Analytics Table Schema Diagram

This diagram shows the relationships between the analytics tables based on Foreign Key definitions. Arrows point from the table containing the foreign key field to the table it references.

%3 avg_ex_rate avg_ex_rate dear_customer dear_customer dear_customer_addresses dear_customer_addresses dear_customer->dear_customer_addresses dear_customer_contacts dear_customer_contacts dear_customer->dear_customer_contacts dear_customer_tag dear_customer_tag dear_customer->dear_customer_tag dear_product_custom_prices dear_product_custom_prices dear_customer->dear_product_custom_prices dear_sales_header dear_sales_header dear_customer->dear_sales_header dear_sales_invoice dear_sales_invoice dear_customer->dear_sales_invoice sales_fact sales_fact dear_customer->sales_fact dear_financial_transactions dear_financial_transactions dear_finished_goods_header dear_finished_goods_header dear_location dear_location threepl_stock_analysis threepl_stock_analysis dear_location->threepl_stock_analysis dear_po_header dear_po_header purchase_order_lines purchase_order_lines dear_po_header->purchase_order_lines purchase_order_payments purchase_order_payments dear_po_header->purchase_order_payments purchases_fact purchases_fact dear_po_header->purchases_fact purchases_lines_lifecycle purchases_lines_lifecycle dear_po_header->purchases_lines_lifecycle dear_product dear_product dear_product_availability dear_product_availability dear_product->dear_product_availability dear_product->dear_product_custom_prices dear_product_family dear_product_family dear_product->dear_product_family dear_product_tag dear_product_tag dear_product->dear_product_tag dear_stock_adjustment_lines dear_stock_adjustment_lines dear_product->dear_stock_adjustment_lines dear_stock_transfer_lines dear_stock_transfer_lines dear_product->dear_stock_transfer_lines dear_supplier_product dear_supplier_product dear_product->dear_supplier_product product_movements product_movements dear_product->product_movements dear_product->purchase_order_lines dear_product->purchases_fact dear_product->purchases_lines_lifecycle dear_product->sales_fact sales_lines_lifecycle sales_lines_lifecycle dear_product->sales_lines_lifecycle sales_order_inventory_transactions sales_order_inventory_transactions dear_product->sales_order_inventory_transactions sales_order_lines sales_order_lines dear_product->sales_order_lines sales_shipments sales_shipments dear_product->sales_shipments dear_product->threepl_stock_analysis dear_sales_header->dear_po_header dear_sales_header->dear_sales_invoice dear_sales_header->sales_fact dear_sales_header->sales_lines_lifecycle dear_sales_header->sales_order_inventory_transactions dear_sales_header->sales_order_lines sales_order_payments sales_order_payments dear_sales_header->sales_order_payments dear_sales_header->sales_shipments dear_sales_invoice->sales_fact dear_sales_invoice->sales_shipments dear_stock_adjustment_header dear_stock_adjustment_header dear_stock_adjustment_header->dear_stock_adjustment_lines dear_stock_transfer_header dear_stock_transfer_header dear_stock_transfer_header->dear_stock_transfer_lines dear_supplier dear_supplier dear_supplier->dear_po_header dear_supplier->dear_product dear_supplier->dear_supplier_product dear_supplier->purchases_fact mainfreight_events mainfreight_events shipping_subscriptions shipping_subscriptions shippit_transactions shippit_transactions table_update_status table_update_status

Back to Analytics Index