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)