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