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