Seed Data Validation

All time-series tables converted to TimescaleDB hypertables (13 v4.0 + access_audit_log v4.3)

All 14 hypertables present: access_audit_log, alert_history, arb_monitor, carry_monitor, cnycnh_spread_monitor, convergence_monitor, fact_check_history, forward_curve_snapshot, fx_actual_transactions, fx_forward_curve, fx_rates, fx_spot_rates, ingestion_audit, job_run_log, positions_snapshot, prices_daily, prices_intraday, source_health_log, technical_indicators

timescaledb, uuid-ossp, pg_trgm, btree_gist, vector

All 5 extensions installed

All custom PostgreSQL enum types created

All 13 enum types present

trg_quest_epoch_ms on quests, trg_config_history on system_config

Both triggers active: trg_quest_epoch_ms, trg_config_history, pipboy_link_on_counterparty, pipboy_link_on_cargo

to_epoch_ms, from_epoch_ms, assign_session, log_config_change, get_validation_tier

All 5 functions present

cause_before_result, lag_correct, positive_lag, cause_eligible, daily_only_approximate, confirmed_needs_validated

All 6 causal constraints enforced at schema level

unknown_must_be_blocked, exact_requires_time, approximate_requires_window

All 3 source discipline constraints enforced

override_requires_reason (news + prices), tier_c_no_expiry, valid_ai_tier

All 4 validation constraints enforced

sources, products, config, jobs, status_definitions, field_definitions, users, roles

All seed data present: source_registry=16, products=7, system_config=34, scheduled_jobs_registry=31, status_definitions=54, field_definitions=0, system_users=0, access_roles=14

All table indexes present

214 indexes found across all tables (expected 100+)

field_definitions, status_definitions, counterparty_relationship_events, special_treatment_log

All 4 v4.2 tables present

system_users, access_roles, user_roles, data_permissions, access_audit_log, temporary_access_grants, data_sensitivity_rules

All 7 v4.3 tables present

Individual RLS policy rules created for access control

6 policies: analysis_log/analysis_access, news_items/news_access, physical_cargo/physical_cargo_access, positions_snapshot/positions_access, special_treatment_log/special_treatment_access, trade_recommendation_log/rec_access