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