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