-- Data for Name: clases_puc; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.clases_puc (id_clases_puc, nombre, fecha_creacion, id_usuario_creacion, fecha_modificacion, id_usuario_modificacion, codigo_puc, estado) FROM stdin;
1	ACTIVO	2015-09-23 00:00:00	1	2015-09-28 16:48:54	1	1	t
2	PASIVO	2015-09-23 00:00:00	1	2015-09-23 00:00:00	1	2	t
3	PATRIMONIO	2015-09-23 00:00:00	1	2015-09-23 00:00:00	1	3	t
4	INGRESOS	2015-09-23 00:00:00	1	2015-09-23 00:00:00	1	4	t
5	GASTOS	2015-09-23 00:00:00	1	2015-09-23 00:00:00	1	5	t
6	COSTOS	2015-09-23 00:00:00	1	2015-09-23 00:00:00	1	6	t
7	COSTOS DE PRODUCCION	2015-09-23 00:00:00	1	2015-09-23 00:00:00	1	7	t
8	CUENTAS DE ORDEN DEUDORAS	2015-09-23 00:00:00	1	2015-09-23 00:00:00	1	8	t
9	CUENTAS DE ORDEN ACREEDORAS	2015-09-23 00:00:00	1	2015-09-23 00:00:00	1	9	t
\.


--
-- Data for Name: clinical_data; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.clinical_data (id_clinical_data, id_room_appointment_study_receipt, data_clinical, cd_custom1, cd_custom2, cd_custom3, cd_custom4, es_embarazo, es_alergico_contraste, tipo_reaccion, creatinina, talla, filtracion_glomerular, ultima_comida, estudios_anteriores, enf_tratamiento, hta, asma, prob_cardiacos, prob_intestinal, prob_coagulacion, diabetes, insuficiencia_renal, prob_pulmonares, prob_hepaticos, toma_medicamentos, cual_medicamento, metformina_glucophage, ultimo_met_glu, cirugia, cual_cirugia) FROM stdin;
\.


--
-- Data for Name: clinical_file; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.clinical_file (id, patient_document, patient_name, patient_birth_date, patient_sex, study_iuid, modality, study_name, study_datetime, current, appointment_code) FROM stdin;
\.


--
-- Data for Name: concordance; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.concordance (id_concordance, appointment_code, quality_image, quality_contrast, secuence_image, moving_patient, tech_failure, concordance, current, id_user) FROM stdin;
\.


--
-- Data for Name: consent; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.consent (id, name, description, current) FROM stdin;
\.


--
-- Data for Name: contra_indication; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.contra_indication (id, name, description, current) FROM stdin;
\.


--
-- Data for Name: contratos; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.contratos (id_contratos, fecha_inicio, fecha_final, modo_facturar, id_usuario_creador, estado, tipo_contrato, id_eps, fecha_creacion, valor_monto, id_resolucion, modo_pago, tiempo_pago, tipo_pago, descripcion_pago, codigo_autorizacion, cuotas, facturacion_paciente, pago_bono, recibo_caja, id_cuenta_puc, fecha_modificacion, id_usuario_modificador, nombre_contrato, nit_contrato, direccion_contrato, telefono_contrato, poliza_soat, num_contrato) FROM stdin;
\.


--
-- Data for Name: contratos_examenes; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.contratos_examenes (id_contratos_examenes, id_contratos_modalidad, id_examen, id_usuario_creador, fecha_creacion, id_usuario_modificador, fecha_modificador, tipo_calculo, valor_porcentaje, valor_resultante, estado, id_rate) FROM stdin;
\.


--
-- Data for Name: contratos_modalidades; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.contratos_modalidades (id_contratos_modalidad, id_contratos, id_modalidad, fecha_creacion, id_usuario_creador, fecha_modificador, id_usuario_modificador) FROM stdin;
\.


--
-- Data for Name: contratos_sedes; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.contratos_sedes (id_contratos_sede, fecha_creacion, id_usuario_creador, fecha_modificador, id_usuario_modificador, id_contratos, id_sede) FROM stdin;
\.


--
-- Data for Name: copayment; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.copayment (id_copayment, copayment_percentage, id_affiliation_type, id_level, current) FROM stdin;
\.


--
-- Data for Name: cuentas_puc; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.cuentas_puc (id_cuentas_puc, id_clases_puc, numero_cuenta, nombre, fecha_creacion, id_usuario_creacion, fecha_modificacion, id_usuario_modificacion) FROM stdin;
\.


--
-- Data for Name: cuotas_copagos; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.cuotas_copagos (id_cuotas_copago, nivel_1_cm, nivel_2_cm, nivel_3_cm, nivel_1_cop, nivel_2_cop, nivel_3_cop, estado, fecha_creacion, id_usuario_creador, fecha_modificacion, id_usuario_modificador, nombre_cuotas_copago) FROM stdin;
\.


--
-- Data for Name: data_result; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.data_result (id_data, name_receives, item_satisfaction, remark, id_transcription, receive, "time", dates, id_user) FROM stdin;
\.


--
-- Data for Name: days; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.days (id_day, day) FROM stdin;
\.


--
-- Data for Name: days_schedule; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.days_schedule (id_days_schedule, id_days, id_schedule_rules) FROM stdin;
\.


--
-- Data for Name: department; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.department (department_code, department_name, current) FROM stdin;
1009	ALEMANIA	2014-06-12 16:25:50
1484	ARUBA	2014-06-12 16:25:50
1027	AUSTRALIA	2014-06-12 16:25:50
1485	BARBADOS	2014-06-12 16:25:50
1012	BRASIL	2014-06-12 16:25:50
1001	CANADA	2014-06-12 16:25:50
1020	CHILE	2014-06-12 16:25:50
1034	CHINA	2014-06-12 16:25:50
1004	CIUDAD DE PANAMA	2014-06-12 16:25:50
1000	COLOMBIA	2014-06-12 16:25:50
1015	COSTA RICA	2014-06-12 16:25:50
1037	CUBA	2014-06-12 16:25:50
1024	CURACAO	2014-06-12 16:25:50
1019	ECUADOR	2014-06-12 16:25:50
1002	EE.UU	2014-06-12 16:25:50
1003	ESPANA	2014-06-12 16:25:50
1030	FILIPINAS	2014-06-12 16:25:50
1040	FRANCIA	2014-06-12 16:25:50
1033	GUATEMALA	2014-06-12 16:25:50
1006	HOLANDA	2014-06-12 16:25:50
1016	HONDURAS	2014-06-12 16:25:50
1014	INDIA	2014-06-12 16:25:50
1018	INGLATERRA	2014-06-12 16:25:50
1010	ISRAEL	2014-06-12 16:25:50
1005	ITALIA	2014-06-12 16:25:50
1023	JAPON	2014-06-12 16:25:50
1032	JORDANIA	2014-06-12 16:25:50
1031	KOREA	2014-06-12 16:25:50
1011	LIBANO	2014-06-12 16:25:50
1021	LONDRES	2014-06-12 16:25:50
1025	MEXICO	2014-06-12 16:25:50
1022	MIAMI FLORIDA	2014-06-12 16:25:50
1013	PARAGUAY	2014-06-12 16:25:50
1028	PERU	2014-06-12 16:25:50
1035	POLONIA	2014-06-12 16:25:50
1041	PORTUGAL	2014-06-12 16:25:50
1017	PUERTO RICO	2014-06-12 16:25:50
1038	REPUBLICA DOMINICANA	2014-06-12 16:25:50
1039	RUMANIA	2014-06-12 16:25:50
1036	SUECIA	2014-06-12 16:25:50
1008	SUIZA	2014-06-12 16:25:50
1029	URUGUAY	2014-06-12 16:25:50
1026	YUGOESLAVIA	2014-06-12 16:25:50
63	Quindio	2016-02-22 12:15:00
18	Caqueta	2016-02-22 12:15:00
68	Santander	2016-02-22 12:15:00
66	Risaralda	2016-02-22 12:15:00
76	Valle del Cauca	2016-02-22 12:15:00
73	Tolima	2016-02-22 12:15:00
94	Guainia	2016-02-22 12:15:00
25	Cundinamarca	2016-02-22 12:15:00
41	Huila	2016-02-22 12:15:00
44	La Guajira	2016-02-22 12:15:00
08	Atlantico	2016-02-22 12:15:00
47	Magdalena	2016-02-22 12:15:00
20	Cesar	2016-02-22 12:15:00
23	Cordoba	2016-02-22 12:15:00
70	Sucre	2016-02-22 12:15:00
13	Bolivar	2016-02-22 12:15:00
54	Norte de Santander	2016-02-22 12:15:00
27	Choco	2016-02-22 12:15:00
05	Antioquia	2016-02-22 12:15:00
81	Arauca	2016-02-22 12:15:00
17	Caldas	2016-02-22 12:15:00
85	Casanare	2016-02-22 12:15:00
99	Vichada	2016-02-22 12:15:00
19	Cauca	2016-02-22 12:15:00
50	Meta	2016-02-22 12:15:00
52	Nariño	2016-02-22 12:15:00
95	Guaviare	2016-02-22 12:15:00
97	Vaupes	2016-02-22 12:15:00
86	Putumayo	2016-02-22 12:15:00
91	Amazonas	2016-02-22 12:15:00
88	San Andres y Providencia	2016-02-22 12:15:00
11	Bogota D.C	2016-02-22 12:15:00
00	N/A	2016-02-22 12:15:00
01	EXTRANJERO	2016-02-22 12:15:00
15	Boyaca	2016-02-22 12:15:00
01007	ARGENTINA	2016-03-02 11:06:10
\.


--
-- Data for Name: devolution_historic; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.devolution_historic (id_devolution_historic, current, next_step, motive_devolution, appointment_code, id_user, comment_new_send_technologist, comment_new_send_radiologist, comment_new_send_transcription, id_user_last_process) FROM stdin;
\.


--
-- Data for Name: diary_blockade; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.diary_blockade (id, name, current, description) FROM stdin;
\.


--
-- Data for Name: document_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.document_type (id_document_type, name, current) FROM stdin;
CC	Cédula de Ciudadanía                              	2015-04-08
TI	Tarjeta de identidad                              	2015-05-11
RC	Registro Civil                                    	2015-05-11
\.


--
-- Data for Name: encuesta; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.encuesta (id_encuesta, campo1, campo2, campo3, campo4, campo5, campo6, campo7, campo8, campo9, campo10, campo11, campo12, campo13, campo14, campo15, campo16, campo17, campo18, campo19, campo20, campo21, campo22, campo23, campo24, campo25, campo26, campo27, campo28, campo29, campo30, campo31, campo32, campo33, campo34, campo35, campo36, campo37, campo38, campo39, campo40, campo41, campo42, campo43, campo44, campo45, campo46, campo47, campo48, campo49, campo50, campo51, campo52, campo53, campo54, campo55, campo56, campo57, campo58, campo59, campo60, campo61, campo62, campo63, campo64, campo65, campo66, campo67, campo68, campo69, campo70, campo71, campo72, campo73, campo74, campo75, campo76, campo77, campo78, campo79, campo80, campo81, campo82, campo83, campo84, campo85, campo86, campo87, campo88, campo89, campo90, campo91, campo92, campo93, campo94, campo95, campo96, campo97, campo98, campo99, campo100, campo101, campo102, campo103, campo104, campo105, campo106, campo107, campo108, campo109, campo110, campo111, campo112, campo113, campo114, campo115, campo116, campo117, campo118, campo119, campo120, campo121, campo122, campo123, campo124, campo125, campo126, campo127, campo128, campo129, campo130, campo131, campo132, campo133, campo134, campo135, campo136, campo137, campo138, campo139, appointment_code) FROM stdin;
\.


--
-- Data for Name: entity; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.entity (id_entity, entity_nit, entity_name, email, current, url_logo, nota_pie_factura, id_cuotas_copagos) FROM stdin;
7f5328ba-6991-436b-bc0e-c89e5be69f65	0000000	Empresa	soporre@imexhs.com	2015-05-08 19:23:52	\N	\N	\N
\.


--
-- Data for Name: eps; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.eps (id_eps, eps_nit, name, address, telephone, email, current, code, id_municipality, id_type, id_benefit_plan, id_regime_affiliate, id_iva_privity, other_benefit, other_type, codigo_empresa, facturable, id_contratos, estado_factura) FROM stdin;
\.


--
-- Data for Name: eps_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.eps_type (id, name, description, current) FROM stdin;
1	DEFAULT	DEFAULT	2017-10-31 10:08:54
\.


--
-- Data for Name: especialidad_medico; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.especialidad_medico (nombre_especialidad_medico, id_especialidad_medico) FROM stdin;
MÉDICO RADIÓLOGO	1
\.


--
-- Data for Name: facturas; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.facturas (id_factura, codigo_resolucion, id_contrato, fecha_creacion, id_usuario_creacion, estado, fecha_anulacion, id_usuario_anulacion, comentario_anulacion, valor_neto, valor_total, copago, deducciones, bono, iva, fecha_inicio, fecha_final, valor_inicial, valor_final, prefijo, resolucion, observaciones, fecha_radicacion, id_usuario_radicacion, factura_capita, v_us_rpv, v_no_estudios_ecografia, v_us_valor_total, v_rad_rpv, v_no_estudios_radiologia, v_rad_valor_total, v_us_valor_fijo, v_rad_valor_fijo, factura_volumen, codigo_factura, system_date) FROM stdin;
\.


--
-- Data for Name: facturas_capita; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.facturas_capita (id_capita, c_dato_poblacion, c_rad_precio_r0, c_rad_incr_precio_r_ri1, c_rad_freq_r0, c_rad_incr_intervalo_r_ri1, c_no_estudios_radiologia, c_rad_anual_estudios, c_rad_proporcion_estudiosanual_afiliado, c_rad_diferencia_proporcion_estudiosanual_afiliado, c_rad_no_saltos, c_rad_valor_capita_afiliado, c_rad_valor_total_capita_afiliado, c_us_precio_r0, c_us_incr_precio_r_ri1, c_us_freq_r0, c_us_incr_intervalo_r_ri1, c_no_estudios_us, c_us_anual_estudios, c_us_proporcion_estudiosanual_afiliado, c_us_diferencia_proporcion_estudiosanual_afiliado, c_us_no_saltos, c_us_valor_capita_afiliado, c_us_valor_total_capita_afiliado, c_no_estudios_capitados, id_factura) FROM stdin;
\.


--
-- Data for Name: facturas_ordenes; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.facturas_ordenes (id_facturas_ordenes, id_factura, id_orden, estado, fecha_creacion, id_usuario_creacion, codigo_resolucion, codigo_factura) FROM stdin;
\.


--
-- Data for Name: fixed_price; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.fixed_price (id, name, value, description, current) FROM stdin;
\.


--
-- Data for Name: formularios; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.formularios (id, nombre, fecha_creacion, id_usuario_creador, fecha_modificacion, id_usuario_modificador, estado) FROM stdin;
\.


--
-- Data for Name: fos_user_headquarter; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.fos_user_headquarter (user_id, headquarter_id, id) FROM stdin;
1	6d44fb4f-aa8d-47ea-a633-d54f8041b843	1
2	6d44fb4f-aa8d-47ea-a633-d54f8041b843	2
\.


--
-- Data for Name: fos_user_user_group; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.fos_user_user_group (user_id, group_id) FROM stdin;
1	10
2	3
\.


--
-- Data for Name: group_sonata; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.group_sonata (id, name, roles) FROM stdin;
3	RADIOLOGO	a:2:{i:0;s:12:"ROLE_READING";i:1;s:16:"ROLE_READING_ANY";}
5	TRANSCRIPTOR	a:1:{i:0;s:18:"ROLE_TRANSCRIPTION";}
10	SUPER_ADMIN	a:1:{i:0;s:16:"ROLE_SUPER_ADMIN";}
8	ENTREGA_RESULTADOS	a:2:{i:0;s:21:"ROLE_DELIVERY_RESULTS";i:1;s:13:"ROLE_ENCUESTA";}
6	RADIOLOGO_RV	a:3:{i:0;s:12:"ROLE_READING";i:1;s:16:"ROLE_READING_ANY";i:2;s:19:"ROLE_READING_ANY_VR";}
18	CONSULTA_PISOS	a:2:{i:0;s:13:"ROLE_CONSULTA";i:1;s:13:"ROLE_ENCUESTA";}
24	TECNOLOGO	a:2:{i:0;s:16:"ROLE_ASISTENTIAL";i:1;s:11:"ROLE_REPORT";}
25	ADMINISTRADOR_AGENDA	a:2:{i:0;s:19:"ROLE_SCHEDULE_ADMIN";i:1;s:12:"ROLE_RECEIVE";}
26	ATENCION_INMEDIATA_HIS	a:1:{i:0;s:13:"ROLE_ATENCION";}
27	INDICADORES	a:1:{i:0;s:15:"ROLE_INDICATORS";}
28	BUSCAR_PACIENTE	a:1:{i:0;s:19:"ROLE_PATIENT_SEARCH";}
23	VNA_MODIFY	a:1:{i:0;s:15:"ROLE_VNA_MODIFY";}
30	CALL_CENTER_ASIGNACION_CITAS	a:1:{i:0;s:16:"ROLE_CALL_CENTER";}
22	VNA_CARDIOLOGIA	a:1:{i:0;s:13:"ROLE_USER_VNA";}
31	ENCUESTAS	a:1:{i:0;s:13:"ROLE_ENCUESTA";}
32	REPORTE	a:1:{i:0;s:11:"ROLE_REPORT";}
21	VNA_READ	a:1:{i:0;s:13:"ROLE_VNA_READ";}
29	CANCELACIONES	a:1:{i:0;s:22:"ROLE_USER_CANCEL_STUDY";}
\.


--
-- Data for Name: historial_patient; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.historial_patient (historial_patient_code, physical_order_url, current) FROM stdin;
\.


--
-- Data for Name: hrk_portal; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.hrk_portal (hrk_portal_id, id_patient, id_room_appointment_study_receipt, state, code_response, message_response, current) FROM stdin;
\.


--
-- Data for Name: indication; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.indication (id, name, description, current) FROM stdin;
\.


--
-- Data for Name: infectologia; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.infectologia (id, nombre, fecha_creacion) FROM stdin;
1	Búsqueda de foco infeccioso y estadificación	2014-06-13 19:43:14
2	Evaluación de la respuesta al tratamiento antibiótico	2014-06-13 19:43:14
3	Evaluación de la respuesta al tratamiento reumatológico y/o inmunosupresor	2014-06-13 19:43:14
4	Evaluación del proceso inflamatorio parietal vascular	2014-06-13 19:43:14
0	No aplica	2014-12-01 19:43:14
\.


--
-- Data for Name: internal_order; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.internal_order (internal_order_code, physical_order_url, current, doctor_referring, have_clinical_data, codigo_cie10, document_doctor_referring, id_out_site_user, hijo_de, valor_neto, valor_total, copago, deducciones, bonos, iva, orden_original, fecha_cancelacion, usuario_cancelacion, comentario_cancelacion, comentario_no_facturado, auditado, fecha_auditado, usuario_auditado, consecutivo_recibo_caja, recibo_caja_original, forma_pago, codigo_autorizacion, nivel_afiliacion, estado_orden, id_contrato, id_usuario_creador, estado_factura, codigo_factura, n_poliza_soat, valor_tarjeta, valor_efectivo, valor_paciente, tipo_aporte) FROM stdin;
\.


--
-- Data for Name: iva_privity; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iva_privity (id, name, description, current) FROM stdin;
22	DEFAULT	1	2015-05-09 10:55:03
\.


--
-- Data for Name: level; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.level (id_level, level_type, current) FROM stdin;
\.


--
-- Data for Name: margen_reportes; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.margen_reportes (id_report, margen_top, margen_boton, margen_left, margen_right, cabecera, url_cabecera, id_headquarter, current) FROM stdin;
\.


--
-- Data for Name: modality; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.modality (id_modality, modality_name, current, has_images, insumos, medio_contraste) FROM stdin;
CT	TOMOGRAFIA	2015-05-08 19:26:37	t	f	f
MG	MAMOGRAFIA	2015-05-08 19:26:37	t	f	f
CR	RX CONVENCIONAL	2015-05-08 19:26:37	t	f	f
DX	RX DIGITAL	2015-05-08 19:26:37	t	f	f
US	ECOGRAFIA	2015-05-08 19:26:37	t	f	f
MR	RESONANCIA	2015-05-09 12:50:18	t	f	f
\.


--
-- Data for Name: modality_worklist; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.modality_worklist (id_modality_worklist, sex, birth_date, names, last_names, patient_document, appointment_code, study_name, id_room, is_sent, study_uid, headquarter_code) FROM stdin;
\.


--
-- Data for Name: municipality; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.municipality (municipality_code, municipality_name, department_code, current) FROM stdin;
05002	Abejorral	05	2016-02-22 12:15:00
05004	Abriaqui	05	2016-02-22 12:15:00
27006	Acandi	27	2016-02-22 12:15:00
05021	Alejandria	05	2016-02-22 12:15:00
05030	Amaga	05	2016-02-22 12:15:00
05031	Amalfi	05	2016-02-22 12:15:00
05034	Andes	05	2016-02-22 12:15:00
05036	Angelopolis	05	2016-02-22 12:15:00
05040	Anori	05	2016-02-22 12:15:00
05044	Anza	05	2016-02-22 12:15:00
05045	Apartado	05	2016-02-22 12:15:00
23068	Ayapel	23	2016-02-22 12:15:00
08001	Barranquilla	08	2016-02-22 12:15:00
05088	Bello	05	2016-02-22 12:15:00
05086	Belmira	05	2016-02-22 12:15:00
05091	Betania	05	2016-02-22 12:15:00
27099	Bojaya	27	2016-02-22 12:15:00
05101	Bolivar	05	2016-02-22 12:15:00
15109	Buenavista	70	2016-02-22 12:15:00
05120	Caceres	05	2016-02-22 12:15:00
05129	Caldas	05	2016-02-22 12:15:00
05134	Campamento	05	2016-02-22 12:15:00
05145	Caramanta	05	2016-02-22 12:15:00
05147	Carepa	05	2016-02-22 12:15:00
05148	Carmen de Viboral	05	2016-02-22 12:15:00
05150	Carolina del Principe	05	2016-02-22 12:15:00
13001	Cartagena de Indias	13	2016-02-22 12:15:00
05154	Caucasia	05	2016-02-22 12:15:00
23162	Cereté	23	2016-02-22 12:15:00
73168	Chaparral	73	2016-02-22 12:15:00
05172	Chigorodo	05	2016-02-22 12:15:00
68176	Chimá	23	2016-02-22 12:15:00
17174	Chinchina	17	2016-02-22 12:15:00
23182	Chinú	23	2016-02-22 12:15:00
05190	Cisneros	05	2016-02-22 12:15:00
05197	Cocorna	05	2016-02-22 12:15:00
05209	Concordia	05	2016-02-22 12:15:00
27205	Condoto	27	2016-02-22 12:15:00
05212	Copacabana	05	2016-02-22 12:15:00
70215	Corozal	70	2016-02-22 12:15:00
54001	Cucuta	54	2016-02-22 12:15:00
05234	Dabeiba	05	2016-02-22 12:15:00
05237	Donmatias	05	2016-02-22 12:15:00
05240	Ebejico	05	2016-02-22 12:15:00
05250	El Bagre	05	2016-02-22 12:15:00
05541	El Peñol	05	2016-02-22 12:15:00
05607	El Retiro	05	2016-02-22 12:15:00
05264	Entrerrios	05	2016-02-22 12:15:00
05266	Envigado	05	2016-02-22 12:15:00
05282	Fredonia	05	2016-02-22 12:15:00
05308	Girardota	05	2016-02-22 12:15:00
05313	Granada	05	2016-02-22 12:15:00
05315	Guadalupe	05	2016-02-22 12:15:00
47318	Guamal	47	2016-02-22 12:15:00
05318	Guarne	05	2016-02-22 12:15:00
05347	Heliconia	05	2016-02-22 12:15:00
05353	Hispania	05	2016-02-22 12:15:00
73001	Ibagué	73	2016-02-22 12:15:00
05360	Itagüi	05	2016-02-22 12:15:00
05364	Jardin	05	2016-02-22 12:15:00
05376	La Ceja	05	2016-02-22 12:15:00
17380	La Dorada	17	2016-02-22 12:15:00
05380	La Etrella	05	2016-02-22 12:15:00
23419	Los Córdobas	23	2016-02-22 12:15:00
05425	Maceo	05	2016-02-22 12:15:00
13430	Magangue	13	2016-02-22 12:15:00
44430	Maicao	44	2016-02-22 12:15:00
17001	Manizales	17	2016-02-22 12:15:00
05440	Marinilla	05	2016-02-22 12:15:00
17444	Marquetalia	17	2016-02-22 12:15:00
23466	Montelíbano	23	2016-02-22 12:15:00
23001	Montería	23	2016-02-22 12:15:00
25483	Nariño	05	2016-02-22 12:15:00
05490	Necocli	05	2016-02-22 12:15:00
17513	Pacora	17	2016-02-22 12:15:00
17541	Pensilvania	17	2016-02-22 12:15:00
05543	Peque	05	2016-02-22 12:15:00
23555	Planeta Rica	23	2016-02-22 12:15:00
47555	Plato	47	2016-02-22 12:15:00
23570	Pueblo Nuevo	23	2016-02-22 12:15:00
05579	Puerto Berrio	05	2016-02-22 12:15:00
05585	Puerto Nare	05	2016-02-22 12:15:00
27001	Quibdo	27	2016-02-22 12:15:00
05604	Remedios	05	2016-02-22 12:15:00
44001	Riohacha	44	2016-02-22 12:15:00
27615	Riosucio	17	2016-02-22 12:15:00
08638	Sabanalarga	05	2016-02-22 12:15:00
05631	Sabaneta	05	2016-02-22 12:15:00
23660	Sahagún	23	2016-02-22 12:15:00
17653	Salamina	17	2016-02-22 12:15:00
05642	Salgar	05	2016-02-22 12:15:00
05647	San Andres de Cuerquia	05	2016-02-22 12:15:00
05656	San Jeronimo	05	2016-02-22 12:15:00
05665	San Pedro de Uraba	05	2016-02-22 12:15:00
05667	San Rafael	05	2016-02-22 12:15:00
05674	San Vicente	05	2016-02-22 12:15:00
47001	Santa Marta	47	2016-02-22 12:15:00
05686	Santa Rosa de Osos	05	2016-02-22 12:15:00
05736	Segovia	05	2016-02-22 12:15:00
70001	Sincelejo	70	2016-02-22 12:15:00
05756	Sonson	05	2016-02-22 12:15:00
05789	Tamesis	05	2016-02-22 12:15:00
05790	Taraza	05	2016-02-22 12:15:00
05792	Tarso	05	2016-02-22 12:15:00
05809	Titiribi	05	2016-02-22 12:15:00
05837	Turbo	05	2016-02-22 12:15:00
05847	Urrao	05	2016-02-22 12:15:00
05854	Valdivia	05	2016-02-22 12:15:00
20001	Valledupar	20	2016-02-22 12:15:00
05856	Valparaiso	05	2016-02-22 12:15:00
44847	Uribia	44	2016-02-23 10:00:00
15368	Jerico	15	2016-02-22 12:15:00
05107	Briceño	05	2016-02-22 12:15:00
05649	San Carlos	05	2016-02-22 12:15:00
05679	Santa Barbara	05	2016-02-22 12:15:00
05697	El Santuario	05	2016-02-22 12:15:00
05079	Barbosa	05	2016-02-22 12:15:00
05093	Betulia	05	2016-02-22 12:15:00
05615	Rionegro	05	2016-02-22 12:15:00
05660	San Luis	05	2016-02-22 12:15:00
05055	Argelia	05	2016-02-22 12:15:00
15106	BRICEÑO	15	2016-02-22 12:15:00
23678	SAN CARLOS	23	2016-02-22 12:15:00
25506	VENECIA	25	2016-02-22 12:15:00
52696	SANTA BARBARA	52	2016-02-22 12:15:00
66687	SANTUARIO	66	2016-02-22 12:15:00
68077	BARBOSA	68	2016-02-22 12:15:00
68092	BETULIA	68	2016-02-22 12:15:00
68615	RIONEGRO	68	2016-02-22 12:15:00
73678	SAN LUIS	73	2016-02-22 12:15:00
76054	ARGELIA	76	2016-02-22 12:15:00
01007	ARGENTINA	01007	2016-03-02 11:00:53
3	Dibulla	44	2014-06-13 11:45:39
4	Distracción	44	2014-06-13 11:45:39
5	El Molino	44	2014-06-13 11:45:39
7	Hatonuevo	44	2014-06-13 11:45:39
8	La Jagua del Pilar	44	2014-06-13 11:45:39
05887	Yarumal	05	2016-02-22 12:15:00
05890	Yolombo	05	2016-02-22 12:15:00
05001	Medellin	05	2016-02-22 12:15:00
44035	Albania	44	2016-02-23 10:00:00
44078	Barrancas	44	2016-02-23 10:00:00
44279	Fonseca	44	2016-02-23 10:00:00
44560	Manaure	44	2016-02-23 10:00:00
44650	San Juan del Cesar	44	2016-02-23 10:00:00
44855	Urumita	44	2016-02-23 10:00:00
44874	Villanueva	44	2016-02-23 10:00:00
08078	Baranoa	08	2016-02-23 10:00:00
08137	Campo de la Cruz	08	2016-02-23 10:00:00
08141	Candelaria	08	2016-02-23 10:00:00
08296	Galapa	08	2016-02-23 10:00:00
08372	Juan de Acosta	08	2016-02-23 10:00:00
70708	San Marcos	70	2016-02-23 10:00:00
13052	Arjona	13	2016-02-23 10:00:00
13074	Barranco de Loba	13	2016-02-23 10:00:00
13140	Calamar	13	2016-02-23 10:00:00
13244	El Carmen de Bolivar	13	2016-02-23 10:00:00
13212	Cordoba	13	2016-02-23 10:00:00
13248	El Guamo	13	2016-02-23 10:00:00
25258	El Peñon	13	2016-02-23 10:00:00
13433	Mahates	13	2016-02-23 10:00:00
13440	Margarita	13	2016-02-23 10:00:00
13442	Maria la Baja	13	2016-02-23 10:00:00
13473	Morales	13	2016-02-23 10:00:00
13549	Pinillos	13	2016-02-23 10:00:00
68575	Puerto Wilches	68	2016-02-23 10:00:00
68655	Sabana de Torres	68	2016-02-23 10:00:00
68895	Zapatoca	68	2016-02-23 10:00:00
68327	Güepsa	68	2016-02-23 10:00:00
68368	Jesus Maria	68	2016-02-23 10:00:00
68377	La  Belleza	68	2016-02-23 10:00:00
68397	La Paz	68	2016-02-23 10:00:00
68572	Puente Nacional	68	2016-02-23 10:00:00
68673	San Benito	68	2016-02-23 10:00:00
68773	Sucre	68	2016-02-23 10:00:00
68861	Velez	68	2016-02-23 10:00:00
66045	Apia	66	2016-02-23 10:00:00
66075	Balboa	66	2016-02-23 10:00:00
66383	La Celia	66	2016-02-23 10:00:00
66456	Mistrato	66	2016-02-23 10:00:00
66572	Pueblo Rico	66	2016-02-23 10:00:00
66594	Quinchia	66	2016-02-23 10:00:00
66682	Santa Rosa de Cabal	66	2016-02-23 10:00:00
76020	Alcalá	76	2016-02-23 10:00:00
76041	Ansermanuevo	76	2016-02-23 10:00:00
76100	Bolívar	76	2016-02-23 10:00:00
76147	Cartago	76	2016-02-23 10:00:00
76243	El Águila	76	2016-02-23 10:00:00
76246	El Cairo	76	2016-02-23 10:00:00
76250	El Dovio	76	2016-02-23 10:00:00
76400	La Unión	76	2016-02-23 10:00:00
76497	Obando	76	2016-02-23 10:00:00
76622	Roldanillo	76	2016-02-23 10:00:00
76823	Toro	76	2016-02-23 10:00:00
76845	Ulloa	76	2016-02-23 10:00:00
76863	Versalles	76	2016-02-23 10:00:00
76895	Zarzal	76	2016-02-23 10:00:00
76036	Andalucía	76	2016-02-23 10:00:00
76111	Buga	76	2016-02-23 10:00:00
76113	Bugalagrande	76	2016-02-23 10:00:00
76248	El Cerrito	76	2016-02-23 10:00:00
76306	Ginebra	76	2016-02-23 10:00:00
76318	Guacarí	76	2016-02-23 10:00:00
76606	Restrepo	76	2016-02-23 10:00:00
76616	Riofrío	76	2016-02-23 10:00:00
76670	San Pedro	76	2016-02-23 10:00:00
76828	Trujillo	76	2016-02-23 10:00:00
76834	Tuluá	76	2016-02-23 10:00:00
76890	Yotoco	76	2016-02-23 10:00:00
76130	Candelaria	76	2016-02-23 10:00:00
76233	Dagua	76	2016-02-23 10:00:00
76275	Florida	76	2016-02-23 10:00:00
76364	Jamundí	76	2016-02-23 10:00:00
76377	La Cumbre	76	2016-02-23 10:00:00
76520	Palmira	76	2016-02-23 10:00:00
76563	Pradera	76	2016-02-23 10:00:00
76892	Yumbo	76	2016-02-23 10:00:00
76122	Caicedonia	76	2016-02-23 10:00:00
76736	Sevilla	76	2016-02-23 10:00:00
76109	Buenaventura	76	2016-02-23 10:00:00
73026	Alvarado	73	2016-02-23 10:00:00
73043	Anzoátegui	73	2016-02-23 10:00:00
73124	Cajamarca	73	2016-02-23 10:00:00
73200	Coello	73	2016-02-23 10:00:00
73268	Espinal	73	2016-02-23 10:00:00
73275	Flandes	73	2016-02-23 10:00:00
73547	Piedras	73	2016-02-23 10:00:00
73624	Rovira	73	2016-02-23 10:00:00
73854	Valle de San Juan	73	2016-02-23 10:00:00
73152	Casabianca	73	2016-02-23 10:00:00
73347	Herveo	73	2016-02-23 10:00:00
73408	Lérida	73	2016-02-23 10:00:00
73461	Murillo	73	2016-02-23 10:00:00
73686	Santa Isabel	73	2016-02-23 10:00:00
73861	Venadillo	73	2016-02-23 10:00:00
73030	Ambalema	73	2016-02-23 10:00:00
73055	Armero	73	2016-02-23 10:00:00
73270	Falan	73	2016-02-23 10:00:00
73283	Fresno	73	2016-02-23 10:00:00
73349	Honda	73	2016-02-23 10:00:00
73443	Mariquita	73	2016-02-23 10:00:00
73148	Carmen de Apicalá	73	2016-02-23 10:00:00
73226	Cunday	73	2016-02-23 10:00:00
73352	Icononzo	73	2016-02-23 10:00:00
73449	Melgar	73	2016-02-23 10:00:00
73873	Villarrica	73	2016-02-23 10:00:00
73067	Ataco	73	2016-02-23 10:00:00
73217	Coyaima	73	2016-02-23 10:00:00
73483	Natagaima	73	2016-02-23 10:00:00
73504	Ortega	73	2016-02-23 10:00:00
05861	Venecia	05	2016-02-22 12:15:00
150	Arenal	13	2014-06-13 11:45:39
152	Arroyohondo	13	2014-06-13 11:45:39
154	Brazuelo de Papapyal	13	2014-06-13 11:45:39
156	Cantagallo	13	2014-06-13 11:45:39
159	Cicuco	13	2014-06-13 11:45:39
160	Clemencia	13	2014-06-13 11:45:39
164	Hatillo de Loba	13	2014-06-13 11:45:39
169	Montecristo	13	2014-06-13 11:45:39
171	Norosi	13	2014-06-13 11:45:39
173	Regidor	13	2014-06-13 11:45:39
68276	Floridablanca	68	2016-02-23 10:00:00
68307	Giron	68	2016-02-23 10:00:00
68406	Lebrija	68	2016-02-23 10:00:00
68418	Los Santos	68	2016-02-23 10:00:00
68573	Puerto Parra	68	2016-02-23 10:00:00
68720	Santa Helena del Opon	68	2016-02-23 10:00:00
68209	Confines	68	2016-02-23 10:00:00
68211	Contratacion	68	2016-02-23 10:00:00
68245	El Guacamayo	68	2016-02-23 10:00:00
68320	Guadalupe	68	2016-02-23 10:00:00
68322	Guapota	68	2016-02-23 10:00:00
68296	Galan	68	2016-02-23 10:00:00
68298	Gambita	68	2016-02-23 10:00:00
68344	Hato	68	2016-02-23 10:00:00
68755	Socorro	68	2016-02-23 10:00:00
68500	Oiba	68	2016-02-23 10:00:00
68522	Palmar	68	2016-02-23 10:00:00
68705	Santa Barbara	68	2016-02-23 10:00:00
68190	Cimitarra	68	2016-02-23 10:00:00
68385	Landazuri	68	2016-02-23 10:00:00
68524	Palmas del Socorro	68	2016-02-23 10:00:00
68745	Simacota	68	2016-02-23 10:00:00
68770	Suaita	68	2016-02-23 10:00:00
68147	Capitanejo	68	2016-02-23 10:00:00
68152	Carcasi	68	2016-02-23 10:00:00
68162	Cerrito	68	2016-02-23 10:00:00
68207	Concepcion	68	2016-02-23 10:00:00
68266	Enciso	68	2016-02-23 10:00:00
68318	Guaca	68	2016-02-23 10:00:00
68425	Macaravita	68	2016-02-23 10:00:00
68432	Malaga	68	2016-02-23 10:00:00
68468	Molagavita	68	2016-02-23 10:00:00
68684	San Jose de Miranda	68	2016-02-23 10:00:00
68686	San Miguel	68	2016-02-23 10:00:00
68051	Aratoca	68	2016-02-23 10:00:00
68079	Barichara	68	2016-02-23 10:00:00
68121	Cabrera	68	2016-02-23 10:00:00
68167	Charala	68	2016-02-23 10:00:00
68160	Cepita	68	2016-02-23 10:00:00
68217	Coromoro	68	2016-02-23 10:00:00
68229	Curiti	68	2016-02-23 10:00:00
68264	Encino	68	2016-02-23 10:00:00
68370	Jordan	68	2016-02-23 10:00:00
68464	Mogotes	68	2016-02-23 10:00:00
68498	Ocamonte	68	2016-02-23 10:00:00
05310	Gomez Plata	05	2016-02-23 10:00:00
05361	Ituango	05	2016-02-23 10:00:00
05658	San Jose de la Montaña	05	2016-02-23 10:00:00
05819	Toledo	05	2016-02-23 10:00:00
05113	Buritica	05	2016-02-23 10:00:00
05125	Caicedo	05	2016-02-23 10:00:00
05138	Cañasgordas	05	2016-02-23 10:00:00
05284	Frontino	05	2016-02-23 10:00:00
05306	Giraldo	05	2016-02-23 10:00:00
05411	Liborina	05	2016-02-23 10:00:00
05501	Olaya	05	2016-02-23 10:00:00
05761	Sopetran	05	2016-02-23 10:00:00
05842	Uramita	05	2016-02-23 10:00:00
73555	Planadas	73	2016-02-23 10:00:00
73616	Rioblanco	73	2016-02-23 10:00:00
73622	Roncesvalles	73	2016-02-23 10:00:00
73675	San Antonio	73	2016-02-23 10:00:00
73024	Alpujarra	73	2016-02-23 10:00:00
73236	Dolores	73	2016-02-23 10:00:00
73319	Guamo	73	2016-02-23 10:00:00
73563	Prado	73	2016-02-23 10:00:00
73770	Suárez	73	2016-02-23 10:00:00
94001	Inírida	94	2016-02-23 10:00:00
94885	La Guadalupe	94	2016-02-23 10:00:00
95220	Morichal Nuevo	94	2016-02-23 10:00:00
94884	Puerto Colombia	94	2016-02-23 10:00:00
25183	Chocontá	25	2016-02-23 10:00:00
25426	Machetá	25	2016-02-23 10:00:00
25436	Manta	25	2016-02-23 10:00:00
25736	Sesquilé	25	2016-02-23 10:00:00
25772	Suesca	25	2016-02-23 10:00:00
05059	Armenia	05	2014-06-13 11:45:39
518	Rionegro	68	2014-06-13 11:45:39
524	Chima	68	2014-06-13 11:45:39
548	San Andres	68	2014-06-13 11:45:39
404	Antioquia	05	2014-06-13 11:45:39
15204	Combita	15	2016-02-23 10:00:00
15224	Cucaita	15	2016-02-23 10:00:00
15187	Chivata	15	2016-02-23 10:00:00
15232	Chiquiza	15	2016-02-23 10:00:00
15476	Motavita	15	2016-02-23 10:00:00
15500	Oicata	15	2016-02-23 10:00:00
15646	Samaca	15	2016-02-23 10:00:00
15740	Siachoque	15	2016-02-23 10:00:00
15762	Sora	15	2016-02-23 10:00:00
15764	Soraca	15	2016-02-23 10:00:00
15763	Sotaquira	15	2016-02-23 10:00:00
15814	Toca	15	2016-02-23 10:00:00
15001	Tunja	15	2016-02-23 10:00:00
15837	Tuta	15	2016-02-23 10:00:00
15861	Ventaquemada	15	2016-02-23 10:00:00
15180	Chiscas	15	2016-02-23 10:00:00
15244	El Cocuy	15	2016-02-23 10:00:00
15248	El Espino	15	2016-02-23 10:00:00
15317	Guacamayas	15	2016-02-23 10:00:00
15332	Güican	15	2016-02-23 10:00:00
15522	Panqueba	15	2016-02-23 10:00:00
15377	Labranzagrande	15	2016-02-23 10:00:00
15518	Pajarito	15	2016-02-23 10:00:00
15533	Paya	15	2016-02-23 10:00:00
15550	Pisba	15	2016-02-23 10:00:00
15090	Berbeo	15	2016-02-23 10:00:00
15135	Campohermoso	15	2016-02-23 10:00:00
15455	Miraflores	15	2016-02-23 10:00:00
15514	Paez	15	2016-02-23 10:00:00
15660	San Eduardo	15	2016-02-23 10:00:00
15897	Zetaquira	15	2016-02-23 10:00:00
15104	Boyaca	15	2016-02-23 10:00:00
15189	Cienega	15	2016-02-23 10:00:00
15367	Jenesano	15	2016-02-23 10:00:00
15494	Nuevo Colon	15	2016-02-23 10:00:00
15599	Ramiriqui	15	2016-02-23 10:00:00
15621	Rondon	15	2016-02-23 10:00:00
15804	Tibana	15	2016-02-23 10:00:00
15835	Turmeque	15	2016-02-23 10:00:00
15842	Umbita	15	2016-02-23 10:00:00
15879	Viracacha	15	2016-02-23 10:00:00
15172	Chinavita	15	2016-02-23 10:00:00
15299	Garagoa	15	2016-02-23 10:00:00
15425	Macanal	15	2016-02-23 10:00:00
15511	Pachavita	15	2016-02-23 10:00:00
15667	San Luis de Gaceno	15	2016-02-23 10:00:00
15690	Santa Maria	15	2016-02-23 10:00:00
15097	Boavita	15	2016-02-23 10:00:00
15218	Covarachia	15	2016-02-23 10:00:00
15403	La  Uvita	15	2016-02-23 10:00:00
15673	San Mateo	15	2016-02-23 10:00:00
15720	Sativanorte	15	2016-02-23 10:00:00
15723	Sativasur	15	2016-02-23 10:00:00
15753	Soata	15	2016-02-23 10:00:00
15774	Susacon	15	2016-02-23 10:00:00
15810	Tipacoque	15	2016-02-23 10:00:00
15131	Caldas	15	2016-02-23 10:00:00
15176	Chiquinquira	15	2016-02-23 10:00:00
15212	Coper	15	2016-02-23 10:00:00
15401	La Victoria	15	2016-02-23 10:00:00
68502	Onzaga	68	2016-02-23 10:00:00
68533	Paramo	68	2016-02-23 10:00:00
68549	Pinchote	68	2016-02-23 10:00:00
68679	San Gil	68	2016-02-23 10:00:00
68682	San Joaquin	68	2016-02-23 10:00:00
68855	Valle de San Jose	68	2016-02-23 10:00:00
68872	Villanueva	68	2016-02-23 10:00:00
702	Briceño	15	2014-06-13 11:45:39
703	Buenavista	15	2014-06-13 11:45:39
570	Betulia	68	2014-06-13 11:45:39
571	El Carmen de Chucuri	68	2014-06-13 11:45:39
574	San Vicente	68	2014-06-13 11:45:39
05368	Jericó	05	2016-02-23 10:00:00
712	Quipama	15	2014-06-13 11:45:39
718	Chivor	15	2014-06-13 11:45:39
741	Gámeza	15	2014-06-13 11:45:39
759	Tutazá	15	2014-06-13 11:45:39
15442	Maripi	15	2016-02-23 10:00:00
15480	Muzo	15	2016-02-23 10:00:00
15507	Otanche	15	2016-02-23 10:00:00
15531	Pauna	15	2016-02-23 10:00:00
15632	Saboya	15	2016-02-23 10:00:00
15676	San Miguel de Sema	15	2016-02-23 10:00:00
15681	San Pablo de Borbur	15	2016-02-23 10:00:00
15832	Tunungua	15	2016-02-23 10:00:00
15022	Almeida	15	2016-02-23 10:00:00
15322	Guateque	15	2016-02-23 10:00:00
15325	Guayata	15	2016-02-23 10:00:00
15380	La Capilla	15	2016-02-23 10:00:00
15761	Somondoco	15	2016-02-23 10:00:00
15778	Sutatenza	15	2016-02-23 10:00:00
15798	Tenza	15	2016-02-23 10:00:00
15051	Arcabuco	15	2016-02-23 10:00:00
15185	Chitaraque	15	2016-02-23 10:00:00
15293	Gachantiva	15	2016-02-23 10:00:00
15469	Moniquira	15	2016-02-23 10:00:00
15600	Raquira	15	2016-02-23 10:00:00
15638	Sachica	15	2016-02-23 10:00:00
15664	San Jose de Pare	15	2016-02-23 10:00:00
15696	Santa Sofia	15	2016-02-23 10:00:00
15686	Santana	15	2016-02-23 10:00:00
15776	Sutamarchan	15	2016-02-23 10:00:00
15808	Tinjaca	15	2016-02-23 10:00:00
15816	Togüi	15	2016-02-23 10:00:00
15407	Villa de Leyva	15	2016-02-23 10:00:00
15047	Aquitania	15	2016-02-23 10:00:00
15226	Cuitiva	15	2016-02-23 10:00:00
15272	Firavitoba	15	2016-02-23 10:00:00
15362	Iza	15	2016-02-23 10:00:00
15464	Mongua	15	2016-02-23 10:00:00
15466	Monguí	15	2016-02-23 10:00:00
15491	Nobsa	15	2016-02-23 10:00:00
15542	Pesca	15	2016-02-23 10:00:00
15759	Sogamoso	15	2016-02-23 10:00:00
15806	Tibasosa	15	2016-02-23 10:00:00
15820	Tópaga	15	2016-02-23 10:00:00
15822	Tota	15	2016-02-23 10:00:00
15087	Belén	15	2016-02-23 10:00:00
15114	Busbanzá	15	2016-02-23 10:00:00
15162	Cerinza	15	2016-02-23 10:00:00
15215	Corrales	15	2016-02-23 10:00:00
15238	Duitama	15	2016-02-23 10:00:00
15276	Floresta	15	2016-02-23 10:00:00
15516	Paipa	15	2016-02-23 10:00:00
15693	Santa Rosa de Viterbo	15	2016-02-23 10:00:00
15092	Betéitiva	15	2016-02-23 10:00:00
15183	Chita	15	2016-02-23 10:00:00
15537	Paz de Río	15	2016-02-23 10:00:00
15755	Socotá	15	2016-02-23 10:00:00
15757	Socha	15	2016-02-23 10:00:00
15790	Tasco	15	2016-02-23 10:00:00
15223	Cubará	15	2016-02-23 10:00:00
63111	Buenavista	63	2016-02-23 10:00:00
63130	Calarcá	63	2016-02-23 10:00:00
63190	Circasia	63	2016-02-23 10:00:00
63212	Córdoba	63	2016-02-23 10:00:00
25807	Tibirita	25	2016-02-23 10:00:00
25873	Villapinzón	25	2016-02-23 10:00:00
25001	Agua de Dios	25	2016-02-23 10:00:00
25307	Girardot	25	2016-02-23 10:00:00
25324	Guataquí	25	2016-02-23 10:00:00
25368	Jerusalén	25	2016-02-23 10:00:00
05483	Nariño	25	2016-02-23 10:00:00
25488	Nilo	25	2016-02-23 10:00:00
25612	Ricaurte	25	2016-02-23 10:00:00
25815	Tocaima	25	2016-02-23 10:00:00
25148	Caparrapí	25	2016-02-23 10:00:00
25320	Guaduas	25	2016-02-23 10:00:00
25572	Puerto Salgar	25	2016-02-23 10:00:00
25019	Albán	25	2016-02-23 10:00:00
25398	La Peña	25	2016-02-23 10:00:00
25402	La Vega	25	2016-02-23 10:00:00
25489	Nimaima	25	2016-02-23 10:00:00
25491	Nocaima	25	2016-02-23 10:00:00
73411	Líbano	73	2016-02-23 10:00:00
25592	Quebradanegra	25	2016-02-23 10:00:00
25658	San Francisco	25	2016-02-23 10:00:00
25718	Sasaima	25	2016-02-23 10:00:00
25777	Supatá	25	2016-02-23 10:00:00
25851	Útica	25	2016-02-23 10:00:00
25862	Vergara	25	2016-02-23 10:00:00
25875	Villeta	25	2016-02-23 10:00:00
25293	Gachalá	25	2016-02-23 10:00:00
25297	Gachetá	25	2016-02-23 10:00:00
25299	Gama	25	2016-02-23 10:00:00
25322	Guasca	25	2016-02-23 10:00:00
25326	Guatavita	25	2016-02-23 10:00:00
25372	Junín	25	2016-02-23 10:00:00
25377	La Calera	25	2016-02-23 10:00:00
25839	Ubalá	25	2016-02-23 10:00:00
25086	Beltrán	25	2016-02-23 10:00:00
25095	Bituima	25	2016-02-23 10:00:00
25168	Chaguaní	25	2016-02-23 10:00:00
25328	Guayabal de Síquima	25	2016-02-23 10:00:00
25580	Pulí	25	2016-02-23 10:00:00
25662	San Juan de Rioseco	25	2016-02-23 10:00:00
25867	Vianí	25	2016-02-23 10:00:00
25438	Medina	25	2016-02-23 10:00:00
25530	Paratebueno	25	2016-02-23 10:00:00
25151	Cáqueza	25	2016-02-23 10:00:00
25178	Chipaque	25	2016-02-23 10:00:00
25181	Choachí	25	2016-02-23 10:00:00
25279	Fómeque	25	2016-02-23 10:00:00
25281	Fosca	25	2016-02-23 10:00:00
25335	Guayabetal	25	2016-02-23 10:00:00
25339	Gutiérrez	25	2016-02-23 10:00:00
25594	Quetame	25	2016-02-23 10:00:00
25841	Ubaque	25	2016-02-23 10:00:00
25845	Une	25	2016-02-23 10:00:00
25394	La Palma	25	2016-02-23 10:00:00
25513	Pacho	25	2016-02-23 10:00:00
25518	Paime	25	2016-02-23 10:00:00
25653	San Cayetano	25	2016-02-23 10:00:00
25823	Topaipí	25	2016-02-23 10:00:00
25871	Villagómez	25	2016-02-23 10:00:00
25885	Yacopí	25	2016-02-23 10:00:00
25126	Cajicá	25	2016-02-23 10:00:00
25200	Cogua	25	2016-02-23 10:00:00
25175	Chía	25	2016-02-23 10:00:00
25295	Gachancipá	25	2016-02-23 10:00:00
25486	Nemocón	25	2016-02-23 10:00:00
25758	Sopó	25	2016-02-23 10:00:00
25785	Tabio	25	2016-02-23 10:00:00
25799	Tenjo	25	2016-02-23 10:00:00
25817	Tocancipá	25	2016-02-23 10:00:00
25899	Zipaquirá	25	2016-02-23 10:00:00
25099	Bojacá	25	2016-02-23 10:00:00
25214	Cota	25	2016-02-23 10:00:00
25269	Facatativá	25	2016-02-23 10:00:00
25286	Funza	25	2016-02-23 10:00:00
25430	Madrid	25	2016-02-23 10:00:00
25473	Mosquera	25	2016-02-23 10:00:00
25769	Subachoque	25	2016-02-23 10:00:00
25898	Zipacón	25	2016-02-23 10:00:00
25740	Sibaté	25	2016-02-23 10:00:00
25754	Soacha	25	2016-02-23 10:00:00
25053	Arbeláez	25	2016-02-23 10:00:00
25120	Cabrera	25	2016-02-23 10:00:00
25290	Fusagasugá	25	2016-02-23 10:00:00
25312	Granada	25	2016-02-23 10:00:00
25524	Pandi	25	2016-02-23 10:00:00
25535	Pasca	25	2016-02-23 10:00:00
25649	San Bernardo	25	2016-02-23 10:00:00
25743	Silvania	25	2016-02-23 10:00:00
25805	Tibacuy	25	2016-02-23 10:00:00
25035	Anapoima	25	2016-02-23 10:00:00
25040	Anolaima	25	2016-02-23 10:00:00
25599	Apulo	25	2016-02-23 10:00:00
25123	Cachipay	25	2016-02-23 10:00:00
25245	Mesitas del Colegio	25	2016-02-23 10:00:00
25386	La Mesa	25	2016-02-23 10:00:00
25596	Quipile	25	2016-02-23 10:00:00
25797	Tena	25	2016-02-23 10:00:00
25878	Viotá	25	2016-02-23 10:00:00
25154	Carmen de Carupa	25	2016-02-23 10:00:00
25224	Cucunubá	25	2016-02-23 10:00:00
25288	Fúquene	25	2016-02-23 10:00:00
25317	Guachetá	25	2016-02-23 10:00:00
25407	Lenguazaque	25	2016-02-23 10:00:00
25745	Simijaca	25	2016-02-23 10:00:00
25779	Susa	25	2016-02-23 10:00:00
25781	Sutatausa	25	2016-02-23 10:00:00
25793	Tausa	25	2016-02-23 10:00:00
25843	Ubaté	25	2016-02-23 10:00:00
41016	Aipe	41	2016-02-23 10:00:00
41020	Algeciras	41	2016-02-23 10:00:00
41078	Baraya	41	2016-02-23 10:00:00
41132	Campoalegre	41	2016-02-23 10:00:00
41349	Hobo	41	2016-02-23 10:00:00
41357	Íquira	41	2016-02-23 10:00:00
41001	Neiva	41	2016-02-23 10:00:00
41524	Palermo	41	2016-02-23 10:00:00
41615	Rivera	41	2016-02-23 10:00:00
41676	Santa María	41	2016-02-23 10:00:00
41799	Tello	41	2016-02-23 10:00:00
41801	Teruel	41	2016-02-23 10:00:00
41872	Villavieja	41	2016-02-23 10:00:00
41885	Yaguará	41	2016-02-23 10:00:00
41026	Altamira	41	2016-02-23 10:00:00
41551	Pitalito	41	2016-02-23 10:00:00
41660	Saladoblanco	41	2016-02-23 10:00:00
41668	San Agustín	41	2016-02-23 10:00:00
41807	Timaná	41	2016-02-23 10:00:00
08421	Luruaco	08	2016-02-23 10:00:00
08433	Malambo	08	2016-02-23 10:00:00
08436	Manatí	08	2016-02-23 10:00:00
08520	Palmar de Varela	08	2016-02-23 10:00:00
08549	Piojó	08	2016-02-23 10:00:00
08558	Polonuevo	08	2016-02-23 10:00:00
08560	Ponedera	08	2016-02-23 10:00:00
08573	Puerto Colombia	08	2016-02-23 10:00:00
08606	Repelón	08	2016-02-23 10:00:00
08634	Sabanagrande	08	2016-02-23 10:00:00
08675	Santa Lucía	08	2016-02-23 10:00:00
08685	Santo Tomás	08	2016-02-23 10:00:00
08758	Soledad	08	2016-02-23 10:00:00
08770	Suán	08	2016-02-23 10:00:00
08832	Tubará	08	2016-02-23 10:00:00
08849	Usiacurí	08	2016-02-23 10:00:00
47053	Aracataca	47	2016-02-23 10:00:00
47058	Ariguaní	47	2016-02-23 10:00:00
47161	Cerro de San Antonio	47	2016-02-23 10:00:00
47170	Chibolo	47	2016-02-23 10:00:00
47189	Ciénaga	47	2016-02-23 10:00:00
47245	El Banco	47	2016-02-23 10:00:00
47258	El Piñón	47	2016-02-23 10:00:00
47288	Fundación	47	2016-02-23 10:00:00
47541	Pedraza	47	2016-02-23 10:00:00
47551	Pivijay	47	2016-02-23 10:00:00
47570	Pueblo Viejo	47	2016-02-23 10:00:00
47605	Remolino	47	2016-02-23 10:00:00
47692	San Sebastián de Buenavista	47	2016-02-23 10:00:00
47703	San Zenón	47	2016-02-23 10:00:00
47707	Santa Ana	47	2016-02-23 10:00:00
47745	Sitionuevo	47	2016-02-23 10:00:00
47798	Tenerife	47	2016-02-23 10:00:00
20011	Aguachica	20	2016-02-23 10:00:00
20013	Agustín Codazzi	20	2016-02-23 10:00:00
20228	Curumaní	20	2016-02-23 10:00:00
20178	Chiriguaná	20	2016-02-23 10:00:00
20060	Bosconia	20	2016-02-23 10:00:00
20238	El Copey	20	2016-02-23 10:00:00
20621	La Paz	20	2016-02-23 10:00:00
20400	La Jagua de Ibirico	20	2016-02-23 10:00:00
20032	Astrea	20	2016-02-23 10:00:00
20710	San Alberto	20	2016-02-23 10:00:00
20770	San Martín	20	2016-02-23 10:00:00
20250	El Paso	20	2016-02-23 10:00:00
20550	Pelaya	20	2016-02-23 10:00:00
20045	Becerril	20	2016-02-23 10:00:00
20614	Río de Oro	20	2016-02-23 10:00:00
20517	Pailitas	20	2016-02-23 10:00:00
20750	San Diego	20	2016-02-23 10:00:00
20295	Gamarra	20	2016-02-23 10:00:00
20383	La Gloria	20	2016-02-23 10:00:00
20787	Tamalameque	20	2016-02-23 10:00:00
20175	Chimichagua	20	2016-02-23 10:00:00
20443	Manaure Balcón del Cesar	20	2016-02-23 10:00:00
20310	González	20	2016-02-23 10:00:00
23079	Buenavista	23	2016-02-23 10:00:00
23090	Canalete	23	2016-02-23 10:00:00
23189	Ciénaga de Oro	23	2016-02-23 10:00:00
23464	Momil	23	2016-02-23 10:00:00
23500	Moñitos	23	2016-02-23 10:00:00
23580	Puerto Libertador	23	2016-02-23 10:00:00
23586	Purísima	23	2016-02-23 10:00:00
23670	San Andrés de Sotavento	23	2016-02-23 10:00:00
23672	San Antero	23	2016-02-23 10:00:00
23675	San Bernardo del Viento	23	2016-02-23 10:00:00
23686	San Pelayo	23	2016-02-23 10:00:00
23807	Tierralta	23	2016-02-23 10:00:00
23855	Valencia	23	2016-02-23 10:00:00
70429	Majagual	70	2016-02-23 10:00:00
70230	Chalán	70	2016-02-23 10:00:00
70204	Coloso	70	2016-02-23 10:00:00
70473	Morroa	70	2016-02-23 10:00:00
70508	Ovejas	70	2016-02-23 10:00:00
70523	Palmito	70	2016-02-23 10:00:00
70713	San Onofre	70	2016-02-23 10:00:00
70820	Santiago de Tolú	70	2016-02-23 10:00:00
70823	Tolúviejo	70	2016-02-23 10:00:00
70235	Galeras	70	2016-02-23 10:00:00
70418	Los Palmitos	70	2016-02-23 10:00:00
70670	Sampués	70	2016-02-23 10:00:00
70702	San Juan de Betulia	70	2016-02-23 10:00:00
70717	San Pedro	70	2016-02-23 10:00:00
70742	Sincé	70	2016-02-23 10:00:00
70124	Caimito	70	2016-02-23 10:00:00
54720	Sardinata	54	2016-02-23 10:00:00
54261	El Zulia	54	2016-02-23 10:00:00
54405	Los Patios	54	2016-02-23 10:00:00
54553	Puerto Santander	54	2016-02-23 10:00:00
54673	San Cayetano	54	2016-02-23 10:00:00
54874	Villa del Rosario	54	2016-02-23 10:00:00
54125	Cacota	54	2016-02-23 10:00:00
54174	Chitaga	54	2016-02-23 10:00:00
54480	Mutiscua	54	2016-02-23 10:00:00
54518	Pamplona	54	2016-02-23 10:00:00
54520	Pamplonita	54	2016-02-23 10:00:00
54051	Arboledas	54	2016-02-23 10:00:00
54223	Cucutilla	54	2016-02-23 10:00:00
54313	Gramalote	54	2016-02-23 10:00:00
54418	Lourdes	54	2016-02-23 10:00:00
54660	Salazar de Las Palmas	54	2016-02-23 10:00:00
54680	Santiago	54	2016-02-23 10:00:00
54871	Villa Caro	54	2016-02-23 10:00:00
54099	Bochalema	54	2016-02-23 10:00:00
54172	Chinacota	54	2016-02-23 10:00:00
54239	Durania	54	2016-02-23 10:00:00
54347	Herran	54	2016-02-23 10:00:00
54377	Labateca	54	2016-02-23 10:00:00
54599	Ragonvalia	54	2016-02-23 10:00:00
54820	Toledo	54	2016-02-23 10:00:00
27025	Alto Baudo	27	2016-02-23 10:00:00
27073	Bagado	27	2016-02-23 10:00:00
27075	Bahia Solano	27	2016-02-23 10:00:00
27077	Bajo Baudo	27	2016-02-23 10:00:00
27245	El Carmen de Atrato	27	2016-02-23 10:00:00
27361	Istmina	27	2016-02-23 10:00:00
27372	Jurado	27	2016-02-23 10:00:00
27413	Lloro	27	2016-02-23 10:00:00
27430	Medio Baudo	27	2016-02-23 10:00:00
27450	Medio San Juan	27	2016-02-23 10:00:00
27491	Novita	27	2016-02-23 10:00:00
27495	Nuqui	27	2016-02-23 10:00:00
27580	Rio Iro	27	2016-02-23 10:00:00
27600	Rio Quito	27	2016-02-23 10:00:00
27660	San Jose del Palmar	27	2016-02-23 10:00:00
27745	Sipi	27	2016-02-23 10:00:00
27787	Tado	27	2016-02-23 10:00:00
27800	Unguia	27	2016-02-23 10:00:00
27810	Union Panamericana	27	2016-02-23 10:00:00
05495	Nechi	05	2016-02-23 10:00:00
05895	Zaragoza	05	2016-02-23 10:00:00
05142	Caracoli	05	2016-02-23 10:00:00
05591	Puerto Triunfo	05	2016-02-23 10:00:00
05893	Yondo	05	2016-02-23 10:00:00
05664	San Pedro de los Milagros	05	2016-02-23 10:00:00
05670	San Roque	05	2016-02-23 10:00:00
05690	Santo Domingo	05	2016-02-23 10:00:00
05858	Vegachi	05	2016-02-23 10:00:00
05885	Yali	05	2016-02-23 10:00:00
05038	Angostura	05	2016-02-23 10:00:00
05206	Concepcion	05	2016-02-23 10:00:00
05321	Guatape	05	2016-02-23 10:00:00
05400	La Union	05	2016-02-23 10:00:00
05652	San Francisco	05	2016-02-23 10:00:00
05390	La Pintada	05	2016-02-23 10:00:00
05467	Montebello	05	2016-02-23 10:00:00
05576	Pueblorrico	05	2016-02-23 10:00:00
05051	Arboletes	05	2016-02-23 10:00:00
05475	Murindo	05	2016-02-23 10:00:00
05480	Mutata	05	2016-02-23 10:00:00
05659	San Juan de Uraba	05	2016-02-23 10:00:00
05873	Vigia del Fuerte	05	2016-02-23 10:00:00
19807	Timbío	19	2016-02-23 10:00:00
19022	Almaguer	19	2016-02-23 10:00:00
19050	Argelia	19	2016-02-23 10:00:00
19075	Balboa	19	2016-02-23 10:00:00
19100	Bolívar	19	2016-02-23 10:00:00
19290	Florencia	19	2016-02-23 10:00:00
19397	La Vega	19	2016-02-23 10:00:00
19450	Mercaderes	19	2016-02-23 10:00:00
19532	Patía	19	2016-02-23 10:00:00
19533	Piamonte	19	2016-02-23 10:00:00
19693	San Sebastián	19	2016-02-23 10:00:00
19701	Santa Rosa	19	2016-02-23 10:00:00
19785	Sucre	19	2016-02-23 10:00:00
01484	ARUBA	1484	2016-02-22 12:15:00
01027	AUSTRALIA	1027	2016-02-22 12:15:00
01012	BRASIL	1012	2016-02-22 12:15:00
01004	CIUDAD DE PANAMA	1004	2016-02-22 12:15:00
41206	COLOMBIA	1000	2016-02-22 12:15:00
01485	BARBADOS	1485	2016-02-23 10:00:00
01001	CANADA	1001	2016-02-23 10:00:00
01020	CHILE	1020	2016-02-23 10:00:00
01034	CHINA	1034	2016-02-23 10:00:00
01037	CUBA	1037	2016-02-23 10:00:00
01019	ECUADOR	1019	2016-02-23 10:00:00
01003	ESPANA	1003	2016-02-23 10:00:00
01030	FILIPINAS	1030	2016-02-23 10:00:00
01040	FRANCIA	1040	2016-02-23 10:00:00
01033	GUATEMALA	1033	2016-02-23 10:00:00
01006	HOLANDA	1006	2016-02-23 10:00:00
01016	HONDURAS	1016	2016-02-23 10:00:00
01014	INDIA	1014	2016-02-23 10:00:00
01018	INGLATERRA	1018	2016-02-23 10:00:00
01010	ISRAEL	1010	2016-02-23 10:00:00
01023	JAPON	1023	2016-02-23 10:00:00
01032	JORDANIA	1032	2016-02-23 10:00:00
01031	KOREA	1031	2016-02-23 10:00:00
01011	LIBANO	1011	2016-02-23 10:00:00
01025	MEXICO	1025	2016-02-23 10:00:00
01022	MIAMI FLORIDA	1022	2016-02-23 10:00:00
01013	PARAGUAY	1013	2016-02-23 10:00:00
01028	PERU	1028	2016-02-23 10:00:00
01035	POLONIA	1035	2016-02-23 10:00:00
18029	Albania	18	2016-02-23 10:00:00
18094	Belén de los Andaquies	18	2016-02-23 10:00:00
18247	El Doncello	18	2016-02-23 10:00:00
18256	El Paujil	18	2016-02-23 10:00:00
18001	Florencia	18	2016-02-23 10:00:00
18410	La Montañita	18	2016-02-23 10:00:00
18479	Morelia	18	2016-02-23 10:00:00
18765	Solano	18	2016-02-23 10:00:00
18767	Solita	18	2016-02-23 10:00:00
52287	Funes	52	2016-02-23 10:00:00
19318	Guapí	19	2016-02-23 10:00:00
19809	Timbiquí	19	2016-02-23 10:00:00
19137	Caldonó	19	2016-02-23 10:00:00
19355	Inzá	19	2016-02-23 10:00:00
19364	Jambaló	19	2016-02-23 10:00:00
19517	Páez	19	2016-02-23 10:00:00
19585	Puracé	19	2016-02-23 10:00:00
19743	Silvia	19	2016-02-23 10:00:00
19821	Toribío	19	2016-02-23 10:00:00
19824	Totoró	19	2016-02-23 10:00:00
50006	Acacías	50	2016-02-23 10:00:00
50110	Barranca de Upía	50	2016-02-23 10:00:00
50124	Cabuyaro	50	2016-02-23 10:00:00
50150	Castilla La Nueva	50	2016-02-23 10:00:00
50223	Cubarral	50	2016-02-23 10:00:00
50226	Cumaral	50	2016-02-23 10:00:00
50245	El Calvario	50	2016-02-23 10:00:00
50251	El Castillo	50	2016-02-23 10:00:00
50270	El Dorado	50	2016-02-23 10:00:00
50287	Fuente de Oro	50	2016-02-23 10:00:00
50313	Granada	50	2016-02-23 10:00:00
50350	La Macarena	50	2016-02-23 10:00:00
50370	La Uribe	50	2016-02-23 10:00:00
50400	Lejanías	50	2016-02-23 10:00:00
94663	Mapiripán	50	2016-02-23 10:00:00
50330	Mesetas	50	2016-02-23 10:00:00
50450	Puerto Concordia	50	2016-02-23 10:00:00
50568	Puerto Gaitán	50	2016-02-23 10:00:00
50577	Puerto Lleras	50	2016-02-23 10:00:00
50573	Puerto López	50	2016-02-23 10:00:00
50606	Restrepo	50	2016-02-23 10:00:00
50680	San Carlos de Guaroa	50	2016-02-23 10:00:00
50683	San Juan de Arama	50	2016-02-23 10:00:00
50686	San Juanito	50	2016-02-23 10:00:00
50689	San Martín	50	2016-02-23 10:00:00
50001	Villavicencio	50	2016-02-23 10:00:00
50711	Vista Hermosa	50	2016-02-23 10:00:00
52022	Aldana	52	2016-02-23 10:00:00
52036	Ancuyá	52	2016-02-23 10:00:00
52051	Arboleda	52	2016-02-23 10:00:00
52079	Barbacoas	52	2016-02-23 10:00:00
52083	Belén	52	2016-02-23 10:00:00
52110	Buesaco	52	2016-02-23 10:00:00
52240	Chachagüí	52	2016-02-23 10:00:00
52203	Colón	52	2016-02-23 10:00:00
52207	Consacá	52	2016-02-23 10:00:00
52210	Contadero	52	2016-02-23 10:00:00
52215	Córdoba	52	2016-02-23 10:00:00
52224	Cuaspud	52	2016-02-23 10:00:00
52227	Cumbal	52	2016-02-23 10:00:00
52233	Cumbitara	52	2016-02-23 10:00:00
52250	El Charco	52	2016-02-23 10:00:00
52254	El Peñol	52	2016-02-23 10:00:00
52256	El Rosario	52	2016-02-23 10:00:00
52258	El Tablón de Gómez	52	2016-02-23 10:00:00
52260	El Tambo	52	2016-02-23 10:00:00
01017	Puerto Rico	1017	2016-02-23 10:00:00
1192	Curillo	18	2014-06-13 11:45:39
1198	Puerto Milán	18	2014-06-13 11:45:39
1199	Puerto Rico	18	2014-06-13 11:45:39
1200	San José del Fragua	18	2014-06-13 11:45:39
1201	San Vicente del Caguán	18	2014-06-13 11:45:39
1205	Valparaíso	18	2014-06-13 11:45:39
1280	PUERTO RICO	1017	2014-06-13 11:45:39
01009	ALEMANIA	1009	2016-02-22 12:15:00
63001	Armenia	63	2016-02-22 12:15:00
68081	Barrancabermeja	68	2016-02-22 12:15:00
01015	COSTA RICA	1015	2016-02-22 12:15:00
11015	CURACAO	1024	2016-02-22 12:15:00
01002	EE.UU	1002	2016-02-22 12:15:00
01005	ITALIA	1005	2016-02-22 12:15:00
01021	LONDRES	1021	2016-02-22 12:15:00
15572	Puerto Boyacá	15	2016-02-22 12:15:00
01038	REPUBLICA DOMINICANA	1038	2016-02-22 12:15:00
01041	PORTUGAL	1041	2016-02-23 10:00:00
01039	RUMANIA	1039	2016-02-23 10:00:00
01036	SUECIA	1036	2016-02-23 10:00:00
01008	SUIZA	1008	2016-02-23 10:00:00
01029	URUGUAY	1029	2016-02-23 10:00:00
01026	YUGOESLAVIA	1026	2016-02-23 10:00:00
52520	Francisco Pizarro	52	2016-02-23 10:00:00
52317	Guachucal	52	2016-02-23 10:00:00
52320	Guaitarilla	52	2016-02-23 10:00:00
52323	Gualmatán	52	2016-02-23 10:00:00
52352	Iles	52	2016-02-23 10:00:00
52354	Imués	52	2016-02-23 10:00:00
52356	Ipiales	52	2016-02-23 10:00:00
52378	La Cruz	52	2016-02-23 10:00:00
52381	La Florida	52	2016-02-23 10:00:00
52385	La Llanada	52	2016-02-23 10:00:00
52390	La Tola	52	2016-02-23 10:00:00
52399	La Unión	52	2016-02-23 10:00:00
52405	Leiva	52	2016-02-23 10:00:00
52411	Linares	52	2016-02-23 10:00:00
52418	Los Andes	52	2016-02-23 10:00:00
52427	Magüí	52	2016-02-23 10:00:00
52435	Mallama	52	2016-02-23 10:00:00
52473	Mosquera	52	2016-02-23 10:00:00
52480	Nariño	52	2016-02-23 10:00:00
52490	Olaya Herrera	52	2016-02-23 10:00:00
52506	Ospina	52	2016-02-23 10:00:00
52540	Policarpa	52	2016-02-23 10:00:00
52560	Potosí	52	2016-02-23 10:00:00
52565	Providencia	52	2016-02-23 10:00:00
52573	Puerres	52	2016-02-23 10:00:00
52585	Pupiales	52	2016-02-23 10:00:00
52612	Ricaurte	52	2016-02-23 10:00:00
52621	Roberto Payán	52	2016-02-23 10:00:00
52678	Samaniego	52	2016-02-23 10:00:00
52685	San Bernardo	52	2016-02-23 10:00:00
52687	San Lorenzo	52	2016-02-23 10:00:00
52693	San Pablo	52	2016-02-23 10:00:00
52694	San Pedro de Cartago	52	2016-02-23 10:00:00
52683	Sandoná	52	2016-02-23 10:00:00
52699	Santacruz	52	2016-02-23 10:00:00
52720	Sapuyes	52	2016-02-23 10:00:00
52786	Taminango	52	2016-02-23 10:00:00
52788	Tangua	52	2016-02-23 10:00:00
52835	Tumaco	52	2016-02-23 10:00:00
52838	Túquerres	52	2016-02-23 10:00:00
52885	Yacuanquer	52	2016-02-23 10:00:00
95015	Calamar	95	2016-02-23 10:00:00
95025	El Retorno	95	2016-02-23 10:00:00
95200	Miraflores	95	2016-02-23 10:00:00
95001	San José del Guaviare	95	2016-02-23 10:00:00
97161	Carurú	97	2016-02-23 10:00:00
97001	Mitú	97	2016-02-23 10:00:00
97511	Pacoa	97	2016-02-23 10:00:00
97777	Papunaua	97	2016-02-23 10:00:00
97666	Taraira	97	2016-02-23 10:00:00
97889	Yavaraté	97	2016-02-23 10:00:00
86001	Mocoa	86	2016-02-23 10:00:00
86571	Puerto Guzmán	86	2016-02-23 10:00:00
86760	Santiago	86	2016-02-23 10:00:00
86219	Colón	86	2016-02-23 10:00:00
86573	Puerto Leguízamo	86	2016-02-23 10:00:00
86865	Valle del Guamuez	86	2016-02-23 10:00:00
86320	Orito	86	2016-02-23 10:00:00
86749	Sibundoy	86	2016-02-23 10:00:00
86885	Villagarzón	86	2016-02-23 10:00:00
86568	Puerto Asís	86	2016-02-23 10:00:00
86755	San Francisco	86	2016-02-23 10:00:00
86569	Puerto Caycedo	86	2016-02-23 10:00:00
86757	San Miguel	86	2016-02-23 10:00:00
91460	Mirití-Paraná	91	2016-02-23 10:00:00
68001	Bucaramanga	68	2016-02-22 12:15:00
76001	Cali	76	2016-02-22 12:15:00
68132	California	68	2016-02-22 12:15:00
66170	Desquebradas	66	2016-02-22 12:15:00
66318	Guatica	66	2016-02-22 12:15:00
66400	La Virginia	66	2016-02-22 12:15:00
66001	Pereira	66	2016-02-22 12:15:00
68547	Piedecuesta	68	2016-02-22 12:15:00
63272	Filandia	63	2016-02-23 10:00:00
63302	Génova	63	2016-02-23 10:00:00
63401	La Tebaida	63	2016-02-23 10:00:00
63470	Montenegro	63	2016-02-23 10:00:00
63548	Pijao	63	2016-02-23 10:00:00
63594	Quimbaya	63	2016-02-23 10:00:00
63690	Salento	63	2016-02-23 10:00:00
68169	Charta	68	2016-02-23 10:00:00
68255	El Playon	68	2016-02-23 10:00:00
68444	Matanza	68	2016-02-23 10:00:00
584	Barbosa	68	2014-06-13 11:45:39
585	Bolivar	68	2014-06-13 11:45:39
607	Belen de Ubria	66	2014-06-13 11:45:39
612	Masarella	66	2014-06-13 11:45:39
618	Santuario	66	2014-06-13 11:45:39
790	Argelia	76	2014-06-13 11:45:39
797	La Victoria	76	2014-06-13 11:45:39
807	Darién	76	2014-06-13 11:45:39
826	Vijes	76	2014-06-13 11:45:39
851	San Luis	73	2014-06-13 11:45:39
860	Villahermosa	73	2014-06-13 11:45:39
867	Palocabildo	73	2014-06-13 11:45:39
68780	Surata	68	2016-02-23 10:00:00
68820	Tona	68	2016-02-23 10:00:00
68867	Vetas	68	2016-02-23 10:00:00
68020	Albania	68	2016-02-23 10:00:00
68179	Chipata	68	2016-02-23 10:00:00
68250	El Peñon	68	2016-02-23 10:00:00
68271	Florian	68	2016-02-23 10:00:00
68324	Guavata	68	2016-02-23 10:00:00
73585	Purificación	73	2016-02-23 10:00:00
73671	Saldaña	73	2016-02-23 10:00:00
1117	Barrancominas	94	2014-06-13 11:45:39
1118	Cacahual	94	2014-06-13 11:45:39
1121	Mapiripana	94	2014-06-13 11:45:39
1123	Pana Pana	94	2014-06-13 11:45:39
1125	San Felipe	94	2014-06-13 11:45:39
946	El Peñón	25	2014-06-13 11:45:39
966	El Rosal	25	2014-06-13 11:45:39
984	Venecia	25	2014-06-13 11:45:39
992	San Antonio del Tequendama	25	2014-06-13 11:45:39
1055	Colombia	41	2014-06-13 11:45:39
1067	Agrado	41	2014-06-13 11:45:39
41298	Garzón	41	2016-02-23 10:00:00
41306	Gigante	41	2016-02-23 10:00:00
32	Sabanalarga	08	2014-06-13 11:45:39
41548	Pital	41	2016-02-23 10:00:00
39	Algarrobo	47	2014-06-13 11:45:39
45	Concordia	47	2014-06-13 11:45:39
48	El Retén	47	2014-06-13 11:45:39
51	Nueva Granada	47	2014-06-13 11:45:39
53	Pijiño del Carmen	47	2014-06-13 11:45:39
58	Sabanas de San Angel	47	2014-06-13 11:45:39
59	Salamina	47	2014-06-13 11:45:39
63	Santa Bárbara de Pinto	47	2014-06-13 11:45:39
67	Zapayán	47	2014-06-13 11:45:39
68	Zona Bananera	47	2014-06-13 11:45:39
41319	Guadalupe	41	2016-02-23 10:00:00
41791	Tarqui	41	2016-02-23 10:00:00
41770	Suaza	41	2016-02-23 10:00:00
89	Pueblo Bello	20	2014-06-13 11:45:39
41378	La Argentina3	41	2016-02-23 10:00:00
101	Cotorra	23	2014-06-13 11:45:39
102	La Apartada	23	2014-06-13 11:45:39
117	San Carlos	23	2014-06-13 11:45:39
118	San José de Uré	23	2014-06-13 11:45:39
120	Santa Cruz de Lorica	23	2014-06-13 11:45:39
122	Tuchín	23	2014-06-13 11:45:39
41396	La Plata	41	2016-02-23 10:00:00
41483	Nátaga	41	2016-02-23 10:00:00
41518	Paicol	41	2016-02-23 10:00:00
41797	Tesalia	41	2016-02-23 10:00:00
41006	Acevedo	41	2016-02-23 10:00:00
41244	Elías	41	2016-02-23 10:00:00
41359	Isnos	41	2016-02-23 10:00:00
41503	Oporapa	41	2016-02-23 10:00:00
41530	Palestina	41	2016-02-23 10:00:00
124	Guaranda	70	2014-06-13 11:45:39
126	Sucre	70	2014-06-13 11:45:39
132	Coveñas	70	2014-06-13 11:45:39
139	El Roble	70	2014-06-13 11:45:39
70400	La Unión	70	2016-02-23 10:00:00
70678	San Benito Abad	70	2016-02-23 10:00:00
13600	Rio Viejo	13	2016-02-23 10:00:00
175	San Cristobal	13	2014-06-13 11:45:39
179	San Jacinoto del Cauca	13	2014-06-13 11:45:39
184	Santa Cruz de Mompox	13	2014-06-13 11:45:39
190	Tiquisio	13	2014-06-13 11:45:39
13647	San Estanislao	13	2016-02-23 10:00:00
13650	San Fernando	13	2016-02-23 10:00:00
208	La Esperanza	54	2014-06-13 11:45:39
215	El Tarra	54	2014-06-13 11:45:39
229	Santo Domingo de Silios	54	2014-06-13 11:45:39
13654	San Jacinto	13	2016-02-23 10:00:00
246	Atrato	27	2014-06-13 11:45:39
251	Canton de San Pablo	27	2014-06-13 11:45:39
253	Certegui	27	2014-06-13 11:45:39
255	El Carmen del Darien	27	2014-06-13 11:45:39
258	Litoral de San Juan	27	2014-06-13 11:45:39
260	Medio Atrato	27	2014-06-13 11:45:39
266	Riosucio	27	2014-06-13 11:45:39
13657	San Juan Nepomuceno	13	2016-02-23 10:00:00
13667	San Martin de Loba	13	2016-02-23 10:00:00
13670	San Pablo	13	2016-02-23 10:00:00
13673	Santa Catalina	13	2016-02-23 10:00:00
13683	Santa Rosa	13	2016-02-23 10:00:00
13688	Santa Rosa del Sur	13	2016-02-23 10:00:00
13744	Simiti	13	2016-02-23 10:00:00
13760	Soplaviento	13	2016-02-23 10:00:00
13780	Talaigua Nuevo	13	2016-02-23 10:00:00
13836	Turbaco	13	2016-02-23 10:00:00
13838	Turbana	13	2016-02-23 10:00:00
13873	Villanueva	13	2016-02-23 10:00:00
13894	Zambrano	13	2016-02-23 10:00:00
54003	Abrego	54	2016-02-23 10:00:00
54128	Cachira	54	2016-02-23 10:00:00
54206	Convencion	54	2016-02-23 10:00:00
68235	El Carmen	54	2016-02-23 10:00:00
54344	Hacari	54	2016-02-23 10:00:00
54398	La Playa de Belen	54	2016-02-23 10:00:00
54498	Ocaña	54	2016-02-23 10:00:00
54670	San Calixto	54	2016-02-23 10:00:00
54800	Teorama	54	2016-02-23 10:00:00
54109	Bucarasica	54	2016-02-23 10:00:00
54810	Tibu	54	2016-02-23 10:00:00
81001	Arauca	81	2016-02-23 10:00:00
81065	Arauquita	81	2016-02-23 10:00:00
81220	Cravo Norte	81	2016-02-23 10:00:00
81300	Fortul	81	2016-02-23 10:00:00
81591	Puerto Rondon	81	2016-02-23 10:00:00
81736	Saravena	81	2016-02-23 10:00:00
81794	Tame	81	2016-02-23 10:00:00
17662	Samana	17	2016-02-23 10:00:00
17867	Victoria	17	2016-02-23 10:00:00
17495	Norcasia	17	2016-02-23 10:00:00
17433	Manzanares	17	2016-02-23 10:00:00
17446	Marulanda	17	2016-02-23 10:00:00
17013	Aguadas	17	2016-02-23 10:00:00
17050	Aranzazu	17	2016-02-23 10:00:00
17777	Supia	17	2016-02-23 10:00:00
17388	La Merced	17	2016-02-23 10:00:00
17442	Marmato	17	2016-02-23 10:00:00
17272	Filadelfia	17	2016-02-23 10:00:00
17486	Neira	17	2016-02-23 10:00:00
17873	Villamaria	17	2016-02-23 10:00:00
17524	Palestina	17	2016-02-23 10:00:00
17877	Viterbo	17	2016-02-23 10:00:00
17088	Belalcazar	17	2016-02-23 10:00:00
17665	San Jose	17	2016-02-23 10:00:00
17616	Risaralda	17	2016-02-23 10:00:00
17042	Anserma	17	2016-02-23 10:00:00
85010	Aguazul	85	2016-02-23 10:00:00
85015	Chámeza	85	2016-02-23 10:00:00
85125	Hato Corozal	85	2016-02-23 10:00:00
85136	La Salina	85	2016-02-23 10:00:00
85139	Maní	85	2016-02-23 10:00:00
85162	Monterrey	85	2016-02-23 10:00:00
85225	Nunchía	85	2016-02-23 10:00:00
85230	Orocué	85	2016-02-23 10:00:00
85250	Paz de Ariporo	85	2016-02-23 10:00:00
85263	Pore	85	2016-02-23 10:00:00
85279	Recetor	85	2016-02-23 10:00:00
85300	Sabanalarga	85	2016-02-23 10:00:00
85315	Sácama	85	2016-02-23 10:00:00
85325	San Luis de Palenque	85	2016-02-23 10:00:00
85400	Támara	85	2016-02-23 10:00:00
85410	Tauramena	85	2016-02-23 10:00:00
85430	Trinidad	85	2016-02-23 10:00:00
85440	Villanueva	85	2016-02-23 10:00:00
85001	Yopal	85	2016-02-23 10:00:00
99773	Cumaribo	99	2016-02-23 10:00:00
99524	La Primavera	99	2016-02-23 10:00:00
99001	Puerto Carreño	99	2016-02-23 10:00:00
99624	Santa Rosalía	99	2016-02-23 10:00:00
19110	Buenos Aires	19	2016-02-23 10:00:00
19142	Caloto	19	2016-02-23 10:00:00
19212	Corinto	19	2016-02-23 10:00:00
19300	Guachené	19	2016-02-23 10:00:00
19455	Miranda	19	2016-02-23 10:00:00
19513	Padilla	19	2016-02-23 10:00:00
19573	Puerto Tejada	19	2016-02-23 10:00:00
19698	Santander de Quilichao	19	2016-02-23 10:00:00
19780	Suárez	19	2016-02-23 10:00:00
19845	Villa Rica	19	2016-02-23 10:00:00
19130	Cajibío	19	2016-02-23 10:00:00
19256	El Tambo	19	2016-02-23 10:00:00
19392	La Sierra	19	2016-02-23 10:00:00
19473	Morales	19	2016-02-23 10:00:00
19548	Piendamó	19	2016-02-23 10:00:00
19001	Popayán	19	2016-02-23 10:00:00
19622	Rosas	19	2016-02-23 10:00:00
19760	Sotará	19	2016-02-23 10:00:00
1041	López de Micay	19	2014-06-13 11:45:39
1099	Guamal	50	2014-06-13 11:45:39
1176	San José de Albán	52	2014-06-13 11:45:39
1177	San Juan de Pasto	52	2014-06-13 11:45:39
1182	Santa Bárbara	52	2014-06-13 11:45:39
1242	Isla de Santa Catalina	88	2014-06-13 11:45:39
0	N/A	00	2014-06-13 11:45:39
1244	EXTRANJERO	01	2015-11-17 16:56:00
11001	BOGOTA D.C.	11	2016-02-22 12:15:00
91263	El Encanto	91	2016-02-22 12:15:00
68669	Isla de San Andres	88	2016-02-22 12:15:00
91405	La Chorrera	91	2016-02-22 12:15:00
91407	La Pedrera	91	2016-02-22 12:15:00
76403	La Victoria	91	2016-02-22 12:15:00
91001	Leticia	91	2016-02-22 12:15:00
91530	Puerto Alegría	91	2016-02-23 10:00:00
91536	Puerto Arica	91	2016-02-23 10:00:00
91540	Puerto Nariño	91	2016-02-23 10:00:00
91669	Puerto Santander	91	2016-02-23 10:00:00
91798	Tarapacá	91	2016-02-23 10:00:00
88564	Isla de Providencia	88	2016-02-23 10:00:00
\.


--
-- Data for Name: neuro_psiquiatria; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.neuro_psiquiatria (id, nombre, fecha_creacion) FROM stdin;
1	Búsqueda de foco de descarga en estudio ictal	2014-06-13 19:43:14
2	Búsqueda de foco de descarga en estudio inter octal	2014-06-13 19:43:14
3	Diagnóstico diferencial de la demencia	2014-06-13 19:43:14
4	Diagnóstico diferencial de un trastorno psiquiátrico	2014-06-13 19:43:14
5	Evaluación de la función cortical cerebral	2014-06-13 19:43:14
6	Evaluación de la viabilidad tumoral, en tumor de SNC	2014-06-13 19:43:14
0	No aplica	2014-12-01 19:43:14
\.


--
-- Data for Name: noconfirmation_reason; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.noconfirmation_reason (id, name, current, description) FROM stdin;
3	Telefono errado	2015-05-15	Telefono errado
\.


--
-- Data for Name: oncologia; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.oncologia (id, nombre, fecha_creacion) FROM stdin;
1	Búsqueda de primario oculto	2015-09-15 19:43:14
2	Caracterización de lesión primaria (maligna vs benigna)	2015-09-15 19:43:14
3	Estadificación inicial	2015-09-15 19:43:14
4	Estadificación postquirúrgica	2015-09-15 19:43:14
5	Evaluación de la neoadyuvancia- re estadificación	2015-09-15 19:43:14
6	Evaluación de la respuesta al final del tratamiento	2015-09-15 19:43:14
7	Plantación de radioterapia y/o cirugía	2015-09-15 19:43:14
8	Recurrencia	2015-09-15 19:43:14
9	Seguimiento oncológica	2015-09-15 19:43:14
10	Síndrome para neoplástico	2015-09-15 19:43:14
11	Síndrome para neoplástico	2015-09-15 19:43:14
0	No aplica	2014-12-01 19:43:14
\.


--
-- Data for Name: patient; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.patient (id_person, municipality_code, contact_telephone, contact_name, current, weight, id_patient) FROM stdin;
\.


--
-- Data for Name: patient_consent; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.patient_consent (patient_consent, physical_consent_url, current) FROM stdin;
\.


--
-- Data for Name: payment_form; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.payment_form (id, name, description, id_account, current, check_required, bank, address, id_bank, print_label) FROM stdin;
\.


--
-- Data for Name: person_data; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.person_data (id_person, document, first_name, second_name, first_last_name, second_last_name, date_birth, age_year, age_month, telephone, email, cellphone, address, current, sex, blood_type, residential_zone, age_type, id_document_type, historia_clinica, full_name) FROM stdin;
\.


--
-- Data for Name: plates_registry; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.plates_registry (id_registry, plates_good, plates_bad, number_exposures, number_unneccesary_exposures, amount_mas, amount_kva, id_person, appointment_code, current, amount_mgy, snapnumber, prevstudies, over_exposure, number_plates, number_studies, id_user_tecno, size_plates, biopsy, amount_ma, amount_compresion, amount_mgyagd, amount_ctdi, amount_dlp, weight, amount_mci, amount_qradiof, amount_imgcine, amount_imgfluoro, amount_dapugy, amount_cumulate_dose, amount_time_fluo, reason_overexposure, tipo_contraste, cantidad_contraste) FROM stdin;
\.


--
-- Data for Name: preparation; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.preparation (id, name, preparation, note, recomendation, current) FROM stdin;
\.


--
-- Data for Name: priority; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.priority (id, name, current) FROM stdin;
1	Alta                                                                                                	2015-05-09
2	Media                                                                                               	2015-05-09
3	Baja                                                                                                	2015-05-09
\.


--
-- Data for Name: provenance_date; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.provenance_date (id, name, current, description, val_provenance) FROM stdin;
1	HOSPITALIZACION	\N	\N	\N
2	URGENCIAS	\N	\N	\N
3	CONSULTA EXTERNA	\N	\N	\N
\.


--
-- Data for Name: rate; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.rate (id_base_price, id_study_list, code, value, id, current) FROM stdin;
\.


--
-- Data for Name: rate_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.rate_type (id_rate_type, rate_name, current) FROM stdin;
\.


--
-- Data for Name: reception_requirement; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.reception_requirement (id, name, description, current) FROM stdin;
1	Orden médica	\N	2018-04-30 12:54:35
\.


--
-- Data for Name: recorder; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.recorder (id, url, current, id_room_appointment_study_receipt, recording_id, record, save, status, user_id) FROM stdin;
\.


--
-- Data for Name: recording; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.recording (id_recording, url_recording, current, id_room_appointment_study_receipt, current_form_transcription, id_user, record) FROM stdin;
\.


--
-- Data for Name: regime_affiliate; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.regime_affiliate (id, name, description, current) FROM stdin;
27	DEFAULT	1	2015-05-09 10:55:13
1	Contributivo	1	2018-03-14 11:07:53
2	Subsidiado	2	2018-03-14 11:07:53
3	Vinculado	3	2018-03-14 11:09:44
4	Particular	4	2018-03-14 11:10:47
5	Otro	5	2018-03-14 11:11:18
6	Desplazado con afiliación al Régimen Contributivo	6	2018-03-14 11:12:04
7	Desplazado con afiliación al Régimen Subsidiado	7	2018-03-14 11:12:04
8	Dezplazado no asegurado(vinculado)	8	2018-03-14 11:13:02
\.


--
-- Data for Name: rel_insumos_estudios; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.rel_insumos_estudios (id_insumo, nombre_insumo, study_code, codigo_insumo, valor_insumo, id_study_list) FROM stdin;
\.


--
-- Data for Name: rel_study_list_consent; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.rel_study_list_consent (id_consent, id_study_list) FROM stdin;
\.


--
-- Data for Name: rel_study_list_contra_indication; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.rel_study_list_contra_indication (id_contra_indication, id_study_list) FROM stdin;
\.


--
-- Data for Name: rel_study_list_indication; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.rel_study_list_indication (id_indication, id_study_list) FROM stdin;
\.


--
-- Data for Name: rel_study_list_preparation; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.rel_study_list_preparation (id_preparation, id_study_list) FROM stdin;
\.


--
-- Data for Name: requirement; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.requirement (id_requirement, requirement_description, current) FROM stdin;
\.


--
-- Data for Name: reservation; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.reservation (id, name, date) FROM stdin;
1	Presencial	2016-12-26 20:34:47
2	Telefónica	2016-12-26 20:35:07
3	Email	2016-12-26 20:35:07
\.


--
-- Data for Name: resoluciones; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.resoluciones (id_resoluciones, fecha_inicial, fecha_final, valor_inicial, valor_final, id_usuario_creador, fecha_creacion, estado, id_entidad, prefijo, fecha_modificacion, id_usuario_modificador, nombre) FROM stdin;
\.


--
-- Data for Name: rips_data; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.rips_data (appointment_code, rips, id, date_create, id_user, date_init, date_end, codigo_factura, id_factura) FROM stdin;
\.


--
-- Data for Name: room; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.room (room_code, id_modality, id_headquarter, current, room_name, ae_title, port, ip, enabled, color, dicom, paso_lectura, agrupa_estudios, toma_imagenes) FROM stdin;
50	US	6d44fb4f-aa8d-47ea-a633-d54f8041b843	2018-05-21 10:01:38	Ecografía	\N	\N	\N	t	\N	f	t	f	f
\.


--
-- Data for Name: room_appointment_study_receipt; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.room_appointment_study_receipt (id_room_appointment_study_receipt, appointment_code, room_code, current, auto_validated, duration, episode, motivos_devolucion, validate_datetime, motive, current_from_delivery_result, id_user_ras, id_user_back, birads, current_update_status, id_oncologia, id_neuro_psiquiatria, id_cardiologia, id_infectologia, peso, id_radiologo, fecha_registro_pet, rasr_custom1, rasr_custom2, rasr_custom3, rasr_custom4) FROM stdin;
\.


--
-- Data for Name: schedule; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.schedule (id_schedule, date_start, date_end, hours_start, hours_end, appointment_code, type_schedule, id_user_creator, date_creator, id_user_cancel, date_cancel, id_schedule_rules, blockade_days, id_diary_blockade, id_schedule_sms, sms_sent, id_room, id_blockade_event) FROM stdin;
\.


--
-- Data for Name: schedule_logs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.schedule_logs (id, current, action, description, id_user, appointment_code) FROM stdin;
\.


--
-- Data for Name: schedule_rules; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.schedule_rules (id_schedule_rules, date_start, date_end, hours_start, hours_end, id_room, duration, id_user_creator, date_creator, status, name, id_user_assing, days_week) FROM stdin;
\.


--
-- Data for Name: schedule_sms; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.schedule_sms (id, name, description, current) FROM stdin;
5	SMS	Notificación	2015-11-07 14:07:46
\.


--
-- Data for Name: schedule_sms_logs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.schedule_sms_logs (id, description, log_type, current) FROM stdin;
\.


--
-- Data for Name: second_opinion; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.second_opinion (id, appointment_code, id_user_request, requesting_comment, requesting_date, id_requested_user, second_opinion, status, second_opinion_date, priority) FROM stdin;
\.


--
-- Data for Name: sm_languages; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sm_languages (id, languages, description) FROM stdin;
0	es-003	ESPAÑOL
2	es-ES	SAS3
\.


--
-- Data for Name: sm_licenseguid; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sm_licenseguid (id, nusai_licenseguid, description) FROM stdin;
\.


--
-- Data for Name: sm_microphones; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sm_microphones (id, microphones, description) FROM stdin;
0	100	generico
2	200	SPECH MIKE
\.


--
-- Data for Name: sm_partnerguid; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sm_partnerguid (id, nusai_partnerguid, description) FROM stdin;
\.


--
-- Data for Name: sm_serverurl; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sm_serverurl (id, serverurl, description) FROM stdin;
\.


--
-- Data for Name: sm_topics; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sm_topics (id, topics) FROM stdin;
0	RadiologiaSP
2	Radiology
\.


--
-- Data for Name: solicitude_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.solicitude_type (id, name, current, description) FROM stdin;
\.


--
-- Data for Name: speciality; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.speciality (id_speciality, name_speciality, description) FROM stdin;
\.


--
-- Data for Name: study; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.study (study_code, study_name, id_modality, current, description, body, portable, untimeliness, clinical, id_room_appointment_study_receipt, id_study_list, cups, purpose) FROM stdin;
\.


--
-- Data for Name: study_detail; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.study_detail (study_detail_code, id_room_appointment_study_receipt, study_uid, series_uid, object_uid, current) FROM stdin;
\.


--
-- Data for Name: study_list; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.study_list (cod_study, name_study, description, cod_modality, id_study_list, type_value, id_modality, birad, recomendation, consent, id_speciality, estado, multiplicador, cuenta_rpv, tipo_procedimiento, tipo_medicamento, forma_farmaceutica, concentracion_medicamento, unidad_medida_medicamento) FROM stdin;
\.


--
-- Data for Name: study_rate; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.study_rate (id_study_rate, study_rate_price, study_rate_code, study_code, id_rate_type, current) FROM stdin;
\.


--
-- Data for Name: telephone_state; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.telephone_state (id, name, current, description) FROM stdin;
\.


--
-- Data for Name: ti_adendum; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.ti_adendum (id, fuente, nrodoc, nlinea, item, codusr, fechar, nota, appointment_code, estado, numero_solicitud, codigo_interno_servicio, cups) FROM stdin;
\.


--
-- Data for Name: ti_hisris; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.ti_hisris (id, idagrupado, codigounico, fuente, nrodoc, nlinea, origen, codser, histor, ingres, fechad, tipide, nroide, nombre, apell1, apell2, telefo, celula, direcc, sexo, zresid, tipmed, medico, codact, nomact, obsord, fnacim, rhsang, correo, fechas, esthis, codusr, nrosol, fechar, codtec, codrad, estris, result, docrem, nomrem, lectura, reporte, fechaingreso, estado, coddia, justif, cancel, regmed, nomrad, appointment_code, estcam, depcod, depnom, muncod, munnom, nommed, nomser, priori, codemp, nomemp, nomdia, codigo_interno_servicio, modalidad, nombre_sede, codigo_sede, studyiuid, reporte_pdf, contraste, facturacion, control_facturado, cmp_medico, tipoatencion, ftecnologo, finicio_examen, ffinal_examen, fentrega_informe, fregistro_informe, resp_informe, usr_informe, iddiagnostico, nro_placas, idtecnologo, ixpagar_paciente, p1, p2, p3, fcita_llegada) FROM stdin;
\.


--
-- Data for Name: ti_logint; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.ti_logint (id, fuente, nrodoc, nlinea, fecha, usuario, estado, enviado, numero_solicitud) FROM stdin;
\.


--
-- Data for Name: tipe_flow; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tipe_flow (flux_type, id_flux_type) FROM stdin;
Recepción                     	0
Actualización                 	1
\.


--
-- Data for Name: transcription_template; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.transcription_template (content, id_template, name, id, id_modality, study_list) FROM stdin;
\.


--
-- Data for Name: user_schedule; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.user_schedule (id_schedule_user, id_user, id_schedule, date_init, date_end, hour_init, hour_end, days, status) FROM stdin;
\.


--
-- Data for Name: user_sm; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.user_sm (id, id_user, nusa_userid, id_nusai_licenseguid, id_nusai_partnerguid, id_serverurl, version) FROM stdin;
\.


--
-- Data for Name: user_sm_languages; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.user_sm_languages (id_user, id_languages) FROM stdin;
\.


--
-- Data for Name: user_sm_microphones; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.user_sm_microphones (id_user, id_microphones) FROM stdin;
\.


--
-- Data for Name: user_sm_topics; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.user_sm_topics (id_user, id_topics) FROM stdin;
\.


--
-- Data for Name: valores_fijos; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.valores_fijos (id_valor_fijo, temporada, valor_fijo_us_400, valor_fijo_us_900, valor_fijo_rad_400, valor_fijo_rad_900, fecha_creacion, usuario_creacion, precio_r_0_us, precio_r_0_rad, intervalo_incremento_ri_us, intervalo_incremento_ri_rad, incremento_us, incremento_rad, frecuencia_r_0_us, frecuencia_r_0_rad, ipc) FROM stdin;
\.


--
-- Data for Name: vna_files; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.vna_files (id, id_study, mime_type, report, content) FROM stdin;
\.


--
-- Data for Name: vna_studies; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.vna_studies (id, current, user_id, comments, study_name, patient_id) FROM stdin;
\.


--
-- Data for Name: work_lists; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.work_lists (id, user_id, name_work_list, config, current) FROM stdin;
\.



--
-- Name: absence_reasons absence_reasons_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.absence_reasons
    ADD CONSTRAINT absence_reasons_pkey PRIMARY KEY (id);


--
-- Name: account account_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.account
    ADD CONSTRAINT account_pkey PRIMARY KEY (id);


--
-- Name: acl_classes acl_classes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acl_classes
    ADD CONSTRAINT acl_classes_pkey PRIMARY KEY (id);


--
-- Name: acl_entries acl_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acl_entries
    ADD CONSTRAINT acl_entries_pkey PRIMARY KEY (id);


--
-- Name: acl_object_identities acl_object_identities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acl_object_identities
    ADD CONSTRAINT acl_object_identities_pkey PRIMARY KEY (id);


--
-- Name: acl_object_identity_ancestors acl_object_identity_ancestors_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acl_object_identity_ancestors
    ADD CONSTRAINT acl_object_identity_ancestors_pkey PRIMARY KEY (object_identity_id, ancestor_id);


--
-- Name: acl_security_identities acl_security_identities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acl_security_identities
    ADD CONSTRAINT acl_security_identities_pkey PRIMARY KEY (id);


--
-- Name: affiliation_type affiliation_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.affiliation_type
    ADD CONSTRAINT affiliation_type_pkey PRIMARY KEY (id_affiliation_type);


--
-- Name: appointment appointment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT appointment_pkey PRIMARY KEY (appointment_code);


--
-- Name: auxiliary_transcription aux_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auxiliary_transcription
    ADD CONSTRAINT aux_pk PRIMARY KEY (id_auxiliary_transcription);


--
-- Name: bank bank_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bank
    ADD CONSTRAINT bank_pkey PRIMARY KEY (id);


--
-- Name: base_price base_price_name_u; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.base_price
    ADD CONSTRAINT base_price_name_u UNIQUE (name);


--
-- Name: base_price base_price_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.base_price
    ADD CONSTRAINT base_price_pkey PRIMARY KEY (id);


--
-- Name: benefit_plan benefit_plan_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.benefit_plan
    ADD CONSTRAINT benefit_plan_name_unique UNIQUE (name);


--
-- Name: benefit_plan benefit_plan_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.benefit_plan
    ADD CONSTRAINT benefit_plan_pkey PRIMARY KEY (id);


--
-- Name: block_des block_des_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.block_des
    ADD CONSTRAINT block_des_pkey PRIMARY KEY (id_blocked);


--
-- Name: campos_de_formularios campos_de_formulario_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.campos_de_formularios
    ADD CONSTRAINT campos_de_formulario_pkey PRIMARY KEY (id);


--
-- Name: cancellation_reason cancellation_reason_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cancellation_reason
    ADD CONSTRAINT cancellation_reason_pkey PRIMARY KEY (id);


--
-- Name: cardiologia cardiologia_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cardiologia
    ADD CONSTRAINT cardiologia_pkey PRIMARY KEY (id);


--
-- Name: cie_10 cie_10_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cie_10
    ADD CONSTRAINT cie_10_pkey PRIMARY KEY (id_cie_10);


--
-- Name: clases_puc clases_puc_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.clases_puc
    ADD CONSTRAINT clases_puc_pkey PRIMARY KEY (id_clases_puc);


--
-- Name: clinical_file clinical_file_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.clinical_file
    ADD CONSTRAINT clinical_file_pkey PRIMARY KEY (id);


--
-- Name: concordance concordance_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.concordance
    ADD CONSTRAINT concordance_pkey PRIMARY KEY (id_concordance);


--
-- Name: noconfirmation_reason confirmation_reason_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.noconfirmation_reason
    ADD CONSTRAINT confirmation_reason_pkey PRIMARY KEY (id);


--
-- Name: consent consent_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.consent
    ADD CONSTRAINT consent_name_unique UNIQUE (name);


--
-- Name: consent consent_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.consent
    ADD CONSTRAINT consent_pkey PRIMARY KEY (id);


--
-- Name: contra_indication contra_indication_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contra_indication
    ADD CONSTRAINT contra_indication_name_unique UNIQUE (name);


--
-- Name: contra_indication contra_indication_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contra_indication
    ADD CONSTRAINT contra_indication_pkey PRIMARY KEY (id);


--
-- Name: contratos_examenes contratos_examenes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_examenes
    ADD CONSTRAINT contratos_examenes_pkey PRIMARY KEY (id_contratos_examenes);


--
-- Name: contratos_modalidades contratos_modalidades_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_modalidades
    ADD CONSTRAINT contratos_modalidades_pkey PRIMARY KEY (id_contratos_modalidad);


--
-- Name: contratos contratos_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos
    ADD CONSTRAINT contratos_pkey PRIMARY KEY (id_contratos);


--
-- Name: contratos_sedes contratos_sedes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_sedes
    ADD CONSTRAINT contratos_sedes_pkey PRIMARY KEY (id_contratos_sede);


--
-- Name: copayment copayment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.copayment
    ADD CONSTRAINT copayment_pkey PRIMARY KEY (id_copayment);


--
-- Name: cuentas_puc cuentas_puc_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cuentas_puc
    ADD CONSTRAINT cuentas_puc_pkey PRIMARY KEY (id_cuentas_puc);


--
-- Name: cuotas_copagos cuotas_copagos_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cuotas_copagos
    ADD CONSTRAINT cuotas_copagos_pkey PRIMARY KEY (id_cuotas_copago);


--
-- Name: days days_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.days
    ADD CONSTRAINT days_pkey PRIMARY KEY (id_day);


--
-- Name: days_schedule days_schedule_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.days_schedule
    ADD CONSTRAINT days_schedule_pkey PRIMARY KEY (id_days_schedule);


--
-- Name: department department_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.department
    ADD CONSTRAINT department_pkey PRIMARY KEY (department_code);


--
-- Name: diary_blockade diary_blockade_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.diary_blockade
    ADD CONSTRAINT diary_blockade_pkey PRIMARY KEY (id);


--
-- Name: document_type document_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.document_type
    ADD CONSTRAINT document_type_pkey PRIMARY KEY (id_document_type);


--
-- Name: encuesta encuesta_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.encuesta
    ADD CONSTRAINT encuesta_pkey PRIMARY KEY (id_encuesta);


--
-- Name: entity entity_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.entity
    ADD CONSTRAINT entity_pkey PRIMARY KEY (id_entity);


--
-- Name: eps eps_eps_nit_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eps
    ADD CONSTRAINT eps_eps_nit_name_key UNIQUE (eps_nit, name);


--
-- Name: eps eps_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eps
    ADD CONSTRAINT eps_pkey PRIMARY KEY (id_eps);


--
-- Name: eps_type eps_type_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eps_type
    ADD CONSTRAINT eps_type_name_unique UNIQUE (name);


--
-- Name: eps_type eps_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eps_type
    ADD CONSTRAINT eps_type_pkey PRIMARY KEY (id);


--
-- Name: especialidad_medico especialidad_medico_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.especialidad_medico
    ADD CONSTRAINT especialidad_medico_pkey PRIMARY KEY (id_especialidad_medico);


--
-- Name: facturas_capita facturas_capita_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas_capita
    ADD CONSTRAINT facturas_capita_pkey PRIMARY KEY (id_capita);


--
-- Name: facturas_ordenes facturas_ordenes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas_ordenes
    ADD CONSTRAINT facturas_ordenes_pkey PRIMARY KEY (id_facturas_ordenes);


--
-- Name: facturas facturas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas
    ADD CONSTRAINT facturas_pkey PRIMARY KEY (id_factura);


--
-- Name: fixed_price fixed_price_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fixed_price
    ADD CONSTRAINT fixed_price_pkey PRIMARY KEY (id);


--
-- Name: formularios formulario_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.formularios
    ADD CONSTRAINT formulario_pkey PRIMARY KEY (id);


--
-- Name: fos_user_headquarter fos_user_headquarter_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fos_user_headquarter
    ADD CONSTRAINT fos_user_headquarter_pkey PRIMARY KEY (id);


--
-- Name: fos_user_user_group fos_user_user_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fos_user_user_group
    ADD CONSTRAINT fos_user_user_group_pkey PRIMARY KEY (user_id, group_id);


--
-- Name: group_sonata group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_sonata
    ADD CONSTRAINT group_pkey PRIMARY KEY (id);


--
-- Name: historial_patient historial_patient_code_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.historial_patient
    ADD CONSTRAINT historial_patient_code_pk PRIMARY KEY (historial_patient_code);


--
-- Name: hrk_portal hrk_portal_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.hrk_portal
    ADD CONSTRAINT hrk_portal_pkey PRIMARY KEY (hrk_portal_id);


--
-- Name: clinical_data id_clinical_data; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.clinical_data
    ADD CONSTRAINT id_clinical_data PRIMARY KEY (id_clinical_data);


--
-- Name: tipe_flow id_flux_headquarter; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tipe_flow
    ADD CONSTRAINT id_flux_headquarter PRIMARY KEY (id_flux_type);


--
-- Name: recorder id_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recorder
    ADD CONSTRAINT id_pkey PRIMARY KEY (id);


--
-- Name: plates_registry id_platesregistry; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plates_registry
    ADD CONSTRAINT id_platesregistry PRIMARY KEY (id_registry);


--
-- Name: schedule_logs id_schedule_logs; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule_logs
    ADD CONSTRAINT id_schedule_logs PRIMARY KEY (id);


--
-- Name: schedule_sms id_schedule_sms; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule_sms
    ADD CONSTRAINT id_schedule_sms PRIMARY KEY (id);


--
-- Name: second_opinion id_secon_opinion; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.second_opinion
    ADD CONSTRAINT id_secon_opinion PRIMARY KEY (id);


--
-- Name: schedule_sms_logs id_sms_log; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule_sms_logs
    ADD CONSTRAINT id_sms_log PRIMARY KEY (id);


--
-- Name: patient_consent idpatient_consent; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.patient_consent
    ADD CONSTRAINT idpatient_consent PRIMARY KEY (patient_consent);


--
-- Name: indication indication_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.indication
    ADD CONSTRAINT indication_name_unique UNIQUE (name);


--
-- Name: indication indication_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.indication
    ADD CONSTRAINT indication_pkey PRIMARY KEY (id);


--
-- Name: infectologia infectologia_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.infectologia
    ADD CONSTRAINT infectologia_pkey PRIMARY KEY (id);


--
-- Name: internal_order internal_order_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.internal_order
    ADD CONSTRAINT internal_order_pkey PRIMARY KEY (internal_order_code);


--
-- Name: iva_privity iva_privity_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iva_privity
    ADD CONSTRAINT iva_privity_name_unique UNIQUE (name);


--
-- Name: iva_privity iva_privity_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iva_privity
    ADD CONSTRAINT iva_privity_pkey PRIMARY KEY (id);


--
-- Name: level level_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.level
    ADD CONSTRAINT level_pkey PRIMARY KEY (id_level);


--
-- Name: ti_logint logs_esthis_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ti_logint
    ADD CONSTRAINT logs_esthis_pkey PRIMARY KEY (id);


--
-- Name: sm_topics m_topics_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sm_topics
    ADD CONSTRAINT m_topics_pkey PRIMARY KEY (id);


--
-- Name: margen_reportes margen_reportes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.margen_reportes
    ADD CONSTRAINT margen_reportes_pkey PRIMARY KEY (id_report);


--
-- Name: modality modality_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.modality
    ADD CONSTRAINT modality_pkey PRIMARY KEY (id_modality);


--
-- Name: modality_worklist modality_worklist_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.modality_worklist
    ADD CONSTRAINT modality_worklist_pkey PRIMARY KEY (id_modality_worklist);


--
-- Name: municipality municipality_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.municipality
    ADD CONSTRAINT municipality_pkey PRIMARY KEY (municipality_code);


--
-- Name: neuro_psiquiatria neuro_psiquiatria_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.neuro_psiquiatria
    ADD CONSTRAINT neuro_psiquiatria_pkey PRIMARY KEY (id);


--
-- Name: oncologia oncologia_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.oncologia
    ADD CONSTRAINT oncologia_pkey PRIMARY KEY (id);


--
-- Name: patient patient_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.patient
    ADD CONSTRAINT patient_pkey PRIMARY KEY (id_patient);


--
-- Name: payment_form payment_form_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payment_form
    ADD CONSTRAINT payment_form_pkey PRIMARY KEY (id);


--
-- Name: person_data person_data_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.person_data
    ADD CONSTRAINT person_data_pkey PRIMARY KEY (id_person);


--
-- Name: data_result pk_datares; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.data_result
    ADD CONSTRAINT pk_datares PRIMARY KEY (id_data);


--
-- Name: devolution_historic pk_devolution_historic; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.devolution_historic
    ADD CONSTRAINT pk_devolution_historic PRIMARY KEY (id_devolution_historic);


--
-- Name: study_list pk_study_list; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study_list
    ADD CONSTRAINT pk_study_list PRIMARY KEY (id_study_list);


--
-- Name: preparation preparation_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.preparation
    ADD CONSTRAINT preparation_name_unique UNIQUE (name);


--
-- Name: preparation preparation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.preparation
    ADD CONSTRAINT preparation_pkey PRIMARY KEY (id);


--
-- Name: priority priority_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.priority
    ADD CONSTRAINT priority_pkey PRIMARY KEY (id);


--
-- Name: provenance_date provenance_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.provenance_date
    ADD CONSTRAINT provenance_pkey PRIMARY KEY (id);


--
-- Name: rate rate_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rate
    ADD CONSTRAINT rate_pkey PRIMARY KEY (id);


--
-- Name: rate_type rate_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rate_type
    ADD CONSTRAINT rate_type_pkey PRIMARY KEY (id_rate_type);


--
-- Name: reception_requirement reception_requirement_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.reception_requirement
    ADD CONSTRAINT reception_requirement_name_unique UNIQUE (name);


--
-- Name: reception_requirement reception_requirement_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.reception_requirement
    ADD CONSTRAINT reception_requirement_pkey PRIMARY KEY (id);


--
-- Name: recording recording_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recording
    ADD CONSTRAINT recording_pkey PRIMARY KEY (id_recording);


--
-- Name: regime_affiliate regime_affiliate_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.regime_affiliate
    ADD CONSTRAINT regime_affiliate_name_unique UNIQUE (name);


--
-- Name: regime_affiliate regime_affiliate_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.regime_affiliate
    ADD CONSTRAINT regime_affiliate_pkey PRIMARY KEY (id);


--
-- Name: rel_insumos_estudios rel_insumos_estudios_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_insumos_estudios
    ADD CONSTRAINT rel_insumos_estudios_pkey PRIMARY KEY (id_insumo);


--
-- Name: rel_study_list_consent rel_study_list_consent_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_consent
    ADD CONSTRAINT rel_study_list_consent_pkey PRIMARY KEY (id_consent, id_study_list);


--
-- Name: rel_study_list_contra_indication rel_study_list_contra_indication_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_contra_indication
    ADD CONSTRAINT rel_study_list_contra_indication_pkey PRIMARY KEY (id_contra_indication, id_study_list);


--
-- Name: rel_study_list_indication rel_study_list_indication_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_indication
    ADD CONSTRAINT rel_study_list_indication_pkey PRIMARY KEY (id_indication, id_study_list);


--
-- Name: rel_study_list_preparation rel_study_list_preparation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_preparation
    ADD CONSTRAINT rel_study_list_preparation_pkey PRIMARY KEY (id_preparation, id_study_list);


--
-- Name: requirement requirement_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.requirement
    ADD CONSTRAINT requirement_pkey PRIMARY KEY (id_requirement);


--
-- Name: reservation reservation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.reservation
    ADD CONSTRAINT reservation_pkey PRIMARY KEY (id);


--
-- Name: resoluciones resoluciones_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.resoluciones
    ADD CONSTRAINT resoluciones_pkey PRIMARY KEY (id_resoluciones);


--
-- Name: rips_data rips_data_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rips_data
    ADD CONSTRAINT rips_data_pkey PRIMARY KEY (id);


--
-- Name: room_appointment_study_receipt room_appointment_study_receipt_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room_appointment_study_receipt
    ADD CONSTRAINT room_appointment_study_receipt_pkey PRIMARY KEY (id_room_appointment_study_receipt);


--
-- Name: room room_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room
    ADD CONSTRAINT room_pkey PRIMARY KEY (room_code);


--
-- Name: schedule schedule_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule
    ADD CONSTRAINT schedule_pkey PRIMARY KEY (id_schedule);


--
-- Name: schedule_rules schedule_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule_rules
    ADD CONSTRAINT schedule_rules_pkey PRIMARY KEY (id_schedule_rules);


--
-- Name: sm_languages sm_languages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sm_languages
    ADD CONSTRAINT sm_languages_pkey PRIMARY KEY (id);


--
-- Name: sm_licenseguid sm_licenseguid_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sm_licenseguid
    ADD CONSTRAINT sm_licenseguid_pkey PRIMARY KEY (id);


--
-- Name: sm_microphones sm_microphones_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sm_microphones
    ADD CONSTRAINT sm_microphones_pkey PRIMARY KEY (id);


--
-- Name: sm_partnerguid sm_partnerguid_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sm_partnerguid
    ADD CONSTRAINT sm_partnerguid_pkey PRIMARY KEY (id);


--
-- Name: sm_serverurl sm_serverurl_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sm_serverurl
    ADD CONSTRAINT sm_serverurl_pkey PRIMARY KEY (id);


--
-- Name: solicitude_type solicitude_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.solicitude_type
    ADD CONSTRAINT solicitude_type_pkey PRIMARY KEY (id);


--
-- Name: speciality speciality_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.speciality
    ADD CONSTRAINT speciality_pkey PRIMARY KEY (id_speciality);


--
-- Name: study_detail study_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study_detail
    ADD CONSTRAINT study_detail_pkey PRIMARY KEY (study_detail_code);


--
-- Name: study study_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study
    ADD CONSTRAINT study_pkey PRIMARY KEY (study_code);


--
-- Name: study_rate study_rate_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study_rate
    ADD CONSTRAINT study_rate_pkey PRIMARY KEY (id_study_rate);


--
-- Name: telephone_state telephone_state_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.telephone_state
    ADD CONSTRAINT telephone_state_pkey PRIMARY KEY (id);


--
-- Name: transcription_template template_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transcription_template
    ADD CONSTRAINT template_pkey PRIMARY KEY (id_template);


--
-- Name: ti_hisris ti_hisris_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ti_hisris
    ADD CONSTRAINT ti_hisris_pkey PRIMARY KEY (id);


--
-- Name: rate unique_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rate
    ADD CONSTRAINT unique_pkey UNIQUE (id_base_price, id_study_list);


--
-- Name: user_schedule user_schedule_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_schedule
    ADD CONSTRAINT user_schedule_pkey PRIMARY KEY (id_schedule_user);


--
-- Name: user_sm user_sm_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm
    ADD CONSTRAINT user_sm_pkey PRIMARY KEY (id);


--
-- Name: valores_fijos valores_fijos_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.valores_fijos
    ADD CONSTRAINT valores_fijos_pkey PRIMARY KEY (id_valor_fijo);


--
-- Name: vna_files vna_files_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vna_files
    ADD CONSTRAINT vna_files_pkey PRIMARY KEY (id);


--
-- Name: vna_studies vna_studies_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vna_studies
    ADD CONSTRAINT vna_studies_pkey PRIMARY KEY (id);


--
-- Name: work_lists work_lists_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_lists
    ADD CONSTRAINT work_lists_pkey PRIMARY KEY (id);


--
-- Name: IX_User_Sm_User; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "IX_User_Sm_User" ON public.user_sm USING btree (id_user);


--
-- Name: IX_user_sm_Languages_Language; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "IX_user_sm_Languages_Language" ON public.user_sm_languages USING btree (id_languages);


--
-- Name: IX_user_sm_Languages_User; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "IX_user_sm_Languages_User" ON public.user_sm_languages USING btree (id_user);


--
-- Name: IX_user_sm_Topics_user; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "IX_user_sm_Topics_user" ON public.user_sm_topics USING btree (id_user);


--
-- Name: Ix_user_sm_Microphones_Microphones; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "Ix_user_sm_Microphones_Microphones" ON public.user_sm_microphones USING btree (id_microphones);


--
-- Name: Ix_user_sm_Microphones_User; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "Ix_user_sm_Microphones_User" ON public.user_sm_microphones USING btree (id_user);


--
-- Name: Ix_user_sm_Topics_Topic; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "Ix_user_sm_Topics_Topic" ON public.user_sm_topics USING btree (id_topics);


--
-- Name: base_price_id_key; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX base_price_id_key ON public.base_price USING btree (id);


--
-- Name: fki_appointment_devolution; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX fki_appointment_devolution ON public.devolution_historic USING btree (appointment_code);


--
-- Name: fki_fkid; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX fki_fkid ON public.transcription_template USING btree (id);


--
-- Name: fki_fkmod; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX fki_fkmod ON public.transcription_template USING btree (id_modality);


--
-- Name: fki_id_trans; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX fki_id_trans ON public.auxiliary_transcription USING btree (id_transcription);


--
-- Name: fki_modWrk_appointment; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "fki_modWrk_appointment" ON public.modality_worklist USING btree (appointment_code);


--
-- Name: fki_modWrk_modality; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "fki_modWrk_modality" ON public.modality_worklist USING btree (id_room);


--
-- Name: fki_modality; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX fki_modality ON public.study_list USING btree (cod_modality);


--
-- Name: fki_st_detail_fk; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX fki_st_detail_fk ON public.study_detail USING btree (id_room_appointment_study_receipt);


--
-- Name: fki_transTemp_Modality; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "fki_transTemp_Modality" ON public.transcription_template USING btree (id_modality);


--
-- Name: fki_transcription; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX fki_transcription ON public.data_result USING btree (id_transcription);


--
-- Name: full_text_patient_search; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX full_text_patient_search ON public.person_data USING gin (to_tsvector('simple'::regconfig, (((((((((((first_name)::text || ' '::text) || (second_name)::text) || ' '::text) || (first_last_name)::text) || ' '::text) || (second_last_name)::text) || ' '::text) || (document)::text) || ' '::text) || public.my_to_char(date_birth))));


--
-- Name: idx_46c8b8063d9ab4a6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_46c8b8063d9ab4a6 ON public.acl_entries USING btree (object_identity_id);


--
-- Name: idx_46c8b806df9183c9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_46c8b806df9183c9 ON public.acl_entries USING btree (security_identity_id);


--
-- Name: idx_46c8b806ea000b10; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_46c8b806ea000b10 ON public.acl_entries USING btree (class_id);


--
-- Name: idx_46c8b806ea000b103d9ab4a6df9183c9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_46c8b806ea000b103d9ab4a6df9183c9 ON public.acl_entries USING btree (class_id, object_identity_id, security_identity_id);


--
-- Name: idx_825de2993d9ab4a6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_825de2993d9ab4a6 ON public.acl_object_identity_ancestors USING btree (object_identity_id);


--
-- Name: idx_825de299c671cea1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_825de299c671cea1 ON public.acl_object_identity_ancestors USING btree (ancestor_id);


--
-- Name: idx_9407e54977fa751a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_9407e54977fa751a ON public.acl_object_identities USING btree (parent_object_identity_id);


--
-- Name: idx_b3c77447a76ed395; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_b3c77447a76ed395 ON public.fos_user_user_group USING btree (user_id);


--
-- Name: idx_b3c77447fe54d947; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_b3c77447fe54d947 ON public.fos_user_user_group USING btree (group_id);


--
-- Name: ind_appointment_code; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_appointment_code ON public.room_appointment_study_receipt USING btree (appointment_code);


--
-- Name: ind_appointment_code2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_appointment_code2 ON public.schedule USING btree (appointment_code);


--
-- Name: ind_date_asistencial; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_date_asistencial ON public.appointment USING btree (datetime_asistencial);


--
-- Name: ind_date_start; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_date_start ON public.schedule USING btree (date_start);


--
-- Name: ind_document; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_document ON public.person_data USING btree (document);


--
-- Name: ind_firstname; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_firstname ON public.person_data USING btree (first_name);


--
-- Name: ind_id_eps; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_id_eps ON public.appointment USING btree (id_eps);


--
-- Name: ind_id_headquarter; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_id_headquarter ON public.room USING btree (id_headquarter);


--
-- Name: ind_id_patient; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_id_patient ON public.appointment USING btree (id_patient);


--
-- Name: ind_id_persON; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "ind_id_persON" ON public.patient USING btree (id_person);


--
-- Name: ind_id_room_app; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_id_room_app ON public.study USING btree (id_room_appointment_study_receipt);


--
-- Name: ind_lastname; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_lastname ON public.person_data USING btree (first_last_name);


--
-- Name: ind_modality; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_modality ON public.study USING btree (id_modality);


--
-- Name: ind_room_code; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_room_code ON public.room_appointment_study_receipt USING btree (room_code);


--
-- Name: ind_room_name; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_room_name ON public.room USING btree (room_name);


--
-- Name: ind_type_schedule; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ind_type_schedule ON public.schedule USING btree (type_schedule);


--
-- Name: ix_sm_languages; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX ix_sm_languages ON public.sm_languages USING btree (languages);


--
-- Name: ix_sm_licenseguid; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX ix_sm_licenseguid ON public.sm_licenseguid USING btree (nusai_licenseguid);


--
-- Name: ix_sm_microphones; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX ix_sm_microphones ON public.sm_microphones USING btree (microphones);


--
-- Name: ix_sm_partnerguid; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX ix_sm_partnerguid ON public.sm_partnerguid USING btree (nusai_partnerguid);


--
-- Name: ix_sm_serverurl; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX ix_sm_serverurl ON public.sm_serverurl USING btree (serverurl);


--
-- Name: ix_sm_topics; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX ix_sm_topics ON public.sm_topics USING btree (topics);


--
-- Name: ix_user_sm_Languages; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX "ix_user_sm_Languages" ON public.user_sm_languages USING btree (id_user);


--
-- Name: ix_user_sm_Microphones; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX "ix_user_sm_Microphones" ON public.user_sm_microphones USING btree (id_user);


--
-- Name: ix_user_sm_Topics; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX "ix_user_sm_Topics" ON public.user_sm_topics USING btree (id_user);


--
-- Name: nombre_contrato_unico; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX nombre_contrato_unico ON public.contratos USING btree (nombre_contrato, id_eps);


--
-- Name: nombre_data_resolucion; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX nombre_data_resolucion ON public.resoluciones USING btree (nombre, prefijo);


--
-- Name: patient_id_person_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX patient_id_person_idx ON public.patient USING btree (id_person);


--
-- Name: rate_id_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX rate_id_idx ON public.rate USING btree (id);


--
-- Name: uidx_affiliation_type; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_affiliation_type ON public.affiliation_type USING btree (affiliation);


--
-- Name: uidx_copayment; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_copayment ON public.copayment USING btree (id_affiliation_type, id_level);


--
-- Name: uidx_department; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_department ON public.department USING btree (department_name);


--
-- Name: uidx_entity; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_entity ON public.entity USING btree (entity_nit, entity_name);


--
-- Name: uidx_eps; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_eps ON public.eps USING btree (eps_nit, name);


--
-- Name: uidx_level; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_level ON public.level USING btree (level_type);


--
-- Name: uidx_modality; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_modality ON public.modality USING btree (modality_name);


--
-- Name: uidx_municipality; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_municipality ON public.municipality USING btree (municipality_name, department_code);


--
-- Name: uidx_person_data; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_person_data ON public.person_data USING btree (document);


--
-- Name: uidx_rate_type; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_rate_type ON public.rate_type USING btree (rate_name);


--
-- Name: uidx_study_rate; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uidx_study_rate ON public.study_rate USING btree (study_code, id_rate_type);


--
-- Name: uniq_46c8b806ea000b103d9ab4a64def17bce4289bf4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uniq_46c8b806ea000b103d9ab4a64def17bce4289bf4 ON public.acl_entries USING btree (class_id, object_identity_id, field_name, ace_order);


--
-- Name: uniq_50a1f0645e237e06; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uniq_50a1f0645e237e06 ON public.group_sonata USING btree (name);


--
-- Name: uniq_69dd750638a36066; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uniq_69dd750638a36066 ON public.acl_classes USING btree (class_type);


--
-- Name: uniq_8835ee78772e836af85e0677; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uniq_8835ee78772e836af85e0677 ON public.acl_security_identities USING btree (identifier, username);


--
-- Name: uniq_9407e5494b12ad6ea000b10; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uniq_9407e5494b12ad6ea000b10 ON public.acl_object_identities USING btree (object_identifier, class_id);


--
-- Name: plates_registry appointment_code; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plates_registry
    ADD CONSTRAINT appointment_code FOREIGN KEY (appointment_code) REFERENCES public.appointment(appointment_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: schedule_logs appointment_code; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule_logs
    ADD CONSTRAINT appointment_code FOREIGN KEY (appointment_code) REFERENCES public.appointment(appointment_code) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: appointment appointment_consent; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT appointment_consent FOREIGN KEY (consent_patient) REFERENCES public.patient_consent(patient_consent) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: appointment appointment_id_contratos_contratos; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT appointment_id_contratos_contratos FOREIGN KEY (id_contratos) REFERENCES public.contratos(id_contratos) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: appointment appointment_id_eps_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT appointment_id_eps_fkey FOREIGN KEY (id_eps) REFERENCES public.eps(id_eps) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: appointment appointment_id_priority; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT appointment_id_priority FOREIGN KEY (id_priority) REFERENCES public.priority(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: appointment appointment_id_provenance_date_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT appointment_id_provenance_date_fkey FOREIGN KEY (id_provenance_date) REFERENCES public.provenance_date(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: appointment appointment_id_user_receipt; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT appointment_id_user_receipt FOREIGN KEY (id_user_receipt) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: appointment appointment_internal_order_code_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT appointment_internal_order_code_fkey FOREIGN KEY (internal_order_code) REFERENCES public.internal_order(internal_order_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: appointment appointment_patient; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT appointment_patient FOREIGN KEY (id_patient) REFERENCES public.patient(id_patient) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: appointment appointment_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT appointment_user_sonata FOREIGN KEY (id_user_assistencial) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: base_price base_price_id_fixed_price_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.base_price
    ADD CONSTRAINT base_price_id_fixed_price_fkey FOREIGN KEY (id_fixed_price) REFERENCES public.fixed_price(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: base_price base_price_id_fixed_price_fkey1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.base_price
    ADD CONSTRAINT base_price_id_fixed_price_fkey1 FOREIGN KEY (id_fixed_price) REFERENCES public.fixed_price(id);


--
-- Name: block_des block_des_id_diary_blockade_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.block_des
    ADD CONSTRAINT block_des_id_diary_blockade_fk FOREIGN KEY (id_diary_blockade) REFERENCES public.diary_blockade(id);


--
-- Name: block_des block_des_id_schedule_rule; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.block_des
    ADD CONSTRAINT block_des_id_schedule_rule FOREIGN KEY (id_schedule_rules) REFERENCES public.schedule_rules(id_schedule_rules);


--
-- Name: concordance concordance_appointment_code_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.concordance
    ADD CONSTRAINT concordance_appointment_code_fkey FOREIGN KEY (appointment_code) REFERENCES public.appointment(appointment_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: concordance concordance_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.concordance
    ADD CONSTRAINT concordance_user_sonata FOREIGN KEY (id_user) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: copayment copayment_id_affiliation_type_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.copayment
    ADD CONSTRAINT copayment_id_affiliation_type_fkey FOREIGN KEY (id_affiliation_type) REFERENCES public.affiliation_type(id_affiliation_type) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: copayment copayment_id_level_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.copayment
    ADD CONSTRAINT copayment_id_level_fkey FOREIGN KEY (id_level) REFERENCES public.level(id_level) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: days_schedule days_schedule_id_days_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.days_schedule
    ADD CONSTRAINT days_schedule_id_days_fk FOREIGN KEY (id_days) REFERENCES public.days(id_day);


--
-- Name: days_schedule days_schedule_id_schedule_rules_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.days_schedule
    ADD CONSTRAINT days_schedule_id_schedule_rules_fk FOREIGN KEY (id_schedule_rules) REFERENCES public.schedule_rules(id_schedule_rules);


--
-- Name: eps eps_id_benefit_plan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eps
    ADD CONSTRAINT eps_id_benefit_plan_fkey FOREIGN KEY (id_benefit_plan) REFERENCES public.benefit_plan(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: eps eps_id_contratos_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eps
    ADD CONSTRAINT eps_id_contratos_fkey FOREIGN KEY (id_contratos) REFERENCES public.contratos(id_contratos) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: eps eps_id_iva_privity_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eps
    ADD CONSTRAINT eps_id_iva_privity_fkey FOREIGN KEY (id_iva_privity) REFERENCES public.iva_privity(id);


--
-- Name: eps eps_id_municipality_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eps
    ADD CONSTRAINT eps_id_municipality_fkey FOREIGN KEY (id_municipality) REFERENCES public.municipality(municipality_code) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: eps eps_id_regime_affiliate_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eps
    ADD CONSTRAINT eps_id_regime_affiliate_fkey FOREIGN KEY (id_regime_affiliate) REFERENCES public.regime_affiliate(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: eps eps_id_type_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eps
    ADD CONSTRAINT eps_id_type_fkey FOREIGN KEY (id_type) REFERENCES public.eps_type(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rips_data fk_appointment_code_rips_data; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rips_data
    ADD CONSTRAINT fk_appointment_code_rips_data FOREIGN KEY (appointment_code) REFERENCES public.appointment(appointment_code);


--
-- Name: devolution_historic fk_appointment_devolution; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.devolution_historic
    ADD CONSTRAINT fk_appointment_devolution FOREIGN KEY (appointment_code) REFERENCES public.appointment(appointment_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: encuesta fk_appointment_encuesta; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.encuesta
    ADD CONSTRAINT fk_appointment_encuesta FOREIGN KEY (appointment_code) REFERENCES public.appointment(appointment_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: facturas_ordenes fk_codigo_factura_facturas; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas_ordenes
    ADD CONSTRAINT fk_codigo_factura_facturas FOREIGN KEY (id_factura) REFERENCES public.facturas(id_factura);


--
-- Name: internal_order fk_contrato_internal_order; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.internal_order
    ADD CONSTRAINT fk_contrato_internal_order FOREIGN KEY (id_contrato) REFERENCES public.contratos(id_contratos);


--
-- Name: facturas_capita fk_factura_capita; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas_capita
    ADD CONSTRAINT fk_factura_capita FOREIGN KEY (id_factura) REFERENCES public.facturas(id_factura);


--
-- Name: cuentas_puc fk_id_clases_puc_clases_puc; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cuentas_puc
    ADD CONSTRAINT fk_id_clases_puc_clases_puc FOREIGN KEY (id_clases_puc) REFERENCES public.clases_puc(id_clases_puc);


--
-- Name: contratos_modalidades fk_id_contrato_contratos; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_modalidades
    ADD CONSTRAINT fk_id_contrato_contratos FOREIGN KEY (id_contratos) REFERENCES public.contratos(id_contratos);


--
-- Name: facturas fk_id_contrato_contratos; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas
    ADD CONSTRAINT fk_id_contrato_contratos FOREIGN KEY (id_contrato) REFERENCES public.contratos(id_contratos);


--
-- Name: contratos_sedes fk_id_contrato_contratos; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_sedes
    ADD CONSTRAINT fk_id_contrato_contratos FOREIGN KEY (id_contratos) REFERENCES public.contratos(id_contratos);


--
-- Name: contratos_examenes fk_id_contratos_modalidad; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_examenes
    ADD CONSTRAINT fk_id_contratos_modalidad FOREIGN KEY (id_contratos_modalidad) REFERENCES public.contratos_modalidades(id_contratos_modalidad);


--
-- Name: contratos fk_id_cuenta_puc_cuentas_puc; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos
    ADD CONSTRAINT fk_id_cuenta_puc_cuentas_puc FOREIGN KEY (id_cuenta_puc) REFERENCES public.cuentas_puc(id_cuentas_puc);


--
-- Name: entity fk_id_cuotas_copagos_cuotas_copagos; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.entity
    ADD CONSTRAINT fk_id_cuotas_copagos_cuotas_copagos FOREIGN KEY (id_cuotas_copagos) REFERENCES public.cuotas_copagos(id_cuotas_copago);


--
-- Name: resoluciones fk_id_entidad_entity; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.resoluciones
    ADD CONSTRAINT fk_id_entidad_entity FOREIGN KEY (id_entidad) REFERENCES public.entity(id_entity);


--
-- Name: contratos fk_id_eps_eps; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos
    ADD CONSTRAINT fk_id_eps_eps FOREIGN KEY (id_eps) REFERENCES public.eps(id_eps);


--
-- Name: contratos_examenes fk_id_examen_study_list; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_examenes
    ADD CONSTRAINT fk_id_examen_study_list FOREIGN KEY (id_examen) REFERENCES public.study_list(id_study_list);


--
-- Name: contratos_modalidades fk_id_modalidad; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_modalidades
    ADD CONSTRAINT fk_id_modalidad FOREIGN KEY (id_modalidad) REFERENCES public.modality(id_modality);


--
-- Name: facturas_ordenes fk_id_orden_internal_order; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas_ordenes
    ADD CONSTRAINT fk_id_orden_internal_order FOREIGN KEY (id_orden) REFERENCES public.internal_order(internal_order_code);


--
-- Name: contratos_examenes fk_id_rate; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_examenes
    ADD CONSTRAINT fk_id_rate FOREIGN KEY (id_rate) REFERENCES public.rate(id);


--
-- Name: contratos fk_id_resolucion_resoluciones; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos
    ADD CONSTRAINT fk_id_resolucion_resoluciones FOREIGN KEY (id_resolucion) REFERENCES public.resoluciones(id_resoluciones);


--
-- Name: contratos_sedes fk_id_sede_headquarter; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_sedes
    ADD CONSTRAINT fk_id_sede_headquarter FOREIGN KEY (id_sede) REFERENCES public.headquarter(id_headquarter);


--
-- Name: auxiliary_transcription fk_id_trans; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auxiliary_transcription
    ADD CONSTRAINT fk_id_trans FOREIGN KEY (id_transcription) REFERENCES public.transcription(id_transcription) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: facturas fk_id_usuario_anulacion; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas
    ADD CONSTRAINT fk_id_usuario_anulacion FOREIGN KEY (id_usuario_anulacion) REFERENCES public.user_sonata(id);


--
-- Name: clases_puc fk_id_usuario_creacion_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.clases_puc
    ADD CONSTRAINT fk_id_usuario_creacion_user_sonata FOREIGN KEY (id_usuario_creacion) REFERENCES public.user_sonata(id);


--
-- Name: cuentas_puc fk_id_usuario_creacion_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cuentas_puc
    ADD CONSTRAINT fk_id_usuario_creacion_user_sonata FOREIGN KEY (id_usuario_creacion) REFERENCES public.user_sonata(id);


--
-- Name: facturas fk_id_usuario_creacion_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas
    ADD CONSTRAINT fk_id_usuario_creacion_user_sonata FOREIGN KEY (id_usuario_creacion) REFERENCES public.user_sonata(id);


--
-- Name: facturas_ordenes fk_id_usuario_creacion_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas_ordenes
    ADD CONSTRAINT fk_id_usuario_creacion_user_sonata FOREIGN KEY (id_usuario_creacion) REFERENCES public.user_sonata(id);


--
-- Name: contratos_modalidades fk_id_usuario_creador; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_modalidades
    ADD CONSTRAINT fk_id_usuario_creador FOREIGN KEY (id_usuario_creador) REFERENCES public.user_sonata(id);


--
-- Name: contratos_examenes fk_id_usuario_creador; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_examenes
    ADD CONSTRAINT fk_id_usuario_creador FOREIGN KEY (id_usuario_creador) REFERENCES public.user_sonata(id);


--
-- Name: contratos_sedes fk_id_usuario_creador; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_sedes
    ADD CONSTRAINT fk_id_usuario_creador FOREIGN KEY (id_usuario_creador) REFERENCES public.user_sonata(id);


--
-- Name: cie_10 fk_id_usuario_creador_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cie_10
    ADD CONSTRAINT fk_id_usuario_creador_user_sonata FOREIGN KEY (id_usuario_creador) REFERENCES public.user_sonata(id);


--
-- Name: resoluciones fk_id_usuario_creador_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.resoluciones
    ADD CONSTRAINT fk_id_usuario_creador_user_sonata FOREIGN KEY (id_usuario_creador) REFERENCES public.user_sonata(id);


--
-- Name: contratos fk_id_usuario_creador_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos
    ADD CONSTRAINT fk_id_usuario_creador_user_sonata FOREIGN KEY (id_usuario_creador) REFERENCES public.user_sonata(id);


--
-- Name: clases_puc fk_id_usuario_modificacion_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.clases_puc
    ADD CONSTRAINT fk_id_usuario_modificacion_user_sonata FOREIGN KEY (id_usuario_modificacion) REFERENCES public.user_sonata(id);


--
-- Name: cuentas_puc fk_id_usuario_modificacion_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cuentas_puc
    ADD CONSTRAINT fk_id_usuario_modificacion_user_sonata FOREIGN KEY (id_usuario_modificacion) REFERENCES public.user_sonata(id);


--
-- Name: contratos_modalidades fk_id_usuario_modificador; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_modalidades
    ADD CONSTRAINT fk_id_usuario_modificador FOREIGN KEY (id_usuario_modificador) REFERENCES public.user_sonata(id);


--
-- Name: contratos_examenes fk_id_usuario_modificador; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_examenes
    ADD CONSTRAINT fk_id_usuario_modificador FOREIGN KEY (id_usuario_modificador) REFERENCES public.user_sonata(id);


--
-- Name: contratos_sedes fk_id_usuario_modificador; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos_sedes
    ADD CONSTRAINT fk_id_usuario_modificador FOREIGN KEY (id_usuario_modificador) REFERENCES public.user_sonata(id);


--
-- Name: cie_10 fk_id_usuario_modificador_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cie_10
    ADD CONSTRAINT fk_id_usuario_modificador_user_sonata FOREIGN KEY (id_usuario_modificador) REFERENCES public.user_sonata(id);


--
-- Name: resoluciones fk_id_usuario_modificador_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.resoluciones
    ADD CONSTRAINT fk_id_usuario_modificador_user_sonata FOREIGN KEY (id_usuario_modificador) REFERENCES public.user_sonata(id);


--
-- Name: contratos fk_id_usuario_modificador_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contratos
    ADD CONSTRAINT fk_id_usuario_modificador_user_sonata FOREIGN KEY (id_usuario_modificador) REFERENCES public.user_sonata(id);


--
-- Name: facturas fk_id_usuario_radicacion; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facturas
    ADD CONSTRAINT fk_id_usuario_radicacion FOREIGN KEY (id_usuario_radicacion) REFERENCES public.user_sonata(id);


--
-- Name: modality_worklist fk_modWrk_appointment; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.modality_worklist
    ADD CONSTRAINT "fk_modWrk_appointment" FOREIGN KEY (appointment_code) REFERENCES public.appointment(appointment_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: recording fk_recording_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recording
    ADD CONSTRAINT fk_recording_user_sonata FOREIGN KEY (id_user) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: study fk_room_app_st_rec; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study
    ADD CONSTRAINT fk_room_app_st_rec FOREIGN KEY (id_room_appointment_study_receipt) REFERENCES public.room_appointment_study_receipt(id_room_appointment_study_receipt) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: clinical_data fk_room_appointment_study_receipt; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.clinical_data
    ADD CONSTRAINT fk_room_appointment_study_receipt FOREIGN KEY (id_room_appointment_study_receipt) REFERENCES public.room_appointment_study_receipt(id_room_appointment_study_receipt) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: study fk_study_list; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study
    ADD CONSTRAINT fk_study_list FOREIGN KEY (id_study_list) REFERENCES public.study_list(id_study_list) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: transcription_template fk_transTemp_Modality; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transcription_template
    ADD CONSTRAINT "fk_transTemp_Modality" FOREIGN KEY (id_modality) REFERENCES public.modality(id_modality) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: transcription_template fk_transTemp_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transcription_template
    ADD CONSTRAINT "fk_transTemp_user" FOREIGN KEY (id) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: data_result fk_transcription; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.data_result
    ADD CONSTRAINT fk_transcription FOREIGN KEY (id_transcription) REFERENCES public.transcription(id_transcription) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_sm fk_userHiruko_userVR; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm
    ADD CONSTRAINT "fk_userHiruko_userVR" FOREIGN KEY (id_user) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: devolution_historic fk_user_devolution_historic; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.devolution_historic
    ADD CONSTRAINT fk_user_devolution_historic FOREIGN KEY (id_user) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: devolution_historic fk_user_last_process; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.devolution_historic
    ADD CONSTRAINT fk_user_last_process FOREIGN KEY (id_user_last_process) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: auxiliary_transcription fk_user_sonata_aux_transc; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auxiliary_transcription
    ADD CONSTRAINT fk_user_sonata_aux_transc FOREIGN KEY (id_user) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: data_result fk_user_sonata_data_result; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.data_result
    ADD CONSTRAINT fk_user_sonata_data_result FOREIGN KEY (id_user) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: rips_data fk_user_sonata_rips_data; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rips_data
    ADD CONSTRAINT fk_user_sonata_rips_data FOREIGN KEY (id_user) REFERENCES public.user_sonata(id);


--
-- Name: valores_fijos fk_user_vf; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.valores_fijos
    ADD CONSTRAINT fk_user_vf FOREIGN KEY (usuario_creacion) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: internal_order fk_usuario_auditado_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.internal_order
    ADD CONSTRAINT fk_usuario_auditado_user_sonata FOREIGN KEY (usuario_auditado) REFERENCES public.user_sonata(id);


--
-- Name: internal_order fk_usuario_cancelacion_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.internal_order
    ADD CONSTRAINT fk_usuario_cancelacion_user_sonata FOREIGN KEY (usuario_cancelacion) REFERENCES public.user_sonata(id);


--
-- Name: internal_order fk_usuario_creador; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.internal_order
    ADD CONSTRAINT fk_usuario_creador FOREIGN KEY (id_usuario_creador) REFERENCES public.user_sonata(id);


--
-- Name: cuotas_copagos fk_usuario_creador_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cuotas_copagos
    ADD CONSTRAINT fk_usuario_creador_user_sonata FOREIGN KEY (id_usuario_creador) REFERENCES public.user_sonata(id);


--
-- Name: cuotas_copagos fk_usuario_modificador; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cuotas_copagos
    ADD CONSTRAINT fk_usuario_modificador FOREIGN KEY (id_usuario_modificador) REFERENCES public.user_sonata(id);


--
-- Name: fos_user_headquarter fos_user_headquarter; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fos_user_headquarter
    ADD CONSTRAINT fos_user_headquarter FOREIGN KEY (headquarter_id) REFERENCES public.headquarter(id_headquarter) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: fos_user_headquarter fos_user_headquarter_user_sonata; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fos_user_headquarter
    ADD CONSTRAINT fos_user_headquarter_user_sonata FOREIGN KEY (user_id) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: room_appointment_study_receipt id_cardiologia_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room_appointment_study_receipt
    ADD CONSTRAINT id_cardiologia_fkey FOREIGN KEY (id_cardiologia) REFERENCES public.cardiologia(id);


--
-- Name: person_data id_document_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.person_data
    ADD CONSTRAINT id_document_type FOREIGN KEY (id_document_type) REFERENCES public.document_type(id_document_type) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: room_appointment_study_receipt id_infectologia_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room_appointment_study_receipt
    ADD CONSTRAINT id_infectologia_fkey FOREIGN KEY (id_infectologia) REFERENCES public.infectologia(id);


--
-- Name: room_appointment_study_receipt id_neuro_psiquiatria_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room_appointment_study_receipt
    ADD CONSTRAINT id_neuro_psiquiatria_fkey FOREIGN KEY (id_neuro_psiquiatria) REFERENCES public.neuro_psiquiatria(id);


--
-- Name: room_appointment_study_receipt id_oncologia_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room_appointment_study_receipt
    ADD CONSTRAINT id_oncologia_fkey FOREIGN KEY (id_oncologia) REFERENCES public.oncologia(id);


--
-- Name: plates_registry id_person; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plates_registry
    ADD CONSTRAINT id_person FOREIGN KEY (id_person) REFERENCES public.person_data(id_person) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: room_appointment_study_receipt id_radiologo_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room_appointment_study_receipt
    ADD CONSTRAINT id_radiologo_fkey FOREIGN KEY (id_radiologo) REFERENCES public.user_sonata(id);


--
-- Name: second_opinion id_requested_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.second_opinion
    ADD CONSTRAINT id_requested_user FOREIGN KEY (id_requested_user) REFERENCES public.user_sonata(id);


--
-- Name: second_opinion id_requesting_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.second_opinion
    ADD CONSTRAINT id_requesting_user FOREIGN KEY (id_user_request) REFERENCES public.user_sonata(id);


--
-- Name: schedule_logs id_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule_logs
    ADD CONSTRAINT id_user FOREIGN KEY (id_user) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: appointment id_user_reading; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.appointment
    ADD CONSTRAINT id_user_reading FOREIGN KEY (id_user_reading) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rel_insumos_estudios insumo_estudio; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_insumos_estudios
    ADD CONSTRAINT insumo_estudio FOREIGN KEY (study_code) REFERENCES public.study(study_code) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: internal_order internal_order_id_out_site_user_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.internal_order
    ADD CONSTRAINT internal_order_id_out_site_user_fkey FOREIGN KEY (id_out_site_user) REFERENCES public.out_site_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: margen_reportes margen_reportes_id_headquarter_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.margen_reportes
    ADD CONSTRAINT margen_reportes_id_headquarter_fkey FOREIGN KEY (id_headquarter) REFERENCES public.headquarter(id_headquarter);


--
-- Name: municipality municipality_department_code_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.municipality
    ADD CONSTRAINT municipality_department_code_fkey FOREIGN KEY (department_code) REFERENCES public.department(department_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: patient patient_municipality_code_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.patient
    ADD CONSTRAINT patient_municipality_code_fkey FOREIGN KEY (municipality_code) REFERENCES public.municipality(municipality_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: payment_form payment_form_id_account_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payment_form
    ADD CONSTRAINT payment_form_id_account_fkey FOREIGN KEY (id_account) REFERENCES public.account(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: payment_form payment_form_id_bank_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payment_form
    ADD CONSTRAINT payment_form_id_bank_fkey FOREIGN KEY (id_bank) REFERENCES public.bank(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: patient person_data_pkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.patient
    ADD CONSTRAINT person_data_pkey FOREIGN KEY (id_person) REFERENCES public.person_data(id_person) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rate rate_id_base_price_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rate
    ADD CONSTRAINT rate_id_base_price_fkey FOREIGN KEY (id_base_price) REFERENCES public.base_price(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rate rate_id_study_list_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rate
    ADD CONSTRAINT rate_id_study_list_fkey FOREIGN KEY (id_study_list) REFERENCES public.study_list(id_study_list) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: recording recording_id_room_appointment_study_receipt_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recording
    ADD CONSTRAINT recording_id_room_appointment_study_receipt_fkey FOREIGN KEY (id_room_appointment_study_receipt) REFERENCES public.room_appointment_study_receipt(id_room_appointment_study_receipt) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: rel_study_list_consent rel_study_list_consent_id_consent_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_consent
    ADD CONSTRAINT rel_study_list_consent_id_consent_fkey FOREIGN KEY (id_consent) REFERENCES public.consent(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rel_study_list_consent rel_study_list_consent_id_study_list_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_consent
    ADD CONSTRAINT rel_study_list_consent_id_study_list_fkey FOREIGN KEY (id_study_list) REFERENCES public.study_list(id_study_list) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rel_study_list_contra_indication rel_study_list_contra_indication_id_contra_indication_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_contra_indication
    ADD CONSTRAINT rel_study_list_contra_indication_id_contra_indication_fkey FOREIGN KEY (id_contra_indication) REFERENCES public.contra_indication(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rel_study_list_contra_indication rel_study_list_contra_indication_id_study_list_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_contra_indication
    ADD CONSTRAINT rel_study_list_contra_indication_id_study_list_fkey FOREIGN KEY (id_study_list) REFERENCES public.study_list(id_study_list) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rel_study_list_indication rel_study_list_indication_id_indication_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_indication
    ADD CONSTRAINT rel_study_list_indication_id_indication_fkey FOREIGN KEY (id_indication) REFERENCES public.indication(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rel_study_list_indication rel_study_list_indication_id_study_list_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_indication
    ADD CONSTRAINT rel_study_list_indication_id_study_list_fkey FOREIGN KEY (id_study_list) REFERENCES public.study_list(id_study_list) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rel_study_list_preparation rel_study_list_preparation_id_preparation_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_preparation
    ADD CONSTRAINT rel_study_list_preparation_id_preparation_fkey FOREIGN KEY (id_preparation) REFERENCES public.preparation(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: rel_study_list_preparation rel_study_list_preparation_id_study_list_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rel_study_list_preparation
    ADD CONSTRAINT rel_study_list_preparation_id_study_list_fkey FOREIGN KEY (id_study_list) REFERENCES public.study_list(id_study_list) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: room_appointment_study_receipt room_appointment_study_receipt_appointment_code_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room_appointment_study_receipt
    ADD CONSTRAINT room_appointment_study_receipt_appointment_code_fkey FOREIGN KEY (appointment_code) REFERENCES public.appointment(appointment_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: room_appointment_study_receipt room_appointment_study_receipt_room_code_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room_appointment_study_receipt
    ADD CONSTRAINT room_appointment_study_receipt_room_code_fkey FOREIGN KEY (room_code) REFERENCES public.room(room_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: room_appointment_study_receipt room_appointment_userback_sonata_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room_appointment_study_receipt
    ADD CONSTRAINT room_appointment_userback_sonata_fkey FOREIGN KEY (id_user_back) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: room_appointment_study_receipt room_appointment_userras_sonata_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room_appointment_study_receipt
    ADD CONSTRAINT room_appointment_userras_sonata_fkey FOREIGN KEY (id_user_ras) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: room room_id_headquarter_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room
    ADD CONSTRAINT room_id_headquarter_fkey FOREIGN KEY (id_headquarter) REFERENCES public.headquarter(id_headquarter) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: room room_id_modality_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.room
    ADD CONSTRAINT room_id_modality_fkey FOREIGN KEY (id_modality) REFERENCES public.modality(id_modality) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: schedule schedule_appointment_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule
    ADD CONSTRAINT schedule_appointment_fk FOREIGN KEY (appointment_code) REFERENCES public.appointment(appointment_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: schedule schedule_block_des; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule
    ADD CONSTRAINT schedule_block_des FOREIGN KEY (id_blockade_event) REFERENCES public.block_des(id_blocked) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: schedule schedule_diary_blockade; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule
    ADD CONSTRAINT schedule_diary_blockade FOREIGN KEY (id_diary_blockade) REFERENCES public.diary_blockade(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: schedule schedule_room_id_room_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule
    ADD CONSTRAINT schedule_room_id_room_fk FOREIGN KEY (id_room) REFERENCES public.room(room_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: schedule_rules schedule_rules_id_room_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule_rules
    ADD CONSTRAINT schedule_rules_id_room_fkey FOREIGN KEY (id_room) REFERENCES public.room(room_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: schedule_rules schedule_rules_id_user_creator_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule_rules
    ADD CONSTRAINT schedule_rules_id_user_creator_fkey FOREIGN KEY (id_user_creator) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: schedule schedule_schedule_rule; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule
    ADD CONSTRAINT schedule_schedule_rule FOREIGN KEY (id_schedule_rules) REFERENCES public.schedule_rules(id_schedule_rules) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: schedule schedule_sms; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule
    ADD CONSTRAINT schedule_sms FOREIGN KEY (id_schedule_sms) REFERENCES public.schedule_sms(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: schedule schedule_user_cancel_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule
    ADD CONSTRAINT schedule_user_cancel_fk FOREIGN KEY (id_user_cancel) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: schedule schedule_user_creator_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedule
    ADD CONSTRAINT schedule_user_creator_fk FOREIGN KEY (id_user_creator) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: study_detail st_detail_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study_detail
    ADD CONSTRAINT st_detail_fk FOREIGN KEY (id_room_appointment_study_receipt) REFERENCES public.room_appointment_study_receipt(id_room_appointment_study_receipt) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: study study_id_modality_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study
    ADD CONSTRAINT study_id_modality_fkey FOREIGN KEY (id_modality) REFERENCES public.modality(id_modality) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: study_list study_list_id_modality_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study_list
    ADD CONSTRAINT study_list_id_modality_fkey FOREIGN KEY (id_modality) REFERENCES public.modality(id_modality) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: study_list study_list_id_speciality; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study_list
    ADD CONSTRAINT study_list_id_speciality FOREIGN KEY (id_speciality) REFERENCES public.speciality(id_speciality) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: study_rate study_rate_id_rate_type_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study_rate
    ADD CONSTRAINT study_rate_id_rate_type_fkey FOREIGN KEY (id_rate_type) REFERENCES public.rate_type(id_rate_type) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: study_rate study_rate_id_study_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.study_rate
    ADD CONSTRAINT study_rate_id_study_fkey FOREIGN KEY (study_code) REFERENCES public.study(study_code) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: plates_registry user_plates; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plates_registry
    ADD CONSTRAINT user_plates FOREIGN KEY (id_user_tecno) REFERENCES public.user_sonata(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_schedule user_schedule_id_schedule_id_schedule_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_schedule
    ADD CONSTRAINT user_schedule_id_schedule_id_schedule_fk FOREIGN KEY (id_schedule) REFERENCES public.schedule_rules(id_schedule_rules);


--
-- Name: user_schedule user_schedule_id_user_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_schedule
    ADD CONSTRAINT user_schedule_id_user_id_fk FOREIGN KEY (id_user) REFERENCES public.user_sonata(id);


--
-- Name: user_sm_languages user_sm_Languages_id_languages_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm_languages
    ADD CONSTRAINT "user_sm_Languages_id_languages_fkey" FOREIGN KEY (id_languages) REFERENCES public.sm_languages(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_sm_languages user_sm_Languages_id_user_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm_languages
    ADD CONSTRAINT "user_sm_Languages_id_user_fkey" FOREIGN KEY (id_user) REFERENCES public.user_sm(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_sm_microphones user_sm_Microphones_id_microphones_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm_microphones
    ADD CONSTRAINT "user_sm_Microphones_id_microphones_fkey" FOREIGN KEY (id_microphones) REFERENCES public.sm_microphones(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_sm_microphones user_sm_Microphones_id_user_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm_microphones
    ADD CONSTRAINT "user_sm_Microphones_id_user_fkey" FOREIGN KEY (id_user) REFERENCES public.user_sm(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_sm_topics user_sm_Topics_id_topics_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm_topics
    ADD CONSTRAINT "user_sm_Topics_id_topics_fkey" FOREIGN KEY (id_topics) REFERENCES public.sm_topics(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_sm_topics user_sm_Topics_id_user_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm_topics
    ADD CONSTRAINT "user_sm_Topics_id_user_fkey" FOREIGN KEY (id_user) REFERENCES public.user_sm(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_sm user_sm_id_NUSAI_licenseGuid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm
    ADD CONSTRAINT "user_sm_id_NUSAI_licenseGuid_fkey" FOREIGN KEY (id_nusai_licenseguid) REFERENCES public.sm_licenseguid(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_sm user_sm_id_NUSAI_partnerGuid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm
    ADD CONSTRAINT "user_sm_id_NUSAI_partnerGuid_fkey" FOREIGN KEY (id_nusai_partnerguid) REFERENCES public.sm_partnerguid(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_sm user_sm_id_ServerURL_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_sm
    ADD CONSTRAINT "user_sm_id_ServerURL_fkey" FOREIGN KEY (id_serverurl) REFERENCES public.sm_serverurl(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: vna_files vna_files_id_study_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vna_files
    ADD CONSTRAINT vna_files_id_study_fkey FOREIGN KEY (id_study) REFERENCES public.vna_studies(id);


--
-- Name: vna_studies vna_studies_patient_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vna_studies
    ADD CONSTRAINT vna_studies_patient_id_fkey FOREIGN KEY (patient_id) REFERENCES public.patient(id_patient);


--
-- Name: vna_studies vna_studies_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vna_studies
    ADD CONSTRAINT vna_studies_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.user_sonata(id);


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
--

GRANT USAGE ON SCHEMA public TO zeus;
GRANT USAGE ON SCHEMA public TO sonata;


--
-- Name: TABLE absence_reasons; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.absence_reasons TO sonata;
GRANT SELECT ON TABLE public.absence_reasons TO zeus;


--
-- Name: SEQUENCE absence_reasons_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.absence_reasons_id_seq TO sonata;
GRANT SELECT ON SEQUENCE public.absence_reasons_id_seq TO zeus;


--
-- Name: TABLE account; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.account TO sonata;
GRANT SELECT ON TABLE public.account TO zeus;


--
-- Name: SEQUENCE account_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.account_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.account_id_seq TO sonata;


--
-- Name: TABLE acl_classes; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.acl_classes TO sonata;
GRANT SELECT ON TABLE public.acl_classes TO zeus;


--
-- Name: SEQUENCE acl_classes_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.acl_classes_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.acl_classes_id_seq TO sonata;


--
-- Name: TABLE acl_entries; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.acl_entries TO sonata;
GRANT SELECT ON TABLE public.acl_entries TO zeus;


--
-- Name: SEQUENCE acl_entries_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.acl_entries_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.acl_entries_id_seq TO sonata;


--
-- Name: TABLE acl_object_identities; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.acl_object_identities TO sonata;
GRANT SELECT ON TABLE public.acl_object_identities TO zeus;


--
-- Name: SEQUENCE acl_object_identities_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.acl_object_identities_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.acl_object_identities_id_seq TO sonata;


--
-- Name: TABLE acl_object_identity_ancestors; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.acl_object_identity_ancestors TO sonata;
GRANT SELECT ON TABLE public.acl_object_identity_ancestors TO zeus;


--
-- Name: TABLE acl_security_identities; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.acl_security_identities TO sonata;
GRANT SELECT ON TABLE public.acl_security_identities TO zeus;


--
-- Name: SEQUENCE acl_security_identities_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.acl_security_identities_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.acl_security_identities_id_seq TO sonata;


--
-- Name: TABLE adendum; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.adendum TO sonata;
GRANT SELECT ON TABLE public.adendum TO zeus;


--
-- Name: TABLE affiliation_type; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.affiliation_type TO sonata;
GRANT SELECT ON TABLE public.affiliation_type TO zeus;


--
-- Name: SEQUENCE appointment_sequence_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.appointment_sequence_seq TO zeus;
GRANT SELECT ON SEQUENCE public.appointment_sequence_seq TO sonata;


--
-- Name: TABLE appointment; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.appointment TO zeus;
GRANT SELECT ON TABLE public.appointment TO sonata;


--
-- Name: SEQUENCE appointment_code_co_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.appointment_code_co_seq TO zeus;
GRANT SELECT ON SEQUENCE public.appointment_code_co_seq TO sonata;


--
-- Name: TABLE auxiliary_transcription; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.auxiliary_transcription TO zeus;
GRANT SELECT ON TABLE public.auxiliary_transcription TO sonata;


--
-- Name: TABLE bank; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.bank TO sonata;
GRANT SELECT ON TABLE public.bank TO zeus;


--
-- Name: SEQUENCE bank_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.bank_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.bank_id_seq TO sonata;


--
-- Name: TABLE base_price; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.base_price TO sonata;
GRANT SELECT ON TABLE public.base_price TO zeus;


--
-- Name: SEQUENCE base_price_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.base_price_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.base_price_id_seq TO sonata;


--
-- Name: TABLE benefit_plan; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.benefit_plan TO sonata;
GRANT SELECT ON TABLE public.benefit_plan TO zeus;


--
-- Name: SEQUENCE benefit_plan_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.benefit_plan_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.benefit_plan_id_seq TO sonata;


--
-- Name: SEQUENCE bill_requirement_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.bill_requirement_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.bill_requirement_id_seq TO sonata;


--
-- Name: TABLE block_des; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.block_des TO zeus;
GRANT SELECT ON TABLE public.block_des TO sonata;


--
-- Name: SEQUENCE block_des_id_blocked_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.block_des_id_blocked_seq TO zeus;
GRANT SELECT ON SEQUENCE public.block_des_id_blocked_seq TO sonata;


--
-- Name: SEQUENCE id_formularios_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.id_formularios_seq TO zeus;
GRANT SELECT ON SEQUENCE public.id_formularios_seq TO sonata;


--
-- Name: TABLE campos_de_formularios; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.campos_de_formularios TO sonata;
GRANT SELECT ON TABLE public.campos_de_formularios TO zeus;


--
-- Name: SEQUENCE cancellation_reason_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.cancellation_reason_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.cancellation_reason_id_seq TO sonata;


--
-- Name: TABLE cancellation_reason; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.cancellation_reason TO sonata;
GRANT SELECT ON TABLE public.cancellation_reason TO zeus;


--
-- Name: SEQUENCE id_cardiologia_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.id_cardiologia_seq TO zeus;
GRANT SELECT ON SEQUENCE public.id_cardiologia_seq TO sonata;


--
-- Name: TABLE cardiologia; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.cardiologia TO zeus;
GRANT SELECT ON TABLE public.cardiologia TO sonata;


--
-- Name: TABLE cie_10; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.cie_10 TO zeus;
GRANT SELECT,INSERT,UPDATE ON TABLE public.cie_10 TO sonata;


--
-- Name: SEQUENCE cie_10_id_cie_10_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.cie_10_id_cie_10_seq TO zeus;
GRANT SELECT ON SEQUENCE public.cie_10_id_cie_10_seq TO sonata;


--
-- Name: TABLE clinical_data; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.clinical_data TO zeus;
GRANT SELECT ON TABLE public.clinical_data TO sonata;


--
-- Name: SEQUENCE clinical_file_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.clinical_file_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.clinical_file_id_seq TO sonata;


--
-- Name: TABLE clinical_file; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.clinical_file TO zeus;
GRANT SELECT ON TABLE public.clinical_file TO sonata;


--
-- Name: SEQUENCE codigo_internal_order; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.codigo_internal_order TO zeus;
GRANT SELECT ON SEQUENCE public.codigo_internal_order TO sonata;


--
-- Name: SEQUENCE concordance_id_concordance_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.concordance_id_concordance_seq TO zeus;
GRANT SELECT ON SEQUENCE public.concordance_id_concordance_seq TO sonata;


--
-- Name: TABLE concordance; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.concordance TO zeus;
GRANT SELECT ON TABLE public.concordance TO sonata;


--
-- Name: SEQUENCE consent_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.consent_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.consent_id_seq TO sonata;


--
-- Name: TABLE consent; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.consent TO zeus;
GRANT SELECT ON TABLE public.consent TO sonata;


--
-- Name: TABLE contra_indication; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.contra_indication TO sonata;
GRANT SELECT ON TABLE public.contra_indication TO zeus;


--
-- Name: SEQUENCE contra_indication_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.contra_indication_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.contra_indication_id_seq TO sonata;


--
-- Name: SEQUENCE contract_type_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.contract_type_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.contract_type_id_seq TO sonata;


--
-- Name: TABLE copayment; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.copayment TO sonata;
GRANT SELECT ON TABLE public.copayment TO zeus;


--
-- Name: TABLE data_result; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.data_result TO zeus;
GRANT SELECT ON TABLE public.data_result TO sonata;


--
-- Name: SEQUENCE data_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.data_seq TO zeus;
GRANT SELECT ON SEQUENCE public.data_seq TO sonata;


--
-- Name: TABLE days; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.days TO sonata;
GRANT SELECT ON TABLE public.days TO zeus;


--
-- Name: TABLE days_schedule; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.days_schedule TO sonata;


--
-- Name: TABLE department; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.department TO sonata;
GRANT SELECT ON TABLE public.department TO zeus;


--
-- Name: TABLE devolution_historic; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.devolution_historic TO zeus;
GRANT SELECT ON TABLE public.devolution_historic TO sonata;


--
-- Name: SEQUENCE diary_blockade_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.diary_blockade_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.diary_blockade_id_seq TO sonata;


--
-- Name: TABLE diary_blockade; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.diary_blockade TO sonata;
GRANT SELECT ON TABLE public.diary_blockade TO zeus;


--
-- Name: TABLE document_type; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.document_type TO sonata;
GRANT SELECT ON TABLE public.document_type TO zeus;


--
-- Name: SEQUENCE encuesta_id_encuesta_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.encuesta_id_encuesta_seq TO zeus;
GRANT SELECT ON SEQUENCE public.encuesta_id_encuesta_seq TO sonata;


--
-- Name: TABLE encuesta; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.encuesta TO zeus;
GRANT SELECT ON TABLE public.encuesta TO sonata;


--
-- Name: TABLE entity; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.entity TO sonata;
GRANT SELECT ON TABLE public.entity TO zeus;


--
-- Name: TABLE eps; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.eps TO sonata;
GRANT SELECT ON TABLE public.eps TO zeus;


--
-- Name: TABLE eps_type; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.eps_type TO sonata;
GRANT SELECT ON TABLE public.eps_type TO zeus;


--
-- Name: SEQUENCE eps_type_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.eps_type_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.eps_type_id_seq TO sonata;


--
-- Name: SEQUENCE especialidad_medico_id_especialidad_medico_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.especialidad_medico_id_especialidad_medico_seq TO zeus;
GRANT SELECT ON SEQUENCE public.especialidad_medico_id_especialidad_medico_seq TO sonata;


--
-- Name: TABLE especialidad_medico; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.especialidad_medico TO sonata;
GRANT SELECT ON TABLE public.especialidad_medico TO zeus;


--
-- Name: SEQUENCE fields_id_fields_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.fields_id_fields_seq TO zeus;
GRANT SELECT ON SEQUENCE public.fields_id_fields_seq TO sonata;


--
-- Name: TABLE fixed_price; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.fixed_price TO sonata;
GRANT SELECT ON TABLE public.fixed_price TO zeus;


--
-- Name: SEQUENCE fixed_price_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.fixed_price_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.fixed_price_id_seq TO sonata;


--
-- Name: TABLE formularios; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,UPDATE ON TABLE public.formularios TO sonata;
GRANT SELECT ON TABLE public.formularios TO zeus;


--
-- Name: SEQUENCE fos_user_headquarter_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.fos_user_headquarter_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.fos_user_headquarter_id_seq TO sonata;


--
-- Name: TABLE fos_user_headquarter; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.fos_user_headquarter TO sonata;
GRANT SELECT ON TABLE public.fos_user_headquarter TO zeus;


--
-- Name: TABLE fos_user_user_group; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.fos_user_user_group TO sonata;
GRANT SELECT ON TABLE public.fos_user_user_group TO zeus;


--
-- Name: SEQUENCE group_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.group_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.group_id_seq TO sonata;


--
-- Name: TABLE group_sonata; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.group_sonata TO sonata;
GRANT SELECT ON TABLE public.group_sonata TO zeus;


--
-- Name: SEQUENCE group_sonata_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.group_sonata_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.group_sonata_id_seq TO sonata;


--
-- Name: TABLE headquarter; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.headquarter TO sonata;
GRANT SELECT ON TABLE public.headquarter TO zeus;


--
-- Name: TABLE historial_patient; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.historial_patient TO zeus;
GRANT SELECT ON TABLE public.historial_patient TO sonata;


--
-- Name: SEQUENCE id_campos_de_formulario_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.id_campos_de_formulario_seq TO zeus;
GRANT SELECT ON SEQUENCE public.id_campos_de_formulario_seq TO sonata;


--
-- Name: SEQUENCE id_hisris_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.id_hisris_seq TO zeus;
GRANT SELECT ON SEQUENCE public.id_hisris_seq TO sonata;


--
-- Name: SEQUENCE id_infectologia_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.id_infectologia_seq TO zeus;
GRANT SELECT ON SEQUENCE public.id_infectologia_seq TO sonata;


--
-- Name: SEQUENCE id_neuro_psiquiatria_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.id_neuro_psiquiatria_seq TO zeus;
GRANT SELECT ON SEQUENCE public.id_neuro_psiquiatria_seq TO sonata;


--
-- Name: SEQUENCE id_oncologia_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.id_oncologia_seq TO zeus;
GRANT SELECT ON SEQUENCE public.id_oncologia_seq TO sonata;


--
-- Name: SEQUENCE indication_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.indication_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.indication_id_seq TO sonata;


--
-- Name: TABLE indication; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.indication TO zeus;
GRANT SELECT ON TABLE public.indication TO sonata;


--
-- Name: TABLE infectologia; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.infectologia TO zeus;
GRANT SELECT ON TABLE public.infectologia TO sonata;


--
-- Name: TABLE internal_order; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.internal_order TO zeus;
GRANT SELECT ON TABLE public.internal_order TO sonata;


--
-- Name: TABLE iva_privity; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.iva_privity TO zeus;
GRANT SELECT ON TABLE public.iva_privity TO sonata;


--
-- Name: SEQUENCE iva_privity_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.iva_privity_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.iva_privity_id_seq TO sonata;


--
-- Name: TABLE level; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.level TO zeus;
GRANT SELECT ON TABLE public.level TO sonata;


--
-- Name: SEQUENCE margen_reportes_id_report_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.margen_reportes_id_report_seq TO zeus;
GRANT SELECT ON SEQUENCE public.margen_reportes_id_report_seq TO sonata;


--
-- Name: TABLE margen_reportes; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.margen_reportes TO zeus;
GRANT SELECT ON TABLE public.margen_reportes TO sonata;


--
-- Name: TABLE modality; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.modality TO zeus;
GRANT SELECT ON TABLE public.modality TO sonata;


--
-- Name: TABLE modality_worklist; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.modality_worklist TO zeus;
GRANT SELECT ON TABLE public.modality_worklist TO sonata;


--
-- Name: SEQUENCE modality_worklist_id_modality_worklist_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.modality_worklist_id_modality_worklist_seq TO zeus;
GRANT SELECT ON SEQUENCE public.modality_worklist_id_modality_worklist_seq TO sonata;


--
-- Name: TABLE municipality; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.municipality TO zeus;
GRANT SELECT ON TABLE public.municipality TO sonata;


--
-- Name: TABLE neuro_psiquiatria; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.neuro_psiquiatria TO zeus;
GRANT SELECT ON TABLE public.neuro_psiquiatria TO sonata;


--
-- Name: SEQUENCE noconfirmation_reason_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.noconfirmation_reason_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.noconfirmation_reason_id_seq TO sonata;


--
-- Name: TABLE noconfirmation_reason; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.noconfirmation_reason TO zeus;
GRANT SELECT ON TABLE public.noconfirmation_reason TO sonata;


--
-- Name: TABLE oncologia; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.oncologia TO zeus;
GRANT SELECT ON TABLE public.oncologia TO sonata;


--
-- Name: SEQUENCE oru_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.oru_seq TO zeus;
GRANT SELECT ON SEQUENCE public.oru_seq TO sonata;


--
-- Name: SEQUENCE out_site_patient_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.out_site_patient_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.out_site_patient_id_seq TO sonata;


--
-- Name: TABLE out_site_patient; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.out_site_patient TO zeus;
GRANT SELECT ON TABLE public.out_site_patient TO sonata;


--
-- Name: SEQUENCE out_site_user_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.out_site_user_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.out_site_user_id_seq TO sonata;


--
-- Name: TABLE out_site_user; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.out_site_user TO zeus;
GRANT SELECT ON TABLE public.out_site_user TO sonata;


--
-- Name: TABLE patient; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.patient TO zeus;
GRANT SELECT ON TABLE public.patient TO sonata;


--
-- Name: TABLE patient_consent; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.patient_consent TO zeus;
GRANT SELECT ON TABLE public.patient_consent TO sonata;


--
-- Name: TABLE payment_form; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.payment_form TO zeus;
GRANT SELECT ON TABLE public.payment_form TO sonata;


--
-- Name: SEQUENCE payment_form_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.payment_form_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.payment_form_id_seq TO sonata;


--
-- Name: TABLE person_data; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.person_data TO zeus;
GRANT SELECT ON TABLE public.person_data TO sonata;


--
-- Name: TABLE plates_registry; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.plates_registry TO zeus;
GRANT SELECT ON TABLE public.plates_registry TO sonata;


--
-- Name: SEQUENCE plates_registry_id_registry_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.plates_registry_id_registry_seq TO zeus;
GRANT SELECT ON SEQUENCE public.plates_registry_id_registry_seq TO sonata;


--
-- Name: SEQUENCE preparation_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.preparation_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.preparation_id_seq TO sonata;


--
-- Name: TABLE preparation; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.preparation TO zeus;
GRANT SELECT ON TABLE public.preparation TO sonata;


--
-- Name: SEQUENCE priority_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.priority_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.priority_id_seq TO sonata;


--
-- Name: TABLE priority; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.priority TO zeus;
GRANT SELECT ON TABLE public.priority TO sonata;


--
-- Name: SEQUENCE provenance_date_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.provenance_date_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.provenance_date_id_seq TO sonata;


--
-- Name: TABLE provenance_date; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.provenance_date TO zeus;
GRANT SELECT ON TABLE public.provenance_date TO sonata;


--
-- Name: SEQUENCE prueba_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.prueba_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.prueba_id_seq TO sonata;


--
-- Name: SEQUENCE rate_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.rate_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.rate_id_seq TO sonata;


--
-- Name: TABLE rate; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.rate TO zeus;
GRANT SELECT ON TABLE public.rate TO sonata;


--
-- Name: TABLE rate_type; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.rate_type TO zeus;
GRANT SELECT ON TABLE public.rate_type TO sonata;


--
-- Name: TABLE reception_requirement; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.reception_requirement TO zeus;
GRANT SELECT ON TABLE public.reception_requirement TO sonata;


--
-- Name: SEQUENCE reception_requirement_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.reception_requirement_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.reception_requirement_id_seq TO sonata;


--
-- Name: TABLE recorder; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.recorder TO zeus;
GRANT SELECT ON TABLE public.recorder TO sonata;


--
-- Name: TABLE recording; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.recording TO zeus;
GRANT SELECT ON TABLE public.recording TO sonata;


--
-- Name: TABLE regime_affiliate; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.regime_affiliate TO zeus;
GRANT SELECT ON TABLE public.regime_affiliate TO sonata;


--
-- Name: SEQUENCE regime_affiliate_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.regime_affiliate_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.regime_affiliate_id_seq TO sonata;


--
-- Name: TABLE rel_study_list_consent; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.rel_study_list_consent TO zeus;
GRANT SELECT ON TABLE public.rel_study_list_consent TO sonata;


--
-- Name: TABLE rel_study_list_contra_indication; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.rel_study_list_contra_indication TO zeus;
GRANT SELECT ON TABLE public.rel_study_list_contra_indication TO sonata;


--
-- Name: TABLE rel_study_list_indication; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.rel_study_list_indication TO zeus;
GRANT SELECT ON TABLE public.rel_study_list_indication TO sonata;


--
-- Name: TABLE rel_study_list_preparation; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.rel_study_list_preparation TO zeus;
GRANT SELECT ON TABLE public.rel_study_list_preparation TO sonata;


--
-- Name: SEQUENCE room_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.room_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.room_id_seq TO sonata;


--
-- Name: TABLE room; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.room TO zeus;
GRANT SELECT ON TABLE public.room TO sonata;


--
-- Name: TABLE room_appointment_study_receipt; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.room_appointment_study_receipt TO zeus;
GRANT SELECT ON TABLE public.room_appointment_study_receipt TO sonata;


--
-- Name: SEQUENCE schedule_logs_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.schedule_logs_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.schedule_logs_id_seq TO sonata;


--
-- Name: TABLE schedule_logs; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.schedule_logs TO zeus;
GRANT SELECT ON TABLE public.schedule_logs TO sonata;


--
-- Name: TABLE transcription; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.transcription TO zeus;
GRANT SELECT ON TABLE public.transcription TO sonata;


--
-- Name: TABLE user_sonata; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.user_sonata TO zeus;
GRANT ALL ON TABLE public.user_sonata TO sonata;


--
-- Name: TABLE study; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.study TO zeus;
GRANT SELECT ON TABLE public.study TO sonata;


--
-- Name: TABLE study_list; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.study_list TO zeus;
GRANT SELECT ON TABLE public.study_list TO sonata;


--
-- Name: TABLE requirement; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.requirement TO zeus;
GRANT SELECT ON TABLE public.requirement TO sonata;


--
-- Name: SEQUENCE reservation_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.reservation_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.reservation_id_seq TO sonata;


--
-- Name: TABLE reservation; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.reservation TO zeus;
GRANT SELECT ON TABLE public.reservation TO sonata;


--
-- Name: SEQUENCE restem_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.restem_seq TO zeus;
GRANT SELECT ON SEQUENCE public.restem_seq TO sonata;


--
-- Name: SEQUENCE resultem_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.resultem_seq TO zeus;
GRANT SELECT ON SEQUENCE public.resultem_seq TO sonata;


--
-- Name: SEQUENCE rips_data_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.rips_data_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.rips_data_id_seq TO sonata;


--
-- Name: TABLE rips_data; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.rips_data TO zeus;
GRANT SELECT ON TABLE public.rips_data TO sonata;


--
-- Name: SEQUENCE room_room_code_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.room_room_code_seq TO zeus;
GRANT SELECT ON SEQUENCE public.room_room_code_seq TO sonata;


--
-- Name: TABLE schedule; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.schedule TO zeus;
GRANT SELECT ON TABLE public.schedule TO sonata;


--
-- Name: SEQUENCE schedule_id_schedule_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.schedule_id_schedule_seq TO zeus;
GRANT SELECT ON SEQUENCE public.schedule_id_schedule_seq TO sonata;


--
-- Name: TABLE schedule_rules; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.schedule_rules TO zeus;
GRANT SELECT ON TABLE public.schedule_rules TO sonata;


--
-- Name: SEQUENCE schedule_rules_id_schedule_rules_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.schedule_rules_id_schedule_rules_seq TO zeus;
GRANT SELECT ON SEQUENCE public.schedule_rules_id_schedule_rules_seq TO sonata;


--
-- Name: SEQUENCE schedule_sms_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.schedule_sms_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.schedule_sms_id_seq TO sonata;


--
-- Name: TABLE schedule_sms; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.schedule_sms TO zeus;
GRANT SELECT ON TABLE public.schedule_sms TO sonata;


--
-- Name: SEQUENCE schedule_sms_logs_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.schedule_sms_logs_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.schedule_sms_logs_id_seq TO sonata;


--
-- Name: TABLE schedule_sms_logs; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.schedule_sms_logs TO zeus;
GRANT SELECT ON TABLE public.schedule_sms_logs TO sonata;


--
-- Name: SEQUENCE second_opinion_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.second_opinion_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.second_opinion_id_seq TO sonata;


--
-- Name: TABLE second_opinion; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.second_opinion TO zeus;
GRANT SELECT ON TABLE public.second_opinion TO sonata;


--
-- Name: TABLE sm_languages; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.sm_languages TO zeus;
GRANT SELECT ON TABLE public.sm_languages TO sonata;


--
-- Name: SEQUENCE sm_languages_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.sm_languages_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.sm_languages_id_seq TO sonata;


--
-- Name: SEQUENCE sm_licenseguid_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.sm_licenseguid_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.sm_licenseguid_id_seq TO sonata;


--
-- Name: TABLE sm_licenseguid; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.sm_licenseguid TO zeus;
GRANT SELECT ON TABLE public.sm_licenseguid TO sonata;


--
-- Name: TABLE sm_microphones; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.sm_microphones TO zeus;
GRANT SELECT ON TABLE public.sm_microphones TO sonata;


--
-- Name: SEQUENCE sm_microphones_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.sm_microphones_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.sm_microphones_id_seq TO sonata;


--
-- Name: SEQUENCE sm_partnerguid_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.sm_partnerguid_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.sm_partnerguid_id_seq TO sonata;


--
-- Name: TABLE sm_partnerguid; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.sm_partnerguid TO zeus;
GRANT SELECT ON TABLE public.sm_partnerguid TO sonata;


--
-- Name: SEQUENCE sm_serverurl_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.sm_serverurl_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.sm_serverurl_id_seq TO sonata;


--
-- Name: TABLE sm_serverurl; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.sm_serverurl TO zeus;
GRANT SELECT ON TABLE public.sm_serverurl TO sonata;


--
-- Name: TABLE sm_topics; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.sm_topics TO zeus;
GRANT SELECT ON TABLE public.sm_topics TO sonata;


--
-- Name: SEQUENCE sm_topics_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.sm_topics_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.sm_topics_id_seq TO sonata;


--
-- Name: SEQUENCE solicitude_type_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.solicitude_type_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.solicitude_type_id_seq TO sonata;


--
-- Name: TABLE solicitude_type; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.solicitude_type TO zeus;
GRANT SELECT ON TABLE public.solicitude_type TO sonata;


--
-- Name: SEQUENCE speciality_id_speciality_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.speciality_id_speciality_seq TO zeus;
GRANT SELECT ON SEQUENCE public.speciality_id_speciality_seq TO sonata;


--
-- Name: TABLE speciality; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.speciality TO zeus;
GRANT SELECT ON TABLE public.speciality TO sonata;


--
-- Name: TABLE study_detail; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.study_detail TO zeus;
GRANT SELECT ON TABLE public.study_detail TO sonata;


--
-- Name: SEQUENCE study_list_id_study_list_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.study_list_id_study_list_seq TO zeus;
GRANT SELECT ON SEQUENCE public.study_list_id_study_list_seq TO sonata;


--
-- Name: TABLE study_rate; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.study_rate TO zeus;
GRANT SELECT ON TABLE public.study_rate TO sonata;


--
-- Name: TABLE telephone_state; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.telephone_state TO zeus;
GRANT SELECT ON TABLE public.telephone_state TO sonata;


--
-- Name: SEQUENCE telephone_state_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.telephone_state_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.telephone_state_id_seq TO sonata;


--
-- Name: SEQUENCE ti_adendum_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.ti_adendum_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.ti_adendum_id_seq TO sonata;


--
-- Name: TABLE ti_adendum; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.ti_adendum TO zeus;
GRANT SELECT ON TABLE public.ti_adendum TO sonata;


--
-- Name: SEQUENCE ti_logint_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.ti_logint_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.ti_logint_id_seq TO sonata;


--
-- Name: TABLE ti_logint; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.ti_logint TO zeus;
GRANT SELECT ON TABLE public.ti_logint TO sonata;


--
-- Name: TABLE tipe_flow; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.tipe_flow TO zeus;
GRANT SELECT ON TABLE public.tipe_flow TO sonata;


--
-- Name: SEQUENCE transcription_template_id_template_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.transcription_template_id_template_seq TO zeus;
GRANT SELECT ON SEQUENCE public.transcription_template_id_template_seq TO sonata;


--
-- Name: TABLE transcription_template; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.transcription_template TO zeus;
GRANT SELECT ON TABLE public.transcription_template TO sonata;


--
-- Name: SEQUENCE user_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.user_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.user_id_seq TO sonata;


--
-- Name: TABLE user_schedule; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.user_schedule TO zeus;
GRANT SELECT ON TABLE public.user_schedule TO sonata;


--
-- Name: SEQUENCE user_schedule_id_schedule_user_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.user_schedule_id_schedule_user_seq TO zeus;
GRANT SELECT ON SEQUENCE public.user_schedule_id_schedule_user_seq TO sonata;


--
-- Name: TABLE user_sm; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.user_sm TO zeus;
GRANT SELECT ON TABLE public.user_sm TO sonata;


--
-- Name: SEQUENCE user_sm_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.user_sm_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.user_sm_id_seq TO sonata;


--
-- Name: TABLE user_sm_languages; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.user_sm_languages TO zeus;
GRANT SELECT ON TABLE public.user_sm_languages TO sonata;


--
-- Name: SEQUENCE user_sm_languages_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.user_sm_languages_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.user_sm_languages_id_seq TO sonata;


--
-- Name: TABLE user_sm_microphones; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.user_sm_microphones TO zeus;
GRANT SELECT ON TABLE public.user_sm_microphones TO sonata;


--
-- Name: SEQUENCE user_sm_microphones_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.user_sm_microphones_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.user_sm_microphones_id_seq TO sonata;


--
-- Name: TABLE user_sm_topics; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.user_sm_topics TO zeus;
GRANT SELECT ON TABLE public.user_sm_topics TO sonata;


--
-- Name: SEQUENCE user_sm_topics_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.user_sm_topics_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.user_sm_topics_id_seq TO sonata;


--
-- Name: SEQUENCE user_sonata_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.user_sonata_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.user_sonata_id_seq TO sonata;


--
-- Name: SEQUENCE work_lists_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON SEQUENCE public.work_lists_id_seq TO zeus;
GRANT SELECT ON SEQUENCE public.work_lists_id_seq TO sonata;


--
-- Name: TABLE work_lists; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT ON TABLE public.work_lists TO zeus;
GRANT SELECT ON TABLE public.work_lists TO sonata;


--
--

