WHERE IN

▣ categories 8 rows

category_id

PKINT

name

VARCHAR

parent_category_id

FKINT

▣ coupons 8 rows

coupon_id

PKINT

code

VARCHAR

discount_type

VARCHAR

discount_value

DECIMAL

min_order_value

DECIMAL

valid_from

DATE

valid_until

DATE

▣ customers 30 rows

customer_id

PKINT

first_name

VARCHAR

last_name

VARCHAR

email

VARCHAR

phone

VARCHAR

city

VARCHAR

country

VARCHAR

created_at

DATE

▣ employees 10 rows

employee_id

PKINT

first_name

VARCHAR

last_name

VARCHAR

department

VARCHAR

salary

DECIMAL

manager_id

FKINT

hire_date

DATE

▣ order_items 125 rows

order_item_id

PKINT

order_id

FKINT

product_id

FKINT

quantity

INT

unit_price

DECIMAL

▣ orders 80 rows

order_id

PKINT

customer_id

FKINT

order_date

DATE

status

VARCHAR

total_amount

DECIMAL

▣ products 25 rows

product_id

PKINT

name

VARCHAR

category_id

FKINT

price

DECIMAL

cost_price

DECIMAL

stock

INT

created_at

DATE

▣ returns 15 rows

return_id

PKINT

order_item_id

FKINT

return_date

DATE

reason

VARCHAR

refund_amount

DECIMAL

status

VARCHAR

▣ reviews 40 rows

review_id

PKINT

product_id

FKINT

customer_id

FKINT

rating

INT

review_date

DATE