ㅁ
Tables (7)
class
- 반고유번호 (class_seq) — INT — Primary key
- 코치고유번호 (coach_seq) — INT — Foreign key → coach.코치고유번호 — NOT NULL
- 컨설턴트고유번호 (consultant_seq) — INT — Foreign key → consultant.컨설턴트고유번호
coach
- 코치고유번호 (coach_seq) — INT — Primary key — NOT NULL
- 담당업무고유번호 (work_seq) — INT — Foreign key → work.담당업무고유번호 — NOT NULL
- 코치이름 (name) — String
- 담당반 (class_seq) — INT — NOT NULL
consultant
- 컨설턴트고유번호 (consultant_seq) — INT — Primary key — NOT NULL
- 담당업무고유번호 (work_seq) — INT — Foreign key → work.담당업무고유번호 — NOT NULL
- 컨설턴트이름 (name) — String
- 담당반 (class_seq) — INT — NOT NULL
curriculum (process)
- 교육과정고유번호 (curriculum_seq) — INT — Primary key — NOT NULL
- 교육과정이름 (curriculum_name) — String
location
- 지역고유번호 (location_seq) — INT — Primary key — NOT NULL
- 지역이름 (location_name) — String
student
- 학생고유번호 (student_seq) — INT — Primary key — NOT NULL
- 반고유번호 (class_seq) — INT — Foreign key → class.반고유번호
- 코치고유번호 (coach_seq) — INT — Foreign key → class.코치고유번호
- 컨설턴트고유번호 (consultant_seq) — INT — Foreign key → class.컨설턴트고유번호
- 교육과정고유번호 (curriculum_seq) — INT — Foreign key → curriculum.교육과정고유번호 — NOT NULL
- 지역고유번호 (location_seq) — INT — Foreign key → location.지역고유번호 — NOT NULL
- 학생이름 (name) — String
- 기수 (grade) — INT — NOT NULL
- 전공여부 (is_major) — INT — NOT NULL
- 퇴소여부 (exit) — String
work
- 담당업무고유번호 (work_seq) — INT — Primary key — NOT NULL
- 담당업무이름 (name) — String