ERD실습

테이블 (7)

교육과정

  • Course Id (course_id) — int() — 기본 키 — NOT NULL
  • Course Name (course_name) — VARCHAR(10)

교육생

  • Student Id (student_id) — int() — 기본 키 — NOT NULL
  • Course Id (course_id) — int() — 외래 키 → 교육과정.Course Id — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Gender (gender) — CHAR(1)
  • Email (email) — VARCHAR(20)
  • Birthday (birthday) — CHAR(8)
  • Major (major) — BOOLEAN()
  • Exit (exit) — BOOLEAN()

기수

  • Semester Id (semester_id) — int() — 기본 키 — NOT NULL
  • Student Id (student_id) — int() — 외래 키 → 교육생.Student Id — NOT NULL
  • Course Id (course_id) — int() — 외래 키 → 교육생.Course Id — NOT NULL

반

  • Class Id (class_id) — int() — 기본 키 — NOT NULL

지역

  • Local Id (local_id) — int() — 기본 키 — NOT NULL
  • Class Id (class_id) — int() — 외래 키 → 반.Class Id — NOT NULL
  • Student Id (student_id) — int() — 외래 키 → 교육생.Student Id — NOT NULL
  • Consultant Id (consultant_id) — int() — 외래 키 → 컨설턴트.Consultant Id — NOT NULL
  • Course Id (course_id) — int() — 외래 키 → 교육생.Course Id — NOT NULL
  • Coach Id (coach_id) — int() — 외래 키 → 코치.Coach Id — NOT NULL
  • Local Name (local_name) — VARCHAR(200)

컨설턴트

  • Consultant Id (consultant_id) — int() — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Gender (gender) — CHAR(1)
  • Email (email) — VARCHAR(20)
  • Birthday (birthday) — CHAR(8)
  • Consultant Work (consultant_work) — VARCHAR(200)

코치

  • Coach Id (coach_id) — int() — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Gender (gender) — CHAR(1)
  • Email (email) — VARCHAR(20)
  • Birthday (birthday) — CHAR(8)
  • Coach Work (coach_work) — VARCHAR(200)