Computer Architecture Project

Tables (5)

BaseEntity (Untitled)

  • created_at (생성일) — Datetime
  • updated_at (수정일) — Datetime

Member (멤버)

  • member_id (PK) — Integer — Primary key — NOT NULL
  • name (이름) — String
  • student_number (학번) — String
  • password (비밀번호) — String

SSHCrediential (원격 접속)

  • credential_id (PK) — Integer — Primary key — NOT NULL
  • vm_id (FK) — Integer — Foreign key → VMachine.vm_id — NOT NULL
  • username (유저 이름) — String
  • ssh_key (ssh를 위한 key(아마 pem key)) — String

VMSpec (Untitled2)

  • vm_spec_id (PK) — Integer — Primary key — NOT NULL
  • vm_id (FK) — Integer — Foreign key → VMachine.vm_id — NOT NULL
  • cpu_cores (cpu 코어 수) — Short
  • memory_mb (메모리 크기) — Short
  • dist_gb (디스크 크기) — Short

VMachine (가상 머신)

  • vm_id (PK) — Integer — Primary key — NOT NULL
  • member_id (FK) — Integer — Foreign key → Member.member_id — NOT NULL
  • proxmox_vm_id (proxmox에서 부여받은 번호) — String
  • status (상태(On or Off)) — Boolean