RegiFlow

Tables (8)

Billing (Untitled6)

  • Primary key (biling_id) — NOT NULL — Primary key — NOT NULL
  • Foreign key (user_id) — NOT NULL — Foreign key → User.Primary key — NOT NULL
  • Primary key (class_type_id) — NOT NULL — Foreign key → Class Type.Primary key — NOT NULL
  • Field (transaction_date) — NOT NULL
  • Field (transaction_amount) — NOT NULL
  • Field (last_modified_date) — NOT NULL

Class Type (Untitled4)

  • Primary key (class_type_id) — NOT NULL — Primary key — NOT NULL
  • Field (class_type) — NOT NULL

Course (Untitled5)

  • Primary key (course_id) — NOT NULL — Primary key — NOT NULL
  • Foreign key (student_id) — NOT NULL — Foreign key → Student.Primary key — NOT NULL
  • Foreign key (teacher_id) — NOT NULL — Foreign key → Teacher.Primary key — NOT NULL
  • Foreign key (class_type_id) — NOT NULL — Foreign key → Class Type.Primary key — NOT NULL
  • Foreign key (course_name_id) — NOT NULL — Foreign key → Course Name.Primary key — NOT NULL
  • Field (last_modified_date) — NOT NULL
  • Field (start_time) — NOT NULL
  • Field (end_time) — NOT NULL

Course Name (Untitled7)

  • Primary key (course_name_id) — NOT NULL — Primary key — NOT NULL
  • Field (course_name) — NOT NULL

Event Log (Logging message)

  • Field (message) — NOT NULL
  • Field (severity_lvl) — NOT NULL
  • Field (timestamp) — NOT NULL

Student (Untitled3)

  • Primary key (student_id) — NOT NULL — Primary key — NOT NULL
  • Foreign key (user_id) — NOT NULL — Foreign key → User.Primary key — NOT NULL

Teacher (Untitled2)

  • Primary key (teacher_id) — NOT NULL — Primary key — NOT NULL
  • Foreign key (user_id) — NOT NULL — Foreign key → User.Primary key — NOT NULL

User (Untitled)

  • Primary key (user_id) — NOT NULL — Primary key — NOT NULL
  • Field (email) — NOT NULL
  • Field (password) — NOT NULL
  • Field (skype_id) — NOT NULL
  • Field (age_group) — NOT NULL
  • Field (phone_number) — NOT NULL
  • Field (english_name) — NOT NULL
  • Field (local_name) — NOT NULL
  • Field (last_modified_date) — NOT NULL
  • Field (session_id) — NOT NULL