herb
Tables (14)
addresses
- address_id — BIGINT
- customer_id — BIGINT
- recipient_name — VARCHAR(100)
- phone — VARCHAR(30)
- line1 — VARCHAR(255)
- postal_code — VARCHAR(20)
cart_items
- cart_item_id — BIGINT
- cart_id — BIGINT
- option_id — BIGINT
- quantity — INT
carts
- cart_id — BIGINT
- customer_id — BIGINT
- session_key — VARCHAR(120)
- expires_at — DATETIME
categories
- category_id — BIGINT
- parent_id — BIGINT
- name — VARCHAR(100)
- sort_order — INT
- is_active — TINYINT
customers
- customer_id — BIGINT
- email — VARCHAR(255)
- name — VARCHAR(100)
inventory
- inventory_id — BIGINT
- option_id — BIGINT
- stock_qty — INT
- safety_stock — INT
- restock_eta — DATETIME
order_items
- order_item_id — BIGINT
- order_id — BIGINT
- option_id — BIGINT
- unit_price — DECIMAL(12,2)
- quantity — INT
- line_amount — DECIMAL(12,2)
orders
- order_id — BIGINT
- customer_id — BIGINT
- shipping_address_id — BIGINT
- total_amount — DECIMAL(12,2)
- ordered_at — DATETIME
payments
- payment_id — BIGINT
- order_id — BIGINT
- method — VARCHAR(30)
- amount — DECIMAL(12,2)
- status — VARCHAR(20)
- paid_at — DATETIME
product_category
- product_id — BIGINT
- category_id — BIGINT
product_images
- image_id — BIGINT
- product_id — BIGINT
- image_url — VARCHAR(500)
- is_main — TINYINT
- sort_order — INT
product_options
- option_id — BIGINT
- product_id — BIGINT
- option_name — VARCHAR(100)
- sale_price — DECIMAL(12,2)
- is_active — TINYINT
products
- product_id — BIGINT
- name — VARCHAR(200)
- manufacturer — VARCHAR(200)
- sku — VARCHAR(100)
- upc — VARCHAR(100)
- image_url — VARCHAR(500)
- start_selling_at — DATETIME
reviews
- review_id — BIGINT
- customer_id — BIGINT
- product_id — BIGINT
- rating — TINYINT
- content — TEXT
- created_at — DATETIME