SSAFY

Tables (5)

Classes (classes)

  • Region (region) — VARCHAR(30) — Primary key — NOT NULL
  • Class Num (class_num) — INT — Primary key — NOT NULL

Coaches (coaches)

  • Coach Id (coach_id) — INT — Primary key — NOT NULL
  • Role (role) — VARCHAR(30)
  • Region (region) — VARCHAR(30) — Foreign key → Classes.Region — NOT NULL
  • Class Num (class_num) — INT — Foreign key → Classes.Class Num — NOT NULL

Consultants (consultants)

  • Consultant Id (consultant_id) — INT — Primary key — NOT NULL
  • Role (role) — VARCHAR(30)
  • Region (region) — VARCHAR(30) — Foreign key → Classes.Region — NOT NULL
  • Class Num (class_num) — INT — Foreign key → Classes.Class Num — NOT NULL

Curriculum (curriculum)

  • Process (process) — VARCHAR(30) — Primary key — NOT NULL

Students (students)

  • Student Id (student_id) — INT — Primary key — NOT NULL
  • Generation (generation) — INT
  • Is Major (is_major) — VARCHAR(30)
  • Is Discharge (is_discharge) — VARCHAR(30)