The Schema

14 tables. 1 ugly query. Click any table for details.

Customers
Products
Operations
Audit
customers🔑customer_id🔗enrollment_cafe_id🔗preferred_cafe_idcustomer_codeemailfirst_name+14 moreClick for detailscustomer_addresses🔑address_id🔗customer_idaddress_typeaddress_line1address_line2+6 moreClick for detailscategories🔑category_id🔗parent_category_idcategory_namedescriptiondisplay_order+2 moreClick for detailsproducts🔑product_id🔗category_idproduct_codeproduct_namedescription+8 moreClick for detailssuppliers🔑supplier_idsupplier_codesupplier_namesupplier_type+9 moreClick for detailsproduct_suppliers🔑product_supplier_id🔗product_id🔗supplier_idis_primary_supplierunit_costlead_time_days+2 moreClick for detailscafes🔑cafe_id🔗manager_idcafe_codenameaddress_line1+10 moreClick for detailsemployees🔑employee_id🔗primary_cafe_idemployee_codeemailfirst_name+8 moreClick for detailspromotions🔑promotion_idpromotion_codepromotion_namedescription+9 moreClick for detailsorders🔑order_id🔗cafe_id🔗customer_id🔗employee_idorder_numberorder_dateorder_type+8 moreClick for detailsorder_items🔑order_item_id🔗order_id🔗product_idquantityunit_priceline_total+3 moreClick for detailsorder_discounts🔑order_discount_id🔗order_id🔗promotion_iddiscount_amountapplied_atClick for detailsinventory🔑inventory_id🔗cafe_id🔗product_idquantity_on_handunit_of_measurereorder_point+2 moreClick for detailsinventory_transactions🔑transaction_id🔗cafe_id🔗product_id🔗performed_bytransaction_typequantity_changetransaction_date+4 moreClick for details
Total Tables: 14
Total Relationships: 21
Total Columns: 161
Continue to The Query