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