Tuter
Tables (17)
assignments
- assignment_id — INT
- lesson_id — INT
- title — VARCHAR(255)
- content — TEXT
- deadline — TIMESTAMP
- file_urls — TEXT
- created_at — TIMESTAMP
attendances
- attendance_id — INT
- lesson_id — INT
- user_id — INT
- attended — BOOLEAN
- checked_at — TIMESTAMP
chat_channels
- channel_id — INT
- name — VARCHAR(255)
- subject_id — INT
- created_at — TIMESTAMP
chat_messages
- message_id — INT
- channel_id — INT
- sender_id — INT
- message — TEXT
- sent_at — TIMESTAMP
- is_read — BOOLEAN
chat_participants
- participant_id — INT
- channel_id — INT
- user_id — INT
files
- file_id — INT
- uploader_id — INT
- lesson_id — INT
- file_url — VARCHAR(1024)
- file_name — VARCHAR(255)
- uploaded_at — TIMESTAMP
lessons
- lesson_id — INT
- subject_id — INT
- teacher_id — INT
- student_id — INT
- title — VARCHAR(255)
- start_time — TIMESTAMP
- end_time — TIMESTAMP
- location — VARCHAR(255)
- status — VARCHAR(20)
notification_settings
- setting_id — INT
- user_id — INT
- is_enabled — BOOLEAN
- type — VARCHAR(20)
notifications
- notification_id — INT
- user_id — INT
- message — VARCHAR(1024)
- type — VARCHAR(20)
- is_read — BOOLEAN
- created_at — TIMESTAMP
parent_student_links
- link_id — INT
- parent_id — INT
- student_id — INT
payments
- payment_id — INT
- payer_id — INT
- receiver_id — INT
- amount — DECIMAL(10,2)
- paid_at — TIMESTAMP
- status — VARCHAR(20)
reviews
- review_id — INT
- lesson_id — INT
- reviewer_id — INT
- target_id — INT
- rating — INT
- comment — TEXT — EX
- created_at — TIMESTAMP
scores
- score_id — INT
- student_id — INT
- subject_id — INT
- score — INT
- recorded_at — TIMESTAMP
subjects
- subject_id — INT
- name — VARCHAR(100)
submissions
- submission_id — INT
- assignment_id — INT
- student_id — INT
- title — VARCHAR(255)
- content — TEXT
- submitted_at — TIMESTAMP
- file_urls — TEXT
todos
- todo_id — INT
- student_id — INT
- teacher_id — INT
- title — VARCHAR(255)
- subject_id — INT
- due_date — DATE
- priority — VARCHAR(10)
- completed — BOOLEAN
- created_at — TIMESTAMP
users
- user_id — INT
- name — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)
- phone — VARCHAR(20)
- role — VARCHAR(20)
- created_at — TIMESTAMP