ivy_powerBI_contents

Tables (17)

Customer (Untitled13)

  • Key (id) — Primary key — NOT NULL
  • Field (email)
  • Field (mall_id)

Customer (Untitled7)

  • Key (id) — Primary key — NOT NULL
  • Field (member_id) — varchar

Customer_privacy (Untitled8)

  • Key — Primary key — NOT NULL
  • Field (name)
  • Field (email)
  • Field2 (birthday)
  • Field3 (cellphone)
  • Field (used_points)
  • Field (available_points)
  • Field (created_date)
  • Field (group_no)

DataSourceList (DataSource)

  • Key (id) — int — Primary key — NOT NULL
  • name — char
  • Field2 (description) — varchar
  • Field3 (scheduled) — int
  • Field (scheduled_time) — time
  • Field (options) — json
  • Field (url) — char
  • Field (status) — char
  • Field (prepared_at) — timestamp
  • Field (expired_at) — timestamp
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp
  • Field (deleted_at) — timestamp

Order (Untitled11)

  • Key (id) — Primary key — NOT NULL
  • Field (order_no)
  • Field (mall_id)

Order_buyer (Untitled5)

  • Field (member_name) — char

Order_cancellation (Untitled6)

  • Field (order_id)
  • Field (claim_reason_type)
  • Field (claim_reason)
  • Field (refund_amount)

Order_items (Untitled4)

  • Field (order_id) — varchar
  • Field (order_item_code) — varchar
  • Field (product_price) — float
  • Field (actual_payment_amount)
  • Field (tax_amount)
  • Field (product_no)
  • Field (product_code)
  • Field (custom_variant_code)
  • Field (product_name)
  • Field (product_name_with_option)
  • Field (quantity) — int
  • Field (claim_code)
  • Field (claim_reason)
  • Field (store_pickup)

Orders

  • Key (id) — int — Primary key — NOT NULL
  • Field (shop_no) — int
  • Field (order_id) — char
  • Field2 (order_date)
  • Field (payment_amount)
  • Field (order_price_amount)
  • Field (tax)
  • Field (paid) — int
  • Field (payment_method)
  • Field (payment_date)
  • Field (member_id)
  • Field (member_email) — char
  • Field (payment_amount_initial)
  • Field (shipping_type) — char
  • Field

Product (Untitled9)

  • Key (id) — Primary key — NOT NULL
  • Field (product_no)
  • Field2 (mall_id)

Product_detail (Untitled)

  • PK (id) — int — Primary key — NOT NULL
  • FK (product_id) — int — Foreign key → Product_list.Key — NOT NULL
  • (category_no) — int
  • Field (category_new) — boolean
  • Field (category_recommend) — boolean
  • Field (simple_description) — text
  • Field (has_option) — boolean
  • Field (shipping_info)
  • Field (shipping_method)
  • Field (shipping_area)
  • Field (shipping_period)
  • Field (shipping_fee_type)
  • Field (points_setting_by_payment)

Product_list (Products)

  • Key (id) — int — Primary key — NOT NULL
  • Field (shop_no) — int
  • Field (product_code) — varchar
  • Field (custom_product_code) — char
  • Field (product_name) — char
  • Field (eng_product_name) — char
  • Field (price)
  • Field (retail_price) — float
  • Field (price_excluding_tax) — float
  • Field (supply_price)
  • Field (display) — boolean
  • Field (selling) — int
  • Field (margin_rate) — float
  • Field (summary_description) — text
  • Field (product_tag) — text
  • Field (points_amount)
  • Field (manufacturer_code) — varchar
  • Field (supplier_code) — varchar
  • Field (brand_code)
  • Field (trend_code)
  • Field (classification_code) — char
  • Field (product_material)
  • Field (english_product_material)
  • Field (cloth_fabric)
  • Field (product_weight)
  • Field (hscode)
  • Field (price_content)

Product_option (Untitled2)

  • Key (id) — int — Primary key — NOT NULL
  • Key (product_id) — int — Foreign key → Product_list.Key — NOT NULL
  • Field (option_preset_code)
  • Field (options)

Product_seo (Untitled3)

  • Key (id) — int — Primary key — NOT NULL
  • Key (product_id) — int — Foreign key → Product_list.Key — NOT NULL
  • Field (search_engine_exposure) — boolean
  • Field (meta_title)
  • Field (meta_author)
  • Field (meta_description)
  • Field (meta_keywords)
  • Field (meta_alt)

customer_meta (Untitled14)

  • Key (id) — Primary key — NOT NULL
  • Key (customer_id) — Foreign key → Customer.Key — NOT NULL
  • Field (meta_key)
  • Field (meta_value)

order_meta (Untitled12)

  • Key (id) — Primary key — NOT NULL
  • Key (order_id) — Foreign key → Order.Key — NOT NULL
  • Field (meta_key)
  • (meta_value)

product_meta (Untitled10)

  • Key (id) — Primary key — NOT NULL
  • Key (product_id) — Foreign key → Product.Key — NOT NULL
  • Field (meta_key)
  • Field2 (meta_value)