r9x1G5qd

1Microsoft Windows [Version 10.0.14393]
2(c) Корпорация Майкрософт (Microsoft Corporation), 2016. Все права защищены.
3
4C:\Windows\system32>cd "C:\Program Files (x86)\PostgreSQL\10\bin"
5
6C:\Program Files (x86)\PostgreSQL\10\bin>pg_restore.exe "C:\backup_.sql"
7--
8-- PostgreSQL database dump
9--
10
11-- Dumped from database version 10.8
12-- Dumped by pg_dump version 10.8
13
14SET statement_timeout = 0;
15SET lock_timeout = 0;
16SET idle_in_transaction_session_timeout = 0;
17SET client_encoding = 'UTF8';
18SET standard_conforming_strings = on;
19SELECT pg_catalog.set_config('search_path', '', false);
20SET check_function_bodies = false;
21SET xmloption = content;
22SET client_min_messages = warning;
23SET row_security = off;
24
25--
26-- Name: DATABASE postgres; Type: COMMENT; Schema: -; Owner: postgres
27--
28
29COMMENT ON DATABASE postgres IS 'default administrative connection database';
30
31
32--
33-- Name: vk; Type: SCHEMA; Schema: -; Owner: postgres
34--
35
36CREATE SCHEMA vk;
37
38
39ALTER SCHEMA vk OWNER TO postgres;
40
41--
42-- Name: vk_system; Type: SCHEMA; Schema: -; Owner: postgres
43--
44
45CREATE SCHEMA vk_system;
46
47
48ALTER SCHEMA vk_system OWNER TO postgres;
49
50--
51-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
52--
53
54CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
55
56
57--
58-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
59--
60
61COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
62
63
64--
65-- Name: adminpack; Type: EXTENSION; Schema: -; Owner:
66--
67
68CREATE EXTENSION IF NOT EXISTS adminpack WITH SCHEMA pg_catalog;
69
70
71--
72-- Name: EXTENSION adminpack; Type: COMMENT; Schema: -; Owner:
73--
74
75COMMENT ON EXTENSION adminpack IS 'administrative functions for PostgreSQL';
76
77
78SET default_tablespace = '';
79
80SET default_with_oids = false;
81
82--
83-- Name: address; Type: TABLE; Schema: vk; Owner: postgres
84--
85
86CREATE TABLE vk.address (
87    id integer NOT NULL,
88    reservist_id integer NOT NULL,
89    type smallint NOT NULL,
90    country_id integer NOT NULL,
91    postcode character varying(6) DEFAULT NULL::character varying,
92    region character varying(30) NOT NULL,
93    type_np_id integer NOT NULL,
94    city character varying(30) NOT NULL,
95    district_id integer NOT NULL,
96    municipal_id integer NOT NULL,
97    reu_id integer NOT NULL,
98    street_type_id integer NOT NULL,
99    street_id integer NOT NULL,
100    house character varying(10) NOT NULL,
101    corp integer,
102    dop character varying(40) DEFAULT NULL::character varying,
103    flat character varying(10),
104    priority smallint NOT NULL,
105    actual smallint NOT NULL,
106    passport_service_id integer,
107    police text
108);
109
110
111ALTER TABLE vk.address OWNER TO postgres;
112
113--
114-- Name: address_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
115--
116
117CREATE SEQUENCE vk.address_id_seq
118    AS integer
119    START WITH 1
120    INCREMENT BY 1
121    NO MINVALUE
122    NO MAXVALUE
123    CACHE 1;
124
125
126ALTER TABLE vk.address_id_seq OWNER TO postgres;
127
128--
129-- Name: address_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
130--
131
132ALTER SEQUENCE vk.address_id_seq OWNED BY vk.address.id;
133
134
135--
136-- Name: addresstype; Type: TABLE; Schema: vk; Owner: postgres
137--
138
139CREATE TABLE vk.addresstype (
140    id integer NOT NULL,
141    name character varying(255) DEFAULT NULL::character varying
142);
143
144
145ALTER TABLE vk.addresstype OWNER TO postgres;
146
147--
148-- Name: addresstype_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
149--
150
151CREATE SEQUENCE vk.addresstype_id_seq
152    START WITH 1
153    INCREMENT BY 1
154    NO MINVALUE
155    NO MAXVALUE
156    CACHE 1;
157
158
159ALTER TABLE vk.addresstype_id_seq OWNER TO postgres;
160
161--
162-- Name: addresstype_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
163--
164
165ALTER SEQUENCE vk.addresstype_id_seq OWNED BY vk.addresstype.id;
166
167
168--
169-- Name: armytype; Type: TABLE; Schema: vk; Owner: postgres
170--
171
172CREATE TABLE vk.armytype (
173    id integer NOT NULL,
174    name text,
175    fullname text,
176    code text
177);
178
179
180ALTER TABLE vk.armytype OWNER TO postgres;
181
182--
183-- Name: armytype_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
184--
185
186CREATE SEQUENCE vk.armytype_id_seq
187    AS integer
188    START WITH 1
189    INCREMENT BY 1
190    NO MINVALUE
191    NO MAXVALUE
192    CACHE 1;
193
194
195ALTER TABLE vk.armytype_id_seq OWNER TO postgres;
196
197--
198-- Name: armytype_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
199--
200
201ALTER SEQUENCE vk.armytype_id_seq OWNED BY vk.armytype.id;
202
203
204--
205-- Name: availability; Type: TABLE; Schema: vk; Owner: postgres
206--
207
208CREATE TABLE vk.availability (
209    id integer NOT NULL,
210    name character varying(255),
211    shortname character varying(45)
212);
213
214
215ALTER TABLE vk.availability OWNER TO postgres;
216
217--
218-- Name: availability_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
219--
220
221CREATE SEQUENCE vk.availability_id_seq
222    START WITH 1
223    INCREMENT BY 1
224    NO MINVALUE
225    NO MAXVALUE
226    CACHE 1;
227
228
229ALTER TABLE vk.availability_id_seq OWNER TO postgres;
230
231--
232-- Name: availability_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
233--
234
235ALTER SEQUENCE vk.availability_id_seq OWNED BY vk.availability.id;
236
237
238--
239-- Name: call; Type: TABLE; Schema: vk; Owner: postgres
240--
241
242CREATE TABLE vk.call (
243    id integer NOT NULL,
244    reservist_id integer,
245    datecall date,
246    resultcall integer
247);
248
249
250ALTER TABLE vk.call OWNER TO postgres;
251
252--
253-- Name: call_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
254--
255
256CREATE SEQUENCE vk.call_id_seq
257    START WITH 1
258    INCREMENT BY 1
259    NO MINVALUE
260    NO MAXVALUE
261    CACHE 1;
262
263
264ALTER TABLE vk.call_id_seq OWNER TO postgres;
265
266--
267-- Name: call_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
268--
269
270ALTER SEQUENCE vk.call_id_seq OWNED BY vk.call.id;
271
272
273--
274-- Name: calltogovement; Type: TABLE; Schema: vk; Owner: postgres
275--
276
277CREATE TABLE vk.calltogovement (
278    id integer NOT NULL,
279    reservist_id integer,
280    calltogovementtype integer,
281    resultcall integer,
282    datecall date
283);
284
285
286ALTER TABLE vk.calltogovement OWNER TO postgres;
287
288--
289-- Name: calltogovement_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
290--
291
292CREATE SEQUENCE vk.calltogovement_id_seq
293    START WITH 1
294    INCREMENT BY 1
295    NO MINVALUE
296    NO MAXVALUE
297    CACHE 1;
298
299
300ALTER TABLE vk.calltogovement_id_seq OWNER TO postgres;
301
302--
303-- Name: calltogovement_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
304--
305
306ALTER SEQUENCE vk.calltogovement_id_seq OWNED BY vk.calltogovement.id;
307
308
309--
310-- Name: calltogovementtype; Type: TABLE; Schema: vk; Owner: postgres
311--
312
313CREATE TABLE vk.calltogovementtype (
314    id integer NOT NULL,
315    name character varying(255) DEFAULT NULL::character varying
316);
317
318
319ALTER TABLE vk.calltogovementtype OWNER TO postgres;
320
321--
322-- Name: calltogovementtype_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
323--
324
325CREATE SEQUENCE vk.calltogovementtype_id_seq
326    START WITH 1
327    INCREMENT BY 1
328    NO MINVALUE
329    NO MAXVALUE
330    CACHE 1;
331
332
333ALTER TABLE vk.calltogovementtype_id_seq OWNER TO postgres;
334
335--
336-- Name: calltogovementtype_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
337--
338
339ALTER SEQUENCE vk.calltogovementtype_id_seq OWNED BY vk.calltogovementtype.id;
340
341
342--
343-- Name: calltype; Type: TABLE; Schema: vk; Owner: postgres
344--
345
346CREATE TABLE vk.calltype (
347    id integer NOT NULL,
348    name text
349);
350
351
352ALTER TABLE vk.calltype OWNER TO postgres;
353
354--
355-- Name: calltype_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
356--
357
358CREATE SEQUENCE vk.calltype_id_seq
359    AS integer
360    START WITH 1
361    INCREMENT BY 1
362    NO MINVALUE
363    NO MAXVALUE
364    CACHE 1;
365
366
367ALTER TABLE vk.calltype_id_seq OWNER TO postgres;
368
369--
370-- Name: calltype_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
371--
372
373ALTER SEQUENCE vk.calltype_id_seq OWNED BY vk.calltype.id;
374
375
376--
377-- Name: commission_decision; Type: TABLE; Schema: vk; Owner: postgres
378--
379
380CREATE TABLE vk.commission_decision (
381    id integer NOT NULL,
382    name text
383);
384
385
386ALTER TABLE vk.commission_decision OWNER TO postgres;
387
388--
389-- Name: commission_decision_base; Type: TABLE; Schema: vk; Owner: postgres
390--
391
392CREATE TABLE vk.commission_decision_base (
393    id integer NOT NULL,
394    name text
395);
396
397
398ALTER TABLE vk.commission_decision_base OWNER TO postgres;
399
400--
401-- Name: TABLE commission_decision_base; Type: COMMENT; Schema: vk; Owner: postgres
402--
403
404COMMENT ON TABLE vk.commission_decision_base IS 'Р?РЎР'Р?Р'Р?Р"Р?РўР┐
405';
406
407
408--
409-- Name: commission_decision_base_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
410--
411
412CREATE SEQUENCE vk.commission_decision_base_id_seq
413    START WITH 1
414    INCREMENT BY 1
415    NO MINVALUE
416    NO MAXVALUE
417    CACHE 1;
418
419
420ALTER TABLE vk.commission_decision_base_id_seq OWNER TO postgres;
421
422--
423-- Name: commission_decision_base_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
424--
425
426ALTER SEQUENCE vk.commission_decision_base_id_seq OWNED BY vk.commission_decision_base.id;
427
428
429--
430-- Name: commission_decision_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
431--
432
433CREATE SEQUENCE vk.commission_decision_id_seq
434    START WITH 1
435    INCREMENT BY 1
436    NO MINVALUE
437    NO MAXVALUE
438    CACHE 1;
439
440
441ALTER TABLE vk.commission_decision_id_seq OWNER TO postgres;
442
443--
444-- Name: commission_decision_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
445--
446
447ALTER SEQUENCE vk.commission_decision_id_seq OWNED BY vk.commission_decision.id;
448
449
450--
451-- Name: country; Type: TABLE; Schema: vk; Owner: postgres
452--
453
454CREATE TABLE vk.country (
455    id integer NOT NULL,
456    name character varying(255) DEFAULT NULL::character varying
457);
458
459
460ALTER TABLE vk.country OWNER TO postgres;
461
462--
463-- Name: country_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
464--
465
466CREATE SEQUENCE vk.country_id_seq
467    START WITH 1
468    INCREMENT BY 1
469    NO MINVALUE
470    NO MAXVALUE
471    CACHE 1;
472
473
474ALTER TABLE vk.country_id_seq OWNER TO postgres;
475
476--
477-- Name: country_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
478--
479
480ALTER SEQUENCE vk.country_id_seq OWNED BY vk.country.id;
481
482
483--
484-- Name: delay; Type: TABLE; Schema: vk; Owner: postgres
485--
486
487CREATE TABLE vk.delay (
488    id integer NOT NULL,
489    name text
490);
491
492
493ALTER TABLE vk.delay OWNER TO postgres;
494
495--
496-- Name: delay_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
497--
498
499CREATE SEQUENCE vk.delay_id_seq
500    AS integer
501    START WITH 1
502    INCREMENT BY 1
503    NO MINVALUE
504    NO MAXVALUE
505    CACHE 1;
506
507
508ALTER TABLE vk.delay_id_seq OWNER TO postgres;
509
510--
511-- Name: delay_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
512--
513
514ALTER SEQUENCE vk.delay_id_seq OWNED BY vk.delay.id;
515
516
517--
518-- Name: delay_priziv; Type: TABLE; Schema: vk; Owner: postgres
519--
520
521CREATE TABLE vk.delay_priziv (
522    id integer NOT NULL,
523    name text
524);
525
526
527ALTER TABLE vk.delay_priziv OWNER TO postgres;
528
529--
530-- Name: delay_priziv_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
531--
532
533CREATE SEQUENCE vk.delay_priziv_id_seq
534    AS integer
535    START WITH 1
536    INCREMENT BY 1
537    NO MINVALUE
538    NO MAXVALUE
539    CACHE 1;
540
541
542ALTER TABLE vk.delay_priziv_id_seq OWNER TO postgres;
543
544--
545-- Name: delay_priziv_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
546--
547
548ALTER SEQUENCE vk.delay_priziv_id_seq OWNED BY vk.delay_priziv.id;
549
550
551--
552-- Name: descriptions; Type: TABLE; Schema: vk; Owner: postgres
553--
554
555CREATE TABLE vk.descriptions (
556    reservist_id integer NOT NULL,
557    description text
558);
559
560
561ALTER TABLE vk.descriptions OWNER TO postgres;
562
563--
564-- Name: district; Type: TABLE; Schema: vk; Owner: postgres
565--
566
567CREATE TABLE vk.district (
568    id integer NOT NULL,
569    name character varying(255) DEFAULT NULL::character varying,
570    okato text
571);
572
573
574ALTER TABLE vk.district OWNER TO postgres;
575
576--
577-- Name: district_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
578--
579
580CREATE SEQUENCE vk.district_id_seq
581    START WITH 1
582    INCREMENT BY 1
583    NO MINVALUE
584    NO MAXVALUE
585    CACHE 1;
586
587
588ALTER TABLE vk.district_id_seq OWNER TO postgres;
589
590--
591-- Name: district_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
592--
593
594ALTER SEQUENCE vk.district_id_seq OWNED BY vk.district.id;
595
596
597--
598-- Name: doc; Type: TABLE; Schema: vk; Owner: postgres
599--
600
601CREATE TABLE vk.doc (
602    id integer NOT NULL,
603    rv_id integer NOT NULL,
604    type_id integer NOT NULL,
605    series character varying(10),
606    num character varying(18),
607    date date NOT NULL,
608    issuance character varying(230),
609    birth character varying(230),
610    isactual smallint NOT NULL
611);
612
613
614ALTER TABLE vk.doc OWNER TO postgres;
615
616--
617-- Name: doc_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
618--
619
620CREATE SEQUENCE vk.doc_id_seq
621    START WITH 1
622    INCREMENT BY 1
623    NO MINVALUE
624    NO MAXVALUE
625    CACHE 1;
626
627
628ALTER TABLE vk.doc_id_seq OWNER TO postgres;
629
630--
631-- Name: doc_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
632--
633
634ALTER SEQUENCE vk.doc_id_seq OWNED BY vk.doc.id;
635
636
637--
638-- Name: doc_rv_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
639--
640
641CREATE SEQUENCE vk.doc_rv_id_seq
642    START WITH 1
643    INCREMENT BY 1
644    NO MINVALUE
645    NO MAXVALUE
646    CACHE 1;
647
648
649ALTER TABLE vk.doc_rv_id_seq OWNER TO postgres;
650
651--
652-- Name: doc_rv_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
653--
654
655ALTER SEQUENCE vk.doc_rv_id_seq OWNED BY vk.doc.rv_id;
656
657
658--
659-- Name: doc_type_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
660--
661
662CREATE SEQUENCE vk.doc_type_id_seq
663    START WITH 1
664    INCREMENT BY 1
665    NO MINVALUE
666    NO MAXVALUE
667    CACHE 1;
668
669
670ALTER TABLE vk.doc_type_id_seq OWNER TO postgres;
671
672--
673-- Name: doc_type_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
674--
675
676ALTER SEQUENCE vk.doc_type_id_seq OWNED BY vk.doc.type_id;
677
678
679--
680-- Name: doctor; Type: TABLE; Schema: vk; Owner: postgres
681--
682
683CREATE TABLE vk.doctor (
684    id integer NOT NULL,
685    name character varying(255) DEFAULT NULL::character varying
686);
687
688
689ALTER TABLE vk.doctor OWNER TO postgres;
690
691--
692-- Name: doctor_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
693--
694
695CREATE SEQUENCE vk.doctor_id_seq
696    START WITH 1
697    INCREMENT BY 1
698    NO MINVALUE
699    NO MAXVALUE
700    CACHE 1;
701
702
703ALTER TABLE vk.doctor_id_seq OWNER TO postgres;
704
705--
706-- Name: doctor_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
707--
708
709ALTER SEQUENCE vk.doctor_id_seq OWNED BY vk.doctor.id;
710
711
712--
713-- Name: doctype; Type: TABLE; Schema: vk; Owner: postgres
714--
715
716CREATE TABLE vk.doctype (
717    id integer NOT NULL,
718    type character varying(85) NOT NULL
719);
720
721
722ALTER TABLE vk.doctype OWNER TO postgres;
723
724--
725-- Name: doctype_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
726--
727
728CREATE SEQUENCE vk.doctype_id_seq
729    START WITH 1
730    INCREMENT BY 1
731    NO MINVALUE
732    NO MAXVALUE
733    CACHE 1;
734
735
736ALTER TABLE vk.doctype_id_seq OWNER TO postgres;
737
738--
739-- Name: doctype_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
740--
741
742ALTER SEQUENCE vk.doctype_id_seq OWNED BY vk.doctype.id;
743
744
745--
746-- Name: dosaaf; Type: TABLE; Schema: vk; Owner: postgres
747--
748
749CREATE TABLE vk.dosaaf (
750    id integer NOT NULL,
751    name text
752);
753
754
755ALTER TABLE vk.dosaaf OWNER TO postgres;
756
757--
758-- Name: dosaaf_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
759--
760
761CREATE SEQUENCE vk.dosaaf_id_seq
762    AS integer
763    START WITH 1
764    INCREMENT BY 1
765    NO MINVALUE
766    NO MAXVALUE
767    CACHE 1;
768
769
770ALTER TABLE vk.dosaaf_id_seq OWNER TO postgres;
771
772--
773-- Name: dosaaf_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
774--
775
776ALTER SEQUENCE vk.dosaaf_id_seq OWNED BY vk.dosaaf.id;
777
778
779--
780-- Name: drivercategories; Type: TABLE; Schema: vk; Owner: postgres
781--
782
783CREATE TABLE vk.drivercategories (
784    doc_id integer,
785    category text,
786    id integer NOT NULL
787);
788
789
790ALTER TABLE vk.drivercategories OWNER TO postgres;
791
792--
793-- Name: drivercategories_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
794--
795
796CREATE SEQUENCE vk.drivercategories_id_seq
797    AS integer
798    START WITH 1
799    INCREMENT BY 1
800    NO MINVALUE
801    NO MAXVALUE
802    CACHE 1;
803
804
805ALTER TABLE vk.drivercategories_id_seq OWNER TO postgres;
806
807--
808-- Name: drivercategories_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
809--
810
811ALTER SEQUENCE vk.drivercategories_id_seq OWNED BY vk.drivercategories.id;
812
813
814--
815-- Name: education_unit; Type: TABLE; Schema: vk; Owner: postgres
816--
817
818CREATE TABLE vk.education_unit (
819    id integer NOT NULL,
820    name text
821);
822
823
824ALTER TABLE vk.education_unit OWNER TO postgres;
825
826--
827-- Name: education_unit_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
828--
829
830CREATE SEQUENCE vk.education_unit_id_seq
831    AS integer
832    START WITH 1
833    INCREMENT BY 1
834    NO MINVALUE
835    NO MAXVALUE
836    CACHE 1;
837
838
839ALTER TABLE vk.education_unit_id_seq OWNER TO postgres;
840
841--
842-- Name: education_unit_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
843--
844
845ALTER SEQUENCE vk.education_unit_id_seq OWNED BY vk.education_unit.id;
846
847
848--
849-- Name: educaton; Type: TABLE; Schema: vk; Owner: postgres
850--
851
852CREATE TABLE vk.educaton (
853    id integer NOT NULL,
854    reservist_id integer,
855    grade integer,
856    spec integer,
857    endofeducation date,
858    unenrollment integer,
859    school_name text
860);
861
862
863ALTER TABLE vk.educaton OWNER TO postgres;
864
865--
866-- Name: educaton_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
867--
868
869CREATE SEQUENCE vk.educaton_id_seq
870    START WITH 1
871    INCREMENT BY 1
872    NO MINVALUE
873    NO MAXVALUE
874    CACHE 1;
875
876
877ALTER TABLE vk.educaton_id_seq OWNER TO postgres;
878
879--
880-- Name: educaton_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
881--
882
883ALTER SEQUENCE vk.educaton_id_seq OWNED BY vk.educaton.id;
884
885
886--
887-- Name: general_staff_team; Type: TABLE; Schema: vk; Owner: postgres
888--
889
890CREATE TABLE vk.general_staff_team (
891    id integer NOT NULL,
892    name text
893);
894
895
896ALTER TABLE vk.general_staff_team OWNER TO postgres;
897
898--
899-- Name: general_staff_team_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
900--
901
902CREATE SEQUENCE vk.general_staff_team_id_seq
903    AS integer
904    START WITH 1
905    INCREMENT BY 1
906    NO MINVALUE
907    NO MAXVALUE
908    CACHE 1;
909
910
911ALTER TABLE vk.general_staff_team_id_seq OWNER TO postgres;
912
913--
914-- Name: general_staff_team_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
915--
916
917ALTER SEQUENCE vk.general_staff_team_id_seq OWNED BY vk.general_staff_team.id;
918
919
920--
921-- Name: gradetype; Type: TABLE; Schema: vk; Owner: postgres
922--
923
924CREATE TABLE vk.gradetype (
925    id integer NOT NULL,
926    name character varying(255) DEFAULT NULL::character varying
927);
928
929
930ALTER TABLE vk.gradetype OWNER TO postgres;
931
932--
933-- Name: gradetype_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
934--
935
936CREATE SEQUENCE vk.gradetype_id_seq
937    START WITH 1
938    INCREMENT BY 1
939    NO MINVALUE
940    NO MAXVALUE
941    CACHE 1;
942
943
944ALTER TABLE vk.gradetype_id_seq OWNER TO postgres;
945
946--
947-- Name: gradetype_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
948--
949
950ALTER SEQUENCE vk.gradetype_id_seq OWNED BY vk.gradetype.id;
951
952
953--
954-- Name: maritalstatus; Type: TABLE; Schema: vk; Owner: postgres
955--
956
957CREATE TABLE vk.maritalstatus (
958    id integer NOT NULL,
959    name character varying(255) DEFAULT NULL::character varying
960);
961
962
963ALTER TABLE vk.maritalstatus OWNER TO postgres;
964
965--
966-- Name: maritalstatus_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
967--
968
969CREATE SEQUENCE vk.maritalstatus_id_seq
970    START WITH 1
971    INCREMENT BY 1
972    NO MINVALUE
973    NO MAXVALUE
974    CACHE 1;
975
976
977ALTER TABLE vk.maritalstatus_id_seq OWNER TO postgres;
978
979--
980-- Name: maritalstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
981--
982
983ALTER SEQUENCE vk.maritalstatus_id_seq OWNED BY vk.maritalstatus.id;
984
985
986--
987-- Name: maritalstatus_parents; Type: TABLE; Schema: vk; Owner: postgres
988--
989
990CREATE TABLE vk.maritalstatus_parents (
991    id integer NOT NULL,
992    name text
993);
994
995
996ALTER TABLE vk.maritalstatus_parents OWNER TO postgres;
997
998--
999-- Name: maritalstatus_parents_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1000--
1001
1002CREATE SEQUENCE vk.maritalstatus_parents_id_seq
1003    AS integer
1004    START WITH 1
1005    INCREMENT BY 1
1006    NO MINVALUE
1007    NO MAXVALUE
1008    CACHE 1;
1009
1010
1011ALTER TABLE vk.maritalstatus_parents_id_seq OWNER TO postgres;
1012
1013--
1014-- Name: maritalstatus_parents_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1015--
1016
1017ALTER SEQUENCE vk.maritalstatus_parents_id_seq OWNED BY vk.maritalstatus_parents.id;
1018
1019
1020--
1021-- Name: marking; Type: TABLE; Schema: vk; Owner: postgres
1022--
1023
1024CREATE TABLE vk.marking (
1025    id integer NOT NULL,
1026    reservist_id integer NOT NULL,
1027    marking_id bigint NOT NULL,
1028    createdata timestamp without time zone,
1029    submarking integer
1030);
1031
1032
1033ALTER TABLE vk.marking OWNER TO postgres;
1034
1035--
1036-- Name: marking_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1037--
1038
1039CREATE SEQUENCE vk.marking_id_seq
1040    START WITH 1
1041    INCREMENT BY 1
1042    NO MINVALUE
1043    NO MAXVALUE
1044    CACHE 1;
1045
1046
1047ALTER TABLE vk.marking_id_seq OWNER TO postgres;
1048
1049--
1050-- Name: marking_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1051--
1052
1053ALTER SEQUENCE vk.marking_id_seq OWNED BY vk.marking.id;
1054
1055
1056--
1057-- Name: markingproperty; Type: TABLE; Schema: vk; Owner: postgres
1058--
1059
1060CREATE TABLE vk.markingproperty (
1061    id integer NOT NULL,
1062    name character varying(255) DEFAULT NULL::character varying
1063);
1064
1065
1066ALTER TABLE vk.markingproperty OWNER TO postgres;
1067
1068--
1069-- Name: markingproperty_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1070--
1071
1072CREATE SEQUENCE vk.markingproperty_id_seq
1073    START WITH 1
1074    INCREMENT BY 1
1075    NO MINVALUE
1076    NO MAXVALUE
1077    CACHE 1;
1078
1079
1080ALTER TABLE vk.markingproperty_id_seq OWNER TO postgres;
1081
1082--
1083-- Name: markingproperty_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1084--
1085
1086ALTER SEQUENCE vk.markingproperty_id_seq OWNED BY vk.markingproperty.id;
1087
1088
1089--
1090-- Name: markingsign; Type: TABLE; Schema: vk; Owner: postgres
1091--
1092
1093CREATE TABLE vk.markingsign (
1094    markingtype_id bigint NOT NULL,
1095    markingproperty_id bigint
1096);
1097
1098
1099ALTER TABLE vk.markingsign OWNER TO postgres;
1100
1101--
1102-- Name: markingtype; Type: TABLE; Schema: vk; Owner: postgres
1103--
1104
1105CREATE TABLE vk.markingtype (
1106    id bigint NOT NULL,
1107    pressmark character varying(45),
1108    name character varying(255)
1109);
1110
1111
1112ALTER TABLE vk.markingtype OWNER TO postgres;
1113
1114--
1115-- Name: medexamination; Type: TABLE; Schema: vk; Owner: postgres
1116--
1117
1118CREATE TABLE vk.medexamination (
1119    id integer NOT NULL,
1120    reservist_id integer,
1121    protocol_number character varying(45),
1122    height integer,
1123    weight double precision,
1124    is_primary smallint DEFAULT 0,
1125    datemedexamination date,
1126    availability_id integer,
1127    soavailability_id integer,
1128    commission_decision integer,
1129    res_id_1 integer,
1130    res_id_2 integer,
1131    res_id_3 integer,
1132    res_id_4 integer,
1133    res_id_5 integer,
1134    res_id_6 integer,
1135    res_id_7 integer,
1136    res_date date,
1137    res_text_1 text,
1138    res_text_2 text,
1139    res_text_3 text,
1140    res_text_4 text,
1141    res_text_5 text
1142);
1143
1144
1145ALTER TABLE vk.medexamination OWNER TO postgres;
1146
1147--
1148-- Name: medexamination_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1149--
1150
1151CREATE SEQUENCE vk.medexamination_id_seq
1152    START WITH 1
1153    INCREMENT BY 1
1154    NO MINVALUE
1155    NO MAXVALUE
1156    CACHE 1;
1157
1158
1159ALTER TABLE vk.medexamination_id_seq OWNER TO postgres;
1160
1161--
1162-- Name: medexamination_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1163--
1164
1165ALTER SEQUENCE vk.medexamination_id_seq OWNED BY vk.medexamination.id;
1166
1167
1168--
1169-- Name: medical_way; Type: TABLE; Schema: vk; Owner: postgres
1170--
1171
1172CREATE TABLE vk.medical_way (
1173    id integer NOT NULL,
1174    name text
1175);
1176
1177
1178ALTER TABLE vk.medical_way OWNER TO postgres;
1179
1180--
1181-- Name: TABLE medical_way; Type: COMMENT; Schema: vk; Owner: postgres
1182--
1183
1184COMMENT ON TABLE vk.medical_way IS 'Р?РчР? Р?апС?Р°Р?Р>РчР?РёС? С?Р>Р?Р?Р°С?С?';
1185
1186
1187--
1188-- Name: medical_way_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1189--
1190
1191CREATE SEQUENCE vk.medical_way_id_seq
1192    AS integer
1193    START WITH 1
1194    INCREMENT BY 1
1195    NO MINVALUE
1196    NO MAXVALUE
1197    CACHE 1;
1198
1199
1200ALTER TABLE vk.medical_way_id_seq OWNER TO postgres;
1201
1202--
1203-- Name: medical_way_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1204--
1205
1206ALTER SEQUENCE vk.medical_way_id_seq OWNED BY vk.medical_way.id;
1207
1208
1209--
1210-- Name: medicalitem; Type: TABLE; Schema: vk; Owner: postgres
1211--
1212
1213CREATE TABLE vk.medicalitem (
1214    id integer NOT NULL,
1215    shortname character varying(45),
1216    fullname character varying(45)
1217);
1218
1219
1220ALTER TABLE vk.medicalitem OWNER TO postgres;
1221
1222--
1223-- Name: medicalitem_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1224--
1225
1226CREATE SEQUENCE vk.medicalitem_id_seq
1227    START WITH 1
1228    INCREMENT BY 1
1229    NO MINVALUE
1230    NO MAXVALUE
1231    CACHE 1;
1232
1233
1234ALTER TABLE vk.medicalitem_id_seq OWNER TO postgres;
1235
1236--
1237-- Name: medicalitem_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1238--
1239
1240ALTER SEQUENCE vk.medicalitem_id_seq OWNED BY vk.medicalitem.id;
1241
1242
1243--
1244-- Name: medicalopinion; Type: TABLE; Schema: vk; Owner: postgres
1245--
1246
1247CREATE TABLE vk.medicalopinion (
1248    id integer NOT NULL,
1249    doctor_id integer,
1250    medicalitem_id integer,
1251    medexamination_id integer
1252);
1253
1254
1255ALTER TABLE vk.medicalopinion OWNER TO postgres;
1256
1257--
1258-- Name: medicalopinion_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1259--
1260
1261CREATE SEQUENCE vk.medicalopinion_id_seq
1262    START WITH 1
1263    INCREMENT BY 1
1264    NO MINVALUE
1265    NO MAXVALUE
1266    CACHE 1;
1267
1268
1269ALTER TABLE vk.medicalopinion_id_seq OWNER TO postgres;
1270
1271--
1272-- Name: medicalopinion_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1273--
1274
1275ALTER SEQUENCE vk.medicalopinion_id_seq OWNED BY vk.medicalopinion.id;
1276
1277
1278--
1279-- Name: municipal; Type: TABLE; Schema: vk; Owner: postgres
1280--
1281
1282CREATE TABLE vk.municipal (
1283    id bigint NOT NULL,
1284    name text,
1285    okato text
1286);
1287
1288
1289ALTER TABLE vk.municipal OWNER TO postgres;
1290
1291--
1292-- Name: nationality; Type: TABLE; Schema: vk; Owner: postgres
1293--
1294
1295CREATE TABLE vk.nationality (
1296    id integer NOT NULL,
1297    name text
1298);
1299
1300
1301ALTER TABLE vk.nationality OWNER TO postgres;
1302
1303--
1304-- Name: nationality_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1305--
1306
1307CREATE SEQUENCE vk.nationality_id_seq
1308    START WITH 1
1309    INCREMENT BY 1
1310    NO MINVALUE
1311    NO MAXVALUE
1312    CACHE 1;
1313
1314
1315ALTER TABLE vk.nationality_id_seq OWNER TO postgres;
1316
1317--
1318-- Name: nationality_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1319--
1320
1321ALTER SEQUENCE vk.nationality_id_seq OWNED BY vk.nationality.id;
1322
1323
1324--
1325-- Name: passport_service; Type: TABLE; Schema: vk; Owner: postgres
1326--
1327
1328CREATE TABLE vk.passport_service (
1329    id integer NOT NULL,
1330    name text
1331);
1332
1333
1334ALTER TABLE vk.passport_service OWNER TO postgres;
1335
1336--
1337-- Name: passport_service_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1338--
1339
1340CREATE SEQUENCE vk.passport_service_id_seq
1341    AS integer
1342    START WITH 1
1343    INCREMENT BY 1
1344    NO MINVALUE
1345    NO MAXVALUE
1346    CACHE 1;
1347
1348
1349ALTER TABLE vk.passport_service_id_seq OWNER TO postgres;
1350
1351--
1352-- Name: passport_service_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1353--
1354
1355ALTER SEQUENCE vk.passport_service_id_seq OWNED BY vk.passport_service.id;
1356
1357
1358--
1359-- Name: registration; Type: TABLE; Schema: vk; Owner: postgres
1360--
1361
1362CREATE TABLE vk.registration (
1363    id integer NOT NULL,
1364    reservist_id integer,
1365    type integer,
1366    date date,
1367    reason integer,
1368    description text
1369);
1370
1371
1372ALTER TABLE vk.registration OWNER TO postgres;
1373
1374--
1375-- Name: registration_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1376--
1377
1378CREATE SEQUENCE vk.registration_id_seq
1379    START WITH 1
1380    INCREMENT BY 1
1381    NO MINVALUE
1382    NO MAXVALUE
1383    CACHE 1;
1384
1385
1386ALTER TABLE vk.registration_id_seq OWNER TO postgres;
1387
1388--
1389-- Name: registration_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1390--
1391
1392ALTER SEQUENCE vk.registration_id_seq OWNED BY vk.registration.id;
1393
1394
1395--
1396-- Name: registrationmark; Type: TABLE; Schema: vk; Owner: postgres
1397--
1398
1399CREATE TABLE vk.registrationmark (
1400    id integer NOT NULL,
1401    name character varying(255) DEFAULT NULL::character varying
1402);
1403
1404
1405ALTER TABLE vk.registrationmark OWNER TO postgres;
1406
1407--
1408-- Name: registrationmark_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1409--
1410
1411CREATE SEQUENCE vk.registrationmark_id_seq
1412    START WITH 1
1413    INCREMENT BY 1
1414    NO MINVALUE
1415    NO MAXVALUE
1416    CACHE 1;
1417
1418
1419ALTER TABLE vk.registrationmark_id_seq OWNER TO postgres;
1420
1421--
1422-- Name: registrationmark_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1423--
1424
1425ALTER SEQUENCE vk.registrationmark_id_seq OWNED BY vk.registrationmark.id;
1426
1427
1428--
1429-- Name: registrationreason; Type: TABLE; Schema: vk; Owner: postgres
1430--
1431
1432CREATE TABLE vk.registrationreason (
1433    id integer NOT NULL,
1434    name character varying(255) DEFAULT NULL::character varying,
1435    type integer
1436);
1437
1438
1439ALTER TABLE vk.registrationreason OWNER TO postgres;
1440
1441--
1442-- Name: registrationreason_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1443--
1444
1445CREATE SEQUENCE vk.registrationreason_id_seq
1446    START WITH 1
1447    INCREMENT BY 1
1448    NO MINVALUE
1449    NO MAXVALUE
1450    CACHE 1;
1451
1452
1453ALTER TABLE vk.registrationreason_id_seq OWNER TO postgres;
1454
1455--
1456-- Name: registrationreason_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1457--
1458
1459ALTER SEQUENCE vk.registrationreason_id_seq OWNED BY vk.registrationreason.id;
1460
1461
1462--
1463-- Name: registrationtype; Type: TABLE; Schema: vk; Owner: postgres
1464--
1465
1466CREATE TABLE vk.registrationtype (
1467    id integer NOT NULL,
1468    name character varying(255) DEFAULT NULL::character varying
1469);
1470
1471
1472ALTER TABLE vk.registrationtype OWNER TO postgres;
1473
1474--
1475-- Name: registrationtype_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1476--
1477
1478CREATE SEQUENCE vk.registrationtype_id_seq
1479    START WITH 1
1480    INCREMENT BY 1
1481    NO MINVALUE
1482    NO MAXVALUE
1483    CACHE 1;
1484
1485
1486ALTER TABLE vk.registrationtype_id_seq OWNER TO postgres;
1487
1488--
1489-- Name: registrationtype_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1490--
1491
1492ALTER SEQUENCE vk.registrationtype_id_seq OWNED BY vk.registrationtype.id;
1493
1494
1495--
1496-- Name: relative; Type: TABLE; Schema: vk; Owner: postgres
1497--
1498
1499CREATE TABLE vk.relative (
1500    id integer NOT NULL,
1501    reservist_id integer,
1502    typerelative integer,
1503    surname character varying(45),
1504    name character varying(45),
1505    secondname character varying(45),
1506    responsibilitystate integer,
1507    can_work smallint,
1508    work_place text
1509);
1510
1511
1512ALTER TABLE vk.relative OWNER TO postgres;
1513
1514--
1515-- Name: relative_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1516--
1517
1518CREATE SEQUENCE vk.relative_id_seq
1519    START WITH 1
1520    INCREMENT BY 1
1521    NO MINVALUE
1522    NO MAXVALUE
1523    CACHE 1;
1524
1525
1526ALTER TABLE vk.relative_id_seq OWNER TO postgres;
1527
1528--
1529-- Name: relative_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1530--
1531
1532ALTER SEQUENCE vk.relative_id_seq OWNED BY vk.relative.id;
1533
1534
1535--
1536-- Name: relatives_address; Type: TABLE; Schema: vk; Owner: postgres
1537--
1538
1539CREATE TABLE vk.relatives_address (
1540    id integer NOT NULL,
1541    relative_id integer NOT NULL,
1542    country_id integer NOT NULL,
1543    postcode character varying(6) DEFAULT NULL::character varying,
1544    region character varying(30) NOT NULL,
1545    type_np_id integer NOT NULL,
1546    city character varying(30) NOT NULL,
1547    district_id integer NOT NULL,
1548    municipal_id integer NOT NULL,
1549    reu_id integer NOT NULL,
1550    street_type_id integer NOT NULL,
1551    street_id integer NOT NULL,
1552    house character varying(10) NOT NULL,
1553    corp integer,
1554    dop character varying(40) DEFAULT NULL::character varying,
1555    flat character varying(10)
1556);
1557
1558
1559ALTER TABLE vk.relatives_address OWNER TO postgres;
1560
1561--
1562-- Name: relatives_address_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1563--
1564
1565CREATE SEQUENCE vk.relatives_address_id_seq
1566    AS integer
1567    START WITH 1
1568    INCREMENT BY 1
1569    NO MINVALUE
1570    NO MAXVALUE
1571    CACHE 1;
1572
1573
1574ALTER TABLE vk.relatives_address_id_seq OWNER TO postgres;
1575
1576--
1577-- Name: relatives_address_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1578--
1579
1580ALTER SEQUENCE vk.relatives_address_id_seq OWNED BY vk.relatives_address.id;
1581
1582
1583--
1584-- Name: reservist; Type: TABLE; Schema: vk; Owner: postgres
1585--
1586
1587CREATE TABLE vk.reservist (
1588    id integer NOT NULL,
1589    surname character varying(50) NOT NULL,
1590    name character varying(50) NOT NULL,
1591    secondname character varying(50) NOT NULL,
1592    birthday date NOT NULL,
1593    personalnumber text NOT NULL,
1594    createdate date NOT NULL,
1595    editdate date,
1596    unregistered smallint NOT NULL,
1597    sverka text,
1598    availability_id integer,
1599    soavailability_id integer
1600);
1601
1602
1603ALTER TABLE vk.reservist OWNER TO postgres;
1604
1605--
1606-- Name: reservist_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1607--
1608
1609CREATE SEQUENCE vk.reservist_id_seq
1610    START WITH 1
1611    INCREMENT BY 1
1612    NO MINVALUE
1613    NO MAXVALUE
1614    CACHE 1;
1615
1616
1617ALTER TABLE vk.reservist_id_seq OWNER TO postgres;
1618
1619--
1620-- Name: reservist_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1621--
1622
1623ALTER SEQUENCE vk.reservist_id_seq OWNED BY vk.reservist.id;
1624
1625
1626--
1627-- Name: responsibility; Type: TABLE; Schema: vk; Owner: postgres
1628--
1629
1630CREATE TABLE vk.responsibility (
1631    id integer NOT NULL,
1632    reservist_id integer,
1633    type integer,
1634    item character varying(45),
1635    createdate date,
1636    limitation date
1637);
1638
1639
1640ALTER TABLE vk.responsibility OWNER TO postgres;
1641
1642--
1643-- Name: responsibility_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1644--
1645
1646CREATE SEQUENCE vk.responsibility_id_seq
1647    START WITH 1
1648    INCREMENT BY 1
1649    NO MINVALUE
1650    NO MAXVALUE
1651    CACHE 1;
1652
1653
1654ALTER TABLE vk.responsibility_id_seq OWNER TO postgres;
1655
1656--
1657-- Name: responsibility_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1658--
1659
1660ALTER SEQUENCE vk.responsibility_id_seq OWNED BY vk.responsibility.id;
1661
1662
1663--
1664-- Name: responsibilitystate; Type: TABLE; Schema: vk; Owner: postgres
1665--
1666
1667CREATE TABLE vk.responsibilitystate (
1668    id integer NOT NULL,
1669    name character varying(255) NOT NULL
1670);
1671
1672
1673ALTER TABLE vk.responsibilitystate OWNER TO postgres;
1674
1675--
1676-- Name: responsibilitystate_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1677--
1678
1679CREATE SEQUENCE vk.responsibilitystate_id_seq
1680    START WITH 1
1681    INCREMENT BY 1
1682    NO MINVALUE
1683    NO MAXVALUE
1684    CACHE 1;
1685
1686
1687ALTER TABLE vk.responsibilitystate_id_seq OWNER TO postgres;
1688
1689--
1690-- Name: responsibilitystate_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1691--
1692
1693ALTER SEQUENCE vk.responsibilitystate_id_seq OWNED BY vk.responsibilitystate.id;
1694
1695
1696--
1697-- Name: responsibilitytype; Type: TABLE; Schema: vk; Owner: postgres
1698--
1699
1700CREATE TABLE vk.responsibilitytype (
1701    id integer NOT NULL,
1702    name character varying(255) DEFAULT NULL::character varying
1703);
1704
1705
1706ALTER TABLE vk.responsibilitytype OWNER TO postgres;
1707
1708--
1709-- Name: responsibilitytype_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1710--
1711
1712CREATE SEQUENCE vk.responsibilitytype_id_seq
1713    START WITH 1
1714    INCREMENT BY 1
1715    NO MINVALUE
1716    NO MAXVALUE
1717    CACHE 1;
1718
1719
1720ALTER TABLE vk.responsibilitytype_id_seq OWNER TO postgres;
1721
1722--
1723-- Name: responsibilitytype_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1724--
1725
1726ALTER SEQUENCE vk.responsibilitytype_id_seq OWNED BY vk.responsibilitytype.id;
1727
1728
1729--
1730-- Name: resultcall; Type: TABLE; Schema: vk; Owner: postgres
1731--
1732
1733CREATE TABLE vk.resultcall (
1734    id integer NOT NULL,
1735    name character varying(255) DEFAULT NULL::character varying
1736);
1737
1738
1739ALTER TABLE vk.resultcall OWNER TO postgres;
1740
1741--
1742-- Name: resultcall_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1743--
1744
1745CREATE SEQUENCE vk.resultcall_id_seq
1746    START WITH 1
1747    INCREMENT BY 1
1748    NO MINVALUE
1749    NO MAXVALUE
1750    CACHE 1;
1751
1752
1753ALTER TABLE vk.resultcall_id_seq OWNER TO postgres;
1754
1755--
1756-- Name: resultcall_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1757--
1758
1759ALTER SEQUENCE vk.resultcall_id_seq OWNED BY vk.resultcall.id;
1760
1761
1762--
1763-- Name: resulttogovementcall; Type: TABLE; Schema: vk; Owner: postgres
1764--
1765
1766CREATE TABLE vk.resulttogovementcall (
1767    id integer NOT NULL,
1768    name character varying(255) DEFAULT NULL::character varying
1769);
1770
1771
1772ALTER TABLE vk.resulttogovementcall OWNER TO postgres;
1773
1774--
1775-- Name: resulttogovementcall_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1776--
1777
1778CREATE SEQUENCE vk.resulttogovementcall_id_seq
1779    START WITH 1
1780    INCREMENT BY 1
1781    NO MINVALUE
1782    NO MAXVALUE
1783    CACHE 1;
1784
1785
1786ALTER TABLE vk.resulttogovementcall_id_seq OWNER TO postgres;
1787
1788--
1789-- Name: resulttogovementcall_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1790--
1791
1792ALTER SEQUENCE vk.resulttogovementcall_id_seq OWNED BY vk.resulttogovementcall.id;
1793
1794
1795--
1796-- Name: reu; Type: TABLE; Schema: vk; Owner: postgres
1797--
1798
1799CREATE TABLE vk.reu (
1800    id bigint NOT NULL,
1801    name character varying(255) DEFAULT NULL::character varying
1802);
1803
1804
1805ALTER TABLE vk.reu OWNER TO postgres;
1806
1807--
1808-- Name: reu_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1809--
1810
1811CREATE SEQUENCE vk.reu_id_seq
1812    START WITH 1
1813    INCREMENT BY 1
1814    NO MINVALUE
1815    NO MAXVALUE
1816    CACHE 1;
1817
1818
1819ALTER TABLE vk.reu_id_seq OWNER TO postgres;
1820
1821--
1822-- Name: reu_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1823--
1824
1825ALTER SEQUENCE vk.reu_id_seq OWNED BY vk.reu.id;
1826
1827
1828--
1829-- Name: side_info; Type: TABLE; Schema: vk; Owner: postgres
1830--
1831
1832CREATE TABLE vk.side_info (
1833    id integer NOT NULL,
1834    reservist_id integer,
1835    maritalstatus integer,
1836    male integer,
1837    phone character varying(45),
1838    mobilphone character varying(45),
1839    nationality integer,
1840    responsibilitystate integer,
1841    maritalstatus_parents integer,
1842    workplace text,
1843    workspec text,
1844    gos_tayna text,
1845    otsrochka_date date,
1846    otsrochka_vuz text,
1847    otsrochka_protokol text,
1848    otsrochka smallint
1849);
1850
1851
1852ALTER TABLE vk.side_info OWNER TO postgres;
1853
1854--
1855-- Name: side_info_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1856--
1857
1858CREATE SEQUENCE vk.side_info_id_seq
1859    START WITH 1
1860    INCREMENT BY 1
1861    NO MINVALUE
1862    NO MAXVALUE
1863    CACHE 1;
1864
1865
1866ALTER TABLE vk.side_info_id_seq OWNER TO postgres;
1867
1868--
1869-- Name: side_info_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1870--
1871
1872ALTER SEQUENCE vk.side_info_id_seq OWNED BY vk.side_info.id;
1873
1874
1875--
1876-- Name: soavailability; Type: TABLE; Schema: vk; Owner: postgres
1877--
1878
1879CREATE TABLE vk.soavailability (
1880    id integer NOT NULL,
1881    availability_id integer,
1882    shortname character varying(45)
1883);
1884
1885
1886ALTER TABLE vk.soavailability OWNER TO postgres;
1887
1888--
1889-- Name: soavailability_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1890--
1891
1892CREATE SEQUENCE vk.soavailability_id_seq
1893    START WITH 1
1894    INCREMENT BY 1
1895    NO MINVALUE
1896    NO MAXVALUE
1897    CACHE 1;
1898
1899
1900ALTER TABLE vk.soavailability_id_seq OWNER TO postgres;
1901
1902--
1903-- Name: soavailability_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1904--
1905
1906ALTER SEQUENCE vk.soavailability_id_seq OWNED BY vk.soavailability.id;
1907
1908
1909--
1910-- Name: speciality; Type: TABLE; Schema: vk; Owner: postgres
1911--
1912
1913CREATE TABLE vk.speciality (
1914    id integer NOT NULL,
1915    name character varying(255) DEFAULT NULL::character varying,
1916    speccode character varying(45)
1917);
1918
1919
1920ALTER TABLE vk.speciality OWNER TO postgres;
1921
1922--
1923-- Name: speciality_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1924--
1925
1926CREATE SEQUENCE vk.speciality_id_seq
1927    START WITH 1
1928    INCREMENT BY 1
1929    NO MINVALUE
1930    NO MAXVALUE
1931    CACHE 1;
1932
1933
1934ALTER TABLE vk.speciality_id_seq OWNER TO postgres;
1935
1936--
1937-- Name: speciality_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1938--
1939
1940ALTER SEQUENCE vk.speciality_id_seq OWNED BY vk.speciality.id;
1941
1942
1943--
1944-- Name: street_type; Type: TABLE; Schema: vk; Owner: postgres
1945--
1946
1947CREATE TABLE vk.street_type (
1948    id integer NOT NULL,
1949    type character varying(10) NOT NULL,
1950    name character varying(50) NOT NULL
1951);
1952
1953
1954ALTER TABLE vk.street_type OWNER TO postgres;
1955
1956--
1957-- Name: street_type_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1958--
1959
1960CREATE SEQUENCE vk.street_type_id_seq
1961    START WITH 1
1962    INCREMENT BY 1
1963    NO MINVALUE
1964    NO MAXVALUE
1965    CACHE 1;
1966
1967
1968ALTER TABLE vk.street_type_id_seq OWNER TO postgres;
1969
1970--
1971-- Name: street_type_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
1972--
1973
1974ALTER SEQUENCE vk.street_type_id_seq OWNED BY vk.street_type.id;
1975
1976
1977--
1978-- Name: streets; Type: TABLE; Schema: vk; Owner: postgres
1979--
1980
1981CREATE TABLE vk.streets (
1982    id integer NOT NULL,
1983    name text
1984);
1985
1986
1987ALTER TABLE vk.streets OWNER TO postgres;
1988
1989--
1990-- Name: streets_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
1991--
1992
1993CREATE SEQUENCE vk.streets_id_seq
1994    AS integer
1995    START WITH 1
1996    INCREMENT BY 1
1997    NO MINVALUE
1998    NO MAXVALUE
1999    CACHE 1;
2000
2001
2002ALTER TABLE vk.streets_id_seq OWNER TO postgres;
2003
2004--
2005-- Name: streets_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
2006--
2007
2008ALTER SEQUENCE vk.streets_id_seq OWNED BY vk.streets.id;
2009
2010
2011--
2012-- Name: submarkingtype; Type: TABLE; Schema: vk; Owner: postgres
2013--
2014
2015CREATE TABLE vk.submarkingtype (
2016    id integer NOT NULL,
2017    pressmark character varying(45)
2018);
2019
2020
2021ALTER TABLE vk.submarkingtype OWNER TO postgres;
2022
2023--
2024-- Name: submarkingtype_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
2025--
2026
2027CREATE SEQUENCE vk.submarkingtype_id_seq
2028    AS integer
2029    START WITH 1
2030    INCREMENT BY 1
2031    NO MINVALUE
2032    NO MAXVALUE
2033    CACHE 1;
2034
2035
2036ALTER TABLE vk.submarkingtype_id_seq OWNER TO postgres;
2037
2038--
2039-- Name: submarkingtype_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
2040--
2041
2042ALTER SEQUENCE vk.submarkingtype_id_seq OWNED BY vk.submarkingtype.id;
2043
2044
2045--
2046-- Name: type_np; Type: TABLE; Schema: vk; Owner: postgres
2047--
2048
2049CREATE TABLE vk.type_np (
2050    id integer NOT NULL,
2051    type character varying(6) NOT NULL,
2052    name character varying(30) NOT NULL
2053);
2054
2055
2056ALTER TABLE vk.type_np OWNER TO postgres;
2057
2058--
2059-- Name: type_np_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
2060--
2061
2062CREATE SEQUENCE vk.type_np_id_seq
2063    START WITH 1
2064    INCREMENT BY 1
2065    NO MINVALUE
2066    NO MAXVALUE
2067    CACHE 1;
2068
2069
2070ALTER TABLE vk.type_np_id_seq OWNER TO postgres;
2071
2072--
2073-- Name: type_np_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
2074--
2075
2076ALTER SEQUENCE vk.type_np_id_seq OWNED BY vk.type_np.id;
2077
2078
2079--
2080-- Name: typerelative; Type: TABLE; Schema: vk; Owner: postgres
2081--
2082
2083CREATE TABLE vk.typerelative (
2084    id integer NOT NULL,
2085    name character varying(255) DEFAULT NULL::character varying
2086);
2087
2088
2089ALTER TABLE vk.typerelative OWNER TO postgres;
2090
2091--
2092-- Name: typerelative_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
2093--
2094
2095CREATE SEQUENCE vk.typerelative_id_seq
2096    START WITH 1
2097    INCREMENT BY 1
2098    NO MINVALUE
2099    NO MAXVALUE
2100    CACHE 1;
2101
2102
2103ALTER TABLE vk.typerelative_id_seq OWNER TO postgres;
2104
2105--
2106-- Name: typerelative_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
2107--
2108
2109ALTER SEQUENCE vk.typerelative_id_seq OWNED BY vk.typerelative.id;
2110
2111
2112--
2113-- Name: unenrollmenttype; Type: TABLE; Schema: vk; Owner: postgres
2114--
2115
2116CREATE TABLE vk.unenrollmenttype (
2117    id integer NOT NULL,
2118    name character varying(255) DEFAULT NULL::character varying
2119);
2120
2121
2122ALTER TABLE vk.unenrollmenttype OWNER TO postgres;
2123
2124--
2125-- Name: unenrollmenttype_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
2126--
2127
2128CREATE SEQUENCE vk.unenrollmenttype_id_seq
2129    START WITH 1
2130    INCREMENT BY 1
2131    NO MINVALUE
2132    NO MAXVALUE
2133    CACHE 1;
2134
2135
2136ALTER TABLE vk.unenrollmenttype_id_seq OWNER TO postgres;
2137
2138--
2139-- Name: unenrollmenttype_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
2140--
2141
2142ALTER SEQUENCE vk.unenrollmenttype_id_seq OWNED BY vk.unenrollmenttype.id;
2143
2144
2145--
2146-- Name: vus; Type: TABLE; Schema: vk; Owner: postgres
2147--
2148
2149CREATE TABLE vk.vus (
2150    id integer NOT NULL,
2151    name text
2152);
2153
2154
2155ALTER TABLE vk.vus OWNER TO postgres;
2156
2157--
2158-- Name: vus_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
2159--
2160
2161CREATE SEQUENCE vk.vus_id_seq
2162    AS integer
2163    START WITH 1
2164    INCREMENT BY 1
2165    NO MINVALUE
2166    NO MAXVALUE
2167    CACHE 1;
2168
2169
2170ALTER TABLE vk.vus_id_seq OWNER TO postgres;
2171
2172--
2173-- Name: vus_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
2174--
2175
2176ALTER SEQUENCE vk.vus_id_seq OWNED BY vk.vus.id;
2177
2178
2179--
2180-- Name: workplace; Type: TABLE; Schema: vk; Owner: postgres
2181--
2182
2183CREATE TABLE vk.workplace (
2184    id integer NOT NULL,
2185    reservist_id integer,
2186    name text
2187);
2188
2189
2190ALTER TABLE vk.workplace OWNER TO postgres;
2191
2192--
2193-- Name: workplace_id_seq; Type: SEQUENCE; Schema: vk; Owner: postgres
2194--
2195
2196CREATE SEQUENCE vk.workplace_id_seq
2197    START WITH 1
2198    INCREMENT BY 1
2199    NO MINVALUE
2200    NO MAXVALUE
2201    CACHE 1;
2202
2203
2204ALTER TABLE vk.workplace_id_seq OWNER TO postgres;
2205
2206--
2207-- Name: workplace_id_seq; Type: SEQUENCE OWNED BY; Schema: vk; Owner: postgres
2208--
2209
2210ALTER SEQUENCE vk.workplace_id_seq OWNED BY vk.workplace.id;
2211
2212
2213--
2214-- Name: autorization; Type: TABLE; Schema: vk_system; Owner: postgres
2215--
2216
2217CREATE TABLE vk_system.autorization (
2218    id integer NOT NULL,
2219    login text,
2220    pass text
2221);
2222
2223
2224ALTER TABLE vk_system.autorization OWNER TO postgres;
2225
2226--
2227-- Name: autorization_id_seq; Type: SEQUENCE; Schema: vk_system; Owner: postgres
2228--
2229
2230CREATE SEQUENCE vk_system.autorization_id_seq
2231    AS integer
2232    START WITH 1
2233    INCREMENT BY 1
2234    NO MINVALUE
2235    NO MAXVALUE
2236    CACHE 1;
2237
2238
2239ALTER TABLE vk_system.autorization_id_seq OWNER TO postgres;
2240
2241--
2242-- Name: autorization_id_seq; Type: SEQUENCE OWNED BY; Schema: vk_system; Owner: postgres
2243--
2244
2245ALTER SEQUENCE vk_system.autorization_id_seq OWNED BY vk_system.autorization.id;
2246
2247
2248--
2249-- Name: log; Type: TABLE; Schema: vk_system; Owner: postgres
2250--
2251
2252CREATE TABLE vk_system.log (
2253    id integer NOT NULL,
2254    who text,
2255    querry text,
2256    date timestamp without time zone,
2257    reservist_id integer
2258);
2259
2260
2261ALTER TABLE vk_system.log OWNER TO postgres;
2262
2263--
2264-- Name: log_dictionaries; Type: TABLE; Schema: vk_system; Owner: postgres
2265--
2266
2267CREATE TABLE vk_system.log_dictionaries (
2268    id integer NOT NULL,
2269    who text,
2270    querry text,
2271    date timestamp without time zone
2272);
2273
2274
2275ALTER TABLE vk_system.log_dictionaries OWNER TO postgres;
2276
2277--
2278-- Name: log_dictionaries_id_seq; Type: SEQUENCE; Schema: vk_system; Owner: postgres
2279--
2280
2281CREATE SEQUENCE vk_system.log_dictionaries_id_seq
2282    AS integer
2283    START WITH 1
2284    INCREMENT BY 1
2285    NO MINVALUE
2286    NO MAXVALUE
2287    CACHE 1;
2288
2289
2290ALTER TABLE vk_system.log_dictionaries_id_seq OWNER TO postgres;
2291
2292--
2293-- Name: log_dictionaries_id_seq; Type: SEQUENCE OWNED BY; Schema: vk_system; Owner: postgres
2294--
2295
2296ALTER SEQUENCE vk_system.log_dictionaries_id_seq OWNED BY vk_system.log_dictionaries.id;
2297
2298
2299--
2300-- Name: log_id_seq; Type: SEQUENCE; Schema: vk_system; Owner: postgres
2301--
2302
2303CREATE SEQUENCE vk_system.log_id_seq
2304    AS integer
2305    START WITH 1
2306    INCREMENT BY 1
2307    NO MINVALUE
2308    NO MAXVALUE
2309    CACHE 1;
2310
2311
2312ALTER TABLE vk_system.log_id_seq OWNER TO postgres;
2313
2314--
2315-- Name: log_id_seq; Type: SEQUENCE OWNED BY; Schema: vk_system; Owner: postgres
2316--
2317
2318ALTER SEQUENCE vk_system.log_id_seq OWNED BY vk_system.log.id;
2319
2320
2321--
2322-- Name: address id; Type: DEFAULT; Schema: vk; Owner: postgres
2323--
2324
2325ALTER TABLE ONLY vk.address ALTER COLUMN id SET DEFAULT nextval('vk.address_id_seq'::regclass);
2326
2327
2328--
2329-- Name: addresstype id; Type: DEFAULT; Schema: vk; Owner: postgres
2330--
2331
2332ALTER TABLE ONLY vk.addresstype ALTER COLUMN id SET DEFAULT nextval('vk.addresstype_id_seq'::regclass);
2333
2334
2335--
2336-- Name: armytype id; Type: DEFAULT; Schema: vk; Owner: postgres
2337--
2338
2339ALTER TABLE ONLY vk.armytype ALTER COLUMN id SET DEFAULT nextval('vk.armytype_id_seq'::regclass);
2340
2341
2342--
2343-- Name: availability id; Type: DEFAULT; Schema: vk; Owner: postgres
2344--
2345
2346ALTER TABLE ONLY vk.availability ALTER COLUMN id SET DEFAULT nextval('vk.availability_id_seq'::regclass);
2347
2348
2349--
2350-- Name: call id; Type: DEFAULT; Schema: vk; Owner: postgres
2351--
2352
2353ALTER TABLE ONLY vk.call ALTER COLUMN id SET DEFAULT nextval('vk.call_id_seq'::regclass);
2354
2355
2356--
2357-- Name: calltogovement id; Type: DEFAULT; Schema: vk; Owner: postgres
2358--
2359
2360ALTER TABLE ONLY vk.calltogovement ALTER COLUMN id SET DEFAULT nextval('vk.calltogovement_id_seq'::regclass);
2361
2362
2363--
2364-- Name: calltogovementtype id; Type: DEFAULT; Schema: vk; Owner: postgres
2365--
2366
2367ALTER TABLE ONLY vk.calltogovementtype ALTER COLUMN id SET DEFAULT nextval('vk.calltogovementtype_id_seq'::regclass);
2368
2369
2370--
2371-- Name: calltype id; Type: DEFAULT; Schema: vk; Owner: postgres
2372--
2373
2374ALTER TABLE ONLY vk.calltype ALTER COLUMN id SET DEFAULT nextval('vk.calltype_id_seq'::regclass);
2375
2376
2377--
2378-- Name: commission_decision id; Type: DEFAULT; Schema: vk; Owner: postgres
2379--
2380
2381ALTER TABLE ONLY vk.commission_decision ALTER COLUMN id SET DEFAULT nextval('vk.commission_decision_id_seq'::regclass);
2382
2383
2384--
2385-- Name: commission_decision_base id; Type: DEFAULT; Schema: vk; Owner: postgres
2386--
2387
2388ALTER TABLE ONLY vk.commission_decision_base ALTER COLUMN id SET DEFAULT nextval('vk.commission_decision_base_id_seq'::regclass);
2389
2390
2391--
2392-- Name: country id; Type: DEFAULT; Schema: vk; Owner: postgres
2393--
2394
2395ALTER TABLE ONLY vk.country ALTER COLUMN id SET DEFAULT nextval('vk.country_id_seq'::regclass);
2396
2397
2398--
2399-- Name: delay id; Type: DEFAULT; Schema: vk; Owner: postgres
2400--
2401
2402ALTER TABLE ONLY vk.delay ALTER COLUMN id SET DEFAULT nextval('vk.delay_id_seq'::regclass);
2403
2404
2405--
2406-- Name: delay_priziv id; Type: DEFAULT; Schema: vk; Owner: postgres
2407--
2408
2409ALTER TABLE ONLY vk.delay_priziv ALTER COLUMN id SET DEFAULT nextval('vk.delay_priziv_id_seq'::regclass);
2410
2411
2412--
2413-- Name: district id; Type: DEFAULT; Schema: vk; Owner: postgres
2414--
2415
2416ALTER TABLE ONLY vk.district ALTER COLUMN id SET DEFAULT nextval('vk.district_id_seq'::regclass);
2417
2418
2419--
2420-- Name: doc id; Type: DEFAULT; Schema: vk; Owner: postgres
2421--
2422
2423ALTER TABLE ONLY vk.doc ALTER COLUMN id SET DEFAULT nextval('vk.doc_id_seq'::regclass);
2424
2425
2426--
2427-- Name: doc rv_id; Type: DEFAULT; Schema: vk; Owner: postgres
2428--
2429
2430ALTER TABLE ONLY vk.doc ALTER COLUMN rv_id SET DEFAULT nextval('vk.doc_rv_id_seq'::regclass);
2431
2432
2433--
2434-- Name: doc type_id; Type: DEFAULT; Schema: vk; Owner: postgres
2435--
2436
2437ALTER TABLE ONLY vk.doc ALTER COLUMN type_id SET DEFAULT nextval('vk.doc_type_id_seq'::regclass);
2438
2439
2440--
2441-- Name: doctor id; Type: DEFAULT; Schema: vk; Owner: postgres
2442--
2443
2444ALTER TABLE ONLY vk.doctor ALTER COLUMN id SET DEFAULT nextval('vk.doctor_id_seq'::regclass);
2445
2446
2447--
2448-- Name: doctype id; Type: DEFAULT; Schema: vk; Owner: postgres
2449--
2450
2451ALTER TABLE ONLY vk.doctype ALTER COLUMN id SET DEFAULT nextval('vk.doctype_id_seq'::regclass);
2452
2453
2454--
2455-- Name: dosaaf id; Type: DEFAULT; Schema: vk; Owner: postgres
2456--
2457
2458ALTER TABLE ONLY vk.dosaaf ALTER COLUMN id SET DEFAULT nextval('vk.dosaaf_id_seq'::regclass);
2459
2460
2461--
2462-- Name: drivercategories id; Type: DEFAULT; Schema: vk; Owner: postgres
2463--
2464
2465ALTER TABLE ONLY vk.drivercategories ALTER COLUMN id SET DEFAULT nextval('vk.drivercategories_id_seq'::regclass);
2466
2467
2468--
2469-- Name: education_unit id; Type: DEFAULT; Schema: vk; Owner: postgres
2470--
2471
2472ALTER TABLE ONLY vk.education_unit ALTER COLUMN id SET DEFAULT nextval('vk.education_unit_id_seq'::regclass);
2473
2474
2475--
2476-- Name: educaton id; Type: DEFAULT; Schema: vk; Owner: postgres
2477--
2478
2479ALTER TABLE ONLY vk.educaton ALTER COLUMN id SET DEFAULT nextval('vk.educaton_id_seq'::regclass);
2480
2481
2482--
2483-- Name: general_staff_team id; Type: DEFAULT; Schema: vk; Owner: postgres
2484--
2485
2486ALTER TABLE ONLY vk.general_staff_team ALTER COLUMN id SET DEFAULT nextval('vk.general_staff_team_id_seq'::regclass);
2487
2488
2489--
2490-- Name: gradetype id; Type: DEFAULT; Schema: vk; Owner: postgres
2491--
2492
2493ALTER TABLE ONLY vk.gradetype ALTER COLUMN id SET DEFAULT nextval('vk.gradetype_id_seq'::regclass);
2494
2495
2496--
2497-- Name: maritalstatus id; Type: DEFAULT; Schema: vk; Owner: postgres
2498--
2499
2500ALTER TABLE ONLY vk.maritalstatus ALTER COLUMN id SET DEFAULT nextval('vk.maritalstatus_id_seq'::regclass);
2501
2502
2503--
2504-- Name: maritalstatus_parents id; Type: DEFAULT; Schema: vk; Owner: postgres
2505--
2506
2507ALTER TABLE ONLY vk.maritalstatus_parents ALTER COLUMN id SET DEFAULT nextval('vk.maritalstatus_parents_id_seq'::regclass);
2508
2509
2510--
2511-- Name: marking id; Type: DEFAULT; Schema: vk; Owner: postgres
2512--
2513
2514ALTER TABLE ONLY vk.marking ALTER COLUMN id SET DEFAULT nextval('vk.marking_id_seq'::regclass);
2515
2516
2517--
2518-- Name: markingproperty id; Type: DEFAULT; Schema: vk; Owner: postgres
2519--
2520
2521ALTER TABLE ONLY vk.markingproperty ALTER COLUMN id SET DEFAULT nextval('vk.markingproperty_id_seq'::regclass);
2522
2523
2524--
2525-- Name: medexamination id; Type: DEFAULT; Schema: vk; Owner: postgres
2526--
2527
2528ALTER TABLE ONLY vk.medexamination ALTER COLUMN id SET DEFAULT nextval('vk.medexamination_id_seq'::regclass);
2529
2530
2531--
2532-- Name: medical_way id; Type: DEFAULT; Schema: vk; Owner: postgres
2533--
2534
2535ALTER TABLE ONLY vk.medical_way ALTER COLUMN id SET DEFAULT nextval('vk.medical_way_id_seq'::regclass);
2536
2537
2538--
2539-- Name: medicalitem id; Type: DEFAULT; Schema: vk; Owner: postgres
2540--
2541
2542ALTER TABLE ONLY vk.medicalitem ALTER COLUMN id SET DEFAULT nextval('vk.medicalitem_id_seq'::regclass);
2543
2544
2545--
2546-- Name: medicalopinion id; Type: DEFAULT; Schema: vk; Owner: postgres
2547--
2548
2549ALTER TABLE ONLY vk.medicalopinion ALTER COLUMN id SET DEFAULT nextval('vk.medicalopinion_id_seq'::regclass);
2550
2551
2552--
2553-- Name: nationality id; Type: DEFAULT; Schema: vk; Owner: postgres
2554--
2555
2556ALTER TABLE ONLY vk.nationality ALTER COLUMN id SET DEFAULT nextval('vk.nationality_id_seq'::regclass);
2557
2558
2559--
2560-- Name: passport_service id; Type: DEFAULT; Schema: vk; Owner: postgres
2561--
2562
2563ALTER TABLE ONLY vk.passport_service ALTER COLUMN id SET DEFAULT nextval('vk.passport_service_id_seq'::regclass);
2564
2565
2566--
2567-- Name: registration id; Type: DEFAULT; Schema: vk; Owner: postgres
2568--
2569
2570ALTER TABLE ONLY vk.registration ALTER COLUMN id SET DEFAULT nextval('vk.registration_id_seq'::regclass);
2571
2572
2573--
2574-- Name: registrationmark id; Type: DEFAULT; Schema: vk; Owner: postgres
2575--
2576
2577ALTER TABLE ONLY vk.registrationmark ALTER COLUMN id SET DEFAULT nextval('vk.registrationmark_id_seq'::regclass);
2578
2579
2580--
2581-- Name: registrationreason id; Type: DEFAULT; Schema: vk; Owner: postgres
2582--
2583
2584ALTER TABLE ONLY vk.registrationreason ALTER COLUMN id SET DEFAULT nextval('vk.registrationreason_id_seq'::regclass);
2585
2586
2587--
2588-- Name: registrationtype id; Type: DEFAULT; Schema: vk; Owner: postgres
2589--
2590
2591ALTER TABLE ONLY vk.registrationtype ALTER COLUMN id SET DEFAULT nextval('vk.registrationtype_id_seq'::regclass);
2592
2593
2594--
2595-- Name: relative id; Type: DEFAULT; Schema: vk; Owner: postgres
2596--
2597
2598ALTER TABLE ONLY vk.relative ALTER COLUMN id SET DEFAULT nextval('vk.relative_id_seq'::regclass);
2599
2600
2601--
2602-- Name: relatives_address id; Type: DEFAULT; Schema: vk; Owner: postgres
2603--
2604
2605ALTER TABLE ONLY vk.relatives_address ALTER COLUMN id SET DEFAULT nextval('vk.relatives_address_id_seq'::regclass);
2606
2607
2608--
2609-- Name: reservist id; Type: DEFAULT; Schema: vk; Owner: postgres
2610--
2611
2612ALTER TABLE ONLY vk.reservist ALTER COLUMN id SET DEFAULT nextval('vk.reservist_id_seq'::regclass);
2613
2614
2615--
2616-- Name: responsibility id; Type: DEFAULT; Schema: vk; Owner: postgres
2617--
2618
2619ALTER TABLE ONLY vk.responsibility ALTER COLUMN id SET DEFAULT nextval('vk.responsibility_id_seq'::regclass);
2620
2621
2622--
2623-- Name: responsibilitystate id; Type: DEFAULT; Schema: vk; Owner: postgres
2624--
2625
2626ALTER TABLE ONLY vk.responsibilitystate ALTER COLUMN id SET DEFAULT nextval('vk.responsibilitystate_id_seq'::regclass);
2627
2628
2629--
2630-- Name: responsibilitytype id; Type: DEFAULT; Schema: vk; Owner: postgres
2631--
2632
2633ALTER TABLE ONLY vk.responsibilitytype ALTER COLUMN id SET DEFAULT nextval('vk.responsibilitytype_id_seq'::regclass);
2634
2635
2636--
2637-- Name: resultcall id; Type: DEFAULT; Schema: vk; Owner: postgres
2638--
2639
2640ALTER TABLE ONLY vk.resultcall ALTER COLUMN id SET DEFAULT nextval('vk.resultcall_id_seq'::regclass);
2641
2642
2643--
2644-- Name: resulttogovementcall id; Type: DEFAULT; Schema: vk; Owner: postgres
2645--
2646
2647ALTER TABLE ONLY vk.resulttogovementcall ALTER COLUMN id SET DEFAULT nextval('vk.resulttogovementcall_id_seq'::regclass);
2648
2649
2650--
2651-- Name: reu id; Type: DEFAULT; Schema: vk; Owner: postgres
2652--
2653
2654ALTER TABLE ONLY vk.reu ALTER COLUMN id SET DEFAULT nextval('vk.reu_id_seq'::regclass);
2655
2656
2657--
2658-- Name: side_info id; Type: DEFAULT; Schema: vk; Owner: postgres
2659--
2660
2661ALTER TABLE ONLY vk.side_info ALTER COLUMN id SET DEFAULT nextval('vk.side_info_id_seq'::regclass);
2662
2663
2664--
2665-- Name: soavailability id; Type: DEFAULT; Schema: vk; Owner: postgres
2666--
2667
2668ALTER TABLE ONLY vk.soavailability ALTER COLUMN id SET DEFAULT nextval('vk.soavailability_id_seq'::regclass);
2669
2670
2671--
2672-- Name: speciality id; Type: DEFAULT; Schema: vk; Owner: postgres
2673--
2674
2675ALTER TABLE ONLY vk.speciality ALTER COLUMN id SET DEFAULT nextval('vk.speciality_id_seq'::regclass);
2676
2677
2678--
2679-- Name: street_type id; Type: DEFAULT; Schema: vk; Owner: postgres
2680--
2681
2682ALTER TABLE ONLY vk.street_type ALTER COLUMN id SET DEFAULT nextval('vk.street_type_id_seq'::regclass);
2683
2684
2685--
2686-- Name: streets id; Type: DEFAULT; Schema: vk; Owner: postgres
2687--
2688
2689ALTER TABLE ONLY vk.streets ALTER COLUMN id SET DEFAULT nextval('vk.streets_id_seq'::regclass);
2690
2691
2692--
2693-- Name: submarkingtype id; Type: DEFAULT; Schema: vk; Owner: postgres
2694--
2695
2696ALTER TABLE ONLY vk.submarkingtype ALTER COLUMN id SET DEFAULT nextval('vk.submarkingtype_id_seq'::regclass);
2697
2698
2699--
2700-- Name: type_np id; Type: DEFAULT; Schema: vk; Owner: postgres
2701--
2702
2703ALTER TABLE ONLY vk.type_np ALTER COLUMN id SET DEFAULT nextval('vk.type_np_id_seq'::regclass);
2704
2705
2706--
2707-- Name: typerelative id; Type: DEFAULT; Schema: vk; Owner: postgres
2708--
2709
2710ALTER TABLE ONLY vk.typerelative ALTER COLUMN id SET DEFAULT nextval('vk.typerelative_id_seq'::regclass);
2711
2712
2713--
2714-- Name: unenrollmenttype id; Type: DEFAULT; Schema: vk; Owner: postgres
2715--
2716
2717ALTER TABLE ONLY vk.unenrollmenttype ALTER COLUMN id SET DEFAULT nextval('vk.unenrollmenttype_id_seq'::regclass);
2718
2719
2720--
2721-- Name: vus id; Type: DEFAULT; Schema: vk; Owner: postgres
2722--
2723
2724ALTER TABLE ONLY vk.vus ALTER COLUMN id SET DEFAULT nextval('vk.vus_id_seq'::regclass);
2725
2726
2727--
2728-- Name: workplace id; Type: DEFAULT; Schema: vk; Owner: postgres
2729--
2730
2731ALTER TABLE ONLY vk.workplace ALTER COLUMN id SET DEFAULT nextval('vk.workplace_id_seq'::regclass);
2732
2733
2734--
2735-- Name: autorization id; Type: DEFAULT; Schema: vk_system; Owner: postgres
2736--
2737
2738ALTER TABLE ONLY vk_system.autorization ALTER COLUMN id SET DEFAULT nextval('vk_system.autorization_id_seq'::regclass);
2739
2740
2741--
2742-- Name: log id; Type: DEFAULT; Schema: vk_system; Owner: postgres
2743--
2744
2745ALTER TABLE ONLY vk_system.log ALTER COLUMN id SET DEFAULT nextval('vk_system.log_id_seq'::regclass);
2746
2747
2748--
2749-- Name: log_dictionaries id; Type: DEFAULT; Schema: vk_system; Owner: postgres
2750--
2751
2752ALTER TABLE ONLY vk_system.log_dictionaries ALTER COLUMN id SET DEFAULT nextval('vk_system.log_dictionaries_id_seq'::regclass);
2753
2754
2755--
2756-- Name: address address_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2757--
2758
2759ALTER TABLE ONLY vk.address
2760    ADD CONSTRAINT address_pkey PRIMARY KEY (id, reservist_id, country_id, type_np_id, district_id, reu_id, street_type_id);
2761
2762
2763--
2764-- Name: addresstype addresstype_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2765--
2766
2767ALTER TABLE ONLY vk.addresstype
2768    ADD CONSTRAINT addresstype_pkey PRIMARY KEY (id);
2769
2770
2771--
2772-- Name: availability availability_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2773--
2774
2775ALTER TABLE ONLY vk.availability
2776    ADD CONSTRAINT availability_pkey PRIMARY KEY (id);
2777
2778
2779--
2780-- Name: call call_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2781--
2782
2783ALTER TABLE ONLY vk.call
2784    ADD CONSTRAINT call_pkey PRIMARY KEY (id);
2785
2786
2787--
2788-- Name: calltogovement calltogovement_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2789--
2790
2791ALTER TABLE ONLY vk.calltogovement
2792    ADD CONSTRAINT calltogovement_pkey PRIMARY KEY (id);
2793
2794
2795--
2796-- Name: calltogovementtype calltogovementtype_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2797--
2798
2799ALTER TABLE ONLY vk.calltogovementtype
2800    ADD CONSTRAINT calltogovementtype_pkey PRIMARY KEY (id);
2801
2802
2803--
2804-- Name: country country_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2805--
2806
2807ALTER TABLE ONLY vk.country
2808    ADD CONSTRAINT country_pkey PRIMARY KEY (id);
2809
2810
2811--
2812-- Name: district district_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2813--
2814
2815ALTER TABLE ONLY vk.district
2816    ADD CONSTRAINT district_pkey PRIMARY KEY (id);
2817
2818
2819--
2820-- Name: doc doc_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2821--
2822
2823ALTER TABLE ONLY vk.doc
2824    ADD CONSTRAINT doc_pkey PRIMARY KEY (id);
2825
2826
2827--
2828-- Name: doctor doctor_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2829--
2830
2831ALTER TABLE ONLY vk.doctor
2832    ADD CONSTRAINT doctor_pkey PRIMARY KEY (id);
2833
2834
2835--
2836-- Name: doctype doctype_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2837--
2838
2839ALTER TABLE ONLY vk.doctype
2840    ADD CONSTRAINT doctype_pkey PRIMARY KEY (id);
2841
2842
2843--
2844-- Name: educaton educaton_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2845--
2846
2847ALTER TABLE ONLY vk.educaton
2848    ADD CONSTRAINT educaton_pkey PRIMARY KEY (id);
2849
2850
2851--
2852-- Name: gradetype gradetype_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2853--
2854
2855ALTER TABLE ONLY vk.gradetype
2856    ADD CONSTRAINT gradetype_pkey PRIMARY KEY (id);
2857
2858
2859--
2860-- Name: maritalstatus maritalstatus_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2861--
2862
2863ALTER TABLE ONLY vk.maritalstatus
2864    ADD CONSTRAINT maritalstatus_pkey PRIMARY KEY (id);
2865
2866
2867--
2868-- Name: marking marking_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2869--
2870
2871ALTER TABLE ONLY vk.marking
2872    ADD CONSTRAINT marking_pkey PRIMARY KEY (id);
2873
2874
2875--
2876-- Name: markingproperty markingproperty_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2877--
2878
2879ALTER TABLE ONLY vk.markingproperty
2880    ADD CONSTRAINT markingproperty_pkey PRIMARY KEY (id);
2881
2882
2883--
2884-- Name: markingsign markingsign_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2885--
2886
2887ALTER TABLE ONLY vk.markingsign
2888    ADD CONSTRAINT markingsign_pkey PRIMARY KEY (markingtype_id);
2889
2890
2891--
2892-- Name: medexamination medexamination_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2893--
2894
2895ALTER TABLE ONLY vk.medexamination
2896    ADD CONSTRAINT medexamination_pkey PRIMARY KEY (id);
2897
2898
2899--
2900-- Name: medicalitem medicalitem_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2901--
2902
2903ALTER TABLE ONLY vk.medicalitem
2904    ADD CONSTRAINT medicalitem_pkey PRIMARY KEY (id);
2905
2906
2907--
2908-- Name: medicalopinion medicalopinion_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
2909--
2910
2911ALTER TABLE ONLY vk.medicalopinion
2912    ADD CONSTRAINT medicalopinion_pkey PRIMARY KEY (id);
2913
2914
2915--
2916-- Name: armytype p_armytype_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
2917--
2918
2919ALTER TABLE ONLY vk.armytype
2920    ADD CONSTRAINT p_armytype_id PRIMARY KEY (id);
2921
2922
2923--
2924-- Name: calltype p_calltype_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
2925--
2926
2927ALTER TABLE ONLY vk.calltype
2928    ADD CONSTRAINT p_calltype_id PRIMARY KEY (id);
2929
2930
2931--
2932-- Name: commission_decision p_com_des; Type: CONSTRAINT; Schema: vk; Owner: postgres
2933--
2934
2935ALTER TABLE ONLY vk.commission_decision
2936    ADD CONSTRAINT p_com_des PRIMARY KEY (id);
2937
2938
2939--
2940-- Name: commission_decision_base p_com_des_base; Type: CONSTRAINT; Schema: vk; Owner: postgres
2941--
2942
2943ALTER TABLE ONLY vk.commission_decision_base
2944    ADD CONSTRAINT p_com_des_base PRIMARY KEY (id);
2945
2946
2947--
2948-- Name: delay p_delay_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
2949--
2950
2951ALTER TABLE ONLY vk.delay
2952    ADD CONSTRAINT p_delay_id PRIMARY KEY (id);
2953
2954
2955--
2956-- Name: delay_priziv p_delay_priziv_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
2957--
2958
2959ALTER TABLE ONLY vk.delay_priziv
2960    ADD CONSTRAINT p_delay_priziv_id PRIMARY KEY (id);
2961
2962
2963--
2964-- Name: dosaaf p_dosaaf_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
2965--
2966
2967ALTER TABLE ONLY vk.dosaaf
2968    ADD CONSTRAINT p_dosaaf_id PRIMARY KEY (id);
2969
2970
2971--
2972-- Name: drivercategories p_driver_caegories_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
2973--
2974
2975ALTER TABLE ONLY vk.drivercategories
2976    ADD CONSTRAINT p_driver_caegories_id PRIMARY KEY (id);
2977
2978
2979--
2980-- Name: education_unit p_edu_unit_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
2981--
2982
2983ALTER TABLE ONLY vk.education_unit
2984    ADD CONSTRAINT p_edu_unit_id PRIMARY KEY (id);
2985
2986
2987--
2988-- Name: general_staff_team p_gen_staff_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
2989--
2990
2991ALTER TABLE ONLY vk.general_staff_team
2992    ADD CONSTRAINT p_gen_staff_id PRIMARY KEY (id);
2993
2994
2995--
2996-- Name: nationality p_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
2997--
2998
2999ALTER TABLE ONLY vk.nationality
3000    ADD CONSTRAINT p_id PRIMARY KEY (id);
3001
3002
3003--
3004-- Name: medical_way p_med_way_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
3005--
3006
3007ALTER TABLE ONLY vk.medical_way
3008    ADD CONSTRAINT p_med_way_id PRIMARY KEY (id);
3009
3010
3011--
3012-- Name: maritalstatus_parents p_ms_parents; Type: CONSTRAINT; Schema: vk; Owner: postgres
3013--
3014
3015ALTER TABLE ONLY vk.maritalstatus_parents
3016    ADD CONSTRAINT p_ms_parents PRIMARY KEY (id);
3017
3018
3019--
3020-- Name: municipal p_municipal; Type: CONSTRAINT; Schema: vk; Owner: postgres
3021--
3022
3023ALTER TABLE ONLY vk.municipal
3024    ADD CONSTRAINT p_municipal PRIMARY KEY (id);
3025
3026
3027--
3028-- Name: passport_service p_passport_service_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
3029--
3030
3031ALTER TABLE ONLY vk.passport_service
3032    ADD CONSTRAINT p_passport_service_id PRIMARY KEY (id);
3033
3034
3035--
3036-- Name: streets p_street_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
3037--
3038
3039ALTER TABLE ONLY vk.streets
3040    ADD CONSTRAINT p_street_id PRIMARY KEY (id);
3041
3042
3043--
3044-- Name: submarkingtype p_submarkingtype_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
3045--
3046
3047ALTER TABLE ONLY vk.submarkingtype
3048    ADD CONSTRAINT p_submarkingtype_id PRIMARY KEY (id);
3049
3050
3051--
3052-- Name: vus p_vus_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
3053--
3054
3055ALTER TABLE ONLY vk.vus
3056    ADD CONSTRAINT p_vus_id PRIMARY KEY (id);
3057
3058
3059--
3060-- Name: registration registration_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3061--
3062
3063ALTER TABLE ONLY vk.registration
3064    ADD CONSTRAINT registration_pkey PRIMARY KEY (id);
3065
3066
3067--
3068-- Name: registrationmark registrationmark_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3069--
3070
3071ALTER TABLE ONLY vk.registrationmark
3072    ADD CONSTRAINT registrationmark_pkey PRIMARY KEY (id);
3073
3074
3075--
3076-- Name: registrationreason registrationreason_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3077--
3078
3079ALTER TABLE ONLY vk.registrationreason
3080    ADD CONSTRAINT registrationreason_pkey PRIMARY KEY (id);
3081
3082
3083--
3084-- Name: registrationtype registrationtype_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3085--
3086
3087ALTER TABLE ONLY vk.registrationtype
3088    ADD CONSTRAINT registrationtype_pkey PRIMARY KEY (id);
3089
3090
3091--
3092-- Name: relative relative_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3093--
3094
3095ALTER TABLE ONLY vk.relative
3096    ADD CONSTRAINT relative_pkey PRIMARY KEY (id);
3097
3098
3099--
3100-- Name: relatives_address relatives_address_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3101--
3102
3103ALTER TABLE ONLY vk.relatives_address
3104    ADD CONSTRAINT relatives_address_pkey PRIMARY KEY (id, relative_id, country_id, type_np_id, district_id, reu_id, street_type_id);
3105
3106
3107--
3108-- Name: reservist reservist_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3109--
3110
3111ALTER TABLE ONLY vk.reservist
3112    ADD CONSTRAINT reservist_pkey PRIMARY KEY (id);
3113
3114
3115--
3116-- Name: responsibility responsibility_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3117--
3118
3119ALTER TABLE ONLY vk.responsibility
3120    ADD CONSTRAINT responsibility_pkey PRIMARY KEY (id);
3121
3122
3123--
3124-- Name: responsibilitystate responsibilitystate_id; Type: CONSTRAINT; Schema: vk; Owner: postgres
3125--
3126
3127ALTER TABLE ONLY vk.responsibilitystate
3128    ADD CONSTRAINT responsibilitystate_id PRIMARY KEY (id);
3129
3130
3131--
3132-- Name: responsibilitytype responsibilitytype_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3133--
3134
3135ALTER TABLE ONLY vk.responsibilitytype
3136    ADD CONSTRAINT responsibilitytype_pkey PRIMARY KEY (id);
3137
3138
3139--
3140-- Name: resultcall resultcall_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3141--
3142
3143ALTER TABLE ONLY vk.resultcall
3144    ADD CONSTRAINT resultcall_pkey PRIMARY KEY (id);
3145
3146
3147--
3148-- Name: resulttogovementcall resulttogovementcall_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3149--
3150
3151ALTER TABLE ONLY vk.resulttogovementcall
3152    ADD CONSTRAINT resulttogovementcall_pkey PRIMARY KEY (id);
3153
3154
3155--
3156-- Name: reu reu_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3157--
3158
3159ALTER TABLE ONLY vk.reu
3160    ADD CONSTRAINT reu_pkey PRIMARY KEY (id);
3161
3162
3163--
3164-- Name: side_info side_info_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3165--
3166
3167ALTER TABLE ONLY vk.side_info
3168    ADD CONSTRAINT side_info_pkey PRIMARY KEY (id);
3169
3170
3171--
3172-- Name: soavailability soavailability_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3173--
3174
3175ALTER TABLE ONLY vk.soavailability
3176    ADD CONSTRAINT soavailability_pkey PRIMARY KEY (id);
3177
3178
3179--
3180-- Name: speciality speciality_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3181--
3182
3183ALTER TABLE ONLY vk.speciality
3184    ADD CONSTRAINT speciality_pkey PRIMARY KEY (id);
3185
3186
3187--
3188-- Name: street_type street_type_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3189--
3190
3191ALTER TABLE ONLY vk.street_type
3192    ADD CONSTRAINT street_type_pkey PRIMARY KEY (id);
3193
3194
3195--
3196-- Name: type_np type_np_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3197--
3198
3199ALTER TABLE ONLY vk.type_np
3200    ADD CONSTRAINT type_np_pkey PRIMARY KEY (id);
3201
3202
3203--
3204-- Name: typerelative typerelative_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3205--
3206
3207ALTER TABLE ONLY vk.typerelative
3208    ADD CONSTRAINT typerelative_pkey PRIMARY KEY (id);
3209
3210
3211--
3212-- Name: unenrollmenttype unenrollmenttype_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3213--
3214
3215ALTER TABLE ONLY vk.unenrollmenttype
3216    ADD CONSTRAINT unenrollmenttype_pkey PRIMARY KEY (id);
3217
3218
3219--
3220-- Name: workplace workplace_pkey; Type: CONSTRAINT; Schema: vk; Owner: postgres
3221--
3222
3223ALTER TABLE ONLY vk.workplace
3224    ADD CONSTRAINT workplace_pkey PRIMARY KEY (id);
3225
3226
3227--
3228-- Name: autorization p_autorization_id; Type: CONSTRAINT; Schema: vk_system; Owner: postgres
3229--
3230
3231ALTER TABLE ONLY vk_system.autorization
3232    ADD CONSTRAINT p_autorization_id PRIMARY KEY (id);
3233
3234
3235--
3236-- Name: log_dictionaries p_log_dictionaries_id; Type: CONSTRAINT; Schema: vk_system; Owner: postgres
3237--
3238
3239ALTER TABLE ONLY vk_system.log_dictionaries
3240    ADD CONSTRAINT p_log_dictionaries_id PRIMARY KEY (id);
3241
3242
3243--
3244-- Name: log p_log_id; Type: CONSTRAINT; Schema: vk_system; Owner: postgres
3245--
3246
3247ALTER TABLE ONLY vk_system.log
3248    ADD CONSTRAINT p_log_id PRIMARY KEY (id);
3249
3250
3251--
3252-- Name: doc_fk0; Type: INDEX; Schema: vk; Owner: postgres
3253--
3254
3255CREATE INDEX doc_fk0 ON vk.doc USING btree (rv_id);
3256
3257
3258--
3259-- Name: doc_fk1; Type: INDEX; Schema: vk; Owner: postgres
3260--
3261
3262CREATE INDEX doc_fk1 ON vk.doc USING btree (type_id);
3263
3264
3265--
3266-- Name: fk_address_country1_idx; Type: INDEX; Schema: vk; Owner: postgres
3267--
3268
3269CREATE INDEX fk_address_country1_idx ON vk.address USING btree (country_id);
3270
3271
3272--
3273-- Name: fk_address_district1_idx; Type: INDEX; Schema: vk; Owner: postgres
3274--
3275
3276CREATE INDEX fk_address_district1_idx ON vk.address USING btree (district_id);
3277
3278
3279--
3280-- Name: fk_address_reservist1_idx; Type: INDEX; Schema: vk; Owner: postgres
3281--
3282
3283CREATE INDEX fk_address_reservist1_idx ON vk.address USING btree (reservist_id);
3284
3285
3286--
3287-- Name: fk_address_reu1_idx; Type: INDEX; Schema: vk; Owner: postgres
3288--
3289
3290CREATE INDEX fk_address_reu1_idx ON vk.address USING btree (reu_id);
3291
3292
3293--
3294-- Name: fk_address_street_type1_idx; Type: INDEX; Schema: vk; Owner: postgres
3295--
3296
3297CREATE INDEX fk_address_street_type1_idx ON vk.address USING btree (street_type_id);
3298
3299
3300--
3301-- Name: fk_address_type_np1_idx; Type: INDEX; Schema: vk; Owner: postgres
3302--
3303
3304CREATE INDEX fk_address_type_np1_idx ON vk.address USING btree (type_np_id);
3305
3306
3307--
3308-- Name: fk_call_reservist1_idx; Type: INDEX; Schema: vk; Owner: postgres
3309--
3310
3311CREATE INDEX fk_call_reservist1_idx ON vk.call USING btree (reservist_id);
3312
3313
3314--
3315-- Name: fk_call_resultcall1_idx; Type: INDEX; Schema: vk; Owner: postgres
3316--
3317
3318CREATE INDEX fk_call_resultcall1_idx ON vk.call USING btree (resultcall);
3319
3320
3321--
3322-- Name: fk_educaton_reservist1_idx; Type: INDEX; Schema: vk; Owner: postgres
3323--
3324
3325CREATE INDEX fk_educaton_reservist1_idx ON vk.educaton USING btree (reservist_id);
3326
3327
3328--
3329-- Name: fk_medexamination_availability1_idx; Type: INDEX; Schema: vk; Owner: postgres
3330--
3331
3332CREATE INDEX fk_medexamination_availability1_idx ON vk.medexamination USING btree (availability_id);
3333
3334
3335--
3336-- Name: fk_medexamination_reservist1_idx; Type: INDEX; Schema: vk; Owner: postgres
3337--
3338
3339CREATE INDEX fk_medexamination_reservist1_idx ON vk.medexamination USING btree (reservist_id);
3340
3341
3342--
3343-- Name: fk_medexamination_soavailability1_idx; Type: INDEX; Schema: vk; Owner: postgres
3344--
3345
3346CREATE INDEX fk_medexamination_soavailability1_idx ON vk.medexamination USING btree (soavailability_id);
3347
3348
3349--
3350-- Name: fk_relative_reservist1_idx; Type: INDEX; Schema: vk; Owner: postgres
3351--
3352
3353CREATE INDEX fk_relative_reservist1_idx ON vk.relative USING btree (reservist_id);
3354
3355
3356--
3357-- Name: fk_relatives_address_country1_idx; Type: INDEX; Schema: vk; Owner: postgres
3358--
3359
3360CREATE INDEX fk_relatives_address_country1_idx ON vk.relatives_address USING btree (country_id);
3361
3362
3363--
3364-- Name: fk_relatives_address_district1_idx; Type: INDEX; Schema: vk; Owner: postgres
3365--
3366
3367CREATE INDEX fk_relatives_address_district1_idx ON vk.relatives_address USING btree (district_id);
3368
3369
3370--
3371-- Name: fk_relatives_address_relative1_idx; Type: INDEX; Schema: vk; Owner: postgres
3372--
3373
3374CREATE INDEX fk_relatives_address_relative1_idx ON vk.relatives_address USING btree (relative_id);
3375
3376
3377--
3378-- Name: fk_relatives_address_reu1_idx; Type: INDEX; Schema: vk; Owner: postgres
3379--
3380
3381CREATE INDEX fk_relatives_address_reu1_idx ON vk.relatives_address USING btree (reu_id);
3382
3383
3384--
3385-- Name: fk_relatives_address_street_type1_idx; Type: INDEX; Schema: vk; Owner: postgres
3386--
3387
3388CREATE INDEX fk_relatives_address_street_type1_idx ON vk.relatives_address USING btree (street_type_id);
3389
3390
3391--
3392-- Name: fk_relatives_address_type_np1_idx; Type: INDEX; Schema: vk; Owner: postgres
3393--
3394
3395CREATE INDEX fk_relatives_address_type_np1_idx ON vk.relatives_address USING btree (type_np_id);
3396
3397
3398--
3399-- Name: fk_responsibility_reservist1_idx; Type: INDEX; Schema: vk; Owner: postgres
3400--
3401
3402CREATE INDEX fk_responsibility_reservist1_idx ON vk.responsibility USING btree (reservist_id);
3403
3404
3405--
3406-- Name: fk_responsibility_responsibilitytype1_idx; Type: INDEX; Schema: vk; Owner: postgres
3407--
3408
3409CREATE INDEX fk_responsibility_responsibilitytype1_idx ON vk.responsibility USING btree (type);
3410
3411
3412--
3413-- Name: fk_side_info_maritalstatus1_idx; Type: INDEX; Schema: vk; Owner: postgres
3414--
3415
3416CREATE INDEX fk_side_info_maritalstatus1_idx ON vk.side_info USING btree (maritalstatus);
3417
3418
3419--
3420-- Name: fk_side_info_reservist1_idx; Type: INDEX; Schema: vk; Owner: postgres
3421--
3422
3423CREATE INDEX fk_side_info_reservist1_idx ON vk.side_info USING btree (reservist_id);
3424
3425
3426--
3427-- Name: doc doc_fk0; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3428--
3429
3430ALTER TABLE ONLY vk.doc
3431    ADD CONSTRAINT doc_fk0 FOREIGN KEY (rv_id) REFERENCES vk.reservist(id);
3432
3433
3434--
3435-- Name: doc doc_fk1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3436--
3437
3438ALTER TABLE ONLY vk.doc
3439    ADD CONSTRAINT doc_fk1 FOREIGN KEY (type_id) REFERENCES vk.doctype(id);
3440
3441
3442--
3443-- Name: address fk_address_country1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3444--
3445
3446ALTER TABLE ONLY vk.address
3447    ADD CONSTRAINT fk_address_country1 FOREIGN KEY (country_id) REFERENCES vk.country(id);
3448
3449
3450--
3451-- Name: address fk_address_district1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3452--
3453
3454ALTER TABLE ONLY vk.address
3455    ADD CONSTRAINT fk_address_district1 FOREIGN KEY (district_id) REFERENCES vk.district(id);
3456
3457
3458--
3459-- Name: address fk_address_reservist1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3460--
3461
3462ALTER TABLE ONLY vk.address
3463    ADD CONSTRAINT fk_address_reservist1 FOREIGN KEY (reservist_id) REFERENCES vk.reservist(id);
3464
3465
3466--
3467-- Name: address fk_address_reu1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3468--
3469
3470ALTER TABLE ONLY vk.address
3471    ADD CONSTRAINT fk_address_reu1 FOREIGN KEY (reu_id) REFERENCES vk.reu(id);
3472
3473
3474--
3475-- Name: address fk_address_street_type1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3476--
3477
3478ALTER TABLE ONLY vk.address
3479    ADD CONSTRAINT fk_address_street_type1 FOREIGN KEY (street_type_id) REFERENCES vk.street_type(id);
3480
3481
3482--
3483-- Name: address fk_address_type_np1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3484--
3485
3486ALTER TABLE ONLY vk.address
3487    ADD CONSTRAINT fk_address_type_np1 FOREIGN KEY (type_np_id) REFERENCES vk.type_np(id);
3488
3489
3490--
3491-- Name: call fk_call_reservist1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3492--
3493
3494ALTER TABLE ONLY vk.call
3495    ADD CONSTRAINT fk_call_reservist1 FOREIGN KEY (reservist_id) REFERENCES vk.reservist(id);
3496
3497
3498--
3499-- Name: call fk_call_resultcall1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3500--
3501
3502ALTER TABLE ONLY vk.call
3503    ADD CONSTRAINT fk_call_resultcall1 FOREIGN KEY (resultcall) REFERENCES vk.resultcall(id);
3504
3505
3506--
3507-- Name: educaton fk_educaton_reservist1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3508--
3509
3510ALTER TABLE ONLY vk.educaton
3511    ADD CONSTRAINT fk_educaton_reservist1 FOREIGN KEY (reservist_id) REFERENCES vk.reservist(id);
3512
3513
3514--
3515-- Name: medexamination fk_medexamination_availability1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3516--
3517
3518ALTER TABLE ONLY vk.medexamination
3519    ADD CONSTRAINT fk_medexamination_availability1 FOREIGN KEY (availability_id) REFERENCES vk.availability(id);
3520
3521
3522--
3523-- Name: medexamination fk_medexamination_reservist1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3524--
3525
3526ALTER TABLE ONLY vk.medexamination
3527    ADD CONSTRAINT fk_medexamination_reservist1 FOREIGN KEY (reservist_id) REFERENCES vk.reservist(id);
3528
3529
3530--
3531-- Name: medexamination fk_medexamination_soavailability1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3532--
3533
3534ALTER TABLE ONLY vk.medexamination
3535    ADD CONSTRAINT fk_medexamination_soavailability1 FOREIGN KEY (soavailability_id) REFERENCES vk.soavailability(id);
3536
3537
3538--
3539-- Name: relative fk_relative_reservist1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3540--
3541
3542ALTER TABLE ONLY vk.relative
3543    ADD CONSTRAINT fk_relative_reservist1 FOREIGN KEY (reservist_id) REFERENCES vk.reservist(id);
3544
3545
3546--
3547-- Name: relatives_address fk_relatives_address_country1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3548--
3549
3550ALTER TABLE ONLY vk.relatives_address
3551    ADD CONSTRAINT fk_relatives_address_country1 FOREIGN KEY (country_id) REFERENCES vk.country(id);
3552
3553
3554--
3555-- Name: relatives_address fk_relatives_address_district1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3556--
3557
3558ALTER TABLE ONLY vk.relatives_address
3559    ADD CONSTRAINT fk_relatives_address_district1 FOREIGN KEY (district_id) REFERENCES vk.district(id);
3560
3561
3562--
3563-- Name: relatives_address fk_relatives_address_relative1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3564--
3565
3566ALTER TABLE ONLY vk.relatives_address
3567    ADD CONSTRAINT fk_relatives_address_relative1 FOREIGN KEY (relative_id) REFERENCES vk.reservist(id);
3568
3569
3570--
3571-- Name: relatives_address fk_relatives_address_reu1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3572--
3573
3574ALTER TABLE ONLY vk.relatives_address
3575    ADD CONSTRAINT fk_relatives_address_reu1 FOREIGN KEY (reu_id) REFERENCES vk.reu(id);
3576
3577
3578--
3579-- Name: relatives_address fk_relatives_address_street_type1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3580--
3581
3582ALTER TABLE ONLY vk.relatives_address
3583    ADD CONSTRAINT fk_relatives_address_street_type1 FOREIGN KEY (street_type_id) REFERENCES vk.street_type(id);
3584
3585
3586--
3587-- Name: relatives_address fk_relatives_address_type_np1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3588--
3589
3590ALTER TABLE ONLY vk.relatives_address
3591    ADD CONSTRAINT fk_relatives_address_type_np1 FOREIGN KEY (type_np_id) REFERENCES vk.type_np(id);
3592
3593
3594--
3595-- Name: responsibility fk_responsibility_reservist1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3596--
3597
3598ALTER TABLE ONLY vk.responsibility
3599    ADD CONSTRAINT fk_responsibility_reservist1 FOREIGN KEY (reservist_id) REFERENCES vk.reservist(id);
3600
3601
3602--
3603-- Name: responsibility fk_responsibility_responsibilitytype1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3604--
3605
3606ALTER TABLE ONLY vk.responsibility
3607    ADD CONSTRAINT fk_responsibility_responsibilitytype1 FOREIGN KEY (type) REFERENCES vk.responsibilitytype(id);
3608
3609
3610--
3611-- Name: side_info fk_side_info_maritalstatus1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3612--
3613
3614ALTER TABLE ONLY vk.side_info
3615    ADD CONSTRAINT fk_side_info_maritalstatus1 FOREIGN KEY (maritalstatus) REFERENCES vk.maritalstatus(id);
3616
3617
3618--
3619-- Name: side_info fk_side_info_nationality; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3620--
3621
3622ALTER TABLE ONLY vk.side_info
3623    ADD CONSTRAINT fk_side_info_nationality FOREIGN KEY (nationality) REFERENCES vk.nationality(id);
3624
3625
3626--
3627-- Name: side_info fk_side_info_reservist1; Type: FK CONSTRAINT; Schema: vk; Owner: postgres
3628--
3629
3630ALTER TABLE ONLY vk.side_info
3631    ADD CONSTRAINT fk_side_info_reservist1 FOREIGN KEY (reservist_id) REFERENCES vk.reservist(id);
3632
3633
3634--
3635-- PostgreSQL database dump complete
3636--
3637
3638
3639C:\Program Files (x86)\PostgreSQL\10\bin>