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