NewTest

Tables (9)

cases

  • csname — varchar(100) — Primary key
  • csmaker — varchar(20) — Primary key
  • regdate — varchar(20)
  • cstype — varchar(20)
  • price — int(8)

comlist

  • listname — varchar(100) — Primary key
  • listnum — int(100) — Primary key — NOT NULL
  • totalprice — int(100)

cpu

  • cname — varchar(100) — Primary key
  • cmaker — varchar(20) — Primary key
  • regdate — varchar(20)
  • socket — varchar(20)
  • price — int(8)

graphiccard

  • gcname — varchar(100) — Primary key
  • gcmaker — varchar(20) — Primary key
  • regdate — varchar(20)
  • vram — varchar(10)
  • usepower — int(10)
  • price — int(8)

hdd

  • hname — varchar(100) — Primary key
  • hmaker — varchar(20) — Primary key
  • regdate — varchar(20)
  • hcap — varchar(10)
  • hfactor — varchar(6)
  • price — int(8)

mainboard

  • mbname — varchar(100) — Primary key
  • mbmaker — varchar(20) — Primary key
  • regdate — varchar(20)
  • mddr — varchar(5)
  • msocket — varchar(20)
  • price — int(8)

power

  • pname — varchar(100) — Primary key
  • pmaker — varchar(20) — Primary key
  • regdate — varchar(20)
  • rpower — int(10)
  • pgrade — varchar(20)
  • price — int(8)

ram

  • rname — varchar(100) — Primary key
  • rmaker — varchar(20) — Primary key
  • regdate — varchar(20)
  • rcap — varchar(4)
  • ddr — varchar(5)
  • price — int(8)

ssd

  • sname — varchar(100) — Primary key
  • smaker — varchar(20) — Primary key
  • regdate — varchar(20)
  • scap — varchar(10)
  • sfactor — varchar(20)
  • price — int(8)