Tables


Infigo Insights Reporting Schema

Generated on Tue Feb 27 15:28 EET 2024

TABLES 36
VIEWS 0
COLUMNS 329
Constraints 65
Anomalies 3
Routines 0

Database Properties

Database Type: PostgreSQL - 16.1

Tables

Table / View Children Parents Columns Rows Type Comments
product_download 0 2 9 -1 Table
attribute_combination 2 1 10 -1 Table
customer_role 1 0 10 -1 Table
order 4 8 39 -1 Table
customer_customer_role_mapping 0 2 3 -1 Table
department_shipping_method_mapping 0 1 3 -1 Table
mis_plugin_mapping 0 1 6 -1 Table
category 2 2 9 -1 Table
product 6 1 21 -1 Table
storefront 10 0 12 -1 Table
customer 12 4 26 -1 Table
customer_address_mapping 0 2 3 -1 Table
mis_plugin 1 1 4 -1 Table
customer_attributes_mapping 0 3 6 -1 Table
budget_usage_history 0 2 6 -1 Table
product_specification_attribute_mapping 0 3 6 -1 Table
orderline_approver_history 0 2 6 -1 Table
attribute_attributecombination_mapping 0 3 4 -1 Table
customer_login_history 0 1 6 -1 Table
order_discount 1 1 10 -1 Table
num_values 0 0 2 -1 Table
budget 1 2 10 -1 Table
orderline_attribute_mapping 0 3 4 -1 Table
attribute_value 6 0 2 -1 Table
orderline 3 4 29 -1 Table
department 4 1 10 -1 Table
customer_relationship_mapping 0 2 6 -1 Table
attribute_name 6 0 3 -1 Table
reward_points_history 0 2 10 -1 Table
product_attribute_mapping 0 3 7 -1 Table
delivery_method 1 0 9 -1 Table
address 5 1 19 -1 Table
product_category_mapping 0 2 5 -1 Table
department_payment_method_mapping 0 1 3 -1 Table
order_checkout_attribute_mapping 0 3 4 -1 Table
orderline_status_history 0 1 7 -1 Table