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()