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