admin_be_260804

Tables (13)

change_request

  • change_request_id — BIGINT — Primary key — NOT NULL
  • request_id — BIGINT — NOT NULL
  • change_type — VARCHAR(20) — NOT NULL
  • old_value — JSON
  • new_value — JSON — NOT NULL
  • reason — VARCHAR(1000) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • admin_comment — VARCHAR(500)
  • requested_by — BIGINT — NOT NULL
  • reviewed_by — BIGINT
  • reviewed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

container_image

  • image_id — BIGINT — Primary key — NOT NULL
  • image_name — VARCHAR(100) — NOT NULL
  • image_version — VARCHAR(100) — NOT NULL
  • cuda_version — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

gpus

  • gpu_id — BIGINT — Primary key — NOT NULL
  • node_id — VARCHAR(100) — NOT NULL
  • gpu_model — VARCHAR(100) — NOT NULL
  • RAM_GB — INT — NOT NULL

groups

  • group_id — BIGINT — Primary key — NOT NULL
  • group_name — VARCHAR(100) — NOT NULL
  • ubuntu_gid — BIGINT — NOT NULL

message_templates

  • template_key — VARCHAR(100) — Primary key — NOT NULL
  • template_value — TEXT — NOT NULL
  • updated_at — DATETIME

nodes

  • node_id — VARCHAR(100) — Primary key — NOT NULL
  • rsgroup_id — INT — NOT NULL
  • memory_size_GB — INT — NOT NULL
  • CPU_core_count — INT — NOT NULL

pod_external_ports

  • pod_external_port_id — BIGINT — Primary key — NOT NULL
  • request_id — BIGINT — NOT NULL
  • internal_port — INT — NOT NULL
  • external_port — INT — NOT NULL
  • usage_purpose — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

port_requests

  • port_request_id — BIGINT — Primary key — NOT NULL
  • internal_port — INT — NOT NULL
  • usage_purpose — VARCHAR(1000) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • request_id — BIGINT — NOT NULL
  • rsgroup_id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

request_groups

  • request_id — BIGINT — Foreign key → requests.request_id — NOT NULL
  • ubuntu_gid — BIGINT — Foreign key → groups.ubuntu_gid — NOT NULL
  • created_at — DATETIME — NOT NULL

requests

  • request_id — BIGINT — Primary key — NOT NULL
  • ubuntu_username — VARCHAR(100) — NOT NULL
  • ubuntu_uid — BIGINT
  • ubuntu_gid — BIGINT
  • ubuntu_password — VARCHAR(255) — NOT NULL
  • ubuntu_password_base64 — VARCHAR(255) — NOT NULL
  • volume_size_GiB — BIGINT — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • usage_purpose — VARCHAR(1000) — NOT NULL
  • form_answers — JSON — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • admin_comment — VARCHAR(300)
  • user_id — BIGINT — NOT NULL
  • pod_name — VARCHAR(255)
  • node_name — VARCHAR(100)
  • rsgroup_id — INT — NOT NULL
  • image_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

resource_group_images

  • rsgroup_id — INT — Foreign key → resource_groups.rsgroup_id — NOT NULL
  • image_id — BIGINT — Foreign key → container_image.image_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

resource_groups

  • rsgroup_id — INT — Primary key — NOT NULL
  • resource_group_name — VARCHAR(300)
  • description — VARCHAR(500)
  • server_name — VARCHAR(300)

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • student_id — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(100) — NOT NULL
  • department — VARCHAR(100) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • last_login_at — DATETIME
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME