CPU Specifications

CREATE TABLE amd (
  "model" VARCHAR,
  "family" VARCHAR,
  "line" VARCHAR,
  "platform" VARCHAR,
  "launch_date" VARCHAR,
  "n__of_cpu_cores" DOUBLE  -- # Of CPU Cores,
  "n__of_threads" DOUBLE  -- # Of Threads,
  "n__of_gpu_cores" DOUBLE  -- # Of GPU Cores,
  "compute_cores" VARCHAR,
  "base_clock" VARCHAR,
  "max_boost_clock" VARCHAR,
  "all_core_boost_speed" VARCHAR,
  "total_l1_cache" VARCHAR,
  "total_l2_cache" VARCHAR,
  "total_l3_cache" VARCHAR,
  "unlocked" VARCHAR,
  "cmos" VARCHAR,
  "package" VARCHAR,
  "socket_count" VARCHAR,
  "pci_express_version_amd_epyc_7002_series" VARCHAR  -- PCI Express® Version AMD EPYC™ 7002 Series,
  "thermal_solution_pib" VARCHAR,
  "default_tdp_tdp_amd_epyc_7002_series" VARCHAR  -- Default TDP / TDP AMD EPYC™ 7002 Series,
  "ctdp" VARCHAR,
  "max_temps" VARCHAR,
  "system_memory_specification_amd_epyc_7002_series" VARCHAR  -- System Memory Specification AMD EPYC™ 7002 Series,
  "system_memory_type" VARCHAR,
  "memory_channels" DOUBLE,
  "per_socket_mem_bw" VARCHAR,
  "graphics_frequency" VARCHAR,
  "gpu_base" VARCHAR,
  "graphics_model" VARCHAR,
  "graphics_core_count" DOUBLE,
  "displayport" VARCHAR,
  "hdmi" VARCHAR,
  "dvi" VARCHAR,
  "vga" VARCHAR
);

CREATE TABLE intel (
  "processor" VARCHAR,
  "status" VARCHAR,
  "release_date" VARCHAR,
  "cores" BIGINT,
  "max_turbo_speed" VARCHAR,
  "base_speed" VARCHAR,
  "cache_size" VARCHAR
);