acq.claim_event

↑ acq schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: claim_event_claim_fkey, claim_event_creator_fkey, claim_event_type_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('acq.claim_event_id_seq'::regclass)
type FK	`integer`	No		→ acq.claim_event_type(id)
claim FK	`integer`	No	nextval('acq.claim_event_claim_seq'::regclass)	→ acq.claim(id)
event_date	`timestamp with time zone`	No	now()
creator FK	`integer`	No		→ actor.usr(id)
note	`text`	Yes

id PK

bigint

nextval('acq.claim_event_id_seq'::regclass)

type FK

integer

→ acq.claim_event_type(id)

claim FK

integer

nextval('acq.claim_event_claim_seq'::regclass)

→ acq.claim(id)

event_date

timestamp with time zone

now()

creator FK

integer

→ actor.usr(id)

note

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`claim`	acq.claim(id)	NO ACTION	NO ACTION	DEFERRED	`claim_event_claim_fkey`
`creator`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`claim_event_creator_fkey`
`type`	acq.claim_event_type(id)	NO ACTION	NO ACTION	DEFERRED	`claim_event_type_fkey`

claim

acq.claim(id)

NO ACTION

DEFERRED

claim_event_claim_fkey

creator

actor.usr(id)

NO ACTION

DEFERRED

claim_event_creator_fkey

type

acq.claim_event_type(id)

NO ACTION

DEFERRED

claim_event_type_fkey

Indexes

Index Method Definition

Index	Method	Definition
`claim_event_pkey` PK	btree	`CREATE UNIQUE INDEX claim_event_pkey ON acq.claim_event USING btree (id)`
`claim_event_claim_date_idx`	btree	`CREATE INDEX claim_event_claim_date_idx ON acq.claim_event USING btree (claim, event_date)`

claim_event_pkey PK

btree

CREATE UNIQUE INDEX claim_event_pkey ON acq.claim_event USING btree (id)

claim_event_claim_date_idx

btree

CREATE INDEX claim_event_claim_date_idx ON acq.claim_event USING btree (claim, event_date)