TitleSubject text NOT NULL

"TitleSubject" text NOT NULL

);

ALTER TABLE public."Subjects" OWNER TO postgres;

-- TOC entry 173 (class 1259 OID 16409)

-- Name: Teachers; Type: TABLE; Schema: public; Owner: postgres; Tablespace:

CREATE TABLE "Teachers" (

"idTeacher" oid NOT NULL,

"FIOTeacher" text NOT NULL,

"idDepartment" integer NOT NULL

);

ALTER TABLE public."Teachers" OWNER TO postgres;

-- TOC entry 1978 (class 0 OID 16397)

-- Dependencies: 171

-- Data for Name: Departments; Type: TABLE DATA; Schema: public; Owner: postgres

COPY "Departments" ("idDepartment", "TitleDepartment", "PhoneDepartment") FROM stdin; \.

-- TOC entry 1977 (class 0 OID 16394)

-- Dependencies: 170

-- Data for Name: Marks; Type: TABLE DATA; Schema: public; Owner: postgres

COPY "Marks" ("idMark", "LowBalls", "HighBalls") FROM stdin;

-- TOC entry 1983 (class 0 OID 16431)

-- Dependencies: 176

-- Data for Name: Results; Type: TABLE DATA; Schema: public; Owner: postgres

COPY "Results" ("idStudent", "idSubject", "idTeacher", "NumSemestr", "DateExam",

"Balls", "Mark") FROM stdin; \.

-- TOC entry 1981 (class 0 OID 16415)

-- Dependencies: 174

-- Data for Name: Sessions; Type: TABLE DATA; Schema: public; Owner: postgres

COPY "Sessions" ("NumGroup", "NumSemestr", "idSubject", "idTeacher",

"Zach_Exam") FROM stdin; \.

-- TOC entry 1982 (class 0 OID 16423)

-- Dependencies: 175

-- Data for Name: Students; Type: TABLE DATA; Schema: public; Owner: postgres

COPY "Students" ("idStudent", "FIOStudent", "NumGroup") FROM stdin; \.

-- TOC entry 1979 (class 0 OID 16403)

-- Dependencies: 172

-- Data for Name: Subjects; Type: TABLE DATA; Schema: public; Owner: postgres

COPY "Subjects" ("idSubject", "TitleSubject") FROM stdin; \.

-- TOC entry 1980 (class 0 OID 16409)

-- Dependencies: 173

-- Data for Name: Teachers; Type: TABLE DATA; Schema: public; Owner: postgres

COPY "Teachers" ("idTeacher", "FIOTeacher", "idDepartment") FROM stdin; \.

-- TOC entry 1853 (class 2606 OID 16439)

-- Name: pk_department; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: