shipment_notification

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.shipment_notification_id_seq'::regclass)
shipment_notification_entry.shipment_notification shipment_notification_entry_shipment_notification_fkey C
receiver int4 10 null
org_unit.id shipment_notification_receiver_fkey R
provider int4 10 null
provider.id shipment_notification_provider_fkey R
shipper int4 10 null
provider.id shipment_notification_shipper_fkey R
recv_date timestamptz 35,6 now()
recv_method text 2147483647 'EDI'::text
invoice_method.code shipment_notification_recv_method_fkey R
process_date timestamptz 35,6 √ null
processed_by int4 10 √ null
usr.id shipment_notification_processed_by_fkey N
container_code text 2147483647 null
lading_number text 2147483647 √ null
note text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
shipment_notification_pkey Primary key Asc id
acq_asn_container_code_idx Performance Asc container_code
container_code_once_per_provider Must be unique Asc/Asc provider + container_code

Relationships

Close relationships within degrees of separation