PRJ5

Tables (5)

class (학급)

  • class_id (학급id) — INT — Primary key — NOT NULL
  • location (지역) — CHAR(5) — NOT NULL
  • group (반) — INT — NOT NULL

coach (코치)

  • coach_id (사번) — INT — Primary key — NOT NULL
  • class_id (반) — INT — Foreign key → class.class_id — NOT NULL
  • role (담당업무) — VARCHAR

consultant (컨설턴트)

  • consultant_id (사번) — INT — Primary key — NOT NULL
  • class_id (반) — INT — Foreign key → class.class_id — NOT NULL
  • role (담당업무) — VARCHAR

course (교육과정)

  • course_id (교육과정id) — INT — Primary key — NOT NULL
  • course_name (교육과정명) — CHAR(3)

trainee (교육생)

  • id (교번) — INT — Primary key
  • class_id (반) — INT — Foreign key → class.class_id — NOT NULL
  • course_id (교육과정id) — INT — Foreign key → course.course_id — NOT NULL
  • generation (기수) — INT
  • name (이름) — CHAR(5)
  • major (전공여부) — BOOLEAN
  • discharge (퇴소여부) — BOOLEAN