SSAFY교육생DB

테이블 (6)

Class (Untitled4)

  • class_id (Key) — 기본 키 — NOT NULL
  • consultant_id (Key2) — 외래 키 → Consultant.consultant_id — NOT NULL
  • region (Field) — CHAR
  • class_num (Field2) — INT
  • coach_id (Key3) — 외래 키 → Coach.coach_id — NOT NULL

Coach (Untitled2)

  • coach_id (Key) — 기본 키 — NOT NULL
  • existance (Field) — BOOL
  • role (Field2) — INT

Consultant (Untitled3)

  • consultant_id (Key) — 기본 키 — NOT NULL
  • name (Field) — CHAR
  • role (Field2) — INT

Curriculum (Untitled5)

  • curriculum_id (Key) — 기본 키 — NOT NULL
  • curriculum_name (Field) — INT

Curriculum_Class (Untitled6)

  • curriculum_id (Key) — 외래 키 → Curriculum.curriculum_id — NOT NULL
  • class_id (Key2) — 외래 키 → Class.class_id — NOT NULL

Student (Untitled)

  • student_id (Key) — 기본 키 — NOT NULL
  • class_id (Key2) — 외래 키 → Class.class_id — NOT NULL
  • major_status (Field) — BOOL
  • generation (Field2) — INT
  • withdraw (Field3) — BOOL