LMS
Tables (5)
Complete (수료)
- com_uid (Key) — varchar(10) — Primary key — NOT NULL
- Le_uid (Key2) — varchar(10) — Foreign key → Lecture.Le_uid — NOT NULL
- St_uid (Key3) — varchar(10) — Foreign key → Student.St_uid — NOT NULL
- com_date (Field) — date
Course (수강)
- course_uid (Key) — varchar(10) — Primary key — NOT NULL
- St_uid (Key2) — varchar(10) — Foreign key → Student.St_uid — NOT NULL
- Le_uid (Key3) — varchar(10) — Foreign key → Lecture.Le_uid — NOT NULL
- taken_time (Field3) — varchar(100)
Enrolment (수강신청)
- En_uid (Key) — varchar(10) — Primary key — NOT NULL
- Le_uid (Key2) — varchar(10) — Foreign key → Lecture.Le_uid — NOT NULL
- St_uid (Key3) — varchar(10) — Foreign key → Student.St_uid — NOT NULL
- applicate (Field) — varchar(20)
Lecture (강의목록)
- Le_uid (Key) — varchar(10) — Primary key — NOT NULL
- pro_name (Field) — varchar(20)
- class_name (Field2) — varchar(50)
Student (학생테이블)
- St_uid (Key) — varchar(10) — Primary key — NOT NULL
- id (Field) — varchar(15)
- pass (Field2) — varchar(30)
- name (Field3) — varchar(10)
- phone (Field4) — varchar(30)