## MD_CONSTRAINT_DETAILS

Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes

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