AcademyManager
Tables (8)
Academy
- Key (id) — UI — Primary key — NOT NULL
- Field (name) — NN
- Field (create_date) — NN
Class
- Key (id) — UI — Primary key — NOT NULL
- Key (teacher_id) — UI — Foreign key → Teacher.Key — NOT NULL
- Field (name) — NN
- Field (description) — NN
- Field (day) — NN
- Field (time) — NN
Parent
- Key (person_id) — UI — Foreign key → Person.Key — NOT NULL
Person
- Key (id) — UI — Primary key — NOT NULL
- Key (academy_id) — UI — Foreign key → Academy.Key — NOT NULL
- Field (name) — NN
- Field (call_num) — NN
- Field (create_date) — NN
Student
- Key (person_id) — UI — Foreign key → Person.Key — NOT NULL
- Key (parent_id) — UI — Foreign key → Parent.Key — NOT NULL
- Field (arrival_time) — NN
- Field (exit_time) — NN
- Field (grade) — NN
- Field (school) — NN
StudentClass
- Key (person_id) — UI — Foreign key → Student.Key — NOT NULL
- Key (class_id) — UI — Foreign key → Class.Key — NOT NULL
Teacher
- Key (person_id) — UI — Foreign key → Person.Key — NOT NULL
- Field (arrival_time) — NN
- Field (exit_time) — NN
Untitled
- Key — Primary key — NOT NULL