ad_wf_process

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_wf_process_id numeric 10 null
ad_wf_activity.ad_wf_process_id adwfprocess_adwfactivity C
ad_wf_eventaudit.ad_wf_process_id adwfprocess_adwfeventaudit R
ad_wf_process.ad_wf_process_id adwfprocess_adwfprocess R
ad_wf_processdata.ad_wf_process_id adwfproccess_adwfprocessdata C
ad_wf_process.ad_wf_process_id adwfprocess_adwfprocess R
ad_client_id numeric 10 null
ad_client.ad_client_id wf_instanceclient R
ad_org_id numeric 10 null
ad_org.ad_org_id wf_instanceorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
ad_workflow_id numeric 10 null
ad_workflow.ad_workflow_id adworkflow_adwfprocess C
ad_wf_responsible_id numeric 10 null
ad_wf_responsible.ad_wf_responsible_id adwfresponsible_adwfprocess R
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_adwfprocess R
wfstate bpchar 2 null
ad_message_id numeric 10 √ null
ad_message.ad_message_id admessage_adwfprocess R
processing bpchar 1 √ null
processed bpchar 1 'N'::bpchar
textmsg varchar 2000 √ null
ad_table_id numeric 10 null
ad_table.ad_table_id adtable_adwfprocess R
record_id numeric 10 null
priority numeric 10 √ null
ad_wf_process_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_wf_process_pkey Primary key Asc ad_wf_process_id
ad_wf_process_uu_idx Must be unique Asc ad_wf_process_uu
ad_wf_process_workflow Performance Asc ad_workflow_id

Check Constraints

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

Relationships

Close relationships within degrees of separation