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