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