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