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