ssafy
Tables (5)
Class (class)
- class_no — INT — Primary key — NOT NULL
- area — VARCHAR
- coach_id — INT — Foreign key → Coach.coach_id — NOT NULL
- consultant_id — INT — Foreign key → Consultant.consultant_id — NOT NULL
Coach (coach)
- coach_id — INT — Primary key — NOT NULL
- job — VARCHAR
- age — INT
- name — VARCHAR
Consultant (consultant)
- consultant_id — INT — Primary key — NOT NULL
- name — VARCHAR
- job — VARCHAR
- age — INT
Course (course)
- course_id — INT — Primary key — NOT NULL
- course_name — VARCHAR — NOT NULL
- class_no — INT — Foreign key → Class.class_no — NOT NULL
Student (student)
- student_id — INT — Primary key — NOT NULL
- grade — VARCHAR
- major — VARCHAR
- graduation (delete) — CHAR(1)
- name — VARCHAR
- age — INT
- class_no — INT — Foreign key → Class.class_no — NOT NULL