ssafy
Tables (4)
Class
- class_id (Key) — VARCHAR — Primary key — NOT NULL
Coach (coach)
- Coach_id — BIGINT — Primary key — NOT NULL
- coach_task (coack_task) — VARCHAR
- class_id (Field) — VARCHAR
- class_id — VARCHAR
- class_id (Key) — VARCHAR — Foreign key → Class.class_id — NOT NULL
Consultant (consultant)
- Consultant_id — BIGINT — Primary key — NOT NULL
- consultant_task — VARCHAR
- class_id (Field) — VARCHAR
- class_id — VARCHAR
- class_id (Key) — VARCHAR — Foreign key → Class.class_id — NOT NULL
Student (student)
- student_id — BIGINT — Primary key — NOT NULL
- major — VARCHAR
- retireTF (Field) — VARCHAR
- curriculum — VARCHAR
- unit — VARCHAR
- class_id (Field2) — VARCHAR
- class_id — VARCHAR
- class_id (Key) — VARCHAR — Foreign key → Class.class_id — NOT NULL