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