AI-LIT

Tables (16)

activities

  • activity_id — UUID
  • class_id — UUID
  • activity_name — VARCHAR(100)
  • description — TEXT
  • created_at — TIMESTAMP

attendance

  • attendance_id — UUID
  • student_id — UUID
  • class_id — UUID
  • activity_id — UUID
  • status — VARCHAR(20)
  • attendance_date — DATE

audio_recordings

  • audio_id — UUID
  • class_id — UUID
  • activity_id — UUID
  • file_url — TEXT — NOT NULL
  • recorded_at — TIMESTAMP

boards

  • board_id — UUID
  • class_id — UUID
  • title — VARCHAR(255)
  • created_at — TIMESTAMP

classes

  • class_id — UUID
  • class_name — VARCHAR(100) — NOT NULL
  • grade — VARCHAR(50)
  • created_at — TIMESTAMP

comments

  • comment_id — UUID
  • post_id — UUID
  • author_id — UUID
  • author_type — VARCHAR(20)
  • comment — TEXT — EX
  • created_at — TIMESTAMP

media_files

  • file_id — UUID
  • owner_id — UUID
  • owner_type — VARCHAR(20)
  • file_url — TEXT — NOT NULL
  • file_type — VARCHAR(20)
  • uploaded_at — TIMESTAMP

parents

  • parent_id — UUID
  • full_name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP

posts

  • post_id — UUID
  • board_id — UUID
  • author_id — UUID
  • author_type — VARCHAR(20)
  • content — TEXT
  • created_at — TIMESTAMP

qna

  • qna_id — UUID
  • question — TEXT — NOT NULL
  • student_id — UUID
  • created_at — TIMESTAMP

qna_answers

  • answer_id — UUID
  • qna_id — UUID
  • teacher_id — UUID
  • answer — TEXT — NOT NULL
  • created_at — TIMESTAMP

scores

  • score_id — UUID
  • student_id — UUID
  • class_id — UUID
  • subject — VARCHAR(100)
  • score — NUMERIC(5,2)
  • exam_date — DATE

students

  • student_id — UUID
  • full_name — VARCHAR(100) — NOT NULL
  • class_id — UUID
  • parent_id — UUID
  • created_at — TIMESTAMP

system_logs

  • log_id — UUID
  • user_id — UUID
  • action — TEXT
  • created_at — TIMESTAMP

teacher_classes

  • id — UUID
  • teacher_id — UUID
  • class_id — UUID

teachers

  • teacher_id — UUID
  • full_name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP