Ontology Table
Column Name | Data Type | Data Type |
|---|---|---|
C_HLEVEL | INT | INT |
C_FULLNAME | VARCHAR2(1500) | VARCHAR(700) |
C_NAME | VARCHAR2(2000) | VARCHAR(2000) |
C_SYNONYM_CD | CHAR(1) | CHAR(1) |
C_VISUALATTRIBUTES | CHAR(3) | CHAR(3) |
C_TOTALNUM | INT | INT |
C_BASECODE | VARCHAR2(50) | VARCHAR(50) |
C_METADATAXML | CLOB | TEXT |
C_FACTTABLECOLUMN | VARCHAR2(50) | VARCHAR(50) |
C_TABLENAME | VARCHAR2(50) | VARCHAR(50) |
C_COLUMNNAME | VARCHAR2(50) | VARCHAR(50) |
C_COLUMNDATATYPE | VARCHAR2(50) | VARCHAR(50) |
C_OPERATOR | VARCHAR2(10) | VARCHAR(10) |
C_DIMCODE | VARCHAR2(700) | VARCHAR(700) |
C_COMMENT | CLOB | TEXT |
C_TOOLTIP | VARCHAR2(900) | VARCHAR(900) |
UPDATE_DATE | DATE | DATETIME |
DOWNLOAD_DATE | DATE | DATETIME |
IMPORT_DATE | DATE | DATETIME |
SOURCESYSTEM_CD | VARCHAR2(50) | VARCHAR(50) |
VALUETYPE_CD | VARCHAR2(50) | VARCHAR(50) |
M_APPLIED_PATH | VARCHAR2(700) | VARCHAR(700) |
M_EXCLUSION_CD | VARCHAR2(25) | VARCHAR(25) |
C_PATH | VARCHAR2(1300) | VARCHAR(700) |
C_SYMBOL | VARCHAR2(200) | VARCHAR(50) |