LMS
Tables (5)
attend class (수강내역)
- s_id (Key) — bigint — Foreign key → student.s_id — NOT NULL
- c_id (Key3) — bigint — Foreign key → class.c_id — NOT NULL
- p_id (Key2) — bigint — Foreign key → professor.p_id — NOT NULL
- attendance (Field) — integer
- middle (Field2) — integer
- last (Field3) — integer
- etc (Field4) — integer
- all (Field5) — integer
- aver (Field6) — varchar(20)
class (강좌)
- c_id (Key) — bigint — Primary key — NOT NULL
- p_id (Key2) — bigint — Foreign key → professor.p_id — NOT NULL
- name (Field) — varchar(20)
- grade (Field2) — varchar(20)
- time (Field3) — varchar(20)
- infor (Field4) — varchar(20)
- d_id (Key3) — bigint — Foreign key → department.d_id — NOT NULL
department (학과)
- d_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- phone (Field2) — varchar(20)
professor (Untitled2)
- p_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- jumin (Field2) — varchar(40)
- address (Field3) — varchar(50)
- phone (Field4) — varchar(20)
- e-mail (Field5) — varchar(30)
- picture (Field6) — varchar(20)
- d_id (Key2) — bigint — Foreign key → department.d_id — NOT NULL
student (학생)
- s_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- jumin (Field2) — varchar(40)
- address (Field3) — varchar(50)
- phone (Field4) — varchar(20)
- e-mail (Field5) — varchar(30)
- picture (Field6) — varchar(20)
- p_id (Key3) — bigint — Foreign key → professor.p_id — NOT NULL
- d_id (Key2) — bigint — Foreign key → department.d_id — NOT NULL