Hw02
Tables (3)
coach
- no (coach_no) — VARCHAR(30) — Primary key — NOT NULL
- field (coach_field) — VARCHAR(20) — NOT NULL
- class (coach_class) — INT(11) — NOT NULL
consultant
- no (consultant_no) — VARCHAR(30) — Primary key — NOT NULL
- field (consultant_field) — VARCHAR(20)
- class (consultant_class) — INT(11)
student
- no (student_no) — VARCHAR(30) — Primary key — NOT NULL
- number (student_number) — INT(11)
- major (student_major) — BOOLEAN
- isExit (student_isExit) — BOOLEAN
- field (student_field) — VARCHAR(20)
- class (student_class) — INT(11)
- edu (student_edu) — VARCHAR(20)
- no (consultant_no) — VARCHAR(30) — Foreign key → consultant.no — NOT NULL