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)