acq.claim

↑ acq schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: claim_lineitem_detail_fkey, claim_type_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.claim_id_seq'::regclass)
type FK	`integer`	No		→ acq.claim_type(id)
lineitem_detail FK	`bigint`	No		→ acq.lineitem_detail(id)

id PK

integer

nextval('acq.claim_id_seq'::regclass)

type FK

integer

→ acq.claim_type(id)

lineitem_detail FK

bigint

→ acq.lineitem_detail(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`lineitem_detail`	acq.lineitem_detail(id)	NO ACTION	NO ACTION	DEFERRED	`claim_lineitem_detail_fkey`
`type`	acq.claim_type(id)	NO ACTION	NO ACTION	DEFERRED	`claim_type_fkey`

lineitem_detail

acq.lineitem_detail(id)

NO ACTION

DEFERRED

claim_lineitem_detail_fkey

type

acq.claim_type(id)

NO ACTION

DEFERRED

claim_type_fkey

Indexes

Index Method Definition

Index	Method	Definition
`claim_pkey` PK	btree	`CREATE UNIQUE INDEX claim_pkey ON acq.claim USING btree (id)`
`claim_lid_idx`	btree	`CREATE INDEX claim_lid_idx ON acq.claim USING btree (lineitem_detail)`

claim_pkey PK

btree

CREATE UNIQUE INDEX claim_pkey ON acq.claim USING btree (id)

claim_lid_idx

btree

CREATE INDEX claim_lid_idx ON acq.claim USING btree (lineitem_detail)

Referenced By

The following tables have foreign keys pointing to acq.claim (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.claim_event	`claim`	`id`	`claim_event_claim_fkey`

acq.claim_event

claim

id

claim_event_claim_fkey