RegiFlow

Tables (6)

Billing (Untitled6)

  • Primary key (bilingId) — NOT NULL — Primary key — NOT NULL
  • Foreign key (userId) — NOT NULL — Foreign key → User.Primary key — NOT NULL
  • Field (transactionDate) — NOT NULL
  • Field (transactionAmount) — NOT NULL

Course (Untitled5)

  • Primary key (courseId) — NOT NULL — Primary key — NOT NULL
  • Foreign key (scheduleId) — NOT NULL — Foreign key → Schedule.Primary key — NOT NULL
  • Primary key (studentId) — NOT NULL — Foreign key → Student.Primary key — NOT NULL
  • Foreign key (teacherId) — NOT NULL — Foreign key → Teacher.Primary key — NOT NULL
  • Field (name) — NOT NULL — NOT NULL
  • Field (duration)
  • Field (capacity) — NOT NULL
  • Field (modifiedDate) — NOT NULL
  • Field (date) — NOT NULL

Schedule (Untitled4)

  • Primary key (scheduleId) — NOT NULL — Primary key — NOT NULL
  • Foreign key (courseId) — NOT NULL — Foreign key → Course.Primary key — NOT NULL
  • Field (dateTime) — NOT NULL
  • Field (type) — NOT NULL

Student (Untitled3)

  • Primary key (studentId) — NOT NULL — Primary key — NOT NULL
  • Foreign key (userId) — NOT NULL — Foreign key → User.Primary key — NOT NULL

Teacher (Untitled2)

  • Primary key (teacherId) — NOT NULL — Primary key — NOT NULL
  • Foreign key (userId) — NOT NULL — Foreign key → User.Primary key — NOT NULL

User (Untitled)

  • Primary key (userId) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (email) — NOT NULL
  • Field (role) — NOT NULL
  • Field (createdDate) — NOT NULL
  • Field (modifiedDate) — NOT NULL
  • Field (address) — NULL
  • Field (status) — NOT NULL