MANAGING
Tables (9)
course
- c_no — Char(200) — Primary key — NOT NULL
- c_name — Char(200)
department
- dept_no — Char(200) — Primary key — NOT NULL
- dept_name — Char(200)
- dept_tel — Char(200)
- dept_location — Char(200)
- dept_assistant — Char(200)
dept_pro
- p_id — Char(200) — Foreign key → professor.p_id — NOT NULL
- dept_no — Char(200) — Foreign key → department.dept_no — NOT NULL
dept_pro_course
- inc_no — Integer — Primary key — NOT NULL
- personnel — Integer
- p_id — Char(200) — Foreign key → professor.p_id — NOT NULL
- c_no (c_no1) — Char(200) — Foreign key → course.c_no — NOT NULL
- inc_name — Char(200)
- c_content — Char(200)
- c_progress — Integer
- c_timeweek — Char(200)
- c_starttime — Char(200)
- c_endtime — Char(200)
dept_s
- s_id — Char(200) — Foreign key → student.s_id — NOT NULL
- dept_no (dept_no2) — Char(200) — Foreign key → department.dept_no — NOT NULL
- ins_name — Char(200)
- indept_name — Char(200)
info
- info_id — Integer — Primary key — NOT NULL
- info_title — Char(200)
- info_content — Char(200)
- info_name — Char(200)
professor
- p_id — Char(200) — Primary key — NOT NULL
- p_password — Char(200) — NOT NULL
- p_name — Char(200) — NOT NULL
- p_phone — Char(200) — NOT NULL
- p_room — Char(200) — NOT NULL
student
- s_id — Char(200) — Primary key — NOT NULL
- s_password — Char(200) — NOT NULL
- s_phone — Char(200)
- s_address — Char(200)
- s_birth — Char(200)
- s_grade — Char(200)
- s_name — Char(200)
student_course
- s_id (s_id2) — Char(200) — Foreign key → dept_s.s_id — NOT NULL
- score — Char(200)
- inc_no — Integer — Foreign key → dept_pro_course.inc_no — NOT NULL
- semester (Semester) — Integer