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_ACTIVITES_1 | Check | organisation_travail IN ('INDIVIDUEL','GROUPE','PROMO') | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011-09-02 09:27:06.0 | null | null | null | null |
FK_ACTIVITES_1 | Foreign_Key | null | AREL | RELS | PK_RELS | CASCADE | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011-09-02 09:44:09.0 | null | null | null | null |
FK_ACTIVITES_2 | Foreign_Key | null | AREL | MATIERES | PK_MATIERES | NO ACTION | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011-09-02 09:44:09.0 | null | null | null | null |
PK_ACTIVITES | Primary_Key | null | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011-09-02 09:27:06.0 | null | PK_ACTIVITES | null | null |
SYS_C004078 | Check | "PF_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_C004079 | Check | "F_MATIERE" 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_C004080 | Check | "ORGANISATION_TRAVAIL" 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 |