ERD
Tables (5)
class (Untitled4)
- area (지역) — varchar(100) — Primary key — NOT NULL
- coach_id (코치아이디) — varchar(100) — Foreign key → coach.coach_id — NOT NULL
- cnsultant_id (컨설턴트아이디) — varchar(100) — Foreign key → consultant.cnsultant_id — NOT NULL
- class (반) — int(10000)
coach (Untitled3)
- coach_id (코치아이디) — varchar(100) — Primary key — NOT NULL
- task (업무) — varchar(100)
consultant (Untitled2)
- cnsultant_id (컨설턴트아이디) — varchar(100) — Primary key — NOT NULL
- task (업무) — varchar(100)
process (Untitled5)
- subject (과정) — varchar(100) — Primary key — NOT NULL
student (Untitled)
- student_id (학생아이디) — int(10000) — Primary key — NOT NULL
- area (지역) — varchar(100) — Foreign key → class.area — NOT NULL
- coach_id (코치아이디) — varchar(100) — Foreign key → class.coach_id — NOT NULL
- cnsultant_id (컨설턴트아이디) — varchar(100) — Foreign key → class.cnsultant_id — NOT NULL
- subject (과정) — varchar(100) — Foreign key → process.subject — NOT NULL
- major (전공) — boolean
- address (주소) — varchar(100)
- stay (퇴소여부) — boolean
- cardinal (기수) — int(10000)