Table erp.COMPIERE.AD_WORKFLOW

Generated by SchemaSpy

Related columns Constraint names Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships Dashed lines show implied relationships < n > number of related tables Please support this project

Column Type Size Nulls Auto Default Children Parents AD_WORKFLOW_ID number 10 AD_MENU AD_WORKFLOW_ID ADWORKFLOW_ADMENU AD_PROCESS AD_WORKFLOW_ID Implied Constraint AD_WF_ACTIVITY AD_WORKFLOW_ID Implied Constraint AD_WF_BLOCK AD_WORKFLOW_ID ADWORKFLOW_ADWFBLOCK AD_WF_NODE AD_WORKFLOW_ID ADWORKFLOW_ADWFNODE AD_WF_NODE WORKFLOW_ID ADWORKFLOW_ADWFNODESUBFLOW AD_WF_PROCESS AD_WORKFLOW_ID ADWORKFLOW_ADWFPROCESS AD_WORKFLOW_ACCESS AD_WORKFLOW_ID ADWORKFOW_WORKFLOWACCESS AD_WORKFLOW_TRL AD_WORKFLOW_ID AD_WORKFLOWTRL AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID WORKFLOWCLIENT AD_ORG_ID number 10 AD_ORG AD_ORG_ID WORKFLOWORG ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null HELP nvarchar2 4000  √  null ACCESSLEVEL char 1 AD_WF_NODE_ID number 10  √  null AD_WF_NODE AD_WF_NODE_ID Implied Constraint ENTITYTYPE varchar2 4 'D' DURATIONUNIT char 1  √  null AUTHOR nvarchar2 40 'ComPiere' VERSION number 10 0 VALIDFROM date 7  √  null VALIDTO date 7  √  null PRIORITY number 10  √  null LIMIT number 10  √  null DURATION number 10 0 COST number 22 0 WORKINGTIME number 10 0 WAITINGTIME number 10 0 AD_WF_RESPONSIBLE_ID number 10  √  null AD_WF_RESPONSIBLE AD_WF_RESPONSIBLE_ID ADWFRESPONSIBLE_ADWORKFLOW PUBLISHSTATUS char 1 NULL AD_WORKFLOWPROCESSOR_ID number 10  √  null AD_WORKFLOWPROCESSOR AD_WORKFLOWPROCESSOR_ID ADWORKFLOWPROCESSOR_ADWF VALUE nvarchar2 80 ISDEFAULT char 1 'N' AD_TABLE_ID number 10  √  null AD_TABLE AD_TABLE_ID Implied Constraint VALIDATEWORKFLOW char 1  √  null WORKFLOWTYPE char 1 'G' DOCVALUELOGIC nvarchar2 4000  √  null ISVALID char 1 'N' Table contained 30 rows at Wed Mar 15 18:14 SAST 2006

SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.