BPmzR1tX

1-- Table: common.cd_persons
2
3-- DROP TABLE IF EXISTS common.cd_persons;
4
5CREATE TABLE IF NOT EXISTS common.cd_persons
6(
7    id uuid NOT NULL DEFAULT uuid_generate_v4(),
8    c_lastname text COLLATE pg_catalog."default" NOT NULL,
9    c_firstname text COLLATE pg_catalog."default" NOT NULL,
10    c_middlename text COLLATE pg_catalog."default",
11    d_birthdate timestamp without time zone NOT NULL,
12    c_snils text COLLATE pg_catalog."default" NOT NULL,
13    c_inn text COLLATE pg_catalog."default",
14    c_phone text COLLATE pg_catalog."default",
15    f_doc_type uuid NOT NULL,
16    c_doc_series text COLLATE pg_catalog."default" NOT NULL,
17    c_doc_number text COLLATE pg_catalog."default" NOT NULL,
18    d_doc_issued timestamp without time zone NOT NULL,
19    c_email text COLLATE pg_catalog."default",
20    c_address_reg_full text COLLATE pg_catalog."default",
21    c_address_reg_region text COLLATE pg_catalog."default",
22    c_address_reg_district text COLLATE pg_catalog."default",
23    c_address_reg_city text COLLATE pg_catalog."default",
24    c_address_reg_settlement text COLLATE pg_catalog."default",
25    c_address_reg_place text COLLATE pg_catalog."default",
26    c_address_reg_street text COLLATE pg_catalog."default",
27    c_address_reg_house text COLLATE pg_catalog."default",
28    c_address_reg_corpus text COLLATE pg_catalog."default",
29    c_address_reg_flat text COLLATE pg_catalog."default",
30    c_address_reg_postalcode text COLLATE pg_catalog."default",
31    uuid_house uuid,
32    uuid_reg_region uuid,
33    uuid_reg_district uuid,
34    uuid_reg_city uuid,
35    uuid_reg_settlement uuid,
36    uuid_reg_place uuid,
37    uuid_reg_street uuid,
38    c_address_live_full text COLLATE pg_catalog."default",
39    c_address_live_region text COLLATE pg_catalog."default",
40    c_address_live_district text COLLATE pg_catalog."default",
41    c_address_live_city text COLLATE pg_catalog."default",
42    c_address_live_settlement text COLLATE pg_catalog."default",
43    c_address_live_place text COLLATE pg_catalog."default",
44    c_address_live_street text COLLATE pg_catalog."default",
45    c_address_live_house text COLLATE pg_catalog."default",
46    c_address_live_corpus text COLLATE pg_catalog."default",
47    c_address_live_flat text COLLATE pg_catalog."default",
48    c_address_live_postalcode text COLLATE pg_catalog."default",
49    uuid_live_house uuid,
50    uuid_live_region uuid,
51    uuid_live_district uuid,
52    uuid_live_city uuid,
53    uuid_live_settlement uuid,
54    uuid_live_place uuid,
55    f_sex uuid NOT NULL,
56    uuid_live_street uuid,
57    f_org integer NOT NULL,
58    b_address_match boolean NOT NULL DEFAULT false,
59    s_creator text COLLATE pg_catalog."default",
60    s_owner text COLLATE pg_catalog."default",
61    s_create_date timestamp with time zone DEFAULT now(),
62    s_modif_date timestamp with time zone,
63    b_is_ru_citizen boolean NOT NULL DEFAULT true,
64    f_doc_issuer uuid,
65    c_doc_subdivision text COLLATE pg_catalog."default",
66    c_relation_degree text COLLATE pg_catalog."default",
67    CONSTRAINT cd_persons_pkey PRIMARY KEY (id),
68    CONSTRAINT unique_c_snils UNIQUE (c_snils),
69    CONSTRAINT cd_persons_fk FOREIGN KEY (f_org)
70        REFERENCES common.cs_organizations (id) MATCH SIMPLE
71        ON UPDATE NO ACTION
72        ON DELETE NO ACTION,
73    CONSTRAINT cd_persons_fkey_f_document_types FOREIGN KEY (f_doc_type)
74        REFERENCES common.cs_document_types (id) MATCH SIMPLE
75        ON UPDATE NO ACTION
76        ON DELETE SET NULL,
77    CONSTRAINT cd_persons_sex FOREIGN KEY (f_sex)
78        REFERENCES common.cs_sex (id) MATCH SIMPLE
79        ON UPDATE NO ACTION
80        ON DELETE SET NULL,
81    CONSTRAINT fk_cd_persons_cs_document_issuing_orgs FOREIGN KEY (f_doc_issuer)
82        REFERENCES common.cs_document_issuing_orgs (id) MATCH SIMPLE
83        ON UPDATE NO ACTION
84        ON DELETE CASCADE
85        NOT VALID
86)
87
88TABLESPACE pg_default;
89
90ALTER TABLE IF EXISTS common.cd_persons
91    OWNER to postgres;
92
93COMMENT ON TABLE common.cd_persons
94    IS '{ "Description" : "Физические лица","XMeta.User.Module" : "Core"}';
95
96COMMENT ON COLUMN common.cd_persons.id
97    IS 'Идентификатор';
98
99COMMENT ON COLUMN common.cd_persons.c_lastname
100    IS 'Фамилия';
101
102COMMENT ON COLUMN common.cd_persons.c_firstname
103    IS 'Имя';
104
105COMMENT ON COLUMN common.cd_persons.c_middlename
106    IS 'Отчество';
107
108COMMENT ON COLUMN common.cd_persons.d_birthdate
109    IS 'Дата рождения';
110
111COMMENT ON COLUMN common.cd_persons.c_snils
112    IS 'СНИЛС';
113
114COMMENT ON COLUMN common.cd_persons.c_inn
115    IS 'ИНН';
116
117COMMENT ON COLUMN common.cd_persons.c_phone
118    IS 'Телефон';
119
120COMMENT ON COLUMN common.cd_persons.f_doc_type
121    IS 'Тип документа';
122
123COMMENT ON COLUMN common.cd_persons.c_doc_series
124    IS 'Серия документа';
125
126COMMENT ON COLUMN common.cd_persons.c_doc_number
127    IS 'Номер документа';
128
129COMMENT ON COLUMN common.cd_persons.d_doc_issued
130    IS 'Дата выдачи документа';
131
132COMMENT ON COLUMN common.cd_persons.c_email
133    IS 'Электронная почта';
134
135COMMENT ON COLUMN common.cd_persons.c_address_reg_full
136    IS 'Адрес регистрации';
137
138COMMENT ON COLUMN common.cd_persons.c_address_reg_region
139    IS 'Регион';
140
141COMMENT ON COLUMN common.cd_persons.c_address_reg_district
142    IS 'Район';
143
144COMMENT ON COLUMN common.cd_persons.c_address_reg_city
145    IS 'Город';
146
147COMMENT ON COLUMN common.cd_persons.c_address_reg_settlement
148    IS 'Населённый пункт';
149
150COMMENT ON COLUMN common.cd_persons.c_address_reg_place
151    IS 'Элемент планировочной структуры';
152
153COMMENT ON COLUMN common.cd_persons.c_address_reg_street
154    IS 'Улица';
155
156COMMENT ON COLUMN common.cd_persons.c_address_reg_house
157    IS 'Дом';
158
159COMMENT ON COLUMN common.cd_persons.c_address_reg_corpus
160    IS 'Корпус';
161
162COMMENT ON COLUMN common.cd_persons.c_address_reg_flat
163    IS 'Квартира';
164
165COMMENT ON COLUMN common.cd_persons.c_address_reg_postalcode
166    IS 'Почтовый индекс';
167
168COMMENT ON COLUMN common.cd_persons.uuid_house
169    IS 'Идентификатор дома';
170
171COMMENT ON COLUMN common.cd_persons.uuid_reg_region
172    IS 'Идентификатор регион';
173
174COMMENT ON COLUMN common.cd_persons.uuid_reg_district
175    IS 'Идентификатор район';
176
177COMMENT ON COLUMN common.cd_persons.uuid_reg_city
178    IS 'Идентификатор город';
179
180COMMENT ON COLUMN common.cd_persons.uuid_reg_settlement
181    IS 'Идентификатор населённый пункт';
182
183COMMENT ON COLUMN common.cd_persons.uuid_reg_place
184    IS 'Идентификатор элемент планировочной структуры';
185
186COMMENT ON COLUMN common.cd_persons.uuid_reg_street
187    IS 'Идентификатор улица';
188
189COMMENT ON COLUMN common.cd_persons.c_address_live_full
190    IS 'Адрес места проживания';
191
192COMMENT ON COLUMN common.cd_persons.c_address_live_region
193    IS 'Регисон места проживания';
194
195COMMENT ON COLUMN common.cd_persons.c_address_live_district
196    IS 'Район места проживания';
197
198COMMENT ON COLUMN common.cd_persons.c_address_live_city
199    IS 'Город места проживания';
200
201COMMENT ON COLUMN common.cd_persons.c_address_live_settlement
202    IS 'Населенный пункт места проживания';
203
204COMMENT ON COLUMN common.cd_persons.c_address_live_place
205    IS 'Элемент места проживания';
206
207COMMENT ON COLUMN common.cd_persons.c_address_live_street
208    IS 'Улица место проживания';
209
210COMMENT ON COLUMN common.cd_persons.c_address_live_house
211    IS 'Дом места проживания';
212
213COMMENT ON COLUMN common.cd_persons.c_address_live_corpus
214    IS 'Корпус места проживания';
215
216COMMENT ON COLUMN common.cd_persons.c_address_live_flat
217    IS 'Квартира места проживания';
218
219COMMENT ON COLUMN common.cd_persons.c_address_live_postalcode
220    IS 'Индекс места проживания';
221
222COMMENT ON COLUMN common.cd_persons.uuid_live_house
223    IS 'ФИАС места проживания дом';
224
225COMMENT ON COLUMN common.cd_persons.uuid_live_region
226    IS 'ФИАС места проживания регион';
227
228COMMENT ON COLUMN common.cd_persons.uuid_live_district
229    IS 'ФИАС места проживания район';
230
231COMMENT ON COLUMN common.cd_persons.uuid_live_city
232    IS 'ФИАС места проживания город';
233
234COMMENT ON COLUMN common.cd_persons.uuid_live_settlement
235    IS 'ФИАС места проживания населенный пункт';
236
237COMMENT ON COLUMN common.cd_persons.uuid_live_place
238    IS 'ФИАС места проживания элемент';
239
240COMMENT ON COLUMN common.cd_persons.f_sex
241    IS 'Пол';
242
243COMMENT ON COLUMN common.cd_persons.uuid_live_street
244    IS 'ФИАС места проживания улица';
245
246COMMENT ON COLUMN common.cd_persons.f_org
247    IS 'Организация';
248
249COMMENT ON COLUMN common.cd_persons.b_address_match
250    IS 'Адрес регистрации и адрес фактического проживания совпадают';
251
252COMMENT ON COLUMN common.cd_persons.b_is_ru_citizen
253    IS 'Гражданин РФ';
254
255COMMENT ON COLUMN common.cd_persons.f_doc_issuer
256    IS 'Организация, выдавшая документ';
257
258COMMENT ON COLUMN common.cd_persons.c_doc_subdivision
259    IS 'Код подразделения';
260
261COMMENT ON COLUMN common.cd_persons.c_relation_degree
262    IS 'Степень родства';
263-- Index: cd_persons_f_org_idx
264
265-- DROP INDEX IF EXISTS common.cd_persons_f_org_idx;
266
267CREATE INDEX IF NOT EXISTS cd_persons_f_org_idx
268    ON common.cd_persons USING btree
269    (f_org ASC NULLS LAST)
270    TABLESPACE pg_default;
271-- Index: if_document_type_common_cd_persons_B09C1A72
272
273-- DROP INDEX IF EXISTS common."if_document_type_common_cd_persons_B09C1A72";
274
275CREATE INDEX IF NOT EXISTS "if_document_type_common_cd_persons_B09C1A72"
276    ON common.cd_persons USING btree
277    (f_doc_type ASC NULLS LAST)
278    TABLESPACE pg_default;