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