SSAFY
Tables (4)
Class
- id — int — Primary key — NOT NULL
- location — varchar(255)
- classNumber — int
- consultantId — int
- coachId — int
Coach
- id — int — Primary key — NOT NULL
- classId — int — Foreign key → Class.id — NOT NULL
- name — varchar(255)
- work — varchar(255)
Consultant
- id — int — Primary key — NOT NULL
- classId — int — Foreign key → Class.id — NOT NULL
- name — varchar(255)
- work — varchar(255)
Student
- id — int — Primary key — NOT NULL
- classId — int — Foreign key → Class.id — NOT NULL
- name — varchar(255)
- type (type) — varchar(255)
- status — Boolean