mcs/class/System.Data.Linq/tests/expected/Northwind.Sqlite+DbSchemaLoader-sqlmetal.dbml

   1 <?xml version="1.0"?>\r
   2 <Database xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Name="main" Class="Main" BaseType="System.Data.Linq.DataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">\r
   3   <Table Name="Categories" Member="Categories">\r
   4     <Type Name="Categories">\r
   5       <Association Name="FK_Products_1" Member="Products" Storage="_products" Type="Products" ThisKey="CategoryID" OtherKey="CategoryID" DeleteRule="NO ACTION" />\r
   6       <Column Name="CategoryID" Member="CategoryID" Storage="_categoryID" Type="System.Int64" DbType="integer" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />\r
   7       <Column Name="CategoryName" Member="CategoryName" Storage="_categoryName" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="false" />\r
   8       <Column Name="Description" Member="Description" Storage="_description" Type="System.String" DbType="ntext" IsPrimaryKey="false" CanBeNull="true" />\r
   9       <Column Name="Picture" Member="Picture" Storage="_picture" Type="System.Byte[]" DbType="image" IsPrimaryKey="false" CanBeNull="true" />\r
  10     </Type>\r
  11   </Table>\r
  12   <Table Name="CustomerCustomerDemo" Member="CustomerCustomerDemo">\r
  13     <Type Name="CustomerCustomerDemo">\r
  14       <Association Name="FK_CustomerCustomerDemo_0" Member="Customers" Storage="_customers" Type="Customers" ThisKey="CustomerID" OtherKey="CustomerID" IsForeignKey="true" />\r
  15       <Association Name="FK_CustomerCustomerDemo_1" Member="CustomerDemographics" Storage="_customerDemographics" Type="CustomerDemographics" ThisKey="CustomerTypeID" OtherKey="CustomerTypeID" IsForeignKey="true" />\r
  16       <Column Name="CustomerID" Member="CustomerID" Storage="_customerID" Type="System.String" DbType="nchar" IsPrimaryKey="true" CanBeNull="false" />\r
  17       <Column Name="CustomerTypeID" Member="CustomerTypeID" Storage="_customerTypeID" Type="System.String" DbType="nchar" IsPrimaryKey="true" CanBeNull="false" />\r
  18     </Type>\r
  19   </Table>\r
  20   <Table Name="CustomerDemographics" Member="CustomerDemographics">\r
  21     <Type Name="CustomerDemographics">\r
  22       <Association Name="FK_CustomerCustomerDemo_1" Member="CustomerCustomerDemo" Storage="_customerCustomerDemo" Type="CustomerCustomerDemo" ThisKey="CustomerTypeID" OtherKey="CustomerTypeID" DeleteRule="NO ACTION" />\r
  23       <Column Name="CustomerDesc" Member="CustomerDesc" Storage="_customerDesc" Type="System.String" DbType="ntext" IsPrimaryKey="false" CanBeNull="true" />\r
  24       <Column Name="CustomerTypeID" Member="CustomerTypeID" Storage="_customerTypeID" Type="System.String" DbType="nchar" IsPrimaryKey="true" CanBeNull="false" />\r
  25     </Type>\r
  26   </Table>\r
  27   <Table Name="Customers" Member="Customers">\r
  28     <Type Name="Customers">\r
  29       <Association Name="FK_Orders_2" Member="Orders" Storage="_orders" Type="Orders" ThisKey="CustomerID" OtherKey="CustomerID" DeleteRule="NO ACTION" />\r
  30       <Association Name="FK_CustomerCustomerDemo_0" Member="CustomerCustomerDemo" Storage="_customerCustomerDemo" Type="CustomerCustomerDemo" ThisKey="CustomerID" OtherKey="CustomerID" DeleteRule="NO ACTION" />\r
  31       <Column Name="Address" Member="Address" Storage="_address" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  32       <Column Name="City" Member="City" Storage="_city" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  33       <Column Name="CompanyName" Member="CompanyName" Storage="_companyName" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="false" />\r
  34       <Column Name="ContactName" Member="ContactName" Storage="_contactName" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  35       <Column Name="ContactTitle" Member="ContactTitle" Storage="_contactTitle" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  36       <Column Name="Country" Member="Country" Storage="_country" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  37       <Column Name="CustomerID" Member="CustomerID" Storage="_customerID" Type="System.String" DbType="nchar" IsPrimaryKey="true" CanBeNull="false" />\r
  38       <Column Name="Fax" Member="Fax" Storage="_fax" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  39       <Column Name="Phone" Member="Phone" Storage="_phone" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  40       <Column Name="PostalCode" Member="PostalCode" Storage="_postalCode" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  41       <Column Name="Region" Member="Region" Storage="_region" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  42     </Type>\r
  43   </Table>\r
  44   <Table Name="Employees" Member="Employees">\r
  45     <Type Name="Employees">\r
  46       <Association Name="FK_Employees_0" Member="ReportsToEmployees" Storage="_reportsToEmployees" Type="Employees" ThisKey="ReportsTo" OtherKey="EmployeeID" IsForeignKey="true" />\r
  47       <Association Name="FK_Employees_0" Member="EmployeeIDEmployees" Storage="_employeeIdeMployees" Type="Employees" ThisKey="EmployeeID" OtherKey="ReportsTo" DeleteRule="NO ACTION" />\r
  48       <Association Name="FK_Orders_1" Member="Orders" Storage="_orders" Type="Orders" ThisKey="EmployeeID" OtherKey="EmployeeID" DeleteRule="NO ACTION" />\r
  49       <Association Name="FK_EmployeeTerritories_1" Member="EmployeeTerritories" Storage="_employeeTerritories" Type="EmployeeTerritories" ThisKey="EmployeeID" OtherKey="EmployeeID" DeleteRule="NO ACTION" />\r
  50       <Column Name="Address" Member="Address" Storage="_address" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  51       <Column Name="BirthDate" Member="BirthDate" Storage="_birthDate" Type="System.DateTime" DbType="datetime" IsPrimaryKey="false" CanBeNull="true" />\r
  52       <Column Name="City" Member="City" Storage="_city" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  53       <Column Name="Country" Member="Country" Storage="_country" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  54       <Column Name="EmployeeID" Member="EmployeeID" Storage="_employeeID" Type="System.Int64" DbType="integer" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />\r
  55       <Column Name="Extension" Member="Extension" Storage="_extension" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  56       <Column Name="FirstName" Member="FirstName" Storage="_firstName" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="false" />\r
  57       <Column Name="HireDate" Member="HireDate" Storage="_hireDate" Type="System.DateTime" DbType="datetime" IsPrimaryKey="false" CanBeNull="true" />\r
  58       <Column Name="HomePhone" Member="HomePhone" Storage="_homePhone" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  59       <Column Name="LastName" Member="LastName" Storage="_lastName" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="false" />\r
  60       <Column Name="Notes" Member="Notes" Storage="_notes" Type="System.String" DbType="ntext" IsPrimaryKey="false" CanBeNull="true" />\r
  61       <Column Name="Photo" Member="Photo" Storage="_photo" Type="System.Byte[]" DbType="image" IsPrimaryKey="false" CanBeNull="true" />\r
  62       <Column Name="PhotoPath" Member="PhotoPath" Storage="_photoPath" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  63       <Column Name="PostalCode" Member="PostalCode" Storage="_postalCode" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  64       <Column Name="Region" Member="Region" Storage="_region" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  65       <Column Name="ReportsTo" Member="ReportsTo" Storage="_reportsTo" Type="System.Int64" DbType="integer" IsPrimaryKey="false" CanBeNull="true" />\r
  66       <Column Name="Title" Member="Title" Storage="_title" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  67       <Column Name="TitleOfCourtesy" Member="TitleOfCourtesy" Storage="_titleOfCourtesy" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
  68     </Type>\r
  69   </Table>\r
  70   <Table Name="EmployeeTerritories" Member="EmployeeTerritories">\r
  71     <Type Name="EmployeeTerritories">\r
  72       <Association Name="FK_EmployeeTerritories_0" Member="Territories" Storage="_territories" Type="Territories" ThisKey="TerritoryID" OtherKey="TerritoryID" IsForeignKey="true" />\r
  73       <Association Name="FK_EmployeeTerritories_1" Member="Employees" Storage="_employees" Type="Employees" ThisKey="EmployeeID" OtherKey="EmployeeID" IsForeignKey="true" />\r
  74       <Column Name="EmployeeID" Member="EmployeeID" Storage="_employeeID" Type="System.Int64" DbType="integer" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />\r
  75       <Column Name="TerritoryID" Member="TerritoryID" Storage="_territoryID" Type="System.String" DbType="nvarchar" IsPrimaryKey="true" CanBeNull="false" />\r
  76     </Type>\r
  77   </Table>\r
  78   <Table Name="Order Details" Member="OrderDetails">\r
  79     <Type Name="OrderDetails">\r
  80       <Association Name="FK_Order Details_0" Member="Products" Storage="_products" Type="Products" ThisKey="ProductID" OtherKey="ProductID" IsForeignKey="true" />\r
  81       <Association Name="FK_Order Details_1" Member="Orders" Storage="_orders" Type="Orders" ThisKey="OrderID" OtherKey="OrderID" IsForeignKey="true" />\r
  82       <Column Name="Discount" Member="Discount" Storage="_discount" Type="System.Single" DbType="real" IsPrimaryKey="false" CanBeNull="false" />\r
  83       <Column Name="OrderID" Member="OrderID" Storage="_orderID" Type="System.Int64" DbType="integer" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />\r
  84       <Column Name="ProductID" Member="ProductID" Storage="_productID" Type="System.Int64" DbType="integer" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />\r
  85       <Column Name="Quantity" Member="Quantity" Storage="_quantity" Type="System.Int16" DbType="smallint" IsPrimaryKey="false" CanBeNull="false" />\r
  86       <Column Name="UnitPrice" Member="UnitPrice" Storage="_unitPrice" Type="System.Decimal" DbType="money" IsPrimaryKey="false" CanBeNull="false" />\r
  87     </Type>\r
  88   </Table>\r
  89   <Table Name="Orders" Member="Orders">\r
  90     <Type Name="Orders">\r
  91       <Association Name="FK_Orders_0" Member="Shippers" Storage="_shippers" Type="Shippers" ThisKey="ShipVia" OtherKey="ShipperID" IsForeignKey="true" />\r
  92       <Association Name="FK_Orders_1" Member="Employees" Storage="_employees" Type="Employees" ThisKey="EmployeeID" OtherKey="EmployeeID" IsForeignKey="true" />\r
  93       <Association Name="FK_Orders_2" Member="Customers" Storage="_customers" Type="Customers" ThisKey="CustomerID" OtherKey="CustomerID" IsForeignKey="true" />\r
  94       <Association Name="FK_Order Details_1" Member="OrderDetails" Storage="_orderDetails" Type="OrderDetails" ThisKey="OrderID" OtherKey="OrderID" DeleteRule="NO ACTION" />\r
  95       <Column Name="CustomerID" Member="CustomerID" Storage="_customerID" Type="System.String" DbType="nchar" IsPrimaryKey="false" CanBeNull="true" />\r
  96       <Column Name="EmployeeID" Member="EmployeeID" Storage="_employeeID" Type="System.Int64" DbType="integer" IsPrimaryKey="false" CanBeNull="true" />\r
  97       <Column Name="Freight" Member="Freight" Storage="_freight" Type="System.Decimal" DbType="money" IsPrimaryKey="false" CanBeNull="true" />\r
  98       <Column Name="OrderDate" Member="OrderDate" Storage="_orderDate" Type="System.DateTime" DbType="datetime" IsPrimaryKey="false" CanBeNull="true" />\r
  99       <Column Name="OrderID" Member="OrderID" Storage="_orderID" Type="System.Int64" DbType="integer" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />\r
 100       <Column Name="RequiredDate" Member="RequiredDate" Storage="_requiredDate" Type="System.DateTime" DbType="datetime" IsPrimaryKey="false" CanBeNull="true" />\r
 101       <Column Name="ShipAddress" Member="ShipAddress" Storage="_shipAddress" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 102       <Column Name="ShipCity" Member="ShipCity" Storage="_shipCity" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 103       <Column Name="ShipCountry" Member="ShipCountry" Storage="_shipCountry" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 104       <Column Name="ShipName" Member="ShipName" Storage="_shipName" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 105       <Column Name="ShippedDate" Member="ShippedDate" Storage="_shippedDate" Type="System.DateTime" DbType="datetime" IsPrimaryKey="false" CanBeNull="true" />\r
 106       <Column Name="ShipPostalCode" Member="ShipPostalCode" Storage="_shipPostalCode" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 107       <Column Name="ShipRegion" Member="ShipRegion" Storage="_shipRegion" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 108       <Column Name="ShipVia" Member="ShipVia" Storage="_shipVia" Type="System.Int64" DbType="integer" IsPrimaryKey="false" CanBeNull="true" />\r
 109     </Type>\r
 110   </Table>\r
 111   <Table Name="Products" Member="Products">\r
 112     <Type Name="Products">\r
 113       <Association Name="FK_Products_0" Member="Suppliers" Storage="_suppliers" Type="Suppliers" ThisKey="SupplierID" OtherKey="SupplierID" IsForeignKey="true" />\r
 114       <Association Name="FK_Products_1" Member="Categories" Storage="_categories" Type="Categories" ThisKey="CategoryID" OtherKey="CategoryID" IsForeignKey="true" />\r
 115       <Association Name="FK_Order Details_0" Member="OrderDetails" Storage="_orderDetails" Type="OrderDetails" ThisKey="ProductID" OtherKey="ProductID" DeleteRule="NO ACTION" />\r
 116       <Column Name="CategoryID" Member="CategoryID" Storage="_categoryID" Type="System.Int64" DbType="integer" IsPrimaryKey="false" CanBeNull="true" />\r
 117       <Column Name="Discontinued" Member="Discontinued" Storage="_discontinued" Type="System.Boolean" DbType="bit" IsPrimaryKey="false" CanBeNull="false" />\r
 118       <Column Name="ProductID" Member="ProductID" Storage="_productID" Type="System.Int64" DbType="integer" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />\r
 119       <Column Name="ProductName" Member="ProductName" Storage="_productName" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="false" />\r
 120       <Column Name="QuantityPerUnit" Member="QuantityPerUnit" Storage="_quantityPerUnit" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 121       <Column Name="ReorderLevel" Member="ReorderLevel" Storage="_reorderLevel" Type="System.Int16" DbType="smallint" IsPrimaryKey="false" CanBeNull="true" />\r
 122       <Column Name="SupplierID" Member="SupplierID" Storage="_supplierID" Type="System.Int64" DbType="integer" IsPrimaryKey="false" CanBeNull="true" />\r
 123       <Column Name="UnitPrice" Member="UnitPrice" Storage="_unitPrice" Type="System.Decimal" DbType="money" IsPrimaryKey="false" CanBeNull="true" />\r
 124       <Column Name="UnitsInStock" Member="UnitsInStock" Storage="_unitsInStock" Type="System.Int16" DbType="smallint" IsPrimaryKey="false" CanBeNull="true" />\r
 125       <Column Name="UnitsOnOrder" Member="UnitsOnOrder" Storage="_unitsOnOrder" Type="System.Int16" DbType="smallint" IsPrimaryKey="false" CanBeNull="true" />\r
 126     </Type>\r
 127   </Table>\r
 128   <Table Name="Region" Member="Region">\r
 129     <Type Name="Region">\r
 130       <Association Name="FK_Territories_0" Member="Territories" Storage="_territories" Type="Territories" ThisKey="RegionID" OtherKey="RegionID" DeleteRule="NO ACTION" />\r
 131       <Column Name="RegionDescription" Member="RegionDescription" Storage="_regionDescription" Type="System.String" DbType="nchar" IsPrimaryKey="false" CanBeNull="false" />\r
 132       <Column Name="RegionID" Member="RegionID" Storage="_regionID" Type="System.Int64" DbType="integer" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />\r
 133     </Type>\r
 134   </Table>\r
 135   <Table Name="Shippers" Member="Shippers">\r
 136     <Type Name="Shippers">\r
 137       <Association Name="FK_Orders_0" Member="Orders" Storage="_orders" Type="Orders" ThisKey="ShipperID" OtherKey="ShipVia" DeleteRule="NO ACTION" />\r
 138       <Column Name="CompanyName" Member="CompanyName" Storage="_companyName" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="false" />\r
 139       <Column Name="Phone" Member="Phone" Storage="_phone" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 140       <Column Name="ShipperID" Member="ShipperID" Storage="_shipperID" Type="System.Int64" DbType="integer" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />\r
 141     </Type>\r
 142   </Table>\r
 143   <Table Name="Suppliers" Member="Suppliers">\r
 144     <Type Name="Suppliers">\r
 145       <Association Name="FK_Products_0" Member="Products" Storage="_products" Type="Products" ThisKey="SupplierID" OtherKey="SupplierID" DeleteRule="NO ACTION" />\r
 146       <Column Name="Address" Member="Address" Storage="_address" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 147       <Column Name="City" Member="City" Storage="_city" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 148       <Column Name="CompanyName" Member="CompanyName" Storage="_companyName" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="false" />\r
 149       <Column Name="ContactName" Member="ContactName" Storage="_contactName" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 150       <Column Name="ContactTitle" Member="ContactTitle" Storage="_contactTitle" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 151       <Column Name="Country" Member="Country" Storage="_country" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 152       <Column Name="Fax" Member="Fax" Storage="_fax" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 153       <Column Name="HomePage" Member="HomePage" Storage="_homePage" Type="System.String" DbType="ntext" IsPrimaryKey="false" CanBeNull="true" />\r
 154       <Column Name="Phone" Member="Phone" Storage="_phone" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 155       <Column Name="PostalCode" Member="PostalCode" Storage="_postalCode" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 156       <Column Name="Region" Member="Region" Storage="_region" Type="System.String" DbType="nvarchar" IsPrimaryKey="false" CanBeNull="true" />\r
 157       <Column Name="SupplierID" Member="SupplierID" Storage="_supplierID" Type="System.Int64" DbType="integer" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />\r
 158     </Type>\r
 159   </Table>\r
 160   <Table Name="Territories" Member="Territories">\r
 161     <Type Name="Territories">\r
 162       <Association Name="FK_Territories_0" Member="Region" Storage="_region" Type="Region" ThisKey="RegionID" OtherKey="RegionID" IsForeignKey="true" />\r
 163       <Association Name="FK_EmployeeTerritories_0" Member="EmployeeTerritories" Storage="_employeeTerritories" Type="EmployeeTerritories" ThisKey="TerritoryID" OtherKey="TerritoryID" DeleteRule="NO ACTION" />\r
 164       <Column Name="RegionID" Member="RegionID" Storage="_regionID" Type="System.Int64" DbType="integer" IsPrimaryKey="false" CanBeNull="false" />\r
 165       <Column Name="TerritoryDescription" Member="TerritoryDescription" Storage="_territoryDescription" Type="System.String" DbType="nchar" IsPrimaryKey="false" CanBeNull="false" />\r
 166       <Column Name="TerritoryID" Member="TerritoryID" Storage="_territoryID" Type="System.String" DbType="nvarchar" IsPrimaryKey="true" CanBeNull="false" />\r
 167     </Type>\r
 168   </Table>\r
 169 </Database>