1233 lines
29 KiB
MySQL
1233 lines
29 KiB
MySQL
|
--
|
||
|
-- 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
|
||
|
--
|
||
|
|