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

INSERT INTO public.quaadtag_doc_link VALUES (14, 281);
INSERT INTO public.quaadtag_doc_link VALUES (14, 283);
INSERT INTO public.quaadtag_doc_link VALUES (14, 284);
INSERT INTO public.quaadtag_doc_link VALUES (14, 280);
INSERT INTO public.quaadtag_doc_link VALUES (14, 285);
INSERT INTO public.quaadtag_doc_link VALUES (14, 286);
INSERT INTO public.quaadtag_doc_link VALUES (14, 287);
INSERT INTO public.quaadtag_doc_link VALUES (45, 289);
INSERT INTO public.quaadtag_doc_link VALUES (45, 290);
INSERT INTO public.quaadtag_doc_link VALUES (47, 290);
INSERT INTO public.quaadtag_doc_link VALUES (14, 291);
INSERT INTO public.quaadtag_doc_link VALUES (45, 292);
INSERT INTO public.quaadtag_doc_link VALUES (46, 293);
INSERT INTO public.quaadtag_doc_link VALUES (3, 296);
INSERT INTO public.quaadtag_doc_link VALUES (3, 297);
INSERT INTO public.quaadtag_doc_link VALUES (142, 298);
INSERT INTO public.quaadtag_doc_link VALUES (60, 301);
INSERT INTO public.quaadtag_doc_link VALUES (27, 302);
INSERT INTO public.quaadtag_doc_link VALUES (4, 303);
INSERT INTO public.quaadtag_doc_link VALUES (2, 304);
INSERT INTO public.quaadtag_doc_link VALUES (10, 305);
INSERT INTO public.quaadtag_doc_link VALUES (57, 306);
INSERT INTO public.quaadtag_doc_link VALUES (42, 307);
INSERT INTO public.quaadtag_doc_link VALUES (1, 315);
INSERT INTO public.quaadtag_doc_link VALUES (2, 315);
INSERT INTO public.quaadtag_doc_link VALUES (4, 315);
INSERT INTO public.quaadtag_doc_link VALUES (8, 315);
INSERT INTO public.quaadtag_doc_link VALUES (3, 316);
INSERT INTO public.quaadtag_doc_link VALUES (14, 282);
INSERT INTO public.quaadtag_doc_link VALUES (1, 288);
INSERT INTO public.quaadtag_doc_link VALUES (1, 328);
INSERT INTO public.quaadtag_doc_link VALUES (1, 329);
INSERT INTO public.quaadtag_doc_link VALUES (40, 330);
INSERT INTO public.quaadtag_doc_link VALUES (18, 324);
INSERT INTO public.quaadtag_doc_link VALUES (16, 324);
INSERT INTO public.quaadtag_doc_link VALUES (19, 324);
INSERT INTO public.quaadtag_doc_link VALUES (27, 321);
INSERT INTO public.quaadtag_doc_link VALUES (142, 299);
INSERT INTO public.quaadtag_doc_link VALUES (59, 319);


--
-- TOC entry 5691 (class 0 OID 25383)
-- Dependencies: 287
-- Data for Name: report; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.report VALUES (18, -1, 'New incident', '2024-10-04 00:00:00+02', NULL, 0, '', '', 7, 4, false);
INSERT INTO public.report VALUES (10, -1, 'New incident', '0001-01-01 00:00:00+00:09:21 BC', NULL, 0, '', '', 7, -1, true);
INSERT INTO public.report VALUES (11, -1, 'New incident', '0001-01-01 00:00:00+00:09:21 BC', NULL, 0, '', '', 7, 4, true);
INSERT INTO public.report VALUES (12, -1, 'New incident', '0001-01-01 00:00:00+00:09:21 BC', NULL, 0, '', '', 7, 4, true);
INSERT INTO public.report VALUES (13, -1, 'New incident', '0001-01-01 00:00:00+00:09:21 BC', NULL, 0, '', '', 7, 4, true);
INSERT INTO public.report VALUES (14, -1, 'New incident', '0001-01-01 00:00:00+00:09:21 BC', NULL, 0, '', '', 7, 4, true);
INSERT INTO public.report VALUES (15, -1, 'New incident', '0001-01-01 00:00:00+00:09:21 BC', NULL, 0, '', '', 7, 4, true);
INSERT INTO public.report VALUES (16, -1, 'New incident', '2024-10-04 00:00:00+02', NULL, 0, '', '', 7, 4, true);
INSERT INTO public.report VALUES (17, -1, 'New incident', '2024-10-04 00:00:00+02', NULL, 0, '', '', 7, 4, true);
INSERT INTO public.report VALUES (21, -1, 'New incident', '2024-10-04 00:00:00+02', NULL, 0, '', '', 7, 4, false);
INSERT INTO public.report VALUES (24, 2, 'Incident 123', '2024-10-01 00:00:00+02', NULL, 0, '', '', 7, 4, true);
INSERT INTO public.report VALUES (23, 2, 'Incident 123', '2024-10-04 00:00:00+02', NULL, 0, '', '', 7, 4, true);
INSERT INTO public.report VALUES (5, 2, 'New incident 321', '2022-03-07 00:00:00+01', NULL, 0, '', '', 8, 4, false);
INSERT INTO public.report VALUES (19, NULL, 'New incident', '2024-10-04 00:00:00+02', NULL, 0, 'Description', 'Status comment', 7, 4, false);
INSERT INTO public.report VALUES (22, 2, 'New incident', '2024-10-04 00:00:00+02', '2024-10-05 00:00:00+02', 0, '', '', 7, 4, false);
INSERT INTO public.report VALUES (25, 3, 'Incident 123', '2024-10-01 00:00:00+02', '2024-10-04 00:00:00+02', 0, '', '', 8, 4, false);
INSERT INTO public.report VALUES (26, 2, 'aaaaaaaaaaaaaaaa', '2024-10-04 00:00:00+02', NULL, 0, 'Test new incident...						', '', 7, 4, false);
INSERT INTO public.report VALUES (27, 1, 'aa', '2025-02-11 00:00:00+01', NULL, 0, '												', '', 7, 4, true);
INSERT INTO public.report VALUES (20, NULL, 'New incident', '2024-10-03 00:00:00+02', '2025-03-06 00:00:00+01', 0, '', '', 8, 4, false);
INSERT INTO public.report VALUES (29, 2, 'Test Incident 001', '2025-03-06 00:00:00+01', '2025-03-06 00:00:00+01', 0, '', '', 8, 4, false);
INSERT INTO public.report VALUES (30, 2, 'Test 001', '2025-03-06 00:00:00+01', NULL, 0, 'Test...					', '', 7, 4, false);


--
-- TOC entry 5693 (class 0 OID 25393)
-- Dependencies: 289
-- Data for Name: sequpdate_state; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.sequpdate_state VALUES ('create_sequpdate_state', 1);
INSERT INTO public.sequpdate_state VALUES ('addbquadvirtualpoint', 2);
INSERT INTO public.sequpdate_state VALUES ('addmulticlient', 3);
INSERT INTO public.sequpdate_state VALUES ('fixdashboardalert', 4);
INSERT INTO public.sequpdate_state VALUES ('user_cfg', 5);
INSERT INTO public.sequpdate_state VALUES ('survey', 6);
INSERT INTO public.sequpdate_state VALUES ('survey removed column', 7);
INSERT INTO public.sequpdate_state VALUES ('staff_member photo column', 8);
INSERT INTO public.sequpdate_state VALUES ('device photo column', 9);
INSERT INTO public.sequpdate_state VALUES ('read status', 10);
INSERT INTO public.sequpdate_state VALUES ('staff member email', 11);
INSERT INTO public.sequpdate_state VALUES ('civility list', 12);
INSERT INTO public.sequpdate_state VALUES ('document file not null', 13);
INSERT INTO public.sequpdate_state VALUES ('document type list', 14);
INSERT INTO public.sequpdate_state VALUES ('document modification date', 15);
INSERT INTO public.sequpdate_state VALUES ('read_status_link action field', 15);
INSERT INTO public.sequpdate_state VALUES ('action_status_link last_reminder field', 16);
INSERT INTO public.sequpdate_state VALUES ('tasks tables and view', 17);


--
-- TOC entry 5694 (class 0 OID 25398)
-- Dependencies: 290
-- Data for Name: sexlist; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.sexlist VALUES (0, 'Male');
INSERT INTO public.sexlist VALUES (1, 'Female');
INSERT INTO public.sexlist VALUES (2, 'All');


--
-- TOC entry 5696 (class 0 OID 25404)
-- Dependencies: 292
-- Data for Name: staff_formation; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.staff_formation VALUES (5, 0, NULL, NULL, 'New formation', NULL, NULL, 3, false, 0);
INSERT INTO public.staff_formation VALUES (4, 12, '2020-12-31 00:00:00+01', '2020-10-13 00:00:00+02', 'formation radioprotection', 'Test.', 'formation radioprotection', 4, false, 12);
INSERT INTO public.staff_formation VALUES (3, 12, '2025-03-06 00:00:00+01', '2023-03-27 00:00:00+02', 'formation radioprotection', '', 'formation 2', 4, false, 12);


--
-- TOC entry 5698 (class 0 OID 25411)
-- Dependencies: 294
-- Data for Name: staff_job; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.staff_job VALUES (1, 1, 1, '2019-12-10 00:00:00+01', '2999-12-31 00:00:00+01', 1, false, false);
INSERT INTO public.staff_job VALUES (5, 1, 1, '1990-10-01 00:00:00+01', '2999-12-31 00:00:00+01', 2, false, false);
INSERT INTO public.staff_job VALUES (15, 2, 12, '2021-03-11 00:00:00+01', '2999-12-31 00:00:00+01', 3, false, false);
INSERT INTO public.staff_job VALUES (17, 4, 12, '2021-07-28 00:00:00+02', '2999-12-31 00:00:00+01', 3, false, false);
INSERT INTO public.staff_job VALUES (21, 2, 0, '2022-03-01 00:00:00+01', '2999-12-31 00:00:00+01', 1, false, false);
INSERT INTO public.staff_job VALUES (19, 2, 15, '2021-12-03 00:00:00+01', '2999-12-31 00:00:00+01', 1, false, false);
INSERT INTO public.staff_job VALUES (18, 2, 14, '2021-12-03 00:00:00+01', '2999-12-31 00:00:00+01', 3, false, false);
INSERT INTO public.staff_job VALUES (20, 2, 16, '2021-12-03 00:00:00+01', '2999-12-31 00:00:00+01', 2, false, false);
INSERT INTO public.staff_job VALUES (29, 2, 14, '2024-08-23 00:00:00+02', '2999-12-31 00:00:00+01', 3, false, true);
INSERT INTO public.staff_job VALUES (30, 7, 14, '2024-08-23 00:00:00+02', '2999-12-31 00:00:00+01', 5, false, true);
INSERT INTO public.staff_job VALUES (31, -1, 14, '2024-08-23 18:03:08.090529+02', '2999-12-31 00:00:00+01', -1, false, true);
INSERT INTO public.staff_job VALUES (32, 8, 14, '2024-08-28 00:00:00+02', '2999-12-31 00:00:00+01', 2, false, true);
INSERT INTO public.staff_job VALUES (33, 3, 16, '2024-11-26 00:00:00+01', '2999-12-31 00:00:00+01', 2, false, false);
INSERT INTO public.staff_job VALUES (16, 3, 13, '2021-07-28 00:00:00+02', '2999-12-31 00:00:00+01', 2, false, false);
INSERT INTO public.staff_job VALUES (36, -1, 0, '2025-01-31 14:30:17.749693+01', '2999-12-31 00:00:00+01', -1, false, true);
INSERT INTO public.staff_job VALUES (35, 4, 13, '2025-01-15 00:00:00+01', '2022-12-31 00:00:00+01', 2, false, false);
INSERT INTO public.staff_job VALUES (34, 3, 13, '2025-01-10 00:00:00+01', '2999-12-31 00:00:00+01', 2, false, true);
INSERT INTO public.staff_job VALUES (37, 6, 15, '2025-04-24 00:00:00+02', '2999-12-31 00:00:00+01', 1, false, false);
INSERT INTO public.staff_job VALUES (22, 7, 0, '2022-03-01 00:00:00+01', '2025-05-06 00:00:00+02', 1, false, false);


--
-- TOC entry 5700 (class 0 OID 25418)
-- Dependencies: 296
-- Data for Name: staff_member; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.staff_member VALUES (1, 'XIMEO', 'XIMEO', true, 'ximeo', 'eGltZW8yMDIx', 0, false, '', '', '', NULL, NULL, NULL);
INSERT INTO public.staff_member VALUES (14, 'Bernier', 'Manon', false, 'mbernier', 'bWJlcm5pZXI=', 1, true, 'null', '', '', '\x[encoded data, 80594 characters]', 'm.bernier@eoqual.be', 1);
INSERT INTO public.staff_member VALUES (13, 'Robillard', 'Carole', false, 'crobillard', 'Y3JvYmlsbGFyZA==', 0, true, 'null', '', '', '\x[encoded data, 16234 characters]', '', 3);
INSERT INTO public.staff_member VALUES (15, 'LeBatelier', 'Octave', false, 'olebatelier', 'cHBhcmlz', 3, true, 'null', '', '', '\x[encoded data, 13770 characters]', '', 3);
INSERT INTO public.staff_member VALUES (12, 'Couture', 'Mallory', false, 'mcouture', 'bWNvdXR1cmU=', 1, true, 'null', '', '', '\x[encoded data, 14710 characters]', '', 4);
INSERT INTO public.staff_member VALUES (0, 'admin', 'admin', false, 'admin', 'YWRtaW40YWxs', 0, true, 'null', '', '', '\x[encoded data, 15934 characters]', '', 0);
INSERT INTO public.staff_member VALUES (16, 'Masson', 'Estelle', false, 'emasson', 'ZW1hc3Nvbg==', 1, true, 'null', '', '', '\x[encoded data, 14066 characters]', 'e.masson@eoqual.be', 3);


--
-- TOC entry 5702 (class 0 OID 25426)
-- Dependencies: 298
-- Data for Name: staff_role; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.staff_role VALUES (-1, 'Undef', true, 1);
INSERT INTO public.staff_role VALUES (2, 'Radiologue', false, 1);
INSERT INTO public.staff_role VALUES (3, 'Technologue', false, 1);
INSERT INTO public.staff_role VALUES (4, 'Secrétaire', false, 1);
INSERT INTO public.staff_role VALUES (1, 'Responsable qualité', false, 1);
INSERT INTO public.staff_role VALUES (5, 'Radiologue remplaçant', false, 0);
INSERT INTO public.staff_role VALUES (7, 'Test', true, 1);
INSERT INTO public.staff_role VALUES (8, 'New job role', true, -1);
INSERT INTO public.staff_role VALUES (9, 'New job role', true, -1);
INSERT INTO public.staff_role VALUES (6, 'Test 2', true, 0);
INSERT INTO public.staff_role VALUES (10, 'Responsable RH', false, 0);


--
-- TOC entry 5704 (class 0 OID 25434)
-- Dependencies: 300
-- Data for Name: statuslist; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.statuslist VALUES (-1, '', '|device_inspection_result|device|');
INSERT INTO public.statuslist VALUES (1, 'Actif', '|device|');
INSERT INTO public.statuslist VALUES (5, 'OK', '|device_inspection_result|');
INSERT INTO public.statuslist VALUES (6, 'KO', '|device_inspection_result|');
INSERT INTO public.statuslist VALUES (7, 'Open', '|report|');
INSERT INTO public.statuslist VALUES (4, 'Completed', '|device_inspection|staff_formation|action|audit|device_maintenance|');
INSERT INTO public.statuslist VALUES (3, 'Planned', '|device_inspection|staff_formation|action|audit|device_maintenance|survey|');
INSERT INTO public.statuslist VALUES (8, 'Closed', '|report|survey|');
INSERT INTO public.statuslist VALUES (9, 'In progress', '|survey|');
INSERT INTO public.statuslist VALUES (10, 'Draft', '|document|');
INSERT INTO public.statuslist VALUES (11, 'Pending approval', '|document|');
INSERT INTO public.statuslist VALUES (12, 'Approved', '|document|');
INSERT INTO public.statuslist VALUES (2, 'Obsolete', '|device|document|');
INSERT INTO public.statuslist VALUES (13, 'Deleted', '|document|');
INSERT INTO public.statuslist VALUES (14, 'Published', '|document|');


--
-- TOC entry 5706 (class 0 OID 25440)
-- Dependencies: 302
-- Data for Name: survey; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.survey VALUES (1, 'Enquête de satisfaction', '<p><strong>Madame,&nbsp;Monsieur,&nbsp;</strong></p><p>Vos&nbsp;appréciations&nbsp;sur&nbsp;l’ensemble&nbsp;de&nbsp;votre&nbsp;séjour&nbsp;sont&nbsp;essentielles&nbsp;pour&nbsp;améliorer&nbsp;la&nbsp;qualité&nbsp;du&nbsp;service&nbsp;que&nbsp;nous&nbsp;offrons&nbsp;aux&nbsp;patients.&nbsp;Nous&nbsp;vous&nbsp;invitons&nbsp;à&nbsp;remplir&nbsp;ce&nbsp;questionnaire&nbsp;en&nbsp;cochant&nbsp;votre&nbsp;choix&nbsp;pour&nbsp;chaque&nbsp;question.</p><p><strong>Si&nbsp;vous&nbsp;n&#39;êtes&nbsp;pas&nbsp;concerné(e)&nbsp;par&nbsp;l&#39;une&nbsp;des&nbsp;questions,&nbsp;merci&nbsp;de&nbsp;ne&nbsp;pas&nbsp;y&nbsp;répondre.</strong>&nbsp;</p><p>Vous&nbsp;retrouvez&nbsp;également&nbsp;à&nbsp;la&nbsp;fin&nbsp;de&nbsp;ce&nbsp;questionnaire&nbsp;un&nbsp;espace&nbsp;commentaires,&nbsp;qui&nbsp;vous&nbsp;permettra&nbsp;d&#39;apporter&nbsp;des&nbsp;précisions&nbsp;sur&nbsp;votre&nbsp;séjour.</p>', 1, 3, '2025-02-14 00:00:00+01', '2025-02-28 00:00:00+01', '', '<p><strong>Les&nbsp;conclusions&nbsp;de&nbsp;cette&nbsp;enquête&nbsp;sont&nbsp;:</strong></p><ul><li>un&nbsp;degré&nbsp;de&nbsp;satisfaction&nbsp;élevé&nbsp;sur&nbsp;les&nbsp;conditions&nbsp;d&#39;accueil.</li><li>un&nbsp;niveau&nbsp;de&nbsp;satisfaction&nbsp;insuffisant&nbsp;sur&nbsp;la&nbsp;communication&nbsp;avec&nbsp;les&nbsp;médecins.</li><li>un&nbsp;accès&nbsp;aux&nbsp;informations&nbsp;satisfaisant&nbsp;pour&nbsp;55%&nbsp;des&nbsp;patients.&nbsp;</li></ul><p></p><p>Des&nbsp;actions&nbsp;vont&nbsp;être&nbsp;planifiées&nbsp;pour&nbsp;améliorer&nbsp;la&nbsp;situation.</p>', false);
INSERT INTO public.survey VALUES (4, 'New survey', NULL, 1, 3, '2025-03-05 15:00:54+01', '2025-03-05 15:00:54+01', NULL, NULL, true);
INSERT INTO public.survey VALUES (3, 'New survey', '<p></p>', 1, 3, '2025-03-05 00:00:00+01', '2025-03-05 00:00:00+01', '', '<p></p>', true);
INSERT INTO public.survey VALUES (5, 'New survey', '<p></p>', 1, 3, '2025-03-06 00:00:00+01', '2025-03-07 00:00:00+01', '', '<p></p>', false);
INSERT INTO public.survey VALUES (2, 'Enquête qualité des soins', '', 1, 3, '2025-03-01 00:00:00+01', '2025-03-15 00:00:00+01', '<p>Test</p>', '', false);


--
-- TOC entry 5707 (class 0 OID 25446)
-- Dependencies: 303
-- Data for Name: survey_field; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.survey_field VALUES (33, '- du calme de la chambre ?', 3, 1, 32);
INSERT INTO public.survey_field VALUES (34, '- de la température de la chambre?', 3, 1, 33);
INSERT INTO public.survey_field VALUES (35, '- de l''adaptation des locaux à votre état de santé ?', 3, 1, 34);
INSERT INTO public.survey_field VALUES (39, 'Votre nom (facultatif) : ', 7, 2, 0);
INSERT INTO public.survey_field VALUES (40, 'Vos commentaires :', 8, 2, 1);
INSERT INTO public.survey_field VALUES (41, 'VOTRE AVIS COMPTE', 1, 1, 35);
INSERT INTO public.survey_field VALUES (42, 'N''hésitez pas à nous faire part de vos remarques :', 8, 1, 36);
INSERT INTO public.survey_field VALUES (43, 'Votre nom (facultatif) :', 7, 1, 37);
INSERT INTO public.survey_field VALUES (2, 'VOTRE ACCUEIL', 1, 1, 0);
INSERT INTO public.survey_field VALUES (1, 'Que pensez-vous :', 5, 1, 1);
INSERT INTO public.survey_field VALUES (3, '- de l''accessibilité de l''établissement (transport/ parking) ?', 3, 1, 2);
INSERT INTO public.survey_field VALUES (4, '- du fléchage et des indications pour parvenir au(x) service(s)?', 3, 1, 3);
INSERT INTO public.survey_field VALUES (5, 'Que pensez-vous de l''accueil :', 5, 1, 4);
INSERT INTO public.survey_field VALUES (6, '- au bureau des consultations et des hospitalisations ?', 3, 1, 5);
INSERT INTO public.survey_field VALUES (7, '- dans le(s) service(s) de soins ?', 3, 1, 6);
INSERT INTO public.survey_field VALUES (8, 'Que pensez-vous des informations données en amont de votre séjour sur :', 5, 1, 7);
INSERT INTO public.survey_field VALUES (9, '- les consignes à respecter (ex : être à jeun, accompagné, 
horaires...) ?', 3, 1, 8);
INSERT INTO public.survey_field VALUES (10, '- les documents à apporter (ex: convocations, examens...) ?', 3, 1, 9);
INSERT INTO public.survey_field VALUES (11, 'VOTRE PRISE EN CHARGE', 1, 1, 10);
INSERT INTO public.survey_field VALUES (12, 'Durant votre séjour, avez-vous obtenu spontanément des informations claires et 
suffisantes, concernant :', 6, 1, 11);
INSERT INTO public.survey_field VALUES (13, '- votre état de santé ?', 2, 1, 12);
INSERT INTO public.survey_field VALUES (14, '- le déroulement des soins ?', 2, 1, 13);
INSERT INTO public.survey_field VALUES (15, 'Le personnel a-t-il répondu à vos questions ?', 4, 1, 14);
INSERT INTO public.survey_field VALUES (16, 'Si oui, est-ce que les réponses apportées ont été claires et 
suffisantes ?', 2, 1, 15);
INSERT INTO public.survey_field VALUES (17, 'Estimez-vous que votre intimité et dignité ont été respectées 
durant votre séjour?
', 4, 1, 16);
INSERT INTO public.survey_field VALUES (18, 'Pensez-vous que la confidentialité de vos informations a été 
respectée ?', 4, 1, 17);
INSERT INTO public.survey_field VALUES (19, 'Prise en charge de votre douleur ', 5, 1, 18);
INSERT INTO public.survey_field VALUES (20, '- comment la jugez-vous ?', 3, 1, 19);
INSERT INTO public.survey_field VALUES (21, 'Globalement, comment évaluez-vous la qualité de votre prise en charge par :', 5, 1, 20);
INSERT INTO public.survey_field VALUES (22, '- les médecins/ chirurgiens ?', 3, 1, 21);
INSERT INTO public.survey_field VALUES (23, '- les paramédicaux (infirmier, aide-soignant) ?', 3, 1, 22);
INSERT INTO public.survey_field VALUES (24, '- les kinésithérapeutes ?', 3, 1, 23);
INSERT INTO public.survey_field VALUES (25, '- les diététiciens ?', 3, 1, 24);
INSERT INTO public.survey_field VALUES (26, '- les assistants sociaux ?', 3, 1, 25);
INSERT INTO public.survey_field VALUES (27, '- les psychologues ?', 3, 1, 26);
INSERT INTO public.survey_field VALUES (28, 'Avez-vous trouvé le temps d''attente convenable au moment du 
transfert?', 4, 1, 27);
INSERT INTO public.survey_field VALUES (29, 'CHAMBRE ET REPAS', 1, 1, 28);
INSERT INTO public.survey_field VALUES (30, 'Etes-vous satisfait :', 5, 1, 29);
INSERT INTO public.survey_field VALUES (31, '- de la propreté de la chambre ?', 3, 1, 30);
INSERT INTO public.survey_field VALUES (32, '- des prestations complémentaires proposées par la conciergerie 
(télévision, téléphone, internet) ?', 3, 1, 31);


--
-- TOC entry 5709 (class 0 OID 25452)
-- Dependencies: 305
-- Data for Name: survey_field_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.survey_field_type VALUES (2, 'Yes-No');
INSERT INTO public.survey_field_type VALUES (3, '5 smileys');
INSERT INTO public.survey_field_type VALUES (4, 'Header Yes-No');
INSERT INTO public.survey_field_type VALUES (5, 'Header 5 smileys');
INSERT INTO public.survey_field_type VALUES (1, 'Main header');
INSERT INTO public.survey_field_type VALUES (6, 'Header');
INSERT INTO public.survey_field_type VALUES (7, 'String');
INSERT INTO public.survey_field_type VALUES (8, 'Text');


--
-- TOC entry 5712 (class 0 OID 25459)
-- Dependencies: 308
-- Data for Name: survey_resp; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.survey_resp VALUES (8, 1, '2025-02-17 15:34:44+01');
INSERT INTO public.survey_resp VALUES (9, 1, '2025-02-17 15:35:44+01');
INSERT INTO public.survey_resp VALUES (10, 1, '2025-02-17 15:36:34+01');
INSERT INTO public.survey_resp VALUES (11, 1, '2025-02-20 17:27:17+01');
INSERT INTO public.survey_resp VALUES (12, 1, '2025-02-20 17:30:38+01');
INSERT INTO public.survey_resp VALUES (13, 1, '2025-02-20 17:31:35+01');


--
-- TOC entry 5713 (class 0 OID 25462)
-- Dependencies: 309
-- Data for Name: survey_resp_field; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.survey_resp_field VALUES (17, 3, 2, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (18, 4, 2, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (19, 6, 3, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (20, 7, 4, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (21, 9, 1, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (22, 10, 4, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (23, 13, 1, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (24, 14, 1, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (25, 15, 1, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (26, 16, 0, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (27, 17, 0, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (28, 18, 1, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (29, 20, 3, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (30, 22, 4, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (31, 23, 2, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (32, 24, 2, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (33, 25, 1, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (34, 26, 4, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (35, 27, 3, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (36, 28, 0, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (37, 31, 3, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (38, 32, 3, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (39, 33, 4, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (40, 34, 3, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (41, 35, 3, 8, NULL);
INSERT INTO public.survey_resp_field VALUES (42, 3, 1, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (43, 4, 2, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (44, 6, 1, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (45, 7, 2, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (46, 9, 1, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (47, 10, 2, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (48, 13, 0, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (49, 14, 1, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (50, 15, 0, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (51, 16, 0, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (52, 17, 1, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (53, 18, 1, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (54, 20, 3, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (55, 22, 4, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (56, 23, 3, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (57, 24, 2, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (58, 25, 4, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (59, 26, 2, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (60, 27, 3, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (61, 28, 1, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (62, 31, 3, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (63, 32, 3, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (64, 33, 3, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (65, 34, 3, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (66, 35, 3, 9, NULL);
INSERT INTO public.survey_resp_field VALUES (67, 3, 1, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (68, 4, 2, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (69, 6, 1, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (70, 7, 2, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (71, 9, 4, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (72, 10, 2, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (73, 13, 0, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (74, 14, 1, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (75, 15, 0, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (76, 16, 0, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (77, 17, 1, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (78, 18, 1, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (79, 20, 3, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (80, 22, 1, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (81, 23, 1, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (82, 24, 2, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (83, 25, 4, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (84, 26, 3, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (85, 27, 2, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (86, 28, 1, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (87, 31, 3, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (88, 32, 2, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (89, 33, 3, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (90, 34, 2, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (91, 35, 2, 10, NULL);
INSERT INTO public.survey_resp_field VALUES (92, 3, 2, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (93, 4, 2, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (94, 6, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (95, 7, 2, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (96, 9, 3, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (97, 10, 2, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (98, 13, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (99, 14, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (100, 15, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (101, 16, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (102, 17, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (103, 18, 0, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (104, 20, 3, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (105, 22, 3, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (106, 23, 2, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (107, 24, 3, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (108, 25, 3, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (109, 26, 4, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (110, 27, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (111, 28, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (112, 31, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (113, 32, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (114, 33, 1, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (115, 34, 2, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (116, 35, 2, 11, NULL);
INSERT INTO public.survey_resp_field VALUES (117, 3, 2, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (118, 4, 2, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (119, 6, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (120, 7, 2, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (121, 9, 3, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (122, 10, 2, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (123, 13, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (124, 14, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (125, 15, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (126, 16, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (127, 17, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (128, 18, 0, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (129, 20, 3, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (130, 22, 3, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (131, 23, 2, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (132, 24, 3, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (133, 25, 3, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (134, 26, 4, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (135, 27, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (136, 28, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (137, 31, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (138, 32, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (139, 33, 1, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (140, 34, 2, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (141, 35, 2, 12, NULL);
INSERT INTO public.survey_resp_field VALUES (143, 3, 2, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (144, 4, 2, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (145, 6, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (146, 7, 2, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (147, 9, 3, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (148, 10, 2, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (149, 13, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (150, 14, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (151, 15, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (152, 16, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (153, 17, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (154, 18, 0, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (155, 20, 3, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (156, 22, 3, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (157, 23, 2, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (158, 24, 3, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (159, 25, 3, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (160, 26, 4, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (161, 27, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (162, 28, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (163, 31, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (164, 32, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (165, 33, 1, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (166, 34, 2, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (167, 35, 2, 13, NULL);
INSERT INTO public.survey_resp_field VALUES (168, 42, -1, 13, 'RAS.');


--
-- TOC entry 5716 (class 0 OID 25469)
-- Dependencies: 312
-- Data for Name: survey_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.survey_type VALUES (1, 'Patient');


--
-- TOC entry 5718 (class 0 OID 25475)
-- Dependencies: 314
-- Data for Name: tag; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.tag VALUES (2, 'OR', 'XIMEO Qualité', false);
INSERT INTO public.tag VALUES (3, 'OR', 'XIMEO Radiologie', false);
INSERT INTO public.tag VALUES (4, 'AND', 'Thorax', false);
INSERT INTO public.tag VALUES (7, 'AND', 'Scanner', false);
INSERT INTO public.tag VALUES (8, 'AND', 'Radiographie', false);
INSERT INTO public.tag VALUES (13, 'OR', 'Centre de radiologie XIMEO Médecine nucléaire', false);
INSERT INTO public.tag VALUES (14, 'OR', 'XIMEO 1 New department', true);
INSERT INTO public.tag VALUES (15, 'OR', 'XIMEO 2 Qualité', false);
INSERT INTO public.tag VALUES (12, 'OR', 'site eoQUAL 2 Radiologie', false);
INSERT INTO public.tag VALUES (16, 'OR', 'site eoQUAL 2 Médecine nucléaire', false);
INSERT INTO public.tag VALUES (24, 'AND', 'New tag', true);
INSERT INTO public.tag VALUES (23, 'AND', 'New tag', true);
INSERT INTO public.tag VALUES (19, 'AND', 'ccccccccccccccccccccc', true);
INSERT INTO public.tag VALUES (20, 'AND', 'New tag', true);
INSERT INTO public.tag VALUES (17, 'AND', 'New tag', true);
INSERT INTO public.tag VALUES (9, 'AND', 'New tag', true);
INSERT INTO public.tag VALUES (18, 'AND', 'bbbbb', true);
INSERT INTO public.tag VALUES (21, 'AND', 'aaaa', true);
INSERT INTO public.tag VALUES (22, 'AND', 'New tag', true);
INSERT INTO public.tag VALUES (6, 'AND', 'ORL', false);
INSERT INTO public.tag VALUES (25, 'AND', 'New tag', true);
INSERT INTO public.tag VALUES (26, 'AND', 'New tag', true);
INSERT INTO public.tag VALUES (10, 'AND', 'Mammographie', false);
INSERT INTO public.tag VALUES (27, 'AND', 'New taghhhhhhhhhhhhhhh', true);
INSERT INTO public.tag VALUES (5, 'AND', 'Abdomen', false);
INSERT INTO public.tag VALUES (28, 'AND', 'aaaa', true);
INSERT INTO public.tag VALUES (29, 'OR', 'Aaaaaaaaaaaaaaaaaaaa', true);
INSERT INTO public.tag VALUES (30, 'OR', 'New Institutionnnnnnnnnnnnn', true);
INSERT INTO public.tag VALUES (31, 'OR', 'site eoQUAL 1 New department', true);
INSERT INTO public.tag VALUES (32, 'OR', 'site eoQUAL 1 New departmenttttt', true);
INSERT INTO public.tag VALUES (34, 'OR', 'New Institution New department', true);
INSERT INTO public.tag VALUES (33, 'OR', 'New Institution', true);
INSERT INTO public.tag VALUES (35, 'AND', 'New tag', true);
INSERT INTO public.tag VALUES (36, 'AND', 'New tagggggggggggggggggg', true);
INSERT INTO public.tag VALUES (1, 'OR', 'Site eoQUAL 1', false);
INSERT INTO public.tag VALUES (11, 'OR', 'Site eoQUAL 2', false);


--
-- TOC entry 5720 (class 0 OID 25482)
-- Dependencies: 316
-- Data for Name: tag_link; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.tag_link VALUES (1, 'institution', 1, 1);
INSERT INTO public.tag_link VALUES (2, 'department', 1, 2);
INSERT INTO public.tag_link VALUES (3, 'department', 2, 3);
INSERT INTO public.tag_link VALUES (8, 'examlist', 2, 4);
INSERT INTO public.tag_link VALUES (9, 'examlist', 2, 8);
INSERT INTO public.tag_link VALUES (15, 'examlist', 3, 3);
INSERT INTO public.tag_link VALUES (16, 'examlist', 3, 6);
INSERT INTO public.tag_link VALUES (17, 'examlist', 3, 8);
INSERT INTO public.tag_link VALUES (18, 'examlist', 4, 3);
INSERT INTO public.tag_link VALUES (19, 'examlist', 4, 6);
INSERT INTO public.tag_link VALUES (20, 'examlist', 4, 8);
INSERT INTO public.tag_link VALUES (21, 'examlist', 5, 3);
INSERT INTO public.tag_link VALUES (22, 'examlist', 5, 6);
INSERT INTO public.tag_link VALUES (23, 'examlist', 5, 8);
INSERT INTO public.tag_link VALUES (24, 'examlist', 1, 3);
INSERT INTO public.tag_link VALUES (25, 'examlist', 1, 4);
INSERT INTO public.tag_link VALUES (26, 'examlist', 1, 7);
INSERT INTO public.tag_link VALUES (27, 'examlist', 6, 3);
INSERT INTO public.tag_link VALUES (28, 'examlist', 6, 5);
INSERT INTO public.tag_link VALUES (29, 'examlist', 6, 7);
INSERT INTO public.tag_link VALUES (30, 'examlist', 7, 3);
INSERT INTO public.tag_link VALUES (31, 'examlist', 7, 5);
INSERT INTO public.tag_link VALUES (32, 'examlist', 7, 7);
INSERT INTO public.tag_link VALUES (37, 'examlist', 8, 3);
INSERT INTO public.tag_link VALUES (38, 'examlist', 8, 5);
INSERT INTO public.tag_link VALUES (39, 'examlist', 8, 8);
INSERT INTO public.tag_link VALUES (40, 'examlist', 9, 3);
INSERT INTO public.tag_link VALUES (41, 'examlist', 9, 5);
INSERT INTO public.tag_link VALUES (42, 'examlist', 9, 8);
INSERT INTO public.tag_link VALUES (43, 'examlist', 10, 3);
INSERT INTO public.tag_link VALUES (44, 'examlist', 10, 5);
INSERT INTO public.tag_link VALUES (45, 'examlist', 10, 8);
INSERT INTO public.tag_link VALUES (46, 'examlist', 11, 3);
INSERT INTO public.tag_link VALUES (47, 'examlist', 11, 5);
INSERT INTO public.tag_link VALUES (48, 'examlist', 11, 8);
INSERT INTO public.tag_link VALUES (49, 'examlist', 12, 3);
INSERT INTO public.tag_link VALUES (50, 'examlist', 12, 4);
INSERT INTO public.tag_link VALUES (51, 'examlist', 12, 7);
INSERT INTO public.tag_link VALUES (52, 'examlist', 13, 5);
INSERT INTO public.tag_link VALUES (53, 'examlist', 13, 7);
INSERT INTO public.tag_link VALUES (54, 'examlist', 14, 3);
INSERT INTO public.tag_link VALUES (55, 'examlist', 14, 5);
INSERT INTO public.tag_link VALUES (56, 'examlist', 14, 7);
INSERT INTO public.tag_link VALUES (57, 'examlist', 15, 3);
INSERT INTO public.tag_link VALUES (58, 'examlist', 15, 5);
INSERT INTO public.tag_link VALUES (59, 'examlist', 15, 7);
INSERT INTO public.tag_link VALUES (60, 'examlist', 16, 5);
INSERT INTO public.tag_link VALUES (61, 'examlist', 16, 7);
INSERT INTO public.tag_link VALUES (64, 'examlist', 17, 3);
INSERT INTO public.tag_link VALUES (65, 'examlist', 17, 7);
INSERT INTO public.tag_link VALUES (66, 'examlist', 18, 3);
INSERT INTO public.tag_link VALUES (67, 'examlist', 18, 6);
INSERT INTO public.tag_link VALUES (69, 'examlist', 19, 3);
INSERT INTO public.tag_link VALUES (70, 'examlist', 19, 10);
INSERT INTO public.tag_link VALUES (71, 'examlist', 24, 3);
INSERT INTO public.tag_link VALUES (72, 'examlist', 26, 3);
INSERT INTO public.tag_link VALUES (73, 'examlist', 27, 3);
INSERT INTO public.tag_link VALUES (74, 'examlist', 28, 3);
INSERT INTO public.tag_link VALUES (75, 'examlist', 29, 3);
INSERT INTO public.tag_link VALUES (76, 'examlist', 30, 3);
INSERT INTO public.tag_link VALUES (77, 'examlist', 31, 3);
INSERT INTO public.tag_link VALUES (78, 'examlist', 32, 3);
INSERT INTO public.tag_link VALUES (79, 'examlist', 33, 3);
INSERT INTO public.tag_link VALUES (80, 'examlist', 34, 3);
INSERT INTO public.tag_link VALUES (81, 'examlist', 35, 3);
INSERT INTO public.tag_link VALUES (82, 'examlist', 36, 3);
INSERT INTO public.tag_link VALUES (83, 'examlist', 37, 3);
INSERT INTO public.tag_link VALUES (84, 'examlist', 38, 3);
INSERT INTO public.tag_link VALUES (85, 'examlist', 39, 3);
INSERT INTO public.tag_link VALUES (86, 'examlist', 40, 3);
INSERT INTO public.tag_link VALUES (87, 'examlist', 41, 3);
INSERT INTO public.tag_link VALUES (88, 'examlist', 42, 3);
INSERT INTO public.tag_link VALUES (89, 'examlist', 43, 3);
INSERT INTO public.tag_link VALUES (90, 'examlist', 44, 3);
INSERT INTO public.tag_link VALUES (91, 'examlist', 45, 3);
INSERT INTO public.tag_link VALUES (92, 'examlist', 46, 3);
INSERT INTO public.tag_link VALUES (93, 'examlist', 47, 3);
INSERT INTO public.tag_link VALUES (94, 'examlist', 48, 3);
INSERT INTO public.tag_link VALUES (95, 'examlist', 49, 3);
INSERT INTO public.tag_link VALUES (96, 'examlist', 50, 3);
INSERT INTO public.tag_link VALUES (97, 'examlist', 52, 3);
INSERT INTO public.tag_link VALUES (98, 'examlist', 53, 3);
INSERT INTO public.tag_link VALUES (99, 'examlist', 54, 3);
INSERT INTO public.tag_link VALUES (100, 'examlist', 55, 3);
INSERT INTO public.tag_link VALUES (101, 'examlist', 56, 3);
INSERT INTO public.tag_link VALUES (102, 'examlist', 57, 3);
INSERT INTO public.tag_link VALUES (103, 'examlist', 58, 3);
INSERT INTO public.tag_link VALUES (104, 'examlist', 59, 3);
INSERT INTO public.tag_link VALUES (105, 'examlist', 60, 3);
INSERT INTO public.tag_link VALUES (106, 'examlist', 61, 3);
INSERT INTO public.tag_link VALUES (107, 'examlist', 62, 3);
INSERT INTO public.tag_link VALUES (108, 'examlist', 63, 3);
INSERT INTO public.tag_link VALUES (109, 'examlist', 64, 3);
INSERT INTO public.tag_link VALUES (110, 'examlist', 65, 3);
INSERT INTO public.tag_link VALUES (111, 'examlist', 66, 3);
INSERT INTO public.tag_link VALUES (112, 'examlist', 67, 3);
INSERT INTO public.tag_link VALUES (113, 'examlist', 69, 3);
INSERT INTO public.tag_link VALUES (114, 'examlist', 70, 3);
INSERT INTO public.tag_link VALUES (115, 'examlist', 71, 3);
INSERT INTO public.tag_link VALUES (116, 'examlist', 71, 8);
INSERT INTO public.tag_link VALUES (117, 'examlist', 72, 3);
INSERT INTO public.tag_link VALUES (118, 'examlist', 72, 6);
INSERT INTO public.tag_link VALUES (119, 'examlist', 72, 8);
INSERT INTO public.tag_link VALUES (120, 'examlist', 73, 3);
INSERT INTO public.tag_link VALUES (121, 'examlist', 73, 6);
INSERT INTO public.tag_link VALUES (122, 'examlist', 74, 3);
INSERT INTO public.tag_link VALUES (123, 'examlist', 74, 4);
INSERT INTO public.tag_link VALUES (124, 'examlist', 75, 3);
INSERT INTO public.tag_link VALUES (125, 'examlist', 75, 8);
INSERT INTO public.tag_link VALUES (126, 'examlist', 76, 3);
INSERT INTO public.tag_link VALUES (127, 'examlist', 76, 8);
INSERT INTO public.tag_link VALUES (128, 'examlist', 77, 3);
INSERT INTO public.tag_link VALUES (129, 'examlist', 77, 8);
INSERT INTO public.tag_link VALUES (130, 'examlist', 78, 3);
INSERT INTO public.tag_link VALUES (131, 'examlist', 78, 8);
INSERT INTO public.tag_link VALUES (132, 'examlist', 79, 3);
INSERT INTO public.tag_link VALUES (133, 'examlist', 79, 8);
INSERT INTO public.tag_link VALUES (134, 'examlist', 80, 3);
INSERT INTO public.tag_link VALUES (135, 'examlist', 80, 8);
INSERT INTO public.tag_link VALUES (136, 'examlist', 81, 3);
INSERT INTO public.tag_link VALUES (137, 'examlist', 82, 3);
INSERT INTO public.tag_link VALUES (138, 'examlist', 84, 3);
INSERT INTO public.tag_link VALUES (139, 'examlist', 84, 8);
INSERT INTO public.tag_link VALUES (140, 'examlist', 86, 3);
INSERT INTO public.tag_link VALUES (141, 'examlist', 86, 8);
INSERT INTO public.tag_link VALUES (142, 'examlist', 87, 3);
INSERT INTO public.tag_link VALUES (143, 'examlist', 87, 8);
INSERT INTO public.tag_link VALUES (144, 'examlist', 88, 3);
INSERT INTO public.tag_link VALUES (145, 'examlist', 88, 8);
INSERT INTO public.tag_link VALUES (146, 'examlist', 89, 3);
INSERT INTO public.tag_link VALUES (147, 'examlist', 89, 8);
INSERT INTO public.tag_link VALUES (148, 'examlist', 90, 3);
INSERT INTO public.tag_link VALUES (149, 'examlist', 90, 8);
INSERT INTO public.tag_link VALUES (150, 'examlist', 91, 3);
INSERT INTO public.tag_link VALUES (151, 'examlist', 91, 8);
INSERT INTO public.tag_link VALUES (152, 'examlist', 92, 3);
INSERT INTO public.tag_link VALUES (153, 'examlist', 92, 8);
INSERT INTO public.tag_link VALUES (154, 'examlist', 93, 3);
INSERT INTO public.tag_link VALUES (155, 'examlist', 93, 8);
INSERT INTO public.tag_link VALUES (156, 'examlist', 94, 3);
INSERT INTO public.tag_link VALUES (157, 'examlist', 94, 8);
INSERT INTO public.tag_link VALUES (158, 'examlist', 95, 3);
INSERT INTO public.tag_link VALUES (159, 'examlist', 95, 8);
INSERT INTO public.tag_link VALUES (160, 'examlist', 96, 3);
INSERT INTO public.tag_link VALUES (161, 'examlist', 96, 8);
INSERT INTO public.tag_link VALUES (162, 'examlist', 97, 3);
INSERT INTO public.tag_link VALUES (163, 'examlist', 98, 3);
INSERT INTO public.tag_link VALUES (164, 'examlist', 98, 8);
INSERT INTO public.tag_link VALUES (165, 'examlist', 99, 3);
INSERT INTO public.tag_link VALUES (166, 'examlist', 99, 4);
INSERT INTO public.tag_link VALUES (167, 'examlist', 99, 7);
INSERT INTO public.tag_link VALUES (168, 'examlist', 100, 4);
INSERT INTO public.tag_link VALUES (169, 'examlist', 100, 7);
INSERT INTO public.tag_link VALUES (170, 'examlist', 101, 3);
INSERT INTO public.tag_link VALUES (171, 'examlist', 101, 4);
INSERT INTO public.tag_link VALUES (172, 'examlist', 101, 7);
INSERT INTO public.tag_link VALUES (176, 'examlist', 103, 3);
INSERT INTO public.tag_link VALUES (177, 'examlist', 103, 5);
INSERT INTO public.tag_link VALUES (178, 'examlist', 103, 7);
INSERT INTO public.tag_link VALUES (179, 'examlist', 104, 3);
INSERT INTO public.tag_link VALUES (180, 'examlist', 104, 5);
INSERT INTO public.tag_link VALUES (181, 'examlist', 104, 7);
INSERT INTO public.tag_link VALUES (182, 'examlist', 105, 3);
INSERT INTO public.tag_link VALUES (183, 'examlist', 105, 5);
INSERT INTO public.tag_link VALUES (184, 'examlist', 105, 7);
INSERT INTO public.tag_link VALUES (185, 'examlist', 106, 3);
INSERT INTO public.tag_link VALUES (186, 'examlist', 106, 5);
INSERT INTO public.tag_link VALUES (187, 'examlist', 106, 7);
INSERT INTO public.tag_link VALUES (188, 'examlist', 107, 3);
INSERT INTO public.tag_link VALUES (189, 'examlist', 107, 5);
INSERT INTO public.tag_link VALUES (190, 'examlist', 107, 7);
INSERT INTO public.tag_link VALUES (191, 'examlist', 108, 3);
INSERT INTO public.tag_link VALUES (192, 'examlist', 108, 7);
INSERT INTO public.tag_link VALUES (193, 'examlist', 109, 3);
INSERT INTO public.tag_link VALUES (194, 'examlist', 109, 6);
INSERT INTO public.tag_link VALUES (195, 'examlist', 109, 7);
INSERT INTO public.tag_link VALUES (196, 'examlist', 110, 3);
INSERT INTO public.tag_link VALUES (197, 'examlist', 110, 6);
INSERT INTO public.tag_link VALUES (198, 'examlist', 110, 7);
INSERT INTO public.tag_link VALUES (199, 'examlist', 111, 3);
INSERT INTO public.tag_link VALUES (200, 'examlist', 111, 6);
INSERT INTO public.tag_link VALUES (201, 'examlist', 111, 7);
INSERT INTO public.tag_link VALUES (202, 'examlist', 112, 3);
INSERT INTO public.tag_link VALUES (203, 'examlist', 112, 6);
INSERT INTO public.tag_link VALUES (204, 'examlist', 112, 7);
INSERT INTO public.tag_link VALUES (205, 'examlist', 113, 3);
INSERT INTO public.tag_link VALUES (206, 'examlist', 113, 6);
INSERT INTO public.tag_link VALUES (207, 'examlist', 113, 7);
INSERT INTO public.tag_link VALUES (208, 'examlist', 114, 3);
INSERT INTO public.tag_link VALUES (209, 'examlist', 114, 6);
INSERT INTO public.tag_link VALUES (210, 'examlist', 114, 7);
INSERT INTO public.tag_link VALUES (214, 'examlist', 116, 3);
INSERT INTO public.tag_link VALUES (215, 'examlist', 116, 5);
INSERT INTO public.tag_link VALUES (216, 'examlist', 116, 7);
INSERT INTO public.tag_link VALUES (217, 'examlist', 117, 3);
INSERT INTO public.tag_link VALUES (218, 'examlist', 117, 5);
INSERT INTO public.tag_link VALUES (219, 'examlist', 117, 7);
INSERT INTO public.tag_link VALUES (226, 'examlist', 120, 3);
INSERT INTO public.tag_link VALUES (233, 'examlist', 122, 4);
INSERT INTO public.tag_link VALUES (234, 'examlist', 122, 5);
INSERT INTO public.tag_link VALUES (235, 'examlist', 122, 7);
INSERT INTO public.tag_link VALUES (236, 'examlist', 123, 3);
INSERT INTO public.tag_link VALUES (237, 'examlist', 123, 4);
INSERT INTO public.tag_link VALUES (238, 'examlist', 123, 5);
INSERT INTO public.tag_link VALUES (239, 'examlist', 123, 7);
INSERT INTO public.tag_link VALUES (240, 'examlist', 124, 3);
INSERT INTO public.tag_link VALUES (241, 'examlist', 124, 6);
INSERT INTO public.tag_link VALUES (242, 'examlist', 124, 7);
INSERT INTO public.tag_link VALUES (243, 'examlist', 125, 3);
INSERT INTO public.tag_link VALUES (244, 'examlist', 125, 7);
INSERT INTO public.tag_link VALUES (245, 'examlist', 126, 3);
INSERT INTO public.tag_link VALUES (246, 'examlist', 126, 7);
INSERT INTO public.tag_link VALUES (247, 'examlist', 127, 3);
INSERT INTO public.tag_link VALUES (248, 'examlist', 127, 7);
INSERT INTO public.tag_link VALUES (249, 'examlist', 128, 3);
INSERT INTO public.tag_link VALUES (250, 'examlist', 128, 7);
INSERT INTO public.tag_link VALUES (251, 'examlist', 129, 3);
INSERT INTO public.tag_link VALUES (252, 'examlist', 129, 10);
INSERT INTO public.tag_link VALUES (253, 'institution', 2, 11);
INSERT INTO public.tag_link VALUES (254, 'department', 3, 12);
INSERT INTO public.tag_link VALUES (255, 'department', 4, 13);
INSERT INTO public.tag_link VALUES (256, 'examlist', 131, 3);
INSERT INTO public.tag_link VALUES (257, 'department', 5, 14);
INSERT INTO public.tag_link VALUES (258, 'examlist', 120, 1);
INSERT INTO public.tag_link VALUES (259, 'examlist', 121, 11);
INSERT INTO public.tag_link VALUES (264, 'department', 6, 15);
INSERT INTO public.tag_link VALUES (270, 'examlist', 103, 1);
INSERT INTO public.tag_link VALUES (271, 'examlist', 115, 3);
INSERT INTO public.tag_link VALUES (272, 'examlist', 115, 1);
INSERT INTO public.tag_link VALUES (273, 'examlist', 119, 3);
INSERT INTO public.tag_link VALUES (274, 'examlist', 119, 1);
INSERT INTO public.tag_link VALUES (279, 'department', 7, 16);
INSERT INTO public.tag_link VALUES (280, 'institution', 3, 29);
INSERT INTO public.tag_link VALUES (281, 'institution', 4, 30);
INSERT INTO public.tag_link VALUES (282, 'department', 8, 31);
INSERT INTO public.tag_link VALUES (283, 'department', 9, 32);
INSERT INTO public.tag_link VALUES (284, 'institution', 5, 33);
INSERT INTO public.tag_link VALUES (285, 'department', 10, 34);
INSERT INTO public.tag_link VALUES (286, 'procedure', 16, 4);
INSERT INTO public.tag_link VALUES (287, 'procedure', 16, 1);
INSERT INTO public.tag_link VALUES (293, 'examlist', 136, 10);
INSERT INTO public.tag_link VALUES (294, 'examlist', 136, 8);
INSERT INTO public.tag_link VALUES (295, 'procedure', 19, 1);
INSERT INTO public.tag_link VALUES (297, 'procedure', 6, 2);
INSERT INTO public.tag_link VALUES (298, 'procedure', 6, 3);
INSERT INTO public.tag_link VALUES (299, 'procedure', 7, 2);
INSERT INTO public.tag_link VALUES (310, 'procedure', 1, 1);
INSERT INTO public.tag_link VALUES (311, 'procedure', 6, 13);
INSERT INTO public.tag_link VALUES (312, 'procedure', 5, 2);
INSERT INTO public.tag_link VALUES (313, 'procedure', 8, 2);
INSERT INTO public.tag_link VALUES (314, 'procedure', 3, 3);
INSERT INTO public.tag_link VALUES (315, 'procedure', 3, 13);
INSERT INTO public.tag_link VALUES (316, 'procedure', 2, 2);
INSERT INTO public.tag_link VALUES (317, 'procedure', 2, 3);
INSERT INTO public.tag_link VALUES (318, 'examlist', 118, 8);
INSERT INTO public.tag_link VALUES (319, 'examlist', 118, 10);
INSERT INTO public.tag_link VALUES (321, 'examlist', 102, 7);
INSERT INTO public.tag_link VALUES (322, 'examlist', 102, 3);
INSERT INTO public.tag_link VALUES (324, 'examlist', 102, 16);
INSERT INTO public.tag_link VALUES (325, 'examlist', 102, 5);
INSERT INTO public.tag_link VALUES (332, 'examlist', 137, 13);
INSERT INTO public.tag_link VALUES (333, 'examlist', 137, 10);
INSERT INTO public.tag_link VALUES (334, 'examlist', 136, 13);
INSERT INTO public.tag_link VALUES (335, 'procedure', 22, 1);
INSERT INTO public.tag_link VALUES (339, 'examlist', 102, 1);
INSERT INTO public.tag_link VALUES (340, 'examlist', 140, 1);
INSERT INTO public.tag_link VALUES (341, 'examlist', 141, 11);
INSERT INTO public.tag_link VALUES (342, 'examlist', 144, 2);
INSERT INTO public.tag_link VALUES (343, 'examlist', 144, 16);
INSERT INTO public.tag_link VALUES (344, 'examlist', 118, 13);
INSERT INTO public.tag_link VALUES (345, 'examlist', 118, 12);
INSERT INTO public.tag_link VALUES (346, 'examlist', 115, 15);
INSERT INTO public.tag_link VALUES (347, 'procedure', 1, 3);
INSERT INTO public.tag_link VALUES (348, 'procedure', 24, 3);
INSERT INTO public.tag_link VALUES (349, 'procedure', 24, 1);
INSERT INTO public.tag_link VALUES (350, 'procedure', 25, 3);
INSERT INTO public.tag_link VALUES (351, 'procedure', 25, 1);
INSERT INTO public.tag_link VALUES (352, 'procedure', 26, 12);
INSERT INTO public.tag_link VALUES (353, 'procedure', 26, 11);
INSERT INTO public.tag_link VALUES (354, 'procedure', 27, 2);
INSERT INTO public.tag_link VALUES (355, 'procedure', 27, 1);
INSERT INTO public.tag_link VALUES (356, 'procedure', 28, 1);
INSERT INTO public.tag_link VALUES (357, 'procedure', 29, 11);
INSERT INTO public.tag_link VALUES (358, 'examlist', 126, 12);
INSERT INTO public.tag_link VALUES (359, 'examlist', 143, 3);
INSERT INTO public.tag_link VALUES (360, 'examlist', 143, 12);
INSERT INTO public.tag_link VALUES (361, 'procedure', 30, 1);
INSERT INTO public.tag_link VALUES (362, 'procedure', 31, 1);
INSERT INTO public.tag_link VALUES (363, 'procedure', 32, 1);
INSERT INTO public.tag_link VALUES (364, 'procedure', 33, 1);
INSERT INTO public.tag_link VALUES (365, 'procedure', 34, 1);
INSERT INTO public.tag_link VALUES (366, 'procedure', 35, 1);
INSERT INTO public.tag_link VALUES (367, 'procedure', 36, 1);
INSERT INTO public.tag_link VALUES (368, 'procedure', 37, 1);
INSERT INTO public.tag_link VALUES (369, 'procedure', 38, 11);
INSERT INTO public.tag_link VALUES (370, 'procedure', 39, 1);
INSERT INTO public.tag_link VALUES (371, 'procedure', 40, 1);
INSERT INTO public.tag_link VALUES (372, 'procedure', 41, 16);
INSERT INTO public.tag_link VALUES (373, 'procedure', 42, 1);
INSERT INTO public.tag_link VALUES (374, 'procedure', 1, 16);
INSERT INTO public.tag_link VALUES (375, 'procedure', 1, 11);
INSERT INTO public.tag_link VALUES (376, 'procedure', 43, 1);
INSERT INTO public.tag_link VALUES (377, 'procedure', 43, 11);
INSERT INTO public.tag_link VALUES (379, 'procedure', 22, 3);


--
-- TOC entry 5733 (class 0 OID 29856)
-- Dependencies: 354
-- Data for Name: task; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 5735 (class 0 OID 29868)
-- Dependencies: 356
-- Data for Name: task_link; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 5737 (class 0 OID 29875)
-- Dependencies: 358
-- Data for Name: task_master; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 5739 (class 0 OID 29891)
-- Dependencies: 360
-- Data for Name: task_master_link; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 5722 (class 0 OID 25599)
-- Dependencies: 343
-- Data for Name: xusercfg; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.xusercfg VALUES (1, '{"IdcPDPatientListDT": {"Ident": "IdcPDPatientListDT", "Columns": [{"Data": "pat_id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "id", "Width": "25%", "Visible": true, "Position": 1}, {"Data": "name", "Width": "36.25%", "Visible": true, "Position": 2}, {"Data": "birthdate", "Width": "21.25%", "Visible": true, "Position": 3}, {"Data": "age", "Width": "16.25%", "Visible": true, "Position": 4}, {"Data": "accessionnumber", "Width": "16.25%", "Visible": true, "Position": 5}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcPatientDosimetryDT": {"Ident": "IdcPatientDosimetryDT", "Columns": [{"Data": "stu_id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "modalitytitle", "Width": "12.5%", "Visible": true, "Position": 1}, {"Data": "date", "Width": "12.5%", "Visible": true, "Position": 2}, {"Data": "groupname", "Width": "21%", "Visible": false, "Position": 3}, {"Data": "accessionnumber", "Width": "16.25%", "Visible": true, "Position": 4}, {"Data": "description", "Width": "37.5%", "Visible": true, "Position": 5}], "Properties": {"RowHeight": 40, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}}', 110);
INSERT INTO public.xusercfg VALUES (16, '{"IdcTaskDT": {"Ident": "IdcTaskDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "dep_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "status_id", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "actionlinkid", "Width": "50px", "Visible": false, "Position": 3}, {"Data": "personincharge", "Width": "50px", "Visible": false, "Position": 4}, {"Data": "shortcut_pin", "Width": "40px", "Visible": false, "Position": 5}, {"Data": "begdate", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "Link", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "deadline", "Width": "10%", "Visible": true, "Position": 8}, {"Data": "closeddate", "Width": "10%", "Visible": true, "Position": 9}, {"Data": "status_name", "Width": "10%", "Visible": true, "Position": 10}, {"Data": "department", "Width": "15%", "Visible": true, "Position": 11}, {"Data": "origine", "Width": "15%", "Visible": true, "Position": 12}, {"Data": "description", "Width": "15%", "Visible": true, "Position": 13}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "normal"}}, "IdcLDDocumentDT_DT": {"Ident": "IdcLDDocumentDT_DT", "Columns": [{"Data": "shortcut", "Width": "110px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "10%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "10%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "10%", "Visible": false, "Position": 3}, {"Data": "revision", "Width": "10%", "Visible": true, "Position": 4}, {"Data": "label", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "date", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "author", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "name", "Width": "10%", "Visible": true, "Position": 8}, {"Data": "comment", "Width": "10%", "Visible": true, "Position": 9}, {"Data": "valid_until_date", "Width": "10%", "Visible": true, "Position": 10}], "Properties": {"RowHeight": 40, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "normal"}}, "IdcExamsListWorkingDT": {"Ident": "IdcExamsListWorkingDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "nameid", "Width": "113px", "Visible": true, "Position": 1}, {"Data": "modality", "Width": "20%", "Visible": true, "Position": 2}, {"Data": "description", "Width": "80%", "Visible": true, "Position": 3}, {"Data": "staff_member_id", "Width": "50px", "Visible": false, "Position": 4}, {"Data": "read_doc_at", "Width": "50px", "Visible": false, "Position": 5}, {"Data": "read_otherdoc_at", "Width": "50px", "Visible": false, "Position": 6}, {"Data": "riskv", "Width": "40px", "Visible": false, "Position": 7}, {"Data": "taglist", "Width": "40px", "Visible": false, "Position": 8}, {"Data": "doc_id", "Width": "40px", "Visible": false, "Position": 9}, {"Data": "doc_otherdoc_id", "Width": "40px", "Visible": false, "Position": 10}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "normal"}}, "IdcProcedureWorkingDT": {"Ident": "IdcProcedureWorkingDT", "Columns": [{"Data": "doc_id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "doc_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "name", "Width": "45%", "Visible": true, "Position": 2}, {"Data": "comment", "Width": "65%", "Visible": true, "Position": 3}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "normal"}}}', 110);
INSERT INTO public.xusercfg VALUES (1, '{"IdcPatientDosimetrySplitter1_2": {"Ident": "IdcPatientDosimetrySplitter1_2", "Properties": {"Ratio": 0.4088098918083462}}}', 100);
INSERT INTO public.xusercfg VALUES (13, '{"IdcTaskDT": {"Ident": "IdcTaskDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "dep_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "status_id", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "actionlinkid", "Width": "50px", "Visible": false, "Position": 3}, {"Data": "personincharge", "Width": "50px", "Visible": false, "Position": 4}, {"Data": "shortcut_pin", "Width": "40px", "Visible": false, "Position": 5}, {"Data": "begdate", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "Link", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "deadline", "Width": "10%", "Visible": true, "Position": 8}, {"Data": "closeddate", "Width": "10%", "Visible": true, "Position": 9}, {"Data": "status_name", "Width": "10%", "Visible": true, "Position": 10}, {"Data": "department", "Width": "15%", "Visible": true, "Position": 11}, {"Data": "origine", "Width": "15%", "Visible": true, "Position": 12}, {"Data": "description", "Width": "15%", "Visible": true, "Position": 13}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "normal"}}, "IdcExamsListWorkingDT": {"Ident": "IdcExamsListWorkingDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "nameid", "Width": "82px", "Visible": true, "Position": 1}, {"Data": "modality", "Width": "20%", "Visible": true, "Position": 2}, {"Data": "description", "Width": "80%", "Visible": true, "Position": 3}, {"Data": "riskv", "Width": "40px", "Visible": false, "Position": 4}, {"Data": "taglist", "Width": "40px", "Visible": false, "Position": 5}, {"Data": "doc_id", "Width": "40px", "Visible": false, "Position": 6}, {"Data": "doc_otherdoc_id", "Width": "40px", "Visible": false, "Position": 7}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcProcedureWorkingDT": {"Ident": "IdcProcedureWorkingDT", "Columns": [{"Data": "doc_id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "doc_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "name", "Width": "45%", "Visible": true, "Position": 2}, {"Data": "comment", "Width": "65%", "Visible": true, "Position": 3}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcLegalDocumentWorkingDT": {"Ident": "IdcLegalDocumentWorkingDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "name", "Width": "35%", "Visible": true, "Position": 1}, {"Data": "type", "Width": "20%", "Visible": true, "Position": 2}, {"Data": "comment", "Width": "45%", "Visible": true, "Position": 3}], "Properties": {"RowHeight": 30, "RowFontSize": 11, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}}', 110);
INSERT INTO public.xusercfg VALUES (0, '{"IdcTaskDT": {"Ident": "IdcTaskDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "dep_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "status_id", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "actionlinkid", "Width": "50px", "Visible": false, "Position": 3}, {"Data": "personincharge", "Width": "50px", "Visible": false, "Position": 4}, {"Data": "shortcut_pin", "Width": "40px", "Visible": false, "Position": 5}, {"Data": "begdate", "Width": "8.714285714285715%", "Visible": true, "Position": 6}, {"Data": "Link", "Width": "12.142857142857144%", "Visible": false, "Position": 7}, {"Data": "deadline", "Width": "8.285714285714286%", "Visible": true, "Position": 8}, {"Data": "closeddate", "Width": "7.857142857142858%", "Visible": true, "Position": 9}, {"Data": "status_name", "Width": "8.428571428571429%", "Visible": true, "Position": 10}, {"Data": "department", "Width": "13%", "Visible": true, "Position": 11}, {"Data": "origine", "Width": "17.14285714285714%", "Visible": true, "Position": 12}, {"Data": "description", "Width": "17.14285714285714%", "Visible": true, "Position": 13}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcAuditDT": {"Ident": "IdcAuditDT", "Columns": [{"Data": "afcnsend.id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "status_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "inst_id", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "dep_id", "Width": "50px", "Visible": false, "Position": 3}, {"Data": "audit_type", "Width": "50px", "Visible": false, "Position": 4}, {"Data": "date", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "status", "Width": "11%", "Visible": true, "Position": 6}, {"Data": "institution", "Width": "17.875%", "Visible": true, "Position": 7}, {"Data": "department", "Width": "12.75%", "Visible": true, "Position": 8}, {"Data": "title", "Width": "15.25%", "Visible": true, "Position": 9}, {"Data": "origine", "Width": "12.75%", "Visible": true, "Position": 10}, {"Data": "comment", "Width": "12.75%", "Visible": true, "Position": 11}, {"Data": "start_date", "Width": "12.75%", "Visible": true, "Position": 12}, {"Data": "end_date", "Width": "12.75%", "Visible": true, "Position": 13}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSurveyDT": {"Ident": "IdcSurveyDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "type", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "status", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "status_name", "Width": "10%", "Visible": true, "Position": 3}, {"Data": "survey_type", "Width": "10%", "Visible": true, "Position": 4}, {"Data": "begindate", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "enddate", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "title", "Width": "20%", "Visible": true, "Position": 7}, {"Data": "description", "Width": "40%", "Visible": false, "Position": 8}, {"Data": "comment", "Width": "40%", "Visible": false, "Position": 9}, {"Data": "conclusion", "Width": "40%", "Visible": false, "Position": 10}, {"Data": "listofactiondescription", "Width": "50px", "Visible": false, "Position": 11}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcIncidentDT": {"Ident": "IdcIncidentDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "dep_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "status_id", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "severity", "Width": "50px", "Visible": false, "Position": 3}, {"Data": "statuscomment", "Width": "50px", "Visible": false, "Position": 4}, {"Data": "reportdate", "Width": "9.5%", "Visible": true, "Position": 5}, {"Data": "closeddate", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "status_name", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "department", "Width": "15%", "Visible": true, "Position": 8}, {"Data": "reporterby", "Width": "10%", "Visible": true, "Position": 9}, {"Data": "title", "Width": "15%", "Visible": true, "Position": 10}, {"Data": "comment", "Width": "15%", "Visible": true, "Position": 11}, {"Data": "listofactiondescription", "Width": "20px", "Visible": false, "Position": 12}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcDosimetryDT": {"Ident": "IdcDosimetryDT", "Columns": [{"Data": "afcnsend.id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "status_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "inst_id", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "dep_id", "Width": "50px", "Visible": false, "Position": 3}, {"Data": "dev_id", "Width": "50px", "Visible": false, "Position": 4}, {"Data": "senddate", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "status", "Width": "13.142857142857142%", "Visible": true, "Position": 6}, {"Data": "institution", "Width": "13.428571428571429%", "Visible": true, "Position": 7}, {"Data": "department", "Width": "13.285714285714288%", "Visible": true, "Position": 8}, {"Data": "device", "Width": "8.285714285714286%", "Visible": true, "Position": 9}, {"Data": "title", "Width": "13.285714285714288%", "Visible": true, "Position": 10}, {"Data": "sender", "Width": "13.285714285714288%", "Visible": false, "Position": 11}, {"Data": "comment", "Width": "13.285714285714288%", "Visible": false, "Position": 12}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcExamsListDT": {"Ident": "IdcExamsListDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "nameid", "Width": "106px", "Visible": true, "Position": 1}, {"Data": "modality", "Width": "20%", "Visible": true, "Position": 2}, {"Data": "description", "Width": "80%", "Visible": true, "Position": 3}, {"Data": "riskv", "Width": "40px", "Visible": false, "Position": 4}, {"Data": "taglist", "Width": "40px", "Visible": false, "Position": 5}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcProcedureDT": {"Ident": "IdcProcedureDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "type", "Width": "40px", "Visible": false, "Position": 1}, {"Data": "name_fr", "Width": "23%", "Visible": true, "Position": 2}, {"Data": "comment", "Width": "38.5%", "Visible": true, "Position": 3}, {"Data": "alltagidallow", "Width": "38.5%", "Visible": false, "Position": 4}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcStaffListDT": {"Ident": "IdcStaffListDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "fullname", "Width": "40%", "Visible": true, "Position": 1}, {"Data": "job", "Width": "60%", "Visible": true, "Position": 2}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcDeviceListDT": {"Ident": "IdcDeviceListDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "ris_name", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "pacs_name", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "dacs_name", "Width": "50px", "Visible": false, "Position": 3}, {"Data": "type", "Width": "50px", "Visible": false, "Position": 4}, {"Data": "name", "Width": "15%", "Visible": true, "Position": 5}, {"Data": "brand", "Width": "15%", "Visible": true, "Position": 6}, {"Data": "model", "Width": "15%", "Visible": true, "Position": 7}, {"Data": "serialnumber", "Width": "15%", "Visible": true, "Position": 8}, {"Data": "modalitytype", "Width": "60px", "Visible": false, "Position": 9}, {"Data": "typename", "Width": "15%", "Visible": true, "Position": 10}, {"Data": "institution_name", "Width": "40%", "Visible": true, "Position": 11}, {"Data": "depname", "Width": "40%", "Visible": true, "Position": 12}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcDocReadingDT": {"Ident": "IdcDocReadingDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "fullname", "Width": "31.5%", "Visible": true, "Position": 1}, {"Data": "job", "Width": "21.5%", "Visible": true, "Position": 2}, {"Data": "institution", "Width": "21.5%", "Visible": true, "Position": 3}, {"Data": "department", "Width": "21.5%", "Visible": true, "Position": 4}, {"Data": "read_at_fmt", "Width": "14%", "Visible": true, "Position": 5}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "normal"}}, "IdcSettingsTagDT": {"Ident": "IdcSettingsTagDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "name", "Width": "100%", "Visible": true, "Position": 1}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSurveyFieldDT": {"Ident": "IdcSurveyFieldDT", "Columns": [{"Data": "shortcut", "Width": "50px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "type", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "type_name", "Width": "20%", "Visible": true, "Position": 3}, {"Data": "content", "Width": "80%", "Visible": true, "Position": 4}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcLDDocumentDT_DT": {"Ident": "IdcLDDocumentDT_DT", "Columns": [{"Data": "shortcut", "Width": "110px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "12.222222222222221%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "12.222222222222221%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "12.222222222222221%", "Visible": false, "Position": 3}, {"Data": "revision", "Width": "6%", "Visible": true, "Position": 4}, {"Data": "label", "Width": "12.222222222222221%", "Visible": true, "Position": 5}, {"Data": "date", "Width": "6.111111111111111%", "Visible": true, "Position": 6}, {"Data": "author", "Width": "6%", "Visible": true, "Position": 7}, {"Data": "name", "Width": "12.222222222222221%", "Visible": true, "Position": 8}, {"Data": "comment", "Width": "12.222222222222221%", "Visible": true, "Position": 9}, {"Data": "valid_until_date", "Width": "6.555555555555555%", "Visible": true, "Position": 10}], "Properties": {"RowHeight": 40, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcLegalDocumentDT": {"Ident": "IdcLegalDocumentDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "name", "Width": "32.5%", "Visible": true, "Position": 1}, {"Data": "type", "Width": "22.5%", "Visible": true, "Position": 2}, {"Data": "comment", "Width": "45%", "Visible": true, "Position": 3}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSurveyResponseDT": {"Ident": "IdcSurveyResponseDT", "Columns": [{"Data": "id", "Width": "10%", "Visible": true, "Position": 0}, {"Data": "rdate", "Width": "90%", "Visible": true, "Position": 1}], "Properties": {"RowHeight": 25, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "normal"}}, "IdcAudtiDocListDT_DT": {"Ident": "IdcAudtiDocListDT_DT", "Columns": [{"Data": "shortcut", "Width": "110px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "10%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "10%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "10%", "Visible": false, "Position": 3}, {"Data": "revision", "Width": "10%", "Visible": true, "Position": 4}, {"Data": "label", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "date", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "author", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "name", "Width": "10%", "Visible": true, "Position": 8}, {"Data": "comment", "Width": "10%", "Visible": true, "Position": 9}, {"Data": "valid_until_date", "Width": "10%", "Visible": true, "Position": 10}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcInstDocInstListDT": {"Ident": "IdcInstDocInstListDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "name", "Width": "100%", "Visible": true, "Position": 1}], "Properties": {"RowHeight": 40, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcInstDocumentDT_DT": {"Ident": "IdcInstDocumentDT_DT", "Columns": [{"Data": "shortcut", "Width": "140px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "10%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "10%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "10%", "Visible": false, "Position": 3}, {"Data": "status_id", "Width": "10%", "Visible": false, "Position": 4}, {"Data": "name", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "revision", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "label", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "date", "Width": "10%", "Visible": true, "Position": 8}, {"Data": "author", "Width": "10%", "Visible": false, "Position": 9}, {"Data": "status_name", "Width": "10%", "Visible": true, "Position": 10}, {"Data": "comment", "Width": "10%", "Visible": false, "Position": 11}, {"Data": "valid_until_date", "Width": "10%", "Visible": true, "Position": 12}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcProcDocumentDT_DT": {"Ident": "IdcProcDocumentDT_DT", "Columns": [{"Data": "shortcut", "Width": "110px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "10%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "10%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "10%", "Visible": false, "Position": 3}, {"Data": "revision", "Width": "10%", "Visible": true, "Position": 4}, {"Data": "label", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "date", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "author", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "name", "Width": "10%", "Visible": true, "Position": 8}, {"Data": "comment", "Width": "10%", "Visible": true, "Position": 9}, {"Data": "valid_until_date", "Width": "10%", "Visible": true, "Position": 10}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsJobRoleDT": {"Ident": "IdcSettingsJobRoleDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "scope_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "name", "Width": "100%", "Visible": true, "Position": 2}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsWarningDT": {"Ident": "IdcSettingsWarningDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "sex_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "age_id", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "title", "Width": "40%", "Visible": true, "Position": 3}, {"Data": "description", "Width": "60%", "Visible": true, "Position": 4}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsDocumentDT": {"Ident": "IdcSettingsDocumentDT", "Columns": [{"Data": "type", "Width": "100%", "Visible": true, "Position": 0}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcDosimetryFilesDT_DT": {"Ident": "IdcDosimetryFilesDT_DT", "Columns": [{"Data": "shortcut", "Width": "110px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "10%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "10%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "10%", "Visible": false, "Position": 3}, {"Data": "label", "Width": "10%", "Visible": true, "Position": 4}, {"Data": "date", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "author", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "name", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "comment", "Width": "10%", "Visible": true, "Position": 8}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsExamIdentDT": {"Ident": "IdcSettingsExamIdentDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "name", "Width": "30%", "Visible": true, "Position": 1}, {"Data": "description", "Width": "70%", "Visible": true, "Position": 2}], "Properties": {"RowHeight": 25, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsExamsListDT": {"Ident": "IdcSettingsExamsListDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "nameid", "Width": "30%", "Visible": true, "Position": 1}, {"Data": "modality", "Width": "20%", "Visible": true, "Position": 2}, {"Data": "description", "Width": "50%", "Visible": true, "Position": 3}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsLoginRoleDT": {"Ident": "IdcSettingsLoginRoleDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "scope_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "name", "Width": "100%", "Visible": true, "Position": 2}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcInstDepDocumentDT_DT": {"Ident": "IdcInstDepDocumentDT_DT", "Columns": [{"Data": "shortcut", "Width": "110px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "10%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "10%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "10%", "Visible": false, "Position": 3}, {"Data": "revision", "Width": "10%", "Visible": true, "Position": 4}, {"Data": "label", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "date", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "author", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "name", "Width": "10%", "Visible": true, "Position": 8}, {"Data": "comment", "Width": "10%", "Visible": true, "Position": 9}, {"Data": "valid_until_date", "Width": "10%", "Visible": true, "Position": 10}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcStaffFormationListDT": {"Ident": "IdcStaffFormationListDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "status_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "status_name", "Width": "100px", "Visible": true, "Position": 2}, {"Data": "planned_date", "Width": "100px", "Visible": true, "Position": 3}, {"Data": "formation_date", "Width": "100px", "Visible": true, "Position": 4}, {"Data": "title", "Width": "100px", "Visible": true, "Position": 5}, {"Data": "type", "Width": "100px", "Visible": true, "Position": 6}, {"Data": "comment", "Width": "100px", "Visible": true, "Position": 7}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcExamsListDocListDT_DT": {"Ident": "IdcExamsListDocListDT_DT", "Columns": [{"Data": "shortcut", "Width": "140px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "10.3%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "10.3%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "10.3%", "Visible": false, "Position": 3}, {"Data": "name", "Width": "10.3%", "Visible": true, "Position": 4}, {"Data": "revision", "Width": "7%", "Visible": true, "Position": 5}, {"Data": "label", "Width": "10.3%", "Visible": true, "Position": 6}, {"Data": "date", "Width": "10.3%", "Visible": true, "Position": 7}, {"Data": "author", "Width": "10.3%", "Visible": false, "Position": 8}, {"Data": "status_name", "Width": "10.3%", "Visible": true, "Position": 9}, {"Data": "comment", "Width": "10.3%", "Visible": false, "Position": 10}, {"Data": "valid_until_date", "Width": "10.3%", "Visible": true, "Position": 11}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "normal"}}, "IdcSettingsInstitutionDT": {"Ident": "IdcSettingsInstitutionDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "name", "Width": "100%", "Visible": true, "Position": 1}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsStaffMemberDT": {"Ident": "IdcSettingsStaffMemberDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "lastname", "Width": "50%", "Visible": true, "Position": 1}, {"Data": "firstname", "Width": "50%", "Visible": true, "Position": 2}, {"Data": "login", "Width": "50%", "Visible": false, "Position": 3}, {"Data": "password", "Width": "50%", "Visible": false, "Position": 4}, {"Data": "login_role_id", "Width": "50%", "Visible": false, "Position": 5}, {"Data": "active", "Width": "50%", "Visible": false, "Position": 6}, {"Data": "ris_name", "Width": "50%", "Visible": false, "Position": 7}, {"Data": "pacs_name", "Width": "50%", "Visible": false, "Position": 8}, {"Data": "dacs_name", "Width": "50%", "Visible": false, "Position": 9}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcDeviceInspectionListDT": {"Ident": "IdcDeviceInspectionListDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "status_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "result", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "comment", "Width": "50px", "Visible": false, "Position": 3}, {"Data": "listofactiondescription", "Width": "50px", "Visible": false, "Position": 4}, {"Data": "status_name", "Width": "16%", "Visible": true, "Position": 5}, {"Data": "planned_date", "Width": "18.5%", "Visible": true, "Position": 6}, {"Data": "inspection_date", "Width": "18.5%", "Visible": true, "Position": 7}, {"Data": "result_name", "Width": "18.5%", "Visible": true, "Position": 8}, {"Data": "type", "Width": "28.5%", "Visible": true, "Position": 9}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcDeviceMaintenanceListDT": {"Ident": "IdcDeviceMaintenanceListDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "status_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "comment", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "status_name", "Width": "22%", "Visible": true, "Position": 3}, {"Data": "planned_date", "Width": "26%", "Visible": true, "Position": 4}, {"Data": "maintenance_date", "Width": "26%", "Visible": true, "Position": 5}, {"Data": "type", "Width": "26%", "Visible": true, "Position": 6}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcInstDocDepartmentListDT": {"Ident": "IdcInstDocDepartmentListDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "name", "Width": "100%", "Visible": true, "Position": 1}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsInsDepartmentDT": {"Ident": "IdcSettingsInsDepartmentDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "inst_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "name", "Width": "100%", "Visible": true, "Position": 2}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcDeviceInstallationListDT": {"Ident": "IdcDeviceInstallationListDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "dep_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "department", "Width": "25%", "Visible": true, "Position": 2}, {"Data": "installdate", "Width": "14%", "Visible": true, "Position": 3}, {"Data": "removeddate", "Width": "14%", "Visible": true, "Position": 4}, {"Data": "installedby", "Width": "24%", "Visible": true, "Position": 5}, {"Data": "inchargeof", "Width": "24%", "Visible": false, "Position": 6}, {"Data": "comment", "Width": "49%", "Visible": false, "Position": 7}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsStaffMemberJobDT": {"Ident": "IdcSettingsStaffMemberJobDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "staff_role_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "dep_id", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "institutionname", "Width": "49.25%", "Visible": true, "Position": 3}, {"Data": "departmentname", "Width": "49.25%", "Visible": true, "Position": 4}, {"Data": "rolename", "Width": "49.25%", "Visible": true, "Position": 5}, {"Data": "begdate", "Width": "33%", "Visible": true, "Position": 6}, {"Data": "enddate", "Width": "29.25%", "Visible": true, "Position": 7}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsExamsLinkedListDT": {"Ident": "IdcSettingsExamsLinkedListDT", "Columns": [{"Data": "", "Width": "60px", "Visible": true, "Position": 0}, {"Data": "exam_id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "examident_id", "Width": "50px", "Visible": false, "Position": 2}, {"Data": "name", "Width": "30%", "Visible": true, "Position": 3}, {"Data": "description", "Width": "70%", "Visible": true, "Position": 4}], "Properties": {"RowHeight": 25, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcStaffFormationDocListDT_DT": {"Ident": "IdcStaffFormationDocListDT_DT", "Columns": [{"Data": "shortcut", "Width": "110px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "10%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "10%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "10%", "Visible": false, "Position": 3}, {"Data": "revision", "Width": "10%", "Visible": true, "Position": 4}, {"Data": "label", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "date", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "author", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "name", "Width": "10%", "Visible": true, "Position": 8}, {"Data": "comment", "Width": "10%", "Visible": true, "Position": 9}, {"Data": "valid_until_date", "Width": "10%", "Visible": true, "Position": 10}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcDeviceInspectionDocListDT_DT": {"Ident": "IdcDeviceInspectionDocListDT_DT", "Columns": [{"Data": "shortcut", "Width": "110px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "10%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "10%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "10%", "Visible": false, "Position": 3}, {"Data": "revision", "Width": "10%", "Visible": true, "Position": 4}, {"Data": "label", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "date", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "author", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "name", "Width": "10%", "Visible": true, "Position": 8}, {"Data": "comment", "Width": "10%", "Visible": true, "Position": 9}, {"Data": "valid_until_date", "Width": "10%", "Visible": true, "Position": 10}], "Properties": {"RowHeight": 20, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsExamsNotLinkedListDT": {"Ident": "IdcSettingsExamsNotLinkedListDT", "Columns": [{"Data": "", "Width": "60px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "name", "Width": "30%", "Visible": true, "Position": 2}, {"Data": "description", "Width": "70%", "Visible": true, "Position": 3}], "Properties": {"RowHeight": 25, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcDeviceDescriptionDocListDT_DT": {"Ident": "IdcDeviceDescriptionDocListDT_DT", "Columns": [{"Data": "shortcut", "Width": "110px", "Visible": true, "Position": 0}, {"Data": "id", "Width": "10%", "Visible": false, "Position": 1}, {"Data": "doc_master_id", "Width": "10%", "Visible": false, "Position": 2}, {"Data": "doc_master_groupid", "Width": "10%", "Visible": false, "Position": 3}, {"Data": "revision", "Width": "10%", "Visible": true, "Position": 4}, {"Data": "label", "Width": "10%", "Visible": true, "Position": 5}, {"Data": "date", "Width": "10%", "Visible": true, "Position": 6}, {"Data": "author", "Width": "10%", "Visible": true, "Position": 7}, {"Data": "name", "Width": "10%", "Visible": true, "Position": 8}, {"Data": "comment", "Width": "10%", "Visible": true, "Position": 9}, {"Data": "valid_until_date", "Width": "10%", "Visible": true, "Position": 10}], "Properties": {"RowHeight": 25, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}, "IdcSettingsLoginRolePermissionDT": {"Ident": "IdcSettingsLoginRolePermissionDT", "Columns": [{"Data": "id", "Width": "50px", "Visible": false, "Position": 0}, {"Data": "working_view_exist", "Width": "50px", "Visible": false, "Position": 1}, {"Data": "ptype", "Width": "15%", "Visible": true, "Position": 2}, {"Data": "description", "Width": "55%", "Visible": true, "Position": 3}, {"Data": "value", "Width": "15%", "Visible": true, "Position": 4}, {"Data": "working_view", "Width": "15%", "Visible": true, "Position": 5}], "Properties": {"RowHeight": 30, "RowFontSize": 12, "HeaderFontSize": 14, "HeaderFontWeight": "bold"}}}', 110);
INSERT INTO public.xusercfg VALUES (16, '{"IdcSLRSplitter1_2": {"Ident": "IdcSLRSplitter1_2", "Properties": {"Ratio": 0.4}}, "IdcTaskSplitter1_2": {"Ident": "IdcTaskSplitter1_2", "Properties": {"Ratio": 0.5}}, "IdcSurveySplitter1_2": {"Ident": "IdcSurveySplitter1_2", "Properties": {"Ratio": 0.5}}, "IdcSurveySplitter3_4": {"Ident": "IdcSurveySplitter3_4", "Properties": {"Ratio": 0.43973214285714285}}, "IdcSurveySplitter5_6": {"Ident": "IdcSurveySplitter5_6", "Properties": {"Ratio": 0.6}}, "IdcSurveySplitter7_8": {"Ident": "IdcSurveySplitter7_8", "Properties": {"Ratio": 0.3}}, "IdcExamsListSplitter1_2": {"Ident": "IdcExamsListSplitter1_2", "Properties": {"Ratio": 0.30427763505954053}}, "IdcExamsListSplitter3_4": {"Ident": "IdcExamsListSplitter3_4", "Properties": {"Ratio": 0.42395498392282954}}, "IdcExamsListSplitter5_6": {"Ident": "IdcExamsListSplitter5_6", "Properties": {"Ratio": 0.727972027972028}}, "IdcProcedureSplitter1_2": {"Ident": "IdcProcedureSplitter1_2", "Properties": {"Ratio": 0.4711561306496346}}, "IdcExamsListWorkingSplitter1_2": {"Ident": "IdcExamsListWorkingSplitter1_2", "Properties": {"Ratio": 0.5}}, "IdcExamsListWorkingSplitter2_3": {"Ident": "IdcExamsListWorkingSplitter2_3", "Properties": {"Ratio": 0.5}}, "IdcProcedureWorkingSplitter1_2": {"Ident": "IdcProcedureWorkingSplitter1_2", "Properties": {"Ratio": 0.472708488656939}}, "IdcLegalDocumentWorkingSplitter1_2": {"Ident": "IdcLegalDocumentWorkingSplitter1_2", "Properties": {"Ratio": 0.4668460493052785}}}', 100);
INSERT INTO public.xusercfg VALUES (0, '{"IdcBQSplitter1_2": {"Ident": "IdcBQSplitter1_2", "Properties": {"Ratio": 0.3}}, "IdcSDSplitter1_2": {"Ident": "IdcSDSplitter1_2", "Properties": {"Ratio": 0.41311394441931154}}, "IdcSISplitter1_2": {"Ident": "IdcSISplitter1_2", "Properties": {"Ratio": 0.4}}, "IdcSISplitter3_4": {"Ident": "IdcSISplitter3_4", "Properties": {"Ratio": 0.5999999999999999}}, "IdcSTSplitter1_2": {"Ident": "IdcSTSplitter1_2", "Properties": {"Ratio": 0.39999999999999997}}, "IdcSWSplitter1_2": {"Ident": "IdcSWSplitter1_2", "Properties": {"Ratio": 0.39999999999999997}}, "IdcSEISplitter1_2": {"Ident": "IdcSEISplitter1_2", "Properties": {"Ratio": 0.39999999999999997}}, "IdcSELSplitter1_2": {"Ident": "IdcSELSplitter1_2", "Properties": {"Ratio": 0.5}}, "IdcSELSplitter3_4": {"Ident": "IdcSELSplitter3_4", "Properties": {"Ratio": 0.5}}, "IdcSJRSplitter1_2": {"Ident": "IdcSJRSplitter1_2", "Properties": {"Ratio": 0.4}}, "IdcSLRSplitter1_2": {"Ident": "IdcSLRSplitter1_2", "Properties": {"Ratio": 0.4}}, "IdcSSMSplitter1_2": {"Ident": "IdcSSMSplitter1_2", "Properties": {"Ratio": 0.31993881129193624}}, "IdcSSMSplitter3_4": {"Ident": "IdcSSMSplitter3_4", "Properties": {"Ratio": 0.6010809626219136}}, "IdcTaskSplitter1_2": {"Ident": "IdcTaskSplitter1_2", "Properties": {"Ratio": 0.5}}, "IdcAuditSplitter1_2": {"Ident": "IdcAuditSplitter1_2", "Properties": {"Ratio": 0.43485853282183623}}, "IdcAuditSplitter3_4": {"Ident": "IdcAuditSplitter3_4", "Properties": {"Ratio": 0.4}}, "IdcStaffSplitter1_2": {"Ident": "IdcStaffSplitter1_2", "Properties": {"Ratio": 0.29301811331676053}}, "IdcStaffSplitter3_4": {"Ident": "IdcStaffSplitter3_4", "Properties": {"Ratio": 0.4}}, "IdcStaffSplitter5_6": {"Ident": "IdcStaffSplitter5_6", "Properties": {"Ratio": 0.6}}, "IdcDeviceSplitter1_2": {"Ident": "IdcDeviceSplitter1_2", "Properties": {"Ratio": 0.4605710237957896}}, "IdcSurveySplitter1_2": {"Ident": "IdcSurveySplitter1_2", "Properties": {"Ratio": 0.4233055885850178}}, "IdcSurveySplitter3_4": {"Ident": "IdcSurveySplitter3_4", "Properties": {"Ratio": 0.5324695730247406}}, "IdcSurveySplitter5_6": {"Ident": "IdcSurveySplitter5_6", "Properties": {"Ratio": 0.6}}, "IdcSurveySplitter7_8": {"Ident": "IdcSurveySplitter7_8", "Properties": {"Ratio": 0.3}}, "IdcInstDocSplitter1_2": {"Ident": "IdcInstDocSplitter1_2", "Properties": {"Ratio": 0.43953077146639924}}, "IdcInstDocSplitter3_4": {"Ident": "IdcInstDocSplitter3_4", "Properties": {"Ratio": 0.3517401547998709}}, "IdcInstDocSplitter5_6": {"Ident": "IdcInstDocSplitter5_6", "Properties": {"Ratio": 0.5}}, "IdcIncidentSplitter1_2": {"Ident": "IdcIncidentSplitter1_2", "Properties": {"Ratio": 0.5}}, "IdcIncidentSplitter3_4": {"Ident": "IdcIncidentSplitter3_4", "Properties": {"Ratio": 0.6}}, "IdcDosimetrySplitter1_2": {"Ident": "IdcDosimetrySplitter1_2", "Properties": {"Ratio": 0.614764644860582}}, "IdcDosimetrySplitter3_4": {"Ident": "IdcDosimetrySplitter3_4", "Properties": {"Ratio": 0.6497854077253219}}, "IdcExamsListSplitter1_2": {"Ident": "IdcExamsListSplitter1_2", "Properties": {"Ratio": 0.2999999999999999}}, "IdcExamsListSplitter3_4": {"Ident": "IdcExamsListSplitter3_4", "Properties": {"Ratio": 0.35}}, "IdcExamsListSplitter5_6": {"Ident": "IdcExamsListSplitter5_6", "Properties": {"Ratio": 0.5}}, "IdcProcedureSplitter1_2": {"Ident": "IdcProcedureSplitter1_2", "Properties": {"Ratio": 0.4711561306496345}}, "IdcTaskMasterSplitter1_2": {"Ident": "IdcTaskMasterSplitter1_2", "Properties": {"Ratio": 0.5}}, "IdcLegalDocumentSplitter1_2": {"Ident": "IdcLegalDocumentSplitter1_2", "Properties": {"Ratio": 0.35092385529493025}}, "IdcDeviceInspectionSplitter1_2": {"Ident": "IdcDeviceInspectionSplitter1_2", "Properties": {"Ratio": 0.4}}, "IdcDeviceInspectionSplitter3_4": {"Ident": "IdcDeviceInspectionSplitter3_4", "Properties": {"Ratio": 0.6}}, "IdcExamsListWorkingSplitter1_2": {"Ident": "IdcExamsListWorkingSplitter1_2", "Properties": {"Ratio": 0.5}}, "IdcExamsListWorkingSplitter2_3": {"Ident": "IdcExamsListWorkingSplitter2_3", "Properties": {"Ratio": 0.6674364896073903}}, "IdcProcedureWorkingSplitter1_2": {"Ident": "IdcProcedureWorkingSplitter1_2", "Properties": {"Ratio": 0.42292682926829267}}, "IdcDeviceMaintenanceSplitter1_2": {"Ident": "IdcDeviceMaintenanceSplitter1_2", "Properties": {"Ratio": 0.4}}, "IdcDeviceMaintenanceSplitter3_4": {"Ident": "IdcDeviceMaintenanceSplitter3_4", "Properties": {"Ratio": 0.6}}, "IdcDeviceInstallationSplitter1_2": {"Ident": "IdcDeviceInstallationSplitter1_2", "Properties": {"Ratio": 0.4}}, "IdcDeviceInstallationSplitter3_4": {"Ident": "IdcDeviceInstallationSplitter3_4", "Properties": {"Ratio": 0.6}}, "IdcLegalDocumentWorkingSplitter1_2": {"Ident": "IdcLegalDocumentWorkingSplitter1_2", "Properties": {"Ratio": 0.4668460493052785}}}', 100);
INSERT INTO public.xusercfg VALUES (13, '{"IdcSDSplitter1_2": {"Ident": "IdcSDSplitter1_2", "Properties": {"Ratio": 0.5}}, "IdcSSMSplitter1_2": {"Ident": "IdcSSMSplitter1_2", "Properties": {"Ratio": 0.25}}, "IdcSSMSplitter3_4": {"Ident": "IdcSSMSplitter3_4", "Properties": {"Ratio": 0.6000000000000001}}, "IdcTaskSplitter1_2": {"Ident": "IdcTaskSplitter1_2", "Properties": {"Ratio": 0.5}}, "IdcInstDocSplitter1_2": {"Ident": "IdcInstDocSplitter1_2", "Properties": {"Ratio": 0.3}}, "IdcInstDocSplitter3_4": {"Ident": "IdcInstDocSplitter3_4", "Properties": {"Ratio": 0.35}}, "IdcInstDocSplitter5_6": {"Ident": "IdcInstDocSplitter5_6", "Properties": {"Ratio": 0.5}}, "IdcExamsListSplitter1_2": {"Ident": "IdcExamsListSplitter1_2", "Properties": {"Ratio": 0.29999999999999993}}, "IdcExamsListSplitter3_4": {"Ident": "IdcExamsListSplitter3_4", "Properties": {"Ratio": 0.35}}, "IdcExamsListSplitter5_6": {"Ident": "IdcExamsListSplitter5_6", "Properties": {"Ratio": 0.5}}, "IdcProcedureSplitter1_2": {"Ident": "IdcProcedureSplitter1_2", "Properties": {"Ratio": 0.4378624326710377}}}', 100);


--
-- TOC entry 5723 (class 0 OID 25604)
-- Dependencies: 344
-- Data for Name: xusercfgparameter; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.xusercfgparameter VALUES (110, 4, 5, 11000, 'DataTableConfiguration', 'DataTableConfiguration', 'DataTableConfiguration', '{}');
INSERT INTO public.xusercfgparameter VALUES (100, 4, 5, 10000, 'SplitterConfiguration', 'SplitterConfiguration', 'SplitterConfiguration', NULL);


--
-- TOC entry 5804 (class 0 OID 0)
-- Dependencies: 217
-- Name: action_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.action_id_seq', 9, true);


--
-- TOC entry 5805 (class 0 OID 0)
-- Dependencies: 219
-- Name: action_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.action_link_id_seq', 36, true);


--
-- TOC entry 5806 (class 0 OID 0)
-- Dependencies: 221
-- Name: afcnsend_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.afcnsend_id_seq', 16, true);


--
-- TOC entry 5807 (class 0 OID 0)
-- Dependencies: 223
-- Name: agelist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.agelist_id_seq', 1, false);


--
-- TOC entry 5808 (class 0 OID 0)
-- Dependencies: 225
-- Name: audit_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.audit_id_seq', 20, true);


--
-- TOC entry 5809 (class 0 OID 0)
-- Dependencies: 227
-- Name: audit_record_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.audit_record_id_seq', 426, true);


--
-- TOC entry 5810 (class 0 OID 0)
-- Dependencies: 229
-- Name: audit_recordprocedure_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.audit_recordprocedure_id_seq', 112, true);


--
-- TOC entry 5811 (class 0 OID 0)
-- Dependencies: 231
-- Name: audit_subrecord_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.audit_subrecord_id_seq', 372, true);


--
-- TOC entry 5812 (class 0 OID 0)
-- Dependencies: 233
-- Name: audit_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.audit_type_id_seq', 3, true);


--
-- TOC entry 5813 (class 0 OID 0)
-- Dependencies: 348
-- Name: civilitylist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.civilitylist_id_seq', 1, false);


--
-- TOC entry 5814 (class 0 OID 0)
-- Dependencies: 347
-- Name: default_read_needed_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.default_read_needed_id_seq', 214, true);


--
-- TOC entry 5815 (class 0 OID 0)
-- Dependencies: 235
-- Name: department_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.department_id_seq', 10, true);


--
-- TOC entry 5816 (class 0 OID 0)
-- Dependencies: 237
-- Name: device_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.device_id_seq', 26, true);


--
-- TOC entry 5817 (class 0 OID 0)
-- Dependencies: 239
-- Name: device_inspection_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.device_inspection_id_seq', 9, true);


--
-- TOC entry 5818 (class 0 OID 0)
-- Dependencies: 241
-- Name: device_installation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.device_installation_id_seq', 67, true);


--
-- TOC entry 5819 (class 0 OID 0)
-- Dependencies: 243
-- Name: device_maintenance_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.device_maintenance_id_seq', 7, true);


--
-- TOC entry 5820 (class 0 OID 0)
-- Dependencies: 245
-- Name: document_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.document_id_seq', 410, true);


--
-- TOC entry 5821 (class 0 OID 0)
-- Dependencies: 247
-- Name: document_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.document_link_id_seq', 388, true);


--
-- TOC entry 5822 (class 0 OID 0)
-- Dependencies: 249
-- Name: document_master_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.document_master_id_seq', 377, true);


--
-- TOC entry 5823 (class 0 OID 0)
-- Dependencies: 251
-- Name: documentstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.documentstatus_id_seq', 470, true);


--
-- TOC entry 5824 (class 0 OID 0)
-- Dependencies: 350
-- Name: documenttypelist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.documenttypelist_id_seq', 1, false);


--
-- TOC entry 5825 (class 0 OID 0)
-- Dependencies: 254
-- Name: examident_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.examident_id_seq', 5, true);


--
-- TOC entry 5826 (class 0 OID 0)
-- Dependencies: 257
-- Name: examlist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.examlist_id_seq', 147, true);


--
-- TOC entry 5827 (class 0 OID 0)
-- Dependencies: 259
-- Name: examwarning_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.examwarning_id_seq', 11, true);


--
-- TOC entry 5828 (class 0 OID 0)
-- Dependencies: 262
-- Name: external_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.external_link_id_seq', 1, false);


--
-- TOC entry 5829 (class 0 OID 0)
-- Dependencies: 264
-- Name: external_src_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.external_src_id_seq', 1, false);


--
-- TOC entry 5830 (class 0 OID 0)
-- Dependencies: 266
-- Name: institution_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.institution_id_seq', 5, true);


--
-- TOC entry 5831 (class 0 OID 0)
-- Dependencies: 268
-- Name: legaldocument_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.legaldocument_id_seq', 28, true);


--
-- TOC entry 5832 (class 0 OID 0)
-- Dependencies: 272
-- Name: login_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.login_role_id_seq', 5, true);


--
-- TOC entry 5833 (class 0 OID 0)
-- Dependencies: 274
-- Name: login_role_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.login_role_permission_id_seq', 123, true);


--
-- TOC entry 5834 (class 0 OID 0)
-- Dependencies: 276
-- Name: procedure_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.procedure_id_seq', 43, true);


--
-- TOC entry 5835 (class 0 OID 0)
-- Dependencies: 278
-- Name: quaad_description_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.quaad_description_id_seq', 348, true);


--
-- TOC entry 5836 (class 0 OID 0)
-- Dependencies: 281
-- Name: quaad_point_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.quaad_point_id_seq', 338, true);


--
-- TOC entry 5837 (class 0 OID 0)
-- Dependencies: 283
-- Name: quaadpoint_tag_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.quaadpoint_tag_id_seq', 108, true);


--
-- TOC entry 5838 (class 0 OID 0)
-- Dependencies: 285
-- Name: quaadpoint_tag_name_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.quaadpoint_tag_name_id_seq', 112, true);


--
-- TOC entry 5839 (class 0 OID 0)
-- Dependencies: 288
-- Name: report_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.report_id_seq', 30, true);


--
-- TOC entry 5840 (class 0 OID 0)
-- Dependencies: 291
-- Name: sexlist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sexlist_id_seq', 1, false);


--
-- TOC entry 5841 (class 0 OID 0)
-- Dependencies: 293
-- Name: staff_formation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.staff_formation_id_seq', 5, true);


--
-- TOC entry 5842 (class 0 OID 0)
-- Dependencies: 295
-- Name: staff_job_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.staff_job_id_seq', 37, true);


--
-- TOC entry 5843 (class 0 OID 0)
-- Dependencies: 297
-- Name: staff_member_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.staff_member_id_seq', 22, true);


--
-- TOC entry 5844 (class 0 OID 0)
-- Dependencies: 299
-- Name: staff_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.staff_role_id_seq', 10, true);


--
-- TOC entry 5845 (class 0 OID 0)
-- Dependencies: 301
-- Name: statuslist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.statuslist_id_seq', 9, true);


--
-- TOC entry 5846 (class 0 OID 0)
-- Dependencies: 304
-- Name: survey_field_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.survey_field_id_seq', 43, true);


--
-- TOC entry 5847 (class 0 OID 0)
-- Dependencies: 306
-- Name: survey_field_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.survey_field_type_id_seq', 7, true);


--
-- TOC entry 5848 (class 0 OID 0)
-- Dependencies: 307
-- Name: survey_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.survey_id_seq', 5, true);


--
-- TOC entry 5849 (class 0 OID 0)
-- Dependencies: 310
-- Name: survey_resp_field_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.survey_resp_field_id_seq', 168, true);


--
-- TOC entry 5850 (class 0 OID 0)
-- Dependencies: 311
-- Name: survey_resp_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.survey_resp_id_seq', 13, true);


--
-- TOC entry 5851 (class 0 OID 0)
-- Dependencies: 313
-- Name: survey_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.survey_type_id_seq', 1, true);


--
-- TOC entry 5852 (class 0 OID 0)
-- Dependencies: 315
-- Name: tag_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tag_id_seq', 36, true);


--
-- TOC entry 5853 (class 0 OID 0)
-- Dependencies: 317
-- Name: tag_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tag_link_id_seq', 379, true);


--
-- TOC entry 5854 (class 0 OID 0)
-- Dependencies: 352
-- Name: task_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.task_id_seq', 1, false);


--
-- TOC entry 5855 (class 0 OID 0)
-- Dependencies: 355
-- Name: task_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.task_link_id_seq', 1, false);


--
-- TOC entry 5856 (class 0 OID 0)
-- Dependencies: 357
-- Name: task_master_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.task_master_id_seq', 1, false);


--
-- TOC entry 5857 (class 0 OID 0)
-- Dependencies: 359
-- Name: task_master_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.task_master_link_id_seq', 1, false);


--
-- TOC entry 5858 (class 0 OID 0)
-- Dependencies: 353
-- Name: task_task_master_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.task_task_master_id_seq', 1, false);


--
-- TOC entry 5275 (class 2606 OID 25668)
-- Name: action_link action_link_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.action_link
    ADD CONSTRAINT action_link_pk PRIMARY KEY (id);


--
-- TOC entry 5277 (class 2606 OID 25670)
-- Name: action_link action_link_un; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.action_link
    ADD CONSTRAINT action_link_un UNIQUE (action_id, ext_id, scope);


--
-- TOC entry 5273 (class 2606 OID 25672)
-- Name: action action_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.action
    ADD CONSTRAINT action_pkey PRIMARY KEY (id);


--
-- TOC entry 5279 (class 2606 OID 25674)
-- Name: afcnsend afcnsend_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.afcnsend
    ADD CONSTRAINT afcnsend_pkey PRIMARY KEY (id);


--
-- TOC entry 5281 (class 2606 OID 25676)
-- Name: agelist agelist_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agelist
    ADD CONSTRAINT agelist_pkey PRIMARY KEY (id);


--
-- TOC entry 5283 (class 2606 OID 25678)
-- Name: audit audit_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit
    ADD CONSTRAINT audit_pkey PRIMARY KEY (id);


--
-- TOC entry 5285 (class 2606 OID 25680)
-- Name: audit_record audit_record_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_record
    ADD CONSTRAINT audit_record_pk PRIMARY KEY (id);


--
-- TOC entry 5287 (class 2606 OID 25682)
-- Name: audit_record audit_record_un; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_record
    ADD CONSTRAINT audit_record_un UNIQUE (quaad_point_id, audit_id);


--
-- TOC entry 5289 (class 2606 OID 25684)
-- Name: audit_recordprocedure audit_recordprocedure_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_recordprocedure
    ADD CONSTRAINT audit_recordprocedure_pk PRIMARY KEY (id);


--
-- TOC entry 5291 (class 2606 OID 25686)
-- Name: audit_subrecord audit_subrecord_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_subrecord
    ADD CONSTRAINT audit_subrecord_pk PRIMARY KEY (id);


--
-- TOC entry 5293 (class 2606 OID 25688)
-- Name: audit_type audit_type_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_type
    ADD CONSTRAINT audit_type_pk PRIMARY KEY (id);


--
-- TOC entry 5295 (class 2606 OID 25690)
-- Name: department department_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 5299 (class 2606 OID 25692)
-- Name: device_inspection device_inspection_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.device_inspection
    ADD CONSTRAINT device_inspection_pkey PRIMARY KEY (id);


--
-- TOC entry 5301 (class 2606 OID 25694)
-- Name: device_installation device_installation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.device_installation
    ADD CONSTRAINT device_installation_pkey PRIMARY KEY (id);


--
-- TOC entry 5303 (class 2606 OID 25696)
-- Name: device_maintenance device_maintenance_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.device_maintenance
    ADD CONSTRAINT device_maintenance_pkey PRIMARY KEY (id);


--
-- TOC entry 5297 (class 2606 OID 25698)
-- Name: device device_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.device
    ADD CONSTRAINT device_pkey PRIMARY KEY (id);


--
-- TOC entry 5307 (class 2606 OID 25700)
-- Name: document_link document_link_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.document_link
    ADD CONSTRAINT document_link_pkey PRIMARY KEY (id);


--
-- TOC entry 5309 (class 2606 OID 25702)
-- Name: document_master document_master_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.document_master
    ADD CONSTRAINT document_master_pkey PRIMARY KEY (id);


--
-- TOC entry 5305 (class 2606 OID 25704)
-- Name: document document_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.document
    ADD CONSTRAINT document_pkey PRIMARY KEY (id);


--
-- TOC entry 5311 (class 2606 OID 25706)
-- Name: documentstatus documentstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.documentstatus
    ADD CONSTRAINT documentstatus_pkey PRIMARY KEY (id);


--
-- TOC entry 5383 (class 2606 OID 26827)
-- Name: documenttypelist documenttypelist_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.documenttypelist
    ADD CONSTRAINT documenttypelist_pkey PRIMARY KEY (id);


--
-- TOC entry 5314 (class 2606 OID 25708)
-- Name: examident examident_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.examident
    ADD CONSTRAINT examident_pkey PRIMARY KEY (id);


--
-- TOC entry 5316 (class 2606 OID 25710)
-- Name: examlist examlist_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.examlist
    ADD CONSTRAINT examlist_pkey PRIMARY KEY (id);


--
-- TOC entry 5318 (class 2606 OID 25712)
-- Name: examwarning examwarning_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.examwarning
    ADD CONSTRAINT examwarning_pkey PRIMARY KEY (id);


--
-- TOC entry 5320 (class 2606 OID 25714)
-- Name: external_link external_link_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.external_link
    ADD CONSTRAINT external_link_pk PRIMARY KEY (id);


--
-- TOC entry 5322 (class 2606 OID 25716)
-- Name: external_src external_src_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.external_src
    ADD CONSTRAINT external_src_pk PRIMARY KEY (id);


--
-- TOC entry 5324 (class 2606 OID 25718)
-- Name: institution institution_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.institution
    ADD CONSTRAINT institution_pkey PRIMARY KEY (id);


--
-- TOC entry 5326 (class 2606 OID 25720)
-- Name: legaldocument legaldocument_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.legaldocument
    ADD CONSTRAINT legaldocument_pkey PRIMARY KEY (id);


--
-- TOC entry 5328 (class 2606 OID 25722)
-- Name: link_quaad_tag link_quaad_tag_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.link_quaad_tag
    ADD CONSTRAINT link_quaad_tag_pk PRIMARY KEY (id_quaadpoint, id_tag);


--
-- TOC entry 5330 (class 2606 OID 25724)
-- Name: login_role login_role_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.login_role
    ADD CONSTRAINT login_role_name_key UNIQUE (name);


--
-- TOC entry 5334 (class 2606 OID 25726)
-- Name: login_role_permission login_role_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.login_role_permission
    ADD CONSTRAINT login_role_permission_pkey PRIMARY KEY (id);


--
-- TOC entry 5332 (class 2606 OID 25728)
-- Name: login_role login_role_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.login_role
    ADD CONSTRAINT login_role_pkey PRIMARY KEY (id);


--
-- TOC entry 5336 (class 2606 OID 25730)
-- Name: procedure procedure_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.procedure
    ADD CONSTRAINT procedure_pkey PRIMARY KEY (id);


--
-- TOC entry 5338 (class 2606 OID 25732)
-- Name: quaad_description quaad_description_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaad_description
    ADD CONSTRAINT quaad_description_pk PRIMARY KEY (id);


--
-- TOC entry 5340 (class 2606 OID 25734)
-- Name: quaad_description quaad_description_un; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaad_description
    ADD CONSTRAINT quaad_description_un UNIQUE (id_quaadpoint, language);


--
-- TOC entry 5342 (class 2606 OID 25736)
-- Name: quaad_nameinscope quaad_nameinscope_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaad_nameinscope
    ADD CONSTRAINT quaad_nameinscope_pk PRIMARY KEY (scope_name);


--
-- TOC entry 5344 (class 2606 OID 25738)
-- Name: quaad_point quaad_point_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaad_point
    ADD CONSTRAINT quaad_point_pk PRIMARY KEY (id);


--
-- TOC entry 5346 (class 2606 OID 25740)
-- Name: quaad_point quaad_point_un; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaad_point
    ADD CONSTRAINT quaad_point_un UNIQUE (level1, level2, level3, level4, level5, inlevelorder, quaadversion);


--
-- TOC entry 5350 (class 2606 OID 25742)
-- Name: quaadpoint_tag_name quaadpoint_tag_name_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaadpoint_tag_name
    ADD CONSTRAINT quaadpoint_tag_name_pk PRIMARY KEY (id);


--
-- TOC entry 5352 (class 2606 OID 25744)
-- Name: quaadpoint_tag_name quaadpoint_tag_name_un; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaadpoint_tag_name
    ADD CONSTRAINT quaadpoint_tag_name_un UNIQUE (id_quaadpoint_tag);


--
-- TOC entry 5348 (class 2606 OID 25746)
-- Name: quaadpoint_tag quaadpoint_tag_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaadpoint_tag
    ADD CONSTRAINT quaadpoint_tag_pk PRIMARY KEY (id);


--
-- TOC entry 5354 (class 2606 OID 25748)
-- Name: quaadtag_doc_link quaadtag_doc_link_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaadtag_doc_link
    ADD CONSTRAINT quaadtag_doc_link_pk PRIMARY KEY (id_doclink, id_quaadtag);


--
-- TOC entry 5381 (class 2606 OID 26898)
-- Name: action_status_link read_status_link_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.action_status_link
    ADD CONSTRAINT read_status_link_pk UNIQUE (staff_member_id, document_id, action_id);


--
-- TOC entry 5356 (class 2606 OID 25750)
-- Name: report report_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.report
    ADD CONSTRAINT report_pkey PRIMARY KEY (id);


--
-- TOC entry 5358 (class 2606 OID 25752)
-- Name: sequpdate_state sequpdate_state_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sequpdate_state
    ADD CONSTRAINT sequpdate_state_pkey PRIMARY KEY (updateid);


--
-- TOC entry 5360 (class 2606 OID 25754)
-- Name: sexlist sexlist_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sexlist
    ADD CONSTRAINT sexlist_pkey PRIMARY KEY (id);


--
-- TOC entry 5362 (class 2606 OID 25756)
-- Name: staff_formation staff_formation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_formation
    ADD CONSTRAINT staff_formation_pkey PRIMARY KEY (id);


--
-- TOC entry 5364 (class 2606 OID 25758)
-- Name: staff_job staff_job_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_job
    ADD CONSTRAINT staff_job_pkey PRIMARY KEY (id);


--
-- TOC entry 5366 (class 2606 OID 25760)
-- Name: staff_member staff_member_login_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_member
    ADD CONSTRAINT staff_member_login_key UNIQUE (login);


--
-- TOC entry 5368 (class 2606 OID 25762)
-- Name: staff_member staff_member_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_member
    ADD CONSTRAINT staff_member_pkey PRIMARY KEY (id);


--
-- TOC entry 5370 (class 2606 OID 25764)
-- Name: staff_role staff_role_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_role
    ADD CONSTRAINT staff_role_pkey PRIMARY KEY (id);


--
-- TOC entry 5372 (class 2606 OID 25766)
-- Name: statuslist statuslist_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.statuslist
    ADD CONSTRAINT statuslist_pkey PRIMARY KEY (id);


--
-- TOC entry 5376 (class 2606 OID 25768)
-- Name: tag_link tag_link_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tag_link
    ADD CONSTRAINT tag_link_pkey PRIMARY KEY (id);


--
-- TOC entry 5374 (class 2606 OID 25770)
-- Name: tag tag_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tag
    ADD CONSTRAINT tag_pkey PRIMARY KEY (id);


--
-- TOC entry 5387 (class 2606 OID 29889)
-- Name: task_master task_master_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.task_master
    ADD CONSTRAINT task_master_pk PRIMARY KEY (id);


--
-- TOC entry 5385 (class 2606 OID 29866)
-- Name: task task_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.task
    ADD CONSTRAINT task_pk PRIMARY KEY (id);


--
-- TOC entry 5378 (class 2606 OID 25772)
-- Name: xusercfgparameter xusercfgparameter_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.xusercfgparameter
    ADD CONSTRAINT xusercfgparameter_pk PRIMARY KEY (cfgparameter_id);


--
-- TOC entry 5312 (class 1259 OID 25773)
-- Name: laststatus_per_document_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX laststatus_per_document_index ON public.documentstatus USING btree (doc_id, begdate DESC);


--
-- TOC entry 5379 (class 1259 OID 25774)
-- Name: xusercfgparameteridx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX xusercfgparameteridx ON public.xusercfgparameter USING btree (variable);


--
-- TOC entry 5608 (class 2618 OID 25555)
-- Name: v_exam_risk_tag_doc _RETURN; Type: RULE; Schema: public; Owner: postgres
--

CREATE OR REPLACE VIEW public.v_exam_risk_tag_doc AS
 SELECT allexam.id,
    allexam.modality,
    allexam.nameid AS name,
    allexam.description,
    allexam.riskv AS risklist,
    allexam.taglist,
    allexamwithdoc.doc_id,
    allexamwithotherdoc.doc_otherdoc_id
   FROM ((( SELECT examlist.id,
            examlist.modality,
            examlist.nameid,
            examlist.description,
            string_agg((examwarning_link.examwarning_id)::text, ','::text) AS riskv,
            public.f_tag_link(examlist.id) AS taglist
           FROM (public.examlist
             LEFT JOIN public.examwarning_link ON ((examwarning_link.exam_id = examlist.id)))
          WHERE ((examlist.removed = false) AND ((examwarning_link.examwarning_id IS NULL) OR (examwarning_link.examwarning_id IS NOT NULL)))
          GROUP BY examlist.id, examlist.nameid, examlist.description) allexam
     LEFT JOIN ( SELECT document_link.doc_id,
            document_link.ext_id
           FROM public.v_last_documentstatus,
            public.document_link
          WHERE ((v_last_documentstatus.status_id = 1) AND (v_last_documentstatus.doc_id = document_link.doc_id) AND ((document_link.type)::text = 'examlist'::text))) allexamwithdoc ON ((allexamwithdoc.ext_id = allexam.id)))
     LEFT JOIN ( SELECT document_link.doc_id AS doc_otherdoc_id,
            document_link.ext_id
           FROM public.v_last_documentstatus,
            public.document_link
          WHERE ((v_last_documentstatus.status_id = 1) AND (v_last_documentstatus.doc_id = document_link.doc_id) AND ((document_link.type)::text = 'examlist_otherdocument'::text))) allexamwithotherdoc ON ((allexamwithotherdoc.ext_id = allexam.id)))
  ORDER BY allexam.id, allexamwithdoc.doc_id;


--
-- TOC entry 5445 (class 2620 OID 25776)
-- Name: department calltrg_init_init_tag_department; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER calltrg_init_init_tag_department AFTER INSERT ON public.department FOR EACH ROW EXECUTE FUNCTION public.trg_init_tag_department();


--
-- TOC entry 5446 (class 2620 OID 25777)
-- Name: department calltrg_init_init_tag_department_update; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER calltrg_init_init_tag_department_update AFTER UPDATE ON public.department FOR EACH ROW EXECUTE FUNCTION public.trg_init_tag_department_update();


--
-- TOC entry 5447 (class 2620 OID 25778)
-- Name: institution calltrg_init_init_tag_institution; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER calltrg_init_init_tag_institution AFTER INSERT ON public.institution FOR EACH ROW EXECUTE FUNCTION public.trg_init_tag_institution();


--
-- TOC entry 5448 (class 2620 OID 25779)
-- Name: institution calltrg_init_init_tag_institution_update; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER calltrg_init_init_tag_institution_update AFTER UPDATE ON public.institution FOR EACH ROW EXECUTE FUNCTION public.trg_init_tag_institution_update();


--
-- TOC entry 5449 (class 2620 OID 25780)
-- Name: login_role calltrg_init_login_role_permission; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER calltrg_init_login_role_permission AFTER INSERT ON public.login_role FOR EACH ROW EXECUTE FUNCTION public.trg_init_login_role_permission();


--
-- TOC entry 5450 (class 2620 OID 25781)
-- Name: staff_formation f_staffmember_equals_staff; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER f_staffmember_equals_staff BEFORE INSERT OR UPDATE ON public.staff_formation FOR EACH ROW EXECUTE FUNCTION public.f_staffmember_equals_staff();


--
-- TOC entry 5390 (class 2606 OID 25782)
-- Name: action_link action_link_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.action_link
    ADD CONSTRAINT action_link_fk FOREIGN KEY (action_id) REFERENCES public.action(id);


--
-- TOC entry 5388 (class 2606 OID 25787)
-- Name: action action_personincharge_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.action
    ADD CONSTRAINT action_personincharge_fkey FOREIGN KEY (personincharge) REFERENCES public.staff_member(id);


--
-- TOC entry 5389 (class 2606 OID 25792)
-- Name: action action_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.action
    ADD CONSTRAINT action_status_id_fkey FOREIGN KEY (status_id) REFERENCES public.statuslist(id);


--
-- TOC entry 5391 (class 2606 OID 25797)
-- Name: afcnsend afcnsend_dep_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.afcnsend
    ADD CONSTRAINT afcnsend_dep_id_fkey FOREIGN KEY (dep_id) REFERENCES public.department(id);


--
-- TOC entry 5392 (class 2606 OID 25802)
-- Name: afcnsend afcnsend_device_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.afcnsend
    ADD CONSTRAINT afcnsend_device_id_fkey FOREIGN KEY (device_id) REFERENCES public.device(id);


--
-- TOC entry 5393 (class 2606 OID 25807)
-- Name: afcnsend afcnsend_inst_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.afcnsend
    ADD CONSTRAINT afcnsend_inst_id_fkey FOREIGN KEY (inst_id) REFERENCES public.institution(id);


--
-- TOC entry 5394 (class 2606 OID 25812)
-- Name: afcnsend afcnsend_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.afcnsend
    ADD CONSTRAINT afcnsend_sender_fkey FOREIGN KEY (sender) REFERENCES public.staff_member(id);


--
-- TOC entry 5395 (class 2606 OID 25817)
-- Name: audit audit_dep_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit
    ADD CONSTRAINT audit_dep_id_fkey FOREIGN KEY (dep_id) REFERENCES public.department(id);


--
-- TOC entry 5396 (class 2606 OID 25822)
-- Name: audit audit_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit
    ADD CONSTRAINT audit_fk FOREIGN KEY (type) REFERENCES public.audit_type(id);


--
-- TOC entry 5397 (class 2606 OID 25827)
-- Name: audit audit_inst_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit
    ADD CONSTRAINT audit_inst_id_fkey FOREIGN KEY (inst_id) REFERENCES public.institution(id);


--
-- TOC entry 5398 (class 2606 OID 25832)
-- Name: audit audit_personincharge_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit
    ADD CONSTRAINT audit_personincharge_fkey FOREIGN KEY (personincharge) REFERENCES public.staff_member(id);


--
-- TOC entry 5400 (class 2606 OID 25837)
-- Name: audit_record audit_record_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_record
    ADD CONSTRAINT audit_record_fk FOREIGN KEY (audit_id) REFERENCES public.audit(id);


--
-- TOC entry 5401 (class 2606 OID 25842)
-- Name: audit_record audit_record_fk_1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_record
    ADD CONSTRAINT audit_record_fk_1 FOREIGN KEY (quaad_point_id) REFERENCES public.quaad_point(id);


--
-- TOC entry 5402 (class 2606 OID 25847)
-- Name: audit_recordprocedure audit_recordprocedure_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_recordprocedure
    ADD CONSTRAINT audit_recordprocedure_fk FOREIGN KEY (audit_record_id) REFERENCES public.audit_record(id);


--
-- TOC entry 5403 (class 2606 OID 25852)
-- Name: audit_recordprocedure audit_recordprocedure_fk_1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_recordprocedure
    ADD CONSTRAINT audit_recordprocedure_fk_1 FOREIGN KEY (procedure_id) REFERENCES public.procedure(id);


--
-- TOC entry 5404 (class 2606 OID 25857)
-- Name: audit_recordprocedure audit_recordprocedure_fk_2; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_recordprocedure
    ADD CONSTRAINT audit_recordprocedure_fk_2 FOREIGN KEY (doc_id) REFERENCES public.document(id);


--
-- TOC entry 5399 (class 2606 OID 25862)
-- Name: audit audit_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit
    ADD CONSTRAINT audit_status_id_fkey FOREIGN KEY (status_id) REFERENCES public.statuslist(id);


--
-- TOC entry 5405 (class 2606 OID 25867)
-- Name: audit_subrecord audit_subrecord_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_subrecord
    ADD CONSTRAINT audit_subrecord_fk FOREIGN KEY (audit_record_id) REFERENCES public.audit_record(id);


--
-- TOC entry 5406 (class 2606 OID 25872)
-- Name: audit_subrecord audit_subrecord_fk_1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_subrecord
    ADD CONSTRAINT audit_subrecord_fk_1 FOREIGN KEY (quaadpoint_tag_id) REFERENCES public.quaadpoint_tag(id);


--
-- TOC entry 5441 (class 2606 OID 26160)
-- Name: default_action_needed default_read_needed_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.default_action_needed
    ADD CONSTRAINT default_read_needed_fk FOREIGN KEY (department_id) REFERENCES public.department(id);


--
-- TOC entry 5442 (class 2606 OID 26165)
-- Name: default_action_needed default_read_needed_fk_1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.default_action_needed
    ADD CONSTRAINT default_read_needed_fk_1 FOREIGN KEY (staff_role_id) REFERENCES public.staff_role(id);


--
-- TOC entry 5407 (class 2606 OID 25877)
-- Name: department department_inst_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.department
    ADD CONSTRAINT department_inst_id_fkey FOREIGN KEY (inst_id) REFERENCES public.institution(id);


--
-- TOC entry 5408 (class 2606 OID 25882)
-- Name: device_inspection device_inspection_device_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.device_inspection
    ADD CONSTRAINT device_inspection_device_id_fkey FOREIGN KEY (device_id) REFERENCES public.device(id);


--
-- TOC entry 5409 (class 2606 OID 25887)
-- Name: device_inspection device_inspection_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.device_inspection
    ADD CONSTRAINT device_inspection_status_id_fkey FOREIGN KEY (status_id) REFERENCES public.statuslist(id);


--
-- TOC entry 5410 (class 2606 OID 25892)
-- Name: device_installation device_installation_dep_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.device_installation
    ADD CONSTRAINT device_installation_dep_id_fkey FOREIGN KEY (dep_id) REFERENCES public.department(id);


--
-- TOC entry 5411 (class 2606 OID 25897)
-- Name: device_installation device_installation_device_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.device_installation
    ADD CONSTRAINT device_installation_device_id_fkey FOREIGN KEY (device_id) REFERENCES public.device(id);


--
-- TOC entry 5412 (class 2606 OID 25902)
-- Name: device_maintenance device_maintenance_device_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.device_maintenance
    ADD CONSTRAINT device_maintenance_device_id_fkey FOREIGN KEY (device_id) REFERENCES public.device(id);


--
-- TOC entry 5413 (class 2606 OID 25907)
-- Name: device_maintenance device_maintenance_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.device_maintenance
    ADD CONSTRAINT device_maintenance_status_id_fkey FOREIGN KEY (status_id) REFERENCES public.statuslist(id);


--
-- TOC entry 5414 (class 2606 OID 25912)
-- Name: document document_doc_master_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.document
    ADD CONSTRAINT document_doc_master_id_fkey FOREIGN KEY (doc_master_id) REFERENCES public.document_master(id);


--
-- TOC entry 5416 (class 2606 OID 25917)
-- Name: document_link document_link_doc_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.document_link
    ADD CONSTRAINT document_link_doc_id_fkey FOREIGN KEY (doc_id) REFERENCES public.document(id);


--
-- TOC entry 5415 (class 2606 OID 25922)
-- Name: document document_uploadedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.document
    ADD CONSTRAINT document_uploadedby_fkey FOREIGN KEY (uploadedby) REFERENCES public.staff_member(id);


--
-- TOC entry 5417 (class 2606 OID 25927)
-- Name: documentstatus documentstatus_doc_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.documentstatus
    ADD CONSTRAINT documentstatus_doc_id_fkey FOREIGN KEY (doc_id) REFERENCES public.document(id);


--
-- TOC entry 5418 (class 2606 OID 25932)
-- Name: documentstatus documentstatus_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.documentstatus
    ADD CONSTRAINT documentstatus_status_id_fkey FOREIGN KEY (status_id) REFERENCES public.statuslist(id);


--
-- TOC entry 5419 (class 2606 OID 25937)
-- Name: examwarning_link examwarning_link_exam_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.examwarning_link
    ADD CONSTRAINT examwarning_link_exam_id_fkey FOREIGN KEY (exam_id) REFERENCES public.examlist(id);


--
-- TOC entry 5420 (class 2606 OID 25942)
-- Name: examwarning_link examwarning_link_examwarning_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.examwarning_link
    ADD CONSTRAINT examwarning_link_examwarning_id_fkey FOREIGN KEY (examwarning_id) REFERENCES public.examwarning(id);


--
-- TOC entry 5421 (class 2606 OID 25947)
-- Name: external_link external_link_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.external_link
    ADD CONSTRAINT external_link_fk FOREIGN KEY (ext_src) REFERENCES public.external_src(id);


--
-- TOC entry 5422 (class 2606 OID 25952)
-- Name: link_quaad_tag link_quaad_tag_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.link_quaad_tag
    ADD CONSTRAINT link_quaad_tag_fk FOREIGN KEY (id_tag) REFERENCES public.quaadpoint_tag(id);


--
-- TOC entry 5423 (class 2606 OID 25957)
-- Name: link_quaad_tag link_quaad_tag_fk_1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.link_quaad_tag
    ADD CONSTRAINT link_quaad_tag_fk_1 FOREIGN KEY (id_quaadpoint) REFERENCES public.quaad_point(id);


--
-- TOC entry 5424 (class 2606 OID 25962)
-- Name: login_role_permission login_role_permission_login_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.login_role_permission
    ADD CONSTRAINT login_role_permission_login_role_id_fkey FOREIGN KEY (login_role_id) REFERENCES public.login_role(id);


--
-- TOC entry 5425 (class 2606 OID 25967)
-- Name: quaad_description quaad_description_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaad_description
    ADD CONSTRAINT quaad_description_fk FOREIGN KEY (id_quaadpoint) REFERENCES public.quaad_point(id);


--
-- TOC entry 5426 (class 2606 OID 25972)
-- Name: quaad_point quaad_point_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaad_point
    ADD CONSTRAINT quaad_point_fk FOREIGN KEY (quaadversion) REFERENCES public.audit_type(id);


--
-- TOC entry 5427 (class 2606 OID 25977)
-- Name: quaadpoint_tag_name quaadpoint_tag_name_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaadpoint_tag_name
    ADD CONSTRAINT quaadpoint_tag_name_fk FOREIGN KEY (id_quaadpoint_tag) REFERENCES public.quaadpoint_tag(id);


--
-- TOC entry 5428 (class 2606 OID 25982)
-- Name: quaadtag_doc_link quaadtag_doc_link_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaadtag_doc_link
    ADD CONSTRAINT quaadtag_doc_link_fk FOREIGN KEY (id_doclink) REFERENCES public.document_link(id);


--
-- TOC entry 5429 (class 2606 OID 25987)
-- Name: quaadtag_doc_link quaadtag_doc_link_fk_1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.quaadtag_doc_link
    ADD CONSTRAINT quaadtag_doc_link_fk_1 FOREIGN KEY (id_quaadtag) REFERENCES public.quaadpoint_tag(id);


--
-- TOC entry 5443 (class 2606 OID 26175)
-- Name: action_status_link read_status_link_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.action_status_link
    ADD CONSTRAINT read_status_link_fk FOREIGN KEY (staff_member_id) REFERENCES public.staff_member(id);


--
-- TOC entry 5444 (class 2606 OID 26180)
-- Name: action_status_link read_status_link_fk_1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.action_status_link
    ADD CONSTRAINT read_status_link_fk_1 FOREIGN KEY (document_id) REFERENCES public.document(id);


--
-- TOC entry 5430 (class 2606 OID 25992)
-- Name: report report_dep_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.report
    ADD CONSTRAINT report_dep_id_fkey FOREIGN KEY (dep_id) REFERENCES public.department(id);


--
-- TOC entry 5431 (class 2606 OID 25997)
-- Name: report report_reporter_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.report
    ADD CONSTRAINT report_reporter_fkey FOREIGN KEY (reporter) REFERENCES public.staff_member(id);


--
-- TOC entry 5432 (class 2606 OID 26002)
-- Name: report report_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.report
    ADD CONSTRAINT report_status_id_fkey FOREIGN KEY (status_id) REFERENCES public.statuslist(id);


--
-- TOC entry 5433 (class 2606 OID 26007)
-- Name: staff_formation staff_formation_staff_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_formation
    ADD CONSTRAINT staff_formation_staff_id_fkey FOREIGN KEY (staff_id) REFERENCES public.staff_member(id);


--
-- TOC entry 5434 (class 2606 OID 26012)
-- Name: staff_formation staff_formation_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_formation
    ADD CONSTRAINT staff_formation_status_id_fkey FOREIGN KEY (status_id) REFERENCES public.statuslist(id);


--
-- TOC entry 5435 (class 2606 OID 26017)
-- Name: staff_job staff_job_dep_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_job
    ADD CONSTRAINT staff_job_dep_id_fkey FOREIGN KEY (dep_id) REFERENCES public.department(id);


--
-- TOC entry 5436 (class 2606 OID 26022)
-- Name: staff_job staff_job_staff_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_job
    ADD CONSTRAINT staff_job_staff_id_fkey FOREIGN KEY (staff_id) REFERENCES public.staff_member(id);


--
-- TOC entry 5437 (class 2606 OID 26027)
-- Name: staff_job staff_job_staff_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_job
    ADD CONSTRAINT staff_job_staff_role_id_fkey FOREIGN KEY (staff_role_id) REFERENCES public.staff_role(id);


--
-- TOC entry 5438 (class 2606 OID 26032)
-- Name: staff_member staff_member_login_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.staff_member
    ADD CONSTRAINT staff_member_login_role_id_fkey FOREIGN KEY (login_role_id) REFERENCES public.login_role(id);


--
-- TOC entry 5440 (class 2606 OID 26037)
-- Name: xusercfg staff_member_xusercfg_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.xusercfg
    ADD CONSTRAINT staff_member_xusercfg_fk FOREIGN KEY (id) REFERENCES public.staff_member(id);


--
-- TOC entry 5439 (class 2606 OID 26042)
-- Name: tag_link tag_link_tag_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tag_link
    ADD CONSTRAINT tag_link_tag_id_fkey FOREIGN KEY (tag_id) REFERENCES public.tag(id);


-- Completed on 2025-08-28 14:26:58

--
--

