admin-be
Tables (7)
admins (관리자(유저))
- admins_id (관리자 (우리) 유저 아이디) — Primary key — NOT NULL
- name (관리자 이름)
- password (해시된 패스워드)
- email (관리자 이메일)
groups
- id — INT — Primary key — NOT NULL
- ubuntu_gid — Foreign key → used_ids.id_value — NOT NULL
- ubuntu_groupname — VARCHAR(255) — NOT NULL
node
- node_id — INT — Primary key — NOT NULL
- resource_group_id — INT — Foreign key → resource_group.id — NOT NULL
- node_name — VARCHAR(255) — NOT NULL
- server_address — VARCHAR(255)
- status — VARCHAR(50) — NOT NULL
- INDEX — idx_node_rg
resource_group
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
used_ids (이미 사용한 ID)
- id_value — Primary key — NOT NULL — id라고 해두면 헷갈릴까봐 방지용으로 value를 붙인다.
user_keys
- id — INT
- user_id — INT — NOT NULL
- public_key — TEXT — NOT NULL
- key_name — VARCHAR(100)
- is_active — TINYINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- INDEX — idx_uk_user
- INDEX — idx_uk_active
users (유저)
- user_id — Foreign key → used_ids.id_value — NOT NULL
- resource_group_id — INT — Foreign key → resource_group.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- username — VARCHAR(50) — NOT NULL — 우분투에서 사용할 계정명
- password_hash — VARCHAR(255) — NOT NULL
- is_active — TINYINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL