purchase_order

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.purchase_order_id_seq'::regclass)
edi_message.purchase_order edi_message_purchase_order_fkey R
invoice_entry.purchase_order invoice_entry_purchase_order_fkey N
invoice_item.purchase_order invoice_item_purchase_order_fkey N
lineitem.purchase_order lineitem_purchase_order_fkey R
po_item.purchase_order po_item_purchase_order_fkey N
po_note.purchase_order po_note_purchase_order_fkey R
owner int4 10 null
usr.id purchase_order_owner_fkey R
creator int4 10 null
usr.id purchase_order_creator_fkey R
editor int4 10 null
usr.id purchase_order_editor_fkey R
ordering_agency int4 10 null
org_unit.id purchase_order_ordering_agency_fkey R
create_time timestamptz 35,6 now()
edit_time timestamptz 35,6 now()
provider int4 10 null
provider.id purchase_order_provider_fkey R
state text 2147483647 'new'::text
order_date timestamptz 35,6 √ null
name text 2147483647 null
cancel_reason int4 10 √ null
cancel_reason.id purchase_order_cancel_reason_fkey R
prepayment_required bool 1 false

Indexes

Constraint Name Type Sort Column(s)
purchase_order_pkey Primary key Asc id
acq_po_org_name_order_date_idx Performance Asc/Asc/Asc ordering_agency + name + order_date
po_creator_idx Performance Asc creator
po_editor_idx Performance Asc editor
po_owner_idx Performance Asc owner
po_provider_idx Performance Asc provider
po_state_idx Performance Asc state

Check Constraints

Constraint Name Constraint
valid_po_state ((state = ANY (ARRAY['new'::text, 'pending'::text, 'on-order'::text, 'received'::text, 'cancelled'::text])))

Relationships

Close relationships within degrees of separation