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