ssafy

Tables (6)

Area (area)

  • Area_Id (area_id) — int — Primary key — NOT NULL
  • Area_Name (area_name) — VARCHAR(255)

ClassRoom (classroom)

  • ClassRoom_Id (ClassRoom_id) — int — Primary key — NOT NULL
  • Consultant_Id (consultant_id2) — int — Foreign key → Consultant.Consultant_Id — NOT NULL
  • Area_Id (area_id) — int — Foreign key → Area.Area_Id — NOT NULL
  • Coach_Id (coach_id2) — int — Foreign key → Coach.Coach_Id — NOT NULL

Coach (coach)

  • Coach_Id (coach_id) — int — Primary key — NOT NULL
  • Coach_Work (coach_work) — VARCHAR(255)
  • Coach_Class (coach_class) — VARCHAR(255)

Consultant (consultant)

  • Consultant_Id (consultant_id) — int — Primary key — NOT NULL
  • Consultant_Work (consultant_work) — VARCHAR(255)
  • Consultant_Class (consultant_class) — VARCHAR(255)

Curriculum (curriculum)

  • Curriculum_Id (curriculum_id) — int — Primary key — NOT NULL
  • Curriculum_Name (curriculum_name) — VARCHAR(255)

Student (student)

  • Student_Id (student_id) — int — Primary key — NOT NULL
  • Curriculum_Id (curriculum_id2) — int — Foreign key → Curriculum.Curriculum_Id — NOT NULL
  • ClassRoom_Id (ClassRoom_id) — int — Foreign key → ClassRoom.ClassRoom_Id — NOT NULL
  • Consultant_Id (consultant_id2) — int — Foreign key → ClassRoom.Consultant_Id — NOT NULL
  • Area_Id (area_id) — int — Foreign key → ClassRoom.Area_Id — NOT NULL
  • Major (major) — int
  • Remain (remain) — int
  • Year (year) — int