NERD
Tables (7)
learning_items
- id — BIGSERIAL — Primary key — NOT NULL
- session_version_id — BIGINT — Foreign key → learning_session_versions.id — NOT NULL
- item_kind — VARCHAR(20) — NOT NULL
- placement — VARCHAR(20) — NOT NULL
- position — SMALLINT — NOT NULL
- response_type — VARCHAR(64)
- content_schema_version — INTEGER — NOT NULL
- content_json — JSONB — NOT NULL
- response_config_json — JSONB
- grading_json — JSONB
- hint_json — JSONB
- explanation_json — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
learning_run_item_progresses
- id — UUID — Primary key — NOT NULL
- run_id — UUID — Foreign key → learning_runs.id — NOT NULL
- session_version_id — BIGINT — Foreign key → learning_items.session_version_id — NOT NULL
- item_id — BIGINT — Foreign key → learning_items.id — NOT NULL
- round — VARCHAR(20) — NOT NULL
- round_position — SMALLINT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- hint_revealed_at — TIMESTAMPTZ
- explanation_revealed_at — TIMESTAMPTZ
- answer_revealed_at — TIMESTAMPTZ
- started_at — TIMESTAMPTZ
- ready_to_advance_at — TIMESTAMPTZ
- advanced_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
learning_runs
- id — UUID — Foreign key → learning_run_item_progresses.run_id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- learning_session_id — BIGINT — Foreign key → learning_session_versions.learning_session_id — NOT NULL
- session_version_id — BIGINT — Foreign key → learning_session_versions.id — NOT NULL
- start_request_id — UUID — NOT NULL
- status — VARCHAR(20) — NOT NULL
- current_phase — VARCHAR(30) — NOT NULL
- current_item_progress_id — UUID — Foreign key → learning_run_item_progresses.id
- retry_decision — VARCHAR(10)
- started_at — TIMESTAMPTZ — NOT NULL
- completed_at — TIMESTAMPTZ
- abandoned_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ — NOT NULL
- row_version — BIGINT — NOT NULL
learning_session_versions
- id — BIGSERIAL — Primary key — NOT NULL
- learning_session_id — BIGINT — Foreign key → learning_sessions.id — NOT NULL
- version_no — INTEGER — NOT NULL
- status — VARCHAR(20) — NOT NULL
- content_schema_version — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- published_at — TIMESTAMPTZ
learning_sessions
- id — BIGSERIAL — Foreign key → learning_session_versions.learning_session_id — NOT NULL
- current_version_id — BIGINT — Foreign key → learning_session_versions.id
learning_submissions
- id — UUID — Primary key — NOT NULL
- progress_id — UUID — Foreign key → learning_run_item_progresses.id — NOT NULL
- attempt_no — SMALLINT — NOT NULL
- answer_json — JSONB — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- scorer_version — VARCHAR(100) — NOT NULL
- elapsed_ms — INTEGER
- submitted_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL