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
1 COMPETICIO_AMBIT_FK Foreign_Key null SYSTEM AMBIT AMBIT_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
2 COMPETICIO_AMBIT_N_ARB_CHK Check (AMBIT_ID = 1 AND N_ARBITRES = 3) OR (AMBIT_ID = 2 AND N_ARBITRES = 4) null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 18/04/13 null null null null
3 COMPETICIO_CATEG_FACTOR_P_CHK Check (CATEGORIA_ID = 1 AND FACTOR_P = 10) OR (CATEGORIA_ID = 2 AND FACTOR_P = 8) null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 20/04/13 null null null null
4 COMPETICIO_CATEGORIA_FK Foreign_Key null SYSTEM CATEGORIA CATEGORIA_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
5 COMPETICIO_CONTINENT_FK Foreign_Key null SYSTEM CONTINENT CONTINENT_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
6 COMPETICIO_GENERE_FK Foreign_Key null SYSTEM GENERE GENERE_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
7 COMPETICIO_MODALITAT_FK Foreign_Key null SYSTEM MODALITAT MODALITAT_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
8 COMPETICIO_PAIS_CONTINENT_CHK Check PAIS_ID != null OR CONTINENT_ID != null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 18/04/13 null null null null
9 COMPETICIO_PAIS_FK Foreign_Key null SYSTEM PAIS PAIS_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
10 COMPETICIO_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 18/04/13 SYSTEM COMPETICIO_PK null null
11 COMPETICIO_TEMPORADA_FK Foreign_Key null SYSTEM TEMPORADA TEMPORADA_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
12 COMPETICIO_TEMPORADA_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 08/06/13 SYSTEM COMPETICIO_TEMPORADA_UK null null
13 COMPETICIO_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 19/04/13 SYSTEM COMPETICIO_UK null null
14 SYS_C007163 Check "COMPETICIO_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 18/04/13 null null null null
15 SYS_C007164 Check "COMPETICIO" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 18/04/13 null null null null
16 SYS_C007165 Check "AMBIT_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 18/04/13 null null null null
17 SYS_C007166 Check "GENERE_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 18/04/13 null null null null
18 SYS_C007167 Check "MODALITAT_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 18/04/13 null null null null
19 SYS_C007168 Check "N_ARBITRES" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 18/04/13 null null null null
20 SYS_C007169 Check "CATEGORIA_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 18/04/13 null null null null
21 SYS_C007171 Check "FACTOR_P" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 18/04/13 null null null null