-- -- PostgreSQL database dump -- -- Dumped from database version 11.4 (Ubuntu 11.4-1.pgdg18.04+1) -- Dumped by pg_dump version 11.4 (Ubuntu 11.4-1.pgdg18.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; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: actividad; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.actividad ( id_actividad integer NOT NULL, nombre character varying(50) NOT NULL, cupos smallint, lugar character varying(20) NOT NULL, rut_profesor character varying(9) NOT NULL, CONSTRAINT actividad_cupos_check CHECK ((cupos > 0)), CONSTRAINT actividad_rut_profesor_check CHECK (((rut_profesor)::text ~ '^[0-9k]+$'::text)) ); ALTER TABLE public.actividad OWNER TO cromer; -- -- Name: actividad_bloque; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.actividad_bloque ( id_actividad integer NOT NULL, id_bloque integer NOT NULL ); ALTER TABLE public.actividad_bloque OWNER TO cromer; -- -- Name: actividad_id_actividad_seq; Type: SEQUENCE; Schema: public; Owner: cromer -- CREATE SEQUENCE public.actividad_id_actividad_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.actividad_id_actividad_seq OWNER TO cromer; -- -- Name: actividad_id_actividad_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cromer -- ALTER SEQUENCE public.actividad_id_actividad_seq OWNED BY public.actividad.id_actividad; -- -- Name: actividad_nivel; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.actividad_nivel ( id_actividad integer NOT NULL, id_nivel integer NOT NULL ); ALTER TABLE public.actividad_nivel OWNER TO cromer; -- -- Name: alumno; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.alumno ( rut_alumno character varying(9) NOT NULL, nombres character varying(50) NOT NULL, apellidos character varying(50) NOT NULL, direccion character varying(30) NOT NULL, id_ciudad smallint, anyo_ingreso smallint, fecha_nacimiento date NOT NULL, rut_apoderado character varying(9) NOT NULL, CONSTRAINT alumno_anyo_ingreso_check CHECK ((anyo_ingreso > 1980)), CONSTRAINT alumno_fecha_nacimiento_check CHECK ((fecha_nacimiento > '1980-01-01'::date)), CONSTRAINT alumno_rut_alumno_check CHECK (((rut_alumno)::text ~ '^[0-9k]+$'::text)), CONSTRAINT alumno_rut_apoderado_check CHECK (((rut_apoderado)::text ~ '^[0-9k]+$'::text)) ); ALTER TABLE public.alumno OWNER TO cromer; -- -- Name: apoderado; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.apoderado ( rut_apoderado character varying(9) NOT NULL, nombres character varying(50) NOT NULL, apellidos character varying(50) NOT NULL, direccion character varying(30) NOT NULL, id_ciudad smallint, CONSTRAINT apoderado_rut_apoderado_check CHECK (((rut_apoderado)::text ~ '^[0-9k]+$'::text)) ); ALTER TABLE public.apoderado OWNER TO cromer; -- -- Name: asignatura; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.asignatura ( id_asignatura integer NOT NULL, nombre character varying(50) NOT NULL, rut_profesor character varying(9) NOT NULL, CONSTRAINT asignatura_rut_profesor_check CHECK (((rut_profesor)::text ~ '^[0-9k]+$'::text)) ); ALTER TABLE public.asignatura OWNER TO cromer; -- -- Name: asignatura_id_asignatura_seq; Type: SEQUENCE; Schema: public; Owner: cromer -- CREATE SEQUENCE public.asignatura_id_asignatura_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.asignatura_id_asignatura_seq OWNER TO cromer; -- -- Name: asignatura_id_asignatura_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cromer -- ALTER SEQUENCE public.asignatura_id_asignatura_seq OWNED BY public.asignatura.id_asignatura; -- -- Name: asistente; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.asistente ( rut_profesor character varying(9) NOT NULL, id_curso character varying(10) NOT NULL, CONSTRAINT asistente_rut_profesor_check CHECK (((rut_profesor)::text ~ '^[0-9k]+$'::text)) ); ALTER TABLE public.asistente OWNER TO cromer; -- -- Name: asociado; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.asociado ( id_curso character varying(10) NOT NULL, id_asignatura integer NOT NULL ); ALTER TABLE public.asociado OWNER TO cromer; -- -- Name: bloque; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.bloque ( id_bloque integer NOT NULL, descripcion character varying(20) NOT NULL ); ALTER TABLE public.bloque OWNER TO cromer; -- -- Name: bloque_id_bloque_seq; Type: SEQUENCE; Schema: public; Owner: cromer -- CREATE SEQUENCE public.bloque_id_bloque_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.bloque_id_bloque_seq OWNER TO cromer; -- -- Name: bloque_id_bloque_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cromer -- ALTER SEQUENCE public.bloque_id_bloque_seq OWNED BY public.bloque.id_bloque; -- -- Name: ciudad; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.ciudad ( id_ciudad smallint NOT NULL, nombre_ciudad character varying(20) NOT NULL, id_region smallint ); ALTER TABLE public.ciudad OWNER TO cromer; -- -- Name: ciudad_id_ciudad_seq; Type: SEQUENCE; Schema: public; Owner: cromer -- CREATE SEQUENCE public.ciudad_id_ciudad_seq AS smallint START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.ciudad_id_ciudad_seq OWNER TO cromer; -- -- Name: ciudad_id_ciudad_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cromer -- ALTER SEQUENCE public.ciudad_id_ciudad_seq OWNED BY public.ciudad.id_ciudad; -- -- Name: cursar; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.cursar ( rut_alumno character varying(9) NOT NULL, id_curso character varying(10) NOT NULL, CONSTRAINT cursar_rut_alumno_check CHECK (((rut_alumno)::text ~ '^[0-9k]+$'::text)) ); ALTER TABLE public.cursar OWNER TO cromer; -- -- Name: curso; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.curso ( id_curso character varying(10) NOT NULL, nombre character varying(6) NOT NULL, anyo smallint, rut_profesor character varying(9) NOT NULL, CONSTRAINT curso_anyo_check CHECK ((anyo > 1980)), CONSTRAINT curso_rut_profesor_check CHECK (((rut_profesor)::text ~ '^[0-9k]+$'::text)) ); ALTER TABLE public.curso OWNER TO cromer; -- -- Name: horario; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.horario ( id_asignatura integer NOT NULL, id_bloque integer NOT NULL, sala character varying(20) NOT NULL ); ALTER TABLE public.horario OWNER TO cromer; -- -- Name: nivel; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.nivel ( id_nivel integer NOT NULL, nombre character varying(20) NOT NULL ); ALTER TABLE public.nivel OWNER TO cromer; -- -- Name: nivel_id_nivel_seq; Type: SEQUENCE; Schema: public; Owner: cromer -- CREATE SEQUENCE public.nivel_id_nivel_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.nivel_id_nivel_seq OWNER TO cromer; -- -- Name: nivel_id_nivel_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cromer -- ALTER SEQUENCE public.nivel_id_nivel_seq OWNED BY public.nivel.id_nivel; -- -- Name: participar; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.participar ( rut_alumno character varying(9) NOT NULL, id_actividad integer NOT NULL, CONSTRAINT participar_rut_alumno_check CHECK (((rut_alumno)::text ~ '^[0-9k]+$'::text)) ); ALTER TABLE public.participar OWNER TO cromer; -- -- Name: profesor; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.profesor ( rut_profesor character varying(9) NOT NULL, nombres character varying(50) NOT NULL, apellidos character varying(50) NOT NULL, direccion character varying(30) NOT NULL, id_ciudad smallint, CONSTRAINT profesor_rut_profesor_check CHECK (((rut_profesor)::text ~ '^[0-9k]+$'::text)) ); ALTER TABLE public.profesor OWNER TO cromer; -- -- Name: region; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.region ( id_region smallint NOT NULL, nombre_region character varying(20) NOT NULL ); ALTER TABLE public.region OWNER TO cromer; -- -- Name: region_id_region_seq; Type: SEQUENCE; Schema: public; Owner: cromer -- CREATE SEQUENCE public.region_id_region_seq AS smallint START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.region_id_region_seq OWNER TO cromer; -- -- Name: region_id_region_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cromer -- ALTER SEQUENCE public.region_id_region_seq OWNED BY public.region.id_region; -- -- Name: registro; Type: TABLE; Schema: public; Owner: cromer -- CREATE TABLE public.registro ( rut_alumno character varying(9) NOT NULL, id_asignatura integer NOT NULL, nota numeric(2,1), CONSTRAINT registro_nota_check CHECK (((nota >= 1.0) AND (nota <= 7.0))), CONSTRAINT registro_rut_alumno_check CHECK (((rut_alumno)::text ~ '^[0-9k]+$'::text)) ); ALTER TABLE public.registro OWNER TO cromer; -- -- Name: actividad id_actividad; Type: DEFAULT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.actividad ALTER COLUMN id_actividad SET DEFAULT nextval('public.actividad_id_actividad_seq'::regclass); -- -- Name: asignatura id_asignatura; Type: DEFAULT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.asignatura ALTER COLUMN id_asignatura SET DEFAULT nextval('public.asignatura_id_asignatura_seq'::regclass); -- -- Name: bloque id_bloque; Type: DEFAULT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.bloque ALTER COLUMN id_bloque SET DEFAULT nextval('public.bloque_id_bloque_seq'::regclass); -- -- Name: ciudad id_ciudad; Type: DEFAULT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.ciudad ALTER COLUMN id_ciudad SET DEFAULT nextval('public.ciudad_id_ciudad_seq'::regclass); -- -- Name: nivel id_nivel; Type: DEFAULT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.nivel ALTER COLUMN id_nivel SET DEFAULT nextval('public.nivel_id_nivel_seq'::regclass); -- -- Name: region id_region; Type: DEFAULT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.region ALTER COLUMN id_region SET DEFAULT nextval('public.region_id_region_seq'::regclass); -- -- Data for Name: actividad; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.actividad (id_actividad, nombre, cupos, lugar, rut_profesor) FROM stdin; 1 Quidditch 14 Quidditch field 226174788 2 Ogre taming 5 The forbidden forest 226779329 3 Advanced transfiguration 2 Headmaster's office 139414853 4 Rugby 30 Rugby field 226174788 \. -- -- Data for Name: actividad_bloque; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.actividad_bloque (id_actividad, id_bloque) FROM stdin; 1 1 2 2 3 3 \. -- -- Data for Name: actividad_nivel; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.actividad_nivel (id_actividad, id_nivel) FROM stdin; 1 1 2 2 3 3 \. -- -- Data for Name: alumno; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.alumno (rut_alumno, nombres, apellidos, direccion, id_ciudad, anyo_ingreso, fecha_nacimiento, rut_apoderado) FROM stdin; 254049492 Isabella Lynn Cromer Chacano 214 Edison Dr. 1 2019 2019-10-04 14592927k 245191391 Tomas Bunt Avenida San Sebastian 778 2 2018 2010-02-05 192186099 18028642k Tom Riddle 320 Thomas Jefferson St. 3 2017 2014-12-31 192199859 22690395k Draco Malfoy 743 Thames Ave. 1 2017 2006-10-04 192199859 215221350 Victor Krum 9282 Park Way 1 2017 2007-02-12 192199859 144715179 Pansy Parkinson 339 Mobile Hwy. 1 2017 2008-12-03 192199859 86210681 Oliver Wood 323 Crane Ave. 1 2017 2007-01-02 192199859 20084453k Theodore Nott 848 Short Way 1 2017 2006-02-04 192199859 133765859 Cormac McLaggen 484 9th Ave. 1 2017 2007-01-08 192199859 \. -- -- Data for Name: apoderado; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.apoderado (rut_apoderado, nombres, apellidos, direccion, id_ciudad) FROM stdin; 14592927k Christopher Barry Cromer 214 Edison Dr. 1 192186099 Elia Alejandra Chacano Troncoso Avenida San Sebastian 778 2 192199859 Jack Johnson 320 Thomas Jefferson St. 3 \. -- -- Data for Name: asignatura; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.asignatura (id_asignatura, nombre, rut_profesor) FROM stdin; 1 Transfiguration 226779329 2 Defense against the dark arts 226174788 3 Muggle studies 139414853 4 Potions 226174788 \. -- -- Data for Name: asistente; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.asistente (rut_profesor, id_curso) FROM stdin; 139414853 1A-2019 226174788 2B-2019 \. -- -- Data for Name: asociado; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.asociado (id_curso, id_asignatura) FROM stdin; 1A-2019 1 2B-2019 2 3C-2019 3 6A-2018 1 6A-2018 2 6A-2018 3 1A-2018 4 \. -- -- Data for Name: bloque; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.bloque (id_bloque, descripcion) FROM stdin; 1 08:10 - 09:30 2 09:40 - 11:00 3 11:10 - 12:30 4 12:40 - 14:00 5 14:10 - 15:30 6 15:40 - 17:00 7 17:10 - 18:30 8 18:40 - 20:00 \. -- -- Data for Name: ciudad; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.ciudad (id_ciudad, nombre_ciudad, id_region) FROM stdin; 1 Pensacola 1 2 Montgomery 2 3 Virginia Beach 3 \. -- -- Data for Name: cursar; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.cursar (rut_alumno, id_curso) FROM stdin; 254049492 1A-2019 245191391 2B-2019 18028642k 3C-2019 22690395k 6A-2018 215221350 6A-2018 144715179 6A-2018 86210681 2B-2019 20084453k 2B-2019 133765859 3C-2019 \. -- -- Data for Name: curso; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.curso (id_curso, nombre, anyo, rut_profesor) FROM stdin; 1A-2019 1A 2019 226174788 2B-2019 2B 2019 226779329 3C-2019 3C 2019 139414853 6A-2018 6A 2018 226174788 1A-2018 1A 2018 226779329 \. -- -- Data for Name: horario; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.horario (id_asignatura, id_bloque, sala) FROM stdin; 2 2 301AB 3 3 102AA 1 1 203AC 4 8 105AA \. -- -- Data for Name: nivel; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.nivel (id_nivel, nombre) FROM stdin; 1 Primero 2 Segundo 3 Tercero \. -- -- Data for Name: participar; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.participar (rut_alumno, id_actividad) FROM stdin; 254049492 1 245191391 2 18028642k 3 22690395k 1 215221350 1 144715179 1 86210681 1 20084453k 1 133765859 1 22690395k 4 \. -- -- Data for Name: profesor; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.profesor (rut_profesor, nombres, apellidos, direccion, id_ciudad) FROM stdin; 226174788 Severus Snape 232 Jackson Ave. 1 226779329 Minerva McGonagall 333 Nottingham Ln. 2 139414853 Albus Dumbledore 8450 Sparrow Rd. 3 \. -- -- Data for Name: region; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.region (id_region, nombre_region) FROM stdin; 1 Bío Bío 2 Ñuble 3 Virginia \. -- -- Data for Name: registro; Type: TABLE DATA; Schema: public; Owner: cromer -- COPY public.registro (rut_alumno, id_asignatura, nota) FROM stdin; 254049492 1 7.0 18028642k 3 1.0 22690395k 4 3.0 144715179 4 2.0 245191391 2 4.1 86210681 4 5.0 \. -- -- Name: actividad_id_actividad_seq; Type: SEQUENCE SET; Schema: public; Owner: cromer -- SELECT pg_catalog.setval('public.actividad_id_actividad_seq', 1, false); -- -- Name: asignatura_id_asignatura_seq; Type: SEQUENCE SET; Schema: public; Owner: cromer -- SELECT pg_catalog.setval('public.asignatura_id_asignatura_seq', 13, true); -- -- Name: bloque_id_bloque_seq; Type: SEQUENCE SET; Schema: public; Owner: cromer -- SELECT pg_catalog.setval('public.bloque_id_bloque_seq', 1, false); -- -- Name: ciudad_id_ciudad_seq; Type: SEQUENCE SET; Schema: public; Owner: cromer -- SELECT pg_catalog.setval('public.ciudad_id_ciudad_seq', 1, false); -- -- Name: nivel_id_nivel_seq; Type: SEQUENCE SET; Schema: public; Owner: cromer -- SELECT pg_catalog.setval('public.nivel_id_nivel_seq', 1, false); -- -- Name: region_id_region_seq; Type: SEQUENCE SET; Schema: public; Owner: cromer -- SELECT pg_catalog.setval('public.region_id_region_seq', 1, false); -- -- Name: actividad_bloque actividad_bloque_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.actividad_bloque ADD CONSTRAINT actividad_bloque_pkey PRIMARY KEY (id_actividad, id_bloque); -- -- Name: actividad_nivel actividad_nivel_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.actividad_nivel ADD CONSTRAINT actividad_nivel_pkey PRIMARY KEY (id_actividad, id_nivel); -- -- Name: actividad actividad_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.actividad ADD CONSTRAINT actividad_pkey PRIMARY KEY (id_actividad); -- -- Name: alumno alumno_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.alumno ADD CONSTRAINT alumno_pkey PRIMARY KEY (rut_alumno); -- -- Name: apoderado apoderado_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.apoderado ADD CONSTRAINT apoderado_pkey PRIMARY KEY (rut_apoderado); -- -- Name: asignatura asignatura_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.asignatura ADD CONSTRAINT asignatura_pkey PRIMARY KEY (id_asignatura); -- -- Name: asistente asistente_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.asistente ADD CONSTRAINT asistente_pkey PRIMARY KEY (rut_profesor, id_curso); -- -- Name: asociado asociado_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.asociado ADD CONSTRAINT asociado_pkey PRIMARY KEY (id_curso, id_asignatura); -- -- Name: bloque bloque_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.bloque ADD CONSTRAINT bloque_pkey PRIMARY KEY (id_bloque); -- -- Name: ciudad ciudad_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.ciudad ADD CONSTRAINT ciudad_pkey PRIMARY KEY (id_ciudad); -- -- Name: cursar cursar_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.cursar ADD CONSTRAINT cursar_pkey PRIMARY KEY (rut_alumno, id_curso); -- -- Name: curso curso_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.curso ADD CONSTRAINT curso_pkey PRIMARY KEY (id_curso); -- -- Name: horario horario_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.horario ADD CONSTRAINT horario_pkey PRIMARY KEY (id_asignatura, id_bloque); -- -- Name: nivel nivel_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.nivel ADD CONSTRAINT nivel_pkey PRIMARY KEY (id_nivel); -- -- Name: participar participar_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.participar ADD CONSTRAINT participar_pkey PRIMARY KEY (rut_alumno, id_actividad); -- -- Name: profesor profesor_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.profesor ADD CONSTRAINT profesor_pkey PRIMARY KEY (rut_profesor); -- -- Name: region region_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.region ADD CONSTRAINT region_pkey PRIMARY KEY (id_region); -- -- Name: registro registro_pkey; Type: CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.registro ADD CONSTRAINT registro_pkey PRIMARY KEY (rut_alumno, id_asignatura); -- -- Name: actividad_bloque actividad_bloque_id_actividad_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.actividad_bloque ADD CONSTRAINT actividad_bloque_id_actividad_fkey FOREIGN KEY (id_actividad) REFERENCES public.actividad(id_actividad) ON DELETE RESTRICT; -- -- Name: actividad_bloque actividad_bloque_id_bloque_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.actividad_bloque ADD CONSTRAINT actividad_bloque_id_bloque_fkey FOREIGN KEY (id_bloque) REFERENCES public.bloque(id_bloque) ON DELETE RESTRICT; -- -- Name: actividad_nivel actividad_nivel_id_actividad_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.actividad_nivel ADD CONSTRAINT actividad_nivel_id_actividad_fkey FOREIGN KEY (id_actividad) REFERENCES public.actividad(id_actividad) ON DELETE RESTRICT; -- -- Name: actividad_nivel actividad_nivel_id_nivel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.actividad_nivel ADD CONSTRAINT actividad_nivel_id_nivel_fkey FOREIGN KEY (id_nivel) REFERENCES public.nivel(id_nivel) ON DELETE RESTRICT; -- -- Name: actividad actividad_rut_profesor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.actividad ADD CONSTRAINT actividad_rut_profesor_fkey FOREIGN KEY (rut_profesor) REFERENCES public.profesor(rut_profesor) ON DELETE RESTRICT; -- -- Name: alumno alumno_id_ciudad_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.alumno ADD CONSTRAINT alumno_id_ciudad_fkey FOREIGN KEY (id_ciudad) REFERENCES public.ciudad(id_ciudad) ON DELETE RESTRICT; -- -- Name: alumno alumno_rut_apoderado_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.alumno ADD CONSTRAINT alumno_rut_apoderado_fkey FOREIGN KEY (rut_apoderado) REFERENCES public.apoderado(rut_apoderado) ON DELETE RESTRICT; -- -- Name: apoderado apoderado_id_ciudad_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.apoderado ADD CONSTRAINT apoderado_id_ciudad_fkey FOREIGN KEY (id_ciudad) REFERENCES public.ciudad(id_ciudad) ON DELETE RESTRICT; -- -- Name: asignatura asignatura_rut_profesor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.asignatura ADD CONSTRAINT asignatura_rut_profesor_fkey FOREIGN KEY (rut_profesor) REFERENCES public.profesor(rut_profesor) ON DELETE RESTRICT; -- -- Name: asistente asistente_id_curso_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.asistente ADD CONSTRAINT asistente_id_curso_fkey FOREIGN KEY (id_curso) REFERENCES public.curso(id_curso) ON DELETE RESTRICT; -- -- Name: asistente asistente_rut_profesor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.asistente ADD CONSTRAINT asistente_rut_profesor_fkey FOREIGN KEY (rut_profesor) REFERENCES public.profesor(rut_profesor) ON DELETE RESTRICT; -- -- Name: asociado asociado_id_asignatura_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.asociado ADD CONSTRAINT asociado_id_asignatura_fkey FOREIGN KEY (id_asignatura) REFERENCES public.asignatura(id_asignatura) ON DELETE RESTRICT; -- -- Name: asociado asociado_id_curso_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.asociado ADD CONSTRAINT asociado_id_curso_fkey FOREIGN KEY (id_curso) REFERENCES public.curso(id_curso) ON DELETE RESTRICT; -- -- Name: ciudad ciudad_id_region_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.ciudad ADD CONSTRAINT ciudad_id_region_fkey FOREIGN KEY (id_region) REFERENCES public.region(id_region) ON DELETE RESTRICT; -- -- Name: cursar cursar_id_curso_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.cursar ADD CONSTRAINT cursar_id_curso_fkey FOREIGN KEY (id_curso) REFERENCES public.curso(id_curso) ON DELETE RESTRICT; -- -- Name: cursar cursar_rut_alumno_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.cursar ADD CONSTRAINT cursar_rut_alumno_fkey FOREIGN KEY (rut_alumno) REFERENCES public.alumno(rut_alumno) ON DELETE RESTRICT; -- -- Name: curso curso_rut_profesor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.curso ADD CONSTRAINT curso_rut_profesor_fkey FOREIGN KEY (rut_profesor) REFERENCES public.profesor(rut_profesor) ON DELETE RESTRICT; -- -- Name: horario horario_id_asignatura_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.horario ADD CONSTRAINT horario_id_asignatura_fkey FOREIGN KEY (id_asignatura) REFERENCES public.asignatura(id_asignatura) ON DELETE RESTRICT; -- -- Name: horario horario_id_bloque_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.horario ADD CONSTRAINT horario_id_bloque_fkey FOREIGN KEY (id_bloque) REFERENCES public.bloque(id_bloque) ON DELETE RESTRICT; -- -- Name: participar participar_id_actividad_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.participar ADD CONSTRAINT participar_id_actividad_fkey FOREIGN KEY (id_actividad) REFERENCES public.actividad(id_actividad) ON DELETE RESTRICT; -- -- Name: participar participar_rut_alumno_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.participar ADD CONSTRAINT participar_rut_alumno_fkey FOREIGN KEY (rut_alumno) REFERENCES public.alumno(rut_alumno) ON DELETE RESTRICT; -- -- Name: profesor profesor_id_ciudad_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.profesor ADD CONSTRAINT profesor_id_ciudad_fkey FOREIGN KEY (id_ciudad) REFERENCES public.ciudad(id_ciudad) ON DELETE RESTRICT; -- -- Name: registro registro_id_asignatura_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.registro ADD CONSTRAINT registro_id_asignatura_fkey FOREIGN KEY (id_asignatura) REFERENCES public.asignatura(id_asignatura) ON DELETE RESTRICT; -- -- Name: registro registro_rut_alumno_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cromer -- ALTER TABLE ONLY public.registro ADD CONSTRAINT registro_rut_alumno_fkey FOREIGN KEY (rut_alumno) REFERENCES public.alumno(rut_alumno) ON DELETE RESTRICT; -- -- Name: TABLE actividad; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.actividad TO bdd; -- -- Name: TABLE actividad_bloque; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.actividad_bloque TO bdd; -- -- Name: SEQUENCE actividad_id_actividad_seq; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON SEQUENCE public.actividad_id_actividad_seq TO bdd; -- -- Name: TABLE actividad_nivel; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.actividad_nivel TO bdd; -- -- Name: TABLE alumno; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.alumno TO bdd; -- -- Name: TABLE apoderado; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.apoderado TO bdd; -- -- Name: TABLE asignatura; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.asignatura TO bdd; -- -- Name: SEQUENCE asignatura_id_asignatura_seq; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON SEQUENCE public.asignatura_id_asignatura_seq TO bdd; -- -- Name: TABLE asistente; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.asistente TO bdd; -- -- Name: TABLE asociado; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.asociado TO bdd; -- -- Name: TABLE bloque; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.bloque TO bdd; -- -- Name: SEQUENCE bloque_id_bloque_seq; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON SEQUENCE public.bloque_id_bloque_seq TO bdd; -- -- Name: TABLE ciudad; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.ciudad TO bdd; -- -- Name: SEQUENCE ciudad_id_ciudad_seq; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON SEQUENCE public.ciudad_id_ciudad_seq TO bdd; -- -- Name: TABLE cursar; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.cursar TO bdd; -- -- Name: TABLE curso; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.curso TO bdd; -- -- Name: TABLE horario; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.horario TO bdd; -- -- Name: TABLE nivel; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.nivel TO bdd; -- -- Name: SEQUENCE nivel_id_nivel_seq; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON SEQUENCE public.nivel_id_nivel_seq TO bdd; -- -- Name: TABLE participar; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.participar TO bdd; -- -- Name: TABLE profesor; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.profesor TO bdd; -- -- Name: TABLE region; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.region TO bdd; -- -- Name: SEQUENCE region_id_region_seq; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON SEQUENCE public.region_id_region_seq TO bdd; -- -- Name: TABLE registro; Type: ACL; Schema: public; Owner: cromer -- GRANT ALL ON TABLE public.registro TO bdd; -- -- PostgreSQL database dump complete --