MyERD

Tables (5)

CLASS (반)

  • class_id (반 번호) — PRIMARY KEY — Primary key
  • region (지역) — NOT NULL
  • consultant_id (컨설턴트 ID) — FOREIGN KEY, NOT NULL
  • coach_id (코치 ID) — FOREIGN KEY
  • name (이름) — NOT NULL
  • curri_id (커리큘럼ID) — PRIMARY KEY — Foreign key → CURRICULUM.curri_id

COACH (코치)

  • coach_id (코치 번호) — PRIMARY KEY — Primary key
  • s_id (반 번호) — PRIMARY KEY — Foreign key → CLASS.class_id
  • name (코치 이름) — NOT NULL
  • column (name) — Attribute — NOT NULL

CONSULTANT (컨설턴트)

  • consultant_id (컨설턴트 ID) — PRIMARY KEY
  • name (컨설턴트 이름) — NOT NULL
  • s_id (반 번호) — PRIMARY KEY — Foreign key → CLASS.class_id

CURRICULUM (교육과정)

  • curri_id (커리큘럼ID) — PRIMARY KEY — Primary key
  • region (지역) — NOT NULL
  • kind (공통/특화/자율) — NOT NULL
  • name (커리큘럼이름) — NOT NULL

STUDENT (교육생)

  • s_id (학번) — PRIMARY KEY — Primary key — NOT NULL
  • major (전공/비전공) — NOT NULL — NOT NULL
  • discharge (퇴소여부) — NOT NULL
  • name (이름) — NOT NULL
  • terms (기수) — NOT NULL
  • s_id (반 번호) — PRIMARY KEY — Foreign key → CLASS.class_id