취미 클래스 ERD

테이블 (7)

Category (Untitled7)

  • category_id (Key) — 기본 키 — NOT NULL
  • name (Field)

Class (Untitled3)

  • instructor_id (Key2) — 외래 키 → Teaches.instructor_id — NOT NULL
  • class_id (Key22) — 외래 키 → Teaches.class_id — NOT NULL
  • category_id (Key3) — 외래 키 → Teaches.category_id — NOT NULL
  • name (Field)
  • class_region (Field2)
  • max_personnel (Field3)
  • min_personnel (Field5)
  • curr_personnel (Field4)
  • schedule (Field7)
  • available (Field8)

Instructor (Untitled5)

  • instructor_id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • age (Field2)
  • gender (Field3)

Takes (Untitled2)

  • user_id (Key3) — Int — 외래 키 → User.user_id — NOT NULL
  • class_id (Key22) — 외래 키 → Class.class_id — NOT NULL
  • category_id (Key32) — 외래 키 → Class.category_id — NOT NULL

Teaches (Untitled6)

  • class_id (Key2) — 기본 키 — NOT NULL
  • instructor_id (Key) — 외래 키 → Instructor.instructor_id — NOT NULL
  • category_id (Key3) — 외래 키 → Category.category_id — NOT NULL
  • class_region (Field)

User (Untitled)

  • user_id (Key) — Int — 기본 키 — NOT NULL
  • username (Field2)
  • password (Field3)

UserInfo (Untitled4)

  • user_id (Key2) — Int — 외래 키 → User.user_id — NOT NULL
  • name (Field)
  • email (Field2)
  • phone (Field3)
  • user_region (Field4)
  • age (Field5)
  • gender (Field6)