IBM DB2 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 | VARCHAR(256) | CI_INFO |
| PRODUCT_NAME | VARCHAR(256) | CI_INFO |
| PROP_ID | DECIMAL(28) | PROP_INFO |
| PROP_NAME | VARCHAR(256) | PROP_INFO |
| PROP_TYPE | DECIMAL(1) | PROP_INFO |
| CI_ID | DECIMAL(28) | PROP_INFO |
| XCI_ID | DECIMAL(28) | XCI_INFO |
| XCI_SRCID | VARCHAR(256) | XCI_INFO |
| USER_LOGIN | VARCHAR(256) | XCI_INFO |
| CONS_DATE | TIMESTAMP | XCI_INFO |
| IMPORT_DATE | TIMESTAMP | XCI_INFO |
| EXPORT_DATE | TIMESTAMP | XCI_INFO |
| EXPORT_FLAG | DECIMAL(1) | XCI_INFO |
| XCI_COUNT | DECIMAL(16) | XCI_INFO |
| CI_ID | DECIMAL(28) | XCI_INFO |
| MAGIC_NUMBER | VARCHAR(2000) | XCI_INFO |
| XCI_ID | DECIMAL(28) | XCI_VALUES |
| PROP_ID | DECIMAL(28) | XCI_VALUES |
| NUMBER_VALUE | DECIMAL(28,6) | XCI_VALUES |
| STRING_VALUE | VARCHAR(2000) | XCI_VALUES |
| DATE_VALUE | TIMESTAMP | XCI_VALUES |