<?xml version='1.0' encoding='utf-8'?>
<businessmodels>
<model name="NorthwindCategories">
<attributes database="northwind" table="Categories" qualified="northwind.categories">
<attribute name="CategoryID" type="int" size="11" required="true" primary_key="true"></attribute>
<attribute name="CategoryName" type="varchar" size="15"></attribute>
<attribute name="Description" type="text" maxLength="65535"></attribute>
<attribute name="Picture" type="varchar" size="40"></attribute>
</attributes>
</model>
<model name="NorthwindCountry">
<attributes database="northwind" table="Country" qualified="northwind.country">
<attribute name="id" type="int" size="11" required="true" primary_key="true"></attribute>
<attribute name="Code" type="char" size="3" required="true"></attribute>
<attribute name="Name" type="char" size="52" required="true"></attribute>
<attribute name="Continent" type="enum" required="true" default="'Asia','Europe','North America','Africa','Oceania','Antarctica','South America'"></attribute>
<attribute name="SurfaceArea" type="float" size="10" required="true" default="1"></attribute>
<attribute name="Population" type="int" size="11" required="true" default="1"></attribute>
<attribute name="LocalName" type="char" size="45" required="true"></attribute>
</attributes>
</model>
<model name="NorthwindCustomers">
<attributes database="northwind" table="Customers" qualified="northwind.customers">
<attribute name="CustomerID" type="varchar" size="5" required="true" primary_key="true"></attribute>
<attribute name="CompanyName" type="varchar" size="40"></attribute>
<attribute name="ContactName" type="varchar" size="30"></attribute>
<attribute name="ContactTitle" type="varchar" size="30"></attribute>
<attribute name="Address" type="varchar" size="60"></attribute>
<attribute name="City" type="varchar" size="15"></attribute>
<attribute name="Region" type="varchar" size="15"></attribute>
<attribute name="PostalCode" type="varchar" size="10"></attribute>
<attribute name="Country" type="varchar" size="15"></attribute>
<attribute name="Phone" type="varchar" size="24"></attribute>
<attribute name="Fax" type="varchar" size="24"></attribute>
</attributes>
</model>
<model name="NorthwindEmployees">
<attributes database="northwind" table="Employees" qualified="northwind.employees">
<attribute name="EmployeeID" type="int" size="11" required="true" primary_key="true"></attribute>
<attribute name="LastName" type="varchar" size="20"></attribute>
<attribute name="FirstName" type="varchar" size="10"></attribute>
<attribute name="Title" type="varchar" size="30"></attribute>
<attribute name="TitleOfCourtesy" type="varchar" size="25"></attribute>
<attribute name="BirthDate" type="date"></attribute>
<attribute name="HireDate" type="date"></attribute>
<attribute name="Address" type="varchar" size="60"></attribute>
<attribute name="City" type="varchar" size="15"></attribute>
<attribute name="Region" type="varchar" size="15"></attribute>
<attribute name="PostalCode" type="varchar" size="10"></attribute>
<attribute name="Country" type="varchar" size="15"></attribute>
<attribute name="HomePhone" type="varchar" size="24"></attribute>
<attribute name="Extension" type="varchar" size="4"></attribute>
<attribute name="Photo" type="varchar" size="40"></attribute>
<attribute name="Notes" type="text" maxLength="65535"></attribute>
<attribute name="ReportsTo" type="int" size="11"></attribute>
</attributes>
</model>
<model name="NorthwindOrderDetails">
<attributes database="northwind" table="OrderDetails" qualified="northwind.order_details">
<attribute name="odID" type="int" size="10" required="true" primary_key="true"></attribute>
<attribute name="OrderID" type="int" size="11" default="1"></attribute>
<attribute name="ProductID" type="int" size="11" default="1"></attribute>
<attribute name="UnitPrice" type="float" size="1" default="1"></attribute>
<attribute name="Quantity" type="smallint" size="6" default="1"></attribute>
<attribute name="Discount" type="float" size="1" default="1"></attribute>
</attributes>
</model>
<model name="NorthwindOrders">
<attributes database="northwind" table="Orders" qualified="northwind.orders">
<attribute name="OrderID" type="int" size="11" required="true" primary_key="true"></attribute>
<attribute name="CustomerID" type="varchar" size="5"></attribute>
<attribute name="EmployeeID" type="int" size="11"></attribute>
<attribute name="OrderDate" type="date"></attribute>
<attribute name="RequiredDate" type="date"></attribute>
<attribute name="ShippedDate" type="date"></attribute>
<attribute name="ShipVia" type="int" size="11"></attribute>
<attribute name="Freight" type="float" size="1" default="1"></attribute>
<attribute name="ShipName" type="varchar" size="40"></attribute>
<attribute name="ShipAddress" type="varchar" size="60"></attribute>
<attribute name="ShipCity" type="varchar" size="15"></attribute>
<attribute name="ShipRegion" type="varchar" size="15"></attribute>
<attribute name="ShipPostalCode" type="varchar" size="10"></attribute>
<attribute name="ShipCountry" type="varchar" size="15"></attribute>
</attributes>
</model>
<model name="NorthwindProducts">
<attributes database="northwind" table="Products" qualified="northwind.products">
<attribute name="ProductID" type="int" size="11" required="true" primary_key="true"></attribute>
<attribute name="ProductName" type="varchar" size="40"></attribute>
<attribute name="SupplierID" type="int" size="11"></attribute>
<attribute name="CategoryID" type="int" size="11"></attribute>
<attribute name="QuantityPerUnit" type="varchar" size="20"></attribute>
<attribute name="UnitPrice" type="float" size="1" default="1"></attribute>
<attribute name="UnitsInStock" type="smallint" size="6" default="1"></attribute>
<attribute name="UnitsOnOrder" type="smallint" size="6" default="1"></attribute>
<attribute name="ReorderLevel" type="smallint" size="6" default="1"></attribute>
<attribute name="Discontinued" type="tinyint" size="1" default="1"></attribute>
</attributes>
</model>
<model name="NorthwindShippers">
<attributes database="northwind" table="Shippers" qualified="northwind.shippers">
<attribute name="ShipperID" type="int" size="11" required="true" primary_key="true"></attribute>
<attribute name="CompanyName" type="varchar" size="40"></attribute>
<attribute name="Phone" type="varchar" size="24"></attribute>
</attributes>
</model>
<model name="NorthwindSuppliers">
<attributes database="northwind" table="Suppliers" qualified="northwind.suppliers">
<attribute name="SupplierID" type="int" size="11" required="true" primary_key="true"></attribute>
<attribute name="CompanyName" type="varchar" size="40"></attribute>
<attribute name="ContactName" type="varchar" size="30"></attribute>
<attribute name="ContactTitle" type="varchar" size="30"></attribute>
<attribute name="Address" type="varchar" size="60"></attribute>
<attribute name="City" type="varchar" size="15"></attribute>
<attribute name="Region" type="varchar" size="15"></attribute>
<attribute name="PostalCode" type="varchar" size="10"></attribute>
<attribute name="Country" type="varchar" size="15"></attribute>
<attribute name="Phone" type="varchar" size="24"></attribute>
<attribute name="Fax" type="varchar" size="24"></attribute>
<attribute name="HomePage" type="text" maxLength="65535"></attribute>
</attributes>
</model>
</businessmodels>
|
Download
