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