database/pg_dump

--
-- PostgreSQL database dump
--

-- Dumped from database version 12.14 (Ubuntu 12.14-0ubuntu0.20.04.1)
-- Dumped by pg_dump version 12.14 (Ubuntu 12.14-0ubuntu0.20.04.1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: is_language_code(character varying); Type: FUNCTION; Schema: public; Owner: leqsikoni
--

CREATE FUNCTION public.is_language_code(value character varying) RETURNS boolean
    LANGUAGE plpgsql IMMUTABLE PARALLEL SAFE
    AS $_$BEGIN
    IF value IS NULL THEN
        RETURN TRUE;
    ELSE
        RETURN value ~ '^[a-z]{2}$';
    END IF;
END$_$;


ALTER FUNCTION public.is_language_code(value character varying) OWNER TO leqsikoni;

--
-- Name: is_sane_text(text); Type: FUNCTION; Schema: public; Owner: leqsikoni
--

CREATE FUNCTION public.is_sane_text(value text) RETURNS boolean
    LANGUAGE plpgsql IMMUTABLE PARALLEL SAFE
    AS $$BEGIN
    IF value IS NULL THEN
        RETURN TRUE;
    ELSE
        RETURN value = btrim(value) AND length(value) > 0;
    END IF;
END$$;


ALTER FUNCTION public.is_sane_text(value text) OWNER TO leqsikoni;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: example_texts; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.example_texts (
    id bigint NOT NULL,
    example_id bigint NOT NULL,
    language_id bigint NOT NULL,
    index bigint NOT NULL,
    value text NOT NULL,
    CONSTRAINT index_is_not_negative CHECK ((index >= 0)),
    CONSTRAINT value_is_sane_text CHECK (public.is_sane_text(value))
);


ALTER TABLE public.example_texts OWNER TO leqsikoni;

--
-- Name: example_texts_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.example_texts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.example_texts_id_seq OWNER TO leqsikoni;

--
-- Name: example_texts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.example_texts_id_seq OWNED BY public.example_texts.id;


--
-- Name: examples; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.examples (
    id bigint NOT NULL
);


ALTER TABLE public.examples OWNER TO leqsikoni;

--
-- Name: examples_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.examples_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.examples_id_seq OWNER TO leqsikoni;

--
-- Name: examples_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.examples_id_seq OWNED BY public.examples.id;


--
-- Name: inflections; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.inflections (
    id bigint NOT NULL,
    part_id bigint NOT NULL,
    descr character varying NOT NULL,
    index bigint NOT NULL,
    CONSTRAINT descr_is_sane_text CHECK (public.is_sane_text((descr)::text)),
    CONSTRAINT index_is_not_negative CHECK ((index >= 0))
);


ALTER TABLE public.inflections OWNER TO leqsikoni;

--
-- Name: inflections_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.inflections_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.inflections_id_seq OWNER TO leqsikoni;

--
-- Name: inflections_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.inflections_id_seq OWNED BY public.inflections.id;


--
-- Name: language_names; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.language_names (
    id bigint NOT NULL,
    lang_id bigint NOT NULL,
    name_lang_id bigint NOT NULL,
    value character varying NOT NULL,
    CONSTRAINT value_is_sane_text CHECK (public.is_sane_text((value)::text))
);


ALTER TABLE public.language_names OWNER TO leqsikoni;

--
-- Name: language_names_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.language_names_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.language_names_id_seq OWNER TO leqsikoni;

--
-- Name: language_names_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.language_names_id_seq OWNED BY public.language_names.id;


--
-- Name: languages; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.languages (
    id bigint NOT NULL,
    code character varying(2) NOT NULL,
    CONSTRAINT code_is_language_code CHECK (public.is_language_code(code))
);


ALTER TABLE public.languages OWNER TO leqsikoni;

--
-- Name: languages_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.languages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.languages_id_seq OWNER TO leqsikoni;

--
-- Name: languages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.languages_id_seq OWNED BY public.languages.id;


--
-- Name: part_names; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.part_names (
    id bigint NOT NULL,
    part_id bigint NOT NULL,
    name_lang_id bigint NOT NULL,
    value character varying NOT NULL,
    CONSTRAINT value_is_sane_text CHECK (public.is_sane_text((value)::text))
);


ALTER TABLE public.part_names OWNER TO leqsikoni;

--
-- Name: part_names_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.part_names_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.part_names_id_seq OWNER TO leqsikoni;

--
-- Name: part_names_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.part_names_id_seq OWNED BY public.part_names.id;


--
-- Name: parts; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.parts (
    id bigint NOT NULL,
    language_id bigint NOT NULL
);


ALTER TABLE public.parts OWNER TO leqsikoni;

--
-- Name: parts_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.parts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.parts_id_seq OWNER TO leqsikoni;

--
-- Name: parts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.parts_id_seq OWNED BY public.parts.id;


--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.schema_migrations (
    version bigint NOT NULL,
    dirty boolean NOT NULL
);


ALTER TABLE public.schema_migrations OWNER TO leqsikoni;

--
-- Name: translation_texts; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.translation_texts (
    id bigint NOT NULL,
    translation_id bigint NOT NULL,
    lang_id bigint NOT NULL,
    value text NOT NULL,
    commentary text,
    CONSTRAINT commentary_is_sane_text CHECK (((commentary IS NULL) OR public.is_sane_text(commentary))),
    CONSTRAINT value_is_sane_text CHECK (public.is_sane_text(value))
);


ALTER TABLE public.translation_texts OWNER TO leqsikoni;

--
-- Name: translation_texts_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.translation_texts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.translation_texts_id_seq OWNER TO leqsikoni;

--
-- Name: translation_texts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.translation_texts_id_seq OWNED BY public.translation_texts.id;


--
-- Name: translations; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.translations (
    id bigint NOT NULL,
    word_id bigint NOT NULL,
    index bigint NOT NULL,
    CONSTRAINT index_is_not_negative CHECK ((index >= 0))
);


ALTER TABLE public.translations OWNER TO leqsikoni;

--
-- Name: translations_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.translations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.translations_id_seq OWNER TO leqsikoni;

--
-- Name: translations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.translations_id_seq OWNED BY public.translations.id;


--
-- Name: word_form_example_texts; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.word_form_example_texts (
    id bigint NOT NULL,
    word_form_id bigint NOT NULL,
    example_text_id bigint NOT NULL,
    pos integer NOT NULL,
    CONSTRAINT pos_is_not_negative CHECK ((pos >= 0))
);


ALTER TABLE public.word_form_example_texts OWNER TO leqsikoni;

--
-- Name: word_form_example_texts_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.word_form_example_texts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.word_form_example_texts_id_seq OWNER TO leqsikoni;

--
-- Name: word_form_example_texts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.word_form_example_texts_id_seq OWNED BY public.word_form_example_texts.id;


--
-- Name: word_forms; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.word_forms (
    id bigint NOT NULL,
    word_id bigint NOT NULL,
    value character varying NOT NULL,
    len integer GENERATED ALWAYS AS (length((value)::text)) STORED NOT NULL,
    inflection_id bigint NOT NULL,
    other_word_id bigint,
    CONSTRAINT value_is_sane_text CHECK (public.is_sane_text((value)::text))
);


ALTER TABLE public.word_forms OWNER TO leqsikoni;

--
-- Name: word_forms_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.word_forms_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.word_forms_id_seq OWNER TO leqsikoni;

--
-- Name: word_forms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.word_forms_id_seq OWNED BY public.word_forms.id;


--
-- Name: words; Type: TABLE; Schema: public; Owner: leqsikoni
--

CREATE TABLE public.words (
    id bigint NOT NULL,
    language_id bigint NOT NULL,
    primary_form character varying NOT NULL,
    part_id bigint NOT NULL,
    commentary text,
    CONSTRAINT commentary_is_sane_text CHECK (public.is_sane_text(commentary)),
    CONSTRAINT primary_form_is_sane_text CHECK (public.is_sane_text((primary_form)::text))
);


ALTER TABLE public.words OWNER TO leqsikoni;

--
-- Name: words_id_seq; Type: SEQUENCE; Schema: public; Owner: leqsikoni
--

CREATE SEQUENCE public.words_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.words_id_seq OWNER TO leqsikoni;

--
-- Name: words_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: leqsikoni
--

ALTER SEQUENCE public.words_id_seq OWNED BY public.words.id;


--
-- Name: example_texts id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.example_texts ALTER COLUMN id SET DEFAULT nextval('public.example_texts_id_seq'::regclass);


--
-- Name: examples id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.examples ALTER COLUMN id SET DEFAULT nextval('public.examples_id_seq'::regclass);


--
-- Name: inflections id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.inflections ALTER COLUMN id SET DEFAULT nextval('public.inflections_id_seq'::regclass);


--
-- Name: language_names id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.language_names ALTER COLUMN id SET DEFAULT nextval('public.language_names_id_seq'::regclass);


--
-- Name: languages id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.languages ALTER COLUMN id SET DEFAULT nextval('public.languages_id_seq'::regclass);


--
-- Name: part_names id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.part_names ALTER COLUMN id SET DEFAULT nextval('public.part_names_id_seq'::regclass);


--
-- Name: parts id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.parts ALTER COLUMN id SET DEFAULT nextval('public.parts_id_seq'::regclass);


--
-- Name: translation_texts id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.translation_texts ALTER COLUMN id SET DEFAULT nextval('public.translation_texts_id_seq'::regclass);


--
-- Name: translations id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.translations ALTER COLUMN id SET DEFAULT nextval('public.translations_id_seq'::regclass);


--
-- Name: word_form_example_texts id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.word_form_example_texts ALTER COLUMN id SET DEFAULT nextval('public.word_form_example_texts_id_seq'::regclass);


--
-- Name: word_forms id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.word_forms ALTER COLUMN id SET DEFAULT nextval('public.word_forms_id_seq'::regclass);


--
-- Name: words id; Type: DEFAULT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.words ALTER COLUMN id SET DEFAULT nextval('public.words_id_seq'::regclass);


--
-- Data for Name: example_texts; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.example_texts (id, example_id, language_id, index, value) FROM stdin;
1	1	5	0	მე ქართველი ვარ
2	1	5	1	მე ვარ ქართველი
3	1	5	2	ქართველი ვარ
4	1	5	3	ვარ ქართველი
5	1	2	0	Я грузин
6	1	1	0	I am Georgian
7	1	4	0	Soy georgiano
8	1	4	1	Yo soy georgiano
9	1	3	0	Jestem Gruzinem
10	1	3	1	Ja jestem Gruzinem
11	2	5	0	შენ რუსი ხარ
12	2	5	1	შენ ხარ რუსი
13	2	5	2	რუსი ხარ
14	2	5	3	ხარ რუსი
15	2	2	0	Ты русский
19	3	5	0	ის ამერიკელი არის
20	3	2	0	Он американец
23	4	5	0	ჩვენ ფრანგები ვართ
24	4	2	0	Мы французы
25	5	5	0	თქვენ პოლონელები ხართ
26	5	2	0	Вы поляки
27	6	5	0	ისინი არგენტინელები არიან
28	6	2	0	Они аргентинцы
29	7	5	0	ეს მანქანები არის
30	7	2	0	Это автомобили
31	8	5	0	მე მაქვს წიგნი
32	8	2	0	У меня есть книга
33	9	5	0	მე მაქვს წიგნები
34	9	2	0	У меня есть книги
35	10	5	0	შენ გაქვს წიგნი
36	10	2	0	У тебя есть книга
37	11	5	0	შენ გაქვს წიგნები
38	11	2	0	У тебя есть книги
39	12	5	0	მას აქვს წიგნი
40	12	2	0	У него есть книга
41	13	5	0	მას აქვს წიგნები
42	13	2	0	У него есть книги
43	14	5	0	ჩვენ გვაქვს წიგნი
44	14	2	0	У нас есть книга
45	15	5	0	ჩვენ გვაქვს წიგნები
46	15	2	0	У нас есть книги
47	16	5	0	თქვენ გაქვთ წიგნი
48	16	2	0	У вас есть книга
49	17	5	0	თქვენ გაქვთ წიგნები
50	17	2	0	У вас есть книги
51	18	5	0	მათ აქვთ წიგნი
52	18	2	0	У них есть книга
53	19	5	0	მათ აქვთ წიგნები
54	19	2	0	У них есть книги
55	20	5	0	ერთი კაცი ხეს ცემს
56	20	2	0	Один мужчина бьёт дерево
57	21	5	0	ორი ქალი სახლს ცემენ
58	21	2	0	Две женщины бьют дом
59	22	5	0	არავინ მე მცემს
60	22	2	0	Никто не бьёт меня
61	23	5	0	მე იმ კაცებს ვხატავ
62	23	2	0	Я рисую этих мужчин
63	24	5	0	ისინი მე მხატავენ
64	24	2	0	Они рисуют меня
65	25	5	0	და მე თქვენ გხატავთ
66	25	2	0	А я рисую вас
67	26	5	0	ყველა ყველას ხატავს
68	26	2	0	Все рисуют всех
69	27	5	0	მე კაცი ვარ, და შენ ქალი ხარ
70	27	5	1	მე ვარ კაცი, და შენ ხარ ქალი
72	27	5	2	მე კაცი ვარ, და შენ ხარ ქალი
73	27	5	3	მე ვარ კაცი, და შენ ქალი ხარ
74	27	2	0	Я мужчина, а ты женщина
75	28	5	0	მე კაცი ვარ, და ის ქალი არის
76	28	5	1	მე ვარ კაცი, და ის არის ქალი
77	28	5	2	მე კაცი ვარ, და ის არის ქალი
78	28	5	3	მე ვარ კაცი, და ის ქალი არის
79	28	2	0	Я мужчина, а она женщина
\.


--
-- Data for Name: examples; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.examples (id) FROM stdin;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
\.


--
-- Data for Name: inflections; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.inflections (id, part_id, descr, index) FROM stdin;
37	2	Verbal noun	0
38	3	Primary form	0
5	2	Subj: sg, 1; obj: pl, 2	3
6	2	Subj: sg, 1; obj: pl, 3	4
7	2	Subj: sg, 2; obj: sg, 1	5
20	2	Subj: pl, 1; obj: sg, 2	15
21	2	Subj: pl, 1; obj: sg, 3	16
23	2	Subj: pl, 1; obj: pl, 2	17
24	2	Subj: pl, 1; obj: pl, 3	18
25	2	Subj: pl, 2; obj: sg, 1	19
9	2	Subj: sg, 2; obj: sg, 3	6
10	2	Subj: sg, 2; obj: pl, 1	7
2	2	Subj: sg, 1; obj: sg, 2	1
3	2	Subj: sg, 1; obj: sg, 3	2
27	2	Subj: pl, 2; obj: sg, 3	20
28	2	Subj: pl, 2; obj: pl, 1	21
30	2	Subj: pl, 2; obj: pl, 3	22
31	2	Subj: pl, 3; obj: sg, 1	23
32	2	Subj: pl, 3; obj: sg, 2	24
33	2	Subj: pl, 3; obj: sg, 3	25
34	2	Subj: pl, 3; obj: pl, 1	26
35	2	Subj: pl, 3; obj: pl, 2	27
36	2	Subj: pl, 3; obj: pl, 3	28
12	2	Subj: sg, 2; obj: pl, 3	8
13	2	Subj: sg, 3; obj: sg, 1	9
14	2	Subj: sg, 3; obj: sg, 2	10
15	2	Subj: sg, 3; obj: sg, 3	11
16	2	Subj: sg, 3; obj: pl, 1	12
17	2	Subj: sg, 3; obj: pl, 2	13
18	2	Subj: sg, 3; obj: pl, 3	14
\.


--
-- Data for Name: language_names; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.language_names (id, lang_id, name_lang_id, value) FROM stdin;
1	1	1	English
2	1	2	Английский
3	1	3	Angielski
4	1	4	Inglés
5	1	5	ინგლისური
6	2	1	Russian
7	2	2	Русский
8	2	3	Rosyjski
9	2	4	Ruso
10	2	5	რუსული
11	3	1	Polish
12	3	2	Польский
13	3	3	Polski
14	3	4	Polaco
15	3	5	პოლონური
16	4	1	Spanish
17	4	2	Испанский
18	4	3	Hiszpański
19	4	4	Español
20	4	5	ესპანური
21	5	1	Georgian
22	5	2	Грузинский
23	5	3	Gruziński
24	5	4	Georgiano
25	5	5	ქართული
\.


--
-- Data for Name: languages; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.languages (id, code) FROM stdin;
1	en
2	ru
3	pl
4	es
5	ka
\.


--
-- Data for Name: part_names; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.part_names (id, part_id, name_lang_id, value) FROM stdin;
1	1	1	noun
2	2	1	verb
3	1	2	существительное
4	2	2	глагол
5	1	3	rzeczownik
6	2	3	czasownik
7	1	4	sustantivo
8	2	4	verbo
9	1	5	არსებითი სახელი
10	2	5	ზმნა
11	3	1	adverb
12	3	2	наречие
13	3	3	przysłówek
14	3	4	adverbio
15	3	5	ზმნიზედა
\.


--
-- Data for Name: parts; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.parts (id, language_id) FROM stdin;
1	5
2	5
3	5
\.


--
-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.schema_migrations (version, dirty) FROM stdin;
20230324235714	f
\.


--
-- Data for Name: translation_texts; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.translation_texts (id, translation_id, lang_id, value, commentary) FROM stdin;
6	2	2	иметь	что-то неодушевлённое
7	3	2	иметь	что-то одушевлённое или персональное транспортное средство
8	4	2	хвалить	\N
9	5	2	бить	\N
10	6	2	рисовать	\N
1	1	1	to be	something, somebody; + noun
3	1	3	być	czymś, kimś; + rzeczownik
4	1	4	ser	algo, alguien; + sustantivo
5	1	5	ყოფნა	რაღაც, ვიღაც; + არსებითი სახელი
11	9	1	to be	something; + adjective
12	9	2	быть, являться	каким-то; + прилагательное
13	9	3	być	jakimś; + przymiotnik
14	9	4	ser	alguno; + adjetivo
15	9	5	ყოფნა	როგორც/როგორღაც(?); + ზედსართავი სახელი
16	1	2	быть, являться	чем-то, кем-то; + существительное
\.


--
-- Data for Name: translations; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.translations (id, word_id, index) FROM stdin;
1	1	0
2	2	0
3	3	0
4	4	0
5	5	0
6	6	0
9	1	1
\.


--
-- Data for Name: word_form_example_texts; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.word_form_example_texts (id, word_form_id, example_text_id, pos) FROM stdin;
2	1	2	3
3	1	3	9
4	1	4	0
1	1	1	12
8	2	14	0
7	2	13	5
6	2	12	4
5	2	11	9
10	3	29	13
9	3	19	13
11	4	23	14
12	5	25	17
13	6	27	20
15	7	33	3
14	7	31	3
17	8	37	4
16	8	35	4
19	9	41	4
18	9	39	4
21	10	45	5
20	10	43	5
23	11	49	6
22	11	47	6
25	12	53	4
24	12	51	4
28	53	59	10
26	55	55	14
27	69	57	15
31	75	65	12
29	76	61	13
32	86	67	13
30	95	63	9
33	1	69	8
34	2	69	25
35	1	75	8
36	3	75	24
\.


--
-- Data for Name: word_forms; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.word_forms (id, word_id, value, inflection_id, other_word_id) FROM stdin;
1	1	ვარ	3	\N
2	1	ხარ	9	\N
3	1	არის	15	\N
4	1	ვართ	21	\N
5	1	ხართ	27	\N
6	1	არიან	33	\N
67	5	მცემენ	31	\N
7	2	მაქვს	13	\N
8	2	გაქვს	14	\N
9	2	აქვს	15	\N
10	2	გვაქვს	16	\N
11	2	გაქვთ	17	\N
12	2	აქვთ	18	\N
45	5	გცემ	2	\N
46	5	ვცემ	3	\N
47	5	გცემთ	5	\N
48	5	ვცემ	6	\N
49	5	მცემ	7	\N
50	5	ცემ	9	\N
51	5	გვცემ	10	\N
52	5	ცემ	12	\N
53	5	მცემს	13	\N
54	5	გცემს	14	\N
55	5	ცემს	15	\N
56	5	გვცემს	16	\N
57	5	გცემთ	17	\N
58	5	ცემს	18	\N
59	5	გცემთ	20	\N
60	5	ვცემთ	21	\N
61	5	გცემთ	23	\N
62	5	ვცემთ	24	\N
63	5	მცემთ	25	\N
64	5	ცემთ	27	\N
65	5	გვცემთ	28	\N
66	5	ცემთ	30	\N
68	5	გცემენ	32	\N
69	5	ცემენ	33	\N
70	5	გვცემენ	34	\N
71	5	გცემენ	35	\N
72	5	ცემენ	36	\N
90	6	ვხატავთ	24	\N
91	6	მხატავთ	25	\N
92	6	ხატავთ	27	\N
93	6	გვხატავთ	28	\N
94	6	ხატავთ	30	\N
95	6	მხატავენ	31	\N
74	6	ვხატავ	3	\N
75	6	გხატავთ	5	\N
76	6	ვხატავ	6	\N
77	6	მხატავ	7	\N
78	6	ხატავ	9	\N
79	6	გვხატავ	10	\N
80	6	ხატავ	12	\N
81	6	მხატავს	13	\N
82	6	გხატავს	14	\N
83	6	ხატავს	15	\N
84	6	გვხატავს	16	\N
85	6	გხატავთ	17	\N
86	6	ხატავს	18	\N
87	6	გხატავთ	20	\N
88	6	ვხატავთ	21	\N
89	6	გხატავთ	23	\N
96	6	გხატავენ	32	\N
97	6	ხატავენ	33	\N
98	6	გვხატავენ	34	\N
99	6	გხატავენ	35	\N
100	6	ხატავენ	36	\N
101	1	ა	15	\N
102	4	გაქებ	2	\N
103	4	ვაქებ	3	\N
104	4	გაქებთ	5	\N
105	4	ვაქებ	6	\N
106	4	მაქებ	7	\N
107	4	აქებ	9	\N
108	4	გვაქებ	10	\N
109	4	აქებ	12	\N
110	4	მაქებს	13	\N
111	4	გაქებს	14	\N
112	4	აქებს	15	\N
113	4	გვაქებს	16	\N
114	4	გაქებთ	17	\N
115	4	აქებს	18	\N
116	4	გაქებთ	20	\N
117	4	ვაქებთ	21	\N
118	4	გაქებთ	23	\N
119	4	ვაქებთ	24	\N
120	4	მაქებთ	25	\N
121	4	აქებთ	27	\N
122	4	გვაქებთ	28	\N
123	4	აქებთ	30	\N
124	4	მაქებენ	31	\N
125	4	გაქებენ	32	\N
126	4	აქებენ	33	\N
127	4	გვაქებენ	34	\N
128	4	გაქებენ	35	\N
129	4	აქებენ	36	\N
132	6	გხატავ	2	\N
133	6	ხატვა	37	7
134	8	ძალიან	38	\N
\.


--
-- Data for Name: words; Type: TABLE DATA; Schema: public; Owner: leqsikoni
--

COPY public.words (id, language_id, primary_form, part_id, commentary) FROM stdin;
4	5	აქებს	2	\N
2	5	აქვს	2	Глагол спрягается по объектному строю: меняется лицо и число грамматического объекта, являющегося реальным субъектом (тем, кто имеет), а лицо грамматического субъекта, являющегося реальным объектом (тем, что имеют), остаётся неизменным. Глагол спрягается только по этому строю, ибо его нельзя употребить в 1 и 2 лицах субъекта и во множественном числе субъекта, потому что грамматическим субъектом, то есть реальным объектом (тем, что имеют), может быть только неодушевлённый предмет.
3	5	ყავს	2	\N
5	5	ცემს	2	\N
6	5	ხატავს	2	\N
1	5	არის	2	\N
7	5	ხატვა	1	\N
8	5	ძალიან	3	\N
\.


--
-- Name: example_texts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

SELECT pg_catalog.setval('public.example_texts_id_seq', 79, true);


--
-- Name: examples_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

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


--
-- Name: inflections_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

SELECT pg_catalog.setval('public.inflections_id_seq', 38, true);


--
-- Name: language_names_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

SELECT pg_catalog.setval('public.language_names_id_seq', 25, true);


--
-- Name: languages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

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


--
-- Name: part_names_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

SELECT pg_catalog.setval('public.part_names_id_seq', 15, true);


--
-- Name: parts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

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


--
-- Name: translation_texts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

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


--
-- Name: translations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

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


--
-- Name: word_form_example_texts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

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


--
-- Name: word_forms_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

SELECT pg_catalog.setval('public.word_forms_id_seq', 134, true);


--
-- Name: words_id_seq; Type: SEQUENCE SET; Schema: public; Owner: leqsikoni
--

SELECT pg_catalog.setval('public.words_id_seq', 8, true);


--
-- Name: example_texts example_texts_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.example_texts
    ADD CONSTRAINT example_texts_pkey PRIMARY KEY (id);


--
-- Name: examples examples_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.examples
    ADD CONSTRAINT examples_pkey PRIMARY KEY (id);


--
-- Name: inflections inflections_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.inflections
    ADD CONSTRAINT inflections_pkey PRIMARY KEY (id);


--
-- Name: language_names language_names_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.language_names
    ADD CONSTRAINT language_names_pkey PRIMARY KEY (id);


--
-- Name: languages languages_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.languages
    ADD CONSTRAINT languages_pkey PRIMARY KEY (id);


--
-- Name: part_names part_names_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.part_names
    ADD CONSTRAINT part_names_pkey PRIMARY KEY (id);


--
-- Name: parts parts_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.parts
    ADD CONSTRAINT parts_pkey PRIMARY KEY (id);


--
-- Name: schema_migrations schema_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.schema_migrations
    ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);


--
-- Name: translation_texts translation_texts_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.translation_texts
    ADD CONSTRAINT translation_texts_pkey PRIMARY KEY (id);


--
-- Name: translations translations_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.translations
    ADD CONSTRAINT translations_pkey PRIMARY KEY (id);


--
-- Name: word_form_example_texts word_form_example_texts_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.word_form_example_texts
    ADD CONSTRAINT word_form_example_texts_pkey PRIMARY KEY (id);


--
-- Name: word_forms word_forms_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.word_forms
    ADD CONSTRAINT word_forms_pkey PRIMARY KEY (id);


--
-- Name: words words_pkey; Type: CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.words
    ADD CONSTRAINT words_pkey PRIMARY KEY (id);


--
-- Name: example_texts_example_language_index; Type: INDEX; Schema: public; Owner: leqsikoni
--

CREATE UNIQUE INDEX example_texts_example_language_index ON public.example_texts USING btree (example_id, language_id, index);


--
-- Name: inflections_part_id_index; Type: INDEX; Schema: public; Owner: leqsikoni
--

CREATE UNIQUE INDEX inflections_part_id_index ON public.inflections USING btree (part_id, index);


--
-- Name: languages_code; Type: INDEX; Schema: public; Owner: leqsikoni
--

CREATE UNIQUE INDEX languages_code ON public.languages USING btree (code);


--
-- Name: languages_lang_name_lang; Type: INDEX; Schema: public; Owner: leqsikoni
--

CREATE UNIQUE INDEX languages_lang_name_lang ON public.language_names USING btree (lang_id, name_lang_id);


--
-- Name: part_names_name_lang_value; Type: INDEX; Schema: public; Owner: leqsikoni
--

CREATE UNIQUE INDEX part_names_name_lang_value ON public.part_names USING btree (name_lang_id, value);


--
-- Name: part_names_part_name_lang; Type: INDEX; Schema: public; Owner: leqsikoni
--

CREATE UNIQUE INDEX part_names_part_name_lang ON public.part_names USING btree (part_id, name_lang_id);


--
-- Name: translation_texts_translation_lang; Type: INDEX; Schema: public; Owner: leqsikoni
--

CREATE UNIQUE INDEX translation_texts_translation_lang ON public.translation_texts USING btree (translation_id, lang_id);


--
-- Name: translations_word_index; Type: INDEX; Schema: public; Owner: leqsikoni
--

CREATE UNIQUE INDEX translations_word_index ON public.translations USING btree (word_id, index);


--
-- Name: word_form_example_texts_pos; Type: INDEX; Schema: public; Owner: leqsikoni
--

CREATE UNIQUE INDEX word_form_example_texts_pos ON public.word_form_example_texts USING btree (example_text_id, pos);


--
-- Name: example_texts example_texts_example_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.example_texts
    ADD CONSTRAINT example_texts_example_id_fkey FOREIGN KEY (example_id) REFERENCES public.examples(id);


--
-- Name: example_texts example_texts_language_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.example_texts
    ADD CONSTRAINT example_texts_language_id_fkey FOREIGN KEY (language_id) REFERENCES public.languages(id);


--
-- Name: inflections inflections_part_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.inflections
    ADD CONSTRAINT inflections_part_id_fkey FOREIGN KEY (part_id) REFERENCES public.parts(id);


--
-- Name: language_names language_names_lang_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.language_names
    ADD CONSTRAINT language_names_lang_id_fkey FOREIGN KEY (lang_id) REFERENCES public.languages(id);


--
-- Name: language_names language_names_name_lang_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.language_names
    ADD CONSTRAINT language_names_name_lang_id_fkey FOREIGN KEY (name_lang_id) REFERENCES public.languages(id);


--
-- Name: part_names part_names_name_lang_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.part_names
    ADD CONSTRAINT part_names_name_lang_id_fkey FOREIGN KEY (name_lang_id) REFERENCES public.languages(id);


--
-- Name: part_names part_names_part_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.part_names
    ADD CONSTRAINT part_names_part_id_fkey FOREIGN KEY (part_id) REFERENCES public.parts(id);


--
-- Name: parts parts_language_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.parts
    ADD CONSTRAINT parts_language_id_fkey FOREIGN KEY (language_id) REFERENCES public.languages(id);


--
-- Name: translation_texts translation_texts_lang_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.translation_texts
    ADD CONSTRAINT translation_texts_lang_id_fkey FOREIGN KEY (lang_id) REFERENCES public.languages(id);


--
-- Name: translation_texts translation_texts_translation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.translation_texts
    ADD CONSTRAINT translation_texts_translation_id_fkey FOREIGN KEY (translation_id) REFERENCES public.translations(id);


--
-- Name: translations translations_word_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.translations
    ADD CONSTRAINT translations_word_id_fkey FOREIGN KEY (word_id) REFERENCES public.words(id);


--
-- Name: word_form_example_texts word_form_example_texts_example_text_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.word_form_example_texts
    ADD CONSTRAINT word_form_example_texts_example_text_id_fkey FOREIGN KEY (example_text_id) REFERENCES public.example_texts(id);


--
-- Name: word_form_example_texts word_form_example_texts_word_form_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.word_form_example_texts
    ADD CONSTRAINT word_form_example_texts_word_form_id_fkey FOREIGN KEY (word_form_id) REFERENCES public.word_forms(id);


--
-- Name: word_forms word_forms_inflection_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.word_forms
    ADD CONSTRAINT word_forms_inflection_id_fkey FOREIGN KEY (inflection_id) REFERENCES public.inflections(id);


--
-- Name: word_forms word_forms_other_word_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.word_forms
    ADD CONSTRAINT word_forms_other_word_id_fkey FOREIGN KEY (other_word_id) REFERENCES public.words(id);


--
-- Name: word_forms word_forms_word_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.word_forms
    ADD CONSTRAINT word_forms_word_id_fkey FOREIGN KEY (word_id) REFERENCES public.words(id);


--
-- Name: words words_language_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.words
    ADD CONSTRAINT words_language_id_fkey FOREIGN KEY (language_id) REFERENCES public.languages(id);


--
-- Name: words words_part_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: leqsikoni
--

ALTER TABLE ONLY public.words
    ADD CONSTRAINT words_part_id_fkey FOREIGN KEY (part_id) REFERENCES public.parts(id);


--
-- PostgreSQL database dump complete
--