SSAFY

Tables (3)

Coaches (coaches)

  • Coach_Id (coach_id) — Auto — Primary key — NOT NULL
  • Name (name) — Varchar(30)
  • Region (region) — Char(2)
  • Class (class) — Varchar(2)
  • Job (job) — Varchar(20)

Consultants (consultants)

  • Consultant_Id (consultant_id) — Auto — Primary key — NOT NULL
  • Name (name) — Varchar(30)
  • Region (region) — Char(2)
  • Class (class) — Varchar(2)
  • Job (job) — Varchar(20)

Students (students)

  • Student_Id (student_id) — Auto — Primary key — NOT NULL
  • Name (name) — Varchar(30)
  • Year (year) — Varchar(2)
  • Major (major) — Char(1)
  • Region (region) — Char(2)
  • Class (class) — Varchar(2)
  • Out (out) — Char(1)
  • Process (process) — Char(2)
  • Consultant_Id (consultant_id) — Auto — Foreign key → Consultants.Consultant_Id — NOT NULL
  • Coach_Id (coach_id) — Auto — Foreign key → Coaches.Coach_Id — NOT NULL