picklist

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.picklist_id_seq'::regclass)
lineitem.picklist lineitem_picklist_fkey R
owner int4 10 null
usr.id picklist_owner_fkey R
creator int4 10 null
usr.id picklist_creator_fkey R
editor int4 10 null
usr.id picklist_editor_fkey R
org_unit int4 10 null
org_unit.id picklist_org_unit_fkey R
name text 2147483647 null
create_time timestamptz 35,6 now()
edit_time timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
picklist_pkey Primary key Asc id
acq_picklist_creator_idx Performance Asc creator
acq_picklist_editor_idx Performance Asc editor
acq_picklist_owner_idx Performance Asc owner
name_once_per_owner Must be unique Asc/Asc name + owner

Relationships

Close relationships within degrees of separation