test

Tables (5)

bastion_host

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL — 바스천 식별 이름
  • public_ip — VARCHAR(50) — NOT NULL
  • ssh_port — INT — NOT NULL
  • status — ENUM('ACTIVE', 'MAINTENANCE', 'STOPPED') — NOT NULL

db_cluster

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • environment — ENUM('PRD', 'STG', 'DEV', 'TEST') — NOT NULL — 운영 환경
  • ha_architecture — VARCHAR(50) — NOT NULL — M-M, M-S, Galera 등 고가용성 구조
  • created_at — TIMESTAMP

db_server

  • id — UUID — Primary key — NOT NULL
  • cluster_id — UUID — Foreign key → db_cluster.id — 속한 클러스터 (Standalone일 경우 NULL)
  • bastion_id — UUID — Foreign key → bastion_host.id — 접근을 위한 바스천 호스트
  • hostname — VARCHAR(255) — NOT NULL
  • private_ip — VARCHAR(50) — NOT NULL
  • os_name — VARCHAR(100) — NOT NULL
  • os_version — VARCHAR(100) — NOT NULL
  • cpu_cores — INT — NOT NULL — vCPU 수
  • memory_gb — INT — NOT NULL — 메모리 용량(GB)
  • disk_gb — INT — NOT NULL — 디스크 용량(GB)
  • status — ENUM('PROVISIONING', 'RUNNING', 'STOPPED', 'TERMINATED') — NOT NULL

dbms_instance

  • id — UUID — Primary key — NOT NULL
  • server_id — UUID — Foreign key → db_server.id — NOT NULL
  • db_type — VARCHAR(50) — NOT NULL — MySQL, PostgreSQL, MongoDB 등
  • version — VARCHAR(100) — NOT NULL
  • tcp_port — INT — NOT NULL
  • cluster_role — ENUM('PRIMARY', 'REPLICA', 'ARBITER', 'STANDALONE') — NOT NULL — 클러스터 내 역할
  • status — ENUM('STARTING', 'ACTIVE', 'OFFLINE', 'ERROR') — NOT NULL

platform_user

  • id — UUID — Primary key — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — ENUM('SUPER_ADMIN', 'DBA', 'DEVELOPER', 'VIEWER') — NOT NULL — 플랫폼 내 권한 수준
  • created_at — TIMESTAMP