Table almasdd.COMPIERE.AD_ROLE

Generated by SchemaSpy

Implied relationships 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_ROLE_ID number 10 AD_ALERTRECIPIENT AD_ROLE_ID ADROLE_ADALTERTRECIPIENT AD_COLUMN_ACCESS AD_ROLE_ID ADROLE_ADCOLUMNACCESS AD_FORM_ACCESS AD_ROLE_ID ADROLE_ADFORMACCESS AD_PROCESS_ACCESS AD_ROLE_ID ADROLE_ADPROCESSACCESS AD_RECORD_ACCESS AD_ROLE_ID ADROLE_ARDECORDACCESS AD_ROLE_ORGACCESS AD_ROLE_ID ADROLE_ADROLEORGACCESS AD_SCHEDULERRECIPIENT AD_ROLE_ID ADROLE_ADSCHEDULERRECIPIENT AD_TABLE_ACCESS AD_ROLE_ID ADROLE_ADTABLEACCESS AD_TASK_ACCESS AD_ROLE_ID ADROLE_ADTASKACCESS AD_USERDEF_WIN AD_ROLE_ID ADROLE_ADUSERDEFWIN AD_USER_ROLES AD_ROLE_ID ADROLE_ADUSERROLES AD_WF_RESPONSIBLE AD_ROLE_ID ADROLE_ADWFRESPONSIBLE AD_WINDOW_ACCESS AD_ROLE_ID ADROLE_ADWINDOWACCESS AD_WORKFLOW_ACCESS AD_ROLE_ID ADROLE_ADWORKFLOWACCESS PA_GOAL AD_ROLE_ID Implied Constraint R_REQUEST AD_ROLE_ID ADROLE_RREQUEST R_REQUESTACTION AD_ROLE_ID ADROLE_RREQUESTACTION R_REQUEST_V AD_ROLE_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID AD_ROLECLIENT AD_ORG_ID number 10 AD_ORG AD_ORG_ID AD_ROLEORG ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now NAME nvarchar2 120 UPDATEDBY number 10 DESCRIPTION nvarchar2 510  √  null USERLEVEL char 3 ' O' C_CURRENCY_ID number 10  √  null C_CURRENCY C_CURRENCY_ID C_CURRENCY_AD_ROLE AMTAPPROVAL number 22  √  0 AD_TREE_MENU_ID number 10  √  null AD_TREE AD_TREE_ID ADTREE_ADROLE ISMANUAL char 1 'N' ISSHOWACCT char 1 'Y' ISPERSONALLOCK char 1 'N' ISPERSONALACCESS char 1 'N' ISCANEXPORT char 1 'Y' ISCANREPORT char 1 'Y' SUPERVISOR_ID number 10  √  null AD_USER AD_USER_ID ADUSERSUPERVISOR_ADROLE ISCANAPPROVEOWNDOC char 1 'Y' ISACCESSALLORGS char 1 'N' ISCHANGELOG char 1 'N' PREFERENCETYPE char 1 'C' OVERWRITEPRICELIMIT char 1 'N' ISUSEUSERORGACCESS char 1 'N' AD_TREE_ORG_ID number 10  √  null CONFIRMQUERYRECORDS number 10 0 MAXQUERYRECORDS number 10 0 CONNECTIONPROFILE char 1  √  null Table contained 3 rows at ‰Î 3 07 12:14 JST 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.