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