-
Notifications
You must be signed in to change notification settings - Fork 0
/
data.json.js
1 lines (1 loc) · 15.1 KB
/
data.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": { _ref: "data/d7.json.js" },"d7m": { _ref: "data/d7m.json.js" },"d7t": { _ref: "data/d7t.json.js" },"d7v": { _ref: "data/d7v.json.js" },"d7p": { _ref: "data/d7p.json.js" },"d7f": { _ref: "data/d7f.json.js" },"m107t": { _ref: "data/m107t.json.js" },"m107v": { _ref: "data/m107v.json.js" },"t3729": { _ref: "data/t3729.json.js" },"v3748": { _ref: "data/v3748.json.js" },"t3722": { _ref: "data/t3722.json.js" },"t3719": { _ref: "data/t3719.json.js" },"t3724": { _ref: "data/t3724.json.js" },"v3749": { _ref: "data/v3749.json.js" },"t3720": { _ref: "data/t3720.json.js" },"t3725": { _ref: "data/t3725.json.js" },"t3721": { _ref: "data/t3721.json.js" },"t3730": { _ref: "data/t3730.json.js" },"t3731": { _ref: "data/t3731.json.js" },"m107": { _ref: "data/m107.json.js" },"v3750": { _ref: "data/v3750.json.js" },"t3723": { _ref: "data/t3723.json.js" },"t3732": { _ref: "data/t3732.json.js" },"t3726": { _ref: "data/t3726.json.js" },"v3733": { _ref: "data/v3733.json.js" },"v3734": { _ref: "data/v3734.json.js" },"t3727": { _ref: "data/t3727.json.js" },"v3746": { _ref: "data/v3746.json.js" },"v3735": { _ref: "data/v3735.json.js" },"v3739": { _ref: "data/v3739.json.js" },"t3728": { _ref: "data/t3728.json.js" },"v3747": { _ref: "data/v3747.json.js" },"v3736": { _ref: "data/v3736.json.js" },"v3741": { _ref: "data/v3741.json.js" },"v3740": { _ref: "data/v3740.json.js" },"p136": { _ref: "data/p136.json.js" },"p137": { _ref: "data/p137.json.js" },"f132": { _ref: "data/f132.json.js" },"v3742": { _ref: "data/v3742.json.js" },"p138": { _ref: "data/p138.json.js" },"v3737": { _ref: "data/v3737.json.js" },"v3743": { _ref: "data/v3743.json.js" },"p139": { _ref: "data/p139.json.js" },"f133": { _ref: "data/f133.json.js" },"f134": { _ref: "data/f134.json.js" },"p140": { _ref: "data/p140.json.js" },"v3738": { _ref: "data/v3738.json.js" },"p141": { _ref: "data/p141.json.js" },"v3744": { _ref: "data/v3744.json.js" },"v3745": { _ref: "data/v3745.json.js" },"p135": { _ref: "data/p135.json.js" },}};