취미 클래스 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)