safy

Tables (7)

Class

  • Class Id (class_id) — int() — Primary key
  • Location Id (location_id) — int() — Foreign key → location.Location Id
  • Consultant Id (consultant_id) — int() — Foreign key → Consultant.Consultant Id
  • Class Num (class_num) — int()

Coach

  • Coach Id (coach_id) — int() — Primary key
  • Class Id (class_id) — int() — Foreign key → Class.Class Id
  • Name (name) — varchar(10)

Consultant

  • Consultant Id (consultant_id) — int() — Primary key
  • Name (name) — varchar(10)

Course

  • Course Id (course_id) — int() — Primary key
  • Course Name (course_name) — varchar(10)

Generation

  • Generation Id (generation_id) — int() — Primary key
  • Generation Num (generation_num) — int()

location

  • Location Id (location_id) — int() — Primary key
  • Location Name (location_name) — varchar(100)

student

  • Student Id (student_id) — int() — Primary key
  • Location Id (location_id) — int() — Foreign key → location.Location Id
  • Generation Id (generation_id) — int() — Foreign key → Generation.Generation Id
  • Course Id (course_id) — int() — Foreign key → Course.Course Id
  • Name (name) — varchar(10)
  • Major (major) — Boolean()
  • Out (out) — Boolean()