Learning Management

Tables (6)

Course (교육과정)

  • 교육과정_ID — Int — Primary key — NOT NULL
  • 강사_ID (강사_ID2) — Int — Foreign key → Instructor.강사_ID — NOT NULL
  • 운영자_ID (운영자_ID2) — Int — Foreign key → Operator.운영자_ID — NOT NULL
  • 강의명 (강의먕) — Varchar
  • 강의내용 — Varchar

Enrollment (수강)

  • 등록_ID — Int — Primary key — NOT NULL
  • 학생_ID (학생_ID2) — Int — Foreign key → Student.학생_ID — NOT NULL
  • 교육과정_ID (교육과정_ID2) — Int — Foreign key → Course.교육과정_ID — NOT NULL

Instructor (강사)

  • 강사_ID — Int — Primary key — NOT NULL
  • 강사이름 — Varchar

Operator (운영자)

  • 운영자_ID — Int — Primary key — NOT NULL
  • 운영자이름 — Varchar

Review (리뷰)

  • 리뷰_ID — Int — Primary key — NOT NULL
  • 학생_ID (학생_ID2) — Int — Foreign key → Student.학생_ID — NOT NULL
  • 교육과정_ID (교육과정_ID2) — Int — Foreign key → Course.교육과정_ID — NOT NULL
  • 교육과정_ID — Int
  • 학생_ID — Int
  • 평가 — Varchar
  • 내용 — Varchar

Student (학생)

  • 학생_ID — Int — Primary key — NOT NULL
  • 학생이름 — Varchar
  • 이메일 — Varchar