자율적 교육과정
테이블 (9)
Untitled (USER)
- Key (userID) — int(10) — 기본 키 — NOT NULL
- Field (userName) — char(20)
- Field (userGender) — char(1)
- Field (userPhone) — int(10)
- Key (charID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (CHARACTER)
- Key (charID) — int(10) — 기본 키 — NOT NULL
- Field (charName) — char(20)
- Field (charSkill) — text
- Key (userID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (semester)
- Key (yearQuarter) — int(6) — 기본 키 — NOT NULL
Untitled (apply)
- Key (studentID) — int(4) — 기본 키 — NOT NULL
- Field (yearQuarter) — int(6)
- Key (yearQuarter2) — int(6) — 외래 키 → Untitled.Key — NOT NULL
- Key (studentID2) — int(4) — 외래 키 → Untitled.Key — NOT NULL
Untitled (student)
- Key (studentID) — int(4) — 기본 키 — NOT NULL
- Field (studentName) — char(20)
- Field (grade) — int(1)
- Field (studentClass) — int(2)
- Field (number) — int(2)
Untitled (enroll)
- Key (enrollDate) — date — 기본 키 — NOT NULL
- Field (yearQuarter) — int(6)
- Field (studentID) — int(4)
- Field (lectureID) — int(5)
- Key (yearQuarter2) — int(6) — 외래 키 → Untitled.Key — NOT NULL
- Key (studentID2) — int(4) — 외래 키 → Untitled.Key — NOT NULL
- Key (lectureID2) — int(5) — 외래 키 → Untitled.Key — NOT NULL
Untitled (lecture)
- Key (lectureID) — int(5) — 기본 키 — NOT NULL
- Field (credit) — int(1)
- Field (cost) — int(6)
- Field (descriprion) — text
- Field (classID) — int(4)
- Field (teacherID) — int(3)
- Key (classID2) — int(4) — 외래 키 → Untitled.Key — NOT NULL
- Key (teacherID2) — int(3) — 외래 키 → Untitled.Key — NOT NULL
Untitled (class)
- Key (classID) — int(4) — 기본 키 — NOT NULL
- Field (className) — char(20)
Untitled (teacher)
- Key (teacherID) — int(3) — 기본 키 — NOT NULL
- Field (teacherName) — char(3)