ERD실습

테이블 (5)

Class (Untitled)

  • Class_Id (class_id) — INT — 기본 키
  • Area (area) — VARCHAR
  • Class_Num (class_num) — INT
  • Consultant_Id (consultant_id2) — INT — 외래 키 → Consultant.Consultant_Id — NOT NULL

Coach (Untitled2)

  • Coach_Id (coach_id) — INT — 기본 키 — NOT NULL
  • Job (job) — VARCHAR(30)
  • Class_Id (class_id) — INT — 외래 키 → Class.Class_Id

Consultant

  • Consultant_Id (consultant_id) — INT — 기본 키 — NOT NULL
  • Job (job) — VARCHAR(30)

EduCourse

  • Course_Id (course_id) — INT — 기본 키 — NOT NULL
  • Course (course) — VARCHAR(20)
  • Student_Id (student_id) — INT — 외래 키 → Student.Student_Id — NOT NULL

Student (Untitled3)

  • Student_Id (student_id) — INT — 기본 키 — NOT NULL
  • Generation (generation) — INT
  • Major (major) — BOOLEAN
  • Out (out) — BOOLEAN
  • Class_Id (class_id) — INT — 외래 키 → Class.Class_Id