Advertisement
haithienht

[HTD DB] Product fixed

Jan 13th, 2020
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.22 KB | None | 0 0
  1. Name : text [all]
  2. Manufacturer : varchar(255) [all]
  3. Color : varchar(100) [all]
  4. Socket : text [motherboard, cpu, cpucooler]
  5. Chipset : varchar(100) [motherboard, cpu(compatibility),
  6. gpu(whole name, i.e. 1060 3GB, 1060 6GB, etc.)]
  7. MemoryType : varchar(100) [ram(ddr4), motherboard(ddr4), gpu (gddr4), storage (nvme)]
  8. FormFactor : varchar(100) [motherboard, case, storage, psu]
  9. -MaxMemory : int [motherboard, cpu (GB)]
  10. TDP : int [cpu, gpu (combine and compare with psu's wattage) (W)]
  11. Interface : varchar(100) [gpu, storage]
  12. Memory : int [gpu, ram (GB), storage]
  13. +CoreClock : int [cpu, gpu (MHz)]
  14. +Fan : int [gpu, cpucooler]
  15. +ExtensionSlot : int [gpu(slot width) , case]
  16. +PCIELength: int [gpu, case (mm)]
  17. +Cache : int [cpu, storage (MB)]
  18. =+PORT
  19. =DVIPort : int [gpu, motherboard, monitor]
  20. =DVIAPort : int [gpu, motherboard, monitor]
  21. =VGAPort : int [gpu, motherboard, monitor]
  22. =HDMIPort : int [gpu, motherboard, monitor]
  23. =MiniHDMIPort : int [gpu, motherboard, monitor]
  24. =DisplayportPort : int [gpu, motherboard, monitor]
  25. =MiniDisplayportPort : int [gpu, motherboard, monitor]
  26. =SVideoPort : int [gpu, motherboard, monitor]
  27. =EthernetPort : int [motherboard]
  28. =Sata3GPort : int
  29. =Sata6GPort : int
  30. =M2SataPort : int
  31. -Fanless : bit [cpucooler, psu]
  32.  
  33. +IntegratedGraphic : varchar(100) [cpu]
  34. Core : int [cpu]
  35. Thread : int [cpu]
  36. Series : varchar(100) [cpu line (core i7, i5...)]
  37.  
  38. +CoolerHeight : int [cpucooler (mm)]
  39. +FanRPMMin : int (rpm)
  40. +FanRPMMax : int (rpm)
  41. +NoiseMin : float (db)
  42. +NoiseMax : float (db)
  43. +WaterCooled : bit
  44.  
  45. MemorySlot : int [motherboard]
  46. =+SLOT
  47. =PCIE16Slot : int
  48. =PCIE8Slot : int
  49. =PCIE4Slot : int
  50. =PCIE1Slot : int
  51. =PCISlot : int
  52.  
  53. +ExternalPower8Pin : int [gpu]
  54. +ExternalPower6Pin : int
  55.  
  56. StorageType : varchar(100) [storage (hdd, ssd, sshd)]
  57. +StorageRPM : int
  58.  
  59. +PSUEfficiencyRating : varchar(100) [psu]
  60. PSUWattage : int
  61. +PSUModular : varchar(20) (Full, Half, None)
  62. =+CONNECTION
  63. =ConPCIe6Pin : int
  64. =ConPCIe6Plus2Pin : int
  65. =ConEPS : int
  66. =ConSATA : int
  67. =ConMolex4Pin : int
  68.  
  69. +MemorySpeed : int [memory (MHz)]
  70. MemoryModules : int
  71. +CAS : int
  72. +Voltage : float
  73. +ECC : bit
  74. +Registered : bit
  75. +HeatSpreader : bit
  76.  
  77. +CaseType : varchar(20) [case]
  78. PSUFormFactor : varchar(100) (atx, sfx)
  79. +PowerSupplyShroud : bit
  80. +SidePanelType : varchar(100) (Tempered Glass, Acrylic,...)
  81. +FrontPanelUSB : varchar(255) (USB 3.2 Type-C, USB 3.2 Type-A,...)
  82. =+BAY
  83. =External5_25Bay : int
  84. =External3_5Bay : int
  85. =Internal3_5Bay : int
  86. =Internal2_5Bay : int
  87.  
  88. ScreenSize : float [monitor (in)]
  89. Resolution : varchar(20) [1280x720,...]
  90. +AspectRatio : varchar(20)
  91. +PanelType : varchar(20) (IPS, VA, TN,...)
  92. +RefreshRate : int (Hz)
  93. +ResponseTime : int (ms)
  94. +Brightness : int (nt)
  95. +CurvedRatio : float
  96. -BuiltInSpeaker : bit
  97. +ASyncType : varchar(100)
  98. +ASyncMin : int
  99. +ASyncMax : int
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement