Data model
Migrations: services/control-plane/migrations/ (0001–0012).
Tables
| Table | Note |
|---|---|
tenants | + slug |
principals | roles: admin, engineer, viewer, operator |
principal_avatars | |
sessions | |
api_tokens | + role_max |
principal_folder_grants | |
projects | |
workspaces | |
revisions | immutable |
revision_resources | immutable |
workspace_resources | draft |
deployment_targets | + runtime_id |
deployment_artifacts | immutable |
audit_events | immutable |
idempotency_keys | |
runtimes | registered runtime endpoints |
Resource kind
folder, tag, screen, equipmentType, equipment, udt, udtInstance, connection, report
Historian DB (separate)
historian_samples — CREATE TABLE IF NOT EXISTS when crates/historian-postgres connects. Not the engineering DB.