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