Skip to main content

Data Model and Migrations

Tables Declared in SQL Migrations

TableSource
assetsinfra/sql/0001_init.sql:37
audit_credentialsinfra/sql/0001_init.sql:117
background_jobsinfra/sql/0005_job_queue.sql:1
clientsinfra/sql/0001_init.sql:14
contactsinfra/sql/0001_init.sql:24
idempotency_recordsinfra/sql/0003_idempotency.sql:3
invoicesinfra/sql/0001_init.sql:83
outbox_eventsinfra/sql/0004_event_pipeline.sql:12
paymentsinfra/sql/0001_init.sql:95
platform_settingsinfra/sql/0007_configuration_plane.sql:3
portal_invitesinfra/sql/0011_portal_invites.sql:1
projectsinfra/sql/0001_init.sql:61
psa_resourcesinfra/sql/0002_psa_resources.sql:5
runtime_secretsinfra/sql/0007_configuration_plane.sql:19
tasksinfra/sql/0001_init.sql:71
telemetry_ingest_batchesinfra/sql/0004_event_pipeline.sql:3
ticketsinfra/sql/0001_init.sql:49
webhook_receiptsinfra/sql/0006_security_hardening.sql:3
worker_runtime_statusinfra/sql/0010_worker_runtime.sql:1
workflow_callbacksinfra/sql/0004_event_pipeline.sql:28
workflow_executionsinfra/sql/0001_init.sql:106
workspace_settingsinfra/sql/0007_configuration_plane.sql:11
workspacesinfra/sql/0001_init.sql:6

Constraints and Hardening Clauses

ConstraintSource
background_jobs_status_checkinfra/sql/0006_security_hardening.sql:69
background_jobs_workspace_fkinfra/sql/0006_security_hardening.sql:141
outbox_events_status_checkinfra/sql/0006_security_hardening.sql:57
outbox_events_workspace_fkinfra/sql/0006_security_hardening.sql:105
telemetry_ingest_batches_event_count_checkinfra/sql/0006_security_hardening.sql:81
telemetry_ingest_batches_workspace_fkinfra/sql/0006_security_hardening.sql:93
whereinfra/sql/0006_security_hardening.sql:30
whereinfra/sql/0006_security_hardening.sql:42
whereinfra/sql/0006_security_hardening.sql:54
whereinfra/sql/0006_security_hardening.sql:66
whereinfra/sql/0006_security_hardening.sql:78
whereinfra/sql/0006_security_hardening.sql:90
whereinfra/sql/0006_security_hardening.sql:102
whereinfra/sql/0006_security_hardening.sql:114
whereinfra/sql/0006_security_hardening.sql:126
whereinfra/sql/0006_security_hardening.sql:138
workflow_callbacks_execution_fkinfra/sql/0006_security_hardening.sql:117
workflow_callbacks_status_checkinfra/sql/0006_security_hardening.sql:45
workflow_callbacks_workspace_fkinfra/sql/0006_security_hardening.sql:129
workflow_executions_status_checkinfra/sql/0006_security_hardening.sql:33

Key Storage Areas

  • 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