You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1232 lines
29 KiB
1232 lines
29 KiB
-- |
|
-- 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 |
|
-- |
|
|
|
|