DH edu2

Tables (16)

assessment

  • assess_id — uuid
  • learner_id_raw — uuid — NOT NULL
  • exam_type — varchar(30) — NOT NULL
  • scope — varchar(100)
  • taken_at — timestamp — NOT NULL

consent_raw

  • consent_id — uuid
  • learner_id_raw — uuid — NOT NULL
  • consent_personalization — boolean — NOT NULL
  • consent_model_train — boolean — NOT NULL
  • version — varchar(20) — NOT NULL
  • valid_from — timestamp — NOT NULL
  • valid_to — timestamp

course

  • course_id — uuid
  • title — varchar(200) — NOT NULL
  • subject — varchar(50) — NOT NULL
  • difficulty — int
  • status — varchar(20)
  • updated_at — timestamp — NOT NULL

course_media

  • media_id — uuid
  • course_id — uuid — NOT NULL
  • object_id — uuid — NOT NULL
  • media_type — varchar(20) — NOT NULL
  • duration_sec — int
  • resolution — varchar(20)
  • bitrate_kbps — int
  • drm_applied — boolean — NOT NULL
  • caption_object_id — uuid
  • thumbnail_object_id — uuid
  • created_at — timestamp — NOT NULL

enrollment

  • enroll_id — uuid
  • learner_id_raw — uuid — NOT NULL
  • course_id — uuid — NOT NULL
  • started_at — timestamp — NOT NULL
  • completed_at — timestamp
  • status — varchar(20) — NOT NULL
  • progress_ratio — numeric(5,2)

exam_score

  • score_id — uuid
  • learner_id_raw — uuid — NOT NULL
  • exam_id — varchar(64) — NOT NULL
  • total_score — numeric(6,2)
  • section_score — jsonb

item

  • item_id — uuid
  • stem — text — NOT NULL
  • item_type — varchar(20) — NOT NULL
  • difficulty — int
  • tags — jsonb

item_response

  • response_id — uuid
  • assess_id — uuid — NOT NULL
  • item_id — uuid — NOT NULL
  • is_correct — boolean — NOT NULL
  • time_sec — int
  • attempt_no — int
  • answered_at — timestamp — NOT NULL

item_stats

  • item_id — uuid
  • avg_correct_rate — numeric(5,4)
  • avg_time_sec — numeric(8,3)
  • exposure_cnt — int
  • irt_a — numeric(8,4)
  • irt_b — numeric(8,4)
  • irt_c — numeric(8,4)
  • updated_at — timestamp

learner

  • learner_id_raw — uuid
  • name — varchar(100) — NOT NULL
  • phone — varchar(30)
  • email — varchar(200)
  • join_dt — timestamp — NOT NULL
  • grade — varchar(20)
  • track — varchar(50)

pseudo_map

  • learner_id_raw — uuid — Primary key — NOT NULL
  • learner_pid — uuid — NOT NULL
  • salt_id — uuid — NOT NULL
  • created_at — timestamp — NOT NULL

recommendation

  • rec_id — uuid
  • learner_id_raw — uuid — NOT NULL
  • saved_at — timestamp — NOT NULL
  • rank — int
  • score — numeric(8,4)
  • served_model — varchar(50)
  • ab_bucket — varchar(20)
  • clicked — timestamp
  • converted — timestamp
  • completed — timestamp

s3_object

  • object_id — uuid
  • bucket — varchar(100) — NOT NULL
  • object_key — varchar(1024) — NOT NULL
  • version_id — varchar(200)
  • e_tag — varchar(200)
  • size_bytes — bigint
  • content_type — varchar(100)
  • storage_class — varchar(40)
  • kms_key_id — varchar(200)
  • last_modified — timestamp
  • created_at — timestamp — NOT NULL

salt_ref

  • salt_id — uuid
  • created_at — timestamp — NOT NULL

textbook

  • textbook_id — uuid
  • course_id — uuid — NOT NULL
  • title — varchar(200) — NOT NULL
  • isbn — varchar(32) — NOT NULL
  • subject — varchar(50) — NOT NULL
  • grade_band — varchar(20)
  • price — numeric(12,2)
  • stock_status — varchar(20) — NOT NULL

textbook_asset

  • asset_id — uuid
  • textbook_id — uuid — NOT NULL
  • object_id — uuid — NOT NULL
  • asset_type — varchar(20) — NOT NULL
  • created_at — timestamp — NOT NULL