-- -- 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 --