|
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 |
FEDERACIO_ID_FED_NUMERO_FED_UK |
Unique |
null |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
03/05/13 |
SYSTEM |
FEDERACIO_ID_FED_NUMERO_FED_UK |
null |
null |
2 |
JUGADOR_ACTIVITAT_FK |
Foreign_Key |
null |
SYSTEM |
ACTIVITAT |
ACTIVITAT_PK |
NO ACTION |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
16/06/13 |
null |
null |
null |
null |
3 |
JUGADOR_ESTAT_FK |
Foreign_Key |
null |
SYSTEM |
ESTAT |
ESTAT_PK |
NO ACTION |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
16/06/13 |
null |
null |
null |
null |
4 |
JUGADOR_FEDERACIO_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 |
5 |
JUGADOR_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 |
6 |
JUGADOR_NACIONALITAT_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 |
7 |
JUGADOR_PK |
Primary_Key |
null |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
16/04/13 |
SYSTEM |
JUGADOR_PK |
null |
null |
8 |
JUGADOR_POSICIO_FK |
Foreign_Key |
null |
SYSTEM |
POSICIO |
POSICIO_PK |
NO ACTION |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
16/06/13 |
null |
null |
null |
null |
9 |
JUGADOR_REPRESENTANT_FK |
Foreign_Key |
null |
SYSTEM |
REPRESENTANT |
REPRESENTANT_PK |
NO ACTION |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
16/06/13 |
null |
null |
null |
null |
10 |
JUGADOR_SUB_ESTAT_FK |
Foreign_Key |
null |
SYSTEM |
SUB_ESTAT |
SUB_ESTAT_PK |
NO ACTION |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
16/06/13 |
null |
null |
null |
null |
11 |
SYS_C007005 |
Check |
"JUGADOR_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
16/04/13 |
null |
null |
null |
null |
12 |
SYS_C007006 |
Check |
"NACIONALITAT_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
16/04/13 |
null |
null |
null |
null |
13 |
SYS_C007008 |
Check |
"FEDERACIO_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
16/04/13 |
null |
null |
null |
null |
14 |
SYS_C007009 |
Check |
"NUMERO_FEDERAT" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
16/04/13 |
null |
null |
null |
null |
15 |
SYS_C007012 |
Check |
"NOM" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
16/04/13 |
null |
null |
null |
null |
16 |
SYS_C007013 |
Check |
"DATA_NAIXEMENT" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
16/04/13 |
null |
null |
null |
null |
17 |
SYS_C007014 |
Check |
"ALÇADA" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
17/04/13 |
null |
null |
null |
null |
18 |
SYS_C007015 |
Check |
"PES" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
17/04/13 |
null |
null |
null |
null |
19 |
SYS_C007016 |
Check |
"POSICIO_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
17/04/13 |
null |
null |
null |
null |
20 |
SYS_C007017 |
Check |
"ACTIVITAT_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
17/04/13 |
null |
null |
null |
null |
21 |
SYS_C007018 |
Check |
"ESTAT_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
17/04/13 |
null |
null |
null |
null |
22 |
SYS_C007019 |
Check |
"SUB_ESTAT_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
17/04/13 |
null |
null |
null |
null |
23 |
SYS_C007281 |
Check |
"REPRESENTANT_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
19/04/13 |
null |
null |
null |
null |
24 |
SYS_C007342 |
Check |
"GENERE_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
21/04/13 |
null |
null |
null |
null |
25 |
SYS_C007379 |
Check |
"MODALITAT_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
03/05/13 |
null |
null |
null |
null |