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