COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 1 Primary Key
DELETE_CLAUSE VARCHAR2(4000 BYTE) Yes null 2 null delete option , can be either CASCADE, RESTRICT or NULL
NAME VARCHAR2(4000 BYTE) Yes null 3 null Name of the constraint //OBJECTNAME
CONSTRAINT_TYPE VARCHAR2(4000 BYTE) Yes null 4 null Type of the constraint (e.g. CHECK)
TABLE_ID_FK NUMBER No null 5 null Table on which this constraint exists //PARENTFIELD
REFTABLE_ID_FK NUMBER Yes null 6 null Used in foreign keys - this gives the table that we refer to.
CONSTRAINT_TEXT CLOB Yes null 7 null The text of the constraint
LANGUAGE VARCHAR2(40 BYTE) No null 8 null //PUBLIC
COMMENTS VARCHAR2(4000 BYTE) Yes null 9 null null
SECURITY_GROUP_ID NUMBER No 0 10 null null
CREATED_ON DATE No sysdate 11 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 12 null null
LAST_UPDATED_ON DATE Yes null 13 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 14 null null