DW_DMD_TABLES
Contains Warehouse table information
Details
Module:
Key Columns
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 | |||
| TABLE_DESCRIPTION | VARCHAR2 | 999 | Table description | ||||
| TABLE_TYPE | VARCHAR2 | 64 | Table type | ||||
| TABLE_ROLE | VARCHAR2 | 64 | Table role |