univ
Tables (5)
class_list (Untitled5)
- s_id (Key) — int — Foreign key → student.s_id — NOT NULL
- l_num (Key2) — integer — Foreign key → lecture.l_num
- p_id (Key3) — varchar(10) — Foreign key → professor.p_id — NOT NULL
- 출석점수 (Field) — int — NOT NULL
- 중간점수 (Field2) — varchar(1) — NOT NULL
- 기말점수 (Field3) — varchar(1) — NOT NULL
- 총점 (Field4) — float — NOT NULL
- 평점정보 (Field5) — varchar(10) — NOT NULL
department (Untitled3)
- d_id (Key) — varchar(20) — Primary key — NOT NULL
- d_name (Field) — varchar(20) — NOT NULL
- s_id (Key2) — int — Foreign key → student.s_id — NOT NULL
- d_tel (Field2) — int — NOT NULL
lecture (Untitled4)
- l_num (Key) — integer — Primary key — NOT NULL
- p_id (Key2) — varchar(10) — Foreign key → professor.p_id — NOT NULL
- l_name (Field) — varchar(20) — NOT NULL
- time (Field2) — time
- class (Field3) — varchar(20)
- 학점 (Field4) — varchar(1) — NOT NULL
- year (Field5) — year — NOT NULL
- term (Field6) — varchar(10) — NOT NULL
professor (Untitled)
- p_id (Key) — varchar(10) — Primary key — NOT NULL
- p_name (Field) — varchar(20) — NOT NULL
- p_num (Field2) — varchar(13) — NOT NULL
- p_address (Field3) — varchar(50) — NOT NULL
- p_phone (Field5) — int — NOT NULL
- p_email (Field4) — varchar(30) — NOT NULL
- p_img (Field6) — varchar(500) — NOT NULL
- d_id (Key2) — varchar(20) — Foreign key → department.d_id — NOT NULL
student (Untitled2)
- s_id (Key) — int — Primary key — NOT NULL
- s_name (Field) — varchar(20) — NOT NULL
- s_num (Field2) — varchar(13) — NOT NULL
- s_address (Field3) — varchar(50) — NOT NULL
- s_phone (Field4) — integer — NOT NULL
- s_email (Field5) — varchar(30) — NOT NULL
- s_img (Field6) — varchar(500) — NOT NULL
- grade (Field7) — varchar(10) — NOT NULL
- term (Field8) — varchar(10) — NOT NULL
- p_id (Key3) — varchar(10) — Foreign key → professor.p_id — NOT NULL