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