Data dictionary and event contracts
All timestamps are UTC in YYYY-MM-DD HH:MM:SS. Observation cutoff: 2026-10-23 00:00:00 UTC. Synthetic period starts 2026-05-01; no real customer counts, costs or demographic data. CSV blanks represent SQL NULL. Schema SQL contains keys and foreign-key relationships.
manifest
Grain: one dataset constant. Rows: 6.
| Field | Type | Meaning |
|---|---|---|
| key | TEXT | Fictional key; units and population follow this table grain |
| value | TEXT | Fictional value; units and population follow this table grain |
obs_checks
Grain: one authorized read-only page check. Rows: 3.
| Field | Type | Meaning |
|---|---|---|
| check_id | TEXT | Stable synthetic key; see schema relationship |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
| surface | TEXT | Fictional surface; units and population follow this table grain |
| observation | TEXT | Fictional observation; units and population follow this table grain |
| result | TEXT | Fictional result; units and population follow this table grain |
plan_gates
Grain: one proposed requirement/release gate. Rows: 4.
| Field | Type | Meaning |
|---|---|---|
| gate_id | TEXT | Stable synthetic key; see schema relationship |
| requirement_id | TEXT | Stable synthetic key; see schema relationship |
| owner_role | TEXT | Fictional owner role; units and population follow this table grain |
| test | TEXT | Fictional test; units and population follow this table grain |
| state | TEXT | Fictional state; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
plan_opportunities
Grain: one unapproved opportunity estimate. Rows: 4.
| Field | Type | Meaning |
|---|---|---|
| opportunity_id | TEXT | Stable synthetic key; see schema relationship |
| name | TEXT | Fictional name; units and population follow this table grain |
| eng_weeks | REAL | Fictional eng weeks; units and population follow this table grain |
| design_weeks | REAL | Fictional design weeks; units and population follow this table grain |
| review_weeks | REAL | Fictional review weeks; units and population follow this table grain |
| dependency | TEXT | Fictional dependency; units and population follow this table grain |
| low_reach | INTEGER | Fictional low reach; units and population follow this table grain |
| high_reach | INTEGER | Fictional high reach; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
practice_answers
Grain: one blank personal exercise answer. Rows: 24.
| Field | Type | Meaning |
|---|---|---|
| exercise_id | TEXT | Stable synthetic key; see schema relationship |
| answer | TEXT | Fictional answer; units and population follow this table grain |
| score | TEXT | Fictional score; units and population follow this table grain |
provenance
Grain: one evidence class. Rows: 4.
| Field | Type | Meaning |
|---|---|---|
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
| status | TEXT | Fictional status; units and population follow this table grain |
| description | TEXT | Fictional description; units and population follow this table grain |
ref_claims
Grain: one public claim with URL/date/limit. Rows: 3.
| Field | Type | Meaning |
|---|---|---|
| claim_id | TEXT | Stable synthetic key; see schema relationship |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
| claim | TEXT | Fictional claim; units and population follow this table grain |
| url | TEXT | Fictional url; units and population follow this table grain |
| accessed | TEXT | Fictional accessed; units and population follow this table grain |
| limitation | TEXT | Fictional limitation; units and population follow this table grain |
sim_accounts
Grain: one fictional billing account. Rows: 180.
| Field | Type | Meaning |
|---|---|---|
| account_id | INTEGER | Stable synthetic key; see schema relationship |
| plan | TEXT | Fictional plan; units and population follow this table grain |
| created_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_attempts
Grain: one render attempt. Rows: 1241.
| Field | Type | Meaning |
|---|---|---|
| attempt_id | INTEGER | Stable synthetic key; see schema relationship |
| task_id | INTEGER | Stable synthetic key; see schema relationship |
| attempt_no | INTEGER | Fictional attempt no; units and population follow this table grain |
| started_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| finished_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| status | TEXT | Fictional status; units and population follow this table grain |
| queue_seconds | INTEGER | Fictional queue seconds; units and population follow this table grain |
| compute_seconds | INTEGER | Fictional compute seconds; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_billing
Grain: one account/calendar month, normalized MRR and cash separate. Rows: 658.
| Field | Type | Meaning |
|---|---|---|
| account_id | INTEGER | Stable synthetic key; see schema relationship |
| month | TEXT | Fictional month; units and population follow this table grain |
| opening_mrr | REAL | Fictional opening mrr; units and population follow this table grain |
| new_mrr | REAL | Fictional new mrr; units and population follow this table grain |
| expansion | REAL | Fictional expansion; units and population follow this table grain |
| contraction | REAL | Fictional contraction; units and population follow this table grain |
| churn | REAL | Fictional churn; units and population follow this table grain |
| closing_mrr | REAL | Fictional closing mrr; units and population follow this table grain |
| cash_received | REAL | Fictional cash received; units and population follow this table grain |
| refunds | REAL | Fictional refunds; units and population follow this table grain |
| payment_fee | REAL | Fictional payment fee; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_costs
Grain: one vendor resource/cost line; task preaggregation required. Rows: 4542.
| Field | Type | Meaning |
|---|---|---|
| cost_id | INTEGER | Stable synthetic key; see schema relationship |
| task_id | INTEGER | Stable synthetic key; see schema relationship |
| component | TEXT | Fictional component; units and population follow this table grain |
| quantity | REAL | Fictional quantity; units and population follow this table grain |
| unit | TEXT | Fictional unit; units and population follow this table grain |
| rate_usd | REAL | Fictional rate usd; units and population follow this table grain |
| cost_usd | REAL | Fictional cost usd; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_entitlements
Grain: one task/meter reservation settlement; unlike public plan rules, fictional. Rows: 1300.
| Field | Type | Meaning |
|---|---|---|
| task_id | INTEGER | Stable synthetic key; see schema relationship |
| meter | TEXT | Fictional meter; units and population follow this table grain |
| reserved | REAL | Fictional reserved; units and population follow this table grain |
| consumed | REAL | Fictional consumed; units and population follow this table grain |
| released | REAL | Fictional released; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_eval_cases
Grain: one fictional independent source case; no underlying media. Rows: 144.
| Field | Type | Meaning |
|---|---|---|
| case_id | INTEGER | Stable synthetic key; see schema relationship |
| slice | TEXT | Fictional slice; units and population follow this table grain |
| split | TEXT | Fictional split; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_eval_results
Grain: one case/candidate result, paired across candidates. Rows: 288.
| Field | Type | Meaning |
|---|---|---|
| case_id | INTEGER | Stable synthetic key; see schema relationship |
| candidate | TEXT | Fictional candidate; units and population follow this table grain |
| task_pass | INTEGER | Fictional task pass; units and population follow this table grain |
| critical_error | INTEGER | Fictional critical error; units and population follow this table grain |
| judge_pass | INTEGER | Fictional judge pass; units and population follow this table grain |
| cost_usd | REAL | Fictional cost usd; units and population follow this table grain |
| latency_seconds | INTEGER | Fictional latency seconds; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_outputs
Grain: one task outcome and nullable checkpoint timestamps. Rows: 1300.
| Field | Type | Meaning |
|---|---|---|
| task_id | INTEGER | Stable synthetic key; see schema relationship |
| ready_at | TEXT | Artifact available to customer, not just a backend HTTP response |
| preview_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| exported_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| distributed_at | TEXT | Fictional approved output delivered to an audience channel |
| confirmed_use_at | TEXT | Fictional confirmation of actual intended use after accepted distribution; not mere export |
| content_version | INTEGER | Fictional content version; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_period_costs
Grain: one month/component cost allocation. Rows: 18.
| Field | Type | Meaning |
|---|---|---|
| month | TEXT | Fictional month; units and population follow this table grain |
| component | TEXT | Fictional component; units and population follow this table grain |
| cost_usd | REAL | Fictional cost usd; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_reviews
Grain: one sampled review per previewed task; no row means unknown. Rows: 617.
| Field | Type | Meaning |
|---|---|---|
| task_id | INTEGER | Stable synthetic key; see schema relationship |
| reviewed_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| accepted | INTEGER | 1 usable under fictional review rubric, 0 rejected, NULL/absent unknown |
| critical_error | INTEGER | Fictional critical error; units and population follow this table grain |
| prep_minutes | REAL | Fictional prep minutes; units and population follow this table grain |
| review_minutes | REAL | Fictional review minutes; units and population follow this table grain |
| repair_minutes | REAL | Fictional repair minutes; units and population follow this table grain |
| manual_baseline_estimate_minutes | REAL | Invented manual estimate, not measured control |
| theme | TEXT | Fictional theme; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_support
Grain: one support ticket. Rows: 202.
| Field | Type | Meaning |
|---|---|---|
| ticket_id | INTEGER | Stable synthetic key; see schema relationship |
| task_id | INTEGER | Stable synthetic key; see schema relationship |
| theme | TEXT | Fictional theme; units and population follow this table grain |
| handling_minutes | REAL | Fictional handling minutes; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_tasks
Grain: one intended source-to-locale/output task; multiple attempts possible. Rows: 1300.
| Field | Type | Meaning |
|---|---|---|
| task_id | INTEGER | Stable synthetic key; see schema relationship |
| user_id | INTEGER | Stable synthetic key; see schema relationship |
| workflow | TEXT | Fictional workflow; units and population follow this table grain |
| locale | TEXT | Fictional locale; units and population follow this table grain |
| created_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| source_minutes | REAL | Input duration, not generated-minute bill or GPU seconds |
| eligible | INTEGER | 1 permitted to attempt, 0 expected rights/plan block; not general user eligibility |
| block_reason | TEXT | Fictional block reason; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
sim_users
Grain: one fictional signup/seat, possibly no tasks. Rows: 312.
| Field | Type | Meaning |
|---|---|---|
| user_id | INTEGER | Stable synthetic key; see schema relationship |
| account_id | INTEGER | Stable synthetic key; see schema relationship |
| persona | TEXT | Fictional persona; units and population follow this table grain |
| primary_workflow | TEXT | Fictional primary workflow; units and population follow this table grain |
| channel | TEXT | Fictional channel; units and population follow this table grain |
| signup_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| variant | TEXT | Random user/seat assignment; deliberately invalid for a clean team-account causal test |
| acquisition_usd | REAL | Fictional acquisition usd; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
v_account_week
Grain: one account/use week. Rows: 199.
| Field | Type | Meaning |
|---|---|---|
| week_start | derived | Fictional week start; units and population follow this table grain |
| account_id | INTEGER | Stable synthetic key; see schema relationship |
| confirmed_tasks | derived | Fictional confirmed tasks; units and population follow this table grain |
v_task
Grain: one task; attempts/costs preaggregated before joins. Rows: 1300.
| Field | Type | Meaning |
|---|---|---|
| task_id | INTEGER | Stable synthetic key; see schema relationship |
| user_id | INTEGER | Stable synthetic key; see schema relationship |
| workflow | TEXT | Fictional workflow; units and population follow this table grain |
| locale | TEXT | Fictional locale; units and population follow this table grain |
| created_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| source_minutes | REAL | Input duration, not generated-minute bill or GPU seconds |
| eligible | INTEGER | 1 permitted to attempt, 0 expected rights/plan block; not general user eligibility |
| block_reason | TEXT | Fictional block reason; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
| account_id | INTEGER | Stable synthetic key; see schema relationship |
| persona | TEXT | Fictional persona; units and population follow this table grain |
| primary_workflow | TEXT | Fictional primary workflow; units and population follow this table grain |
| channel | TEXT | Fictional channel; units and population follow this table grain |
| signup_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| variant | TEXT | Random user/seat assignment; deliberately invalid for a clean team-account causal test |
| plan | TEXT | Fictional plan; units and population follow this table grain |
| attempts | derived | Fictional attempts; units and population follow this table grain |
| failed_attempts | derived | Fictional failed attempts; units and population follow this table grain |
| render_success | derived | Fictional render success; units and population follow this table grain |
| last_finished_at | derived | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| ready_at | TEXT | Artifact available to customer, not just a backend HTTP response |
| preview_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| exported_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| distributed_at | TEXT | Fictional approved output delivered to an audience channel |
| confirmed_use_at | TEXT | Fictional confirmation of actual intended use after accepted distribution; not mere export |
| reviewed_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| accepted | INTEGER | 1 usable under fictional review rubric, 0 rejected, NULL/absent unknown |
| critical_error | INTEGER | Fictional critical error; units and population follow this table grain |
| prep_minutes | REAL | Fictional prep minutes; units and population follow this table grain |
| review_minutes | REAL | Fictional review minutes; units and population follow this table grain |
| repair_minutes | REAL | Fictional repair minutes; units and population follow this table grain |
| manual_baseline_estimate_minutes | REAL | Invented manual estimate, not measured control |
| direct_vendor_usd | derived | Preaggregated render, translation, delivery, vendor review and support; excludes fixed period costs/customer labor |
| confirmed_quality_use | derived | Fictional confirmed quality use; units and population follow this table grain |
| ready_seconds | derived | Fictional ready seconds; units and population follow this table grain |
v_user_cohort
Grain: one user incl zero task; individual mature windows. Rows: 312.
| Field | Type | Meaning |
|---|---|---|
| user_id | INTEGER | Stable synthetic key; see schema relationship |
| account_id | INTEGER | Stable synthetic key; see schema relationship |
| persona | TEXT | Fictional persona; units and population follow this table grain |
| primary_workflow | TEXT | Fictional primary workflow; units and population follow this table grain |
| channel | TEXT | Fictional channel; units and population follow this table grain |
| signup_at | TEXT | UTC nullable checkpoint; absence is unknown/unreached, not a verified failure |
| variant | TEXT | Random user/seat assignment; deliberately invalid for a clean team-account causal test |
| acquisition_usd | REAL | Fictional acquisition usd; units and population follow this table grain |
| source_id | TEXT | Foreign key to evidence class; prevents fictional/public conflation |
| cohort_month | derived | Fictional cohort month; units and population follow this table grain |
| mature7 | derived | Fictional mature7; units and population follow this table grain |
| mature42 | derived | At least 42 full UTC days of follow-up |
| activated7 | derived | Quality-confirmed use and approval within [signup,signup+7d) |
| return28_41 | derived | Quality-confirmed use in [signup+28d,signup+42d); unconditional on activation |
Relationships and event definitions
Account → many users → many tasks → many attempts/costs/support; task → zero/one output/review/entitlement. Review and export are parallel after preview; distribution requires both accepted review and export. Confirmed use follows distribution. A missing review is unknown, not rejection.
Production event proposals: task_created (once on durable intent); attempt_started/finished (once per attempt, status); artifact_ready (retrievable version); preview_opened (dedup task/version); review_submitted (reviewer, rubric, source/target hashes); approval_recorded (exact hashes and decision); export_completed; distribution_confirmed; intended_use_confirmed; entitlement_reserved/consumed/released (entry ID, meter, quantity); task_cancelled. Each has event_id, tenant-safe account/user/task/attempt IDs, UTC timestamp, state/version and source provenance. Do not log raw source/voice/likeness by default. Event delivery can be repeated; consumer deduplicates by event_id, not timestamp alone.
The lab stores milestone timestamps rather than a raw event stream. It cannot test production event delivery, permissions, consent revocation, stale approval or duplicate payload behavior; PRD fixtures specify those future tests. No session/click/paywall/payment-attempt table exists, so traffic conversion and payment success remain unknown.
Assumptions and mechanics
Seed 731904, 180 accounts; plan mix, seat counts, task frequency, persona/workflow/locale mixes and outcomes are arbitrary coverage assumptions. There are no demographic attributes. Every user can have zero tasks. One intended task may have two attempts, with first-failure recovery; resource costs include failures. Rates, customer time and contracts are fictional. Synthetic variant assignment has no intended causal treatment effect and intentionally permits mixed variants within a team. Eval cases are paired baseline/candidate and development/heldout blocks; labels/cost/latency are invented. Candidate outcomes are not model measurements.
Full generator code is authoritative for every probability and unit rate. Calendar-month billing and no reactivation simplify the MRR bridge. October is partial. Failed generated jobs release all fictional reservations; this is an illustrative policy, not verified AI Studios billing. Credits/minutes/video counts must never be summed across meters. Observed checks are page-level only; no fictional output is represented as personally tested.