DB설계

테이블 (5)

Class (class)

  • Class ID (class_id) — INT — 기본 키 — NOT NULL
  • Location (location) — ENUM('서울', '대전', '구미', '광주', '부울경')
  • Class Number (class_number) — INT

Coach (coach)

  • Coach ID (coach_id) — INT — 기본 키 — NOT NULL
  • Class ID (class_id) — INT — 외래 키 → Class.Class ID — NOT NULL
  • Name (name) — VARCHAR(50)
  • Duties (duties) — VARCHAR(100)

Consultant (consultant)

  • Consultant ID (consultant_id) — INT — 기본 키 — NOT NULL
  • Class ID (class_id) — INT — 외래 키 → Class.Class ID — NOT NULL
  • Name (name) — VARCHAR(50)
  • Duties (duties) — VARCHAR(100)

Course (course)

  • Course ID (course_id) — INT — 기본 키 — NOT NULL
  • Type (type) — ENUM('공통', '특화','자율')
  • Field

Student (student)

  • Student ID (student_id) — INT — 기본 키 — NOT NULL
  • Class ID (class_id2) — INT — 외래 키 → Class.Class ID — NOT NULL
  • Course ID (course_id) — INT — 외래 키 → Course.Course ID — NOT NULL
  • Name (name) — VARCHAR(50)
  • Major (is_major) — BOOLEAN
  • Graduated (is_graduated) — BOOLEAN
  • Term (term) — INT