pc_symphony

Tables (16)

cart

  • cart_id — int
  • cpu_id — int — Foreign key → cpu.cpu_id
  • cpucooler_id — int — Foreign key → cpucooler.cpucooler_id
  • motherboard_id — int — Foreign key → motherboard.motherboard_id
  • memory_id — int — Foreign key → memory.memory_id
  • storage_id — int — Foreign key → storage.storage_id
  • videocard_id — int — Foreign key → videocard.videocard_id
  • powersupply_id — int — Foreign key → powersupply.powersupply_id
  • cover_id — int — Foreign key → cover.cover_id
  • user_id — varchar(20) — Foreign key — NOT NULL
  • Key — Foreign key → user.user_id — NOT NULL

community

  • community_id — int — Primary key — NOT NULL
  • community_title — VARCHAR(100) — NOT NULL
  • community_content — VARCHAR(2000) — NOT NULL
  • community_view — INT
  • community_date — TIMESTAMP
  • user_id — VARCHAR(20) — Foreign key → user.user_id — NOT NULL

community_reply

  • community_id (community_id2) — int — Foreign key → community.community_id — NOT NULL
  • user_id — VARCHAR(20) — Foreign key → user.user_id — NOT NULL
  • community_reply_id — INT
  • community_id — INT
  • community_reply_content — VARCHAR(500) — NOT NULL

cover

  • cover_id — int
  • cover_name — varchar(255) — NOT NULL
  • cover_manufactor — varchar(50) — NOT NULL
  • cover_part — varchar(50) — NOT NULL
  • cover_price — double
  • cover_power_supply — varchar(100)
  • cover_motherboard_Form_Factor — varchar(50) — NOT NULL
  • cover_Maximum_Video_Card_Length — varchar(100) — NOT NULL
  • cover_type — varchar(50) — NOT NULL
  • cover_color — varchar(20) — NOT NULL

cpu

  • cpu_id — int
  • cpu_name — varchar(255) — NOT NULL
  • cpu_manufacturer — varchar(50) — NOT NULL
  • cpu_part — varchar(50) — NOT NULL
  • cpu_price — double
  • cpu_series — varchar(50) — NOT NULL
  • cpu_socket — varchar(50) — NOT NULL
  • cpu_includes_cooler — bool — NOT NULL
  • cpu_tdp — int — NOT NULL
  • cpu_microarchitecture — varchar(50) — NOT NULL
  • cpu_core_count — int
  • cpu_thread_count — int
  • cpu_performance_core_clock — int
  • cpu_performance_core_boost_clock — int

cpucooler

  • cpucooler_id — int
  • cpucooler_name — varchar(255) — NOT NULL
  • cpucooler_manufacturer — varchar(50) — NOT NULL
  • cpucooler_part — varchar(50) — NOT NULL
  • cpucooler_price — double
  • cpucooler_cpu_socket — varchar(20)
  • cpucooler_Water_cooled — bool
  • cpucooler_color — varchar(20)
  • cpucooler_noise_level — int
  • cpucooler_fan_rpm — varchar(20)

guideline

  • guideline_id — int
  • guideline_title — varchar(100) — NOT NULL
  • guideline_content — varchar(2000) — NOT NULL
  • cpu_id — int — Foreign key → cpu.cpu_id
  • cpucooler_id — int — Foreign key → cpucooler.cpucooler_id
  • motherboard_id — int — Foreign key → motherboard.motherboard_id
  • memory_id — int — Foreign key → memory.memory_id
  • storage_id — int — Foreign key → storage.storage_id
  • videocard_id — int — Foreign key → videocard.videocard_id
  • powersupply_id — int — Foreign key → powersupply.powersupply_id
  • cover_id — int — Foreign key → cover.cover_id

memory

  • memory_id — int
  • memory_name — varchar(255) — NOT NULL
  • memory_manufacturer — varchar(50) — NOT NULL
  • memory_part — varchar(50) — NOT NULL
  • memory_price — double
  • memory_form_factor — varchar(50) — NOT NULL
  • memory_color — varchar(20)
  • memory_module — varchar(50)
  • memory_speed — int

motherboard

  • motherboard_id — int
  • motherboard_name — varchar(255) — NOT NULL
  • motherboard_manufacturer — varchar(50) — NOT NULL
  • motherboard_part — varchar(50) — NOT NULL
  • motherboard_price — double
  • motherboard_socket_cpu — varchar(50) — NOT NULL
  • motherboard_form_factor — varchar(50) — NOT NULL
  • motherboard_memory_type — varchar(50) — NOT NULL
  • motherboard_chipset — varchar(50)
  • motherboard_memory_slot_count — int
  • motherboard_m_dot_2_slot_count — int
  • motherboard_memory_max — int
  • motherboard_color — varchar(20)

partsreview

  • partsreview_id — int
  • partsreview_rating — int
  • partsreview_title — varchar(100) — NOT NULL
  • partsreview_content — varchar(2000) — NOT NULL
  • partsreview_date — TIMESTAMP
  • user_id — varchar(20) — Foreign key
  • cpu_id — int — Foreign key → cpu.cpu_id
  • cpucooler_id — int — Foreign key → cpucooler.cpucooler_id
  • motherboard_id — int — Foreign key → motherboard.motherboard_id
  • memory_id — int — Foreign key → memory.memory_id
  • storage_id — int — Foreign key → storage.storage_id
  • videocard_id — int — Foreign key → videocard.videocard_id
  • powersupply_id — int — Foreign key → powersupply.powersupply_id
  • cover_id — int — Foreign key → cover.cover_id
  • Key — Foreign key → user.user_id — NOT NULL

pcreview

  • pcreview_id — int
  • pcreview_title — varchar(100) — NOT NULL
  • pcreview_content — varchar(2000) — NOT NULL
  • pcreview_date — timestamp
  • user_id — varchar(20) — Foreign key
  • cpu_review_id — int — Foreign key → partsreview.partsreview_id
  • cpucooler_review_id — int — Foreign key → partsreview.partsreview_id
  • motherboard_review_id — int — Foreign key → partsreview.partsreview_id
  • memory_review_id — int — Foreign key → partsreview.partsreview_id
  • storage_review_id — int — Foreign key → partsreview.partsreview_id
  • videocard_review_id — int — Foreign key → partsreview.partsreview_id
  • powersupply_review_id — int — Foreign key → partsreview.partsreview_id
  • cover_review_id — int — Foreign key → partsreview.partsreview_id
  • Key — Foreign key → user.user_id — NOT NULL

pcreviewcomment

  • pcreviewcomment_id — int
  • pcreviewcomment_content — varchar(2000)
  • pcreviewcomment_date — timestamp
  • pcreview_id — int — Foreign key → pcreview.pcreview_id — NOT NULL
  • user_id — varchar(20) — Foreign key
  • Key — Foreign key → user.user_id — NOT NULL

powersupply

  • powersupply_id — int
  • powersupply_name — varchar(255) — NOT NULL
  • powersupply_manufactor — varchar(50) — NOT NULL
  • powersupply_part — varchar(50) — NOT NULL
  • powersupply_price — double
  • powersupply_type — varchar(50) — NOT NULL
  • powersupply_wattage — int — NOT NULL
  • powersupply_length — int
  • powersupply_color — varchar(20)

storage

  • storage_id — int
  • storage_name — varchar(255) — NOT NULL
  • storage_manufactor — varchar(50) — NOT NULL
  • storage_part — varchar(50) — NOT NULL
  • storage_price — double
  • storage_type — varchar(50) — NOT NULL
  • storage_form_factor — varchar(50) — NOT NULL
  • storage_capacity — varchar(50)

user

  • user_id — VARCHAR(20) — Primary key — NOT NULL
  • user_pw — VARCHAR(200) — NOT NULL
  • user_name — VARCHAR(20) — NOT NULL
  • user_email — VARCHAR(50) — NOT NULL
  • user_address — VARCHAR(1000)
  • user_gender — VARCHAR(10)

videocard

  • videocard_id — int
  • videocard_name — varchar(255) — NOT NULL
  • videocard_manufactor — varchar(50) — NOT NULL
  • videocard_part — varchar(50) — NOT NULL
  • videocard_price — double
  • videocard_length — varchar(50)
  • videocard_tdp — int — NOT NULL
  • videocard_memory — varchar(50)
  • videocard_chipset — varchar(50)
  • videocard_color — varchar(20)
  • videocard_core_clock — int
  • videocard_boost_clock — int