CONSTRAINT_NAME | CONSTRAINT_TYPE | SEARCH_CONDITION | R_OWNER | R_TABLE_NAME | R_CONSTRAINT_NAME | DELETE_RULE | STATUS | DEFERRABLE | VALIDATED | GENERATED | BAD | RELY | LAST_CHANGE | INDEX_OWNER | INDEX_NAME | INVALID | VIEW_RELATED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CK_RELS_1 | Check | nouvelle IN('y','n') | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011-09-02 09:27:06.0 | null | null | null | null |
CK_RELS_2 | Check | etat IN('BROUILLON','PUBLIEE','ATTENTE') | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011-09-02 09:27:06.0 | null | null | null | null |
FK_RELS_1 | Foreign_Key | null | AREL | VISIBILITES | PK_VISIBILITES | NO ACTION | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011-09-02 09:44:09.0 | null | null | null | null |
PK_RELS | Primary_Key | null | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011-09-02 09:27:06.0 | null | PK_RELS | null | null |
SYS_C004030 | Check | "P_ID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 2011-09-02 09:27:06.0 | null | null | null | null |
SYS_C004031 | Check | "F_VISIBILITE" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 2011-09-02 09:27:06.0 | null | null | null | null |
SYS_C004032 | Check | "LIBELLE" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 2011-09-02 09:27:06.0 | null | null | null | null |
SYS_C004033 | Check | "RELS_TYPE" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 2011-09-02 09:27:06.0 | null | null | null | null |
SYS_C004034 | Check | "DATE_MAJ" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 2011-09-02 09:27:06.0 | null | null | null | null |
SYS_C004035 | Check | "DATE_CRE" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 2011-09-02 09:27:06.0 | null | null | null | null |
SYS_C004036 | Check | "ETAT" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 2011-09-02 09:27:06.0 | null | null | null | null |