lineitem_note

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.lineitem_note_id_seq'::regclass)
lineitem int4 10 null
lineitem.id lineitem_note_lineitem_fkey C
creator int4 10 null
usr.id lineitem_note_creator_fkey R
editor int4 10 null
usr.id lineitem_note_editor_fkey R
create_time timestamptz 35,6 now()
edit_time timestamptz 35,6 now()
value text 2147483647 null
alert_text int4 10 √ null
lineitem_alert_text.id lineitem_note_alert_text_fkey R
vendor_public bool 1 false

Indexes

Constraint Name Type Sort Column(s)
lineitem_note_pkey Primary key Asc id
li_note_creator_idx Performance Asc creator
li_note_editor_idx Performance Asc editor
li_note_li_idx Performance Asc lineitem

Relationships

Close relationships within degrees of separation