0% found this document useful (0 votes)

5 views167 pages

ER Diagram of Foreign Key Relationships

The document is an entity relationship diagram (ERD) that shows the relationships between 49 entities related to a system for monitoring indicators. The ERD includes the entity names, primary keys, foreign keys, and relationships between entities. Key entities include sime_indicadores, sime_xls, sime_bdapp, sec_users, sec_groups, sec_apps, and upload_archivos.

Uploaded by

Abel Salazar

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

5 views167 pages

ER Diagram of Foreign Key Relationships

Uploaded by

Abel Salazar

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

Diagram

ID
1

Foreign Key

Name
E_R_SIME

ID
2
5
FK Column
id

Foreign Key

14
16
FK Column
id
Foreign Key

ID
17
19
FK Column
id

Foreign Key

ID
20
22
FK Column
id

Foreign Key

ID
23
25
FK Column
id
ID

Reference
7

Model ID

Name
Reference
7
Name
Reference
7

Model ID

Name

Reference
7

Model ID

Name

Reference
7

Model ID

Name

Reference
7

Model ID

Name

Reference
7

Model ID

26
29
FK Column
Name
group_id
Foreign Key

Name

ID
Model ID
11
13
FK Column
Name
userid
ID

ERDiagram

Model ID

8
10
FK Column
Name
bd_cargadosid
Foreign Key

Type

Model ID

31
33
FK Column
Name
app_name

Name
groups_apps_ibfk_1
Reference
30
Name
groups_apps_ibfk_2
Reference
34

Foreign Key

ID
35
38
FK Column
login

Foreign Key

ID
47
49
FK Column
id

Foreign Key

ID
50
52
FK Column
id

Foreign Key

ID
53
55
FK Column
id
ID
56
58
FK Column
id

Foreign Key

ID
59
61
FK Column
id2

Foreign Key

ID
62
64
FK Column
id2

Foreign Key

Name

ID
Model ID
40
41
FK Column
Name
group_id

42
45
FK Column
id
Foreign Key

Model ID

ID
65
67
FK Column

Name
users_groups_ibfk_1
Reference
39
Name
users_groups_ibfk_2
Reference
30

Model ID

Name

Reference
46

Model ID

Name

Reference
46

Model ID

Name

Reference
46

Model ID

Name

Reference
46

Model ID

Name

Reference
46

Model ID

Name

Reference
46

Model ID

Name

Reference
46

Model ID

Name

Reference

id2
Foreign Key

ID
68
70
FK Column
id2

Foreign Key

ID
71
73
FK Column
id2

Foreign Key

ID
74
76
FK Column
id2

Foreign Key

ID
83
85
FK Column
cod

Foreign Key

ID
86
88
FK Column
cem

Foreign Key

Model ID

Name

Reference
46

Model ID

Name

Reference
46

Name
Reference
46

Model ID

Name

Reference
46

Model ID

Name

Reference
46

Model ID

Name

Reference
89
Name
Reference
89

Model ID

92
93
FK Column
Name
cod_cem
Foreign Key

Reference
46

ID
Model ID
90
91
FK Column
Name
cod_cem
ID

Name

ID
Model ID
77
79
FK Column
Name
codigo

80
82
FK Column
id
Foreign Key

Model ID

Name
Reference
89
Name

94
95
FK Column
cem
Foreign Key

ID
96
97
FK Column
cem

Foreign Key

Model ID

Name

Reference
89

Foreign Key

Reference
46

Model ID

ID
Model ID
110
111
FK Column
Name
codigo_indicador
ID

Reference
89
Name
Reference
7
Name
Reference
46

Model ID

Name
Reference
46

Model ID

ID
117
Column

Name

Model ID

115
116
FK Column
Name
codigo_centro
Entity

101

Name

112
114
FK Column
Name
codigo_indicador
Foreign Key

Reference

Name

108
109
FK Column
Name
id_progra
Foreign Key

Name

Model ID

105
107
FK Column
Name
codigo_centro
Foreign Key

Reference
89

ID
Model ID
98
100
FK Column
Name
hc-key

102
104
FK Column
id2
Foreign Key

Name

Model ID
118
ID
120

Name
Reference
89
Name
tbl_otros_indicadores
Model ID
120

121
122
Entity

ID
123
Column

121
122
Model ID

124
ID
125
126
127
128

Entity

ID
129
Column

Model ID
130
ID

ID
134
Column

Model ID
135

tbl_anios

Model ID
139

Name
tbl_alertas

ID
113
Column

Model ID
136
137

140
141
142
143
144
145
Entity

Name

ID
138
Column

Model ID
131
132
133

136
137
Entity

Name
tbl_meses

131
132
133
Entity

Name
tbl_linea_piepag
Model ID
125
126
127
128

140
141
142
143
144
145
Model ID

146
ID
147
148
149
150
151
152
153
154
155
156
157

Model ID

Name
metas_programadas
Model ID
147
148
149
150
151
152
153
154
155
156
157

158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205

206
207
208
209
210
211
212
213
214
215
216
217
Index

206
207
208
209
210
211
212
213
214
215
216
217
ID

218
Entity

ID
106
Column

218
Model ID

219
ID
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249

Model ID

Name
metas_ejecutadas
Model ID
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249

250
251
252
253
254
255
256
257
258
259
260
261
Entity

ID
103
Column

250
251
252
253
254
255
256
257
258
259
260
261
Model ID

262
ID
263
264
265

Entity

ID
99
Column

Model ID
266

ID
87
Column

tbl_dpto_iso

Model ID
270

Name
tbl_centros

Index

Model ID
271
272
273
274
89
275
276
277
278
279
280
281
282

ID
283

Model ID
267
268
269
101

271
272
273
274
89
275
276
277
278
279
280
281
282

Entity

Name

ID
267
268
269
101

Entity

Name
metodo_analisis_informacion
Model ID
263
264
265

Model ID
283

Model ID

Name

75
Column

284
ID
285
286
287

Entity

ID
78
Column

Model ID
288
ID
289
290

Entity

ID
81
Column

Model ID
291
ID
292
293
294

Entity

ID
84
Column

ID
69
Column

295

Model ID
298
ID

Model ID
302
ID

ID
63
Column

Model ID
306
ID
307
308
309

Entity

ID
60

Name

Model ID
310

Model ID
296
297

303
304
305
Entity

Name
tipo_indicador
Model ID
292
293
294

ID
66
Column

tipo_servicios
Model ID
289
290

tbl_reportes

299
300
301
Entity

Name

Model ID

296
297
Entity

unidad_medida
Model ID
285
286
287

Name
responsables_mediciones
Model ID
299
300
301
Name
responsable_intervencion
Model ID
303
304
305
Name
para_que_se_aplicara
Model ID
307
308
309
Name
metodo_recopilacion

Column

ID
311
312
313

Entity

ID
57
Column

311
312
313
Model ID

314
ID
315
316
317

Entity

ID
54
Column

318
ID

ID
51
Column

322

ID
43
Column

Model ID
326
ID

Model ID
330
ID

ID
72
Column

Name
formatos_difusion
Model ID
327
328
329
Name
enunciado_resultados
Model ID
331
332
333

Model ID
334

Name
circulacion

ID
335
336
337

Entity

Model ID
323
324
325

331
332
333
Entity

Name
frecuencia

327
328
329
Entity

fuente_datos
Model ID
319
320
321

ID
48
Column

Name

Model ID

323
324
325
Entity

Name
jerarquia_objetivos
Model ID
315
316
317

Model ID

319
320
321
Entity

Model ID

Model ID
335
336
337

Model ID

Name

44
Column

338
ID
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
46
358
359
360

Index

ID
361

Entity

ID
36
Column

Model ID
362
ID
363
364

Entity

ID
27
Column

Model ID
365
ID
366
367
368
369
370
371
372
373

Entity

ID
28

sime_indicadores
Model ID
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
46
358
359
360
Model ID
361
Name
sec_users_groups
Model ID
363
364
Name
sec_groups_apps
Model ID
366
367
368
369
370
371
372
373

Model ID
374

Name
sec_groups

Column

ID
30
375

Entity

ID
32
Column

30
375
Model ID

376

ID
37
Column

sec_apps

Model ID
379

sec_users

Model ID
387
ID

ID
3

Model ID
39
380
381
382
383
384
385
386

388
389
390
391
392
393
394
395
Entity

Name

ID
12
Column

Model ID
34
377
378

39
380
381
382
383
384
385
386
Entity

Name

ID
34
377
378

Entity

Model ID

Name
upload_archivos
Model ID
388
389
390
391
392
393
394
395

Model ID
396

Column

Name
sime_xls

ID
397
398
399
400
401
402
403
404
405
406

Model ID
397
398
399
400
401
402
403
404
405
406

407
408
409
410
411
412
413
Entity

ID
24
Column

407
408
409
410
411
412
413
Model ID

414

Name
sime_bdapp

ID
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451

Model ID
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451

452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499

500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547

548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595

596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643

644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691

692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
Index

692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
ID

708
709
Entity

ID
15
Column

Model ID
708
709

Model ID
710

Name
sime_chat

ID
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735

Model ID
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735

736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783

784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
Entity

ID
9

784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
Model ID

804
Column

Name
sime_cai

ID
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828

Model ID
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828

829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876

877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924

925
926
927
Entity

ID
21
Column

925
926
927
Model ID

928
ID
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969

Name
sime_casos_spss
Model ID
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969

970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017

1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065

1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113

1114
1115
1116
1117
Index

1114
1115
1116
1117
ID

1118
1119
1120
Entity

ID
18
Column

1118
1119
1120
Model ID

1121
ID
1122
1123
1124
1125
1126
1127
1128
1129
1130

Index

ID
1131
1132
1133
1134
1135
1136
1137

Entity

ID
4

Model ID
1138

Column

ID
7
1139
1140
1141
1142
1143
1144

Model ID

Name
sime_atenciones_spss2
Model ID
1122
1123
1124
1125
1126
1127
1128
1129
1130
Model ID
1131
1132
1133
1134
1135
1136
1137
Name
bd_cargados
Model ID
7
1139
1140
1141
1142
1143
1144

Description

Parent Model

Delete ?
No

Table
3

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Table
9

Table
12

Table
15

Table
18

Table
21

Table
24

Table
27

Reference

Table
36

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Table
36

Table
43

Table
48

Table
51

Table
54

Table
57

Table
60

Table
63

Table
66

Reference

Table
69

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Table
72

Table
75

Table
78

Table
81

Table
84

Table
21

Table
24

Table
3

Table

Table
37

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Reference

Phrase1

Table
87

Table
103

Table
106

Table
113

Reference

Discriminator Column

Version Column

Name

Type
int8

Schema
public
Length
0

codigo
denominacion

varchar
varchar

Discriminator Column
Name
cod
linea1
linea2
linea3
Discriminator Column
Name
nombre
mes2
mes
Discriminator Column
Name
anio
id
Discriminator Column
Name
categoria
inferior
superior
calificacion
color
observacion

Version Column
Type
int8
varchar
varchar
varchar
Version Column
Type
varchar
varchar
int2
Version Column
Type
numeric
int4
Version Column
Type
varchar
numeric
numeric
varchar
varchar
varchar

Discriminator Column

Version Column

Name

Type

id
anio
codigo_indicador
codigo_centro
meta_ene
meta_feb
meta_mar
meta_abr
meta_may
meta_jun
meta_jul

int8
varchar
int8
varchar
numeric
numeric
numeric
numeric
numeric
numeric
numeric

1
120
Schema
public
Length
0
255
255
255
Schema
public
Length
60
2
0
Schema
public
Length
4
0
Schema
public
Length
1
7
7
100
100
2147483647
Schema
public
Length
0
4
0
18
10
10
10
10
10
10
10

meta_ago
meta_set
meta_oct
meta_nov
meta_dic
estado
ubigeo
departamento
provincia
distrito
cem
r1_ene
r1_feb
r1_mar
r1_abr
r1_may
r1_jun
r1_jul
r1_ago
r1_set
r1_oct
r1_nov
r1_dic
r2_ene
r2_feb
r2_mar
r2_abr
r2_may
r2_jun
r2_jul
r2_ago
r2_set
r2_oct
r2_nov
r2_dic
r3_ene
r3_feb
r3_mar
r3_abr
r3_may
r3_jun
r3_jul
r3_ago
r3_set
r3_oct
r3_nov
r3_dic
f_ene

numeric
numeric
numeric
numeric
numeric
varchar
varchar
varchar
varchar
varchar
varchar
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric

10
10
10
10
10
1
10
120
120
120
120
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10

f_feb
f_mar
f_abr
f_may
f_jun
f_jul
f_ago
f_set
f_oct
f_nov
f_dic
meta_total
Name
indice_anio_indicador
Discriminator Column
Name
id
anio
codigo_indicador
codigo_centro
meta_ene
meta_feb
meta_mar
meta_abr
meta_may
meta_jun
meta_jul
meta_ago
meta_set
meta_oct
meta_nov
meta_dic
estado
id_progra
eje_ene_den
eje_ene_num
eje_feb_den
eje_feb_num
eje_mar_den
eje_mar_num
eje_abr_den
eje_abr_num
eje_may_den
eje_may_num
eje_jun_den
eje_jun_num

numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
Description

Version Column
Type
int8
varchar
int8
varchar
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
varchar
int8
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric

10
10
10
10
10
10
10
10
10
10
10
10
Tablespace

Schema
public
Length
0
4
0
18
10
10
10
10
10
10
10
10
10
10
10
10
1
0
10
10
10
10
10
10
10
10
10
10
10
10

eje_jul_den
eje_jul_num
eje_ago_den
eje_ago_num
eje_set_den
eje_set_num
eje_oct_den
eje_oct_num
eje_nov_den
eje_nov_num
eje_dic_den
eje_dic_num

numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric

Discriminator Column
Name
metodo_analisis_informacion
estado
id2
Discriminator Column
Name
cod_depar
nom_dep
hc_key2
hc_key
Discriminator Column
Name
cem
dpto
prov
dist
cod_aten
ubigeo_inei
direccion_ubicacion
fecha_creacion
latitud
altitud
descripcion
reporte
hc-key
Name
icem001
Discriminator Column

Version Column
Type
varchar
varchar
int8
Version Column
Type
varchar
varchar
varchar
varchar
Version Column
Type
varchar
varchar
varchar
varchar
varchar
varchar
varchar
date
numeric
numeric
text
varchar
varchar
Description

Version Column

10
10
10
10
10
10
10
10
10
10
10
10
Schema
public
Length
255
255
0
Schema
public
Length
4
120
5
5
Schema
public
Length
100
39
75
168
18
18
255
0
30
30
0
1
5
Tablespace

Schema

Name
unidad_medida
estado
id2

Type
varchar
varchar
int8

Discriminator Column

Version Column

Name

Type

codigo
descripcion

int8
varchar

Discriminator Column
Name
tipo_indicador
id
estado
Discriminator Column
Name
cod
descripcion
Discriminator Column
Name
responsables_medicion
estado
id2
Discriminator Column
Name
responsable_intervencion
estado
id2
Discriminator Column
Name
para_que_se_aplicara
estado
id2
Discriminator Column

Version Column
Type
varchar
int8
varchar
Version Column
Type
int8
varchar
Version Column
Type
varchar
varchar
int8
Version Column
Type
varchar
varchar
int8
Version Column
Type
varchar
varchar
int8
Version Column

public
Length
255
1
0
Schema
public
Length
0
50
Schema
public
Length
100
0
1
Schema
public
Length
0
140
Schema
public
Length
255
1
0
Schema
public
Length
255
1
0
Schema
public
Length
255
255
0
Schema
public

Name
metodo_recopilacio
estado
id2
Discriminator Column
Name
jerarquia_objetivos
id
estado
Discriminator Column
Name
fuente_dato
estado
id
Discriminator Column
Name
frecuencia
estado
id
Discriminator Column
Name
formatos_difusion
id
estado
Discriminator Column
Name
enunciado_resultados
id
estado
Discriminator Column
Name
circulacion
estado
id2
Discriminator Column

Type
varchar
varchar
int8
Version Column
Type
varchar
int8
varchar
Version Column
Type
varchar
varchar
int8
Version Column
Type
varchar
varchar
int8
Version Column
Type
varchar
int8
varchar
Version Column
Type
int8
int8
varchar
Version Column
Type
varchar
varchar
int8
Version Column

Length
255
1
0
Schema
public
Length
120
0
1
Schema
public
Length
100
1
0
Schema
public
Length
255
1
0
Schema
public
Length
255
0
255
Schema
public
Length
0
0
1
Schema
public
Length
255
1
0
Schema

Name
anio
jerarquia_objetivos
enunciado_resultados
codigo
indicador
unidad_medida
tipo_indicador
metas_nacional
estandar
explicacion_estandar
fuente_datos
metodo_recopilacion
responsable_intervencion
responsables_medicion
metodo_analisis_informacion
frecuencia
para_que_se_aplicara
formatos_difusion
circulacion
id
tipo_servicio
reporte
sime_indicadoresid
Name
indice_anio
Discriminator Column
Name
login
group_id

Type
varchar
numeric
numeric
varchar
varchar
numeric
numeric
numeric
varchar
text
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
numeric
int8
varchar
varchar
int8
Description

Version Column
Type
varchar
int4

Discriminator Column

Version Column

Name

Type

group_id
app_name
priv_access
priv_insert
priv_delete
priv_update
priv_export
priv_print
Discriminator Column

int4
varchar
varchar
varchar
varchar
varchar
varchar
varchar
Version Column

public
Length
4
2
2
10
255
2
2
15
100
0
2
2
2
2
2
2
2
2
2
0
1
10
0
Tablespace

Schema
public
Length
32
0
Schema
public
Length
0
128
1
1
1
1
1
1
Schema
public

Name
group_id
description

int4
varchar

Discriminator Column
Name
app_name
app_type
description
Discriminator Column
Name
login
pswd
name
email
active
activation_code
priv_admin
cem
Discriminator Column
Name
fileid
userid
binaryvalue
filename
filetype
fecha_inclusion
ip
estado
Discriminator Column
Name
anho
cod_ind
cod_cem
mes
ene
feb
mar
abr
may
jun

Type

Version Column
Type
varchar
varchar
varchar
Version Column
Type
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
Version Column
Type
int8
int8
varchar
varchar
varchar
timestamp
varchar
varchar
Version Column
Type
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar

Length
0
64
Schema
public
Length
128
255
255
Schema
public
Length
32
32
64
64
1
32
1
18
Schema
public
Length
0
0
2147483647
200
50
6
255
1
Schema
public
Length
4
10
18
2
20
20
20
20
20
20

jul
ago
set
oct
nov
dic
id

varchar
varchar
varchar
varchar
varchar
varchar
int8
Discriminator Column
Name

cod_cem
num_fich
dia_ini
mes_ini
anno_ini
dia_fin
mes_fin
anno_fin
sesion_apar
tip_part
cod_inst_coorg
nombre_inst
coddep
codpro
coddis
area
cod_accion
colaborador
b_inicio_inf
b_inicio_nin
b_inicio_ado
b_inicio_ado_t
b_inicio_jov
b_inicio_adu
b_inicio_m60_m
total_b_inicio
app_concluida
oj_jov_m
oj_jov_v
oj_adu_m
oj_adu_v
oj_m60_m
oj_m60_v
total_oj
op_jov_m
op_jov_v
op_adu_m

Version Column
Type
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
text
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar

20
20
20
20
20
20
0
Schema
public
Length
18
255
255
255
255
255
255
255
255
255
255
0
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

op_adu_v
op_m60_m
op_m60_v
total_op
os_jov_m
os_jov_v
os_adu_m
os_adu_v
os_m60_m
os_m60_v
total_os
aufr_jov_m
aufr_jov_v
aufr_adu_m
aufr_adu_v
aufr_m60_m
aufr_m60_v
total_aufr
aufl_jov_m
aufl_jov_v
aufl_adu_m
aufl_adu_v
aufl_m60_m
aufl_m60_v
total_aufl
auc_jov_m
auc_jov_v
auc_adu_m
auc_adu_v
auc_m60_m
auc_m60_v
total_auc
ed_jov_m
ed_jov_v
ed_adu_m
ed_adu_v
ed_m60_m
ed_m60_v
total_ed
es_inf_m
es_inf_v
es_nin_m
es_nin_v
es_ado_m
es_ado_v
es_ado_t_m
es_ado_t_v
es_jov_m

varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar

255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

es_jov_v
es_adu_m
es_adu_v
es_m60_m
es_m60_v
total_es
esu_ado_m
esu_ado_v
esu_ado_t_m
esu_ado_t_v
esu_jov_m
esu_jov_v
esu_adu_m
esu_adu_v
esu_m60_m
esu_m60_v
total_esu
pa_ado_m
pa_ado_v
pa_ado_t_m
pa_ado_t_v
pa_jov_m
pa_jov_v
pa_adu_m
pa_adu_v
pa_m60_m
pa_m60_v
total_pa
lico_ado_m
lico_ado_v
lico_ado_t_m
lico_ado_t_v
lico_jov_m
lico_jov_v
lico_adu_m
lico_adu_v
lico_m60_m
lico_m60_v
total_lico
fa_jov_m
fa_jov_v
fa_adu_m
fa_adu_v
fa_m60_m
fa_m60_v
total_fa
pro_jov_m
pro_jov_v

255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

pro_adu_m
pro_adu_v
pro_m60_m
pro_m60_v
total_pro
col_ado_m
col_ado_v
col_ado_t_m
col_ado_t_v
col_jov_m
col_jov_v
col_adu_m
col_adu_v
col_m60_m
col_m60_v
total_col
sere_jov_m
sere_jov_v
sere_adu_m
sere_adu_v
sere_m60_m
sere_m60_v
total_sere
fupu_jov_m
fupu_jov_v
fupu_adu_m
fupu_adu_v
fupu_m60_m
fupu_m60_v
total_fupu
fupri_jov_m
fupri_jov_v
fupri_adu_m
fupri_adu_v
fupri_m60_m
fupri_m60_v
total_fupri
emp_jov_m
emp_jov_v
emp_adu_m
emp_adu_v
emp_m60_m
emp_m60_v
total_emp
gemp_jov_m
gemp_jov_v
gemp_adu_m
gemp_adu_v

255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

gemp_m60_m
gemp_m60_v
total_gemp
trab_ado_m
trab_ado_v
trab_ado_t_m
trab_ado_t_v
trab_jov_m
trab_jov_v
trab_adu_m
trab_adu_v
trab_m60_m
trab_m60_v
total_trab
cont_ado_m
cont_ado_v
cont_ado_t_m
cont_ado_t_v
cont_jov_m
cont_jov_v
cont_adu_m
cont_adu_v
cont_m60_m
cont_m60_v
total_cont
per_jov_m
per_jov_v
per_adu_m
per_adu_v
per_m60_m
per_m60_v
total_per
osb_inf_m
osb_inf_v
osb_nin_m
osb_nin_v
osb_ado_m
osb_ado_v
osb_ado_t_m
osb_ado_t_v
osb_jov_m
osb_jov_v
osb_adu_m
osb_adu_v
osb_m60_m
osb_m60_v
total_osb
mrc_ado_m

255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

mrc_ado_v
mrc_ado_t_m
mrc_ado_t_v
mrc_jov_m
mrc_jov_v
mrc_adu_m
mrc_adu_v
mrc_m60_m
mrc_m60_v
total_mrc
rong_jov_m
rong_jov_v
rong_adu_m
rong_adu_v
rong_m60_m
rong_m60_v
total_rong
mmcr_ado_m
mmcr_ado_v
mmcr_ado_t_m
mmcr_ado_t_v
mmcr_jov_m
mmcr_jov_v
mmcr_adu_m
mmcr_adu_v
mmcr_m60_m
mmcr_m60_v
total_mmcr
po_inf_m
po_inf_v
po_nin_m
po_nin_v
po_ado_m
po_ado_v
po_ado_t_m
po_ado_t_v
po_jov_m
po_jov_v
po_adu_m
po_adu_v
po_m60_m
po_m60_v
total_po
ot_inf_m
ot_inf_v
ot_nin_m
ot_nin_v
ot_ado_m

255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

ot_ado_v
ot_ado_t_m
ot_ado_t_v
ot_jov_m
ot_jov_v
ot_adu_m
ot_adu_v
ot_m60_m
ot_m60_v
total_ot
tot_bene
temas
campana
id
cem
ids
Name

varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
int8
varchar
int8
Description

255
255
255
255
255
255
255
255
255
255
255
255
255
0
50
0
Tablespace

indice223
indice222
Discriminator Column
Name
timestamp
ficha
mes
fecha
hora_inicio
hora_final
moderador
estado_persona_consultante
descripcion_seudonimo
apellido_paterno
apellido_materno
nombres
dni_consultante
edad_consultante
sexo_consultante
telefono_contacto
correo_electronico
relacion_consultante
especifica
estado_civil_consultante
ubicacin_geografica
departamento_consultante
provincia
distrito
conocimiento_del_servicio

Version Column
Type
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar

Schema
public
Length
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

tipo_consulta_consultante
tipo_consulta_publica
detalle_referencia
especificar_otro
datos_persona_afectada
apellido_paterno2
apellido_materno2
nombres2
edad_persona_afectada
sexo_persona_afectada
domicilio
detalle_domicilio
nro
mz
lote
int
piso
km
sector
nombre_urb
detalle_nombre
referencia_domicilio
area_residencia
departamento
provincia1
distrito1
telefono_fijo
celular
situacion_violencia
situaciones_consulta_privada
puntapies
psicologica
sexual
punetazos
bofetadas
jalones_cabello
otras_agresiones
empujones
golpes_palos
ahorcamiento
latigazos
heridas_arma
golpes_otros_objetos
indiferencia
psicologica_rechazo
psicologica_desvalorizacion
psicologica_amenazas
psicologica_amenaza_hijos

255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

psicologica_otras_amenazas
psicologica_prohbe_estudiar
psicologica_rompe_cosas
psicologica_vigilancia_continua
botar de la casa
sexual_violacion
sexual_ofensas_pudor
actos_contra_pudor
trata_fines_explotacion
explotacion_sexual
pornografia
sexual1
acciones_realizadas
nombre_cem
tiempo_duracion
uso_chat_100
observaciones
a
b
id
Discriminator Column
Name
CAI
N_FICHA_N
CONDIC
FECHA
JUZGADO
EXPEDIENTE
NOMBRE_USUARIO
SITU_DNI
DNI
EDAD
FECHA_NAC
DIST
PROV
DPTO
VIVE
DISCAPACIDAD
ESTADO_CIVIL
NIVEL_EDUCATIVO
TRABAJA_REMUNERADA
OCUPACION
NOMBRE_AFECTADA
VINCULO
CONTACT_AFECT
EDAD_AFECT

varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
int8
Version Column
Type
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar

255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
0
Schema
public
Length
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

ESTADO_CIVIL_AFECT
NIVEL_EDUCATIVO_AFECT
TRABAJA_REMUNERADA_AFECT
OCUPACION_AFECT
CEM_AFECT
RIESGO_AFECT
TIPO_VIO
PUNTAPIES
PUETAZOS
BOFETADAS
JALONES_CABELLO
OTRAS_AGRESIONES
EMPUJONES
GOLPES_PALOS
AHORCAMIENTO
LATIGAZOS
HERIDAS_ARMAS
GOLPES_OBJETOS
NEGLIGENCIA
OTROS_VF
GRITOS
INDIFERENCIA
RECHAZO
DESVALORIZACION
AMENAZA_MUERTE
AMENAZA_HIJOS
OTRAS_AMENAZAS
IMPIDE_VISITAS
IMPIDE_ESTUDIAR
ROMPE_DESTRUYE
VIGILANCIA_CONTINUA
BOTAR_CASA
CONTROL_DINERO
IMPIDE_TRABAJO
AMENAZA_SUICIDIO
RETIRAR_DEMANDA
ABANDONO
OTROS_VPSI
LUGAR_AGRESION
CELOS
INFIDELIDAD
ENTENDIMIENTO
PAREJA_CELOSA
PAREJA_INFIEL
NO_CONTROL
NO_OBEDECE
PROBL_ECON
EBRIO

255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

ENTROMETE_FAM
NO_CUMPL_OBLIG
EMPEZO_TRAB
DESC_FAM
ELLA_AGREDE
QUISO_LLEVAR_HIJO
OTRO_MOT_SUP
PRESENTE_HECHOS
RECONOC_VIOLENCIA
Minimizar
Culpar
Negar
Coludirse
Cinismo
ACEPTA_DAO
ASUME_DECISION
REPARA_DAO
ANTEC_PSIC
ANTEC_PSIQ
ANTEC_ITS
CONSUME_ALCOHOL
FUMA
CONSUME_DROGA
ADIC_NO_CONV
BUSCO_AYUDA
RELAC_ACT_AFECT
ANTEC_PENAL
ANTEC_POLICIAL
ANTEC_JUDICIAL
CELOS1
DINERO
HIJOS
TRABAJO
CUIDA_CASA
FAMILIA
AMISTAD_SALIDA
SEXO
OTRO
PROBL_PAREJAS_ANT
PROBL_OTRO_FAM
PROBL_OTRO_PERS
CUMPLE_MED_JUZ
PROBL_PAREJA
AMENAZA
RIESGO_PRESUNTIVO
PRONOS_ADHERENCIA
MES
anho

255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255
255

id
bd_cargadosid
tbl_centroscod_aten
Discriminator Column
Name
cem
condic
fecha
n_ficha_n
n_ficha_a
referente
nombre_victima
situ_dni
dni
edad
sexo
embarazo
fecha_nac
lengua_materna
etnia
dpto
prov
dist
estado_civil
nivel_educativo
trabaja_remunerada
ocupacion
nombre_agresor
edad_a
sexo_a
vinculo
detalle_otro
vive
entero_cem
otros_cem
tipo_vio
puntapies
punetazos
bofetadas
jalones_cabello
otras_agresiones
empujones
golpes_palos
ahorcamiento
latigazos
heridas_armas

varchar
int8
varchar
Version Column
Type
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar

255
0
18
Schema
public
Length
18
20
20
32
20
53
100
32
8
32
32
32
20
64
64
100
100
100
64
64
64
64
42
32
32
32
56
32
32
25
32
32
32
32
53
53
53
53
53
53
53

golpes_objetos
negligencia
otros_vf
gritos
indiferencia
rechazo
desvalorizacion
amenaza_muerte
amenaza_hijos
otras_amenazas
impide_visitas
impide_estudiar
rompe_destruye
vigilancia_continua
botar_casa
abandono
otros_vp
acoso_sexual
violacion
ofensas_pudor
actos_pudor
trata_exp_sex
explot
pornografia
otros_vs
tentativa
envenenamiento
desbarrancamiento
atropellamiento
quemadura
otro_modalidad
celos
nega_pareja
va_casa
infidelidad
venganza
nueva_relacion
separarse
demanda_denuncia
otro_motivo
directamente
medio_otra
otra_persona
casa_victima
casa_familiar
centro_laboral
casa_agresor
calle

53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53

hotel
casa_ambos
lugar_desolado
otro_lugar
primera_vez_agrede
estado_u_agresor
estado_g_agresor
estado_u_u
estado_u_g
categoria
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
zz
aa
bb
cc
dd
ee
f
gg
hh
ii
jj
kk

53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
2
53
53
53
53
53
53
53
53
53
53
53

ll
mm
nn
oo
pp
qq
rr
ss
tt
uu
riesgo
denuncia
patrocinio
a1
a2
a3
a4
a5
a6
a7
a8
a9
a10
a11
a12
a13
a14
a15
a16
a17
a18
a19
a20
a21
a22
reconoc_medico
pericia_psicolog
medida_proteccion
garantias
constancia_retiro
agravante1
agravante2
agravante3
agravante4
agravante5
agravante6
agravante7
situacion_juridica

53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53

mes
anio
id
ids
Name

int4
varchar
int8
int8
Description

0
64
0
0
Tablespace

indice011
indice01
indice0111
Discriminator Column
Name
cem
fecha
anio
n_ficha
n_ficha_alfab
servicio
actividad
mes
id
Name

Version Column
Type
varchar
varchar
varchar
varchar
varchar
varchar
varchar
varchar
int8
Description

Schema
public
Length
18
100
64
32
20
200
200
32
0
Tablespace

indice023_copy
indice026_copy
indice02_copy
indice022_copy
indice021_copy
indice024_copy
indice025_copy
Discriminator Column

Version Column

Name

Type

id
fecha_carga
usuario_carga
observacion
mes_informe
anio_informa
flag_cargado

int8
timestamp
varchar
varchar
varchar
numeric
varchar

Schema
public
Length
0
6
20
250
2
4
1

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

One or More

Zero or More

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Zero or More

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1

Phrase2

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Zero or More

Exactly One

Zero or More

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

Cardinality1
Exactly One

Phrase2

DDL Clauses

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Cardinality2

Index Column

Zero or More

Description

Type
Normal

Scale
0

User type
bigserial

Default Value

Parent ID
119
Id Generator
sequence

0
0
DDL Clauses

Description

Type
Normal

Scale
0
0
0
0
DDL Clauses

User type
bigserial

Default Value

Description

Type
Normal

Scale

User type

Default Value

DDL Clauses

Description

Type

Parent ID
119
Id Generator
sequence

Parent ID
119
Id Generator

0
0
0

Normal
Scale
0
0

User type

Default Value

serial

sequence

DDL Clauses

Description

Scale

User type

Type
Default Value

DDL Clauses

Description

Type

Normal
0
0
0
0
0
0

Normal
Scale
0
0
0
0
2
2
2
2
2
2
2

Parent ID
119
Id Generator

User type
bigserial

Default Value

0
0
0
0
0
0
0

Parent ID
119
Id Generator
assigned

Parent ID
119
Id Generator
sequence

2
2
2
2
2
0
0
0
0
0
0
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2

0
0
0
0
0
'A'::character varying

2
2
2
2
2
2
2
2
2
2
2
2

Clustered
Non-clustered
DDL Clauses

Unique
No

Columns
Function
public.metas_programadas.anio,public.metas_programada

Description

Type
Normal

Scale
0
0
0
0
2
2
2
2
2
2
2
2
2
2
2
2
0
0
2
2
2
2
2
2
2
2
2
2
2
2

User type
bigserial

Default Value

0
0
0
0
0
0
0
0
0
0
0
0
'A'::character varying
0
0
0
0
0
0
0
0
0
0
0
0

Parent ID
119
Id Generator
sequence

2
2
2
2
2
2
2
2
2
2
2
2

0
0
0
0
0
0
0
0
0
0
0
0
DDL Clauses

Description

Type
Normal

Scale

User type

0
0
0

Default Value

Parent ID
119
Id Generator

'A'::character varying
sequence
DDL Clauses

Description

Scale

User type

Type
Normal
Default Value

0
0
0
0

Parent ID
119
Id Generator

assigned
DDL Clauses

Description

Scale

User type

Type
Normal
Default Value

0
0
0
0
0
0
0
0
15
15
0
0
0
Clustered
Non-clustered
DDL Clauses

Parent ID
119
Id Generator

assigned

Unique
No
Description

Columns
Function
public.tbl_centros.cem,public.tbl_centros.dpto,public.tbl_c
Type

Parent ID

Normal
Scale

User type

Default Value

0
0
0

119
Id Generator

sequence
DDL Clauses

Description

Type
Normal

Scale

User type

Default Value

DDL Clauses

Description

Type

Scale

User type

0
0

Normal
Default Value

0
0
0

Parent ID
119
Id Generator
assigned

Parent ID
119
Id Generator
sequence

DDL Clauses

Description

Type
Normal

Scale

User type

DDL Clauses

Description

Default Value

0
0
Type
Normal
Scale

User type

0
0
0

Default Value

Parent ID
119
Id Generator
sequence

Parent ID
119
Id Generator

'A'::character varying
sequence
DDL Clauses

Description

Scale

User type

Type
Normal

0
0
0

Default Value

Parent ID
119
Id Generator

'A'::character varying
sequence
DDL Clauses

Description

Type
Normal

Scale

User type

Default Value

0
0
0

Parent ID
119
Id Generator

sequence
DDL Clauses

Description

Type
Normal

Parent ID
119

Scale

User type

0
0
0

Default Value

Id Generator

'A'::character varying
sequence
DDL Clauses

Description

Type
Normal

Scale

User type

0
0
0

Default Value

Parent ID
119
Id Generator
sequence

'A'::character varying
DDL Clauses

Description

Scale

User type

Type
Normal

0
0
0

Default Value

Parent ID
119
Id Generator

'A'::character varying
sequence
DDL Clauses

Description

Type
Normal

Scale

User type

0
0
0

Default Value

Parent ID
119
Id Generator

'A'::character varying
sequence
DDL Clauses

Description

Type
Normal

Scale

User type

0
0
0

Default Value

Parent ID
119
Id Generator
sequence

'A'::character varying
DDL Clauses

Description

Type
Normal

Scale

User type

0
0
0

Default Value

Parent ID
119
Id Generator
native

'A'::character varying
DDL Clauses

Description

Scale

User type

Type
Normal
Default Value

0
0
0

Parent ID
119
Id Generator

sequence
DDL Clauses

Description

Type

Parent ID

Normal
Scale
0
0
0
0
0
0
0
2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

User type

Default Value

bigserial

Clustered
Non-clustered

Unique
No

119
Id Generator

sequence

Columns
public.sime_indicadores.anio

DDL Clauses

Description

Type

Scale

User type

Default Value

DDL Clauses

Description

Type

Normal
0
0

Normal
Scale

User type

Default Value

DDL Clauses

Description

Type

0
0
0
0
0
0
0
0

Normal

Function

Parent ID
119
Id Generator
assigned
assigned
Parent ID
119
Id Generator
assigned
assigned

Parent ID
119

Scale
0
0

User type
serial

Default Value

Id Generator
sequence

Type

Parent ID
119
Id Generator
assigned

DDL Clauses

Description

Scale

User type

Default Value

DDL Clauses

Description

Type

Normal
0
0
0

Normal
Scale

User type

Default Value

DDL Clauses

Description

Type

0
0
0
0
0
0
0
0

Normal
Scale
0
0
0
0
0
0
0
0

User type
bigserial

Default Value

Parent ID
119
Id Generator
sequence

'\x'::bytea

0
DDL Clauses

Description

Type
Normal

Scale
0
0
0
0
0
0
0
0
0
0

Parent ID
119
Id Generator
assigned

User type

Default Value

Parent ID
119
Id Generator

0
0
0
0
0
0
0
DDL Clauses

Description

Scale

User type

Type
Normal

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Default Value

Parent ID
119
Id Generator

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Clustered
Non-clustered
Non-clustered

bigserial
Unique
No
No

DDL Clauses

Description

Scale

User type

sequence
Columns
Function
public.sime_bdapp.cod_cem,public.sime_bdapp.id,public.
public.sime_bdapp.mes_ini,public.sime_bdapp.anno_ini,pu
Type
Normal

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Default Value

Parent ID
119
Id Generator

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
DDL Clauses

Description

Type
Normal

Scale
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

User type

Default Value

Parent ID
119
Id Generator

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
DDL Clauses

Description

Scale

User type

Type
Normal

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Default Value

Parent ID
119
Id Generator
assigned

assigned
assigned

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
Clustered
Non-clustered
Non-clustered
Non-clustered
DDL Clauses

bigserial
Unique
No
No
No

assigned
assigned
nextval('seq_sime_casos_spss_id'::regclass)
Columns
Function
public.sime_casos_spss.cem
public.sime_casos_spss.cem,public.sime_casos_spss.id,pub
public.sime_casos_spss.cem,public.sime_casos_spss.id

Description

Type
Normal

Scale

User type

Default Value

Parent ID
119
Id Generator

0
0
0
0
0
0
0
0
0
Clustered
Non-clustered
Non-clustered
Non-clustered
Non-clustered
Non-clustered
Non-clustered
Non-clustered
DDL Clauses

Unique
No
No
No
No
No
No
No

Columns
Function
public.sime_atenciones_spss2.actividad,public.sime_aten
public.sime_atenciones_spss2.servicio
public.sime_atenciones_spss2.cem,public.sime_atenciones
public.sime_atenciones_spss2.cem,public.sime_atenciones
public.sime_atenciones_spss2.cem
public.sime_atenciones_spss2.id,public.sime_atenciones_
public.sime_atenciones_spss2.id

Description

Type
Normal

Scale
0
0
0
0
0
0
0

User type
bigserial

Default Value

'N'::character varying

Parent ID
119
Id Generator
sequence

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update
No action

On Delete
Cascade

Identifying

On Update
No action

On Delete
Cascade

Yes

Identifying

On Update
No action

On Delete
Cascade

Identifying

On Update
No action

On Delete
Cascade

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Yes

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Identifying

On Update

On Delete

Parent Name

Delete ?

public
Id Generator Key
id_tbl_otros_indicadores_seq

No
Check Constraint

Generated
Unspecified

Unspecified
Unspecified
Parent Name
public
Id Generator Key
seq_tbl_linea_piepag_id

Delete ?
No
Check Constraint

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

seq_tbl_anios_id
Parent Name

Delete ?

Id Generator Key

No
Check Constraint

Parent Name

Delete ?

public

public
Id Generator Key
seq_metas_programadas_id

No
Check Constraint

Generated
Unspecified
Unspecified
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified

Generated
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Delete ?
No
Parent Name
public
Id Generator Key
seq_metas_ejecutadas_id

Delete ?
No
Check Constraint

Generated
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Parent Name
public
Id Generator Key

Delete ?
No
Check Constraint

seq_metodo_analisis_informacion_id
Parent Name

Delete ?

Id Generator Key

No
Check Constraint

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

Delete ?
No
Parent Name

Delete ?

Generated
Unspecified
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

public
Id Generator Key

No
Check Constraint

seq_unidad_medida_id
Parent Name

Delete ?

Id Generator Key

No
Check Constraint

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

seq_tipo_indicador_id

Parent Name
public
Id Generator Key
seq_tbl_reportes_id

Parent Name
public
Id Generator Key

No
Check Constraint

Delete ?
No
Check Constraint

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

seq_responsable_intervension_id
Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

seq_para_que_se_aplicara_id
Parent Name
public

Generated
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified

Delete ?

seq_responsable_medicion_id

public

Generated
Unspecified
Unspecified
Unspecified

Delete ?
No

Generated
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified

Id Generator Key

Check Constraint

seq_metodo_recopilacion_id
Parent Name
public
Id Generator Key

Delete ?
No
Check Constraint

seq_jerarquia_objetivos_id

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

seq_fuente_datos_id
Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

seq_frecuencia_id
Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

seq_formatos_difusion_id

Parent Name
Id Generator Key

Delete ?
No
Check Constraint

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

seq_circulacion_id2
Parent Name

Delete ?

Generated
Unspecified
Unspecified
Unspecified

public
Id Generator Key

No
Check Constraint

seq_sime_indicadores_id

Delete ?
No
Parent Name

Delete ?

Id Generator Key

No
Check Constraint

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

Parent Name

Delete ?

public

Generated
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

Id Generator Key
sec_groups_group_id_seq

Check Constraint

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

Parent Name

Delete ?

public

public
Id Generator Key
id_seq_upload_archivos

No
Check Constraint

Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

Generated
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

Generated
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

seq_sime_bdapp_id
Delete ?
No
No
Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

Delete ?
No
Check Constraint

Unspecified
Unspecified
Unspecified
Parent Name

Delete ?

Id Generator Key

No
Check Constraint

public

Unspecified
Unspecified
Unspecified
Unspecified
Delete ?
No
No
No
Parent Name
public
Id Generator Key

Delete ?
No
Check Constraint

Generated
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

Delete ?
No
No
No
No
No
No
No
Parent Name
public
Id Generator Key
seq_bd_cargados_id

Delete ?
No
Check Constraint

Generated
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified
Unspecified

Description
6

Description
6

Description

DBForeignKey
No

Description
6

Description PrimaryKey
Nullable
Yes
No

Unique Delete ?
No
No

No
No

Description PrimaryKey
Yes
No
No
No

Yes
Yes

Nullable
No
Yes
Yes
Yes

No
No

Unique
No
No
No
No

Delete ?
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
No
Yes
No
Yes

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
No
Yes
No

Unique Delete ?
No
No
No
No

Description PrimaryKey
Yes
No
No
No
No
No

Nullable

Unique
No
No
No
No
No
No

Delete ?
No
No
No
No
No
No

Nullable

Unique
No
No
No
No
No
No
No
No
No
No
No

Delete ?
No
No
No
No
No
No
No
No
No
No
No

Description PrimaryKey
Yes
No
No
No
No
No
No
No
No
No
No

No
Yes
Yes
Yes
Yes
Yes

No
Yes
No
No
No
No
No
No
No
No
No

No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

No
No
No
No
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes

No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

No
No
No
No
No
No
No
No
No
No
No
No

Description PrimaryKey
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No

Nullable
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No

No
No
No
No
No
No
No
No
No
No
No
No

Unique
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

Delete ?
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

No
No
No
No
No
No
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
No
Yes
Yes
No

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
No
No
No
Yes

Nullable

Unique
No
No
No
No

Delete ?
No
No
No
No

Nullable

Unique
No
No
No
No
No
No
No
No
No
No
No
No
No

Delete ?
No
No
No
No
No
No
No
No
No
No
No
No
No

Description PrimaryKey
No
No
No
No
Yes
No
No
No
No
No
No
No
No

Yes
Yes
Yes
No

Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No

Description PrimaryKey
Nullable
No
Yes
No
Yes
Yes
No

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
Yes
No
No
Yes

Unique Delete ?
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
Yes
No
No
Yes

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
Yes
No
No
Yes

Unique Delete ?
No
No
No
No

Description PrimaryKey
Nullable
No
No
No
Yes
Yes
No

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
No
Yes
Yes
No

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
No
Yes
Yes
No

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
No
Yes
Yes
No

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
Yes
No
No
Yes

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
No
Yes
Yes
No

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
No
Yes
Yes
No

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
Yes
No
No
Yes

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
No
Yes
No
No
Yes

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Nullable
No
Yes
No
Yes
Yes
No

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No

Nullable
No
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
No

Unique
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

Delete ?
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

Description PrimaryKey
Nullable
Yes
No
Yes
No

Unique Delete ?
No
No
No
No

Description PrimaryKey
Yes
Yes
No
No
No
No
No
No

Unique
No
No
No
No
No
No
No
No

Nullable
No
No
Yes
Yes
Yes
Yes
Yes
Yes

Delete ?
No
No
No
No
No
No
No
No

Description PrimaryKey
Nullable
Yes
No
No
Yes

Unique Delete ?
No
No
No
No

Description PrimaryKey
Nullable
Yes
No
No
Yes
No
Yes

Unique Delete ?
No
No
No
No
No
No

Description PrimaryKey
Yes
No
No
No
No
No
No
No

Nullable
No
No
Yes
Yes
Yes
Yes
Yes
No

Unique
No
No
No
No
No
No
No
No

Delete ?
No
No
No
No
No
No
No
No

Description PrimaryKey
Yes
No
No
No
No
No
No
No

Nullable
No
No
Yes
Yes
Yes
Yes
Yes
No

Unique
No
No
No
No
No
No
No
No

Delete ?
No
No
No
No
No
No
No
No

Description PrimaryKey
No
No
No
No
No
No
No
No
No
No

Nullable
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes

Unique
No
No
No
No
No
No
No
No
No
No

Delete ?
No
No
No
No
No
No
No
No
No
No

No
No
No
No
No
No
No

Description PrimaryKey
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

Yes
Yes
Yes
Yes
Yes
Yes
No

Nullable
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes

No
No
No
No
No
No
No

Unique
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

Delete ?
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No

Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes