자율적 교육과정

테이블 (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)