| Table AD_Ref_Table |
| PRIMARY KEY | ||
|
AD_Reference_ID
NUMBER (10, 0) NOT NULL | AD_Reference | |
|
AD_Client_ID
NUMBER (10, 0) NOT NULL | AD_Client | |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL | AD_Org | |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) 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 | ||
|
AD_Table_ID
NUMBER (10, 0) NOT NULL | AD_Table | |
|
AD_Key
NUMBER (10, 0) NOT NULL | AD_Column | |
|
AD_Display
NUMBER (10, 0) NOT NULL | AD_Column | |
|
IsValueDisplayed
CHAR (1) default: 'N' CHECK ( IsValueDisplayed in ( 'Y' , 'N' )) NOT NULL | ||
|
EntityType
CHAR (1) default: 'D' NOT NULL | ||
|
WhereClause
NVARCHAR2 (2000) | ||
|
OrderByClause
NVARCHAR2 (2000) | ||
FOREIGN KEY AD_Column_RefTable_Display: AD_Display => AD_Column AD_Column_RefTable_ID: AD_Key => AD_Column AD_Reference_RefTable: AD_Reference_ID => AD_Reference ADD_Table_RefTable: AD_Table_ID => AD_Table Ref_TableClient: AD_Client_ID => AD_Client Ref_TableOrg: AD_Org_ID => AD_Org | ||