cwf_workflowitem

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
workflowitem_id serial 10 √ nextval('cwf_workflowitem_seq'::regclass)
cwf_claimtask.workflowitem_id cwf_claimtask_workflowitem_id_fkey R
cwf_in_progress_user.workflowitem_id cwf_in_progress_user_workflowitem_id_fkey R
cwf_pooltask.workflowitem_id cwf_pooltask_workflowitem_id_fkey R
cwf_workflowitemrole.workflowitem_id cwf_workflowitemrole_workflowitem_id_fkey R
item_id uuid 2147483647 √ null
item.uuid cwf_workflowitem_item_id_fkey R
collection_id uuid 2147483647 √ null
collection.uuid cwf_workflowitem_collection_id_fkey R
multiple_titles bool 1 √ null
published_before bool 1 √ null
multiple_files bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
cwf_workflowitem_pkey Primary key Asc workflowitem_id
cwf_workflowitem_coll_fk_idx Performance Asc collection_id
cwf_workflowitem_item_fk_idx Performance Asc item_id
cwf_workflowitem_item_id_key Must be unique Asc item_id

Relationships

Close relationships within degrees of separation