Oracle Columns
The following column names are present in the database. The same column name can be used in different tables.
| column | type | table |
|---|---|---|
| CI_ID | DECIMAL(28) | CI_INFO |
| CI_NAME | VARCHAR2(256 CHAR) | CI_INFO |
| PRODUCT_NAME | VARCHAR2(256 CHAR) | CI_INFO |
| PROP_ID | DECIMAL(28) | PROP_INFO |
| PROP_NAME | VARCHAR2(256 CHAR) | PROP_INFO |
| PROP_TYPE | DECIMAL(1) | PROP_INFO |
| CI_ID | DECIMAL(28) | PROP_INFO |
| XCI_ID | DECIMAL(28) | XCI_INFO |
| XCI_SRCID | VARCHAR2(256 CHAR) | XCI_INFO |
| USER_LOGIN | VARCHAR2(256 CHAR) | XCI_INFO |
| CONS_DATE | DATE | XCI_INFO |
| IMPORT_DATE | DATE | XCI_INFO |
| EXPORT_DATE | DATE | XCI_INFO |
| EXPORT_FLAG | DECIMAL(1) | XCI_INFO |
| XCI_COUNT | DECIMAL(16) | XCI_INFO |
| CI_ID | DECIMAL(28) | XCI_INFO |
| MAGIC_NUMBER | VARCHAR2(2000 CHAR) | XCI_INFO |
| XCI_ID | DECIMAL(28) | XCI_VALUES |
| PROP_ID | DECIMAL(28) | XCI_VALUES |
| NUMBER_VALUE | DECIMAL(28,6) | XCI_VALUES |
| STRING_VALUE | VARCHAR2(2000 CHAR) | XCI_VALUES |
| DATE_VALUE | DATE | XCI_VALUES |