|
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 |
CONTRACTE_DATAFI_DATAINI_CHK |
Check |
DATA_SIGNATURA < DATA_FINAL_CONTRACTE |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
08/05/13 |
null |
null |
null |
null |
2 |
CONTRACTE_DATA_JUG_EQ_UK |
Unique |
null |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
20/04/13 |
SYSTEM |
CONTRACTE_DATA_JUG_EQ_UK |
null |
null |
3 |
CONTRACTE_EQUIP_COMPRADOR_FK |
Foreign_Key |
null |
SYSTEM |
EQUIP |
EQUIP_PK |
NO ACTION |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
16/06/13 |
null |
null |
null |
null |
4 |
CONTRACTE_EQUIP_VENEDOR_FK |
Foreign_Key |
null |
SYSTEM |
EQUIP |
EQUIP_PK |
NO ACTION |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
16/06/13 |
null |
null |
null |
null |
5 |
CONTRACTE_JUGADOR_FK |
Foreign_Key |
null |
SYSTEM |
JUGADOR |
JUGADOR_PK |
NO ACTION |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
16/06/13 |
null |
null |
null |
null |
6 |
CONTRACTE_PK |
Primary_Key |
null |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
USER NAME |
null |
null |
20/04/13 |
SYSTEM |
CONTRACTE_PK |
null |
null |
7 |
CONTRACTE_PRIMERA_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 |
8 |
CONTRACTE_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 |
9 |
SYS_C007088 |
Check |
"CONTRACTE_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
20/04/13 |
null |
null |
null |
null |
10 |
SYS_C007089 |
Check |
"DATA_SIGNATURA" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
20/04/13 |
null |
null |
null |
null |
11 |
SYS_C007090 |
Check |
"JUGADOR_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
20/04/13 |
null |
null |
null |
null |
12 |
SYS_C007091 |
Check |
"EQUIP_COMPRADOR_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
20/04/13 |
null |
null |
null |
null |
13 |
SYS_C007092 |
Check |
"EQUIP_VENEDOR_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
20/04/13 |
null |
null |
null |
null |
14 |
SYS_C007093 |
Check |
"DURADA_CONTRACTE" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
20/04/13 |
null |
null |
null |
null |
15 |
SYS_C007094 |
Check |
"SALARI_BRUT_ANUAL" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
20/04/13 |
null |
null |
null |
null |
16 |
SYS_C007095 |
Check |
"COMPENSACIO_A_EQUIP_VENEDOR" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
20/04/13 |
null |
null |
null |
null |
17 |
SYS_C007096 |
Check |
"VALOR_OPERACIO" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
20/04/13 |
null |
null |
null |
null |
18 |
SYS_C007382 |
Check |
"REPRESENTANT_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
07/05/13 |
null |
null |
null |
null |
19 |
SYS_C007385 |
Check |
"DATA_FINAL_CONTRACTE" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
08/05/13 |
null |
null |
null |
null |
20 |
SYS_C007388 |
Check |
"ULTIM" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
08/05/13 |
null |
null |
null |
null |
21 |
SYS_C007486 |
Check |
"PRIMERA_TEMPORADA_ID" IS NOT NULL |
null |
null |
null |
null |
ENABLED |
NOT DEFERRABLE |
VALIDATED |
GENERATED NAME |
null |
null |
08/06/13 |
null |
null |
null |
null |