10기_서울12반_김성수_ERD.PNG

테이블 (5)

classes (Untitled3)

  • class_id (pk) — INT — 기본 키 — NOT NULL
  • choach_id (pk2) — INT — 외래 키 → coaches.choach_id — NOT NULL
  • consultant_id (pk3) — INT — 외래 키 → consultants.consultant_id — NOT NULL
  • region (field) — varchar
  • class_num (Field2) — INT

coaches (Untitled2)

  • choach_id (pk) — INT — 기본 키 — NOT NULL
  • class_id (fk) — INT

consultants (Untitled)

  • consultant_id (pk) — INT — 기본 키 — NOT NULL
  • class_id (fk) — INT

student_courses (Untitled4)

  • course_id (pk) — INT — 기본 키 — NOT NULL
  • student_id (pk2) — INT — 외래 키 → students.studentId — NOT NULL
  • course_type (Field) — ENUM('공통','특화','자율')

students (교육생테이블)

  • studentId (pk) — INT — 기본 키 — NOT NULL
  • magor_status (Field) — ENUM('전공','비전공')
  • withdrawal_status (Field2) — ENUM('재학','퇴소')
  • year_status(기수) (기수) — INT
  • course_id (fk) — varchar