SSAFY

Tables (5)

class (Untitled4)

  • Class (class) — int(2) — Primary key — NOT NULL
  • Coach_id (coach_id) — int(7) — Foreign key → coaches.Coach_id — NOT NULL
  • Consultant_id (consultant_id) — int(7) — Foreign key → consultants.Consultant_id — NOT NULL
  • Area (area) — VARCHAR(255)
  • Field

coaches (Untitled2)

  • Coach_id (coach_id) — int(7) — Primary key — NOT NULL
  • Class_in_charge (class_in_charge) — int(2)
  • Coach_name (coaches_name) — VARCHAR(255)
  • Coaches_task (coach_task) — VARCHAR(255) — NOT NULL
  • Field

consultants (CopyOfUntitled2)

  • Consultant_id (consultant_id) — int(7) — Primary key — NOT NULL
  • Consultant_name (consultant_name) — VARCHAR(255)
  • Consultants_task (consultant_task) — VARCHAR(255)
  • Class_in_charge (class_in_charge) — int(2)
  • Field

section (Untitled3)

  • Section_version (section_version) — VARCHAR(255) — Primary key — NOT NULL
  • Field

students (Untitled)

  • Student_id (student_id) — int(7) — Primary key — NOT NULL
  • Consultant_id (consultant_id) — int(7) — Foreign key → consultants.Consultant_id — NOT NULL
  • Coach_id (coach_id) — int(7) — Foreign key → coaches.Coach_id — NOT NULL
  • Area (area) — VARCHAR(255)
  • Class (class) — int(2)
  • Student_name (student_name) — VARCHAR(255)
  • Student_major (student_major) — boolean
  • Students_period (students_period) — int(2)
  • Students_finished (student_finished) — boolean
  • Field