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