MyERD

Tables (6)

Class_Coach (반_코치)

  • 반 ID (classroomId) — int — Primary key — NOT NULL
  • 코치 ID (coachId) — int

Classroom (반)

  • 반 ID (classroomId) — int — Primary key — NOT NULL
  • 지역 (region) — varchar(50)
  • 반 번호 (number) — int
  • 과정 ID (courseId) — int
  • 컨설턴트 ID (consultantId) — int

Coach (코치)

  • 코치 ID (coachId) — int — Primary key — NOT NULL
  • 반 ID (classroomId) — int — Foreign key → Classroom.반 ID — NOT NULL
  • 이름 (name) — varchar(20)
  • 담당 업무 (duties) — varchar(255)

Consultant (컨설턴트)

  • 컨설턴트 ID (consultantId) — int — Primary key — NOT NULL
  • 반 ID (classroomId) — int — Foreign key → Classroom.반 ID — NOT NULL
  • 이름 (name) — varchar(20)
  • 담당 업무 (duties) — varchar(255)

Course (교육 과정)

  • 과정 ID (courseId) — int — Primary key — NOT NULL
  • 반 ID (classroomId) — int — Foreign key → Classroom.반 ID — NOT NULL
  • 과정 유형 (type) — varchar(5)

Student (교육생)

  • 학번 (studentId) — int — Primary key — NOT NULL
  • 반 ID (classroomId) — int — Foreign key → Classroom.반 ID — NOT NULL
  • 이름 (name) — varchar(20)
  • 기수 (class) — int
  • 전공 (major) — boolean
  • 퇴소 (isWithdrawn) — boolean