7기_서울2반_김헤수

테이블 (5)

Class (Untitled3)

  • Num (num) — BIGINT(11) — 기본 키 — NOT NULL
  • Local (local) — VARCHAR(255)
  • ClassNum (class_num) — BIGINT(11)
  • CoachID (coach_id2) — BIGINT(11) — 외래 키 → Coach.CoachID — NOT NULL

Coach (Entity2)

  • CoachID (coach_id) — BIGINT(11) — 기본 키 — NOT NULL
  • FirstName (first_name) — VARCHAR(255)
  • LastName (last_name) — VARCHAR(255)
  • Work (work) — VARCHAR(255)

Consultant (Untitled2)

  • ConsultantID (consultant_id) — BIGINT(11) — 기본 키 — NOT NULL
  • Num (num) — BIGINT(11) — 외래 키 → Class.Num — NOT NULL
  • FirstName (first_name) — VARCHAR(255)
  • LastName (last_name) — VARCHAR(255)
  • Work (work) — VARCHAR(255)

Student (Entity1)

  • StudentID (student_id) — BIGINT(11) — 기본 키 — NOT NULL
  • Num (num) — BIGINT(11) — 외래 키 → Class.Num — NOT NULL
  • Generation (generation) — BIGINT(11)
  • Major (major) — CHAR(1)
  • Exit (exit) — CHAR(1)

교육과정 (Untitled4)

  • EduNum (edu_num) — BIGINT(11) — 기본 키 — NOT NULL
  • StudentID (student_id) — BIGINT(11) — 외래 키 → Student.StudentID — NOT NULL
  • Num (num2) — BIGINT(11) — 외래 키 → Student.Num — NOT NULL
  • EduName (edu_name) — VARCHAR(255)
  • Edutype (edu_type) — VARCHAR(255)