ad_wf_activity

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_wf_activity_id numeric 10 null
ad_note.ad_wf_activity_id adwfactivity_adnote R
ad_wf_activityapprover.ad_wf_activity_id adwfactivity_adwfactivityappro C
ad_wf_activityresult.ad_wf_activity_id adwfactivity_adwfactresult C
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
ad_wf_process_id numeric 10 null
ad_wf_process.ad_wf_process_id adwfprocess_adwfactivity C
ad_wf_node_id numeric 10 null
ad_wf_node.ad_wf_node_id adwfnode_adwfactivity C
ad_wf_responsible_id numeric 10 √ null
ad_wf_responsible.ad_wf_responsible_id adwfresponsible_adwfactivity N
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_adwfactivity N
wfstate bpchar 2 null
ad_message_id numeric 10 √ null
ad_message.ad_message_id admessage_adwfactivity R
processing bpchar 1 √ null
processed bpchar 1 'N'::bpchar
textmsg varchar 2000 √ null
ad_workflow_id numeric 10 null
ad_workflow.ad_workflow_id adworkflow_adwfactivity R
ad_table_id numeric 10 null
ad_table.ad_table_id adtable_adwfactivity R
record_id numeric 10 null
priority numeric 10 √ null
endwaittime timestamp 29,6 √ null
datelastalert timestamp 29,6 √ null
dynprioritystart numeric 10 √ null
ad_wf_activity_uu varchar 36 √ NULL::character varying
ad_role_id numeric 10 √ NULL::numeric
ad_role.ad_role_id adrole_adwfactivity C

Indexes

Constraint Name Type Sort Column(s)
ad_wf_activity_pkey Primary key Asc ad_wf_activity_id
ad_wf_activity_item Performance Asc/Asc ad_wf_process_id + ad_wf_node_id
ad_wf_activity_status Performance Asc/Asc wfstate + processed
ad_wf_activity_uu_idx Must be unique Asc ad_wf_activity_uu
ad_wf_activity_who Performance Asc/Asc ad_wf_responsible_id + ad_user_id

Check Constraints

Constraint Name Constraint
ad_wf_activity_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_wf_activity_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation