schema.sql

CREATE TABLE users (
    user_id INT PRIMARY KEY,
    join_date DATE,
    country VARCHAR(50),
    membership_tier VARCHAR(20)
);


CREATE TABLE products (
    product_id INT PRIMARY KEY,
    product_name VARCHAR(100),
    category VARCHAR(50),
    price DECIMAL(10, 2)
);


CREATE TABLE orders (
    order_id INT PRIMARY KEY,
    user_id INT,
    order_date DATE,
    total_amount DECIMAL(10, 2),
    status VARCHAR(20)
);


CREATE TABLE order_items (
    item_id INT PRIMARY KEY,
    order_id INT,
    product_id INT,
    quantity INT,
    price_per_unit DECIMAL(10, 2)
);


CREATE TABLE user_sessions (
    session_id INT PRIMARY KEY,
    user_id INT,
    session_start TIMESTAMP,
    session_end TIMESTAMP,
    page_views INT
);