erd
Tables (18)
board
- board_id — int — Primary key — NOT NULL
- created_time — varchar(40) — NOT NULL
- user_id — varchar(20) — Foreign key → users.id — NOT NULL
- author_name — varchar(20) — NOT NULL
- contents — varchar(2000) — NOT NULL
- title — varchar(100) — NOT NULL
- category — varchar(20) — NOT NULL
- likes — int
- dislikes — int
- views — int
- image_filename — varchar(100)
cart
- cart_id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → users.id — NOT NULL
- item_name — varchar(100) — NOT NULL
- parts_name — varchar(1000) — NOT NULL
- price — int — NOT NULL
- quantity — int — NOT NULL
- image_filename — varchar(255)
case_
- case_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- supported_form_factors — varchar(100)
- max_gpu_length — int
- max_cpu_cooler_height — int
- max_psu_length — int
- drive_bays — varchar(50)
- image_filename — varchar(100)
comment
- comment_id — int — Primary key — NOT NULL
- board_id — int — Foreign key → board.board_id — NOT NULL
- user_id — varchar(20) — Foreign key → users.id — NOT NULL
- author_name — varchar(20) — NOT NULL
- contents — varchar(1000) — NOT NULL
cooler
- cooler_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- height_mm — int
- supported_sockets — varchar(100)
- image_filename — varchar(100)
cpu
- cpu_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- brand — varchar(20)
- generation — varchar(20)
- socket — varchar(20)
- tdp — int
- max_memory_speed — int
- memory_type — varchar(20)
- pcie_version — varchar(10)
- image_filename — varchar(100)
faq
- faq_id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → users.id — NOT NULL
- question — varchar(1000) — NOT NULL
- answer — varchar(2000) — NOT NULL
- category — varchar(50) — NOT NULL
gpu
- gpu_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- chipset — varchar(50)
- vram — int
- maker — varchar(50)
- pcie_version — varchar(10)
- length_mm — int
- image_filename — varchar(100)
inventory
- name — varchar(100) — Primary key — NOT NULL
- quantity — int — NOT NULL
- sale_count — int — NOT NULL
- price — int — NOT NULL
motherboard
- mb_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- brand — varchar(20)
- chipset — varchar(20)
- socket — varchar(20)
- ram_type — varchar(20)
- ram_slots — int
- max_ram_capacity — int
- max_ram_speed — int
- pcie_slots — int
- pcie_version — varchar(10)
- form_factor — varchar(20)
- m2_slots — int
- sata_ports — int
- image_filename — varchar(100)
order_items
- order_item_id — int — Primary key — NOT NULL
- order_id — int — Foreign key → orders.order_id — NOT NULL
- parts_name — varchar(1000) — NOT NULL
- item_name — varchar(100) — NOT NULL
- unit_price — int — NOT NULL
- quantity — int — NOT NULL
- subtotal — int — NOT NULL
orders
- order_id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → users.id — NOT NULL
- buyer_name — varchar(50) — NOT NULL
- buyer_phone — varchar(20) — NOT NULL
- total_price — int — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — datetime
peripherals
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- category — varchar(50) — NOT NULL
- brand — varchar(100)
- price — int — NOT NULL
- quantity — int
- sale_count — int
- image_filename — varchar(255)
- spec — json
- is_peripheral — tinyint(1)
psu
- psu_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- wattage — int
- efficiency_rating — varchar(20)
- connectors — varchar(255)
- length_mm — int
- image_filename — varchar(100)
ram
- ram_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- type — varchar(20)
- capacity — int
- speed — int
- sticks — int
- image_filename — varchar(100)
recommendedpc
- pc_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- cpu — varchar(100) — NOT NULL
- motherboard — varchar(100) — NOT NULL
- ram — varchar(100) — NOT NULL
- gpu — varchar(100) — NOT NULL
- psu — varchar(100) — NOT NULL
- case_ — varchar(100) — NOT NULL
- cooler — varchar(100) — NOT NULL
- ssd — varchar(100) — NOT NULL
- total_price — int — NOT NULL
- image_path — varchar(255)
- recommendCategory — int — NOT NULL
ssd
- ssd_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- brand — varchar(50)
- capacity — int
- interface — varchar(20)
- form_factor — varchar(20)
- read_speed — int
- write_speed — int
- image_filename — varchar(100)
users
- id — varchar(20) — Primary key — NOT NULL
- hashed_password — varchar(200) — NOT NULL
- user_name — varchar(16) — NOT NULL
- birthdate — varchar(8) — NOT NULL
- gender — varchar(1) — NOT NULL
- phone — varchar(20) — NOT NULL
- email — varchar(100) — NOT NULL
- address — varchar(200)
- role — varchar(10)
- token_version — int