yD6w9ST2

1SET client_encoding TO 'UTF8';
2
3SET search_path = dpc;
4
5DROP TRIGGER IF EXISTS ins_confirmation_methods_id ON confirmation_methods CASCADE;
6CREATE OR REPLACE FUNCTION trigger_fct_ins_confirmation_methods_id() RETURNS trigger AS $BODY$
7BEGIN
8	NEW.ID := nextval('seq_confirmation_methods');
9RETURN NEW;
10END
11$BODY$
12 LANGUAGE 'plpgsql';
13
14
15CREATE TABLE confirmation_methods (
16	id numeric NOT NULL,
17	code numeric,
18	name varchar(100),
19	version varchar(15) DEFAULT '1.0'
20) ;
21COMMENT ON TABLE confirmation_methods IS E'Метод подтверждения диагноза';
22COMMENT ON COLUMN confirmation_methods.id IS E'Идентификатор';
23COMMENT ON COLUMN confirmation_methods.name IS E'Название метода подтверждения диагноза';
24COMMENT ON COLUMN confirmation_methods.code IS E'Код справочника';
25COMMENT ON COLUMN confirmation_methods.version IS E'Версия справочника';
26ALTER TABLE confirmation_methods ADD PRIMARY KEY (id);
27
28CREATE TABLE detection_cases (
29	id numeric NOT NULL,
30	code numeric,
31	name varchar(100),
32	version varchar(15) DEFAULT '1.0'
33) ;
34COMMENT ON TABLE detection_cases IS E'Обстоятельства выявления опухоли';
35COMMENT ON COLUMN detection_cases.id IS E'Идентификатор';
36COMMENT ON COLUMN detection_cases.name IS E'Название обстоятельства выявления опухоли';
37COMMENT ON COLUMN detection_cases.code IS E'Код справочника';
38COMMENT ON COLUMN detection_cases.version IS E'Версия справочника';
39ALTER TABLE detection_cases ADD PRIMARY KEY (id);
40
41
42CREATE TRIGGER ins_confirmation_methods_id
43	BEFORE INSERT ON confirmation_methods FOR EACH ROW
44	EXECUTE PROCEDURE trigger_fct_ins_confirmation_methods_id();
45
46DROP TRIGGER IF EXISTS ins_detection_cases_id ON detection_cases CASCADE;
47CREATE OR REPLACE FUNCTION trigger_fct_ins_detection_cases_id() RETURNS trigger AS $BODY$
48BEGIN
49	NEW.ID := nextval('seq_detection_cases');
50RETURN NEW;
51END
52$BODY$
53 LANGUAGE 'plpgsql';
54
55CREATE TRIGGER ins_detection_cases_id
56	BEFORE INSERT ON detection_cases FOR EACH ROW
57	EXECUTE PROCEDURE trigger_fct_ins_detection_cases_id();
58
59DROP TRIGGER IF EXISTS ins_hst0413_trigger ON hst0413 CASCADE;
60CREATE OR REPLACE FUNCTION trigger_fct_ins_hst0413_trigger() RETURNS trigger AS $BODY$
61BEGIN
62NEW.CODE := nextval('seq_hst0413');
63NEW.ID := NEW.CODE;
64RETURN NEW;
65END
66$BODY$
67 LANGUAGE 'plpgsql' SECURITY DEFINER;
68-- REVOKE ALL ON FUNCTION trigger_fct_ins_hst0413_trigger() FROM PUBLIC;