DW_DMD_TABLE_COLUMNS
Contains Table Column Information
Details
Module:
Key Columns
COLUMN_NAME, DATASOURCE_CODE, TABLE_NAME
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| DATASOURCE_CODE | VARCHAR2 | 32 | True | Source application code. | |||
| TABLE_NAME | VARCHAR2 | 128 | True | Table name | |||
| COLUMN_NAME | VARCHAR2 | 128 | True | Column name | |||
| COLUMN_DESCRIPTION | VARCHAR2 | 999 | Column Description | ||||
| COLUMN_SEQUENCE | NUMBER | 38 | 0 | Column Sequence | |||
| DATATYPE | VARCHAR2 | 16 | Column data type | ||||
| LENGTH | NUMBER | 38 | 0 | Column length | |||
| SCALE | NUMBER | 38 | 0 | Column scale | |||
| NULLABLE | VARCHAR2 | 16 | Is the column can have NULL value | ||||
| PRIMARY_KEY | VARCHAR2 | 16 | Is the column a primary column | ||||
| COLUMN_TYPE | VARCHAR2 | 64 | Column type | ||||
| CONTAINER_DOMAIN_CODE | VARCHAR2 | 128 | Set of columns explaining the given domain | ||||
| COLUMN_DOMAIN_CODE | VARCHAR2 | 128 | Container domain code which this column refers to | ||||
| AGGREGATION_LOGIC | VARCHAR2 | 999 | Column aggregation logic Default NULL if there is no aggregation logic |