Description

Table: user_transactions

+------------------+----------+
| Column Name      | Type     |
+------------------+----------+
| transaction_id   | integer  |
| product_id       | integer  |
| spend            | decimal  |
| transaction_date | datetime |
+------------------+----------+

transaction_id is the primary key. Each row represents one purchase transaction.

Table: product_info

+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| product_id   | integer |
| product_name | varchar |
| category     | varchar |
+--------------+---------+

product_id is the primary key. Each row maps a product to its category.