cwf_workflowitemrole

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
workflowitemrole_id serial 10 √ nextval('cwf_workflowitemrole_seq'::regclass)
role_id text 2147483647 √ null
workflowitem_id int4 10 √ null
cwf_workflowitem.workflowitem_id cwf_workflowitemrole_workflowitem_id_fkey R
eperson_id uuid 2147483647 √ null
eperson.uuid cwf_workflowitemrole_eperson_id_fkey R
group_id uuid 2147483647 √ null
epersongroup.uuid cwf_workflowitemrole_group_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
cwf_workflowitemrole_pkey Primary key Asc workflowitemrole_id
cwf_workflowitemrole_item_fk_idx Performance Asc workflowitem_id
cwf_workflowitemrole_item_role_fk_idx Performance Asc/Asc workflowitem_id + role_id
cwf_workflowitemrole_unique Must be unique Asc/Asc/Asc role_id + workflowitem_id + eperson_id

Relationships

Close relationships within degrees of separation