data defender

Tables (38)

access_logs

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • user_id — uuid
  • resource_id — uuid
  • action — text — NOT NULL
  • result — text — NOT NULL
  • reason — text
  • ip — inet
  • details — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL

access_logs_2025_09

  • 2025-09-01) — TO

api_keys

  • id — uuid
  • tenant_id — uuid
  • name — text — NOT NULL
  • key_hash — bytea — NOT NULL
  • scope — jsonb — NOT NULL
  • created_by — uuid
  • last_used_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • revoked_at — timestamptz

audit_logs

  • id — uuid
  • tenant_id — uuid
  • actor_principal — uuid
  • action — text — NOT NULL
  • target_type — text
  • target_id — uuid
  • ip — inet
  • user_agent — text
  • details — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL

audit_logs_2025_09

  • 2025-09-01) — TO

clusters

  • id — uuid
  • name — text — NOT NULL
  • type — text — NOT NULL
  • meta — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL

deployments

  • id — uuid
  • release_id — uuid — NOT NULL
  • service_id — uuid — NOT NULL
  • target_scope — text — NOT NULL
  • status — text — NOT NULL
  • logs_url — text
  • started_at — timestamptz — NOT NULL
  • finished_at — timestamptz

group_members

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • group_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • created_at — timestamptz — NOT NULL

groups

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • name — text — NOT NULL
  • description — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

idp_applications

  • id — uuid
  • provider — text — NOT NULL
  • display_name — text — NOT NULL
  • client_id — text — NOT NULL
  • tenant_domain — text — NOT NULL
  • secrets — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

notifications

  • id — uuid
  • tenant_id — uuid
  • audience — text — NOT NULL
  • channel — text — NOT NULL
  • template — text
  • payload — jsonb — NOT NULL
  • status — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • sent_at — timestamptz

patches

  • id — uuid
  • code — text — NOT NULL
  • description — text
  • payload — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL

permissions

  • id — uuid
  • code — text — NOT NULL
  • description — text

plans

  • id — uuid
  • code — text — NOT NULL
  • name — text — NOT NULL
  • limits — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

policies

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • name — text — NOT NULL
  • type — text — NOT NULL
  • description — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

policy_assignments

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • policy_id — uuid — NOT NULL
  • target_type — text — NOT NULL
  • target_id — uuid
  • created_by — uuid
  • created_at — timestamptz — NOT NULL

policy_rules

  • id — uuid
  • policy_id — uuid — NOT NULL
  • version — int — NOT NULL
  • rules — jsonb — NOT NULL
  • is_active — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL

policy_violations

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • user_id — uuid
  • policy_id — uuid
  • resource_id — uuid
  • violation_code — text — NOT NULL
  • details — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL

policy_violations_2025_09

  • 2025-09-01) — TO

principal_role_bindings

  • id — uuid
  • tenant_id — uuid
  • principal_id — uuid — NOT NULL
  • role_id — uuid — NOT NULL
  • created_at — timestamptz — NOT NULL

principals

  • id — uuid
  • tenant_id — uuid
  • type — text — NOT NULL
  • ref_id — uuid

releases

  • id — uuid
  • version — text — NOT NULL
  • artifacts — jsonb — NOT NULL
  • notes — text
  • created_at — timestamptz — NOT NULL

report_runs

  • id — uuid
  • scheduled_report_id — uuid — NOT NULL
  • status — text — NOT NULL
  • output_url — text
  • started_at — timestamptz — NOT NULL
  • finished_at — timestamptz

resources

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • type — text — NOT NULL
  • name — text — NOT NULL
  • path — text
  • owner_id — uuid
  • labels — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

role_permissions

  • id — uuid
  • role_id — uuid — NOT NULL
  • permission_id — uuid — NOT NULL

roles

  • id — uuid
  • scope — text — NOT NULL
  • code — text — NOT NULL
  • name — text — NOT NULL
  • description — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

scheduled_reports

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • name — text — NOT NULL
  • type — text — NOT NULL
  • schedule_cron — text — NOT NULL
  • format — text — NOT NULL
  • recipients — jsonb — NOT NULL
  • last_run_at — timestamptz
  • created_at — timestamptz — NOT NULL

servers

  • id — uuid
  • cluster_id — uuid
  • hostname — text — NOT NULL
  • ip — inet
  • status — text — NOT NULL
  • metrics — jsonb — NOT NULL
  • tls_cert_expiry — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

service_instances

  • id — uuid
  • service_id — uuid — NOT NULL
  • server_id — uuid
  • status — text — NOT NULL
  • meta — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

services

  • id — uuid
  • name — text — NOT NULL
  • description — text
  • created_at — timestamptz — NOT NULL

siem_integrations

  • id — uuid
  • tenant_id — uuid
  • vendor — text — NOT NULL
  • settings — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL

subscriptions

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • plan_id — uuid — NOT NULL
  • status — text — NOT NULL
  • started_at — timestamptz — NOT NULL
  • expires_at — timestamptz
  • meta — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

tenant_idp_links

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • idp_application_id — uuid — NOT NULL
  • status — text — NOT NULL
  • settings — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL

tenant_usage_daily

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • usage_date — date — NOT NULL
  • metrics — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL

users

  • id — uuid
  • tenant_id — uuid — NOT NULL
  • email — citext — NOT NULL
  • name — text — NOT NULL
  • status — text — NOT NULL
  • mfa_enabled — boolean — NOT NULL
  • attributes — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

webhook_deliveries

  • id — uuid
  • webhook_id — uuid — NOT NULL
  • event_code — text — NOT NULL
  • payload — jsonb — NOT NULL
  • status — text — NOT NULL
  • attempt — int — NOT NULL
  • created_at — timestamptz — NOT NULL
  • delivered_at — timestamptz

webhooks

  • id — uuid
  • tenant_id — uuid
  • name — text — NOT NULL
  • url — text — NOT NULL
  • secret — text
  • events — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL
  • disabled_at — timestamptz

테넌트 (tenants)

  • id — uuid
  • code — text — NOT NULL
  • name — text — NOT NULL
  • status — text — NOT NULL
  • settings — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL