SSAFY교육생DB
테이블 (6)
Class (Untitled4)
- class_id (Key) — 기본 키 — NOT NULL
- consultant_id (Key2) — 외래 키 → Consultant.consultant_id — NOT NULL
- region (Field) — CHAR
- class_num (Field2) — INT
- coach_id (Key3) — 외래 키 → Coach.coach_id — NOT NULL
Coach (Untitled2)
- coach_id (Key) — 기본 키 — NOT NULL
- existance (Field) — BOOL
- role (Field2) — INT
Consultant (Untitled3)
- consultant_id (Key) — 기본 키 — NOT NULL
- name (Field) — CHAR
- role (Field2) — INT
Curriculum (Untitled5)
- curriculum_id (Key) — 기본 키 — NOT NULL
- curriculum_name (Field) — INT
Curriculum_Class (Untitled6)
- curriculum_id (Key) — 외래 키 → Curriculum.curriculum_id — NOT NULL
- class_id (Key2) — 외래 키 → Class.class_id — NOT NULL
Student (Untitled)
- student_id (Key) — 기본 키 — NOT NULL
- class_id (Key2) — 외래 키 → Class.class_id — NOT NULL
- major_status (Field) — BOOL
- generation (Field2) — INT
- withdraw (Field3) — BOOL