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