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