|
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 |