Лабораторные работы, 3 сем, 2021-2022 / Телеграм бот / schedule

--
-- PostgreSQL database dump
--

-- Dumped from database version 14.1
-- Dumped by pg_dump version 14.1

-- Started on 2021-12-05 21:09:04

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_table_access_method = heap;

--
-- TOC entry 209 (class 1259 OID 16405)
-- Name: subject; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.subject (
name character varying NOT NULL
);


ALTER TABLE public.subject OWNER TO postgres;

--
-- TOC entry 213 (class 1259 OID 16427)
-- Name: teacher; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.teacher (
id integer NOT NULL,
full_name character varying,
subject character varying,
day character varying NOT NULL
);


ALTER TABLE public.teacher OWNER TO postgres;

--
-- TOC entry 212 (class 1259 OID 16426)
-- Name: teacher_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.teacher_id_seq OWNER TO postgres;

--
-- TOC entry 3332 (class 0 OID 0)
-- Dependencies: 212
-- Name: teacher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.teacher_id_seq OWNED BY public.teacher.id;


--
-- TOC entry 211 (class 1259 OID 16413)
-- Name: timetable; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.timetable (
id integer NOT NULL,
day character varying,
subject character varying,
room_numb character varying,
start_time time without time zone
);


ALTER TABLE public.timetable OWNER TO postgres;

--
-- TOC entry 210 (class 1259 OID 16412)
-- Name: timetable_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.timetable_id_seq OWNER TO postgres;

--
-- TOC entry 3333 (class 0 OID 0)
-- Dependencies: 210
-- Name: timetable_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.timetable_id_seq OWNED BY public.timetable.id;


--
-- TOC entry 3174 (class 2604 OID 16430)
-- Name: teacher id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 3173 (class 2604 OID 16416)
-- Name: timetable id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 3322 (class 0 OID 16405)
-- Dependencies: 209
-- Data for Name: subject; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.subject (name) VALUES ('Введение в ИТ');
INSERT INTO public.subject (name) VALUES ('Высш. мат.');
INSERT INTO public.subject (name) VALUES ('Электроника');
INSERT INTO public.subject (name) VALUES ('Выч. тех.');
INSERT INTO public.subject (name) VALUES ('Физ-ра');
INSERT INTO public.subject (name) VALUES ('Экология');
INSERT INTO public.subject (name) VALUES ('Правоведение');
INSERT INTO public.subject (name) VALUES ('ТВиМС');
INSERT INTO public.subject (name) VALUES ('Ин. яз.');
INSERT INTO public.subject (name) VALUES ('ОКАЭЦ');
INSERT INTO public.subject (name) VALUES ('История средств связи');


--
-- TOC entry 3326 (class 0 OID 16427)
-- Dependencies: 213
-- Data for Name: teacher; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.teacher (id, full_name, subject, day) VALUES (2, 'Ведерников Н.', 'Введение в ИТ', 'понедельник 0');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (3, 'Сретенская Н.В.', 'Электроника', 'понедельник 1');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (4, 'Свентковский', 'Высш. мат.', 'понедельник 0');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (5, 'Селезнев В.С.', 'Выч. тех.', 'понедельник 2');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (6, 'Антипов А.А.', 'Правоведение', 'вторник 1');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (7, 'Ерофеева В.В.', 'Экология', 'вторник 1');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (8, 'Крысанов Д.В.', 'ТВиМС', 'среда 0');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (9, 'Чайка А.', 'Введение в ИТ', 'среда 0');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (10, 'Орлова Г.Л.', 'Ин. яз.', 'среда 0');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (11, 'Воронкова М.Н.', 'Выч. тех.', 'четверг 0');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (12, 'Сретенская Н.В.', 'Электроника', 'четверг 0');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (13, 'Микиртичан А.Г.', 'ОКАЭЦ', 'четверг 0');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (14, 'Аршинов Е.', 'Введение в ИТ', 'четверг 0');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (15, 'Дёмин Д.Б.', 'ТВиМС', 'пятница 2');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (16, 'Калабекьянц Н.Э.', 'История средств связи', 'пятница 2');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (17, 'Еровеева В.В.', 'Экология', 'пятница 2');
INSERT INTO public.teacher (id, full_name, subject, day) VALUES (18, 'Мейрманов А.М.', 'Высш. мат.', 'суббота 0');


--
-- TOC entry 3324 (class 0 OID 16413)
-- Dependencies: 211
-- Data for Name: timetable; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (14, 'понедельник 1', 'Электроника', 'Дистанционно', '17:15:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (4, 'понедельник 0', 'Введение в ИТ', 'Дистанционно', '11:20:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (5, 'понедельник 0', 'Высш. мат.', 'Дистанционно', '15:25:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (15, 'понедельник 2', 'Выч. тех.', 'Дистанционно', '17:15:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (16, 'вторник 1', 'Физ-ра', 'Дистанционно', '09:30:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (17, 'вторник 1', 'Экология', 'Дистанционно', '11:20:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (18, 'вторник 1', 'Правоведение', 'Дистанционно', '13:10:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (19, 'вторник 1', 'Правоведение', 'Дистанционно', '15:25:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (20, 'вторник 2', 'Физ-ра', 'Дистанционно', '13:10:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (6, 'среда 0', 'ТВиМС', 'Дистанционно', '09:30:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (7, 'среда 0', 'Введение в ИТ', 'Дистанционно', '11:20:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (8, 'среда 0', 'Физ-ра', 'Дистанционно', '13:10:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (9, 'среда 0', 'Ин. яз.', 'Дистанционно', '15:25:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (10, 'четверг 0', 'Выч. тех.', 'Дистанционно', '11:20:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (11, 'четверг 0', 'Электроника', 'Дистанционно', '13:10:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (12, 'четверг 0', 'ОКАЭЦ', 'Дистанционно', '15:25:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (13, 'четверг 0', 'Введение в ИТ', 'Дистанционно', '17:15:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (21, 'пятница 2', 'ТВиМС', 'Дистанционно', '09:30:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (22, 'пятница 2', 'История средств связи', 'Дистанционно', '11:20:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (23, 'пятница 2', 'История средств связи', 'Дистанционно', '13:10:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (24, 'пятница 2', 'Экология', 'Дистанционно', '15:25:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (25, 'суббота 0', 'Высш. мат.', 'Дистанционно', '11:20:00');
INSERT INTO public.timetable (id, day, subject, room_numb, start_time) VALUES (26, 'суббота 0', 'Высш. мат.', 'Дистанционно', '13:10:00');


--
-- TOC entry 3334 (class 0 OID 0)
-- Dependencies: 212
-- Name: teacher_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.teacher_id_seq', 18, true);


--
-- TOC entry 3335 (class 0 OID 0)
-- Dependencies: 210
-- Name: timetable_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.timetable_id_seq', 26, true);


--
-- TOC entry 3176 (class 2606 OID 16411)
-- Name: subject subject_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subject
ADD CONSTRAINT subject_pkey PRIMARY KEY (name);


--
-- TOC entry 3180 (class 2606 OID 16434)
-- Name: teacher teacher_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.teacher
ADD CONSTRAINT teacher_pkey PRIMARY KEY (id);


--
-- TOC entry 3178 (class 2606 OID 16420)
-- Name: timetable timetable_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.timetable
ADD CONSTRAINT timetable_pkey PRIMARY KEY (id);


--
-- TOC entry 3182 (class 2606 OID 16435)
-- Name: teacher teacher_subject_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.teacher
ADD CONSTRAINT teacher_subject_fkey FOREIGN KEY (subject) REFERENCES public.subject(name);


--
-- TOC entry 3181 (class 2606 OID 16421)
-- Name: timetable timetable_subject_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.timetable
ADD CONSTRAINT timetable_subject_fkey FOREIGN KEY (subject) REFERENCES public.subject(name);


-- Completed on 2021-12-05 21:09:04

--
-- PostgreSQL database dump complete
--