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 |