po_note

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.po_note_id_seq'::regclass)
purchase_order int4 10 null
purchase_order.id po_note_purchase_order_fkey R
creator int4 10 null
usr.id po_note_creator_fkey R
editor int4 10 null
usr.id po_note_editor_fkey R
create_time timestamptz 35,6 now()
edit_time timestamptz 35,6 now()
value text 2147483647 null
vendor_public bool 1 false

Indexes

Constraint Name Type Sort Column(s)
po_note_pkey Primary key Asc id
acq_po_note_creator_idx Performance Asc creator
acq_po_note_editor_idx Performance Asc editor
po_note_po_idx Performance Asc purchase_order

Relationships

Close relationships within degrees of separation