comalmot
Tables (10)
CPU (cpu)
- id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- purpose (용도) — NOT NULL
- name (이름) — NOT NULL
- price (가격) — NOT NULL
- rate (벤치마크) — NOT NULL
Case (본체케이스)
- id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- name (이름) — NOT NULL
- size (크기) — NOT NULL
- price (가격) — NOT NULL
- purpose (용도) — NOT NULL
Dtrecommend_list (데스크탑 추천 목록)
- id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- cpu_id (FK1) — NOT NULL — Foreign key → CPU.id — NOT NULL
- motherboard_id (FK2) — NOT NULL — Foreign key → Motherboard.id — NOT NULL
- gpu_id (FK3) — NOT NULL — Foreign key → GPU.id — NOT NULL
- ram_id (FK4) — NOT NULL — Foreign key → RAM.id — NOT NULL
- storage_id (FK5) — NOT NULL — Foreign key → Storage.id — NOT NULL
- case_id (FK6) — NOT NULL — Foreign key → Case.id — NOT NULL
- user_id (FK7) — NOT NULL — Foreign key → Users.id — NOT NULL
- name (이름) — NOT NULL
GPU (gpu)
- id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- purpose (용도) — NOT NULL
- name (이름) — NOT NULL
- price (가격) — NOT NULL
- rate (벤치마크) — NOT NULL
Laptop (노트북)
- id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- purpose (용도) — NOT NULL
- name (이름) — NOT NULL
- price (가격) — NOT NULL
- weight (중량) — NOT NULL
- inch (화면크기) — NOT NULL
- volume (용량) — NOT NULL
- ram (램) — NOT NULL
Lrecommend_list (노트북 추천 목록)
- id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- laptop_id (FK) — NOT NULL — Foreign key → Laptop.id — NOT NULL
- user_id (FK2) — NOT NULL — Foreign key → Users.id — NOT NULL
- name (이름) — NOT NULL
Motherboard (메인보드)
- id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- purpose (용도) — NOT NULL
- name (이름) — NOT NULL
- price (가격) — NOT NULL
RAM (ram)
- id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- purpose (용도) — NOT NULL
- name (이름) — NOT NULL
- price (가격) — NOT NULL
Storage (저장장치)
- id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- hs (ssd/hdd) — DEFAULT 0
- speed (속도) — NOT NULL
- purpose (용도) — NOT NULL
- name (이름) — NOT NULL
- price (가격) — NOT NULL
Users (회원)
- id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- Field