student

Tables (6)

Batch (기수)

  • 기수 (Batch) — Primary key — NOT NULL

Class (반)

  • 반ID (ClassID) — INT — Primary key — NOT NULL
  • 교육과정ID (CourseID) — INT — Foreign key → Course.교육과정ID — NOT NULL
  • 지역 (Region) — varchar(50) — NOT NULL
  • 반 (ClassNumber) — INT — NOT NULL

Coach (코치)

  • 코치 ID (CoachID) — INT — Primary key — NOT NULL
  • 반ID (ClassID) — INT — Foreign key → Class.반ID — NOT NULL
  • 교육과정ID (CourseID) — INT — Foreign key → Class.교육과정ID — NOT NULL
  • 이름 (Name) — varchar(100)
  • 담당업무 (Duty) — varchar(100)

Consultant (컨설턴트)

  • 컨설턴트ID (ConsultantID) — INT — Primary key — NOT NULL
  • 반ID (ClassID) — INT — Foreign key → Class.반ID — NOT NULL
  • 교육과정ID (CourseID) — INT — Foreign key → Class.교육과정ID — NOT NULL
  • 이름 (Name) — varchar(100)
  • 담당업무 (Duty) — varchar(100)

Course (교육 과정)

  • 교육과정ID (CourseID) — INT — Primary key — NOT NULL
  • 과정유형 (CourseType) — varchar(50)

Student (교육생)

  • 교육생 ID (StudentID) — INT — Primary key — NOT NULL
  • 기수 (Batch) — Foreign key → Batch.기수 — NOT NULL
  • 반ID (ClassID) — INT — Foreign key → Class.반ID — NOT NULL
  • 교육과정ID (CourseID) — INT — Foreign key → Class.교육과정ID — NOT NULL
  • 교육생 이름 (Name) — varchar(100)
  • 전공 비전공 (Major) — Boolean — NOT NULL
  • 퇴소 여부 (Graduated) — Boolean — NOT NULL