ad_wf_node

269 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_wf_node_id numeric 10 null
ad_wf_activity.ad_wf_node_id adwfnode_adwfactivity C
ad_wf_eventaudit.ad_wf_node_id adwfnode_adwfeventaudit R
ad_wf_node_para.ad_wf_node_id adwfnode_adwfnodepara R
ad_wf_node_trl.ad_wf_node_id ad_wfnodetrl C
ad_wf_nodenext.ad_wf_next_id adwfnodenext_adwfnodenext C
ad_wf_nodenext.ad_wf_node_id adwfnode_adwfnodenext C
ad_wizardprocess.ad_wf_node_id adwfnode_adwizardprocess R
ad_workflow.ad_wf_node_id adwfnode_adworkflow R
asp_clientexception.ad_wf_node_id adwfnode_aspclientexception R
pp_order_node.ad_wf_node_id adwfnode_ppordernode R
pp_order_nodenext.ad_wf_next_id adwfnext_ppordernodenext R
pp_order_nodenext.ad_wf_node_id adwfnode_ppordernodenext R
pp_order_workflow.ad_wf_node_id adwfnode_pporderworkflow R
pp_wf_node_asset.ad_wf_node_id adwfnode_ppwfnodeasset R
pp_wf_node_product.ad_wf_node_id adwfnode_ppwfnodeproduct R
ad_client_id numeric 10 null
ad_client.ad_client_id wf_nodeclient R
ad_org_id numeric 10 null
ad_org.ad_org_id wf_nodeorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
help text 2147483647 √ null
ad_workflow_id numeric 10 null
ad_workflow.ad_workflow_id adworkflow_adwfnode C
iscentrallymaintained bpchar 1 'Y'::bpchar
action bpchar 1 null
ad_window_id numeric 10 √ null
ad_window.ad_window_id adwindow_adwfnode R
workflow_id numeric 10 √ null
ad_workflow.ad_workflow_id adworkflow_adwfnodesubflow R
ad_task_id numeric 10 √ null
ad_task.ad_task_id adtask_adwfnode R
ad_process_id numeric 10 √ null
ad_process.ad_process_id adprocess_adwfnode R
ad_form_id numeric 10 √ null
ad_form.ad_form_id adform_adwfnode R
entitytype varchar 40 'U'::character varying
ad_entitytype.entitytype entityt_adwfnode R
xposition numeric 10 0
yposition numeric 10 0
ad_wf_block_id numeric 10 √ null
ad_wf_block.ad_wf_block_id adwfblock_adwfnode N
subflowexecution bpchar 1 √ null
startmode bpchar 1 √ null
finishmode bpchar 1 √ null
limit numeric 10 0
priority numeric 10 √ null
duration numeric 10 0
cost numeric 0 0
workingtime numeric 10 √ null
waitingtime numeric 10 0
ad_wf_responsible_id numeric 10 √ null
ad_wf_responsible.ad_wf_responsible_id adwfresponsible_adwfnode R
ad_image_id numeric 10 √ null
ad_image.ad_image_id adimage_adwfnode R
joinelement bpchar 1 null
splitelement bpchar 1 null
waittime numeric 10 √ null
ad_column_id numeric 10 √ null
ad_column.ad_column_id adcolumn_adwfnode R
attributename varchar 60 √ null
attributevalue varchar 60 √ null
docaction bpchar 2 √ null
value varchar 40 null
dynpriorityunit bpchar 1 √ null
dynprioritychange numeric 0 √ null
emailrecipient bpchar 1 √ null
email varchar 60 √ null
r_mailtext_id numeric 10 √ null
r_mailtext.r_mailtext_id rmailtext_adwfnode R
validto timestamp 29,6 √ null
ismilestone bpchar 1 √ 'N'::bpchar
issubcontracting bpchar 1 √ 'N'::bpchar
unitscycles numeric 0 √ (0)::numeric
movingtime numeric 10 √ null
overlapunits numeric 10 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_adwfnode R
queuingtime numeric 10 √ null
s_resource_id numeric 10 √ null
s_resource.s_resource_id sresource_adwfnode R
setuptime numeric 10 √ null
validfrom timestamp 29,6 √ null
yield numeric 10 √ (100)::numeric
ad_wf_node_uu varchar 36 √ NULL::character varying
ad_ctxhelp_id numeric 10 √ NULL::numeric
ad_ctxhelp.ad_ctxhelp_id adctxhelp_adwfnode R
ad_infowindow_id numeric 10 √ NULL::numeric
ad_infowindow.ad_infowindow_id adinfowindow_adwfnode R
isattacheddocumenttoemail bpchar 1 'Y'::bpchar

Indexes

Constraint Name Type Sort Column(s)
ad_wf_node_pkey Primary key Asc ad_wf_node_id
ad_wf_node_uu_idx Must be unique Asc ad_wf_node_uu
ad_wf_node_workflow Performance Asc ad_workflow_id

Check Constraints

Constraint Name Constraint
ad_wf_node_iscentrallymaintained_check ((iscentrallymaintained = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_wf_node_issubcontracting_check ((issubcontracting = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_wf_node_ismilestone_check ((ismilestone = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_wf_node_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_wf_node_isattacheddocumenttoemail_check ((isattacheddocumenttoemail = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation