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