acq.shipment_notification_entry

Cascading Deletes: Deleting rows from this table will cascade to: acq.shipment_notification.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.shipment_notification_entry_id_seq'::regclass)
shipment_notification FK	`integer`	No		→ acq.shipment_notification(id)
lineitem FK	`integer`	Yes		→ acq.lineitem(id)
item_count	`integer`	No

id PK

integer

nextval('acq.shipment_notification_entry_id_seq'::regclass)

shipment_notification FK

integer

lineitem FK

integer

Yes

item_count

integer

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`lineitem`	acq.lineitem(id)	SET NULL	CASCADE	No	`shipment_notification_entry_lineitem_fkey`
`shipment_notification`	acq.shipment_notification(id)	CASCADE	NO ACTION	No	`shipment_notification_entry_shipment_notification_fkey`

lineitem

SET NULL

CASCADE

shipment_notification_entry_lineitem_fkey

shipment_notification

CASCADE

NO ACTION

shipment_notification_entry_shipment_notification_fkey

Index Method Definition

Index	Method	Definition
`shipment_notification_entry_pkey` PK	btree	`CREATE UNIQUE INDEX shipment_notification_entry_pkey ON acq.shipment_notification_entry USING btree (id)`

shipment_notification_entry_pkey PK

btree

CREATE UNIQUE INDEX shipment_notification_entry_pkey ON acq.shipment_notification_entry USING btree (id)