-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdata.local.json.js
1 lines (1 loc) · 249 KB
/
data.local.json.js
1
window.repository = {"title": "Northwind","license": "Enterprise","license_expires_at": null,"exported_at": "2024-02-29 22:14","structure": [{"id": "d7","object_id": "d7","type": "documentation","name": "Northwind","subtype": null,"is_user_defined": false,"children": [{"id": "d7m","object_id": "d7m","type": "modules","name": "Modules","subtype": null,"is_user_defined": false,"children": [{"id": "m107","object_id": "m107","type": "module","name": "Diagram","subtype": null,"is_user_defined": true,"children": [{"id": "m107t","object_id": "m107t","type": "module_tables","name": "Tables","subtype": null,"is_user_defined": false,"children": [{"id": "m107t3719","object_id": "t3719","type": "module_table","name": "Categories","subtype": "TABLE","is_user_defined": false,"columns": ["CategoryID","CategoryName","Description","Picture"],},{"id": "m107t3720","object_id": "t3720","type": "module_table","name": "CustomerCustomerDemo","subtype": "TABLE","is_user_defined": false,"columns": ["CustomerID","CustomerTypeID"],},{"id": "m107t3721","object_id": "t3721","type": "module_table","name": "CustomerDemographics","subtype": "TABLE","is_user_defined": false,"columns": ["CustomerTypeID","CustomerDesc"],},{"id": "m107t3722","object_id": "t3722","type": "module_table","name": "Customers","subtype": "TABLE","is_user_defined": false,"columns": ["CustomerID","CompanyName","ContactName","ContactTitle","Address","City","Region","PostalCode","Country","Phone","Fax"],},{"id": "m107t3724","object_id": "t3724","type": "module_table","name": "Employees","subtype": "TABLE","is_user_defined": false,"columns": ["EmployeeID","LastName","FirstName","Title","TitleOfCourtesy","BirthDate","HireDate","Address","City","Region","PostalCode","Country","HomePhone","Extension","Photo","Notes","ReportsTo","PhotoPath","dinid"],},{"id": "m107t3725","object_id": "t3725","type": "module_table","name": "EmployeeTerritories","subtype": "TABLE","is_user_defined": false,"columns": ["EmployeeID","TerritoryID"],},{"id": "m107t3726","object_id": "t3726","type": "module_table","name": "Order Details","subtype": "TABLE","is_user_defined": false,"columns": ["OrderID","ProductID","UnitPrice","Quantity","Discount"],},{"id": "m107t3727","object_id": "t3727","type": "module_table","name": "Orders","subtype": "TABLE","is_user_defined": false,"columns": ["OrderID","CustomerID","EmployeeID","OrderDate","RequiredDate","ShippedDate","ShipVia","Freight","ShipName","ShipAddress","ShipCity","ShipRegion","ShipPostalCode","ShipCountry"],},{"id": "m107t3728","object_id": "t3728","type": "module_table","name": "Products","subtype": "TABLE","is_user_defined": false,"columns": ["ProductID","ProductName","SupplierID","CategoryID","QuantityPerUnit","UnitPrice","UnitsInStock","UnitsOnOrder","ReorderLevel","Discontinued"],},{"id": "m107t3729","object_id": "t3729","type": "module_table","name": "Region","subtype": "TABLE","is_user_defined": false,"columns": ["RegionID","RegionDescription"],},{"id": "m107t3730","object_id": "t3730","type": "module_table","name": "Shippers","subtype": "TABLE","is_user_defined": false,"columns": ["ShipperID","CompanyName","Phone"],},{"id": "m107t3731","object_id": "t3731","type": "module_table","name": "Suppliers","subtype": "TABLE","is_user_defined": false,"columns": ["SupplierID","CompanyName","ContactName","ContactTitle","Address","City","Region","PostalCode","Country","Phone","Fax","HomePage"],},{"id": "m107t3732","object_id": "t3732","type": "module_table","name": "Territories","subtype": "TABLE","is_user_defined": false,"columns": ["TerritoryID","TerritoryDescription","RegionID"],},]},{"id": "m107v","object_id": "m107v","type": "module_views","name": "Views","subtype": null,"is_user_defined": false,"children": [{"id": "m107v3746","object_id": "v3746","type": "module_view","name": "Sales Totals by Amount","subtype": "VIEW","is_user_defined": false,"columns": ["SaleAmount","OrderID","CompanyName","ShippedDate"],},{"id": "m107v3747","object_id": "v3747","type": "module_view","name": "Summary of Sales by Quarter","subtype": "VIEW","is_user_defined": false,"columns": ["ShippedDate","OrderID","Subtotal"],},{"id": "m107v3748","object_id": "v3748","type": "module_view","name": "Summary of Sales by Year","subtype": "VIEW","is_user_defined": false,"columns": ["ShippedDate","OrderID","Subtotal"],},{"id": "m107v3749","object_id": "v3749","type": "module_view","name": "topfiveproducts","subtype": "VIEW","is_user_defined": false,"columns": ["ProductID","ProductName","UnitPrice"],},{"id": "m107v3750","object_id": "v3750","type": "module_view","name": "toptenproducts","subtype": "VIEW","is_user_defined": false,"columns": ["ProductID","ProductName","UnitPrice","vat"],},]},]},]},{"id": "d7t","object_id": "d7t","type": "tables","name": "Tables","subtype": null,"is_user_defined": false,"children": [{"id": "t3719","object_id": "t3719","type": "table","name": "Categories","subtype": "TABLE","is_user_defined": false,"columns": ["CategoryID","CategoryName","Description","Picture"],},{"id": "t3720","object_id": "t3720","type": "table","name": "CustomerCustomerDemo","subtype": "TABLE","is_user_defined": false,"columns": ["CustomerID","CustomerTypeID"],},{"id": "t3721","object_id": "t3721","type": "table","name": "CustomerDemographics","subtype": "TABLE","is_user_defined": false,"columns": ["CustomerTypeID","CustomerDesc"],},{"id": "t3722","object_id": "t3722","type": "table","name": "Customers","subtype": "TABLE","is_user_defined": false,"columns": ["CustomerID","CompanyName","ContactName","ContactTitle","Address","City","Region","PostalCode","Country","Phone","Fax"],},{"id": "t3723","object_id": "t3723","type": "table","name": "Device","subtype": "TABLE","is_user_defined": false,"columns": ["ID","Data","ProductionDateTime"],},{"id": "t3724","object_id": "t3724","type": "table","name": "Employees","subtype": "TABLE","is_user_defined": false,"columns": ["EmployeeID","LastName","FirstName","Title","TitleOfCourtesy","BirthDate","HireDate","Address","City","Region","PostalCode","Country","HomePhone","Extension","Photo","Notes","ReportsTo","PhotoPath","dinid"],},{"id": "t3725","object_id": "t3725","type": "table","name": "EmployeeTerritories","subtype": "TABLE","is_user_defined": false,"columns": ["EmployeeID","TerritoryID"],},{"id": "t3726","object_id": "t3726","type": "table","name": "Order Details","subtype": "TABLE","is_user_defined": false,"columns": ["OrderID","ProductID","UnitPrice","Quantity","Discount"],},{"id": "t3727","object_id": "t3727","type": "table","name": "Orders","subtype": "TABLE","is_user_defined": false,"columns": ["OrderID","CustomerID","EmployeeID","OrderDate","RequiredDate","ShippedDate","ShipVia","Freight","ShipName","ShipAddress","ShipCity","ShipRegion","ShipPostalCode","ShipCountry"],},{"id": "t3728","object_id": "t3728","type": "table","name": "Products","subtype": "TABLE","is_user_defined": false,"columns": ["ProductID","ProductName","SupplierID","CategoryID","QuantityPerUnit","UnitPrice","UnitsInStock","UnitsOnOrder","ReorderLevel","Discontinued"],},{"id": "t3729","object_id": "t3729","type": "table","name": "Region","subtype": "TABLE","is_user_defined": false,"columns": ["RegionID","RegionDescription"],},{"id": "t3730","object_id": "t3730","type": "table","name": "Shippers","subtype": "TABLE","is_user_defined": false,"columns": ["ShipperID","CompanyName","Phone"],},{"id": "t3731","object_id": "t3731","type": "table","name": "Suppliers","subtype": "TABLE","is_user_defined": false,"columns": ["SupplierID","CompanyName","ContactName","ContactTitle","Address","City","Region","PostalCode","Country","Phone","Fax","HomePage"],},{"id": "t3732","object_id": "t3732","type": "table","name": "Territories","subtype": "TABLE","is_user_defined": false,"columns": ["TerritoryID","TerritoryDescription","RegionID"],},]},{"id": "d7v","object_id": "d7v","type": "views","name": "Views","subtype": null,"is_user_defined": false,"children": [{"id": "v3733","object_id": "v3733","type": "view","name": "Alphabetical list of products","subtype": "VIEW","is_user_defined": false,"columns": ["ProductID","ProductName","SupplierID","CategoryID","QuantityPerUnit","UnitPrice","UnitsInStock","UnitsOnOrder","ReorderLevel","Discontinued","CategoryName"],},{"id": "v3734","object_id": "v3734","type": "view","name": "Category Sales for 1997","subtype": "VIEW","is_user_defined": false,"columns": ["CategoryName","CategorySales"],},{"id": "v3735","object_id": "v3735","type": "view","name": "Current Product List","subtype": "VIEW","is_user_defined": false,"columns": ["ProductID","ProductName"],},{"id": "v3736","object_id": "v3736","type": "view","name": "Customer and Suppliers by City","subtype": "VIEW","is_user_defined": false,"columns": ["City","CompanyName","ContactName","Relationship"],},{"id": "v3737","object_id": "v3737","type": "view","name": "Invoices","subtype": "VIEW","is_user_defined": false,"columns": ["ShipName","ShipAddress","ShipCity","ShipRegion","ShipPostalCode","ShipCountry","CustomerID","CustomerName","Address","City","Region","PostalCode","Country","Salesperson","OrderID","OrderDate","RequiredDate","ShippedDate","ShipperName","ProductID","ProductName","UnitPrice","Quantity","Discount","ExtendedPrice","Freight"],},{"id": "v3738","object_id": "v3738","type": "view","name": "Order Details Extended","subtype": "VIEW","is_user_defined": false,"columns": ["OrderID","ProductID","ProductName","UnitPrice","Quantity","Discount","ExtendedPrice"],},{"id": "v3739","object_id": "v3739","type": "view","name": "Order Subtotals","subtype": "VIEW","is_user_defined": false,"columns": ["OrderID","Subtotal"],},{"id": "v3740","object_id": "v3740","type": "view","name": "Orders Qry","subtype": "VIEW","is_user_defined": false,"columns": ["OrderID","CustomerID","EmployeeID","OrderDate","RequiredDate","ShippedDate","ShipVia","Freight","ShipName","ShipAddress","ShipCity","ShipRegion","ShipPostalCode","ShipCountry","CompanyName","Address","City","Region","PostalCode","Country"],},{"id": "v3741","object_id": "v3741","type": "view","name": "Product Sales for 1997","subtype": "VIEW","is_user_defined": false,"columns": ["CategoryName","ProductName","ProductSales"],},{"id": "v3742","object_id": "v3742","type": "view","name": "Products Above Average Price","subtype": "VIEW","is_user_defined": false,"columns": ["ProductName","UnitPrice"],},{"id": "v3743","object_id": "v3743","type": "view","name": "Products by Category","subtype": "VIEW","is_user_defined": false,"columns": ["CategoryName","ProductName","QuantityPerUnit","UnitsInStock","Discontinued"],},{"id": "v3744","object_id": "v3744","type": "view","name": "Quarterly Orders","subtype": "VIEW","is_user_defined": false,"columns": ["CustomerID","CompanyName","City","Country"],},{"id": "v3745","object_id": "v3745","type": "view","name": "Sales by Category","subtype": "VIEW","is_user_defined": false,"columns": ["CategoryID","CategoryName","ProductName","ProductSales"],},{"id": "v3746","object_id": "v3746","type": "view","name": "Sales Totals by Amount","subtype": "VIEW","is_user_defined": false,"columns": ["SaleAmount","OrderID","CompanyName","ShippedDate"],},{"id": "v3747","object_id": "v3747","type": "view","name": "Summary of Sales by Quarter","subtype": "VIEW","is_user_defined": false,"columns": ["ShippedDate","OrderID","Subtotal"],},{"id": "v3748","object_id": "v3748","type": "view","name": "Summary of Sales by Year","subtype": "VIEW","is_user_defined": false,"columns": ["ShippedDate","OrderID","Subtotal"],},{"id": "v3749","object_id": "v3749","type": "view","name": "topfiveproducts","subtype": "VIEW","is_user_defined": false,"columns": ["ProductID","ProductName","UnitPrice"],},{"id": "v3750","object_id": "v3750","type": "view","name": "toptenproducts","subtype": "VIEW","is_user_defined": false,"columns": ["ProductID","ProductName","UnitPrice","vat"],},]},{"id": "d7p","object_id": "d7p","type": "procedures","name": "Procedures","subtype": null,"is_user_defined": false,"children": [{"id": "p135","object_id": "p135","type": "procedure","name": "CustOrderHist","subtype": "PROCEDURE","is_user_defined": false,},{"id": "p136","object_id": "p136","type": "procedure","name": "CustOrdersDetail","subtype": "PROCEDURE","is_user_defined": false,},{"id": "p137","object_id": "p137","type": "procedure","name": "CustOrdersOrders","subtype": "PROCEDURE","is_user_defined": false,},{"id": "p138","object_id": "p138","type": "procedure","name": "Employee Sales by Country","subtype": "PROCEDURE","is_user_defined": false,},{"id": "p139","object_id": "p139","type": "procedure","name": "Sales by Year","subtype": "PROCEDURE","is_user_defined": false,},{"id": "p140","object_id": "p140","type": "procedure","name": "SalesByCategory","subtype": "PROCEDURE","is_user_defined": false,},{"id": "p141","object_id": "p141","type": "procedure","name": "Ten Most Expensive Products","subtype": "PROCEDURE","is_user_defined": false,},]},{"id": "d7f","object_id": "d7f","type": "functions","name": "Functions","subtype": null,"is_user_defined": false,"children": [{"id": "f132","object_id": "f132","type": "function","name": "fn_calcvat","subtype": "FUNCTION","is_user_defined": false,},{"id": "f133","object_id": "f133","type": "function","name": "Fn_ParseJson","subtype": "FUNCTION","is_user_defined": false,},{"id": "f134","object_id": "f134","type": "function","name": "GetQueryResultByTimeRange","subtype": "FUNCTION","is_user_defined": false,},]},]},],"objects": {"d7": {"object_id":"d7","name":"Northwind","description":"<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n\t<head>\r\n\t\t<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /><title>\r\n\t\t</title>\r\n\t\t<style type=\"text/css\">\r\n\t\t\t.cs2A4A7CB2{text-align:center;text-indent:0pt;margin:0pt 0pt 0pt 0pt}\r\n\t\t\t.cs2C352F92{color:#000000;background-color:transparent;font-family:Sahel;font-size:12pt;font-weight:bold;font-style:normal;}\r\n\t\t\t.cs50E0ECAE{color:#000000;background-color:transparent;font-family:Sahel;font-size:12pt;font-weight:normal;font-style:normal;}\r\n\t\t\t.cs2654AE3A{text-align:left;text-indent:0pt;margin:0pt 0pt 0pt 0pt}\r\n\t\t\t.cs9B4B2C30{color:#000000;background-color:transparent;font-family:Sahel;font-size:10pt;font-weight:normal;font-style:normal;}\r\n\t\t</style>\r\n\t</head>\r\n\t<body>\r\n\t\t<p class=\"cs2A4A7CB2\"><span class=\"cs2C352F92\">داده های آموزشی کلاس کاریار</span></p><p class=\"cs2A4A7CB2\"><span class=\"cs50E0ECAE\"> </span></p><p class=\"cs2A4A7CB2\"><span class=\"cs50E0ECAE\">داده های Northwind</span></p><p class=\"cs2A4A7CB2\"><span class=\"cs50E0ECAE\"> </span></p><p class=\"cs2654AE3A\"><span class=\"cs9B4B2C30\"> </span></p></body>\r\n</html>\r\n","summary":[{"field":"Host","value":"MOSTAFA\\MSSQL2019"},{"field":"Database","value":"Northwind"},{"field":"DBMS","value":"SQL Server"}],"modules":[{"id":"m107","name":"Diagram"}],"dbObjects":[{"count":14,"id":"d7t","name":"Tables"},{"count":18,"id":"d7v","name":"Views"},{"count":7,"id":"d7p","name":"Procedures"},{"count":3,"id":"d7f","name":"Functions"}],"show_schema":false},"d7m": {"custom_fields":[],"modules":[{"id":"m107","name":"Diagram","type":"MODULE","is_user_defined":true,"custom_fields":{}}],"object_id":"d7m"},"d7t": {"title_prefix":null,"custom_fields":[],"tables":[{"id":"t3719","name":"Categories","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3720","name":"CustomerCustomerDemo","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3721","name":"CustomerDemographics","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3722","name":"Customers","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3723","name":"Device","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3724","name":"Employees","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3725","name":"EmployeeTerritories","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3726","name":"Order Details","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3727","name":"Orders","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3728","name":"Products","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3729","name":"Region","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3730","name":"Shippers","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3731","name":"Suppliers","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"t3732","name":"Territories","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}}],"object_id":"d7t"},"d7v": {"title_prefix":null,"custom_fields":[],"views":[{"id":"v3733","name":"Alphabetical list of products","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3734","name":"Category Sales for 1997","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3735","name":"Current Product List","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3736","name":"Customer and Suppliers by City","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3737","name":"Invoices","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3738","name":"Order Details Extended","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3739","name":"Order Subtotals","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3740","name":"Orders Qry","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3741","name":"Product Sales for 1997","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3742","name":"Products Above Average Price","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3743","name":"Products by Category","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3744","name":"Quarterly Orders","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3745","name":"Sales by Category","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3746","name":"Sales Totals by Amount","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3747","name":"Summary of Sales by Quarter","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3748","name":"Summary of Sales by Year","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3749","name":"topfiveproducts","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"v3750","name":"toptenproducts","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}}],"object_id":"d7v"},"m107": {"tables_custom_fields":[],"tables":[{"id":"m107t3719","name":"Categories","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3720","name":"CustomerCustomerDemo","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3721","name":"CustomerDemographics","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3722","name":"Customers","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3724","name":"Employees","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3725","name":"EmployeeTerritories","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3726","name":"Order Details","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3727","name":"Orders","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3728","name":"Products","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3729","name":"Region","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3730","name":"Shippers","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3731","name":"Suppliers","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3732","name":"Territories","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}}],"views_custom_fields":[],"views":[{"id":"m107v3746","name":"Sales Totals by Amount","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107v3747","name":"Summary of Sales by Quarter","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107v3748","name":"Summary of Sales by Year","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107v3749","name":"topfiveproducts","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107v3750","name":"toptenproducts","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}}],"procedures_custom_fields":[],"procedures":[],"functions_custom_fields":[],"functions":[],"structures_custom_fields":[],"structures":[],"object_id":"m107","name":"Diagram","description":null,"summary":[],"erd":"<svg version=\"1.1\" xmlns=\"http://www.w3.org/2000/svg\" xmlns:xlink=\"http://www.w3.org/1999/xlink\" width=\"950\" height=\"2962\" class=\"erd\"><defs><mask id=\"node-text-mask-3719\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3721\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3724\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3732\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3730\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3729\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3722\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3725\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3726\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3731\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3727\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3720\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3728\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3746\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3747\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3748\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3749\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask><mask id=\"node-text-mask-3750\"><rect x=\"17\" y=\"7\" width=\"198\" height=\"10\" fill=\"#ffffff\" /></mask></defs><g transform=\"translate(8,-33)\"><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"17, 172 -3, 172 -3, 206 17, 206\" /><polyline data-msg=\"Employees.ReportsTo = Employees.EmployeeID\" data-relation=\"\" data-relation-pk-table-id=\"3724\" data-relation-fk-table-id=\"3724\" data-relation-pk-column-ids=\"34356\" data-relation-fk-column-ids=\"34349\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"17, 172 -3, 172 -3, 206 17, 206\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"17, 201 7, 206 17, 211\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"237, 189 257, 189 270, 189 290, 189\" /><polyline data-msg=\"Orders.EmployeeID = Employees.EmployeeID\" data-relation=\"\" data-relation-pk-table-id=\"3724\" data-relation-fk-table-id=\"3727\" data-relation-pk-column-ids=\"34356\" data-relation-fk-column-ids=\"34366\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"237, 189 257, 189 270, 189 290, 189\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"290, 184 280, 189 290, 194\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"127, 224 127, 244 127, 245 127, 265\" /><polyline data-msg=\"EmployeeTerritories.EmployeeID = Employees.EmployeeID\" data-relation=\"\" data-relation-pk-table-id=\"3724\" data-relation-fk-table-id=\"3725\" data-relation-pk-column-ids=\"34356\" data-relation-fk-column-ids=\"34357\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"127, 224 127, 244 127, 245 127, 265\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"122, 265 127, 255 132, 265\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"563, 481 543, 481 530, 481 510, 481\" /><polyline data-msg=\"Products.CategoryID = Categories.CategoryID\" data-relation=\"\" data-relation-pk-table-id=\"3719\" data-relation-fk-table-id=\"3728\" data-relation-pk-column-ids=\"34316\" data-relation-fk-column-ids=\"34381\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"563, 481 543, 481 530, 481 510, 481\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"510, 476 520, 481 510, 486\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"564, 187 544, 187 530, 189 510, 189\" /><polyline data-msg=\"Orders.CustomerID = Customers.CustomerID\" data-relation=\"\" data-relation-pk-table-id=\"3722\" data-relation-fk-table-id=\"3727\" data-relation-pk-column-ids=\"34324\" data-relation-fk-column-ids=\"34365\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"564, 187 544, 187 530, 189 510, 189\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"510, 184 520, 189 510, 194\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"564, 213 544, 213 544, 289 564, 289\" /><polyline data-msg=\"CustomerCustomerDemo.CustomerID = Customers.CustomerID\" data-relation=\"\" data-relation-pk-table-id=\"3722\" data-relation-fk-table-id=\"3720\" data-relation-pk-column-ids=\"34324\" data-relation-fk-column-ids=\"34320\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"564, 213 544, 213 544, 289 564, 289\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"564, 284 554, 289 564, 294\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"400, 92 400, 112 400, 118 400, 138\" /><polyline data-msg=\"Orders.ShipVia = Shippers.ShipperID\" data-relation=\"\" data-relation-pk-table-id=\"3730\" data-relation-fk-table-id=\"3727\" data-relation-pk-column-ids=\"34390\" data-relation-fk-column-ids=\"34370\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"400, 92 400, 112 400, 118 400, 138\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"395, 138 400, 128 405, 138\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"400, 585 400, 565 400, 544 400, 524\" /><polyline data-msg=\"Products.SupplierID = Suppliers.SupplierID\" data-relation=\"\" data-relation-pk-table-id=\"3731\" data-relation-fk-table-id=\"3728\" data-relation-pk-column-ids=\"34393\" data-relation-fk-column-ids=\"34380\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"400, 585 400, 565 400, 544 400, 524\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"395, 524 400, 534 405, 524\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"400, 240 400, 260 400, 268 400, 288\" /><polyline data-msg=\"Order Details.OrderID = Orders.OrderID\" data-relation=\"\" data-relation-pk-table-id=\"3727\" data-relation-fk-table-id=\"3726\" data-relation-pk-column-ids=\"34364\" data-relation-fk-column-ids=\"34359\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"400, 240 400, 260 400, 268 400, 288\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"395, 288 400, 278 405, 288\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"400, 438 400, 418 400, 378 400, 358\" /><polyline data-msg=\"Order Details.ProductID = Products.ProductID\" data-relation=\"\" data-relation-pk-table-id=\"3728\" data-relation-fk-table-id=\"3726\" data-relation-pk-column-ids=\"34378\" data-relation-fk-column-ids=\"34360\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"400, 438 400, 418 400, 378 400, 358\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"395, 358 400, 368 405, 358\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"783, 377 803, 377 804, 289 784, 289\" /><polyline data-msg=\"CustomerCustomerDemo.CustomerTypeID = CustomerDemographics.CustomerTypeID\" data-relation=\"\" data-relation-pk-table-id=\"3721\" data-relation-fk-table-id=\"3720\" data-relation-pk-column-ids=\"34322\" data-relation-fk-column-ids=\"34321\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"783, 377 803, 377 804, 289 784, 289\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"784, 284 794, 289 784, 294\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"127, 510 127, 490 127, 478 127, 458\" /><polyline data-msg=\"Territories.RegionID = Region.RegionID\" data-relation=\"\" data-relation-pk-table-id=\"3729\" data-relation-fk-table-id=\"3732\" data-relation-pk-column-ids=\"34388\" data-relation-fk-column-ids=\"34407\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"127, 510 127, 490 127, 478 127, 458\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"122, 458 127, 468 132, 458\" /></g><g><polyline stroke=\"#757575\" fill=\"transparent\" points=\"127, 388 127, 368 127, 355 127, 335\" /><polyline data-msg=\"EmployeeTerritories.TerritoryID = Territories.TerritoryID\" data-relation=\"\" data-relation-pk-table-id=\"3732\" data-relation-fk-table-id=\"3725\" data-relation-pk-column-ids=\"34405\" data-relation-fk-column-ids=\"34358\" stroke=\"transparent\" stroke-width=\"10\" fill=\"transparent\" points=\"127, 388 127, 368 127, 355 127, 335\" /><polyline stroke=\"#757575\" fill=\"transparent\" points=\"122, 335 127, 345 132, 335\" /></g><g data-table=\"\" data-table-id=\"3719\" href=\"t3719\" data-target=\"#right\" class=\"node\" transform=\"translate(563,454)\" data-msg=\"<div>Categories</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"30\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34316\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">CategoryID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">CategoryID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Categories</p></div></foreignObject><text mask=\"url('#node-text-mask-3719')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Categories</text></switch></g><g data-table=\"\" data-table-id=\"3721\" href=\"t3721\" data-target=\"#right\" class=\"node\" transform=\"translate(563,350)\" data-msg=\"<div>CustomerDemographics</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"30\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34322\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">CustomerTypeID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">CustomerTypeID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">CustomerDemographics</p></div></foreignObject><text mask=\"url('#node-text-mask-3721')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">CustomerDemographics</text></switch></g><g data-table=\"\" data-table-id=\"3724\" href=\"t3724\" data-target=\"#right\" class=\"node\" transform=\"translate(17,154)\" data-msg=\"<div>Employees</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"46\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34356\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">EmployeeID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">EmployeeID</text></switch></g><g data-column=\"\" data-column-id=\"34349\"><image x=\"4\" y=\"23\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvwAADr8BOAVTJAAAAINJREFUOE+tzLENgCAUBFDXYEZHsGAEKwoSCgagoqFiNg0mRzQcfogWr+Bzd4tS6hN6nEGPM+hxhNb6KOinBOUQwkoDb1COMW7lTUM9KKeULG5NqAflnHMtF01g1n8DEhS89/v9/ghJMOKcqyNNSIIRa+01QkMSjBhjdhoYgRH6OU4tJ359xeEtkbt0AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"20\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">ReportsTo</p></div></foreignObject><text x=\"17\" y=\"28\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">ReportsTo</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Employees</p></div></foreignObject><text mask=\"url('#node-text-mask-3724')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Employees</text></switch></g><g data-table=\"\" data-table-id=\"3732\" href=\"t3732\" data-target=\"#right\" class=\"node\" transform=\"translate(17,388)\" data-msg=\"<div>Territories</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"46\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34405\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">TerritoryID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">TerritoryID</text></switch></g><g data-column=\"\" data-column-id=\"34407\"><image x=\"4\" y=\"23\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvwAADr8BOAVTJAAAAINJREFUOE+tzLENgCAUBFDXYEZHsGAEKwoSCgagoqFiNg0mRzQcfogWr+Bzd4tS6hN6nEGPM+hxhNb6KOinBOUQwkoDb1COMW7lTUM9KKeULG5NqAflnHMtF01g1n8DEhS89/v9/ghJMOKcqyNNSIIRa+01QkMSjBhjdhoYgRH6OU4tJ359xeEtkbt0AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"20\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">RegionID</p></div></foreignObject><text x=\"17\" y=\"28\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">RegionID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Territories</p></div></foreignObject><text mask=\"url('#node-text-mask-3732')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Territories</text></switch></g><g data-table=\"\" data-table-id=\"3730\" href=\"t3730\" data-target=\"#right\" class=\"node\" transform=\"translate(290,38)\" data-msg=\"<div>Shippers</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"30\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34390\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">ShipperID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">ShipperID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Shippers</p></div></foreignObject><text mask=\"url('#node-text-mask-3730')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Shippers</text></switch></g><g data-table=\"\" data-table-id=\"3729\" href=\"t3729\" data-target=\"#right\" class=\"node\" transform=\"translate(17,510)\" data-msg=\"<div>Region</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"30\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34388\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">RegionID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">RegionID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Region</p></div></foreignObject><text mask=\"url('#node-text-mask-3729')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Region</text></switch></g><g data-table=\"\" data-table-id=\"3722\" href=\"t3722\" data-target=\"#right\" class=\"node\" transform=\"translate(564,173)\" data-msg=\"<div>Customers</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"30\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34324\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">CustomerID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">CustomerID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Customers</p></div></foreignObject><text mask=\"url('#node-text-mask-3722')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Customers</text></switch></g><g data-table=\"\" data-table-id=\"3725\" href=\"t3725\" data-target=\"#right\" class=\"node\" transform=\"translate(17,265)\" data-msg=\"<div>EmployeeTerritories</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"46\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34357\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">EmployeeID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">EmployeeID</text></switch></g><g data-column=\"\" data-column-id=\"34358\"><image x=\"4\" y=\"23\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"20\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">TerritoryID</p></div></foreignObject><text x=\"17\" y=\"28\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">TerritoryID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">EmployeeTerritories</p></div></foreignObject><text mask=\"url('#node-text-mask-3725')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">EmployeeTerritories</text></switch></g><g data-table=\"\" data-table-id=\"3726\" href=\"t3726\" data-target=\"#right\" class=\"node\" transform=\"translate(290,288)\" data-msg=\"<div>Order Details</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"46\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34359\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">OrderID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">OrderID</text></switch></g><g data-column=\"\" data-column-id=\"34360\"><image x=\"4\" y=\"23\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"20\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">ProductID</p></div></foreignObject><text x=\"17\" y=\"28\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">ProductID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Order Details</p></div></foreignObject><text mask=\"url('#node-text-mask-3726')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Order Details</text></switch></g><g data-table=\"\" data-table-id=\"3731\" href=\"t3731\" data-target=\"#right\" class=\"node\" transform=\"translate(290,585)\" data-msg=\"<div>Suppliers</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"30\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34393\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">SupplierID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">SupplierID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Suppliers</p></div></foreignObject><text mask=\"url('#node-text-mask-3731')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Suppliers</text></switch></g><g data-table=\"\" data-table-id=\"3727\" href=\"t3727\" data-target=\"#right\" class=\"node\" transform=\"translate(290,138)\" data-msg=\"<div>Orders</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"78\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34364\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">OrderID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">OrderID</text></switch></g><g data-column=\"\" data-column-id=\"34365\"><image x=\"4\" y=\"23\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvwAADr8BOAVTJAAAAINJREFUOE+tzLENgCAUBFDXYEZHsGAEKwoSCgagoqFiNg0mRzQcfogWr+Bzd4tS6hN6nEGPM+hxhNb6KOinBOUQwkoDb1COMW7lTUM9KKeULG5NqAflnHMtF01g1n8DEhS89/v9/ghJMOKcqyNNSIIRa+01QkMSjBhjdhoYgRH6OU4tJ359xeEtkbt0AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"20\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">CustomerID</p></div></foreignObject><text x=\"17\" y=\"28\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">CustomerID</text></switch></g><g data-column=\"\" data-column-id=\"34366\"><image x=\"4\" y=\"39\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvwAADr8BOAVTJAAAAINJREFUOE+tzLENgCAUBFDXYEZHsGAEKwoSCgagoqFiNg0mRzQcfogWr+Bzd4tS6hN6nEGPM+hxhNb6KOinBOUQwkoDb1COMW7lTUM9KKeULG5NqAflnHMtF01g1n8DEhS89/v9/ghJMOKcqyNNSIIRa+01QkMSjBhjdhoYgRH6OU4tJ359xeEtkbt0AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"36\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">EmployeeID</p></div></foreignObject><text x=\"17\" y=\"44\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">EmployeeID</text></switch></g><g data-column=\"\" data-column-id=\"34370\"><image x=\"4\" y=\"55\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvwAADr8BOAVTJAAAAINJREFUOE+tzLENgCAUBFDXYEZHsGAEKwoSCgagoqFiNg0mRzQcfogWr+Bzd4tS6hN6nEGPM+hxhNb6KOinBOUQwkoDb1COMW7lTUM9KKeULG5NqAflnHMtF01g1n8DEhS89/v9/ghJMOKcqyNNSIIRa+01QkMSjBhjdhoYgRH6OU4tJ359xeEtkbt0AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"52\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">ShipVia</p></div></foreignObject><text x=\"17\" y=\"60\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">ShipVia</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Orders</p></div></foreignObject><text mask=\"url('#node-text-mask-3727')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Orders</text></switch></g><g data-table=\"\" data-table-id=\"3720\" href=\"t3720\" data-target=\"#right\" class=\"node\" transform=\"translate(564,254)\" data-msg=\"<div>CustomerCustomerDemo</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"46\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34320\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">CustomerID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">CustomerID</text></switch></g><g data-column=\"\" data-column-id=\"34321\"><image x=\"4\" y=\"23\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"20\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">CustomerTypeID</p></div></foreignObject><text x=\"17\" y=\"28\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">CustomerTypeID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">CustomerCustomerDemo</p></div></foreignObject><text mask=\"url('#node-text-mask-3720')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">CustomerCustomerDemo</text></switch></g><g data-table=\"\" data-table-id=\"3728\" href=\"t3728\" data-target=\"#right\" class=\"node\" transform=\"translate(290,438)\" data-msg=\"<div>Products</div>\"><g transform=\"translate(0,24)\"><rect width=\"220\" height=\"62\" stroke-width=\"1\" fill=\"#FFFFFF\" stroke=\"#B3B3B3\" /><g data-column=\"\" data-column-id=\"34378\"><image x=\"4\" y=\"7\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAAAd0SU1FB+AIFgsEMj98icUAAACaSURBVDhPpZFBDoMwDAR5Qq/+AH09P0DAp3qqUMhIGLnOUpA4jCCT9SaCzsweIeU42nuebZgm+/BkrXLQiH24ZM5KGlHDgw8ti/X+js9ZaMR+7eNkB5+z0IgaPm6QuHeDx98AcsnZMEgJsaCyqgxICbFA7TtSQiyof+CrMiAlxAK170gJseBfiZRwZxikdK6G4WdRSnnF9TXWbbq73YVN/Hx2AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"4\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">ProductID</p></div></foreignObject><text x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">ProductID</text></switch></g><g data-column=\"\" data-column-id=\"34380\"><image x=\"4\" y=\"23\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvwAADr8BOAVTJAAAAINJREFUOE+tzLENgCAUBFDXYEZHsGAEKwoSCgagoqFiNg0mRzQcfogWr+Bzd4tS6hN6nEGPM+hxhNb6KOinBOUQwkoDb1COMW7lTUM9KKeULG5NqAflnHMtF01g1n8DEhS89/v9/ghJMOKcqyNNSIIRa+01QkMSjBhjdhoYgRH6OU4tJ359xeEtkbt0AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"20\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">SupplierID</p></div></foreignObject><text x=\"17\" y=\"28\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">SupplierID</text></switch></g><g data-column=\"\" data-column-id=\"34381\"><image x=\"4\" y=\"39\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvwAADr8BOAVTJAAAAINJREFUOE+tzLENgCAUBFDXYEZHsGAEKwoSCgagoqFiNg0mRzQcfogWr+Bzd4tS6hN6nEGPM+hxhNb6KOinBOUQwkoDb1COMW7lTUM9KKeULG5NqAflnHMtF01g1n8DEhS89/v9/ghJMOKcqyNNSIIRa+01QkMSjBhjdhoYgRH6OU4tJ359xeEtkbt0AAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"36\" width=\"198\" height=\"16\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 198px; height: 16px;\"><p style=\"max-width: 198px; max-height: 16px;\">CategoryID</p></div></foreignObject><text x=\"17\" y=\"44\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">CategoryID</text></switch></g></g><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAENJREFUOE9jkJSUpAhjFSQFg4n6+vr/pOJBaAAyIIZPfQNIxRgGIANi+NQ3gFSMYQAyIIZPfQNIxSgGUIKxChKPJRkABAzx7KAd/x4AAAAASUVORK5CYII=\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Products</p></div></foreignObject><text mask=\"url('#node-text-mask-3728')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Products</text></switch></g><g data-table=\"\" data-table-id=\"3746\" href=\"v3746\" data-target=\"#right\" class=\"node\" transform=\"translate(717,2366)\" data-msg=\"<div>Sales Totals by Amount</div>\"><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAAd0SU1FB+AIFgwmMp2B2WAAAABJSURBVDhPY5CUlKQIwxn19fX/ScWD0ABkQAwfbgCIQwqm2AAYRjGAWABTO7AGwPDAuQBGk20ADJNtAEgPDMMNIAVjGEA+lmQAADV6ZRscNBviAAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Sales Totals by Amount</p></div></foreignObject><text mask=\"url('#node-text-mask-3746')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Sales Totals by Amount</text></switch></g><g data-table=\"\" data-table-id=\"3747\" href=\"v3747\" data-target=\"#right\" class=\"node\" transform=\"translate(717,2516)\" data-msg=\"<div>Summary of Sales by Quarter</div>\"><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAAd0SU1FB+AIFgwmMp2B2WAAAABJSURBVDhPY5CUlKQIwxn19fX/ScWD0ABkQAwfbgCIQwqm2AAYRjGAWABTO7AGwPDAuQBGk20ADJNtAEgPDMMNIAVjGEA+lmQAADV6ZRscNBviAAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Summary of Sales by Quarter</p></div></foreignObject><text mask=\"url('#node-text-mask-3747')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Summary of Sales by Quarter</text></switch></g><g data-table=\"\" data-table-id=\"3748\" href=\"v3748\" data-target=\"#right\" class=\"node\" transform=\"translate(717,2666)\" data-msg=\"<div>Summary of Sales by Year</div>\"><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAAd0SU1FB+AIFgwmMp2B2WAAAABJSURBVDhPY5CUlKQIwxn19fX/ScWD0ABkQAwfbgCIQwqm2AAYRjGAWABTO7AGwPDAuQBGk20ADJNtAEgPDMMNIAVjGEA+lmQAADV6ZRscNBviAAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">Summary of Sales by Year</p></div></foreignObject><text mask=\"url('#node-text-mask-3748')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">Summary of Sales by Year</text></switch></g><g data-table=\"\" data-table-id=\"3749\" href=\"v3749\" data-target=\"#right\" class=\"node\" transform=\"translate(717,2816)\" data-msg=\"<div>topfiveproducts</div>\"><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAAd0SU1FB+AIFgwmMp2B2WAAAABJSURBVDhPY5CUlKQIwxn19fX/ScWD0ABkQAwfbgCIQwqm2AAYRjGAWABTO7AGwPDAuQBGk20ADJNtAEgPDMMNIAVjGEA+lmQAADV6ZRscNBviAAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">topfiveproducts</p></div></foreignObject><text mask=\"url('#node-text-mask-3749')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">topfiveproducts</text></switch></g><g data-table=\"\" data-table-id=\"3750\" href=\"v3750\" data-target=\"#right\" class=\"node\" transform=\"translate(717,2966)\" data-msg=\"<div>toptenproducts</div>\"><rect width=\"220\" height=\"24\" stroke-width=\"1\" stroke-dasharray=\"1,0\" fill=\"#F6F6F6\" stroke=\"#B3B3B3\" class=\"hoverable\" /><image x=\"4\" y=\"6\" width=\"12\" height=\"12\" xlink:href=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAALDwAACw8BkvkDpQAAAAd0SU1FB+AIFgwmMp2B2WAAAABJSURBVDhPY5CUlKQIwxn19fX/ScWD0ABkQAwfbgCIQwqm2AAYRjGAWABTO7AGwPDAuQBGk20ADJNtAEgPDMMNIAVjGEA+lmQAADV6ZRscNBviAAAAAElFTkSuQmCC\" /><switch><foreignObject x=\"17\" y=\"0\" width=\"201\" height=\"24\"><div xmlns=\"http://www/w3/org/1999/xhtml\" style=\"width: 201px; height: 24px;\"><p style=\"max-width: 201px; max-height: 16px;\">toptenproducts</p></div></foreignObject><text mask=\"url('#node-text-mask-3750')\" x=\"17\" y=\"12\" font-size=\"12\" font-family=\"Arial\" dy=\"0.4em\">toptenproducts</text></switch></g></g></svg>"},"t3722": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3722","name":"Customers","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Customers"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34324","object_id":"column-34324","name":"CustomerID","name_without_path":"CustomerID","description":null,"is_pk":true,"is_identity":false,"data_type":"nchar","data_length":"5","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34325","object_id":"column-34325","name":"CompanyName","name_without_path":"CompanyName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34326","object_id":"column-34326","name":"ContactName","name_without_path":"ContactName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"30","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34327","object_id":"column-34327","name":"ContactTitle","name_without_path":"ContactTitle","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"30","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34328","object_id":"column-34328","name":"Address","name_without_path":"Address","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"60","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34329","object_id":"column-34329","name":"City","name_without_path":"City","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34330","object_id":"column-34330","name":"Region","name_without_path":"Region","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34331","object_id":"column-34331","name":"PostalCode","name_without_path":"PostalCode","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"10","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34332","object_id":"column-34332","name":"Country","name_without_path":"Country","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34333","object_id":"column-34333","name":"Phone","name_without_path":"Phone","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"24","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34334","object_id":"column-34334","name":"Fax","name_without_path":"Fax","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"24","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[{"name":"FK_CustomerCustomerDemo_Customers","title":null,"description":null,"is_user_defined":false,"foreign_table":"CustomerCustomerDemo","foreign_table_show_schema":"dbo.CustomerCustomerDemo","foreign_table_verbose":"CustomerCustomerDemo","foreign_table_verbose_show_schema":"dbo.CustomerCustomerDemo","foreign_table_object_id":"t3720","primary_table":"Customers","primary_table_show_schema":"dbo.Customers","primary_table_verbose":"Customers","primary_table_verbose_show_schema":"dbo.Customers","primary_table_object_id":"t3722","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"CustomerID","foreign_column_path":null,"foreign_column":"CustomerID"}],"custom_fields":{}},{"name":"FK_Orders_Customers","title":null,"description":null,"is_user_defined":false,"foreign_table":"Orders","foreign_table_show_schema":"dbo.Orders","foreign_table_verbose":"Orders","foreign_table_verbose_show_schema":"dbo.Orders","foreign_table_object_id":"t3727","primary_table":"Customers","primary_table_show_schema":"dbo.Customers","primary_table_verbose":"Customers","primary_table_verbose_show_schema":"dbo.Customers","primary_table_object_id":"t3722","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"CustomerID","foreign_column_path":null,"foreign_column":"CustomerID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_Customers","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"CustomerID","name":"CustomerID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[],"used_by":[{"object_name":"Customers","object_name_show_schema":"dbo.Customers","object_type":"TABLE","object_id":"t3722","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Customer and Suppliers by City","object_name_show_schema":"dbo.Customer and Suppliers by City","object_type":"VIEW","object_id":"v3736","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Invoices","object_name_show_schema":"dbo.Invoices","object_type":"VIEW","object_id":"v3737","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders Qry","object_name_show_schema":"dbo.Orders Qry","object_type":"VIEW","object_id":"v3740","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Quarterly Orders","object_name_show_schema":"dbo.Quarterly Orders","object_type":"VIEW","object_id":"v3744","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Sales Totals by Amount","object_name_show_schema":"dbo.Sales Totals by Amount","object_type":"VIEW","object_id":"v3746","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"CustOrderHist","object_name_show_schema":"dbo.CustOrderHist","object_type":"PROCEDURE","object_id":"p135","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"CustomerCustomerDemo","object_name_show_schema":"dbo.CustomerCustomerDemo","object_type":"TABLE","object_id":"t3720","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"m107t": {"title_prefix":"Diagram","custom_fields":[],"tables":[{"id":"m107t3719","name":"Categories","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3720","name":"CustomerCustomerDemo","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3721","name":"CustomerDemographics","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3722","name":"Customers","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3724","name":"Employees","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3725","name":"EmployeeTerritories","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3726","name":"Order Details","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3727","name":"Orders","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3728","name":"Products","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3729","name":"Region","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3730","name":"Shippers","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3731","name":"Suppliers","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107t3732","name":"Territories","type":"TABLE","subtype":"TABLE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}}],"object_id":"m107t"},"m107v": {"title_prefix":"Diagram","custom_fields":[],"views":[{"id":"m107v3746","name":"Sales Totals by Amount","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107v3747","name":"Summary of Sales by Quarter","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107v3748","name":"Summary of Sales by Year","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107v3749","name":"topfiveproducts","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"m107v3750","name":"toptenproducts","type":"VIEW","subtype":"VIEW","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}}],"object_id":"m107v"},"d7p": {"title_prefix":null,"custom_fields":[],"procedures":[{"id":"p135","name":"CustOrderHist","type":"PROCEDURE","subtype":"PROCEDURE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"p136","name":"CustOrdersDetail","type":"PROCEDURE","subtype":"PROCEDURE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"p137","name":"CustOrdersOrders","type":"PROCEDURE","subtype":"PROCEDURE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"p138","name":"Employee Sales by Country","type":"PROCEDURE","subtype":"PROCEDURE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"p139","name":"Sales by Year","type":"PROCEDURE","subtype":"PROCEDURE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"p140","name":"SalesByCategory","type":"PROCEDURE","subtype":"PROCEDURE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"p141","name":"Ten Most Expensive Products","type":"PROCEDURE","subtype":"PROCEDURE","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}}],"object_id":"d7p"},"t3719": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3719","name":"Categories","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Categories"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34316","object_id":"column-34316","name":"CategoryID","name_without_path":"CategoryID","description":null,"is_pk":true,"is_identity":true,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34317","object_id":"column-34317","name":"CategoryName","name_without_path":"CategoryName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34318","object_id":"column-34318","name":"Description","name_without_path":"Description","description":null,"is_pk":false,"is_identity":false,"data_type":"ntext","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34319","object_id":"column-34319","name":"Picture","name_without_path":"Picture","description":null,"is_pk":false,"is_identity":false,"data_type":"image","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[{"name":"FK_Products_Categories","title":null,"description":null,"is_user_defined":false,"foreign_table":"Products","foreign_table_show_schema":"dbo.Products","foreign_table_verbose":"Products","foreign_table_verbose_show_schema":"dbo.Products","foreign_table_object_id":"t3728","primary_table":"Categories","primary_table_show_schema":"dbo.Categories","primary_table_verbose":"Categories","primary_table_verbose_show_schema":"dbo.Categories","primary_table_object_id":"t3719","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"CategoryID","foreign_column_path":null,"foreign_column":"CategoryID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_Categories","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"CategoryID","name":"CategoryID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[],"used_by":[{"object_name":"Categories","object_name_show_schema":"dbo.Categories","object_type":"TABLE","object_id":"t3719","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Alphabetical list of products","object_name_show_schema":"dbo.Alphabetical list of products","object_type":"VIEW","object_id":"v3733","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Product Sales for 1997","object_name_show_schema":"dbo.Product Sales for 1997","object_type":"VIEW","object_id":"v3741","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Category Sales for 1997","object_name_show_schema":"dbo.Category Sales for 1997","object_type":"VIEW","object_id":"v3734","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]},{"object_name":"Products by Category","object_name_show_schema":"dbo.Products by Category","object_type":"VIEW","object_id":"v3743","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Sales by Category","object_name_show_schema":"dbo.Sales by Category","object_type":"VIEW","object_id":"v3745","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"SalesByCategory","object_name_show_schema":"dbo.SalesByCategory","object_type":"PROCEDURE","object_id":"p140","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"t3720": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3720","name":"CustomerCustomerDemo","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"CustomerCustomerDemo"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34320","object_id":"column-34320","name":"CustomerID","name_without_path":"CustomerID","description":null,"is_pk":true,"is_identity":false,"data_type":"nchar","data_length":"5","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3722","name":"Customers","name_show_schema":"dbo.Customers"}]},{"id":"column-34321","object_id":"column-34321","name":"CustomerTypeID","name_without_path":"CustomerTypeID","description":null,"is_pk":true,"is_identity":false,"data_type":"nchar","data_length":"10","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3721","name":"CustomerDemographics","name_show_schema":"dbo.CustomerDemographics"}]}],"relations":[{"name":"FK_CustomerCustomerDemo","title":null,"description":null,"is_user_defined":false,"foreign_table":"CustomerCustomerDemo","foreign_table_show_schema":"dbo.CustomerCustomerDemo","foreign_table_verbose":"CustomerCustomerDemo","foreign_table_verbose_show_schema":"dbo.CustomerCustomerDemo","foreign_table_object_id":"t3720","primary_table":"CustomerDemographics","primary_table_show_schema":"dbo.CustomerDemographics","primary_table_verbose":"CustomerDemographics","primary_table_verbose_show_schema":"dbo.CustomerDemographics","primary_table_object_id":"t3721","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"CustomerTypeID","foreign_column_path":null,"foreign_column":"CustomerTypeID"}],"custom_fields":{}},{"name":"FK_CustomerCustomerDemo_Customers","title":null,"description":null,"is_user_defined":false,"foreign_table":"CustomerCustomerDemo","foreign_table_show_schema":"dbo.CustomerCustomerDemo","foreign_table_verbose":"CustomerCustomerDemo","foreign_table_verbose_show_schema":"dbo.CustomerCustomerDemo","foreign_table_object_id":"t3720","primary_table":"Customers","primary_table_show_schema":"dbo.Customers","primary_table_verbose":"Customers","primary_table_verbose_show_schema":"dbo.Customers","primary_table_object_id":"t3722","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"CustomerID","foreign_column_path":null,"foreign_column":"CustomerID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_CustomerCustomerDemo","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"CustomerID","name":"CustomerID"},{"path":null,"name_without_path":"CustomerTypeID","name":"CustomerTypeID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[{"object_name":"CustomerCustomerDemo","object_name_show_schema":"dbo.CustomerCustomerDemo","object_type":"TABLE","object_id":"t3720","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"CustomerDemographics","object_name_show_schema":"dbo.CustomerDemographics","object_type":"TABLE","object_id":"t3721","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Customers","object_name_show_schema":"dbo.Customers","object_type":"TABLE","object_id":"t3722","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"t3724": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3724","name":"Employees","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Employees"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34356","object_id":"column-34356","name":"EmployeeID","name_without_path":"EmployeeID","description":null,"is_pk":true,"is_identity":true,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34355","object_id":"column-34355","name":"LastName","name_without_path":"LastName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"20","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34354","object_id":"column-34354","name":"FirstName","name_without_path":"FirstName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"10","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34353","object_id":"column-34353","name":"Title","name_without_path":"Title","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"30","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34352","object_id":"column-34352","name":"TitleOfCourtesy","name_without_path":"TitleOfCourtesy","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"25","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34338","object_id":"column-34338","name":"BirthDate","name_without_path":"BirthDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34339","object_id":"column-34339","name":"HireDate","name_without_path":"HireDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34340","object_id":"column-34340","name":"Address","name_without_path":"Address","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"60","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34341","object_id":"column-34341","name":"City","name_without_path":"City","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34342","object_id":"column-34342","name":"Region","name_without_path":"Region","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34343","object_id":"column-34343","name":"PostalCode","name_without_path":"PostalCode","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"10","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34344","object_id":"column-34344","name":"Country","name_without_path":"Country","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34345","object_id":"column-34345","name":"HomePhone","name_without_path":"HomePhone","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"24","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34346","object_id":"column-34346","name":"Extension","name_without_path":"Extension","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"4","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34347","object_id":"column-34347","name":"Photo","name_without_path":"Photo","description":null,"is_pk":false,"is_identity":false,"data_type":"image","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34348","object_id":"column-34348","name":"Notes","name_without_path":"Notes","description":null,"is_pk":false,"is_identity":false,"data_type":"ntext","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34349","object_id":"column-34349","name":"ReportsTo","name_without_path":"ReportsTo","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3724","name":"Employees","name_show_schema":"dbo.Employees"}]},{"id":"column-34350","object_id":"column-34350","name":"PhotoPath","name_without_path":"PhotoPath","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"255","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34351","object_id":"column-34351","name":"dinid","name_without_path":"dinid","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":"1","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[{"name":"FK_Employees_Employees","title":null,"description":null,"is_user_defined":false,"foreign_table":"Employees","foreign_table_show_schema":"dbo.Employees","foreign_table_verbose":"Employees","foreign_table_verbose_show_schema":"dbo.Employees","foreign_table_object_id":"t3724","primary_table":"Employees","primary_table_show_schema":"dbo.Employees","primary_table_verbose":"Employees","primary_table_verbose_show_schema":"dbo.Employees","primary_table_object_id":"t3724","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"EmployeeID","foreign_column_path":null,"foreign_column":"ReportsTo"}],"custom_fields":{}},{"name":"FK_EmployeeTerritories_Employees","title":null,"description":null,"is_user_defined":false,"foreign_table":"EmployeeTerritories","foreign_table_show_schema":"dbo.EmployeeTerritories","foreign_table_verbose":"EmployeeTerritories","foreign_table_verbose_show_schema":"dbo.EmployeeTerritories","foreign_table_object_id":"t3725","primary_table":"Employees","primary_table_show_schema":"dbo.Employees","primary_table_verbose":"Employees","primary_table_verbose_show_schema":"dbo.Employees","primary_table_object_id":"t3724","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"EmployeeID","foreign_column_path":null,"foreign_column":"EmployeeID"}],"custom_fields":{}},{"name":"FK_Orders_Employees","title":null,"description":null,"is_user_defined":false,"foreign_table":"Orders","foreign_table_show_schema":"dbo.Orders","foreign_table_verbose":"Orders","foreign_table_verbose_show_schema":"dbo.Orders","foreign_table_object_id":"t3727","primary_table":"Employees","primary_table_show_schema":"dbo.Employees","primary_table_verbose":"Employees","primary_table_verbose_show_schema":"dbo.Employees","primary_table_object_id":"t3724","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"EmployeeID","foreign_column_path":null,"foreign_column":"EmployeeID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_Employees","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"EmployeeID","name":"EmployeeID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[{"object_name":"Employees","object_name_show_schema":"dbo.Employees","object_type":"TABLE","object_id":"t3724","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Employees","object_name_show_schema":"dbo.Employees","object_type":"TABLE","object_id":"t3724","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[{"object_name":"Employees","object_name_show_schema":"dbo.Employees","object_type":"TABLE","object_id":"t3724","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Invoices","object_name_show_schema":"dbo.Invoices","object_type":"VIEW","object_id":"v3737","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Employee Sales by Country","object_name_show_schema":"dbo.Employee Sales by Country","object_type":"PROCEDURE","object_id":"p138","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Employees","object_name_show_schema":"dbo.Employees","object_type":"TABLE","object_id":"t3724","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"EmployeeTerritories","object_name_show_schema":"dbo.EmployeeTerritories","object_type":"TABLE","object_id":"t3725","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"d7f": {"title_prefix":null,"custom_fields":[],"functions":[{"id":"f132","name":"fn_calcvat","type":"FUNCTION","subtype":"FUNCTION","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"f133","name":"Fn_ParseJson","type":"FUNCTION","subtype":"FUNCTION","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}},{"id":"f134","name":"GetQueryResultByTimeRange","type":"FUNCTION","subtype":"FUNCTION","is_user_defined":false,"custom_fields":{"Sample field: Status":{"value":null,"type":"LIST_CLOSED"}}}],"object_id":"d7f"},"t3729": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3729","name":"Region","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Region"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34388","object_id":"column-34388","name":"RegionID","name_without_path":"RegionID","description":null,"is_pk":true,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34389","object_id":"column-34389","name":"RegionDescription","name_without_path":"RegionDescription","description":null,"is_pk":false,"is_identity":false,"data_type":"nchar","data_length":"50","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[{"name":"FK_Territories_Region","title":null,"description":null,"is_user_defined":false,"foreign_table":"Territories","foreign_table_show_schema":"dbo.Territories","foreign_table_verbose":"Territories","foreign_table_verbose_show_schema":"dbo.Territories","foreign_table_object_id":"t3732","primary_table":"Region","primary_table_show_schema":"dbo.Region","primary_table_verbose":"Region","primary_table_verbose_show_schema":"dbo.Region","primary_table_object_id":"t3729","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"RegionID","foreign_column_path":null,"foreign_column":"RegionID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_Region","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"RegionID","name":"RegionID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[],"used_by":[{"object_name":"Region","object_name_show_schema":"dbo.Region","object_type":"TABLE","object_id":"t3729","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Territories","object_name_show_schema":"dbo.Territories","object_type":"TABLE","object_id":"t3732","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"t3730": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3730","name":"Shippers","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Shippers"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34390","object_id":"column-34390","name":"ShipperID","name_without_path":"ShipperID","description":null,"is_pk":true,"is_identity":true,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34391","object_id":"column-34391","name":"CompanyName","name_without_path":"CompanyName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34392","object_id":"column-34392","name":"Phone","name_without_path":"Phone","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"24","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[{"name":"FK_Orders_Shippers","title":null,"description":null,"is_user_defined":false,"foreign_table":"Orders","foreign_table_show_schema":"dbo.Orders","foreign_table_verbose":"Orders","foreign_table_verbose_show_schema":"dbo.Orders","foreign_table_object_id":"t3727","primary_table":"Shippers","primary_table_show_schema":"dbo.Shippers","primary_table_verbose":"Shippers","primary_table_verbose_show_schema":"dbo.Shippers","primary_table_object_id":"t3730","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"ShipperID","foreign_column_path":null,"foreign_column":"ShipVia"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_Shippers","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"ShipperID","name":"ShipperID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[],"used_by":[{"object_name":"Shippers","object_name_show_schema":"dbo.Shippers","object_type":"TABLE","object_id":"t3730","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Invoices","object_name_show_schema":"dbo.Invoices","object_type":"VIEW","object_id":"v3737","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"t3731": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3731","name":"Suppliers","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Suppliers"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34393","object_id":"column-34393","name":"SupplierID","name_without_path":"SupplierID","description":null,"is_pk":true,"is_identity":true,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34394","object_id":"column-34394","name":"CompanyName","name_without_path":"CompanyName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34395","object_id":"column-34395","name":"ContactName","name_without_path":"ContactName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"30","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34396","object_id":"column-34396","name":"ContactTitle","name_without_path":"ContactTitle","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"30","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34397","object_id":"column-34397","name":"Address","name_without_path":"Address","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"60","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34398","object_id":"column-34398","name":"City","name_without_path":"City","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34399","object_id":"column-34399","name":"Region","name_without_path":"Region","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34400","object_id":"column-34400","name":"PostalCode","name_without_path":"PostalCode","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"10","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34401","object_id":"column-34401","name":"Country","name_without_path":"Country","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34402","object_id":"column-34402","name":"Phone","name_without_path":"Phone","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"24","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34403","object_id":"column-34403","name":"Fax","name_without_path":"Fax","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"24","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34404","object_id":"column-34404","name":"HomePage","name_without_path":"HomePage","description":null,"is_pk":false,"is_identity":false,"data_type":"ntext","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[{"name":"FK_Products_Suppliers","title":null,"description":null,"is_user_defined":false,"foreign_table":"Products","foreign_table_show_schema":"dbo.Products","foreign_table_verbose":"Products","foreign_table_verbose_show_schema":"dbo.Products","foreign_table_object_id":"t3728","primary_table":"Suppliers","primary_table_show_schema":"dbo.Suppliers","primary_table_verbose":"Suppliers","primary_table_verbose_show_schema":"dbo.Suppliers","primary_table_object_id":"t3731","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"SupplierID","foreign_column_path":null,"foreign_column":"SupplierID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_Suppliers","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"SupplierID","name":"SupplierID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[],"used_by":[{"object_name":"Suppliers","object_name_show_schema":"dbo.Suppliers","object_type":"TABLE","object_id":"t3731","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Customer and Suppliers by City","object_name_show_schema":"dbo.Customer and Suppliers by City","object_type":"VIEW","object_id":"v3736","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"t3732": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3732","name":"Territories","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Territories"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34405","object_id":"column-34405","name":"TerritoryID","name_without_path":"TerritoryID","description":null,"is_pk":true,"is_identity":false,"data_type":"nvarchar","data_length":"20","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34406","object_id":"column-34406","name":"TerritoryDescription","name_without_path":"TerritoryDescription","description":null,"is_pk":false,"is_identity":false,"data_type":"nchar","data_length":"50","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34407","object_id":"column-34407","name":"RegionID","name_without_path":"RegionID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3729","name":"Region","name_show_schema":"dbo.Region"}]}],"relations":[{"name":"FK_Territories_Region","title":null,"description":null,"is_user_defined":false,"foreign_table":"Territories","foreign_table_show_schema":"dbo.Territories","foreign_table_verbose":"Territories","foreign_table_verbose_show_schema":"dbo.Territories","foreign_table_object_id":"t3732","primary_table":"Region","primary_table_show_schema":"dbo.Region","primary_table_verbose":"Region","primary_table_verbose_show_schema":"dbo.Region","primary_table_object_id":"t3729","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"RegionID","foreign_column_path":null,"foreign_column":"RegionID"}],"custom_fields":{}},{"name":"FK_EmployeeTerritories_Territories","title":null,"description":null,"is_user_defined":false,"foreign_table":"EmployeeTerritories","foreign_table_show_schema":"dbo.EmployeeTerritories","foreign_table_verbose":"EmployeeTerritories","foreign_table_verbose_show_schema":"dbo.EmployeeTerritories","foreign_table_object_id":"t3725","primary_table":"Territories","primary_table_show_schema":"dbo.Territories","primary_table_verbose":"Territories","primary_table_verbose_show_schema":"dbo.Territories","primary_table_object_id":"t3732","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"TerritoryID","foreign_column_path":null,"foreign_column":"TerritoryID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_Territories","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"TerritoryID","name":"TerritoryID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[{"object_name":"Territories","object_name_show_schema":"dbo.Territories","object_type":"TABLE","object_id":"t3732","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Region","object_name_show_schema":"dbo.Region","object_type":"TABLE","object_id":"t3729","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[{"object_name":"Territories","object_name_show_schema":"dbo.Territories","object_type":"TABLE","object_id":"t3732","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"EmployeeTerritories","object_name_show_schema":"dbo.EmployeeTerritories","object_type":"TABLE","object_id":"t3725","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"v3746": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3746","name":"Sales Totals by Amount","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Sales Totals by Amount\" AS\r\nSELECT \"Order Subtotals\".Subtotal AS SaleAmount, Orders.OrderID, Customers.CompanyName, Orders.ShippedDate\r\nFROM \tCustomers INNER JOIN \r\n\t\t(Orders INNER JOIN \"Order Subtotals\" ON Orders.OrderID = \"Order Subtotals\".OrderID) \r\n\tON Customers.CustomerID = Orders.CustomerID\r\nWHERE (\"Order Subtotals\".Subtotal >2500) AND (Orders.ShippedDate BETWEEN '19970101' And '19971231')","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Sales Totals by Amount"},{"field":"Type","value":"View"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34500","object_id":"column-34500","name":"SaleAmount","name_without_path":"SaleAmount","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34501","object_id":"column-34501","name":"OrderID","name_without_path":"OrderID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34502","object_id":"column-34502","name":"CompanyName","name_without_path":"CompanyName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34503","object_id":"column-34503","name":"ShippedDate","name_without_path":"ShippedDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Sales Totals by Amount","object_name_show_schema":"dbo.Sales Totals by Amount","object_type":"VIEW","object_id":"v3746","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Customers","object_name_show_schema":"dbo.Customers","object_type":"TABLE","object_id":"t3722","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Subtotals","object_name_show_schema":"dbo.Order Subtotals","object_type":"VIEW","object_id":"v3739","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"t3721": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3721","name":"CustomerDemographics","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"CustomerDemographics"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34322","object_id":"column-34322","name":"CustomerTypeID","name_without_path":"CustomerTypeID","description":null,"is_pk":true,"is_identity":false,"data_type":"nchar","data_length":"10","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34323","object_id":"column-34323","name":"CustomerDesc","name_without_path":"CustomerDesc","description":null,"is_pk":false,"is_identity":false,"data_type":"ntext","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[{"name":"FK_CustomerCustomerDemo","title":null,"description":null,"is_user_defined":false,"foreign_table":"CustomerCustomerDemo","foreign_table_show_schema":"dbo.CustomerCustomerDemo","foreign_table_verbose":"CustomerCustomerDemo","foreign_table_verbose_show_schema":"dbo.CustomerCustomerDemo","foreign_table_object_id":"t3720","primary_table":"CustomerDemographics","primary_table_show_schema":"dbo.CustomerDemographics","primary_table_verbose":"CustomerDemographics","primary_table_verbose_show_schema":"dbo.CustomerDemographics","primary_table_object_id":"t3721","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"CustomerTypeID","foreign_column_path":null,"foreign_column":"CustomerTypeID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_CustomerDemographics","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"CustomerTypeID","name":"CustomerTypeID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[],"used_by":[{"object_name":"CustomerDemographics","object_name_show_schema":"dbo.CustomerDemographics","object_type":"TABLE","object_id":"t3721","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"CustomerCustomerDemo","object_name_show_schema":"dbo.CustomerCustomerDemo","object_type":"TABLE","object_id":"t3720","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"t3726": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3726","name":"Order Details","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Order Details"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34359","object_id":"column-34359","name":"OrderID","name_without_path":"OrderID","description":null,"is_pk":true,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3727","name":"Orders","name_show_schema":"dbo.Orders"}]},{"id":"column-34360","object_id":"column-34360","name":"ProductID","name_without_path":"ProductID","description":null,"is_pk":true,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3728","name":"Products","name_show_schema":"dbo.Products"}]},{"id":"column-34361","object_id":"column-34361","name":"UnitPrice","name_without_path":"UnitPrice","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34362","object_id":"column-34362","name":"Quantity","name_without_path":"Quantity","description":null,"is_pk":false,"is_identity":false,"data_type":"smallint","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":"1","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34363","object_id":"column-34363","name":"Discount","name_without_path":"Discount","description":null,"is_pk":false,"is_identity":false,"data_type":"real","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[{"name":"FK_Order_Details_Orders","title":null,"description":null,"is_user_defined":false,"foreign_table":"Order Details","foreign_table_show_schema":"dbo.Order Details","foreign_table_verbose":"Order Details","foreign_table_verbose_show_schema":"dbo.Order Details","foreign_table_object_id":"t3726","primary_table":"Orders","primary_table_show_schema":"dbo.Orders","primary_table_verbose":"Orders","primary_table_verbose_show_schema":"dbo.Orders","primary_table_object_id":"t3727","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"OrderID","foreign_column_path":null,"foreign_column":"OrderID"}],"custom_fields":{}},{"name":"FK_Order_Details_Products","title":null,"description":null,"is_user_defined":false,"foreign_table":"Order Details","foreign_table_show_schema":"dbo.Order Details","foreign_table_verbose":"Order Details","foreign_table_verbose_show_schema":"dbo.Order Details","foreign_table_object_id":"t3726","primary_table":"Products","primary_table_show_schema":"dbo.Products","primary_table_verbose":"Products","primary_table_verbose_show_schema":"dbo.Products","primary_table_object_id":"t3728","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"ProductID","foreign_column_path":null,"foreign_column":"ProductID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_Order_Details","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"OrderID","name":"OrderID"},{"path":null,"name_without_path":"ProductID","name":"ProductID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Invoices","object_name_show_schema":"dbo.Invoices","object_type":"VIEW","object_id":"v3737","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Details Extended","object_name_show_schema":"dbo.Order Details Extended","object_type":"VIEW","object_id":"v3738","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Sales by Category","object_name_show_schema":"dbo.Sales by Category","object_type":"VIEW","object_id":"v3745","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]},{"object_name":"Order Subtotals","object_name_show_schema":"dbo.Order Subtotals","object_type":"VIEW","object_id":"v3739","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Sales Totals by Amount","object_name_show_schema":"dbo.Sales Totals by Amount","object_type":"VIEW","object_id":"v3746","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Summary of Sales by Quarter","object_name_show_schema":"dbo.Summary of Sales by Quarter","object_type":"VIEW","object_id":"v3747","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Summary of Sales by Year","object_name_show_schema":"dbo.Summary of Sales by Year","object_type":"VIEW","object_id":"v3748","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Employee Sales by Country","object_name_show_schema":"dbo.Employee Sales by Country","object_type":"PROCEDURE","object_id":"p138","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Sales by Year","object_name_show_schema":"dbo.Sales by Year","object_type":"PROCEDURE","object_id":"p139","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]},{"object_name":"Product Sales for 1997","object_name_show_schema":"dbo.Product Sales for 1997","object_type":"VIEW","object_id":"v3741","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Category Sales for 1997","object_name_show_schema":"dbo.Category Sales for 1997","object_type":"VIEW","object_id":"v3734","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]},{"object_name":"CustOrderHist","object_name_show_schema":"dbo.CustOrderHist","object_type":"PROCEDURE","object_id":"p135","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"CustOrdersDetail","object_name_show_schema":"dbo.CustOrdersDetail","object_type":"PROCEDURE","object_id":"p136","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"SalesByCategory","object_name_show_schema":"dbo.SalesByCategory","object_type":"PROCEDURE","object_id":"p140","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"v3747": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3747","name":"Summary of Sales by Quarter","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Summary of Sales by Quarter\" AS\r\nSELECT Orders.ShippedDate, Orders.OrderID, \"Order Subtotals\".Subtotal\r\nFROM Orders INNER JOIN \"Order Subtotals\" ON Orders.OrderID = \"Order Subtotals\".OrderID\r\nWHERE Orders.ShippedDate IS NOT NULL\r\n--ORDER BY Orders.ShippedDate","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Summary of Sales by Quarter"},{"field":"Type","value":"View"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34504","object_id":"column-34504","name":"ShippedDate","name_without_path":"ShippedDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34505","object_id":"column-34505","name":"OrderID","name_without_path":"OrderID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34506","object_id":"column-34506","name":"Subtotal","name_without_path":"Subtotal","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Summary of Sales by Quarter","object_name_show_schema":"dbo.Summary of Sales by Quarter","object_type":"VIEW","object_id":"v3747","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Subtotals","object_name_show_schema":"dbo.Order Subtotals","object_type":"VIEW","object_id":"v3739","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3735": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3735","name":"Current Product List","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Current Product List\" AS\r\nSELECT Product_List.ProductID, Product_List.ProductName\r\nFROM Products AS Product_List\r\nWHERE (((Product_List.Discontinued)=0))\r\n--ORDER BY Product_List.ProductName","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Current Product List"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34421","object_id":"column-34421","name":"ProductID","name_without_path":"ProductID","description":null,"is_pk":false,"is_identity":true,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34422","object_id":"column-34422","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Current Product List","object_name_show_schema":"dbo.Current Product List","object_type":"VIEW","object_id":"v3735","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3736": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3736","name":"Customer and Suppliers by City","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Customer and Suppliers by City\" AS\r\nSELECT City, CompanyName, ContactName, 'Customers' AS Relationship \r\nFROM Customers\r\nUNION SELECT City, CompanyName, ContactName, 'Suppliers'\r\nFROM Suppliers\r\n--ORDER BY City, CompanyName","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Customer and Suppliers by City"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34423","object_id":"column-34423","name":"City","name_without_path":"City","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34424","object_id":"column-34424","name":"CompanyName","name_without_path":"CompanyName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34425","object_id":"column-34425","name":"ContactName","name_without_path":"ContactName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"30","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34426","object_id":"column-34426","name":"Relationship","name_without_path":"Relationship","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"9","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Customer and Suppliers by City","object_name_show_schema":"dbo.Customer and Suppliers by City","object_type":"VIEW","object_id":"v3736","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Customers","object_name_show_schema":"dbo.Customers","object_type":"TABLE","object_id":"t3722","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Suppliers","object_name_show_schema":"dbo.Suppliers","object_type":"TABLE","object_id":"t3731","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3748": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3748","name":"Summary of Sales by Year","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Summary of Sales by Year\" AS\r\nSELECT Orders.ShippedDate, Orders.OrderID, \"Order Subtotals\".Subtotal\r\nFROM Orders INNER JOIN \"Order Subtotals\" ON Orders.OrderID = \"Order Subtotals\".OrderID\r\nWHERE Orders.ShippedDate IS NOT NULL\r\n--ORDER BY Orders.ShippedDate","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Summary of Sales by Year"},{"field":"Type","value":"View"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34507","object_id":"column-34507","name":"ShippedDate","name_without_path":"ShippedDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34508","object_id":"column-34508","name":"OrderID","name_without_path":"OrderID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34509","object_id":"column-34509","name":"Subtotal","name_without_path":"Subtotal","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Summary of Sales by Year","object_name_show_schema":"dbo.Summary of Sales by Year","object_type":"VIEW","object_id":"v3748","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Subtotals","object_name_show_schema":"dbo.Order Subtotals","object_type":"VIEW","object_id":"v3739","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3737": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3737","name":"Invoices","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view Invoices AS\r\nSELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, \r\n\tOrders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName, Customers.Address, Customers.City, \r\n\tCustomers.Region, Customers.PostalCode, Customers.Country, \r\n\t(FirstName + ' ' + LastName) AS Salesperson, \r\n\tOrders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Shippers.CompanyName As ShipperName, \r\n\t\"Order Details\".ProductID, Products.ProductName, \"Order Details\".UnitPrice, \"Order Details\".Quantity, \r\n\t\"Order Details\".Discount, \r\n\t(CONVERT(money,(\"Order Details\".UnitPrice*Quantity*(1-Discount)/100))*100) AS ExtendedPrice, Orders.Freight\r\nFROM \tShippers INNER JOIN \r\n\t\t(Products INNER JOIN \r\n\t\t\t(\r\n\t\t\t\t(Employees INNER JOIN \r\n\t\t\t\t\t(Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) \r\n\t\t\t\tON Employees.EmployeeID = Orders.EmployeeID) \r\n\t\t\tINNER JOIN \"Order Details\" ON Orders.OrderID = \"Order Details\".OrderID) \r\n\t\tON Products.ProductID = \"Order Details\".ProductID) \r\n\tON Shippers.ShipperID = Orders.ShipVia","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Invoices"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34427","object_id":"column-34427","name":"ShipName","name_without_path":"ShipName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34428","object_id":"column-34428","name":"ShipAddress","name_without_path":"ShipAddress","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"60","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34429","object_id":"column-34429","name":"ShipCity","name_without_path":"ShipCity","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34430","object_id":"column-34430","name":"ShipRegion","name_without_path":"ShipRegion","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34431","object_id":"column-34431","name":"ShipPostalCode","name_without_path":"ShipPostalCode","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"10","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34432","object_id":"column-34432","name":"ShipCountry","name_without_path":"ShipCountry","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34433","object_id":"column-34433","name":"CustomerID","name_without_path":"CustomerID","description":null,"is_pk":false,"is_identity":false,"data_type":"nchar","data_length":"5","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34434","object_id":"column-34434","name":"CustomerName","name_without_path":"CustomerName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34435","object_id":"column-34435","name":"Address","name_without_path":"Address","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"60","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34436","object_id":"column-34436","name":"City","name_without_path":"City","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34437","object_id":"column-34437","name":"Region","name_without_path":"Region","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34438","object_id":"column-34438","name":"PostalCode","name_without_path":"PostalCode","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"10","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34439","object_id":"column-34439","name":"Country","name_without_path":"Country","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34440","object_id":"column-34440","name":"Salesperson","name_without_path":"Salesperson","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"31","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34441","object_id":"column-34441","name":"OrderID","name_without_path":"OrderID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34442","object_id":"column-34442","name":"OrderDate","name_without_path":"OrderDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34443","object_id":"column-34443","name":"RequiredDate","name_without_path":"RequiredDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34444","object_id":"column-34444","name":"ShippedDate","name_without_path":"ShippedDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34445","object_id":"column-34445","name":"ShipperName","name_without_path":"ShipperName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34446","object_id":"column-34446","name":"ProductID","name_without_path":"ProductID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34447","object_id":"column-34447","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34448","object_id":"column-34448","name":"UnitPrice","name_without_path":"UnitPrice","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34449","object_id":"column-34449","name":"Quantity","name_without_path":"Quantity","description":null,"is_pk":false,"is_identity":false,"data_type":"smallint","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34450","object_id":"column-34450","name":"Discount","name_without_path":"Discount","description":null,"is_pk":false,"is_identity":false,"data_type":"real","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34451","object_id":"column-34451","name":"ExtendedPrice","name_without_path":"ExtendedPrice","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34452","object_id":"column-34452","name":"Freight","name_without_path":"Freight","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Invoices","object_name_show_schema":"dbo.Invoices","object_type":"VIEW","object_id":"v3737","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Customers","object_name_show_schema":"dbo.Customers","object_type":"TABLE","object_id":"t3722","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Employees","object_name_show_schema":"dbo.Employees","object_type":"TABLE","object_id":"t3724","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Shippers","object_name_show_schema":"dbo.Shippers","object_type":"TABLE","object_id":"t3730","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"t3727": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3727","name":"Orders","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Orders"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34364","object_id":"column-34364","name":"OrderID","name_without_path":"OrderID","description":null,"is_pk":true,"is_identity":true,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34365","object_id":"column-34365","name":"CustomerID","name_without_path":"CustomerID","description":null,"is_pk":false,"is_identity":false,"data_type":"nchar","data_length":"5","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3722","name":"Customers","name_show_schema":"dbo.Customers"}]},{"id":"column-34366","object_id":"column-34366","name":"EmployeeID","name_without_path":"EmployeeID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3724","name":"Employees","name_show_schema":"dbo.Employees"}]},{"id":"column-34367","object_id":"column-34367","name":"OrderDate","name_without_path":"OrderDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34368","object_id":"column-34368","name":"RequiredDate","name_without_path":"RequiredDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34369","object_id":"column-34369","name":"ShippedDate","name_without_path":"ShippedDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34370","object_id":"column-34370","name":"ShipVia","name_without_path":"ShipVia","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3730","name":"Shippers","name_show_schema":"dbo.Shippers"}]},{"id":"column-34371","object_id":"column-34371","name":"Freight","name_without_path":"Freight","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34372","object_id":"column-34372","name":"ShipName","name_without_path":"ShipName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34373","object_id":"column-34373","name":"ShipAddress","name_without_path":"ShipAddress","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"60","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34374","object_id":"column-34374","name":"ShipCity","name_without_path":"ShipCity","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34375","object_id":"column-34375","name":"ShipRegion","name_without_path":"ShipRegion","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34376","object_id":"column-34376","name":"ShipPostalCode","name_without_path":"ShipPostalCode","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"10","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34377","object_id":"column-34377","name":"ShipCountry","name_without_path":"ShipCountry","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[{"name":"FK_Orders_Customers","title":null,"description":null,"is_user_defined":false,"foreign_table":"Orders","foreign_table_show_schema":"dbo.Orders","foreign_table_verbose":"Orders","foreign_table_verbose_show_schema":"dbo.Orders","foreign_table_object_id":"t3727","primary_table":"Customers","primary_table_show_schema":"dbo.Customers","primary_table_verbose":"Customers","primary_table_verbose_show_schema":"dbo.Customers","primary_table_object_id":"t3722","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"CustomerID","foreign_column_path":null,"foreign_column":"CustomerID"}],"custom_fields":{}},{"name":"FK_Orders_Employees","title":null,"description":null,"is_user_defined":false,"foreign_table":"Orders","foreign_table_show_schema":"dbo.Orders","foreign_table_verbose":"Orders","foreign_table_verbose_show_schema":"dbo.Orders","foreign_table_object_id":"t3727","primary_table":"Employees","primary_table_show_schema":"dbo.Employees","primary_table_verbose":"Employees","primary_table_verbose_show_schema":"dbo.Employees","primary_table_object_id":"t3724","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"EmployeeID","foreign_column_path":null,"foreign_column":"EmployeeID"}],"custom_fields":{}},{"name":"FK_Orders_Shippers","title":null,"description":null,"is_user_defined":false,"foreign_table":"Orders","foreign_table_show_schema":"dbo.Orders","foreign_table_verbose":"Orders","foreign_table_verbose_show_schema":"dbo.Orders","foreign_table_object_id":"t3727","primary_table":"Shippers","primary_table_show_schema":"dbo.Shippers","primary_table_verbose":"Shippers","primary_table_verbose_show_schema":"dbo.Shippers","primary_table_object_id":"t3730","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"ShipperID","foreign_column_path":null,"foreign_column":"ShipVia"}],"custom_fields":{}},{"name":"FK_Order_Details_Orders","title":null,"description":null,"is_user_defined":false,"foreign_table":"Order Details","foreign_table_show_schema":"dbo.Order Details","foreign_table_verbose":"Order Details","foreign_table_verbose_show_schema":"dbo.Order Details","foreign_table_object_id":"t3726","primary_table":"Orders","primary_table_show_schema":"dbo.Orders","primary_table_verbose":"Orders","primary_table_verbose_show_schema":"dbo.Orders","primary_table_object_id":"t3727","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"OrderID","foreign_column_path":null,"foreign_column":"OrderID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_Orders","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"OrderID","name":"OrderID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Customers","object_name_show_schema":"dbo.Customers","object_type":"TABLE","object_id":"t3722","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Employees","object_name_show_schema":"dbo.Employees","object_type":"TABLE","object_id":"t3724","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Shippers","object_name_show_schema":"dbo.Shippers","object_type":"TABLE","object_id":"t3730","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Invoices","object_name_show_schema":"dbo.Invoices","object_type":"VIEW","object_id":"v3737","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders Qry","object_name_show_schema":"dbo.Orders Qry","object_type":"VIEW","object_id":"v3740","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Product Sales for 1997","object_name_show_schema":"dbo.Product Sales for 1997","object_type":"VIEW","object_id":"v3741","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Category Sales for 1997","object_name_show_schema":"dbo.Category Sales for 1997","object_type":"VIEW","object_id":"v3734","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]},{"object_name":"Quarterly Orders","object_name_show_schema":"dbo.Quarterly Orders","object_type":"VIEW","object_id":"v3744","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Sales by Category","object_name_show_schema":"dbo.Sales by Category","object_type":"VIEW","object_id":"v3745","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Sales Totals by Amount","object_name_show_schema":"dbo.Sales Totals by Amount","object_type":"VIEW","object_id":"v3746","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Summary of Sales by Quarter","object_name_show_schema":"dbo.Summary of Sales by Quarter","object_type":"VIEW","object_id":"v3747","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Summary of Sales by Year","object_name_show_schema":"dbo.Summary of Sales by Year","object_type":"VIEW","object_id":"v3748","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"CustOrderHist","object_name_show_schema":"dbo.CustOrderHist","object_type":"PROCEDURE","object_id":"p135","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"CustOrdersOrders","object_name_show_schema":"dbo.CustOrdersOrders","object_type":"PROCEDURE","object_id":"p137","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Employee Sales by Country","object_name_show_schema":"dbo.Employee Sales by Country","object_type":"PROCEDURE","object_id":"p138","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Sales by Year","object_name_show_schema":"dbo.Sales by Year","object_type":"PROCEDURE","object_id":"p139","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"SalesByCategory","object_name_show_schema":"dbo.SalesByCategory","object_type":"PROCEDURE","object_id":"p140","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"t3728": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3728","name":"Products","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Products"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34378","object_id":"column-34378","name":"ProductID","name_without_path":"ProductID","description":null,"is_pk":true,"is_identity":true,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34379","object_id":"column-34379","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34380","object_id":"column-34380","name":"SupplierID","name_without_path":"SupplierID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3731","name":"Suppliers","name_show_schema":"dbo.Suppliers"}]},{"id":"column-34381","object_id":"column-34381","name":"CategoryID","name_without_path":"CategoryID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3719","name":"Categories","name_show_schema":"dbo.Categories"}]},{"id":"column-34382","object_id":"column-34382","name":"QuantityPerUnit","name_without_path":"QuantityPerUnit","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"20","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34383","object_id":"column-34383","name":"UnitPrice","name_without_path":"UnitPrice","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34384","object_id":"column-34384","name":"UnitsInStock","name_without_path":"UnitsInStock","description":null,"is_pk":false,"is_identity":false,"data_type":"smallint","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34385","object_id":"column-34385","name":"UnitsOnOrder","name_without_path":"UnitsOnOrder","description":null,"is_pk":false,"is_identity":false,"data_type":"smallint","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34386","object_id":"column-34386","name":"ReorderLevel","name_without_path":"ReorderLevel","description":null,"is_pk":false,"is_identity":false,"data_type":"smallint","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34387","object_id":"column-34387","name":"Discontinued","name_without_path":"Discontinued","description":null,"is_pk":false,"is_identity":false,"data_type":"bit","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[{"name":"FK_Products_Categories","title":null,"description":null,"is_user_defined":false,"foreign_table":"Products","foreign_table_show_schema":"dbo.Products","foreign_table_verbose":"Products","foreign_table_verbose_show_schema":"dbo.Products","foreign_table_object_id":"t3728","primary_table":"Categories","primary_table_show_schema":"dbo.Categories","primary_table_verbose":"Categories","primary_table_verbose_show_schema":"dbo.Categories","primary_table_object_id":"t3719","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"CategoryID","foreign_column_path":null,"foreign_column":"CategoryID"}],"custom_fields":{}},{"name":"FK_Products_Suppliers","title":null,"description":null,"is_user_defined":false,"foreign_table":"Products","foreign_table_show_schema":"dbo.Products","foreign_table_verbose":"Products","foreign_table_verbose_show_schema":"dbo.Products","foreign_table_object_id":"t3728","primary_table":"Suppliers","primary_table_show_schema":"dbo.Suppliers","primary_table_verbose":"Suppliers","primary_table_verbose_show_schema":"dbo.Suppliers","primary_table_object_id":"t3731","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"SupplierID","foreign_column_path":null,"foreign_column":"SupplierID"}],"custom_fields":{}},{"name":"FK_Order_Details_Products","title":null,"description":null,"is_user_defined":false,"foreign_table":"Order Details","foreign_table_show_schema":"dbo.Order Details","foreign_table_verbose":"Order Details","foreign_table_verbose_show_schema":"dbo.Order Details","foreign_table_object_id":"t3726","primary_table":"Products","primary_table_show_schema":"dbo.Products","primary_table_verbose":"Products","primary_table_verbose_show_schema":"dbo.Products","primary_table_object_id":"t3728","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"ProductID","foreign_column_path":null,"foreign_column":"ProductID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_Products","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"ProductID","name":"ProductID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Categories","object_name_show_schema":"dbo.Categories","object_type":"TABLE","object_id":"t3719","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Suppliers","object_name_show_schema":"dbo.Suppliers","object_type":"TABLE","object_id":"t3731","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Alphabetical list of products","object_name_show_schema":"dbo.Alphabetical list of products","object_type":"VIEW","object_id":"v3733","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Current Product List","object_name_show_schema":"dbo.Current Product List","object_type":"VIEW","object_id":"v3735","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Invoices","object_name_show_schema":"dbo.Invoices","object_type":"VIEW","object_id":"v3737","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Details Extended","object_name_show_schema":"dbo.Order Details Extended","object_type":"VIEW","object_id":"v3738","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Sales by Category","object_name_show_schema":"dbo.Sales by Category","object_type":"VIEW","object_id":"v3745","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]},{"object_name":"Product Sales for 1997","object_name_show_schema":"dbo.Product Sales for 1997","object_type":"VIEW","object_id":"v3741","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Category Sales for 1997","object_name_show_schema":"dbo.Category Sales for 1997","object_type":"VIEW","object_id":"v3734","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]},{"object_name":"Products Above Average Price","object_name_show_schema":"dbo.Products Above Average Price","object_type":"VIEW","object_id":"v3742","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products by Category","object_name_show_schema":"dbo.Products by Category","object_type":"VIEW","object_id":"v3743","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Sales by Category","object_name_show_schema":"dbo.Sales by Category","object_type":"VIEW","object_id":"v3745","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"topfiveproducts","object_name_show_schema":"dbo.topfiveproducts","object_type":"VIEW","object_id":"v3749","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"toptenproducts","object_name_show_schema":"dbo.toptenproducts","object_type":"VIEW","object_id":"v3750","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"CustOrderHist","object_name_show_schema":"dbo.CustOrderHist","object_type":"PROCEDURE","object_id":"p135","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"CustOrdersDetail","object_name_show_schema":"dbo.CustOrdersDetail","object_type":"PROCEDURE","object_id":"p136","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"SalesByCategory","object_name_show_schema":"dbo.SalesByCategory","object_type":"PROCEDURE","object_id":"p140","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Ten Most Expensive Products","object_name_show_schema":"dbo.Ten Most Expensive Products","object_type":"PROCEDURE","object_id":"p141","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"t3725": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3725","name":"EmployeeTerritories","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"EmployeeTerritories"},{"field":"Type","value":"Table"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34357","object_id":"column-34357","name":"EmployeeID","name_without_path":"EmployeeID","description":null,"is_pk":true,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3724","name":"Employees","name_show_schema":"dbo.Employees"}]},{"id":"column-34358","object_id":"column-34358","name":"TerritoryID","name_without_path":"TerritoryID","description":null,"is_pk":true,"is_identity":false,"data_type":"nvarchar","data_length":"20","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[{"id":"t3732","name":"Territories","name_show_schema":"dbo.Territories"}]}],"relations":[{"name":"FK_EmployeeTerritories_Employees","title":null,"description":null,"is_user_defined":false,"foreign_table":"EmployeeTerritories","foreign_table_show_schema":"dbo.EmployeeTerritories","foreign_table_verbose":"EmployeeTerritories","foreign_table_verbose_show_schema":"dbo.EmployeeTerritories","foreign_table_object_id":"t3725","primary_table":"Employees","primary_table_show_schema":"dbo.Employees","primary_table_verbose":"Employees","primary_table_verbose_show_schema":"dbo.Employees","primary_table_object_id":"t3724","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"EmployeeID","foreign_column_path":null,"foreign_column":"EmployeeID"}],"custom_fields":{}},{"name":"FK_EmployeeTerritories_Territories","title":null,"description":null,"is_user_defined":false,"foreign_table":"EmployeeTerritories","foreign_table_show_schema":"dbo.EmployeeTerritories","foreign_table_verbose":"EmployeeTerritories","foreign_table_verbose_show_schema":"dbo.EmployeeTerritories","foreign_table_object_id":"t3725","primary_table":"Territories","primary_table_show_schema":"dbo.Territories","primary_table_verbose":"Territories","primary_table_verbose_show_schema":"dbo.Territories","primary_table_object_id":"t3732","pk_cardinality":"1x","fk_cardinality":"mx","constraints":[{"primary_column_path":null,"primary_column":"TerritoryID","foreign_column_path":null,"foreign_column":"TerritoryID"}],"custom_fields":{}}],"unique_keys":[{"name":"PK_EmployeeTerritories","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"EmployeeID","name":"EmployeeID"},{"path":null,"name_without_path":"TerritoryID","name":"TerritoryID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[{"object_name":"EmployeeTerritories","object_name_show_schema":"dbo.EmployeeTerritories","object_type":"TABLE","object_id":"t3725","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Employees","object_name_show_schema":"dbo.Employees","object_type":"TABLE","object_id":"t3724","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Territories","object_name_show_schema":"dbo.Territories","object_type":"TABLE","object_id":"t3732","type":"RELATION","pk_cardinality":"1x","fk_cardinality":"mx","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3741": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3741","name":"Product Sales for 1997","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Product Sales for 1997\" AS\r\nSELECT Categories.CategoryName, Products.ProductName, \r\nSum(CONVERT(money,(\"Order Details\".UnitPrice*Quantity*(1-Discount)/100))*100) AS ProductSales\r\nFROM (Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID) \r\n\tINNER JOIN (Orders \r\n\t\tINNER JOIN \"Order Details\" ON Orders.OrderID = \"Order Details\".OrderID) \r\n\tON Products.ProductID = \"Order Details\".ProductID\r\nWHERE (((Orders.ShippedDate) Between '19970101' And '19971231'))\r\nGROUP BY Categories.CategoryName, Products.ProductName","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Product Sales for 1997"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34482","object_id":"column-34482","name":"CategoryName","name_without_path":"CategoryName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34483","object_id":"column-34483","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34484","object_id":"column-34484","name":"ProductSales","name_without_path":"ProductSales","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Product Sales for 1997","object_name_show_schema":"dbo.Product Sales for 1997","object_type":"VIEW","object_id":"v3741","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Categories","object_name_show_schema":"dbo.Categories","object_type":"TABLE","object_id":"t3719","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[{"object_name":"Product Sales for 1997","object_name_show_schema":"dbo.Product Sales for 1997","object_type":"VIEW","object_id":"v3741","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Category Sales for 1997","object_name_show_schema":"dbo.Category Sales for 1997","object_type":"VIEW","object_id":"v3734","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"p136": {"parameters_custom_fields":[],"object_id":"p136","name":"CustOrdersDetail","subtype":"PROCEDURE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"CustOrdersDetail"},{"field":"Type","value":"Procedure"}],"script":"CREATE PROCEDURE CustOrdersDetail @OrderID int\r\nAS\r\nSELECT ProductName,\r\n UnitPrice=ROUND(Od.UnitPrice, 2),\r\n Quantity,\r\n Discount=CONVERT(int, Discount * 100), \r\n ExtendedPrice=ROUND(CONVERT(money, Quantity * (1 - Discount) * Od.UnitPrice), 2)\r\nFROM Products P, [Order Details] Od\r\nWHERE Od.ProductID = P.ProductID and Od.OrderID = @OrderID","parameters":[{"name":"OrderID","description":null,"mode":"IN","data_type":"int","custom_fields":{}}],"dependencies":{"uses":[{"object_name":"CustOrdersDetail","object_name_show_schema":"dbo.CustOrdersDetail","object_type":"PROCEDURE","object_id":"p136","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3742": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3742","name":"Products Above Average Price","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Products Above Average Price\" AS\r\nSELECT Products.ProductName, Products.UnitPrice\r\nFROM Products\r\nWHERE Products.UnitPrice>(SELECT AVG(UnitPrice) From Products)\r\n--ORDER BY Products.UnitPrice DESC","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Products Above Average Price"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34485","object_id":"column-34485","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34486","object_id":"column-34486","name":"UnitPrice","name_without_path":"UnitPrice","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Products Above Average Price","object_name_show_schema":"dbo.Products Above Average Price","object_type":"VIEW","object_id":"v3742","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3743": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3743","name":"Products by Category","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Products by Category\" AS\r\nSELECT Categories.CategoryName, Products.ProductName, Products.QuantityPerUnit, Products.UnitsInStock, Products.Discontinued\r\nFROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID\r\nWHERE Products.Discontinued <> 1\r\n--ORDER BY Categories.CategoryName, Products.ProductName","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Products by Category"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34487","object_id":"column-34487","name":"CategoryName","name_without_path":"CategoryName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34488","object_id":"column-34488","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34489","object_id":"column-34489","name":"QuantityPerUnit","name_without_path":"QuantityPerUnit","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"20","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34490","object_id":"column-34490","name":"UnitsInStock","name_without_path":"UnitsInStock","description":null,"is_pk":false,"is_identity":false,"data_type":"smallint","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34491","object_id":"column-34491","name":"Discontinued","name_without_path":"Discontinued","description":null,"is_pk":false,"is_identity":false,"data_type":"bit","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Products by Category","object_name_show_schema":"dbo.Products by Category","object_type":"VIEW","object_id":"v3743","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Categories","object_name_show_schema":"dbo.Categories","object_type":"TABLE","object_id":"t3719","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3738": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3738","name":"Order Details Extended","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Order Details Extended\" AS\r\nSELECT \"Order Details\".OrderID, \"Order Details\".ProductID, Products.ProductName, \r\n\t\"Order Details\".UnitPrice, \"Order Details\".Quantity, \"Order Details\".Discount, \r\n\t(CONVERT(money,(\"Order Details\".UnitPrice*Quantity*(1-Discount)/100))*100) AS ExtendedPrice\r\nFROM Products INNER JOIN \"Order Details\" ON Products.ProductID = \"Order Details\".ProductID\r\n--ORDER BY \"Order Details\".OrderID","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Order Details Extended"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34453","object_id":"column-34453","name":"OrderID","name_without_path":"OrderID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34454","object_id":"column-34454","name":"ProductID","name_without_path":"ProductID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34455","object_id":"column-34455","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34456","object_id":"column-34456","name":"UnitPrice","name_without_path":"UnitPrice","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34457","object_id":"column-34457","name":"Quantity","name_without_path":"Quantity","description":null,"is_pk":false,"is_identity":false,"data_type":"smallint","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34458","object_id":"column-34458","name":"Discount","name_without_path":"Discount","description":null,"is_pk":false,"is_identity":false,"data_type":"real","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34459","object_id":"column-34459","name":"ExtendedPrice","name_without_path":"ExtendedPrice","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Order Details Extended","object_name_show_schema":"dbo.Order Details Extended","object_type":"VIEW","object_id":"v3738","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[{"object_name":"Order Details Extended","object_name_show_schema":"dbo.Order Details Extended","object_type":"VIEW","object_id":"v3738","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Sales by Category","object_name_show_schema":"dbo.Sales by Category","object_type":"VIEW","object_id":"v3745","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"p137": {"parameters_custom_fields":[],"object_id":"p137","name":"CustOrdersOrders","subtype":"PROCEDURE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"CustOrdersOrders"},{"field":"Type","value":"Procedure"}],"script":"CREATE PROCEDURE CustOrdersOrders @CustomerID nchar(5)\r\nAS\r\nSELECT OrderID, \r\n\tOrderDate,\r\n\tRequiredDate,\r\n\tShippedDate\r\nFROM Orders\r\nWHERE CustomerID = @CustomerID\r\nORDER BY OrderID","parameters":[{"name":"CustomerID","description":null,"mode":"IN","data_type":"nchar(5)","custom_fields":{}}],"dependencies":{"uses":[{"object_name":"CustOrdersOrders","object_name_show_schema":"dbo.CustOrdersOrders","object_type":"PROCEDURE","object_id":"p137","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3739": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3739","name":"Order Subtotals","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Order Subtotals\" AS\r\nSELECT \"Order Details\".OrderID, Sum(CONVERT(money,(\"Order Details\".UnitPrice*Quantity*(1-Discount)/100))*100) AS Subtotal\r\nFROM \"Order Details\"\r\nGROUP BY \"Order Details\".OrderID","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Order Subtotals"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34460","object_id":"column-34460","name":"OrderID","name_without_path":"OrderID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34461","object_id":"column-34461","name":"Subtotal","name_without_path":"Subtotal","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Order Subtotals","object_name_show_schema":"dbo.Order Subtotals","object_type":"VIEW","object_id":"v3739","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[{"object_name":"Order Subtotals","object_name_show_schema":"dbo.Order Subtotals","object_type":"VIEW","object_id":"v3739","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Sales Totals by Amount","object_name_show_schema":"dbo.Sales Totals by Amount","object_type":"VIEW","object_id":"v3746","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Summary of Sales by Quarter","object_name_show_schema":"dbo.Summary of Sales by Quarter","object_type":"VIEW","object_id":"v3747","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Summary of Sales by Year","object_name_show_schema":"dbo.Summary of Sales by Year","object_type":"VIEW","object_id":"v3748","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Employee Sales by Country","object_name_show_schema":"dbo.Employee Sales by Country","object_type":"PROCEDURE","object_id":"p138","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Sales by Year","object_name_show_schema":"dbo.Sales by Year","object_type":"PROCEDURE","object_id":"p139","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"p138": {"parameters_custom_fields":[],"object_id":"p138","name":"Employee Sales by Country","subtype":"PROCEDURE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Employee Sales by Country"},{"field":"Type","value":"Procedure"}],"script":"create procedure \"Employee Sales by Country\" \r\n@Beginning_Date DateTime, @Ending_Date DateTime AS\r\nSELECT Employees.Country, Employees.LastName, Employees.FirstName, Orders.ShippedDate, Orders.OrderID, \"Order Subtotals\".Subtotal AS SaleAmount\r\nFROM Employees INNER JOIN \r\n\t(Orders INNER JOIN \"Order Subtotals\" ON Orders.OrderID = \"Order Subtotals\".OrderID) \r\n\tON Employees.EmployeeID = Orders.EmployeeID\r\nWHERE Orders.ShippedDate Between @Beginning_Date And @Ending_Date","parameters":[{"name":"Beginning_Date","description":null,"mode":"IN","data_type":"datetime","custom_fields":{}},{"name":"Ending_Date","description":null,"mode":"IN","data_type":"datetime","custom_fields":{}}],"dependencies":{"uses":[{"object_name":"Employee Sales by Country","object_name_show_schema":"dbo.Employee Sales by Country","object_type":"PROCEDURE","object_id":"p138","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Employees","object_name_show_schema":"dbo.Employees","object_type":"TABLE","object_id":"t3724","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Subtotals","object_name_show_schema":"dbo.Order Subtotals","object_type":"VIEW","object_id":"v3739","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3749": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3749","name":"topfiveproducts","subtype":"VIEW","is_user_defined":false,"description":null,"script":"/****** Script for SelectTopNRows command from SSMS ******/\r\ncreate view topfiveproducts as\r\n\r\nSELECT top 5 ProductID, ProductName, UnitPrice from Products\r\norder by unitprice ASC , UnitsInStock desc\r\n\r\n\r\n\r\n/*لیست مشتریانی که در سال 1996 از ما خرید داشتند\r\nفقط customer_id\r\n\r\n*/","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"topfiveproducts"},{"field":"Type","value":"View"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34510","object_id":"column-34510","name":"ProductID","name_without_path":"ProductID","description":null,"is_pk":false,"is_identity":true,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34511","object_id":"column-34511","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34512","object_id":"column-34512","name":"UnitPrice","name_without_path":"UnitPrice","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"topfiveproducts","object_name_show_schema":"dbo.topfiveproducts","object_type":"VIEW","object_id":"v3749","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3740": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3740","name":"Orders Qry","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Orders Qry\" AS\r\nSELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, \r\n\tOrders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, \r\n\tOrders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry, \r\n\tCustomers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country\r\nFROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Orders Qry"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34462","object_id":"column-34462","name":"OrderID","name_without_path":"OrderID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34463","object_id":"column-34463","name":"CustomerID","name_without_path":"CustomerID","description":null,"is_pk":false,"is_identity":false,"data_type":"nchar","data_length":"5","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34464","object_id":"column-34464","name":"EmployeeID","name_without_path":"EmployeeID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34465","object_id":"column-34465","name":"OrderDate","name_without_path":"OrderDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34466","object_id":"column-34466","name":"RequiredDate","name_without_path":"RequiredDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34467","object_id":"column-34467","name":"ShippedDate","name_without_path":"ShippedDate","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34468","object_id":"column-34468","name":"ShipVia","name_without_path":"ShipVia","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34469","object_id":"column-34469","name":"Freight","name_without_path":"Freight","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34470","object_id":"column-34470","name":"ShipName","name_without_path":"ShipName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34471","object_id":"column-34471","name":"ShipAddress","name_without_path":"ShipAddress","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"60","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34472","object_id":"column-34472","name":"ShipCity","name_without_path":"ShipCity","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34473","object_id":"column-34473","name":"ShipRegion","name_without_path":"ShipRegion","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34474","object_id":"column-34474","name":"ShipPostalCode","name_without_path":"ShipPostalCode","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"10","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34475","object_id":"column-34475","name":"ShipCountry","name_without_path":"ShipCountry","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34476","object_id":"column-34476","name":"CompanyName","name_without_path":"CompanyName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34477","object_id":"column-34477","name":"Address","name_without_path":"Address","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"60","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34478","object_id":"column-34478","name":"City","name_without_path":"City","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34479","object_id":"column-34479","name":"Region","name_without_path":"Region","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34480","object_id":"column-34480","name":"PostalCode","name_without_path":"PostalCode","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"10","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34481","object_id":"column-34481","name":"Country","name_without_path":"Country","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Orders Qry","object_name_show_schema":"dbo.Orders Qry","object_type":"VIEW","object_id":"v3740","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Customers","object_name_show_schema":"dbo.Customers","object_type":"TABLE","object_id":"t3722","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"p140": {"parameters_custom_fields":[],"object_id":"p140","name":"SalesByCategory","subtype":"PROCEDURE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"SalesByCategory"},{"field":"Type","value":"Procedure"}],"script":"CREATE PROCEDURE SalesByCategory\r\n @CategoryName nvarchar(15), @OrdYear nvarchar(4) = '1998'\r\nAS\r\nIF @OrdYear != '1996' AND @OrdYear != '1997' AND @OrdYear != '1998' \r\nBEGIN\r\n\tSELECT @OrdYear = '1998'\r\nEND\r\n\r\nSELECT ProductName,\r\n\tTotalPurchase=ROUND(SUM(CONVERT(decimal(14,2), OD.Quantity * (1-OD.Discount) * OD.UnitPrice)), 0)\r\nFROM [Order Details] OD, Orders O, Products P, Categories C\r\nWHERE OD.OrderID = O.OrderID \r\n\tAND OD.ProductID = P.ProductID \r\n\tAND P.CategoryID = C.CategoryID\r\n\tAND C.CategoryName = @CategoryName\r\n\tAND SUBSTRING(CONVERT(nvarchar(22), O.OrderDate, 111), 1, 4) = @OrdYear\r\nGROUP BY ProductName\r\nORDER BY ProductName","parameters":[{"name":"CategoryName","description":null,"mode":"IN","data_type":"nvarchar(15)","custom_fields":{}},{"name":"OrdYear","description":null,"mode":"IN","data_type":"nvarchar(4)","custom_fields":{}}],"dependencies":{"uses":[{"object_name":"SalesByCategory","object_name_show_schema":"dbo.SalesByCategory","object_type":"PROCEDURE","object_id":"p140","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Categories","object_name_show_schema":"dbo.Categories","object_type":"TABLE","object_id":"t3719","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"p141": {"parameters_custom_fields":[],"object_id":"p141","name":"Ten Most Expensive Products","subtype":"PROCEDURE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Ten Most Expensive Products"},{"field":"Type","value":"Procedure"}],"script":"create procedure \"Ten Most Expensive Products\" AS\r\nSET ROWCOUNT 10\r\nSELECT Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice\r\nFROM Products\r\nORDER BY Products.UnitPrice DESC","parameters":[],"dependencies":{"uses":[{"object_name":"Ten Most Expensive Products","object_name_show_schema":"dbo.Ten Most Expensive Products","object_type":"PROCEDURE","object_id":"p141","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"f132": {"parameters_custom_fields":[],"object_id":"f132","name":"fn_calcvat","subtype":"FUNCTION","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"fn_calcvat"},{"field":"Type","value":"Function"}],"script":"Create Function fn_calcvat(@unitprice money)\r\nreturns money\r\nas\r\nbegin\r\nReturn (@unitprice*0.09)\r\nEnd","parameters":[{"name":"Returns","description":null,"mode":"OUT","data_type":"money","custom_fields":{}},{"name":"unitprice","description":null,"mode":"IN","data_type":"money","custom_fields":{}}],"dependencies":{"uses":[],"used_by":[]},"imported_at":"2024-02-29 21:36"},"f133": {"parameters_custom_fields":[],"object_id":"f133","name":"Fn_ParseJson","subtype":"FUNCTION","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Fn_ParseJson"},{"field":"Type","value":"Function"}],"script":"CREATE FUNCTION dbo.Fn_ParseJson\r\n(\r\n @StartTime DATETIME,\r\n @EndTime DATETIME\r\n)\r\nRETURNS TABLE\r\nAS\r\nRETURN\r\n(\r\n SELECT JSON_VALUE(data, '$.DeviceName') AS DeviceName, cast(JSON_VALUE(data, '$.ProductionAmount') as int) AS Productamount\r\n\tfrom dbo.device\r\n\r\n WHERE productiondatetime >= @StartTime AND productiondatetime <= @EndTime\r\n\r\n);","parameters":[{"name":"Returns","description":null,"mode":"OUT","data_type":"table type","custom_fields":{}},{"name":"StartTime","description":null,"mode":"IN","data_type":"datetime","custom_fields":{}},{"name":"EndTime","description":null,"mode":"IN","data_type":"datetime","custom_fields":{}}],"dependencies":{"uses":[{"object_name":"Fn_ParseJson","object_name_show_schema":"dbo.Fn_ParseJson","object_type":"FUNCTION","object_id":"f133","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"device","object_name_show_schema":"dbo.device","object_type":"TABLE","object_id":"t3723","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"f134": {"parameters_custom_fields":[],"object_id":"f134","name":"GetQueryResultByTimeRange","subtype":"FUNCTION","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"GetQueryResultByTimeRange"},{"field":"Type","value":"Function"}],"script":"CREATE FUNCTION dbo.GetQueryResultByTimeRange\r\n(\r\n @StartTime DATETIME,\r\n @EndTime DATETIME\r\n)\r\nRETURNS TABLE\r\nAS\r\nRETURN\r\n(\r\n SELECT *\r\n FROM dbo.device\r\n WHERE productiondatetime >= @StartTime AND productiondatetime <= @EndTime\r\n);","parameters":[{"name":"Returns","description":null,"mode":"OUT","data_type":"table type","custom_fields":{}},{"name":"StartTime","description":null,"mode":"IN","data_type":"datetime","custom_fields":{}},{"name":"EndTime","description":null,"mode":"IN","data_type":"datetime","custom_fields":{}}],"dependencies":{"uses":[{"object_name":"GetQueryResultByTimeRange","object_name_show_schema":"dbo.GetQueryResultByTimeRange","object_type":"FUNCTION","object_id":"f134","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"device","object_name_show_schema":"dbo.device","object_type":"TABLE","object_id":"t3723","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"p139": {"parameters_custom_fields":[],"object_id":"p139","name":"Sales by Year","subtype":"PROCEDURE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Sales by Year"},{"field":"Type","value":"Procedure"}],"script":"create procedure \"Sales by Year\" \r\n\t@Beginning_Date DateTime, @Ending_Date DateTime AS\r\nSELECT Orders.ShippedDate, Orders.OrderID, \"Order Subtotals\".Subtotal, DATENAME(yy,ShippedDate) AS Year\r\nFROM Orders INNER JOIN \"Order Subtotals\" ON Orders.OrderID = \"Order Subtotals\".OrderID\r\nWHERE Orders.ShippedDate Between @Beginning_Date And @Ending_Date","parameters":[{"name":"Beginning_Date","description":null,"mode":"IN","data_type":"datetime","custom_fields":{}},{"name":"Ending_Date","description":null,"mode":"IN","data_type":"datetime","custom_fields":{}}],"dependencies":{"uses":[{"object_name":"Sales by Year","object_name_show_schema":"dbo.Sales by Year","object_type":"PROCEDURE","object_id":"p139","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Subtotals","object_name_show_schema":"dbo.Order Subtotals","object_type":"VIEW","object_id":"v3739","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3744": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3744","name":"Quarterly Orders","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Quarterly Orders\" AS\r\nSELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country\r\nFROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID\r\nWHERE Orders.OrderDate BETWEEN '19970101' And '19971231'","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Quarterly Orders"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34492","object_id":"column-34492","name":"CustomerID","name_without_path":"CustomerID","description":null,"is_pk":false,"is_identity":false,"data_type":"nchar","data_length":"5","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34493","object_id":"column-34493","name":"CompanyName","name_without_path":"CompanyName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34494","object_id":"column-34494","name":"City","name_without_path":"City","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34495","object_id":"column-34495","name":"Country","name_without_path":"Country","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Quarterly Orders","object_name_show_schema":"dbo.Quarterly Orders","object_type":"VIEW","object_id":"v3744","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Customers","object_name_show_schema":"dbo.Customers","object_type":"TABLE","object_id":"t3722","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3745": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3745","name":"Sales by Category","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Sales by Category\" AS\r\nSELECT Categories.CategoryID, Categories.CategoryName, Products.ProductName, \r\n\tSum(\"Order Details Extended\".ExtendedPrice) AS ProductSales\r\nFROM \tCategories INNER JOIN \r\n\t\t(Products INNER JOIN \r\n\t\t\t(Orders INNER JOIN \"Order Details Extended\" ON Orders.OrderID = \"Order Details Extended\".OrderID) \r\n\t\tON Products.ProductID = \"Order Details Extended\".ProductID) \r\n\tON Categories.CategoryID = Products.CategoryID\r\nWHERE Orders.OrderDate BETWEEN '19970101' And '19971231'\r\nGROUP BY Categories.CategoryID, Categories.CategoryName, Products.ProductName\r\n--ORDER BY Products.ProductName","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Sales by Category"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34496","object_id":"column-34496","name":"CategoryID","name_without_path":"CategoryID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34497","object_id":"column-34497","name":"CategoryName","name_without_path":"CategoryName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34498","object_id":"column-34498","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34499","object_id":"column-34499","name":"ProductSales","name_without_path":"ProductSales","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Sales by Category","object_name_show_schema":"dbo.Sales by Category","object_type":"VIEW","object_id":"v3745","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Categories","object_name_show_schema":"dbo.Categories","object_type":"TABLE","object_id":"t3719","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Details Extended","object_name_show_schema":"dbo.Order Details Extended","object_type":"VIEW","object_id":"v3738","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"p135": {"parameters_custom_fields":[],"object_id":"p135","name":"CustOrderHist","subtype":"PROCEDURE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"CustOrderHist"},{"field":"Type","value":"Procedure"}],"script":"CREATE PROCEDURE CustOrderHist @CustomerID nchar(5)\r\nAS\r\nSELECT ProductName, Total=SUM(Quantity)\r\nFROM Products P, [Order Details] OD, Orders O, Customers C\r\nWHERE C.CustomerID = @CustomerID\r\nAND C.CustomerID = O.CustomerID AND O.OrderID = OD.OrderID AND OD.ProductID = P.ProductID\r\nGROUP BY ProductName","parameters":[{"name":"CustomerID","description":null,"mode":"IN","data_type":"nchar(5)","custom_fields":{}}],"dependencies":{"uses":[{"object_name":"CustOrderHist","object_name_show_schema":"dbo.CustOrderHist","object_type":"PROCEDURE","object_id":"p135","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Customers","object_name_show_schema":"dbo.Customers","object_type":"TABLE","object_id":"t3722","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3750": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3750","name":"toptenproducts","subtype":"VIEW","is_user_defined":false,"description":null,"script":"/****** Script for SelectTopNRows command from SSMS ******/\r\ncreate view toptenproducts as\r\n\r\nSELECT top 10 ProductID, ProductName, UnitPrice ,unitprice*0.09 as vat\r\nfrom Products\r\norder by unitprice ASC , UnitsInStock desc\r\n\r\n\r\n\r\n/*لیست مشتریانی که در سال 1996 از ما خرید داشتند\r\nفقط customer_id\r\n\r\n*/","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"toptenproducts"},{"field":"Type","value":"View"},{"field":"Module","value":[{"_type":"link","name":"Diagram","id":"m107"}]}],"columns":[{"id":"column-34513","object_id":"column-34513","name":"ProductID","name_without_path":"ProductID","description":null,"is_pk":false,"is_identity":true,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34514","object_id":"column-34514","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34515","object_id":"column-34515","name":"UnitPrice","name_without_path":"UnitPrice","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34516","object_id":"column-34516","name":"vat","name_without_path":"vat","description":null,"is_pk":false,"is_identity":false,"data_type":"numeric","data_length":"22, 6","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"toptenproducts","object_name_show_schema":"dbo.toptenproducts","object_type":"VIEW","object_id":"v3750","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"t3723": {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3723","name":"Device","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Device"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-34335","object_id":"column-34335","name":"ID","name_without_path":"ID","description":null,"is_pk":true,"is_identity":true,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34336","object_id":"column-34336","name":"Data","name_without_path":"Data","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"MAX","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34337","object_id":"column-34337","name":"ProductionDateTime","name_without_path":"ProductionDateTime","description":null,"is_pk":false,"is_identity":false,"data_type":"datetime","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"unique_keys":[{"name":"PK__Device__3214EC27C6C95DF4","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"ID","name":"ID"}],"custom_fields":{}}],"triggers":[],"dependencies":{"uses":[],"used_by":[{"object_name":"Device","object_name_show_schema":"dbo.Device","object_type":"TABLE","object_id":"t3723","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Fn_ParseJson","object_name_show_schema":"dbo.Fn_ParseJson","object_type":"FUNCTION","object_id":"f133","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"GetQueryResultByTimeRange","object_name_show_schema":"dbo.GetQueryResultByTimeRange","object_type":"FUNCTION","object_id":"f134","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]},"imported_at":"2024-02-29 21:36"},"v3733": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3733","name":"Alphabetical list of products","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Alphabetical list of products\" AS\r\nSELECT Products.*, Categories.CategoryName\r\nFROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID\r\nWHERE (((Products.Discontinued)=0))","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Alphabetical list of products"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34408","object_id":"column-34408","name":"ProductID","name_without_path":"ProductID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34409","object_id":"column-34409","name":"ProductName","name_without_path":"ProductName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"40","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34410","object_id":"column-34410","name":"SupplierID","name_without_path":"SupplierID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34411","object_id":"column-34411","name":"CategoryID","name_without_path":"CategoryID","description":null,"is_pk":false,"is_identity":false,"data_type":"int","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34412","object_id":"column-34412","name":"QuantityPerUnit","name_without_path":"QuantityPerUnit","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"20","is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34413","object_id":"column-34413","name":"UnitPrice","name_without_path":"UnitPrice","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34414","object_id":"column-34414","name":"UnitsInStock","name_without_path":"UnitsInStock","description":null,"is_pk":false,"is_identity":false,"data_type":"smallint","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34415","object_id":"column-34415","name":"UnitsOnOrder","name_without_path":"UnitsOnOrder","description":null,"is_pk":false,"is_identity":false,"data_type":"smallint","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34416","object_id":"column-34416","name":"ReorderLevel","name_without_path":"ReorderLevel","description":null,"is_pk":false,"is_identity":false,"data_type":"smallint","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34417","object_id":"column-34417","name":"Discontinued","name_without_path":"Discontinued","description":null,"is_pk":false,"is_identity":false,"data_type":"bit","data_length":null,"is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34418","object_id":"column-34418","name":"CategoryName","name_without_path":"CategoryName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Alphabetical list of products","object_name_show_schema":"dbo.Alphabetical list of products","object_type":"VIEW","object_id":"v3733","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Categories","object_name_show_schema":"dbo.Categories","object_type":"TABLE","object_id":"t3719","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},"v3734": {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v3734","name":"Category Sales for 1997","subtype":"VIEW","is_user_defined":false,"description":null,"script":"create view \"Category Sales for 1997\" AS\r\nSELECT \"Product Sales for 1997\".CategoryName, Sum(\"Product Sales for 1997\".ProductSales) AS CategorySales\r\nFROM \"Product Sales for 1997\"\r\nGROUP BY \"Product Sales for 1997\".CategoryName","summary":[{"field":"Documentation","value":{"_type":"link","name":"Northwind","id":"d7"}},{"field":"Schema","value":"dbo"},{"field":"Name","value":"Category Sales for 1997"},{"field":"Type","value":"View"}],"columns":[{"id":"column-34419","object_id":"column-34419","name":"CategoryName","name_without_path":"CategoryName","description":null,"is_pk":false,"is_identity":false,"data_type":"nvarchar","data_length":"15","is_nullable":false,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]},{"id":"column-34420","object_id":"column-34420","name":"CategorySales","name_without_path":"CategorySales","description":null,"is_pk":false,"is_identity":false,"data_type":"money","data_length":null,"is_nullable":true,"computed_formula":null,"default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":null,"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":{"uses":[{"object_name":"Category Sales for 1997","object_name_show_schema":"dbo.Category Sales for 1997","object_type":"VIEW","object_id":"v3734","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Product Sales for 1997","object_name_show_schema":"dbo.Product Sales for 1997","object_type":"VIEW","object_id":"v3741","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[{"object_name":"Categories","object_name_show_schema":"dbo.Categories","object_type":"TABLE","object_id":"t3719","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Order Details","object_name_show_schema":"dbo.Order Details","object_type":"TABLE","object_id":"t3726","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Orders","object_name_show_schema":"dbo.Orders","object_type":"TABLE","object_id":"t3727","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]},{"object_name":"Products","object_name_show_schema":"dbo.Products","object_type":"TABLE","object_id":"t3728","type":"NORMAL","object_user_defined":false,"user_defined":false,"children":[]}]}]}],"used_by":[]},"imported_at":"2024-02-29 21:36"},}};