Table AD_Tree

Diagram C

PRIMARY KEY
AD_Tree_ID NUMBER (10, 0) NOT NULL

AD_Client_ID NUMBER (10, 0) NOT NULL
AD_Org_ID NUMBER (10, 0) NOT NULL
Created DATE default: SYSDATE NOT NULL
CreatedBy NUMBER (10, 0) NOT NULL
Updated DATE default: SYSDATE NOT NULL
UpdatedBy NUMBER (10, 0) NOT NULL
IsActive CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL
Name NVARCHAR2 (60) NOT NULL
Description NVARCHAR2 (255)
TreeType CHAR (2) NOT NULL
IsAllNodes CHAR (1) default: 'Y' CHECK ( IsAllNodes in ( 'Y' , 'N' )) NOT NULL
Processing CHAR (1)
REFERENCED BY AD_ClientInfo, AD_ClientInfo, AD_ClientInfo, AD_ClientInfo, AD_ClientInfo, AD_ClientInfo, AD_Role, AD_TreeBar, AD_TreeNode, AD_TreeNodeBP, AD_TreeNodeMM, AD_TreeNodePR, C_Element, C_Element, C_Element