team1
Tables (17)
approvals
- approval_id — UUID
- change_request_id — UUID — Foreign key → change_requests.change_request_id — NOT NULL
- approver_user_id — UUID — Foreign key → users.user_id — NOT NULL
- approval_type — VARCHAR(30) — NOT NULL
- decision — VARCHAR(20) — NOT NULL
- comment — TEXT — EX
- created_at — TIMESTAMP — NOT NULL
atlantis_runs
- run_id — UUID
- change_request_id — UUID — Foreign key → change_requests.change_request_id — NOT NULL
- run_type — VARCHAR(20) — NOT NULL
- atlantis_project — VARCHAR(200)
- status — VARCHAR(30) — NOT NULL
- triggered_by — VARCHAR(30)
- started_at — TIMESTAMP
- finished_at — TIMESTAMP
- log_url — VARCHAR(500)
- raw_output — TEXT
- created_at — TIMESTAMP — NOT NULL
change_requests
- change_request_id — UUID
- tenant_id — UUID — Foreign key → tenants.tenant_id — NOT NULL
- env_id — UUID — Foreign key → environments.env_id — NOT NULL
- service_id — UUID — Foreign key → services.service_id — NOT NULL
- sla_id — UUID — Foreign key → sla_definitions.sla_id
- slo_policy_id — UUID — Foreign key → slo_policies.slo_policy_id
- request_type — VARCHAR(30) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- status — VARCHAR(50) — NOT NULL
- risk_level — VARCHAR(20)
- expected_cost_delta — BIGINT
- requested_by_user_id — UUID — Foreign key → users.user_id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
cloud_accounts
- cloud_account_id — UUID
- tenant_id — UUID — Foreign key → tenants.tenant_id — NOT NULL
- env_id — UUID — Foreign key → environments.env_id — NOT NULL
- provider — VARCHAR(30) — NOT NULL
- account_id — VARCHAR(20) — NOT NULL
- region — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
cloud_credentials
- credential_id — UUID
- cloud_account_id — UUID — Foreign key → cloud_accounts.cloud_account_id — NOT NULL
- execution_role_arn — VARCHAR(500) — NOT NULL
- external_id — VARCHAR(200)
- session_name_template — VARCHAR(200)
- created_at — TIMESTAMP — NOT NULL
csp
- id — UUID
- provider — VARCHAR(20) — NOT NULL
- region — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
deployment_events
- event_id — UUID
- change_request_id — UUID — Foreign key → change_requests.change_request_id — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- message — TEXT
- payload_json — JSONB
- created_at — TIMESTAMP — NOT NULL
environments
- env_id — UUID
- tenant_id — UUID — Foreign key → tenants.tenant_id — NOT NULL
- env_name — VARCHAR(50) — NOT NULL
- cloud_provider — VARCHAR(30) — NOT NULL
- region — VARCHAR(50) — NOT NULL
- is_production — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
github_prs
- pr_id — UUID
- change_request_id — UUID — Foreign key → change_requests.change_request_id — NOT NULL
- repo_owner — VARCHAR(200) — NOT NULL
- repo_name — VARCHAR(200) — NOT NULL
- base_branch — VARCHAR(200) — NOT NULL
- head_branch — VARCHAR(200) — NOT NULL
- pr_number — INT — NOT NULL
- pr_url — VARCHAR(500)
- commit_sha — VARCHAR(100)
- pr_state — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
infra_resources
- resource_id — UUID
- env_id — UUID — Foreign key → environments.env_id — NOT NULL
- service_id — UUID — Foreign key → services.service_id
- created_by_change_request_id — UUID — Foreign key → change_requests.change_request_id
- resource_type — VARCHAR(200) — NOT NULL
- resource_name — VARCHAR(200)
- cloud_resource_id — VARCHAR(500)
- tags_json — JSONB
- last_seen_at — TIMESTAMP
monitoring_artifacts
- artifact_id — UUID
- slo_policy_id — UUID — Foreign key → slo_policies.slo_policy_id — NOT NULL
- artifact_type — VARCHAR(50) — NOT NULL
- artifact_name — VARCHAR(200) — NOT NULL
- artifact_format — VARCHAR(20) — NOT NULL
- artifact_content — TEXT — NOT NULL
- hash_sha256 — VARCHAR(64)
- generated_by_agent — VARCHAR(200)
- created_at — TIMESTAMP — NOT NULL
services
- service_id — UUID
- tenant_id — UUID — Foreign key → tenants.tenant_id — NOT NULL
- env_id — UUID — Foreign key → environments.env_id — NOT NULL
- service_name — VARCHAR(200) — NOT NULL
- service_type — VARCHAR(30) — NOT NULL
- owner_team — VARCHAR(200)
- description — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
sla_definitions
- sla_id — UUID
- service_id — UUID — Foreign key → services.service_id — NOT NULL
- version — INT — NOT NULL
- sla_title — VARCHAR(200)
- raw_input_text — TEXT — NOT NULL
- input_format — VARCHAR(30) — NOT NULL
- availability_target — NUMERIC(6,3)
- latency_p95_ms — INT
- latency_p99_ms — INT
- error_rate_target — NUMERIC(8,6)
- rto_seconds — INT
- rpo_seconds — INT
- cost_limit_monthly — BIGINT
- effective_from — DATE
- effective_to — DATE
- created_by_user_id — UUID — Foreign key → users.user_id
- created_at — TIMESTAMP — NOT NULL
slo_policies
- slo_policy_id — UUID
- sla_id — UUID — Foreign key → sla_definitions.sla_id — NOT NULL
- service_id — UUID — Foreign key → services.service_id — NOT NULL
- policy_version — INT — NOT NULL
- slo_json — JSONB — NOT NULL
- sli_definitions_json — JSONB
- burn_rate_rules_json — JSONB
- error_budget_window_days — INT — NOT NULL
- evaluation_interval_seconds — INT — NOT NULL
- compiled_by_agent — VARCHAR(200)
- compiled_at — TIMESTAMP — NOT NULL
tenants
- tenant_id — UUID
- tenant_name — VARCHAR(200) — NOT NULL
- org_domain — VARCHAR(200)
- billing_plan — VARCHAR(50)
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
terraform_workspaces
- workspace_id — UUID
- env_id — UUID — Foreign key → environments.env_id — NOT NULL
- workspace_name — VARCHAR(200) — NOT NULL
- backend_type — VARCHAR(30) — NOT NULL
- backend_config_json — JSONB — NOT NULL
- last_applied_commit — VARCHAR(100)
- last_apply_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
users
- user_id — UUID
- tenant_id — UUID — Foreign key → tenants.tenant_id — NOT NULL
- email — VARCHAR(200) — NOT NULL
- name — VARCHAR(200)
- role — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL