daily_1_엔티티추출
테이블 (8)
class
- class_id — int — 기본 키 — NOT NULL — PK Auto Increment
- location — enum('서울', '대전', '구미', '부울경', '광주')
- num — int
coach
- user_id — int — 외래 키 → user.user_id — NOT NULL
- dept_id — int — 외래 키 → dept.dept_id
consultant
- user_id — int — 외래 키 → user.user_id — NOT NULL
- class_id — int — 외래 키 → class.class_id — NOT NULL — PK Auto Increment
- dept_id — int — 외래 키 → dept.dept_id
curriculum
- curriculum_id — int — 기본 키 — NOT NULL
- type — enum('공통','특화','자율')
dept
- dept_id — int — 기본 키 — NOT NULL
- task — varchar
manage
- class_id — int — 외래 키 → class.class_id — NOT NULL — PK Auto Increment
- user_id — int — 외래 키 → coach.user_id — NOT NULL
trainee
- user_id — int — 외래 키 → user.user_id — NOT NULL
- class_id — int — 외래 키 → class.class_id — NOT NULL — PK Auto Increment
- period — int
- major — enum('MAJOR', 'NON-MAJOR')
- activated — tinyint
user
- user_id — int — 기본 키 — NOT NULL
- name — varchar
- phone — varchar