backup BD2

--
-- PostgreSQL database dump
--

-- Dumped from database version 17.2
-- Dumped by pg_dump version 17.0

-- Started on 2025-07-03 07:38:04 -04

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_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;

ALTER TABLE IF EXISTS ONLY public.matricula DROP CONSTRAINT IF EXISTS fk_oferta;
ALTER TABLE IF EXISTS ONLY public.matricula DROP CONSTRAINT IF EXISTS fk_estudante;
ALTER TABLE IF EXISTS ONLY public.oferta DROP CONSTRAINT IF EXISTS fk_disciplina;
ALTER TABLE IF EXISTS ONLY public.oferta DROP CONSTRAINT IF EXISTS oferta_pkey;
ALTER TABLE IF EXISTS ONLY public.matricula DROP CONSTRAINT IF EXISTS matricula_pkey;
ALTER TABLE IF EXISTS ONLY public.estudante DROP CONSTRAINT IF EXISTS estudante_pkey;
ALTER TABLE IF EXISTS ONLY public.disciplina DROP CONSTRAINT IF EXISTS disciplina_pkey;
ALTER TABLE IF EXISTS public.oferta ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.disciplina ALTER COLUMN id DROP DEFAULT;
DROP SEQUENCE IF EXISTS public.oferta_id_seq;
DROP TABLE IF EXISTS public.oferta;
DROP TABLE IF EXISTS public.matricula;
DROP TABLE IF EXISTS public.estudante;
DROP SEQUENCE IF EXISTS public.disciplina_id_seq;
DROP TABLE IF EXISTS public.disciplina;
SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- TOC entry 219 (class 1259 OID 16719)
-- Name: disciplina; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.disciplina (
    id integer NOT NULL,
    nome character varying(255) NOT NULL,
    codigo character varying(255) NOT NULL,
    ementa text NOT NULL,
    carga_horaria integer NOT NULL
);


ALTER TABLE public.disciplina OWNER TO postgres;

--
-- TOC entry 218 (class 1259 OID 16718)
-- Name: disciplina_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.disciplina_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.disciplina_id_seq OWNER TO postgres;

--
-- TOC entry 3632 (class 0 OID 0)
-- Dependencies: 218
-- Name: disciplina_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.disciplina_id_seq OWNED BY public.disciplina.id;


--
-- TOC entry 217 (class 1259 OID 16592)
-- Name: estudante; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.estudante (
    ra character varying(6) NOT NULL,
    nome character varying(255) NOT NULL,
    endereco character varying(255) NOT NULL,
    cpf character varying(11) NOT NULL,
    data_nascimento date NOT NULL,
    email character varying(255),
    telefone character varying(255) NOT NULL,
    nome_responsavel character varying(255) NOT NULL,
    genero character varying(1) NOT NULL
);


ALTER TABLE public.estudante OWNER TO postgres;

--
-- TOC entry 222 (class 1259 OID 16739)
-- Name: matricula; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.matricula (
    ra_estudante character varying(6) NOT NULL,
    oferta_id integer NOT NULL
);


ALTER TABLE public.matricula OWNER TO postgres;

--
-- TOC entry 221 (class 1259 OID 16728)
-- Name: oferta; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.oferta (
    id integer NOT NULL,
    ano integer NOT NULL,
    semestre integer NOT NULL,
    quantidade_vagas integer NOT NULL,
    disciplina_id integer NOT NULL
);


ALTER TABLE public.oferta OWNER TO postgres;

--
-- TOC entry 220 (class 1259 OID 16727)
-- Name: oferta_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.oferta_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oferta_id_seq OWNER TO postgres;

--
-- TOC entry 3633 (class 0 OID 0)
-- Dependencies: 220
-- Name: oferta_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.oferta_id_seq OWNED BY public.oferta.id;


--
-- TOC entry 3463 (class 2604 OID 16722)
-- Name: disciplina id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.disciplina ALTER COLUMN id SET DEFAULT nextval('public.disciplina_id_seq'::regclass);


--
-- TOC entry 3464 (class 2604 OID 16731)
-- Name: oferta id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.oferta ALTER COLUMN id SET DEFAULT nextval('public.oferta_id_seq'::regclass);


--
-- TOC entry 3623 (class 0 OID 16719)
-- Dependencies: 219
-- Data for Name: disciplina; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.disciplina VALUES (1, 'Algoritmos e Estruturas de Dados', 'CC101', 'Introdução a algoritmos e estruturas como listas, filas e árvores.', 60);
INSERT INTO public.disciplina VALUES (2, 'Banco de Dados', 'CC102', 'Modelagem, linguagem SQL e SGBDs.', 60);
INSERT INTO public.disciplina VALUES (3, 'Programação Orientada a Objetos', 'CC103', 'Conceitos de orientação a objetos com Java.', 60);
INSERT INTO public.disciplina VALUES (4, 'Sistemas Operacionais', 'CC104', 'Conceitos de processos, memória e sistemas de arquivos.', 60);
INSERT INTO public.disciplina VALUES (5, 'Redes de Computadores', 'CC105', 'Modelo OSI, protocolos e redes locais.', 60);


--
-- TOC entry 3621 (class 0 OID 16592)
-- Dependencies: 217
-- Data for Name: estudante; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.estudante VALUES ('000001', 'Sophie Peixoto', 'Residencial de Nunes, 67, Tres Marias, 82421948 Lima / AM', '15740239850', '2007-07-09', 'caua80@gmail.com', '71 0975 3513', 'Clarice Duarte', 'F');
INSERT INTO public.estudante VALUES ('000002', 'Marcelo Porto', 'Rodovia Caroline Cavalcanti, Jardim Vitoria, 18583-989 Pires de Minas / RN', '65321840717', '2007-07-06', 'costelaheitor@cardoso.br', '51 4833 9694', 'Luna Moraes', 'F');
INSERT INTO public.estudante VALUES ('000003', 'Igor Correia', 'Loteamento de da Mota, 50, Canadá, 52560123 Teixeira / RN', '10957486375', '2005-09-12', 'aragaojoao-pedro@costa.com', '+55 (031) 8691 4131', 'Fernanda Monteiro', 'M');
INSERT INTO public.estudante VALUES ('000004', 'Carolina Caldeira', 'Colônia de Novaes, Dom Bosco, 57923-022 Souza Paulista / AM', '97203584160', '2006-01-05', 'helenaalves@uol.com.br', '+55 21 5084 2375', 'Esther Moraes', 'F');
INSERT INTO public.estudante VALUES ('000005', 'Maysa Costela', 'Pátio de Cardoso, 4, Vila Mangueiras, 23376-960 Peixoto do Norte / CE', '71458392023', '2000-01-24', 'pedro-henrique70@uol.com.br', '+55 (071) 8120-6650', 'André Almeida', 'F');
INSERT INTO public.estudante VALUES ('000006', 'Marcela Castro', 'Via de da Paz, Buritis, 42176-104 Correia de Fernandes / BA', '85167203490', '2002-11-26', 'thomas90@ig.com.br', '0500-776-5823', 'Maria Sophia Gonçalves', 'F');
INSERT INTO public.estudante VALUES ('000007', 'Daniel da Costa', 'Núcleo Melissa Carvalho, 19, Araguaia, 22945-682 Correia do Amparo / SC', '30417826931', '2004-06-29', 'castrohelena@uol.com.br', '(071) 5517-1760', 'Isaac da Costa', 'F');
INSERT INTO public.estudante VALUES ('000008', 'Pedro Lucas Nascimento', 'Estrada das Neves, Beira Linha, 01688-477 Pereira / AP', '53471896066', '2000-06-27', 'hda-paz@novaes.org', '+55 (084) 0392-1376', 'Sr. Calebe Rodrigues', 'F');
INSERT INTO public.estudante VALUES ('000009', 'Miguel Nunes', 'Viela Pedro Sales, 93, Vera Cruz, 05550824 Nascimento / RJ', '47160953207', '2001-08-15', 'antonio75@da.br', '51 8091 8916', 'Gustavo Teixeira', 'F');
INSERT INTO public.estudante VALUES ('000010', 'Kamilly Rocha', 'Fazenda de Aragão, 3, Jardim Vitoria, 51744-666 da Cruz / RS', '23459071699', '2001-10-19', 'da-costathales@uol.com.br', '+55 (051) 9767 0172', 'Arthur Costela', 'M');
INSERT INTO public.estudante VALUES ('000011', 'Giovanna Cavalcanti', 'Residencial Enzo Gabriel Caldeira, 679, Vila Da Luz, 94264183 Novaes / PB', '53729048104', '2003-09-30', 'lorenzocarvalho@santos.org', '+55 61 2696 1161', 'Kaique da Costa', 'M');
INSERT INTO public.estudante VALUES ('000012', 'Srta. Vitória Porto', 'Alameda Cecília Martins, 61, Biquinhas, 50552035 da Conceição / DF', '03159248615', '2003-05-13', 'ana-vitoriacorreia@monteiro.org', '+55 81 0355 7448', 'Giovanna da Mata', 'F');
INSERT INTO public.estudante VALUES ('000013', 'Ana Júlia Cavalcanti', 'Distrito Fernando das Neves, 48, Floramar, 45602906 Cardoso / BA', '64951837200', '2000-11-03', 'omoura@nascimento.com', '84 5735 4712', 'Guilherme Correia', 'M');
INSERT INTO public.estudante VALUES ('000014', 'Maria da Costa', 'Pátio Pinto, 83, Manacas, 57173407 Almeida de da Rosa / MA', '14235607952', '2003-05-10', 'lorena01@yahoo.com.br', '+55 (061) 0468 9671', 'Sra. Isabella Gomes', 'M');
INSERT INTO public.estudante VALUES ('000015', 'Catarina Cardoso', 'Lagoa Emilly Mendes, Candelaria, 21644829 Teixeira / AM', '68952731077', '2002-01-27', 'nascimentoalana@cunha.org', '11 7637 7857', 'Ana Carolina Pires', 'F');
INSERT INTO public.estudante VALUES ('000016', 'Danilo Sales', 'Alameda Moraes, 16, Gutierrez, 16050190 Gonçalves de Goiás / BA', '94307521625', '2005-01-10', 'cda-conceicao@ig.com.br', '+55 (011) 8523-2756', 'Luiza Nogueira', 'M');
INSERT INTO public.estudante VALUES ('000017', 'Srta. Vitória da Paz', 'Avenida de Nogueira, 4, Vila Califórnia, 25023949 Silva / SP', '45630972170', '2007-09-29', 'vda-rosa@yahoo.com.br', '+55 (061) 0025 0402', 'Yuri Pereira', 'F');
INSERT INTO public.estudante VALUES ('000018', 'Clarice Novaes', 'Loteamento Cavalcanti, 615, São Jorge 1ª Seção, 54080-351 Souza / MS', '39456278182', '2003-09-26', 'maysa30@yahoo.com.br', '81 1077-7067', 'Laura Costa', 'M');
INSERT INTO public.estudante VALUES ('000019', 'Bruno Duarte', 'Pátio da Rosa, 29, Novo São Lucas, 86023-732 Moraes Alegre / PA', '18476925328', '2003-11-04', 'arthurcosta@bol.com.br', '+55 41 2633 4088', 'Ana Beatriz Costa', 'M');
INSERT INTO public.estudante VALUES ('000020', 'Melissa Fogaça', 'Morro de Dias, 443, Belmonte, 53574-922 Vieira / PE', '59061387221', '2001-09-16', 'pda-rosa@dias.com', '11 1908-9577', 'André das Neves', 'F');
INSERT INTO public.estudante VALUES ('000021', 'Milena da Cruz', 'Recanto de Viana, 51, Cinquentenário, 35460-305 Mendes / PB', '34571206925', '2001-12-22', 'rodriguesleticia@gmail.com', '+55 (041) 3003 5105', 'Lara Cunha', 'F');
INSERT INTO public.estudante VALUES ('000022', 'Levi Pinto', 'Estação Maitê Melo, 16, Nova America, 88709-166 Almeida / PE', '28907146594', '2002-04-11', 'pereirajulia@ramos.com', '0800-904-5600', 'Ana Laura Moraes', 'M');
INSERT INTO public.estudante VALUES ('000023', 'Raul da Costa', 'Morro de da Cruz, 55, Vista Do Sol, 60484-870 Azevedo dos Dourados / MG', '16530728490', '2003-09-21', 'sarahsouza@bol.com.br', '(081) 6431 9539', 'Rebeca Teixeira', 'F');
INSERT INTO public.estudante VALUES ('000024', 'Isabella da Cruz', 'Aeroporto de Barros, 625, Jardim Felicidade, 57696-202 Pires / BA', '50796218340', '2004-02-22', 'caueda-cruz@santos.br', '(021) 4440-6448', 'Maria Clara Lopes', 'F');
INSERT INTO public.estudante VALUES ('000025', 'Sr. Thales Pinto', 'Rodovia da Costa, 865, Aparecida 7ª Seção, 93058-235 Aragão de Farias / RJ', '34269058170', '2008-01-23', 'isaacpires@pereira.br', '+55 81 4659-5140', 'Alana Fernandes', 'F');
INSERT INTO public.estudante VALUES ('000026', 'Vitor Hugo Novaes', 'Vereda de Nogueira, 8, Maria Helena, 94506782 Cardoso / RJ', '59071634884', '1999-11-01', 'wcostela@ig.com.br', '+55 84 6292-6480', 'Cauê Cunha', 'M');
INSERT INTO public.estudante VALUES ('000027', 'Rafaela Barbosa', 'Vila de Nogueira, 25, Boa Vista, 43454487 Porto / PI', '20954876300', '2007-03-03', 'ksilveira@cunha.br', '84 0818-5011', 'Maria Moraes', 'F');
INSERT INTO public.estudante VALUES ('000028', 'Lavínia Melo', 'Vereda Erick Cunha, 30, Vila Paquetá, 05930604 Barros da Serra / MS', '16032458989', '2007-02-13', 'benicioramos@yahoo.com.br', '+55 (071) 6151-1050', 'João Alves', 'F');
INSERT INTO public.estudante VALUES ('000029', 'Dr. Marcos Vinicius Sales', 'Setor Nunes, Vila Suzana Segunda Seção, 08115-517 da Costa / PE', '40832197505', '2002-02-08', 'benjamin76@das.org', '(071) 2353 2675', 'Beatriz Nogueira', 'F');
INSERT INTO public.estudante VALUES ('000030', 'Stella Alves', 'Viela Nogueira, 12, Alto Dos Pinheiros, 80001-992 Nascimento / SE', '06845219389', '2008-01-31', 'icardoso@monteiro.com', '(021) 6376-3637', 'Maria Luiza Campos', 'M');


--
-- TOC entry 3626 (class 0 OID 16739)
-- Dependencies: 222
-- Data for Name: matricula; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.matricula VALUES ('000013', 2);
INSERT INTO public.matricula VALUES ('000028', 4);
INSERT INTO public.matricula VALUES ('000013', 11);
INSERT INTO public.matricula VALUES ('000026', 11);
INSERT INTO public.matricula VALUES ('000025', 11);
INSERT INTO public.matricula VALUES ('000027', 15);
INSERT INTO public.matricula VALUES ('000002', 7);
INSERT INTO public.matricula VALUES ('000017', 13);
INSERT INTO public.matricula VALUES ('000015', 7);
INSERT INTO public.matricula VALUES ('000001', 2);
INSERT INTO public.matricula VALUES ('000023', 3);
INSERT INTO public.matricula VALUES ('000027', 8);
INSERT INTO public.matricula VALUES ('000022', 11);
INSERT INTO public.matricula VALUES ('000030', 15);
INSERT INTO public.matricula VALUES ('000002', 9);
INSERT INTO public.matricula VALUES ('000017', 15);
INSERT INTO public.matricula VALUES ('000015', 9);
INSERT INTO public.matricula VALUES ('000001', 4);
INSERT INTO public.matricula VALUES ('000024', 8);
INSERT INTO public.matricula VALUES ('000018', 5);
INSERT INTO public.matricula VALUES ('000010', 6);
INSERT INTO public.matricula VALUES ('000005', 1);
INSERT INTO public.matricula VALUES ('000014', 6);
INSERT INTO public.matricula VALUES ('000013', 6);
INSERT INTO public.matricula VALUES ('000027', 1);
INSERT INTO public.matricula VALUES ('000026', 6);
INSERT INTO public.matricula VALUES ('000012', 15);
INSERT INTO public.matricula VALUES ('000003', 2);
INSERT INTO public.matricula VALUES ('000022', 4);
INSERT INTO public.matricula VALUES ('000030', 8);
INSERT INTO public.matricula VALUES ('000003', 11);
INSERT INTO public.matricula VALUES ('000022', 13);
INSERT INTO public.matricula VALUES ('000015', 2);
INSERT INTO public.matricula VALUES ('000008', 14);
INSERT INTO public.matricula VALUES ('000024', 1);
INSERT INTO public.matricula VALUES ('000004', 12);
INSERT INTO public.matricula VALUES ('000018', 7);
INSERT INTO public.matricula VALUES ('000001', 15);
INSERT INTO public.matricula VALUES ('000011', 14);
INSERT INTO public.matricula VALUES ('000019', 11);
INSERT INTO public.matricula VALUES ('000023', 7);
INSERT INTO public.matricula VALUES ('000006', 4);
INSERT INTO public.matricula VALUES ('000005', 15);
INSERT INTO public.matricula VALUES ('000003', 4);
INSERT INTO public.matricula VALUES ('000030', 10);
INSERT INTO public.matricula VALUES ('000029', 11);
INSERT INTO public.matricula VALUES ('000002', 13);
INSERT INTO public.matricula VALUES ('000016', 2);
INSERT INTO public.matricula VALUES ('000001', 8);
INSERT INTO public.matricula VALUES ('000011', 7);
INSERT INTO public.matricula VALUES ('000019', 4);
INSERT INTO public.matricula VALUES ('000025', 1);
INSERT INTO public.matricula VALUES ('000006', 6);
INSERT INTO public.matricula VALUES ('000012', 10);
INSERT INTO public.matricula VALUES ('000003', 6);
INSERT INTO public.matricula VALUES ('000003', 15);
INSERT INTO public.matricula VALUES ('000016', 4);
INSERT INTO public.matricula VALUES ('000020', 1);
INSERT INTO public.matricula VALUES ('000010', 3);
INSERT INTO public.matricula VALUES ('000010', 12);
INSERT INTO public.matricula VALUES ('000007', 3);
INSERT INTO public.matricula VALUES ('000014', 3);
INSERT INTO public.matricula VALUES ('000023', 2);
INSERT INTO public.matricula VALUES ('000009', 8);
INSERT INTO public.matricula VALUES ('000026', 3);
INSERT INTO public.matricula VALUES ('000006', 8);
INSERT INTO public.matricula VALUES ('000022', 1);
INSERT INTO public.matricula VALUES ('000030', 5);
INSERT INTO public.matricula VALUES ('000022', 10);
INSERT INTO public.matricula VALUES ('000008', 11);
INSERT INTO public.matricula VALUES ('000021', 2);
INSERT INTO public.matricula VALUES ('000015', 8);
INSERT INTO public.matricula VALUES ('000004', 9);
INSERT INTO public.matricula VALUES ('000007', 5);
INSERT INTO public.matricula VALUES ('000023', 4);
INSERT INTO public.matricula VALUES ('000006', 1);
INSERT INTO public.matricula VALUES ('000007', 14);
INSERT INTO public.matricula VALUES ('000012', 14);
INSERT INTO public.matricula VALUES ('000005', 12);
INSERT INTO public.matricula VALUES ('000003', 1);
INSERT INTO public.matricula VALUES ('000022', 3);
INSERT INTO public.matricula VALUES ('000028', 10);
INSERT INTO public.matricula VALUES ('000025', 8);
INSERT INTO public.matricula VALUES ('000029', 8);
INSERT INTO public.matricula VALUES ('000008', 13);
INSERT INTO public.matricula VALUES ('000027', 12);
INSERT INTO public.matricula VALUES ('000015', 1);
INSERT INTO public.matricula VALUES ('000017', 10);
INSERT INTO public.matricula VALUES ('000020', 14);
INSERT INTO public.matricula VALUES ('000023', 6);
INSERT INTO public.matricula VALUES ('000005', 14);
INSERT INTO public.matricula VALUES ('000022', 5);
INSERT INTO public.matricula VALUES ('000008', 6);
INSERT INTO public.matricula VALUES ('000027', 5);
INSERT INTO public.matricula VALUES ('000028', 12);
INSERT INTO public.matricula VALUES ('000029', 10);
INSERT INTO public.matricula VALUES ('000004', 4);
INSERT INTO public.matricula VALUES ('000004', 13);
INSERT INTO public.matricula VALUES ('000002', 15);
INSERT INTO public.matricula VALUES ('000018', 8);
INSERT INTO public.matricula VALUES ('000011', 15);
INSERT INTO public.matricula VALUES ('000024', 5);
INSERT INTO public.matricula VALUES ('000007', 9);
INSERT INTO public.matricula VALUES ('000028', 5);
INSERT INTO public.matricula VALUES ('000022', 7);
INSERT INTO public.matricula VALUES ('000027', 7);
INSERT INTO public.matricula VALUES ('000017', 5);
INSERT INTO public.matricula VALUES ('000002', 8);
INSERT INTO public.matricula VALUES ('000020', 9);
INSERT INTO public.matricula VALUES ('000019', 5);
INSERT INTO public.matricula VALUES ('000018', 10);
INSERT INTO public.matricula VALUES ('000024', 7);
INSERT INTO public.matricula VALUES ('000001', 12);
INSERT INTO public.matricula VALUES ('000005', 9);
INSERT INTO public.matricula VALUES ('000008', 1);
INSERT INTO public.matricula VALUES ('000028', 7);
INSERT INTO public.matricula VALUES ('000013', 14);
INSERT INTO public.matricula VALUES ('000027', 9);
INSERT INTO public.matricula VALUES ('000020', 2);
INSERT INTO public.matricula VALUES ('000021', 4);
INSERT INTO public.matricula VALUES ('000020', 11);
INSERT INTO public.matricula VALUES ('000019', 7);
INSERT INTO public.matricula VALUES ('000007', 13);
INSERT INTO public.matricula VALUES ('000010', 7);
INSERT INTO public.matricula VALUES ('000022', 2);
INSERT INTO public.matricula VALUES ('000023', 15);
INSERT INTO public.matricula VALUES ('000028', 9);
INSERT INTO public.matricula VALUES ('000026', 7);
INSERT INTO public.matricula VALUES ('000006', 12);
INSERT INTO public.matricula VALUES ('000027', 11);
INSERT INTO public.matricula VALUES ('000004', 1);
INSERT INTO public.matricula VALUES ('000030', 9);
INSERT INTO public.matricula VALUES ('000004', 10);
INSERT INTO public.matricula VALUES ('000020', 4);
INSERT INTO public.matricula VALUES ('000021', 6);
INSERT INTO public.matricula VALUES ('000015', 12);
INSERT INTO public.matricula VALUES ('000020', 13);
INSERT INTO public.matricula VALUES ('000016', 10);
INSERT INTO public.matricula VALUES ('000010', 9);
INSERT INTO public.matricula VALUES ('000007', 15);
INSERT INTO public.matricula VALUES ('000005', 4);
INSERT INTO public.matricula VALUES ('000005', 13);
INSERT INTO public.matricula VALUES ('000006', 14);
INSERT INTO public.matricula VALUES ('000003', 5);
INSERT INTO public.matricula VALUES ('000002', 14);
INSERT INTO public.matricula VALUES ('000019', 2);
INSERT INTO public.matricula VALUES ('000011', 5);
INSERT INTO public.matricula VALUES ('000024', 13);
INSERT INTO public.matricula VALUES ('000010', 11);
INSERT INTO public.matricula VALUES ('000023', 1);


--
-- TOC entry 3625 (class 0 OID 16728)
-- Dependencies: 221
-- Data for Name: oferta; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.oferta VALUES (1, 2023, 1, 27, 1);
INSERT INTO public.oferta VALUES (2, 2023, 1, 10, 2);
INSERT INTO public.oferta VALUES (3, 2023, 1, 12, 3);
INSERT INTO public.oferta VALUES (4, 2023, 1, 22, 4);
INSERT INTO public.oferta VALUES (5, 2023, 1, 30, 5);
INSERT INTO public.oferta VALUES (6, 2023, 2, 10, 1);
INSERT INTO public.oferta VALUES (7, 2023, 2, 29, 2);
INSERT INTO public.oferta VALUES (8, 2023, 2, 25, 3);
INSERT INTO public.oferta VALUES (9, 2023, 2, 20, 4);
INSERT INTO public.oferta VALUES (10, 2023, 2, 17, 5);
INSERT INTO public.oferta VALUES (11, 2024, 1, 20, 1);
INSERT INTO public.oferta VALUES (12, 2024, 1, 12, 2);
INSERT INTO public.oferta VALUES (13, 2024, 1, 16, 3);
INSERT INTO public.oferta VALUES (14, 2024, 1, 28, 4);
INSERT INTO public.oferta VALUES (15, 2024, 1, 17, 5);


--
-- TOC entry 3634 (class 0 OID 0)
-- Dependencies: 218
-- Name: disciplina_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.disciplina_id_seq', 1, false);


--
-- TOC entry 3635 (class 0 OID 0)
-- Dependencies: 220
-- Name: oferta_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.oferta_id_seq', 1, false);


--
-- TOC entry 3468 (class 2606 OID 16726)
-- Name: disciplina disciplina_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.disciplina
    ADD CONSTRAINT disciplina_pkey PRIMARY KEY (id);


--
-- TOC entry 3466 (class 2606 OID 16596)
-- Name: estudante estudante_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.estudante
    ADD CONSTRAINT estudante_pkey PRIMARY KEY (ra);


--
-- TOC entry 3472 (class 2606 OID 16743)
-- Name: matricula matricula_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.matricula
    ADD CONSTRAINT matricula_pkey PRIMARY KEY (ra_estudante, oferta_id);


--
-- TOC entry 3470 (class 2606 OID 16733)
-- Name: oferta oferta_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.oferta
    ADD CONSTRAINT oferta_pkey PRIMARY KEY (id);


--
-- TOC entry 3473 (class 2606 OID 16734)
-- Name: oferta fk_disciplina; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.oferta
    ADD CONSTRAINT fk_disciplina FOREIGN KEY (disciplina_id) REFERENCES public.disciplina(id);


--
-- TOC entry 3474 (class 2606 OID 16744)
-- Name: matricula fk_estudante; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.matricula
    ADD CONSTRAINT fk_estudante FOREIGN KEY (ra_estudante) REFERENCES public.estudante(ra);


--
-- TOC entry 3475 (class 2606 OID 16749)
-- Name: matricula fk_oferta; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.matricula
    ADD CONSTRAINT fk_oferta FOREIGN KEY (oferta_id) REFERENCES public.oferta(id);


-- Completed on 2025-07-03 07:38:04 -04

--
-- PostgreSQL database dump complete
--