temp1

Tables (10)

ai_feedback

  • id — UUID
  • submission_id — UUID — NOT NULL
  • version — INTEGER — NOT NULL
  • feedback_text — TEXT — NOT NULL
  • model_id — TEXT
  • prompt_meta — JSONB
  • evidence — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

class

  • id — UUID
  • teacher_id — UUID — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

exam

  • id — UUID
  • teacher_id — UUID — NOT NULL
  • class_id — UUID — NOT NULL
  • title — TEXT — NOT NULL
  • description — TEXT
  • starts_at — TIMESTAMPTZ — NOT NULL
  • ends_at — TIMESTAMPTZ — NOT NULL
  • duration_min — INTEGER — NOT NULL
  • is_published — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

exam_choice

  • id — UUID
  • question_id — UUID — NOT NULL
  • label — TEXT — NOT NULL
  • text — TEXT — NOT NULL
  • is_correct — BOOLEAN — NOT NULL

exam_notification

  • id — UUID
  • exam_id — UUID — NOT NULL
  • student_id — UUID
  • channel — edu.notify_channel — NOT NULL
  • payload — JSONB
  • sent_at — TIMESTAMPTZ — NOT NULL
  • success — BOOLEAN — NOT NULL

exam_question

  • id — UUID
  • exam_id — UUID — NOT NULL
  • qno — INTEGER — NOT NULL
  • qtype — edu.question_type — NOT NULL
  • text — TEXT — NOT NULL
  • points — NUMERIC(6,2) — NOT NULL
  • short_answer — TEXT
  • short_answer_re — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

student

  • id — UUID
  • class_id — UUID — NOT NULL
  • name — TEXT — NOT NULL
  • email — CITEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

submission

  • id — UUID
  • exam_id — UUID — NOT NULL
  • student_id — UUID — NOT NULL
  • attempt_no — INTEGER — NOT NULL
  • status — edu.submission_status — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • submitted_at — TIMESTAMPTZ
  • graded_at — TIMESTAMPTZ
  • total_score — NUMERIC(8,2)

submission_answer

  • id — UUID
  • submission_id — UUID — NOT NULL
  • question_id — UUID — NOT NULL
  • selected_choice — UUID
  • answer_text — TEXT
  • is_correct — BOOLEAN
  • score — NUMERIC(6,2)
  • answered_at — TIMESTAMPTZ — NOT NULL

teacher

  • id — UUID
  • name — TEXT — NOT NULL
  • email — CITEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL