Data Model and Migrations

Tables Declared in SQL Migrations

Table	Source
`assets`	infra/sql/0001_init.sql:37
`audit_credentials`	infra/sql/0001_init.sql:117
`background_jobs`	infra/sql/0005_job_queue.sql:1
`clients`	infra/sql/0001_init.sql:14
`contacts`	infra/sql/0001_init.sql:24
`idempotency_records`	infra/sql/0003_idempotency.sql:3
`invoices`	infra/sql/0001_init.sql:83
`outbox_events`	infra/sql/0004_event_pipeline.sql:12
`payments`	infra/sql/0001_init.sql:95
`platform_settings`	infra/sql/0007_configuration_plane.sql:3
`portal_invites`	infra/sql/0011_portal_invites.sql:1
`projects`	infra/sql/0001_init.sql:61
`psa_resources`	infra/sql/0002_psa_resources.sql:5
`runtime_secrets`	infra/sql/0007_configuration_plane.sql:19
`tasks`	infra/sql/0001_init.sql:71
`telemetry_ingest_batches`	infra/sql/0004_event_pipeline.sql:3
`tickets`	infra/sql/0001_init.sql:49
`webhook_receipts`	infra/sql/0006_security_hardening.sql:3
`worker_runtime_status`	infra/sql/0010_worker_runtime.sql:1
`workflow_callbacks`	infra/sql/0004_event_pipeline.sql:28
`workflow_executions`	infra/sql/0001_init.sql:106
`workspace_settings`	infra/sql/0007_configuration_plane.sql:11
`workspaces`	infra/sql/0001_init.sql:6

Constraint	Source
`background_jobs_status_check`	infra/sql/0006_security_hardening.sql:69
`background_jobs_workspace_fk`	infra/sql/0006_security_hardening.sql:141
`outbox_events_status_check`	infra/sql/0006_security_hardening.sql:57
`outbox_events_workspace_fk`	infra/sql/0006_security_hardening.sql:105
`telemetry_ingest_batches_event_count_check`	infra/sql/0006_security_hardening.sql:81
`telemetry_ingest_batches_workspace_fk`	infra/sql/0006_security_hardening.sql:93
`where`	infra/sql/0006_security_hardening.sql:30
`where`	infra/sql/0006_security_hardening.sql:42
`where`	infra/sql/0006_security_hardening.sql:54
`where`	infra/sql/0006_security_hardening.sql:66
`where`	infra/sql/0006_security_hardening.sql:78
`where`	infra/sql/0006_security_hardening.sql:90
`where`	infra/sql/0006_security_hardening.sql:102
`where`	infra/sql/0006_security_hardening.sql:114
`where`	infra/sql/0006_security_hardening.sql:126
`where`	infra/sql/0006_security_hardening.sql:138
`workflow_callbacks_execution_fk`	infra/sql/0006_security_hardening.sql:117
`workflow_callbacks_status_check`	infra/sql/0006_security_hardening.sql:45
`workflow_callbacks_workspace_fk`	infra/sql/0006_security_hardening.sql:129
`workflow_executions_status_check`	infra/sql/0006_security_hardening.sql:33

Resource records: psa_resources
Workflow execution and callback history: workflow_executions, workflow_callbacks
Audit evidence: audit_credentials
Event durability: telemetry_ingest_batches, outbox_events
Job queue: background_jobs
Idempotency: idempotency_records
Runtime config/secrets: platform_settings, workspace_settings, runtime_secrets