acq.shipment_notification

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.shipment_notification_id_seq'::regclass)
receiver FK	`integer`	No		→ actor.org_unit(id)
provider FK	`integer`	No		→ acq.provider(id)
shipper FK	`integer`	No		→ acq.provider(id)
recv_date	`timestamp with time zone`	No	now()
recv_method FK	`text`	No	'EDI'::text	→ acq.invoice_method(code)
process_date	`timestamp with time zone`	Yes
processed_by FK	`integer`	Yes		→ actor.usr(id)
container_code	`text`	No
lading_number	`text`	Yes
note	`text`	Yes

id PK

integer

No

nextval('acq.shipment_notification_id_seq'::regclass)

receiver FK

integer

No

→ actor.org_unit(id)

provider FK

integer

No

→ acq.provider(id)

shipper FK

integer

No

→ acq.provider(id)

recv_date

timestamp with time zone

No

now()

recv_method FK

text

No

'EDI'::text

→ acq.invoice_method(code)

process_date

timestamp with time zone

Yes

processed_by FK

integer

Yes

→ actor.usr(id)

container_code

text

No

lading_number

text

Yes

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
`processed_by`	actor.usr(id)	SET NULL	NO ACTION	No	`shipment_notification_processed_by_fkey`
`provider`	acq.provider(id)	NO ACTION	NO ACTION	No	`shipment_notification_provider_fkey`
`receiver`	actor.org_unit(id)	NO ACTION	NO ACTION	No	`shipment_notification_receiver_fkey`
`recv_method`	acq.invoice_method(code)	NO ACTION	NO ACTION	No	`shipment_notification_recv_method_fkey`
`shipper`	acq.provider(id)	NO ACTION	NO ACTION	No	`shipment_notification_shipper_fkey`

processed_by

actor.usr(id)

SET NULL

NO ACTION

No

shipment_notification_processed_by_fkey

provider

acq.provider(id)

NO ACTION

No

shipment_notification_provider_fkey

receiver

actor.org_unit(id)

NO ACTION

No

shipment_notification_receiver_fkey

recv_method

acq.invoice_method(code)

NO ACTION

No

shipment_notification_recv_method_fkey

shipper

acq.provider(id)

NO ACTION

No

shipment_notification_shipper_fkey

Unique Constraints

container_code_once_per_provider: (provider, container_code)

Indexes

Index Method Definition

Index	Method	Definition
`shipment_notification_pkey` PK	btree	`CREATE UNIQUE INDEX shipment_notification_pkey ON acq.shipment_notification USING btree (id)`
`container_code_once_per_provider` UNIQUE	btree	`CREATE UNIQUE INDEX container_code_once_per_provider ON acq.shipment_notification USING btree (provider, container_code)`
`acq_asn_container_code_idx`	btree	`CREATE INDEX acq_asn_container_code_idx ON acq.shipment_notification USING btree (container_code)`

shipment_notification_pkey PK

btree

CREATE UNIQUE INDEX shipment_notification_pkey ON acq.shipment_notification USING btree (id)

container_code_once_per_provider UNIQUE

btree

CREATE UNIQUE INDEX container_code_once_per_provider ON acq.shipment_notification USING btree (provider, container_code)

acq_asn_container_code_idx

btree

CREATE INDEX acq_asn_container_code_idx ON acq.shipment_notification USING btree (container_code)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.shipment_notification_entry	`shipment_notification`	`id`	`shipment_notification_entry_shipment_notification_fkey`

acq.shipment_notification_entry

shipment_notification

id

shipment_notification_entry_shipment_notification_fkey