· 9 years ago · Dec 15, 2016, 06:56 AM
1DROP TRIGGER IF EXISTS case_closing_trigger on mc_step;
2DROP FUNCTION IF EXISTS update_medcase_close_info();
3
4
5
6CREATE TRIGGER "mc_step_adm_date" BEFORE INSERT OR UPDATE ON "public"."mc_step"
7FOR EACH ROW
8EXECUTE PROCEDURE "f_mc_step_adm_date"();
9
10
11CREATE OR REPLACE FUNCTION "public"."f_mc_step_adm_date"()
12 RETURNS "pg_catalog"."trigger" AS $BODY$
13BEGIN
14 if NEW.admission_date is null then
15 NEW.admission_date := current_date;
16 end if;
17 return new;
18END
19$BODY$
20 LANGUAGE 'plpgsql' VOLATILE COST 100
21;
22
23ALTER FUNCTION "public"."f_mc_step_adm_date"() OWNER TO "app_group_master";
24
25
26
27Саров
28 Line 112: CREATE TRIGGER "audit_trigger" BEFORE INSERT OR UPDATE ON "public"."mc_step"
29 Line 116: CREATE TRIGGER "case_closing_tg" AFTER INSERT OR UPDATE OF "result_id", "outcome_date", "case_id" ON "public"."mc_step"
30 Line 120: CREATE TRIGGER "case_closing_trigger" AFTER INSERT OR UPDATE OF "result_id", "outcome_date" ON "public"."mc_step"
31 Line 124: CREATE TRIGGER "mc_step_before_case_update_trg" BEFORE UPDATE OF "case_id" ON "public"."mc_step"
32 Line 129: CREATE TRIGGER "mc_step_before_insert_trg" BEFORE INSERT ON "public"."mc_step"
33 Line 133: CREATE TRIGGER "mc_step_case_s_s" AFTER INSERT OR UPDATE OR DELETE ON "public"."mc_step"
34 Line 137: CREATE TRIGGER "mc_step_sync_ariud" AFTER INSERT OR UPDATE OR DELETE ON "public"."mc_step"
35 Line 141: CREATE CONSTRAINT TRIGGER "trigger_on_delete_case_step" AFTER DELETE ON "public"."mc_step"
36 Line 145: CREATE CONSTRAINT TRIGGER "trigger_update_case_step_admission_date_time" AFTER INSERT OR UPDATE OF "admission_date", "admission_time" OR DELETE ON "public"."mc_step"
37
38
39dev
40 Line 174: CREATE TRIGGER "audit_trigger" BEFORE INSERT OR UPDATE ON "public"."mc_step"
41 Line 178: CREATE TRIGGER "case_closing_tg" AFTER INSERT OR UPDATE OF "result_id", "outcome_date", "case_id" ON "public"."mc_step"
42 Line 182: CREATE TRIGGER "mc_step_adm_date" BEFORE INSERT OR UPDATE ON "public"."mc_step"
43 Line 186: CREATE TRIGGER "mc_step_before_case_update_trg" BEFORE UPDATE OF "case_id" ON "public"."mc_step"
44 Line 191: CREATE TRIGGER "mc_step_before_insert_trg" BEFORE INSERT ON "public"."mc_step"
45 Line 195: CREATE TRIGGER "mc_step_case_s_s" AFTER INSERT OR UPDATE OR DELETE ON "public"."mc_step"
46 Line 199: CREATE TRIGGER "mc_step_sync_ariud" AFTER INSERT OR UPDATE OR DELETE ON "public"."mc_step"
47 Line 203: CREATE CONSTRAINT TRIGGER "trigger_on_delete_case_step" AFTER DELETE ON "public"."mc_step"
48 Line 207: CREATE CONSTRAINT TRIGGER "trigger_update_case_step_admission_date_time" AFTER INSERT OR UPDATE OF "admission_date", "admission_time" OR DELETE ON "public"."mc_step"
49
50
51
52
53--на Сарове
54
55
56CREATE TABLE "public"."mc_step" (
57"id" int4 NOT NULL,
58"admission_date" date NOT NULL,
59"admission_time" time(6),
60"death_date" date,
61"death_time" time(6),
62"outcome_date" date,
63"outcome_time" time(6),
64"death_employee_id" int4,
65"main_diagnosis_id" int4,
66"case_id" int4 NOT NULL,
67"outcome_id" int4,
68"outcome_clinic_id" int4,
69"outcome_regimen_id" int4,
70"regimen_id" int4,
71"res_group_id" int4,
72"result_id" int4,
73"reason_id" int4,
74"profile_id" int4,
75"mes_id" int4,
76"mes_quality_criterion_id" int4,
77"is_continue" bool,
78"is_continue_editable" bool,
79"standard_id" int4,
80"csg_id" int4,
81"vmp_type_id" int4,
82"vmp_method_id" int4,
83"deviation_reason_id" int4,
84"aud_who" varchar COLLATE "default",
85"aud_when" timestamp(6),
86"aud_source" varchar COLLATE "default",
87"aud_who_create" varchar COLLATE "default",
88"aud_when_create" timestamp(6),
89"aud_source_create" varchar COLLATE "default",
90"_clinic_id" int4,
91"_patient_id" int4,
92CONSTRAINT "mc_step_pk" PRIMARY KEY ("id"),
93CONSTRAINT "fk_mc_step_to_pim_empl_pos" FOREIGN KEY ("death_employee_id") REFERENCES "public"."pim_employee_position" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
94CONSTRAINT "mc_step_md_mes_fk" FOREIGN KEY ("mes_id") REFERENCES "public"."md_mes" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
95CONSTRAINT "mc_step_to_profile_ref" FOREIGN KEY ("profile_id") REFERENCES "public"."md_profile" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
96CONSTRAINT "fk3467bfd5af761f53" FOREIGN KEY ("outcome_regimen_id") REFERENCES "public"."mc_care_regimen" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
97CONSTRAINT "fk3467bfd5c2cb7a71" FOREIGN KEY ("result_id") REFERENCES "public"."mc_step_result" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
98CONSTRAINT "fk3467bfd5d71f460d" FOREIGN KEY ("outcome_id") REFERENCES "public"."mc_step_care_result" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
99CONSTRAINT "fk3467bfd5d9b73846" FOREIGN KEY ("regimen_id") REFERENCES "public"."mc_care_regimen" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
100CONSTRAINT "fk_mc_step_to_csg_id" FOREIGN KEY ("csg_id") REFERENCES "public"."md_clinical_statistical_group" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
101CONSTRAINT "fk_mc_step_to_md_clinic" FOREIGN KEY ("outcome_clinic_id") REFERENCES "public"."md_clinic" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
102CONSTRAINT "fk_mc_step_to_sr_res_group" FOREIGN KEY ("res_group_id") REFERENCES "public"."sr_res_group" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
103CONSTRAINT "mc_diagnosis_fk" FOREIGN KEY ("main_diagnosis_id") REFERENCES "public"."mc_diagnosis" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
104CONSTRAINT "mc_step_case_fk" FOREIGN KEY ("case_id") REFERENCES "public"."mc_case" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
105CONSTRAINT "mc_step_deviation_reason_id_fk" FOREIGN KEY ("deviation_reason_id") REFERENCES "public"."mc_deviation_reason" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
106CONSTRAINT "mc_step_mes_quality_criterion_fk" FOREIGN KEY ("mes_quality_criterion_id") REFERENCES "public"."mc_mes_quality_criterion" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
107CONSTRAINT "mc_step_to_standard_id_fk" FOREIGN KEY ("standard_id") REFERENCES "public"."md_standard" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
108CONSTRAINT "mc_step_vmp_method_id_fk" FOREIGN KEY ("vmp_method_id") REFERENCES "public"."mc_vmp_method" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
109CONSTRAINT "mc_step_vmp_type_id_fk" FOREIGN KEY ("vmp_type_id") REFERENCES "public"."mc_vmp_type" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
110CONSTRAINT "fk3467bfd52477624e" FOREIGN KEY ("reason_id") REFERENCES "public"."mc_step_result_reason" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
111)
112WITH (OIDS=FALSE)
113;
114
115ALTER TABLE "public"."mc_step" OWNER TO "app_group_master";
116
117COMMENT ON COLUMN "public"."mc_step"."_clinic_id" IS 'System field, filled by trigger from mc_case.clinic_id';
118
119COMMENT ON COLUMN "public"."mc_step"."_patient_id" IS 'System field, filled by trigger from mc_case.patient_id';
120
121
122
123CREATE INDEX "fk_mc_step_to_pim_empl_pos" ON "public"."mc_step" USING btree ("death_employee_id");
124
125CREATE INDEX "idx_mc_step" ON "public"."mc_step" USING btree ("case_id");
126
127CREATE INDEX "idx_mc_step_0" ON "public"."mc_step" USING btree ("res_group_id");
128
129CREATE INDEX "idx_mc_step_1" ON "public"."mc_step" USING btree ("outcome_clinic_id");
130
131CREATE INDEX "idx_mc_step_2" ON "public"."mc_step" USING btree ("result_id");
132
133CREATE INDEX "idx_mc_step_3" ON "public"."mc_step" USING btree ("outcome_id");
134
135CREATE INDEX "idx_mc_step_4" ON "public"."mc_step" USING btree ("reason_id");
136
137CREATE INDEX "idx_mc_step_5" ON "public"."mc_step" USING btree ("outcome_regimen_id");
138
139CREATE INDEX "idx_mc_step_7" ON "public"."mc_step" USING btree ("regimen_id");
140
141CREATE INDEX "mc_step_admission_date_admission_time_id_idx" ON "public"."mc_step" USING btree ("admission_date", "admission_time", "id");
142
143CREATE INDEX "mc_step_admission_date_outcome_date_idx" ON "public"."mc_step" USING btree ("admission_date", "outcome_date");
144
145CREATE INDEX "mc_step_admission_date_outcome_date_time_idx" ON "public"."mc_step" USING btree ("(admission_date + COALESCE(admission_time, '00:00:00'::time without time zone))", "(outcome_date + COALESCE(outcome_time, '00:00:00'::time without time zone))");
146
147CREATE INDEX "mc_step_clinic_id_ix" ON "public"."mc_step" USING btree ("_clinic_id");
148
149CREATE INDEX "mc_step_date_time_indi_clinic_id_idx" ON "public"."mc_step" USING btree ("admission_date" DESC, "admission_time" DESC, "get_individual_surname_for_case(case_id)", "get_individual_name_for_case(case_id)", "get_individual_patr_name_for_case(case_id)", "id" DESC, "_clinic_id", "admission_date" DESC, "admission_time" DESC, "get_individual_surname_for_case(case_id)", "get_individual_name_for_case(case_id)", "get_individual_patr_name_for_case(case_id)", "id" DESC, "_clinic_id", "admission_date" DESC, "admission_time" DESC, "get_individual_surname_for_case(case_id)", "get_individual_name_for_case(case_id)", "get_individual_patr_name_for_case(case_id)", "id" DESC, "_clinic_id");
150
151CREATE INDEX "mc_step_main_diagnosis_id_idx" ON "public"."mc_step" USING btree ("main_diagnosis_id");
152
153CREATE INDEX "mc_step_md_mes_fk" ON "public"."mc_step" USING btree ("mes_id");
154
155CREATE INDEX "mc_step_mes_quality_criterion_id_idx" ON "public"."mc_step" USING btree ("mes_quality_criterion_id");
156
157CREATE INDEX "mc_step_outcome_date_idx" ON "public"."mc_step" USING btree ("outcome_date");
158
159CREATE INDEX "mc_step_patient_id_ix" ON "public"."mc_step" USING btree ("_patient_id");
160
161CREATE INDEX "mc_step_standard_id_idx" ON "public"."mc_step" USING btree ("standard_id");
162
163CREATE INDEX "mc_step_to_profile_ref" ON "public"."mc_step" USING btree ("profile_id");
164
165
166
167CREATE TRIGGER "audit_trigger" BEFORE INSERT OR UPDATE ON "public"."mc_step"
168FOR EACH ROW
169EXECUTE PROCEDURE "audit_trigger_fun"();
170
171CREATE TRIGGER "case_closing_tg" AFTER INSERT OR UPDATE OF "result_id", "outcome_date", "case_id" ON "public"."mc_step"
172FOR EACH ROW
173EXECUTE PROCEDURE "case_closing_tf"();
174
175CREATE TRIGGER "case_closing_trigger" AFTER INSERT OR UPDATE OF "result_id", "outcome_date" ON "public"."mc_step"
176FOR EACH ROW
177EXECUTE PROCEDURE "update_medcase_close_info"();
178
179CREATE TRIGGER "mc_step_before_case_update_trg" BEFORE UPDATE OF "case_id" ON "public"."mc_step"
180FOR EACH ROW
181WHEN (old.case_id IS DISTINCT FROM new.case_id)
182EXECUTE PROCEDURE "mc_step_trigger_update_trgf"();
183
184CREATE TRIGGER "mc_step_before_insert_trg" BEFORE INSERT ON "public"."mc_step"
185FOR EACH ROW
186EXECUTE PROCEDURE "mc_step_trigger_update_trgf"();
187
188CREATE TRIGGER "mc_step_case_s_s" AFTER INSERT OR UPDATE OR DELETE ON "public"."mc_step"
189FOR EACH ROW
190EXECUTE PROCEDURE "mc_step_case_s_s"();
191
192CREATE TRIGGER "mc_step_sync_ariud" AFTER INSERT OR UPDATE OR DELETE ON "public"."mc_step"
193FOR EACH ROW
194EXECUTE PROCEDURE "sync_data_f"();
195
196CREATE CONSTRAINT TRIGGER "trigger_on_delete_case_step" AFTER DELETE ON "public"."mc_step"
197DEFERRABLE INITIALLY DEFERRED FOR EACH ROW
198EXECUTE PROCEDURE "delete_res_group_on_delete_case_step"();
199
200CREATE CONSTRAINT TRIGGER "trigger_update_case_step_admission_date_time" AFTER INSERT OR UPDATE OF "admission_date", "admission_time" OR DELETE ON "public"."mc_step"
201DEFERRABLE INITIALLY DEFERRED FOR EACH ROW
202EXECUTE PROCEDURE "update_medcase_open_date_time"();
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218на dev
219CREATE TABLE "public"."mc_step" (
220"id" int4 NOT NULL,
221"admission_date" date NOT NULL,
222"admission_time" time(6),
223"death_date" date,
224"death_time" time(6),
225"outcome_date" date,
226"outcome_time" time(6),
227"death_employee_id" int4,
228"main_diagnosis_id" int4,
229"case_id" int4 NOT NULL,
230"outcome_id" int4,
231"outcome_clinic_id" int4,
232"outcome_regimen_id" int4,
233"regimen_id" int4,
234"res_group_id" int4,
235"result_id" int4,
236"reason_id" int4,
237"profile_id" int4,
238"mes_id" int4,
239"mes_quality_criterion_id" int4,
240"is_continue" bool,
241"is_continue_editable" bool,
242"standard_id" int4,
243"csg_id" int4,
244"vmp_type_id" int4,
245"vmp_method_id" int4,
246"deviation_reason_id" int4,
247"aud_who" varchar COLLATE "default",
248"aud_when" timestamp(6),
249"aud_source" varchar COLLATE "default",
250"aud_who_create" varchar COLLATE "default",
251"aud_when_create" timestamp(6),
252"aud_source_create" varchar COLLATE "default",
253"_clinic_id" int4,
254"_patient_id" int4,
255CONSTRAINT "mc_step_pkey" PRIMARY KEY ("id"),
256CONSTRAINT "mc_step_md_mes_fk" FOREIGN KEY ("mes_id") REFERENCES "public"."md_mes" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
257CONSTRAINT "mc_step_mes_quality_criterion_fk" FOREIGN KEY ("mes_quality_criterion_id") REFERENCES "public"."mc_mes_quality_criterion" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
258CONSTRAINT "mc_step_to_profile_ref" FOREIGN KEY ("profile_id") REFERENCES "public"."md_profile" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
259CONSTRAINT "mc_step_vmp_type_id_fk" FOREIGN KEY ("vmp_type_id") REFERENCES "public"."mc_vmp_type" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
260CONSTRAINT "mc_step_vmp_method_id_fk" FOREIGN KEY ("vmp_method_id") REFERENCES "public"."mc_vmp_method" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
261CONSTRAINT "mc_step_to_standard_id_fk" FOREIGN KEY ("standard_id") REFERENCES "public"."md_standard" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
262CONSTRAINT "mc_step_deviation_reason_id_fk" FOREIGN KEY ("deviation_reason_id") REFERENCES "public"."mc_deviation_reason" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
263CONSTRAINT "fk3467bfd5a95d09a0" FOREIGN KEY ("_patient_id") REFERENCES "public"."pci_patient" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
264CONSTRAINT "mc_diagnosis_fk" FOREIGN KEY ("main_diagnosis_id") REFERENCES "public"."mc_diagnosis" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
265CONSTRAINT "fk_mc_step_to_sr_res_group" FOREIGN KEY ("res_group_id") REFERENCES "public"."sr_res_group" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
266CONSTRAINT "fk_mc_step_to_csg_id" FOREIGN KEY ("csg_id") REFERENCES "public"."md_clinical_statistical_group" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
267CONSTRAINT "fk3467bfd5d9b73846" FOREIGN KEY ("regimen_id") REFERENCES "public"."mc_care_regimen" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
268CONSTRAINT "fk3467bfd5d71f460d" FOREIGN KEY ("outcome_id") REFERENCES "public"."mc_step_care_result" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
269CONSTRAINT "fk3467bfd5c2cb7a71" FOREIGN KEY ("result_id") REFERENCES "public"."mc_step_result" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
270CONSTRAINT "fk3467bfd5af761f53" FOREIGN KEY ("outcome_regimen_id") REFERENCES "public"."mc_care_regimen" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
271CONSTRAINT "fk3467bfd52477624e" FOREIGN KEY ("reason_id") REFERENCES "public"."mc_step_result_reason" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
272CONSTRAINT "mc_step_case_fk" FOREIGN KEY ("case_id") REFERENCES "public"."mc_case" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
273CONSTRAINT "fk3467bfd5a88e329e" FOREIGN KEY ("_clinic_id") REFERENCES "public"."md_clinic" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
274CONSTRAINT "fk_mc_step_to_md_clinic" FOREIGN KEY ("outcome_clinic_id") REFERENCES "public"."md_clinic" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
275CONSTRAINT "fk_mc_step_to_pim_empl_pos" FOREIGN KEY ("death_employee_id") REFERENCES "public"."pim_employee_position" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
276)
277WITH (OIDS=FALSE)
278;
279
280ALTER TABLE "public"."mc_step" OWNER TO "app_group_master";
281
282COMMENT ON TABLE "public"."mc_step" IS 'Шаг Ð¾ÐºÐ°Ð·Ð°Ð½Ð¸Ñ Ð¼ÐµÐ´ помощи в рамках ÑлучаÑ: поÑещение или запиÑÑŒ Ð¾Ñ‚Ð´ÐµÐ»ÐµÐ½Ð¸Ñ Ð³Ð¾Ñпитализации.';
283
284COMMENT ON COLUMN "public"."mc_step"."id" IS 'Идентификатор';
285
286COMMENT ON COLUMN "public"."mc_step"."admission_date" IS 'Дата поÑтуплениÑ, Ð´Ð»Ñ Ð¿Ð¾Ñещений - дата поÑещениÑ';
287
288COMMENT ON COLUMN "public"."mc_step"."admission_time" IS 'Ð’Ñ€ÐµÐ¼Ñ Ð¿Ð¾ÑтуплениÑ, Ð´Ð»Ñ Ð¿Ð¾Ñещений - Ð²Ñ€ÐµÐ¼Ñ Ð¿Ð¾ÑещениÑ';
289
290COMMENT ON COLUMN "public"."mc_step"."death_date" IS 'Дата Ñмерти';
291
292COMMENT ON COLUMN "public"."mc_step"."death_time" IS 'Ð’Ñ€ÐµÐ¼Ñ Ñмерти';
293
294COMMENT ON COLUMN "public"."mc_step"."outcome_date" IS 'Дата выбытиÑ';
295
296COMMENT ON COLUMN "public"."mc_step"."outcome_time" IS 'Ð’Ñ€ÐµÐ¼Ñ Ð²Ñ‹Ð±Ñ‹Ñ‚Ð¸Ñ';
297
298COMMENT ON COLUMN "public"."mc_step"."death_employee_id" IS 'Сотрудник, зафикÑировавший факт Ñмерти';
299
300COMMENT ON COLUMN "public"."mc_step"."case_id" IS 'Случай';
301
302COMMENT ON COLUMN "public"."mc_step"."outcome_id" IS 'ИÑход заболеваниÑ';
303
304COMMENT ON COLUMN "public"."mc_step"."outcome_clinic_id" IS 'ЛПУ выбытиÑ';
305
306COMMENT ON COLUMN "public"."mc_step"."outcome_regimen_id" IS 'Режим Ð»ÐµÑ‡ÐµÐ½Ð¸Ñ Ð² ЛПУ перевода';
307
308COMMENT ON COLUMN "public"."mc_step"."regimen_id" IS 'Режим лечениÑ';
309
310COMMENT ON COLUMN "public"."mc_step"."res_group_id" IS 'СоÑтавной реÑурÑ';
311
312COMMENT ON COLUMN "public"."mc_step"."result_id" IS 'Результат обращениÑ';
313
314COMMENT ON COLUMN "public"."mc_step"."reason_id" IS 'Причина';
315
316COMMENT ON COLUMN "public"."mc_step"."profile_id" IS 'Профиль койки';
317
318COMMENT ON COLUMN "public"."mc_step"."mes_id" IS 'Медико-ÑкономичеÑкий Ñтандарт';
319
320COMMENT ON COLUMN "public"."mc_step"."_clinic_id" IS 'System field, filled by trigger from mc_case.clinic_id';
321
322COMMENT ON COLUMN "public"."mc_step"."_patient_id" IS 'System field, filled by trigger from mc_case.patient_id';
323
324
325
326CREATE INDEX "idx_mc_step" ON "public"."mc_step" USING btree ("case_id");
327
328CREATE INDEX "idx_mc_step_0" ON "public"."mc_step" USING btree ("res_group_id");
329
330CREATE INDEX "idx_mc_step_1" ON "public"."mc_step" USING btree ("outcome_clinic_id");
331
332CREATE INDEX "idx_mc_step_2" ON "public"."mc_step" USING btree ("result_id");
333
334CREATE INDEX "idx_mc_step_3" ON "public"."mc_step" USING btree ("outcome_id");
335
336CREATE INDEX "idx_mc_step_4" ON "public"."mc_step" USING btree ("reason_id");
337
338CREATE INDEX "idx_mc_step_5" ON "public"."mc_step" USING btree ("outcome_regimen_id");
339
340CREATE INDEX "idx_mc_step_7" ON "public"."mc_step" USING btree ("regimen_id") WHERE regimen_id <> 1;
341
342CREATE INDEX "mc_step_admission_date_admission_time_id_idx" ON "public"."mc_step" USING btree ("admission_date", "admission_time", "id");
343
344CREATE INDEX "mc_step_admission_date_outcome_date_idx" ON "public"."mc_step" USING btree ("admission_date", "outcome_date");
345
346CREATE INDEX "mc_step_admission_date_outcome_date_time_idx" ON "public"."mc_step" USING btree ("(admission_date + COALESCE(admission_time, '00:00:00'::time without time zone))", "(outcome_date + COALESCE(outcome_time, '00:00:00'::time without time zone))");
347
348CREATE INDEX "mc_step_admission_date_time_idx" ON "public"."mc_step" USING btree ("admission_date", "admission_time");
349
350CREATE INDEX "mc_step_case_date_ix" ON "public"."mc_step" USING btree ("admission_date", "case_id");
351
352CREATE INDEX "mc_step_case_ix" ON "public"."mc_step" USING btree ("case_id");
353
354CREATE INDEX "mc_step_clinic_id_ix" ON "public"."mc_step" USING btree ("_clinic_id") WHERE _clinic_id <> 490;
355
356CREATE INDEX "mc_step_date_case_ix" ON "public"."mc_step" USING btree ("case_id", "admission_date");
357
358CREATE INDEX "mc_step_date_time_indi_clinic_id_idx" ON "public"."mc_step" USING btree ("admission_date" DESC, "admission_time" DESC, "get_individual_surname_index(_patient_id)", "get_individual_name_index(_patient_id)", "get_individual_patr_name_index(_patient_id)", "id" DESC, "_clinic_id", "admission_date" DESC, "admission_time" DESC, "get_individual_surname_index(_patient_id)", "get_individual_name_index(_patient_id)", "get_individual_patr_name_index(_patient_id)", "id" DESC, "_clinic_id", "admission_date" DESC, "admission_time" DESC, "get_individual_surname_index(_patient_id)", "get_individual_name_index(_patient_id)", "get_individual_patr_name_index(_patient_id)", "id" DESC, "_clinic_id");
359
360CREATE INDEX "mc_step_death_employee_id_idx" ON "public"."mc_step" USING btree ("death_employee_id");
361
362CREATE INDEX "mc_step_main_diagnosis_id_idx" ON "public"."mc_step" USING btree ("main_diagnosis_id");
363
364CREATE INDEX "mc_step_md_mes_fk" ON "public"."mc_step" USING btree ("mes_id");
365
366CREATE INDEX "mc_step_mes_quality_criterion_fk" ON "public"."mc_step" USING btree ("mes_quality_criterion_id");
367
368CREATE INDEX "mc_step_outcome_clinic_id_idx" ON "public"."mc_step" USING btree ("outcome_clinic_id");
369
370CREATE INDEX "mc_step_outcome_date" ON "public"."mc_step" USING btree ("outcome_date" DESC);
371
372CREATE INDEX "mc_step_outcome_date_idx" ON "public"."mc_step" USING btree ("outcome_date");
373
374CREATE INDEX "mc_step_outcome_id_idx" ON "public"."mc_step" USING btree ("outcome_id");
375
376CREATE INDEX "mc_step_outcome_regimen_id_idx" ON "public"."mc_step" USING btree ("outcome_regimen_id");
377
378CREATE INDEX "mc_step_patient_id_ix" ON "public"."mc_step" USING btree ("_patient_id") WHERE _patient_id <> 5568542;
379
380CREATE INDEX "mc_step_reason_id_idx" ON "public"."mc_step" USING btree ("reason_id");
381
382CREATE INDEX "mc_step_regimen_id_idx" ON "public"."mc_step" USING btree ("regimen_id") WHERE regimen_id <> 1;
383
384CREATE INDEX "mc_step_res_group_id_idx" ON "public"."mc_step" USING btree ("res_group_id");
385
386CREATE INDEX "mc_step_result_id_idx" ON "public"."mc_step" USING btree ("result_id");
387
388CREATE INDEX "mc_step_to_profile_ref" ON "public"."mc_step" USING btree ("profile_id") WHERE profile_id <> 144;
389
390
391
392CREATE TRIGGER "audit_trigger" BEFORE INSERT OR UPDATE ON "public"."mc_step"
393FOR EACH ROW
394EXECUTE PROCEDURE "audit_trigger_fun"();
395
396CREATE TRIGGER "case_closing_tg" AFTER INSERT OR UPDATE OF "result_id", "outcome_date", "case_id" ON "public"."mc_step"
397FOR EACH ROW
398EXECUTE PROCEDURE "case_closing_tf"();
399
400CREATE TRIGGER "mc_step_adm_date" BEFORE INSERT OR UPDATE ON "public"."mc_step"
401FOR EACH ROW
402EXECUTE PROCEDURE "f_mc_step_adm_date"();
403
404CREATE TRIGGER "mc_step_before_case_update_trg" BEFORE UPDATE OF "case_id" ON "public"."mc_step"
405FOR EACH ROW
406WHEN (old.case_id IS DISTINCT FROM new.case_id)
407EXECUTE PROCEDURE "mc_step_trigger_update_trgf"();
408
409CREATE TRIGGER "mc_step_before_insert_trg" BEFORE INSERT ON "public"."mc_step"
410FOR EACH ROW
411EXECUTE PROCEDURE "mc_step_trigger_update_trgf"();
412
413CREATE TRIGGER "mc_step_case_s_s" AFTER INSERT OR UPDATE OR DELETE ON "public"."mc_step"
414FOR EACH ROW
415EXECUTE PROCEDURE "mc_step_case_s_s"();
416
417CREATE TRIGGER "mc_step_sync_ariud" AFTER INSERT OR UPDATE OR DELETE ON "public"."mc_step"
418FOR EACH ROW
419EXECUTE PROCEDURE "sync_data_f"();
420
421CREATE CONSTRAINT TRIGGER "trigger_on_delete_case_step" AFTER DELETE ON "public"."mc_step"
422DEFERRABLE INITIALLY DEFERRED FOR EACH ROW
423EXECUTE PROCEDURE "delete_res_group_on_delete_case_step"();
424
425CREATE CONSTRAINT TRIGGER "trigger_update_case_step_admission_date_time" AFTER INSERT OR UPDATE OF "admission_date", "admission_time" OR DELETE ON "public"."mc_step"
426DEFERRABLE INITIALLY DEFERRED FOR EACH ROW
427EXECUTE PROCEDURE "update_medcase_open_date_time"();