SSAFY

Tables (6)

Areas (areas)

  • Area Id (area_id) — INT — Primary key — NOT NULL
  • Area Name (area_name) — VARCHAR(255)

Classes (classes)

  • Class Id (class_id) — INT — Primary key — NOT NULL
  • Class number (class_number) — INT
  • Consultant Id (consultant_id) — INT — Foreign key → Consultants.Consultant Id — NOT NULL
  • Coach Id (coach_id) — INT — Foreign key → Coaches.Coach Id
  • Area Id (area_id) — INT — Foreign key → Areas.Area Id — NOT NULL
  • Course Id (course_id) — INT — Foreign key → Courses.Course Id — NOT NULL

Coaches (coaches)

  • Coach Id (coach_id) — INT — Primary key — NOT NULL
  • Coach Name (coach_name) — VARCHAR(255)
  • CoachTask (coach_task) — VARCHAR(255)
  • Area Id (area_id) — INT — Foreign key → Areas.Area Id — NOT NULL

Consultants (consultants)

  • Consultant Id (consultant_id) — INT — Primary key — NOT NULL
  • Consultant Task (consultant_task) — VARCHAR(255)

Courses (courses)

  • Course Id (course_id) — INT — Primary key — NOT NULL
  • Course Type (course_type) — VARCHAR(255)
  • Course Name (course_name) — VARCHAR(255)

Students (students)

  • Student Id (student_id) — INT — Primary key — NOT NULL
  • Student Year (student_year) — INT
  • Student Major (student_major) — BOOL
  • Student Active (student_active) — BOOL
  • Student Name (student_name) — VARCHAR(255)
  • Class Id (class_id) — INT — Foreign key → Classes.Class Id — NOT NULL