Database Fields for a Computer Game Shop — Core Schema

Core tables and fields:

Games

game_id (PK), game_name, platform, genre, developer, publisher, release_date, description, rating (ESRB/PEGI), price, stock_quantity, image_url, game_url

Customers

customer_id (PK), first_name, last_name, email, password_hash, phone, address, membership_level

Orders

order_id (PK), customer_id (FK), order_date, total_price, order_status, payment_method

Order_Items

order_item_id (PK), order_id (FK), game_id (FK), quantity, item_price

Reviews

review_id (PK), game_id (FK), customer_id (FK), rating, review_text, review_date

Employees

employee_id (PK), first_name, last_name, email, phone, job_title, department

Inventory

inventory_id (PK), game_id (FK), quantity, warehouse_location

Extensions: Sales analytics, promotions/discounts, user accounts, marketing campaigns.