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 CONVOCATS_LOCALS_DIFERENTS_CHK Check L1_ID != L2_ID AND L1_ID != L3_ID AND L1_ID != L4_ID AND L1_ID != L5_ID AND L1_ID != L6_ID AND L1_ID != L7_ID AND L1_ID != L8_ID AND L1_ID != L9_ID AND L1_ID != L10_ID AND L1_ID != L11_ID AND L1_ID != L12_ID AND L2_ID != L3_ID AND L2_ID != L4_ID AND L2_ID != L5_ID AND L2_ID != L6_ID AND L2_ID != L7_ID AND L2_ID != L8_ID AND L2_ID != L9_ID AND L2_ID != L10_ID AND L2_ID != L11_ID AND L2_ID != L12_ID AND L3_ID != L4_ID AND L3_ID != L5_ID AND L3_ID != L6_ID AND L3_ID != L7_ID AND L3_ID != L8_ID AND L3_ID != L9_ID AND L3_ID != L10_ID AND L3_ID != L11_ID AND L3_ID != L12_ID AND L4_ID != L5_ID AND L4_ID != L6_ID AND L4_ID != L7_ID AND L4_ID != L8_ID AND L4_ID != L9_ID AND L4_ID != L10_ID AND L4_ID != L11_ID AND L4_ID != L12_ID AND L5_ID != L6_ID AND L5_ID != L7_ID AND L5_ID != L8_ID AND L5_ID != L9_ID AND L5_ID != L10_ID AND L5_ID != L11_ID AND L5_ID != L12_ID AND L6_ID != L7_ID AND L6_ID != L8_ID AND L6_ID != L9_ID AND L6_ID != L10_ID AND L6_ID != L11_ID AND L6_ID != L12_ID AND L7_ID != L8_ID AND L7_ID != L9_ID AND L7_ID != L10_ID AND L7_ID != L11_ID AND L7_ID != L12_ID AND L8_ID != L9_ID AND L8_ID != L10_ID AND L8_ID != L11_ID AND L8_ID != L12_ID AND L9_ID != L10_ID AND L9_ID != L11_ID AND L9_ID != L12_ID AND L10_ID != L11_ID AND L10_ID != L12_ID AND L11_ID != L12_ID null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 21/04/13 null null null null
2 CONVOCATS_VISITA_DIFERENTS_CHK Check V1_ID != V2_ID AND V1_ID != V3_ID AND V1_ID != V4_ID AND V1_ID != V5_ID AND V1_ID != V6_ID AND V1_ID != V7_ID AND V1_ID != V8_ID AND V1_ID != V9_ID AND V1_ID != V10_ID AND V1_ID != V11_ID AND V1_ID != V12_ID AND V2_ID != V3_ID AND V2_ID != V4_ID AND V2_ID != V5_ID AND V2_ID != V6_ID AND V2_ID != V7_ID AND V2_ID != V8_ID AND V2_ID != V9_ID AND V2_ID != V10_ID AND V2_ID != V11_ID AND V2_ID != V12_ID AND V3_ID != V4_ID AND V3_ID != V5_ID AND V3_ID != V6_ID AND V3_ID != V7_ID AND V3_ID != V8_ID AND V3_ID != V9_ID AND V3_ID != V10_ID AND V3_ID != V11_ID AND V3_ID != V12_ID AND V4_ID != V5_ID AND V4_ID != V6_ID AND V4_ID != V7_ID AND V4_ID != V8_ID AND V4_ID != V9_ID AND V4_ID != V10_ID AND V4_ID != V11_ID AND V4_ID != V12_ID AND V5_ID != V6_ID AND V5_ID != V7_ID AND V5_ID != V8_ID AND V5_ID != V9_ID AND V5_ID != V10_ID AND V5_ID != V11_ID AND V5_ID != V12_ID AND V6_ID != V7_ID AND V6_ID != V8_ID AND V6_ID != V9_ID AND V6_ID != V10_ID AND V6_ID != V11_ID AND V6_ID != V12_ID AND V7_ID != V8_ID AND V7_ID != V9_ID AND V7_ID != V10_ID AND V7_ID != V11_ID AND V7_ID != V12_ID AND V8_ID != V9_ID AND V8_ID != V10_ID AND V8_ID != V11_ID AND V8_ID != V12_ID AND V9_ID != V10_ID AND V9_ID != V11_ID AND V9_ID != V12_ID AND V10_ID != V11_ID AND V10_ID != V12_ID AND V11_ID != V12_ID null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 21/04/13 null null null null
3 PARTIT_ARBITRE_AUX1_FK Foreign_Key null SYSTEM ARBITRE ARBITRE_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
4 PARTIT_ARBITRE_AUX2_FK Foreign_Key null SYSTEM ARBITRE ARBITRE_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
5 PARTIT_ARBITRE_AUX3_FK Foreign_Key null SYSTEM ARBITRE ARBITRE_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
6 PARTIT_ARBITRE_P_FK Foreign_Key null SYSTEM ARBITRE ARBITRE_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
7 PARTIT_ARBITRES_DIFERENTS_CHK Check ARBITRE_P_ID != ARBITRE_AUX1_ID AND ARBITRE_P_ID != ARBITRE_AUX2_ID AND ARBITRE_P_ID != ARBITRE_AUX3_ID AND ARBITRE_AUX1_ID != ARBITRE_AUX2_ID AND ARBITRE_AUX1_ID != ARBITRE_AUX3_ID AND ARBITRE_AUX2_ID != ARBITRE_AUX3_ID null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 21/04/13 null null null null
8 PARTIT_COMPETICIO_FK Foreign_Key null SYSTEM COMPETICIO COMPETICIO_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16/06/13 null null null null
9 PARTIT_DATA_HORA_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 21/04/13 SYSTEM PARTIT_DATA_HORA_UK null null
10 PARTIT_EQUIP_LOCAL_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
11 PARTIT_EQUIP_VISITANT_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
12 PARTIT_L1_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
13 PARTIT_L10_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
14 PARTIT_L11_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
15 PARTIT_L12_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
16 PARTIT_L2_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
17 PARTIT_L3_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
18 PARTIT_L4_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
19 PARTIT_L5_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
20 PARTIT_L6_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
21 PARTIT_L7_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
22 PARTIT_L8_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
23 PARTIT_L9_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
24 PARTIT_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 17/04/13 SYSTEM PARTIT_PK null null
25 PARTIT_V1_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
26 PARTIT_V10_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
27 PARTIT_V11_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
28 PARTIT_V12_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
29 PARTIT_V2_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
30 PARTIT_V3_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
31 PARTIT_V4_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
32 PARTIT_V5_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
33 PARTIT_V6_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
34 PARTIT_V7_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
35 PARTIT_V8_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
36 PARTIT_V9_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
37 SYS_C007038 Check "PARTIT_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 17/04/13 null null null null
38 SYS_C007039 Check "DATA_HORA" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 17/04/13 null null null null
39 SYS_C007041 Check "MUNICIPI" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 20/04/13 null null null null
40 SYS_C007042 Check "PAVELLO" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 17/04/13 null null null null
41 SYS_C007043 Check "EQUIP_LOCAL_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 17/04/13 null null null null
42 SYS_C007044 Check "EQUIP_VISITANT_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 17/04/13 null null null null
43 SYS_C007045 Check "COMPETICIO_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 17/04/13 null null null null
44 SYS_C007046 Check "ARBITRE_P_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 17/04/13 null null null null
45 SYS_C007177 Check "L1_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
46 SYS_C007178 Check "L2_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
47 SYS_C007179 Check "L3_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
48 SYS_C007180 Check "L4_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
49 SYS_C007181 Check "L5_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
50 SYS_C007182 Check "L6_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
51 SYS_C007183 Check "L7_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
52 SYS_C007184 Check "L8_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
53 SYS_C007185 Check "L9_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
54 SYS_C007186 Check "L10_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
55 SYS_C007187 Check "L11_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
56 SYS_C007188 Check "L12_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
57 SYS_C007189 Check "V1_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
58 SYS_C007190 Check "V2_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
59 SYS_C007191 Check "V3_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
60 SYS_C007192 Check "V4_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
61 SYS_C007193 Check "V5_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
62 SYS_C007194 Check "V6_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 20/04/13 null null null null
63 SYS_C007195 Check "V7_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
64 SYS_C007196 Check "V8_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
65 SYS_C007197 Check "V9_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
66 SYS_C007198 Check "V10_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
67 SYS_C007199 Check "V11_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
68 SYS_C007200 Check "V12_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 19/04/13 null null null null
69 SYS_C007310 Check "ARBITRE_AUX1_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 21/04/13 null null null null
70 SYS_C007311 Check "ARBITRE_AUX2_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 21/04/13 null null null null