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)