--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: aliases; Type: TABLE; Schema: public; Owner: evkk; Tablespace: 
--

CREATE TABLE aliases (
    "ID" integer NOT NULL,
    fromword character varying(255),
    "WordID" integer,
    toword character varying(255)
);


ALTER TABLE public.aliases OWNER TO evkk;

--
-- Name: aliidseq; Type: SEQUENCE; Schema: public; Owner: evkk
--

CREATE SEQUENCE aliidseq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.aliidseq OWNER TO evkk;

--
-- Name: didseq; Type: SEQUENCE; Schema: public; Owner: evkk
--

CREATE SEQUENCE didseq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.didseq OWNER TO evkk;

--
-- Name: docrefs; Type: TABLE; Schema: public; Owner: evkk; Tablespace: 
--

CREATE TABLE docrefs (
    word character varying(255),
    "DocumentID" character varying(50) NOT NULL,
    "ID" bigint NOT NULL,
    "language" character varying(10),
    wstat integer DEFAULT 0 NOT NULL,
    corpus character varying(25)
);


ALTER TABLE public.docrefs OWNER TO evkk;

--
-- Name: COLUMN docrefs.wstat; Type: COMMENT; Schema: public; Owner: evkk
--

COMMENT ON COLUMN docrefs.wstat IS '0 - not handled
1 - in process
2 - no match
3 - fullmatch (unified, finished)
4 - multimatch (many options, finished)
5 - manual (unified, finished)';


--
-- Name: docfreq; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW docfreq AS
    SELECT docrefs."DocumentID", count(docrefs."DocumentID") AS count FROM docrefs GROUP BY docrefs."DocumentID" ORDER BY count(docrefs."DocumentID") DESC;


ALTER TABLE public.docfreq OWNER TO postgres;

--
-- Name: documents; Type: TABLE; Schema: public; Owner: evkk; Tablespace: 
--

CREATE TABLE documents (
    "DocumentID" character varying(100) NOT NULL,
    title character varying(255),
    corpus character varying(25),
    "language" character varying(10)
);


ALTER TABLE public.documents OWNER TO evkk;

--
-- Name: firstchars; Type: VIEW; Schema: public; Owner: evkk
--

CREATE VIEW firstchars AS
    SELECT DISTINCT substr((docrefs.word)::text, 1, 1) AS "char", count(docrefs.word) AS count FROM docrefs GROUP BY substr((docrefs.word)::text, 1, 1) ORDER BY substr((docrefs.word)::text, 1, 1), count(docrefs.word);


ALTER TABLE public.firstchars OWNER TO evkk;

--
-- Name: undecided; Type: TABLE; Schema: public; Owner: evkk; Tablespace: 
--

CREATE TABLE undecided (
    "ID" integer NOT NULL,
    word character varying(100) NOT NULL,
    "option" character varying(255),
    "language" character varying(4),
    processed boolean DEFAULT false,
    tick boolean
);


ALTER TABLE public.undecided OWNER TO evkk;

--
-- Name: COLUMN undecided.processed; Type: COMMENT; Schema: public; Owner: evkk
--

COMMENT ON COLUMN undecided.processed IS 'is it processed already?';


--
-- Name: COLUMN undecided.tick; Type: COMMENT; Schema: public; Owner: evkk
--

COMMENT ON COLUMN undecided.tick IS 'tick indicates the chosen form of a word. Ticked words will be copied to words table automatically.';


--
-- Name: unidseq; Type: SEQUENCE; Schema: public; Owner: evkk
--

CREATE SEQUENCE unidseq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.unidseq OWNER TO evkk;

--
-- Name: widseq; Type: SEQUENCE; Schema: public; Owner: evkk
--

CREATE SEQUENCE widseq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.widseq OWNER TO evkk;

--
-- Name: words; Type: TABLE; Schema: public; Owner: evkk; Tablespace: 
--

CREATE TABLE words (
    "ID" integer NOT NULL,
    word character varying(255),
    prim character varying(255),
    lemma character varying(255),
    category character varying(10),
    gram character varying(500),
    "language" character varying(4),
    raw character varying(255)
);


ALTER TABLE public.words OWNER TO evkk;

--
-- Name: TABLE words; Type: COMMENT; Schema: public; Owner: evkk
--

COMMENT ON TABLE words IS 'ID          1
word        näitab
freq        123
prim        näita
lemma       näitama
category    !02_AS
gram        (PlG | (SgN
lang        et
raw         aura =aura (SgN >aura !16_S
';


--
-- Name: aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: evkk; Tablespace: 
--

ALTER TABLE ONLY aliases
    ADD CONSTRAINT aliases_pkey PRIMARY KEY ("ID");


--
-- Name: docid; Type: CONSTRAINT; Schema: public; Owner: evkk; Tablespace: 
--

ALTER TABLE ONLY documents
    ADD CONSTRAINT docid PRIMARY KEY ("DocumentID");


--
-- Name: documents_pkey; Type: CONSTRAINT; Schema: public; Owner: evkk; Tablespace: 
--

ALTER TABLE ONLY docrefs
    ADD CONSTRAINT documents_pkey PRIMARY KEY ("ID");


--
-- Name: undecided_pkey; Type: CONSTRAINT; Schema: public; Owner: evkk; Tablespace: 
--

ALTER TABLE ONLY undecided
    ADD CONSTRAINT undecided_pkey PRIMARY KEY ("ID");


--
-- Name: words_pkey; Type: CONSTRAINT; Schema: public; Owner: evkk; Tablespace: 
--

ALTER TABLE ONLY words
    ADD CONSTRAINT words_pkey PRIMARY KEY ("ID");


--
-- Name: alindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: 
--

CREATE INDEX alindex ON aliases USING btree (fromword);


--
-- Name: docindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: 
--

CREATE INDEX docindex ON docrefs USING btree ("DocumentID");


--
-- Name: fromindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: 
--

CREATE INDEX fromindex ON aliases USING btree (fromword);


--
-- Name: langindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: 
--

CREATE INDEX langindex ON undecided USING btree ("language");


--
-- Name: toindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: 
--

CREATE INDEX toindex ON aliases USING btree (toword);


--
-- Name: windex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: 
--

CREATE INDEX windex ON undecided USING btree (word);


--
-- Name: wordindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: 
--

CREATE INDEX wordindex ON words USING btree (word);


--
-- Name: wrdindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: 
--

CREATE INDEX wrdindex ON docrefs USING btree (word);


--
-- Name: wstatidx; Type: INDEX; Schema: public; Owner: evkk; Tablespace: 
--

CREATE INDEX wstatidx ON docrefs USING btree (wstat);


--
-- Name: word; Type: FK CONSTRAINT; Schema: public; Owner: evkk
--

ALTER TABLE ONLY aliases
    ADD CONSTRAINT word FOREIGN KEY ("WordID") REFERENCES words("ID");


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: docfreq; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE docfreq FROM PUBLIC;
REVOKE ALL ON TABLE docfreq FROM postgres;
GRANT ALL ON TABLE docfreq TO postgres;
GRANT ALL ON TABLE docfreq TO PUBLIC;


--
-- PostgreSQL database dump complete
--

