create table assessment_progress (
  id bigserial primary key,
  user_id bigint not null references users(id) on delete cascade,
  assessment_id bigint not null references assessments(id) on delete cascade,
  answers_json text not null,
  updated_at timestamptz not null default now(),
  unique(user_id, assessment_id)
);

create index idx_assessment_progress_user on assessment_progress(user_id);
create index idx_assessment_progress_assessment on assessment_progress(assessment_id);

