hw_erd
Tables (6)
Batches (Untitled3)
- batch_id — INT — Primary key — NOT NULL
- batch_name (Field)
ClassCoaches (Untitled6)
- class_coach_id — INT — Primary key — NOT NULL
- class_id — INT — Foreign key → Classes.class_id — NOT NULL
- batch_id — INT — Foreign key → Classes.batch_id — NOT NULL
Classes (Untitled2)
- class_id — INT — Primary key — NOT NULL
- batch_id — INT — Foreign key → Batches.batch_id — NOT NULL
- region — ENUM('서울', '대전', '구미', '광주', '부울경')
Consultants (Untitled5)
- consultant_id — INT — Primary key — NOT NULL
- class_id — INT — Foreign key → Classes.class_id — NOT NULL
- batch_id — INT — Foreign key → Classes.batch_id — NOT NULL
- name — VARCHAR(100)
- task_description — TEXT
Coures (Untitled4)
- course_id — INT — Primary key — NOT NULL
- course_type — ENUM('공통', '특화', '자율')
Students (Untitled)
- student_id — INT — Primary key — NOT NULL
- class_id — INT — Foreign key → Classes.class_id — NOT NULL
- batch_id — INT — Foreign key → Classes.batch_id — NOT NULL
- name (Field) — VARCHAR(100)