Хелпикс

Главная

Контакты

Случайная статья





PhoneDepartment text



"PhoneDepartment" text

);

 

ALTER TABLE public."Departments" OWNER TO postgres;

 

--

-- TOC entry 170 (class 1259 OID 16394)

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

--

 

CREATE TABLE "Marks" (

"idMark" integer NOT NULL,

"LowBalls" integer NOT NULL,

"HighBalls" integer NOT NULL

);

 

ALTER TABLE public."Marks" OWNER TO postgres;

--

-- TOC entry 176 (class 1259 OID 16431)

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

--

CREATE TABLE "Results" (

"idStudent" integer NOT NULL,

"idSubject" integer NOT NULL,

"idTeacher" integer NOT NULL,

"NumSemestr" integer NOT NULL,

"DateExam" date,

"Balls" integer, "Mark" integer

);

 

ALTER TABLE public."Results" OWNER TO postgres;

 

--

-- TOC entry 174 (class 1259 OID 16415)

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

--

CREATE TABLE "Sessions" (

"NumGroup" integer NOT NULL,

"NumSemestr" integer NOT NULL,

"idSubject" integer NOT NULL,

"idTeacher" integer NOT NULL,

"Zach_Exam" text

);

 

ALTER TABLE public."Sessions" OWNER TO postgres;

--

-- TOC entry 175 (class 1259 OID 16423)

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

--

 

CREATE TABLE "Students" (

"idStudent" oid NOT NULL,

"FIOStudent" text,

"NumGroup" integer

);

 

ALTER TABLE public."Students" OWNER TO postgres;

--

-- TOC entry 172 (class 1259 OID 16403)

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

--

 

CREATE TABLE "Subjects" (

"idSubject" oid NOT NULL,



  

© helpiks.su При использовании или копировании материалов прямая ссылка на сайт обязательна.