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