simple1

Tables (8)

assignments

  • id — UUID
  • class_id — UUID — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • due_at — TIMESTAMPTZ
  • rubric_json — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

attendance

  • id — UUID
  • class_id — UUID — NOT NULL
  • student_id — UUID — NOT NULL
  • on_date — DATE — NOT NULL
  • status — VARCHAR(1) — NOT NULL

classes

  • id — UUID
  • teacher_id — UUID — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • semester — VARCHAR(40)
  • created_at — TIMESTAMPTZ — NOT NULL

enrollments

  • id — UUID
  • class_id — UUID — NOT NULL
  • student_id — UUID — NOT NULL
  • enrolled_at — TIMESTAMPTZ — NOT NULL

feedbacks

  • id — UUID
  • submission_id — UUID — NOT NULL
  • score_suggestion — NUMERIC(4,1)
  • comments — TEXT
  • evidence — JSONB
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

materials

  • id — UUID
  • class_id — UUID — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • storage_url — TEXT — NOT NULL
  • embedding_ready — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

submissions

  • id — UUID
  • assignment_id — UUID — NOT NULL
  • student_id — UUID — NOT NULL
  • answer_text — TEXT
  • submitted_at — TIMESTAMPTZ — NOT NULL
  • status — VARCHAR(20) — NOT NULL

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL