## MD_COLUMNS

Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes

COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | PK | COMMENTS
--- | --- | --- | --- | --- | --- | ---
ID | NUMBER | No | null | 1 | 1 | Primary Key
TABLE_ID_FK | NUMBER | No | null | 2 | null | The table that this column is part of //PARENTFIELD
COLUMN_NAME | VARCHAR2(4000 BYTE) | No | null | 3 | null | The name of the column //OBJECTNAME
COLUMN_ORDER | NUMBER | No | null | 4 | null | The order this appears in the table
COLUMN_TYPE | VARCHAR2(4000 BYTE) | Yes | null | 5 | null | The type of the column
PRECISION | NUMBER | Yes | null | 6 | null | The precision on the column
SCALE | NUMBER | Yes | null | 7 | null | The scale of the column
NULLABLE | CHAR(1 BYTE) | Yes | null | 8 | null | Yes or No. Null signifies NO
DEFAULT_VALUE | VARCHAR2(4000 BYTE) | Yes | null | 9 | null | Default value on the column
NATIVE_SQL | CLOB | Yes | null | 10 | null | The SQL used to create this column at source
NATIVE_KEY | VARCHAR2(4000 BYTE) | Yes | null | 11 | null | Unique identifier for this object at source
DATATYPE_TRANSFORMED_FLAG | CHAR(1 BYTE) | Yes | null | 12 | null | This is set to 'Y' to show if the data type was transformed. This is useful so we don't apply more than 1 datatype transformation to a column
COMMENTS | VARCHAR2(4000 BYTE) | Yes | null | 13 | null | null
SECURITY_GROUP_ID | NUMBER | No | 0 | 14 | null | null
CREATED_BY | VARCHAR2(255 BYTE) | Yes | null | 15 | null | null
CREATED_ON | DATE | No | sysdate | 16 | null | null
LAST_UPDATED_BY | VARCHAR2(255 BYTE) | Yes | null | 17 | null | null
LAST_UPDATED_ON | DATE | Yes | null | 18 | null | null