DGU-AILab
Tables (10)
ChangeRequests
- change_request_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → Requests.request_id — NOT NULL — 원본 요청 ID
- change_type — ENUM('VOLUME_SIZE', 'EXPIRES_AT', 'RSGROUP_ID', 'IMAGE_ID', 'GROUPS') — NOT NULL
- old_value — JSON — 기존 값 (비교용)
- new_value — JSON — NOT NULL — 새로운 값
- reason — VARCHAR(1000) — NOT NULL — 변경 사유
- status — ENUM('PENDING', 'APPROVED', 'DENIED') — NOT NULL
- admin_comment — VARCHAR(500) — 관리자 승인/거절 사유
- requested_by — BIGINT — Foreign key → Users.user_id — NOT NULL — 변경 요청한 사용자 ID
- reviewed_by — BIGINT — Foreign key → Users.user_id — 검토한 관리자 ID
- created_at — TIMESTAMP — NOT NULL
- reviewed_at — TIMESTAMP — 검토 완료 시간
ContainerImages
- 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 — ex. 11.8, 12.0
- description — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL
GPUs
- gpu_id — BIGINT — Primary key — NOT NULL
- node_id — VARCHAR(100) — Foreign key → Nodes.node_id — NOT NULL
- gpu_model — VARCHAR(100) — NOT NULL — ex. RTX4050, A3000
- RAM_GB — INT — NOT NULL
Groups
- ubuntu_gid — BIGINT — Foreign key → UsedIds.id_value — NOT NULL
- group_name — VARCHAR(100) — NOT NULL
Nodes
- node_id — VARCHAR(100) — Primary key — NOT NULL — ex. LAB1, FARM2
- rsgroup_id — INT — Foreign key → ResourceGroups.rsgroup_id — NOT NULL
- memory_size_GB — INT — NOT NULL
- CPU_core_count — INT — NOT NULL
RequestGroups
- request_id — BIGINT — Foreign key → Requests.request_id — NOT NULL
- ubuntu_gid — BIGINT — Foreign key → Groups.ubuntu_gid — NOT NULL
- created_at — TIMESTAMP — NOT NULL
Requests
- request_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
- rsgroup_id — INT — Foreign key → ResourceGroups.rsgroup_id — NOT NULL — 리소스 그룹 ID
- image_id — BIGINT — Foreign key → ContainerImages.image_id — NOT NULL — 컨테이너 이미지 ID
- ubuntu_username — VARCHAR(100) — NOT NULL
- ubuntu_uid — BIGINT — Foreign key → UsedIds.id_value — NOT NULL — ubuntu_uid
- volume_size_byte — BIGINT — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- usage_purpose — VARCHAR(1000) — NOT NULL
- form_answers — JSON — NOT NULL
- approved_at — TIMESTAMP — NOT NULL — 허가받은 경우 NOT NULL
- status — ENUM('PENDING', 'DENIED', 'FULFILLED') — NOT NULL — PENDING, DENIED, FULFILLED
- comment — VARCHAR(300) — status에 대한 설명 (거절 사유 등)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
ResourceGroups
- rsgroup_id — INT — Primary key — NOT NULL
- description — VARCHAR(500)
UsedIds
- id_value — BIGINT — Primary key — NOT NULL — UID 또는 GID 값
Users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL — 해당 유저의 실명
- role — ENUM('USER', 'ADMIN') — NOT NULL — USER, ADMIN
- student_id — VARCHAR(100) — NOT NULL
- phone — VARCHAR(100) — NOT NULL
- department — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_active — BOOLEAN — NOT NULL