COLUMN_NAME |
DATA_TYPE |
NULLABLE |
DATA_DEFAULT |
COLUMN_ID |
PK |
COMMENTS |
ID |
NUMBER |
No |
null |
1 |
1 |
Primary Key |
REF_FLAG |
CHAR(1 BYTE) |
Yes |
'N' |
2 |
null |
"N" or Null signify that this column is the colum that is used in the constraint. A flag of Y signifies that the colum is a referenced column (i.e. part of a foreign key constraint) |
CONSTRAINT_ID_FK |
NUMBER |
No |
null |
3 |
null |
Constraint that this detail belongs to //PARENTFIELD |
COLUMN_ID_FK |
NUMBER |
Yes |
null |
4 |
null |
null |
COLUMN_PORTION |
NUMBER |
Yes |
null |
5 |
null |
The portion of a column this detail belongs (e.g. for constrints on substrings) |
CONSTRAINT_TEXT |
CLOB |
Yes |
null |
6 |
null |
The text of the constraint |
DETAIL_ORDER |
NUMBER |
No |
null |
7 |
null |
null |
SECURITY_GROUP_ID |
NUMBER |
No |
0 |
8 |
null |
null |
CREATED_ON |
DATE |
No |
sysdate |
9 |
null |
null |
CREATED_BY |
VARCHAR2(255 BYTE) |
Yes |
null |
10 |
null |
null |
LAST_UPDATED_ON |
DATE |
Yes |
null |
11 |
null |
null |
LAST_UPDATED_BY |
VARCHAR2(255 BYTE) |
Yes |
null |
12 |
null |
null |