CREATE TABLE IF NOT EXISTS items (
    id VARCHAR(128) PRIMARY KEY,
    product_name VARCHAR(256) NOT NULL,
    brands VARCHAR(256) NOT NULL,
    quantity VARCHAR(64) NOT NULL,
    categories VARCHAR(256) NOT NULL,
    description TEXT NOT NULL,
    ingredients_text TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS reviews (
    id VARCHAR(128) PRIMARY KEY,
    item_id VARCHAR(128) NOT NULL REFERENCES items(id),
    rating INTEGER NOT NULL,
    comment TEXT NOT NULL
);

CREATE INDEX IF NOT EXISTS idx_reviews_item_id ON reviews(item_id);