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