[HTD DB] Product

Name : text 											[all]
Manufacturer : varchar(255) 							[all]
Color : varchar(100)									[all]
Socket : text 											[motherboard, cpu, cpucooler]
Chipset : varchar(100)									[motherboard, cpu(compatibility),
														 gpu(whole name, i.e. 1060 3GB, 1060 6GB, etc.)]
MemoryType : varchar(100)								[ram(ddr4), motherboard(ddr4), gpu (gddr4), storage (nvme)]
FormFactor : varchar(100)								[motherboard, case, storage, psu]
MaxMemory : int											[motherboard, cpu (GB)]
TDP : int												[cpu, gpu (combine and compare with psu's wattage) (W)]
Interface : varchar(100)								[gpu, storage]
Memory : int											[gpu, ram (GB), storage]
CoreClock : int											[cpu, gpu (MHz)]
Fan : int												[gpu, cpucooler]
ExtensionSlot : int										[gpu(slot width) , case]
PCIELength: int											[gpu, case (mm)]
Cache : int												[cpu, storage (MB)]
DVIPort : int											[gpu, motherboard, monitor]
DVIAPort : int											[gpu, motherboard, monitor]
VGAPort : int											[gpu, motherboard, monitor]
HDMIPort : int											[gpu, motherboard, monitor]
MiniHDMIPort : int										[gpu, motherboard, monitor]
DisplayportPort : int									[gpu, motherboard, monitor]
MiniDisplayportPort : int								[gpu, motherboard, monitor]
SVideoPort : int										[gpu, motherboard, monitor]
Fanless : bit											[cpucooler, psu]

IntegratedGraphic : varchar(100)						[cpu]
Core : int												[cpu]
Thread : int											[cpu]
Series : varchar(100)									[cpu line (core i7, i5...)]

CoolerHeight : int										[cpucooler (mm)]
FanRPMMin : int											(rpm)
FanRPMMax : int											(rpm)
NoiseMin : float										(db)
NoiseMax : float										(db)
WaterCooled : bit

MemorySlot : int 										[motherboard]
PCIE16Slot : int
PCIE8Slot : int
PCIE4Slot : int
PCIE1Slot : int
PCISlot : int
EthernetPort : int
Sata3GPort : int
Sata6GPort : int
M2SataPort : int

ExternalPower8Pin : int									[gpu]
ExternalPower6Pin : int

StorageType : varchar(100)								[storage (hdd, ssd, sshd)]
StorageRPM : int

PSUEfficiencyRating : varchar(100)						[psu]
PSUWattage : int
PSUModular : varchar(20)								(Full, Half, None)
ConPCIe6Pin : int
ConPCIe6Plus2Pin : int
ConEPS : int
ConSATA : int
ConMolex4Pin : int

MemorySpeed : int										[memory (MHz)]
Modules : int
CAS : int
Voltage : float
ECC : bit
Registered : bit
HeatSpreader : bit

CaseType : varchar(20)									[case]
PSUFormFactor : varchar(100)							(atx, sfx)
PowerSupplyShroud : bit
SidePanelType : varchar(100)							(Tempered Glass, Acrylic,...)
FrontPanelUSB : varchar(255)							(USB 3.2 Type-C, USB 3.2 Type-A,...)
External5_25Bay : int
External3_5Bay : int
Internal3_5Bay : int
Internal2_5Bay : int

ScreenSize : float										[monitor (in)]
ResolutionW : int
ResolutionH : int
AspectRatio : varchar(20)
PanelType : varchar(20)									(IPS, VA, TN,...)
RefreshRate : int										(Hz)
ResponseTime : int										(ms)
Brightness : int										(nt)
CurvedRatio : float
BuiltInSpeaker : bit
ASyncType : varchar(100)
ASyncMin : int
ASyncMax : int