Base diccionario

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: conjugaciones; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE conjugaciones (
    id_tipo_conjugacion integer,
    id_tiempo integer,
    id_persona integer,
    conjugacion text
);


ALTER TABLE public.conjugaciones OWNER TO postgres;

--
-- Name: personas; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE personas (
    id_persona integer NOT NULL,
    persona text NOT NULL,
    pronombre text
);


ALTER TABLE public.personas OWNER TO postgres;

--
-- Name: personas_id_persona_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE personas_id_persona_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.personas_id_persona_seq OWNER TO postgres;

--
-- Name: personas_id_persona_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE personas_id_persona_seq OWNED BY personas.id_persona;


--
-- Name: raiz_verbos; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE raiz_verbos (
    id_raiz integer NOT NULL,
    raiz text NOT NULL,
    id_tipo_conjugacion integer NOT NULL,
    infinitivo text NOT NULL
);


ALTER TABLE public.raiz_verbos OWNER TO postgres;

--
-- Name: raiz_verbos_id_raiz_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE raiz_verbos_id_raiz_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.raiz_verbos_id_raiz_seq OWNER TO postgres;

--
-- Name: raiz_verbos_id_raiz_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE raiz_verbos_id_raiz_seq OWNED BY raiz_verbos.id_raiz;


--
-- Name: tiempos; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE tiempos (
    id_tiempo integer NOT NULL,
    tiempo text NOT NULL,
    id_modo integer
);


ALTER TABLE public.tiempos OWNER TO postgres;

--
-- Name: tiempos_id_tiempo_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE tiempos_id_tiempo_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tiempos_id_tiempo_seq OWNER TO postgres;

--
-- Name: tiempos_id_tiempo_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE tiempos_id_tiempo_seq OWNED BY tiempos.id_tiempo;


--
-- Name: tipos_conjugacion; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE tipos_conjugacion (
    id_tipo integer NOT NULL,
    descripcion text
);


ALTER TABLE public.tipos_conjugacion OWNER TO postgres;

--
-- Name: tipos_conjugacion_id_tipo_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE tipos_conjugacion_id_tipo_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tipos_conjugacion_id_tipo_seq OWNER TO postgres;

--
-- Name: tipos_conjugacion_id_tipo_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE tipos_conjugacion_id_tipo_seq OWNED BY tipos_conjugacion.id_tipo;


--
-- Name: id_persona; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY personas ALTER COLUMN id_persona SET DEFAULT nextval('personas_id_persona_seq'::regclass);


--
-- Name: id_raiz; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY raiz_verbos ALTER COLUMN id_raiz SET DEFAULT nextval('raiz_verbos_id_raiz_seq'::regclass);


--
-- Name: id_tiempo; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY tiempos ALTER COLUMN id_tiempo SET DEFAULT nextval('tiempos_id_tiempo_seq'::regclass);


--
-- Name: id_tipo; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY tipos_conjugacion ALTER COLUMN id_tipo SET DEFAULT nextval('tipos_conjugacion_id_tipo_seq'::regclass);


--
-- Data for Name: conjugaciones; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY conjugaciones (id_tipo_conjugacion, id_tiempo, id_persona, conjugacion) FROM stdin;
1   1   1   o
1   1   2   as
1   1   3   a
1   1   4   amos
1   1   5   áis
1   1   6   an
\.


--
-- Data for Name: personas; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY personas (id_persona, persona, pronombre) FROM stdin;
1   Primera Singular    yo
2   Segunda Singular    tú
3   Tercera Singular    él/ella/usted
4   Primera Plural  nosotros
5   Segunda Plural  vosotros
6   Tercera Plural  ellos/ellas/ustedes
\.


--
-- Name: personas_id_persona_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('personas_id_persona_seq', 6, true);


--
-- Data for Name: raiz_verbos; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY raiz_verbos (id_raiz, raiz, id_tipo_conjugacion, infinitivo) FROM stdin;
1   am  1   amar
2   abale   1   abalear
\.


--
-- Name: raiz_verbos_id_raiz_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('raiz_verbos_id_raiz_seq', 2, true);


--
-- Data for Name: tiempos; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY tiempos (id_tiempo, tiempo, id_modo) FROM stdin;
1   Presente Indicativo \N
\.


--
-- Name: tiempos_id_tiempo_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('tiempos_id_tiempo_seq', 1, true);


--
-- Data for Name: tipos_conjugacion; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY tipos_conjugacion (id_tipo, descripcion) FROM stdin;
1   -ar regular
\.


--
-- Name: tipos_conjugacion_id_tipo_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('tipos_conjugacion_id_tipo_seq', 1, true);


--
-- Name: infinitivo_unique; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY raiz_verbos
    ADD CONSTRAINT infinitivo_unique UNIQUE (infinitivo);


--
-- Name: personas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY personas
    ADD CONSTRAINT personas_pkey PRIMARY KEY (id_persona);


--
-- Name: tiempos_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY tiempos
    ADD CONSTRAINT tiempos_pkey PRIMARY KEY (id_tiempo);


--
-- Name: tipos_conjugacion_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY tipos_conjugacion
    ADD CONSTRAINT tipos_conjugacion_pkey PRIMARY KEY (id_tipo);


--
-- Name: conjugaciones_id_persona_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY conjugaciones
    ADD CONSTRAINT conjugaciones_id_persona_fkey FOREIGN KEY (id_persona) REFERENCES personas(id_persona);


--
-- Name: conjugaciones_id_tiempo_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY conjugaciones
    ADD CONSTRAINT conjugaciones_id_tiempo_fkey FOREIGN KEY (id_tiempo) REFERENCES tiempos(id_tiempo);


--
-- Name: conjugaciones_id_tipo_conjugacion_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY conjugaciones
    ADD CONSTRAINT conjugaciones_id_tipo_conjugacion_fkey FOREIGN KEY (id_tipo_conjugacion) REFERENCES tipos_conjugacion(id_tipo);


--
-- Name: raiz_verbos_tipos_conjugacion_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY raiz_verbos
    ADD CONSTRAINT raiz_verbos_tipos_conjugacion_fk FOREIGN KEY (id_tipo_conjugacion) REFERENCES tipos_conjugacion(id_tipo);


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


--
-- PostgreSQL database dump complete
--