Schemas Comparison Report

Report AttributeValue
DTM Schema Comparer 1.11.09, Unicode, x86
Report Created25-Oct-2016 17:01
Primary databaseSQL Server Native Client 11.0: .///AdventureWorks_Empty [Direct]
Secondary databaseSQL Server Native Client 11.0: .///AdventureWorks [Local]
CommentTest and Empty schemas comparison
AuthorAlex P.

Report

Item typePrimary ItemSecondary Item
   ColumnPerson.Address.AddressID int identity NOT NULL Primary KeyPerson.Address.AddressID int identity NOT NULL Primary Key
   ColumnPerson.Address.AddressLine1 nvarchar(60) NOT NULLPerson.Address.AddressLine1 nvarchar(60) NOT NULL
   ColumnPerson.Address.AddressLine2 nvarchar(60) NULLPerson.Address.AddressLine2 nvarchar(60) NULL
   ColumnPerson.Address.City nvarchar(30) NOT NULLPerson.Address.City nvarchar(30) NOT NULL
   ColumnPerson.Address.StateProvinceID int NOT NULLPerson.Address.StateProvinceID int NOT NULL
   ColumnPerson.Address.PostalCode nvarchar(15) NOT NULLPerson.Address.PostalCode nvarchar(15) NOT NULL
   ColumnPerson.Address.rowguid uniqueidentifier NOT NULL default newid()Person.Address.rowguid uniqueidentifier NOT NULL default newid()
   ColumnPerson.Address.ModifiedDate datetime2 NOT NULL default getdate()Person.Address.ModifiedDate datetime NOT NULL default getdate()
TablePerson.AddressPerson.Address
   ColumnPerson.AddressType.AddressTypeID int identity NOT NULL Primary KeyPerson.AddressType.AddressTypeID int identity NOT NULL Primary Key
   ColumnPerson.AddressType.Name nvarchar(50) NOT NULLPerson.AddressType.Name Name NOT NULL
   ColumnPerson.AddressType.rowguid uniqueidentifier NOT NULL default newid()Person.AddressType.rowguid uniqueidentifier NOT NULL default newid()
   ColumnPerson.AddressType.ModifiedDate datetime2 NOT NULL default getdate()Person.AddressType.ModifiedDate datetime NOT NULL default getdate()
TablePerson.AddressTypePerson.AddressType
   Columndbo.AWBuildVersion.SystemInformationID tinyint identity NOT NULL Primary Keydbo.AWBuildVersion.SystemInformationID tinyint identity NOT NULL Primary Key
   Columndbo.AWBuildVersion.[Database Version] nvarchar(25) NOT NULLdbo.AWBuildVersion.[Database Version] nvarchar(25) NOT NULL
   Columndbo.AWBuildVersion.VersionDate datetime2 NOT NULLdbo.AWBuildVersion.VersionDate datetime NOT NULL
   Columndbo.AWBuildVersion.ModifiedDate datetime2 NOT NULL default getdate()dbo.AWBuildVersion.ModifiedDate datetime NOT NULL default getdate()
Tabledbo.AWBuildVersiondbo.AWBuildVersion
   ColumnProduction.BillOfMaterials.BillOfMaterialsID int identity NOT NULL Primary KeyProduction.BillOfMaterials.BillOfMaterialsID int identity NOT NULL Primary Key
   ColumnProduction.BillOfMaterials.ProductAssemblyID int NULLProduction.BillOfMaterials.ProductAssemblyID int NULL
   ColumnProduction.BillOfMaterials.ComponentID int NOT NULLProduction.BillOfMaterials.ComponentID int NOT NULL
   ColumnProduction.BillOfMaterials.StartDate datetime2 NOT NULL default getdate()Production.BillOfMaterials.StartDate datetime NOT NULL default getdate()
   ColumnProduction.BillOfMaterials.EndDate datetime2 NULLProduction.BillOfMaterials.EndDate datetime NULL
   ColumnProduction.BillOfMaterials.UnitMeasureCode nchar(3) NOT NULLProduction.BillOfMaterials.UnitMeasureCode nchar(3) NOT NULL
   ColumnProduction.BillOfMaterials.BOMLevel smallint NOT NULLProduction.BillOfMaterials.BOMLevel smallint NOT NULL
   ColumnProduction.BillOfMaterials.PerAssemblyQty decimal(8,2) NOT NULL default (1.00) CHECK ([PerAssemblyQty]>=(1.00))Production.BillOfMaterials.PerAssemblyQty decimal(8,2) NOT NULL default (1.00) CHECK ([PerAssemblyQty]>=(1.00))
   ColumnProduction.BillOfMaterials.ModifiedDate datetime2 NOT NULL default getdate()Production.BillOfMaterials.ModifiedDate datetime NOT NULL default getdate()
TableProduction.BillOfMaterialsProduction.BillOfMaterials
   ColumnPerson.Contact.ContactID int identity NOT NULL Primary KeyPerson.Contact.ContactID int identity NOT NULL Primary Key
   ColumnPerson.Contact.NameStyle bit NOT NULL default (0)Person.Contact.NameStyle NameStyle NOT NULL default (0)
   ColumnPerson.Contact.Title nvarchar(8) NULLPerson.Contact.Title nvarchar(8) NULL
   ColumnPerson.Contact.FirstName nvarchar(50) NOT NULLPerson.Contact.FirstName Name NOT NULL
   ColumnPerson.Contact.MiddleName nvarchar(50) NULLPerson.Contact.MiddleName Name NULL
   ColumnPerson.Contact.LastName nvarchar(50) NOT NULLPerson.Contact.LastName Name NOT NULL
   ColumnPerson.Contact.Suffix nvarchar(10) NULLPerson.Contact.Suffix nvarchar(10) NULL
   ColumnPerson.Contact.EmailAddress nvarchar(50) NULLPerson.Contact.EmailAddress nvarchar(50) NULL
   ColumnPerson.Contact.EmailPromotion int NOT NULL default (0) CHECK ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))Person.Contact.EmailPromotion int NOT NULL default (0) CHECK ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))
   ColumnPerson.Contact.Phone nvarchar(25) NULLPerson.Contact.Phone Phone NULL
   ColumnPerson.Contact.PasswordHash varchar(128) NOT NULLPerson.Contact.PasswordHash varchar(128) NOT NULL
   ColumnPerson.Contact.PasswordSalt varchar(10) NOT NULLPerson.Contact.PasswordSalt varchar(10) NOT NULL
   ColumnPerson.Contact.AdditionalContactInfo xml NULLPerson.Contact.AdditionalContactInfo xml NULL
   ColumnPerson.Contact.rowguid uniqueidentifier NOT NULL default newid()Person.Contact.rowguid uniqueidentifier NOT NULL default newid()
   ColumnPerson.Contact.ModifiedDate datetime2 NOT NULL default getdate()Person.Contact.ModifiedDate datetime NOT NULL default getdate()
TablePerson.ContactPerson.Contact
   ColumnSales.ContactCreditCard.ContactID int NOT NULL Primary KeySales.ContactCreditCard.ContactID int NOT NULL Primary Key
   ColumnSales.ContactCreditCard.CreditCardID int NOT NULL Primary KeySales.ContactCreditCard.CreditCardID int NOT NULL Primary Key
   ColumnSales.ContactCreditCard.ModifiedDate datetime2 NOT NULL default getdate()Sales.ContactCreditCard.ModifiedDate datetime NOT NULL default getdate()
TableSales.ContactCreditCardSales.ContactCreditCard
   ColumnPerson.ContactType.ContactTypeID int identity NOT NULL Primary KeyPerson.ContactType.ContactTypeID int identity NOT NULL Primary Key
   ColumnPerson.ContactType.Name nvarchar(50) NOT NULLPerson.ContactType.Name Name NOT NULL
   ColumnPerson.ContactType.ModifiedDate datetime2 NOT NULL default getdate()Person.ContactType.ModifiedDate datetime NOT NULL default getdate()
TablePerson.ContactTypePerson.ContactType
   ColumnPerson.CountryRegion.CountryRegionCode nvarchar(3) NOT NULL Primary KeyPerson.CountryRegion.CountryRegionCode nvarchar(3) NOT NULL Primary Key
   ColumnPerson.CountryRegion.Name nvarchar(50) NOT NULLPerson.CountryRegion.Name Name NOT NULL
   ColumnPerson.CountryRegion.ModifiedDate datetime2 NOT NULL default getdate()Person.CountryRegion.ModifiedDate datetime NOT NULL default getdate()
TablePerson.CountryRegionPerson.CountryRegion
   ColumnSales.CountryRegionCurrency.CountryRegionCode nvarchar(3) NOT NULL Primary KeySales.CountryRegionCurrency.CountryRegionCode nvarchar(3) NOT NULL Primary Key
   ColumnSales.CountryRegionCurrency.CurrencyCode nchar(3) NOT NULL Primary KeySales.CountryRegionCurrency.CurrencyCode nchar(3) NOT NULL Primary Key
   ColumnSales.CountryRegionCurrency.ModifiedDate datetime2 NOT NULL default getdate()Sales.CountryRegionCurrency.ModifiedDate datetime NOT NULL default getdate()
TableSales.CountryRegionCurrencySales.CountryRegionCurrency
   ColumnSales.CreditCard.CreditCardID int identity NOT NULL Primary KeySales.CreditCard.CreditCardID int identity NOT NULL Primary Key
   ColumnSales.CreditCard.CardType nvarchar(50) NOT NULLSales.CreditCard.CardType nvarchar(50) NOT NULL
   ColumnSales.CreditCard.CardNumber nvarchar(25) NOT NULLSales.CreditCard.CardNumber nvarchar(25) NOT NULL
   ColumnSales.CreditCard.ExpMonth tinyint NOT NULLSales.CreditCard.ExpMonth tinyint NOT NULL
   ColumnSales.CreditCard.ExpYear smallint NOT NULLSales.CreditCard.ExpYear smallint NOT NULL
   ColumnSales.CreditCard.ModifiedDate datetime2 NOT NULL default getdate()Sales.CreditCard.ModifiedDate datetime NOT NULL default getdate()
TableSales.CreditCardSales.CreditCard
   ColumnProduction.Culture.CultureID nchar(6) NOT NULL Primary KeyProduction.Culture.CultureID nchar(6) NOT NULL Primary Key
   ColumnProduction.Culture.Name nvarchar(50) NOT NULLProduction.Culture.Name Name NOT NULL
   ColumnProduction.Culture.ModifiedDate datetime2 NOT NULL default getdate()Production.Culture.ModifiedDate datetime NOT NULL default getdate()
TableProduction.CultureProduction.Culture
   ColumnSales.Currency.CurrencyCode nchar(3) NOT NULL Primary KeySales.Currency.CurrencyCode nchar(3) NOT NULL Primary Key
   ColumnSales.Currency.Name nvarchar(50) NOT NULLSales.Currency.Name Name NOT NULL
   ColumnSales.Currency.ModifiedDate datetime2 NOT NULL default getdate()Sales.Currency.ModifiedDate datetime NOT NULL default getdate()
TableSales.CurrencySales.Currency
   ColumnSales.CurrencyRate.CurrencyRateID int identity NOT NULL Primary KeySales.CurrencyRate.CurrencyRateID int identity NOT NULL Primary Key
   ColumnSales.CurrencyRate.CurrencyRateDate datetime2 NOT NULLSales.CurrencyRate.CurrencyRateDate datetime NOT NULL
   ColumnSales.CurrencyRate.FromCurrencyCode nchar(3) NOT NULLSales.CurrencyRate.FromCurrencyCode nchar(3) NOT NULL
   ColumnSales.CurrencyRate.ToCurrencyCode nchar(3) NOT NULLSales.CurrencyRate.ToCurrencyCode nchar(3) NOT NULL
   ColumnSales.CurrencyRate.AverageRate decimal(19,4) NOT NULLSales.CurrencyRate.AverageRate money(19,4) NOT NULL
   ColumnSales.CurrencyRate.EndOfDayRate decimal(19,4) NOT NULLSales.CurrencyRate.EndOfDayRate money(19,4) NOT NULL
   ColumnSales.CurrencyRate.ModifiedDate datetime2 NOT NULL default getdate()Sales.CurrencyRate.ModifiedDate datetime NOT NULL default getdate()
TableSales.CurrencyRateSales.CurrencyRate
   ColumnSales.Customer.CustomerID int identity NOT NULL Primary KeySales.Customer.CustomerID int identity NOT NULL Primary Key
   ColumnSales.Customer.TerritoryID int NULLSales.Customer.TerritoryID int NULL
   ColumnSales.Customer.AccountNumber varchar(10) NOT NULLSales.Customer.AccountNumber varchar(10) NOT NULL
   ColumnSales.Customer.CustomerType nchar(1) NOT NULL CHECK (upper([CustomerType])='I' OR upper([CustomerType])='S')Sales.Customer.CustomerType nchar(1) NOT NULL CHECK (upper([CustomerType])='I' OR upper([CustomerType])='S')
   ColumnSales.Customer.rowguid uniqueidentifier NOT NULL default newid()Sales.Customer.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.Customer.ModifiedDate datetime2 NOT NULL default getdate()Sales.Customer.ModifiedDate datetime NOT NULL default getdate()
TableSales.CustomerSales.Customer
   ColumnSales.CustomerAddress.CustomerID int NOT NULL Primary KeySales.CustomerAddress.CustomerID int NOT NULL Primary Key
   ColumnSales.CustomerAddress.AddressID int NOT NULL Primary KeySales.CustomerAddress.AddressID int NOT NULL Primary Key
   ColumnSales.CustomerAddress.AddressTypeID int NOT NULLSales.CustomerAddress.AddressTypeID int NOT NULL
   ColumnSales.CustomerAddress.rowguid uniqueidentifier NOT NULL default newid()Sales.CustomerAddress.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.CustomerAddress.ModifiedDate datetime2 NOT NULL default getdate()Sales.CustomerAddress.ModifiedDate datetime NOT NULL default getdate()
TableSales.CustomerAddressSales.CustomerAddress
   Columndbo.DatabaseLog.DatabaseLogID int identity NOT NULL Primary Keydbo.DatabaseLog.DatabaseLogID int identity NOT NULL Primary Key
   Columndbo.DatabaseLog.PostTime datetime2 NOT NULLdbo.DatabaseLog.PostTime datetime NOT NULL
   Columndbo.DatabaseLog.DatabaseUser nvarchar(128) NOT NULLdbo.DatabaseLog.DatabaseUser sysname(128) NOT NULL
   Columndbo.DatabaseLog.Event nvarchar(128) NOT NULLdbo.DatabaseLog.Event sysname(128) NOT NULL
   Columndbo.DatabaseLog.[Schema] nvarchar(128) NULLdbo.DatabaseLog.[Schema] sysname(128) NULL
   Columndbo.DatabaseLog.Object nvarchar(128) NULLdbo.DatabaseLog.Object sysname(128) NULL
   Columndbo.DatabaseLog.TSQL nvarchar(max) NOT NULLdbo.DatabaseLog.TSQL nvarchar(max) NOT NULL
   Columndbo.DatabaseLog.XmlEvent xml NOT NULLdbo.DatabaseLog.XmlEvent xml NOT NULL
Tabledbo.DatabaseLogdbo.DatabaseLog
   ColumnHumanResources.Department.DepartmentID smallint identity NOT NULL Primary KeyHumanResources.Department.DepartmentID smallint identity NOT NULL Primary Key
   ColumnHumanResources.Department.Name nvarchar(50) NOT NULLHumanResources.Department.Name Name NOT NULL
   ColumnHumanResources.Department.GroupName nvarchar(50) NOT NULLHumanResources.Department.GroupName Name NOT NULL
   ColumnHumanResources.Department.ModifiedDate datetime2 NOT NULL default getdate()HumanResources.Department.ModifiedDate datetime NOT NULL default getdate()
TableHumanResources.DepartmentHumanResources.Department
   ColumnProduction.Document.DocumentID int identity NOT NULL Primary KeyProduction.Document.DocumentID int identity NOT NULL Primary Key
   ColumnProduction.Document.Title nvarchar(50) NOT NULLProduction.Document.Title nvarchar(50) NOT NULL
   ColumnProduction.Document.FileName nvarchar(400) NOT NULLProduction.Document.FileName nvarchar(400) NOT NULL
   ColumnProduction.Document.FileExtension nvarchar(8) NOT NULLProduction.Document.FileExtension nvarchar(8) NOT NULL
   ColumnProduction.Document.Revision nchar(5) NOT NULLProduction.Document.Revision nchar(5) NOT NULL
   ColumnProduction.Document.ChangeNumber int NOT NULL default (0)Production.Document.ChangeNumber int NOT NULL default (0)
   ColumnProduction.Document.Status tinyint NOT NULL CHECK ([Status]>=(1) AND [Status]<=(3))Production.Document.Status tinyint NOT NULL CHECK ([Status]>=(1) AND [Status]<=(3))
   ColumnProduction.Document.DocumentSummary nvarchar(max) NULLProduction.Document.DocumentSummary nvarchar(max) NULL
   ColumnProduction.Document.Document varbinary NULLProduction.Document.Document varbinary NULL
   ColumnProduction.Document.ModifiedDate datetime2 NOT NULL default getdate()Production.Document.ModifiedDate datetime NOT NULL default getdate()
TableProduction.DocumentProduction.Document
   ColumnHumanResources.Employee.EmployeeID int identity NOT NULL Primary KeyHumanResources.Employee.EmployeeID int identity NOT NULL Primary Key
   ColumnHumanResources.Employee.NationalIDNumber nvarchar(15) NOT NULLHumanResources.Employee.NationalIDNumber nvarchar(15) NOT NULL
   ColumnHumanResources.Employee.ContactID int NOT NULLHumanResources.Employee.ContactID int NOT NULL
   ColumnHumanResources.Employee.LoginID nvarchar(256) NOT NULLHumanResources.Employee.LoginID nvarchar(256) NOT NULL
   ColumnHumanResources.Employee.ManagerID int NULLHumanResources.Employee.ManagerID int NULL
   ColumnHumanResources.Employee.Title nvarchar(50) NOT NULLHumanResources.Employee.Title nvarchar(50) NOT NULL
   ColumnHumanResources.Employee.BirthDate datetime2 NOT NULL CHECK ([BirthDate]>='1930-01-01' AND [BirthDate]<=dateadd(year,(-18),getdate()))HumanResources.Employee.BirthDate datetime NOT NULL CHECK ([BirthDate]>='1930-01-01' AND [BirthDate]<=dateadd(year,(-18),getdate()))
   ColumnHumanResources.Employee.MaritalStatus nchar(1) NOT NULL CHECK (upper([MaritalStatus])='S' OR upper([MaritalStatus])='M')HumanResources.Employee.MaritalStatus nchar(1) NOT NULL CHECK (upper([MaritalStatus])='S' OR upper([MaritalStatus])='M')
   ColumnHumanResources.Employee.Gender nchar(1) NOT NULL CHECK (upper([Gender])='F' OR upper([Gender])='M')HumanResources.Employee.Gender nchar(1) NOT NULL CHECK (upper([Gender])='F' OR upper([Gender])='M')
   ColumnHumanResources.Employee.HireDate datetime2 NOT NULL CHECK ([HireDate]>='1996-07-01' AND [HireDate]<=dateadd(day,(1),getdate()))HumanResources.Employee.HireDate datetime NOT NULL CHECK ([HireDate]>='1996-07-01' AND [HireDate]<=dateadd(day,(1),getdate()))
   ColumnHumanResources.Employee.SalariedFlag bit NOT NULL default (1)HumanResources.Employee.SalariedFlag Flag NOT NULL default (1)
   ColumnHumanResources.Employee.VacationHours smallint NOT NULL default (0) CHECK ([VacationHours]>=(-40) AND [VacationHours]<=(240))HumanResources.Employee.VacationHours smallint NOT NULL default (0) CHECK ([VacationHours]>=(-40) AND [VacationHours]<=(240))
   ColumnHumanResources.Employee.SickLeaveHours smallint NOT NULL default (0) CHECK ([SickLeaveHours]>=(0) AND [SickLeaveHours]<=(120))HumanResources.Employee.SickLeaveHours smallint NOT NULL default (0) CHECK ([SickLeaveHours]>=(0) AND [SickLeaveHours]<=(120))
   ColumnHumanResources.Employee.CurrentFlag bit NOT NULL default (1)HumanResources.Employee.CurrentFlag Flag NOT NULL default (1)
   ColumnHumanResources.Employee.rowguid uniqueidentifier NOT NULL default newid()HumanResources.Employee.rowguid uniqueidentifier NOT NULL default newid()
   ColumnHumanResources.Employee.ModifiedDate datetime2 NOT NULL default getdate()HumanResources.Employee.ModifiedDate datetime NOT NULL default getdate()
TableHumanResources.EmployeeHumanResources.Employee
   ColumnHumanResources.EmployeeAddress.EmployeeID int NOT NULL Primary KeyHumanResources.EmployeeAddress.EmployeeID int NOT NULL Primary Key
   ColumnHumanResources.EmployeeAddress.AddressID int NOT NULL Primary KeyHumanResources.EmployeeAddress.AddressID int NOT NULL Primary Key
   ColumnHumanResources.EmployeeAddress.rowguid uniqueidentifier NOT NULL default newid()HumanResources.EmployeeAddress.rowguid uniqueidentifier NOT NULL default newid()
   ColumnHumanResources.EmployeeAddress.ModifiedDate datetime2 NOT NULL default getdate()HumanResources.EmployeeAddress.ModifiedDate datetime NOT NULL default getdate()
TableHumanResources.EmployeeAddressHumanResources.EmployeeAddress
   ColumnHumanResources.EmployeeDepartmentHistory.EmployeeID int NOT NULL Primary KeyHumanResources.EmployeeDepartmentHistory.EmployeeID int NOT NULL Primary Key
   ColumnHumanResources.EmployeeDepartmentHistory.DepartmentID smallint NOT NULL Primary KeyHumanResources.EmployeeDepartmentHistory.DepartmentID smallint NOT NULL Primary Key
   ColumnHumanResources.EmployeeDepartmentHistory.ShiftID tinyint NOT NULL Primary KeyHumanResources.EmployeeDepartmentHistory.ShiftID tinyint NOT NULL Primary Key
   ColumnHumanResources.EmployeeDepartmentHistory.StartDate datetime2 NOT NULL Primary KeyHumanResources.EmployeeDepartmentHistory.StartDate datetime NOT NULL Primary Key
   ColumnHumanResources.EmployeeDepartmentHistory.EndDate datetime2 NULLHumanResources.EmployeeDepartmentHistory.EndDate datetime NULL
   ColumnHumanResources.EmployeeDepartmentHistory.ModifiedDate datetime2 NOT NULL default getdate()HumanResources.EmployeeDepartmentHistory.ModifiedDate datetime NOT NULL default getdate()
TableHumanResources.EmployeeDepartmentHistoryHumanResources.EmployeeDepartmentHistory
   ColumnHumanResources.EmployeePayHistory.EmployeeID int NOT NULL Primary KeyHumanResources.EmployeePayHistory.EmployeeID int NOT NULL Primary Key
   ColumnHumanResources.EmployeePayHistory.RateChangeDate datetime2 NOT NULL Primary KeyHumanResources.EmployeePayHistory.RateChangeDate datetime NOT NULL Primary Key
   ColumnHumanResources.EmployeePayHistory.Rate decimal(19,4) NOT NULL CHECK ([Rate]>=(6.50) AND [Rate]<=(200.00))HumanResources.EmployeePayHistory.Rate money(19,4) NOT NULL CHECK ([Rate]>=(6.50) AND [Rate]<=(200.00))
   ColumnHumanResources.EmployeePayHistory.PayFrequency tinyint NOT NULL CHECK ([PayFrequency]=(2) OR [PayFrequency]=(1))HumanResources.EmployeePayHistory.PayFrequency tinyint NOT NULL CHECK ([PayFrequency]=(2) OR [PayFrequency]=(1))
   ColumnHumanResources.EmployeePayHistory.ModifiedDate datetime2 NOT NULL default getdate()HumanResources.EmployeePayHistory.ModifiedDate datetime NOT NULL default getdate()
TableHumanResources.EmployeePayHistoryHumanResources.EmployeePayHistory
   Columndbo.ErrorLog.ErrorLogID int identity NOT NULL Primary Keydbo.ErrorLog.ErrorLogID int identity NOT NULL Primary Key
   Columndbo.ErrorLog.ErrorTime datetime2 NOT NULL default getdate()dbo.ErrorLog.ErrorTime datetime NOT NULL default getdate()
   Columndbo.ErrorLog.UserName nvarchar(128) NOT NULLdbo.ErrorLog.UserName sysname(128) NOT NULL
   Columndbo.ErrorLog.ErrorNumber int NOT NULLdbo.ErrorLog.ErrorNumber int NOT NULL
   Columndbo.ErrorLog.ErrorSeverity int NULLdbo.ErrorLog.ErrorSeverity int NULL
   Columndbo.ErrorLog.ErrorState int NULLdbo.ErrorLog.ErrorState int NULL
   Columndbo.ErrorLog.ErrorProcedure nvarchar(126) NULLdbo.ErrorLog.ErrorProcedure nvarchar(126) NULL
   Columndbo.ErrorLog.ErrorLine int NULLdbo.ErrorLog.ErrorLine int NULL
   Columndbo.ErrorLog.ErrorMessage nvarchar(4000) NOT NULLdbo.ErrorLog.ErrorMessage nvarchar(4000) NOT NULL
Tabledbo.ErrorLogdbo.ErrorLog
   ColumnProduction.Illustration.IllustrationID int identity NOT NULL Primary KeyProduction.Illustration.IllustrationID int identity NOT NULL Primary Key
   ColumnProduction.Illustration.Diagram xml NULLProduction.Illustration.Diagram xml NULL
   ColumnProduction.Illustration.ModifiedDate datetime2 NOT NULL default getdate()Production.Illustration.ModifiedDate datetime NOT NULL default getdate()
TableProduction.IllustrationProduction.Illustration
   ColumnSales.Individual.CustomerID int NOT NULL Primary KeySales.Individual.CustomerID int NOT NULL Primary Key
   ColumnSales.Individual.ContactID int NOT NULLSales.Individual.ContactID int NOT NULL
   ColumnSales.Individual.Demographics xml NULLSales.Individual.Demographics xml NULL
   ColumnSales.Individual.ModifiedDate datetime2 NOT NULL default getdate()Sales.Individual.ModifiedDate datetime NOT NULL default getdate()
TableSales.IndividualSales.Individual
   ColumnHumanResources.JobCandidate.JobCandidateID int identity NOT NULL Primary KeyHumanResources.JobCandidate.JobCandidateID int identity NOT NULL Primary Key
   ColumnHumanResources.JobCandidate.EmployeeID int NULLHumanResources.JobCandidate.EmployeeID int NULL
   ColumnHumanResources.JobCandidate.Resume xml NULLHumanResources.JobCandidate.Resume xml NULL
   ColumnHumanResources.JobCandidate.ModifiedDate datetime2 NOT NULL default getdate()HumanResources.JobCandidate.ModifiedDate datetime NOT NULL default getdate()
TableHumanResources.JobCandidateHumanResources.JobCandidate
   ColumnProduction.Location.LocationID smallint identity NOT NULL Primary KeyProduction.Location.LocationID smallint identity NOT NULL Primary Key
   ColumnProduction.Location.Name nvarchar(50) NOT NULLProduction.Location.Name Name NOT NULL
   ColumnProduction.Location.CostRate decimal(10,4) NOT NULL default (0.00) CHECK ([CostRate]>=(0.00))Production.Location.CostRate smallmoney(10,4) NOT NULL default (0.00) CHECK ([CostRate]>=(0.00))
   ColumnProduction.Location.Availability decimal(8,2) NOT NULL default (0.00) CHECK ([Availability]>=(0.00))Production.Location.Availability decimal(8,2) NOT NULL default (0.00) CHECK ([Availability]>=(0.00))
   ColumnProduction.Location.ModifiedDate datetime2 NOT NULL default getdate()Production.Location.ModifiedDate datetime NOT NULL default getdate()
TableProduction.LocationProduction.Location
   ColumnProduction.Product.ProductID int identity NOT NULL Primary KeyProduction.Product.ProductID int identity NOT NULL Primary Key
   ColumnProduction.Product.Name nvarchar(50) NOT NULLProduction.Product.Name Name NOT NULL
   ColumnProduction.Product.ProductNumber nvarchar(25) NOT NULLProduction.Product.ProductNumber nvarchar(25) NOT NULL
   ColumnProduction.Product.MakeFlag bit NOT NULL default (1)Production.Product.MakeFlag Flag NOT NULL default (1)
   ColumnProduction.Product.FinishedGoodsFlag bit NOT NULL default (1)Production.Product.FinishedGoodsFlag Flag NOT NULL default (1)
   ColumnProduction.Product.Color nvarchar(15) NULLProduction.Product.Color nvarchar(15) NULL
   ColumnProduction.Product.SafetyStockLevel smallint NOT NULL CHECK ([SafetyStockLevel]>(0))Production.Product.SafetyStockLevel smallint NOT NULL CHECK ([SafetyStockLevel]>(0))
   ColumnProduction.Product.ReorderPoint smallint NOT NULL CHECK ([ReorderPoint]>(0))Production.Product.ReorderPoint smallint NOT NULL CHECK ([ReorderPoint]>(0))
   ColumnProduction.Product.StandardCost decimal(19,4) NOT NULL CHECK ([StandardCost]>=(0.00))Production.Product.StandardCost money(19,4) NOT NULL CHECK ([StandardCost]>=(0.00))
   ColumnProduction.Product.ListPrice decimal(19,4) NOT NULL CHECK ([ListPrice]>=(0.00))Production.Product.ListPrice money(19,4) NOT NULL CHECK ([ListPrice]>=(0.00))
   ColumnProduction.Product.Size nvarchar(5) NULLProduction.Product.Size nvarchar(5) NULL
   ColumnProduction.Product.SizeUnitMeasureCode nchar(3) NULLProduction.Product.SizeUnitMeasureCode nchar(3) NULL
   ColumnProduction.Product.WeightUnitMeasureCode nchar(3) NULLProduction.Product.WeightUnitMeasureCode nchar(3) NULL
   ColumnProduction.Product.Weight decimal(8,2) NULL CHECK ([Weight]>(0.00))Production.Product.Weight decimal(8,2) NULL CHECK ([Weight]>(0.00))
   ColumnProduction.Product.DaysToManufacture int NOT NULL CHECK ([DaysToManufacture]>=(0))Production.Product.DaysToManufacture int NOT NULL CHECK ([DaysToManufacture]>=(0))
   ColumnProduction.Product.ProductLine nchar(2) NULL CHECK (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL)Production.Product.ProductLine nchar(2) NULL CHECK (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL)
   ColumnProduction.Product.Class nchar(2) NULL CHECK (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL)Production.Product.Class nchar(2) NULL CHECK (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL)
   ColumnProduction.Product.Style nchar(2) NULL CHECK (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL)Production.Product.Style nchar(2) NULL CHECK (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL)
   ColumnProduction.Product.ProductSubcategoryID int NULLProduction.Product.ProductSubcategoryID int NULL
   ColumnProduction.Product.ProductModelID int NULLProduction.Product.ProductModelID int NULL
   ColumnProduction.Product.SellStartDate datetime2 NOT NULLProduction.Product.SellStartDate datetime NOT NULL
   ColumnProduction.Product.SellEndDate datetime2 NULLProduction.Product.SellEndDate datetime NULL
   ColumnProduction.Product.DiscontinuedDate datetime2 NULLProduction.Product.DiscontinuedDate datetime NULL
   ColumnProduction.Product.rowguid uniqueidentifier NOT NULL default newid()Production.Product.rowguid uniqueidentifier NOT NULL default newid()
   ColumnProduction.Product.ModifiedDate datetime2 NOT NULL default getdate()Production.Product.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductProduction.Product
   ColumnProduction.ProductCategory.ProductCategoryID int identity NOT NULL Primary KeyProduction.ProductCategory.ProductCategoryID int identity NOT NULL Primary Key
   ColumnProduction.ProductCategory.Name nvarchar(50) NOT NULLProduction.ProductCategory.Name Name NOT NULL
   ColumnProduction.ProductCategory.rowguid uniqueidentifier NOT NULL default newid()Production.ProductCategory.rowguid uniqueidentifier NOT NULL default newid()
   ColumnProduction.ProductCategory.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductCategory.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductCategoryProduction.ProductCategory
   ColumnProduction.ProductCostHistory.ProductID int NOT NULL Primary KeyProduction.ProductCostHistory.ProductID int NOT NULL Primary Key
   ColumnProduction.ProductCostHistory.StartDate datetime2 NOT NULL Primary KeyProduction.ProductCostHistory.StartDate datetime NOT NULL Primary Key
   ColumnProduction.ProductCostHistory.EndDate datetime2 NULLProduction.ProductCostHistory.EndDate datetime NULL
   ColumnProduction.ProductCostHistory.StandardCost decimal(19,4) NOT NULL CHECK ([StandardCost]>=(0.00))Production.ProductCostHistory.StandardCost money(19,4) NOT NULL CHECK ([StandardCost]>=(0.00))
   ColumnProduction.ProductCostHistory.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductCostHistory.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductCostHistoryProduction.ProductCostHistory
   ColumnProduction.ProductDescription.ProductDescriptionID int identity NOT NULL Primary KeyProduction.ProductDescription.ProductDescriptionID int identity NOT NULL Primary Key
   ColumnProduction.ProductDescription.Description nvarchar(400) NOT NULLProduction.ProductDescription.Description nvarchar(400) NOT NULL
   ColumnProduction.ProductDescription.rowguid uniqueidentifier NOT NULL default newid()Production.ProductDescription.rowguid uniqueidentifier NOT NULL default newid()
   ColumnProduction.ProductDescription.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductDescription.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductDescriptionProduction.ProductDescription
   ColumnProduction.ProductDocument.ProductID int NOT NULL Primary KeyProduction.ProductDocument.ProductID int NOT NULL Primary Key
   ColumnProduction.ProductDocument.DocumentID int NOT NULL Primary KeyProduction.ProductDocument.DocumentID int NOT NULL Primary Key
   ColumnProduction.ProductDocument.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductDocument.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductDocumentProduction.ProductDocument
   ColumnProduction.ProductInventory.ProductID int NOT NULL Primary KeyProduction.ProductInventory.ProductID int NOT NULL Primary Key
   ColumnProduction.ProductInventory.LocationID smallint NOT NULL Primary KeyProduction.ProductInventory.LocationID smallint NOT NULL Primary Key
   ColumnProduction.ProductInventory.Shelf nvarchar(10) NOT NULL CHECK ([Shelf] like '[A-Za-z]' OR [Shelf]='N/A')Production.ProductInventory.Shelf nvarchar(10) NOT NULL CHECK ([Shelf] like '[A-Za-z]' OR [Shelf]='N/A')
   ColumnProduction.ProductInventory.Bin tinyint NOT NULL CHECK ([Bin]>=(0) AND [Bin]<=(100))Production.ProductInventory.Bin tinyint NOT NULL CHECK ([Bin]>=(0) AND [Bin]<=(100))
   ColumnProduction.ProductInventory.Quantity smallint NOT NULL default (0)Production.ProductInventory.Quantity smallint NOT NULL default (0)
   ColumnProduction.ProductInventory.rowguid uniqueidentifier NOT NULL default newid()Production.ProductInventory.rowguid uniqueidentifier NOT NULL default newid()
   ColumnProduction.ProductInventory.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductInventory.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductInventoryProduction.ProductInventory
   ColumnProduction.ProductListPriceHistory.ProductID int NOT NULL Primary KeyProduction.ProductListPriceHistory.ProductID int NOT NULL Primary Key
   ColumnProduction.ProductListPriceHistory.StartDate datetime2 NOT NULL Primary KeyProduction.ProductListPriceHistory.StartDate datetime NOT NULL Primary Key
   ColumnProduction.ProductListPriceHistory.EndDate datetime2 NULLProduction.ProductListPriceHistory.EndDate datetime NULL
   ColumnProduction.ProductListPriceHistory.ListPrice decimal(19,4) NOT NULL CHECK ([ListPrice]>(0.00))Production.ProductListPriceHistory.ListPrice money(19,4) NOT NULL CHECK ([ListPrice]>(0.00))
   ColumnProduction.ProductListPriceHistory.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductListPriceHistory.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductListPriceHistoryProduction.ProductListPriceHistory
   ColumnProduction.ProductModel.ProductModelID int identity NOT NULL Primary KeyProduction.ProductModel.ProductModelID int identity NOT NULL Primary Key
   ColumnProduction.ProductModel.Name nvarchar(50) NOT NULLProduction.ProductModel.Name Name NOT NULL
   ColumnProduction.ProductModel.CatalogDescription xml NULLProduction.ProductModel.CatalogDescription xml NULL
   ColumnProduction.ProductModel.Instructions xml NULLProduction.ProductModel.Instructions xml NULL
   ColumnProduction.ProductModel.rowguid uniqueidentifier NOT NULL default newid()Production.ProductModel.rowguid uniqueidentifier NOT NULL default newid()
   ColumnProduction.ProductModel.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductModel.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductModelProduction.ProductModel
   ColumnProduction.ProductModelIllustration.ProductModelID int NOT NULL Primary KeyProduction.ProductModelIllustration.ProductModelID int NOT NULL Primary Key
   ColumnProduction.ProductModelIllustration.IllustrationID int NOT NULL Primary KeyProduction.ProductModelIllustration.IllustrationID int NOT NULL Primary Key
   ColumnProduction.ProductModelIllustration.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductModelIllustration.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductModelIllustrationProduction.ProductModelIllustration
   ColumnProduction.ProductModelProductDescriptionCulture.ProductModelID int NOT NULL Primary KeyProduction.ProductModelProductDescriptionCulture.ProductModelID int NOT NULL Primary Key
   ColumnProduction.ProductModelProductDescriptionCulture.ProductDescriptionID int NOT NULL Primary KeyProduction.ProductModelProductDescriptionCulture.ProductDescriptionID int NOT NULL Primary Key
   ColumnProduction.ProductModelProductDescriptionCulture.CultureID nchar(6) NOT NULL Primary KeyProduction.ProductModelProductDescriptionCulture.CultureID nchar(6) NOT NULL Primary Key
   ColumnProduction.ProductModelProductDescriptionCulture.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductModelProductDescriptionCulture.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductModelProductDescriptionCultureProduction.ProductModelProductDescriptionCulture
   ColumnProduction.ProductPhoto.ProductPhotoID int identity NOT NULL Primary KeyProduction.ProductPhoto.ProductPhotoID int identity NOT NULL Primary Key
   ColumnProduction.ProductPhoto.ThumbNailPhoto varbinary NULLProduction.ProductPhoto.ThumbNailPhoto varbinary NULL
   ColumnProduction.ProductPhoto.ThumbnailPhotoFileName nvarchar(50) NULLProduction.ProductPhoto.ThumbnailPhotoFileName nvarchar(50) NULL
   ColumnProduction.ProductPhoto.LargePhoto varbinary NULLProduction.ProductPhoto.LargePhoto varbinary NULL
   ColumnProduction.ProductPhoto.LargePhotoFileName nvarchar(50) NULLProduction.ProductPhoto.LargePhotoFileName nvarchar(50) NULL
   ColumnProduction.ProductPhoto.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductPhoto.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductPhotoProduction.ProductPhoto
   ColumnProduction.ProductProductPhoto.ProductID int NOT NULL Primary KeyProduction.ProductProductPhoto.ProductID int NOT NULL Primary Key
   ColumnProduction.ProductProductPhoto.ProductPhotoID int NOT NULL Primary KeyProduction.ProductProductPhoto.ProductPhotoID int NOT NULL Primary Key
   ColumnProduction.ProductProductPhoto.[Primary] bit NOT NULL default (0)Production.ProductProductPhoto.[Primary] Flag NOT NULL default (0)
   ColumnProduction.ProductProductPhoto.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductProductPhoto.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductProductPhotoProduction.ProductProductPhoto
   ColumnProduction.ProductReview.ProductReviewID int identity NOT NULL Primary KeyProduction.ProductReview.ProductReviewID int identity NOT NULL Primary Key
   ColumnProduction.ProductReview.ProductID int NOT NULLProduction.ProductReview.ProductID int NOT NULL
   ColumnProduction.ProductReview.ReviewerName nvarchar(50) NOT NULLProduction.ProductReview.ReviewerName Name NOT NULL
   ColumnProduction.ProductReview.ReviewDate datetime2 NOT NULL default getdate()Production.ProductReview.ReviewDate datetime NOT NULL default getdate()
   ColumnProduction.ProductReview.EmailAddress nvarchar(50) NOT NULLProduction.ProductReview.EmailAddress nvarchar(50) NOT NULL
   ColumnProduction.ProductReview.Rating int NOT NULL CHECK ([Rating]>=(1) AND [Rating]<=(5))Production.ProductReview.Rating int NOT NULL CHECK ([Rating]>=(1) AND [Rating]<=(5))
   ColumnProduction.ProductReview.Comments nvarchar(3850) NULLProduction.ProductReview.Comments nvarchar(3850) NULL
   ColumnProduction.ProductReview.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductReview.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductReviewProduction.ProductReview
   ColumnProduction.ProductSubcategory.ProductSubcategoryID int identity NOT NULL Primary KeyProduction.ProductSubcategory.ProductSubcategoryID int identity NOT NULL Primary Key
   ColumnProduction.ProductSubcategory.ProductCategoryID int NOT NULLProduction.ProductSubcategory.ProductCategoryID int NOT NULL
   ColumnProduction.ProductSubcategory.Name nvarchar(50) NOT NULLProduction.ProductSubcategory.Name Name NOT NULL
   ColumnProduction.ProductSubcategory.rowguid uniqueidentifier NOT NULL default newid()Production.ProductSubcategory.rowguid uniqueidentifier NOT NULL default newid()
   ColumnProduction.ProductSubcategory.ModifiedDate datetime2 NOT NULL default getdate()Production.ProductSubcategory.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ProductSubcategoryProduction.ProductSubcategory
   ColumnPurchasing.ProductVendor.ProductID int NOT NULL Primary KeyPurchasing.ProductVendor.ProductID int NOT NULL Primary Key
   ColumnPurchasing.ProductVendor.VendorID int NOT NULL Primary KeyPurchasing.ProductVendor.VendorID int NOT NULL Primary Key
   ColumnPurchasing.ProductVendor.AverageLeadTime int NOT NULL CHECK ([AverageLeadTime]>=(1))Purchasing.ProductVendor.AverageLeadTime int NOT NULL CHECK ([AverageLeadTime]>=(1))
   ColumnPurchasing.ProductVendor.StandardPrice decimal(19,4) NOT NULL CHECK ([StandardPrice]>(0.00))Purchasing.ProductVendor.StandardPrice money(19,4) NOT NULL CHECK ([StandardPrice]>(0.00))
   ColumnPurchasing.ProductVendor.LastReceiptCost decimal(19,4) NULL CHECK ([LastReceiptCost]>(0.00))Purchasing.ProductVendor.LastReceiptCost money(19,4) NULL CHECK ([LastReceiptCost]>(0.00))
   ColumnPurchasing.ProductVendor.LastReceiptDate datetime2 NULLPurchasing.ProductVendor.LastReceiptDate datetime NULL
   ColumnPurchasing.ProductVendor.MinOrderQty int NOT NULL CHECK ([MinOrderQty]>=(1))Purchasing.ProductVendor.MinOrderQty int NOT NULL CHECK ([MinOrderQty]>=(1))
   ColumnPurchasing.ProductVendor.MaxOrderQty int NOT NULL CHECK ([MaxOrderQty]>=(1))Purchasing.ProductVendor.MaxOrderQty int NOT NULL CHECK ([MaxOrderQty]>=(1))
   ColumnPurchasing.ProductVendor.OnOrderQty int NULL CHECK ([OnOrderQty]>=(0))Purchasing.ProductVendor.OnOrderQty int NULL CHECK ([OnOrderQty]>=(0))
   ColumnPurchasing.ProductVendor.UnitMeasureCode nchar(3) NOT NULLPurchasing.ProductVendor.UnitMeasureCode nchar(3) NOT NULL
   ColumnPurchasing.ProductVendor.ModifiedDate datetime2 NOT NULL default getdate()Purchasing.ProductVendor.ModifiedDate datetime NOT NULL default getdate()
TablePurchasing.ProductVendorPurchasing.ProductVendor
   ColumnPurchasing.PurchaseOrderDetail.PurchaseOrderID int NOT NULL Primary KeyPurchasing.PurchaseOrderDetail.PurchaseOrderID int NOT NULL Primary Key
   ColumnPurchasing.PurchaseOrderDetail.PurchaseOrderDetailID int identity NOT NULL Primary KeyPurchasing.PurchaseOrderDetail.PurchaseOrderDetailID int identity NOT NULL Primary Key
   ColumnPurchasing.PurchaseOrderDetail.DueDate datetime2 NOT NULLPurchasing.PurchaseOrderDetail.DueDate datetime NOT NULL
   ColumnPurchasing.PurchaseOrderDetail.OrderQty smallint NOT NULL CHECK ([OrderQty]>(0))Purchasing.PurchaseOrderDetail.OrderQty smallint NOT NULL CHECK ([OrderQty]>(0))
   ColumnPurchasing.PurchaseOrderDetail.ProductID int NOT NULLPurchasing.PurchaseOrderDetail.ProductID int NOT NULL
   ColumnPurchasing.PurchaseOrderDetail.UnitPrice decimal(19,4) NOT NULL CHECK ([UnitPrice]>=(0.00))Purchasing.PurchaseOrderDetail.UnitPrice money(19,4) NOT NULL CHECK ([UnitPrice]>=(0.00))
   ColumnPurchasing.PurchaseOrderDetail.LineTotal decimal(25,4) NOT NULLPurchasing.PurchaseOrderDetail.LineTotal money(19,4) NOT NULL
   ColumnPurchasing.PurchaseOrderDetail.ReceivedQty decimal(8,2) NOT NULL CHECK ([ReceivedQty]>=(0.00))Purchasing.PurchaseOrderDetail.ReceivedQty decimal(8,2) NOT NULL CHECK ([ReceivedQty]>=(0.00))
   ColumnPurchasing.PurchaseOrderDetail.RejectedQty decimal(8,2) NOT NULL CHECK ([RejectedQty]>=(0.00))Purchasing.PurchaseOrderDetail.RejectedQty decimal(8,2) NOT NULL CHECK ([RejectedQty]>=(0.00))
   ColumnPurchasing.PurchaseOrderDetail.StockedQty decimal(9,2) NOT NULLPurchasing.PurchaseOrderDetail.StockedQty decimal(9,2) NOT NULL
   ColumnPurchasing.PurchaseOrderDetail.ModifiedDate datetime2 NOT NULL default getdate()Purchasing.PurchaseOrderDetail.ModifiedDate datetime NOT NULL default getdate()
TablePurchasing.PurchaseOrderDetailPurchasing.PurchaseOrderDetail
   ColumnPurchasing.PurchaseOrderHeader.PurchaseOrderID int identity NOT NULL Primary KeyPurchasing.PurchaseOrderHeader.PurchaseOrderID int identity NOT NULL Primary Key
   ColumnPurchasing.PurchaseOrderHeader.RevisionNumber tinyint NOT NULL default (0)Purchasing.PurchaseOrderHeader.RevisionNumber tinyint NOT NULL default (0)
   ColumnPurchasing.PurchaseOrderHeader.Status tinyint NOT NULL default (1) CHECK ([Status]>=(1) AND [Status]<=(4))Purchasing.PurchaseOrderHeader.Status tinyint NOT NULL default (1) CHECK ([Status]>=(1) AND [Status]<=(4))
   ColumnPurchasing.PurchaseOrderHeader.EmployeeID int NOT NULLPurchasing.PurchaseOrderHeader.EmployeeID int NOT NULL
   ColumnPurchasing.PurchaseOrderHeader.VendorID int NOT NULLPurchasing.PurchaseOrderHeader.VendorID int NOT NULL
   ColumnPurchasing.PurchaseOrderHeader.ShipMethodID int NOT NULLPurchasing.PurchaseOrderHeader.ShipMethodID int NOT NULL
   ColumnPurchasing.PurchaseOrderHeader.OrderDate datetime2 NOT NULL default getdate()Purchasing.PurchaseOrderHeader.OrderDate datetime NOT NULL default getdate()
   ColumnPurchasing.PurchaseOrderHeader.ShipDate datetime2 NULLPurchasing.PurchaseOrderHeader.ShipDate datetime NULL
   ColumnPurchasing.PurchaseOrderHeader.SubTotal decimal(19,4) NOT NULL default (0.00) CHECK ([SubTotal]>=(0.00))Purchasing.PurchaseOrderHeader.SubTotal money(19,4) NOT NULL default (0.00) CHECK ([SubTotal]>=(0.00))
   ColumnPurchasing.PurchaseOrderHeader.TaxAmt decimal(19,4) NOT NULL default (0.00) CHECK ([TaxAmt]>=(0.00))Purchasing.PurchaseOrderHeader.TaxAmt money(19,4) NOT NULL default (0.00) CHECK ([TaxAmt]>=(0.00))
   ColumnPurchasing.PurchaseOrderHeader.Freight decimal(19,4) NOT NULL default (0.00) CHECK ([Freight]>=(0.00))Purchasing.PurchaseOrderHeader.Freight money(19,4) NOT NULL default (0.00) CHECK ([Freight]>=(0.00))
   ColumnPurchasing.PurchaseOrderHeader.TotalDue decimal(21,4) NOT NULLPurchasing.PurchaseOrderHeader.TotalDue money(19,4) NOT NULL
   ColumnPurchasing.PurchaseOrderHeader.ModifiedDate datetime2 NOT NULL default getdate()Purchasing.PurchaseOrderHeader.ModifiedDate datetime NOT NULL default getdate()
TablePurchasing.PurchaseOrderHeaderPurchasing.PurchaseOrderHeader
   ColumnSales.SalesOrderDetail.SalesOrderID int NOT NULL Primary KeySales.SalesOrderDetail.SalesOrderID int NOT NULL Primary Key
   ColumnSales.SalesOrderDetail.SalesOrderDetailID int identity NOT NULL Primary KeySales.SalesOrderDetail.SalesOrderDetailID int identity NOT NULL Primary Key
   ColumnSales.SalesOrderDetail.CarrierTrackingNumber nvarchar(25) NULLSales.SalesOrderDetail.CarrierTrackingNumber nvarchar(25) NULL
   ColumnSales.SalesOrderDetail.OrderQty smallint NOT NULL CHECK ([OrderQty]>(0))Sales.SalesOrderDetail.OrderQty smallint NOT NULL CHECK ([OrderQty]>(0))
   ColumnSales.SalesOrderDetail.ProductID int NOT NULLSales.SalesOrderDetail.ProductID int NOT NULL
   ColumnSales.SalesOrderDetail.SpecialOfferID int NOT NULLSales.SalesOrderDetail.SpecialOfferID int NOT NULL
   ColumnSales.SalesOrderDetail.UnitPrice decimal(19,4) NOT NULL CHECK ([UnitPrice]>=(0.00))Sales.SalesOrderDetail.UnitPrice money(19,4) NOT NULL CHECK ([UnitPrice]>=(0.00))
   ColumnSales.SalesOrderDetail.UnitPriceDiscount decimal(19,4) NOT NULL default (0.0) CHECK ([UnitPriceDiscount]>=(0.00))Sales.SalesOrderDetail.UnitPriceDiscount money(19,4) NOT NULL default (0.0) CHECK ([UnitPriceDiscount]>=(0.00))
   ColumnSales.SalesOrderDetail.LineTotal numeric(38,6) NOT NULLSales.SalesOrderDetail.LineTotal numeric(38,6) NOT NULL
   ColumnSales.SalesOrderDetail.rowguid uniqueidentifier NOT NULL default newid()Sales.SalesOrderDetail.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.SalesOrderDetail.ModifiedDate datetime2 NOT NULL default getdate()Sales.SalesOrderDetail.ModifiedDate datetime NOT NULL default getdate()
TableSales.SalesOrderDetailSales.SalesOrderDetail
   ColumnSales.SalesOrderHeader.SalesOrderID int identity NOT NULL Primary KeySales.SalesOrderHeader.SalesOrderID int identity NOT NULL Primary Key
   ColumnSales.SalesOrderHeader.RevisionNumber tinyint NOT NULL default (0)Sales.SalesOrderHeader.RevisionNumber tinyint NOT NULL default (0)
   ColumnSales.SalesOrderHeader.OrderDate datetime2 NOT NULL default getdate()Sales.SalesOrderHeader.OrderDate datetime NOT NULL default getdate()
   ColumnSales.SalesOrderHeader.DueDate datetime2 NOT NULLSales.SalesOrderHeader.DueDate datetime NOT NULL
   ColumnSales.SalesOrderHeader.ShipDate datetime2 NULLSales.SalesOrderHeader.ShipDate datetime NULL
   ColumnSales.SalesOrderHeader.Status tinyint NOT NULL default (1) CHECK ([Status]>=(0) AND [Status]<=(8))Sales.SalesOrderHeader.Status tinyint NOT NULL default (1) CHECK ([Status]>=(0) AND [Status]<=(8))
   ColumnSales.SalesOrderHeader.OnlineOrderFlag bit NOT NULL default (1)Sales.SalesOrderHeader.OnlineOrderFlag Flag NOT NULL default (1)
   ColumnSales.SalesOrderHeader.SalesOrderNumber nvarchar(25) NOT NULLSales.SalesOrderHeader.SalesOrderNumber nvarchar(25) NOT NULL
   ColumnSales.SalesOrderHeader.PurchaseOrderNumber nvarchar(25) NULLSales.SalesOrderHeader.PurchaseOrderNumber OrderNumber NULL
   ColumnSales.SalesOrderHeader.AccountNumber nvarchar(15) NULLSales.SalesOrderHeader.AccountNumber AccountNumber NULL
   ColumnSales.SalesOrderHeader.CustomerID int NOT NULLSales.SalesOrderHeader.CustomerID int NOT NULL
   ColumnSales.SalesOrderHeader.ContactID int NOT NULLSales.SalesOrderHeader.ContactID int NOT NULL
   ColumnSales.SalesOrderHeader.SalesPersonID int NULLSales.SalesOrderHeader.SalesPersonID int NULL
   ColumnSales.SalesOrderHeader.TerritoryID int NULLSales.SalesOrderHeader.TerritoryID int NULL
   ColumnSales.SalesOrderHeader.BillToAddressID int NOT NULLSales.SalesOrderHeader.BillToAddressID int NOT NULL
   ColumnSales.SalesOrderHeader.ShipToAddressID int NOT NULLSales.SalesOrderHeader.ShipToAddressID int NOT NULL
   ColumnSales.SalesOrderHeader.ShipMethodID int NOT NULLSales.SalesOrderHeader.ShipMethodID int NOT NULL
   ColumnSales.SalesOrderHeader.CreditCardID int NULLSales.SalesOrderHeader.CreditCardID int NULL
   ColumnSales.SalesOrderHeader.CreditCardApprovalCode varchar(15) NULLSales.SalesOrderHeader.CreditCardApprovalCode varchar(15) NULL
   ColumnSales.SalesOrderHeader.CurrencyRateID int NULLSales.SalesOrderHeader.CurrencyRateID int NULL
   ColumnSales.SalesOrderHeader.SubTotal decimal(19,4) NOT NULL default (0.00) CHECK ([SubTotal]>=(0.00))Sales.SalesOrderHeader.SubTotal money(19,4) NOT NULL default (0.00) CHECK ([SubTotal]>=(0.00))
   ColumnSales.SalesOrderHeader.TaxAmt decimal(19,4) NOT NULL default (0.00) CHECK ([TaxAmt]>=(0.00))Sales.SalesOrderHeader.TaxAmt money(19,4) NOT NULL default (0.00) CHECK ([TaxAmt]>=(0.00))
   ColumnSales.SalesOrderHeader.Freight decimal(19,4) NOT NULL default (0.00) CHECK ([Freight]>=(0.00))Sales.SalesOrderHeader.Freight money(19,4) NOT NULL default (0.00) CHECK ([Freight]>=(0.00))
   ColumnSales.SalesOrderHeader.TotalDue decimal(21,4) NOT NULLSales.SalesOrderHeader.TotalDue money(19,4) NOT NULL
   ColumnSales.SalesOrderHeader.[Comment] nvarchar(128) NULLSales.SalesOrderHeader.[Comment] nvarchar(128) NULL
   ColumnSales.SalesOrderHeader.rowguid uniqueidentifier NOT NULL default newid()Sales.SalesOrderHeader.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.SalesOrderHeader.ModifiedDate datetime2 NOT NULL default getdate()Sales.SalesOrderHeader.ModifiedDate datetime NOT NULL default getdate()
TableSales.SalesOrderHeaderSales.SalesOrderHeader
   ColumnSales.SalesOrderHeaderSalesReason.SalesOrderID int NOT NULL Primary KeySales.SalesOrderHeaderSalesReason.SalesOrderID int NOT NULL Primary Key
   ColumnSales.SalesOrderHeaderSalesReason.SalesReasonID int NOT NULL Primary KeySales.SalesOrderHeaderSalesReason.SalesReasonID int NOT NULL Primary Key
   ColumnSales.SalesOrderHeaderSalesReason.ModifiedDate datetime2 NOT NULL default getdate()Sales.SalesOrderHeaderSalesReason.ModifiedDate datetime NOT NULL default getdate()
TableSales.SalesOrderHeaderSalesReasonSales.SalesOrderHeaderSalesReason
   ColumnSales.SalesPerson.SalesPersonID int NOT NULL Primary KeySales.SalesPerson.SalesPersonID int NOT NULL Primary Key
   ColumnSales.SalesPerson.TerritoryID int NULLSales.SalesPerson.TerritoryID int NULL
   ColumnSales.SalesPerson.SalesQuota decimal(19,4) NULL CHECK ([SalesQuota]>(0.00))Sales.SalesPerson.SalesQuota money(19,4) NULL CHECK ([SalesQuota]>(0.00))
   ColumnSales.SalesPerson.Bonus decimal(19,4) NOT NULL default (0.00) CHECK ([Bonus]>=(0.00))Sales.SalesPerson.Bonus money(19,4) NOT NULL default (0.00) CHECK ([Bonus]>=(0.00))
   ColumnSales.SalesPerson.CommissionPct decimal(10,4) NOT NULL default (0.00) CHECK ([CommissionPct]>=(0.00))Sales.SalesPerson.CommissionPct smallmoney(10,4) NOT NULL default (0.00) CHECK ([CommissionPct]>=(0.00))
   ColumnSales.SalesPerson.SalesYTD decimal(19,4) NOT NULL default (0.00) CHECK ([SalesYTD]>=(0.00))Sales.SalesPerson.SalesYTD money(19,4) NOT NULL default (0.00) CHECK ([SalesYTD]>=(0.00))
   ColumnSales.SalesPerson.SalesLastYear decimal(19,4) NOT NULL default (0.00) CHECK ([SalesLastYear]>=(0.00))Sales.SalesPerson.SalesLastYear money(19,4) NOT NULL default (0.00) CHECK ([SalesLastYear]>=(0.00))
   ColumnSales.SalesPerson.rowguid uniqueidentifier NOT NULL default newid()Sales.SalesPerson.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.SalesPerson.ModifiedDate datetime2 NOT NULL default getdate()Sales.SalesPerson.ModifiedDate datetime NOT NULL default getdate()
TableSales.SalesPersonSales.SalesPerson
   ColumnSales.SalesPersonQuotaHistory.SalesPersonID int NOT NULL Primary KeySales.SalesPersonQuotaHistory.SalesPersonID int NOT NULL Primary Key
   ColumnSales.SalesPersonQuotaHistory.QuotaDate datetime2 NOT NULL Primary KeySales.SalesPersonQuotaHistory.QuotaDate datetime NOT NULL Primary Key
   ColumnSales.SalesPersonQuotaHistory.SalesQuota decimal(19,4) NOT NULL CHECK ([SalesQuota]>(0.00))Sales.SalesPersonQuotaHistory.SalesQuota money(19,4) NOT NULL CHECK ([SalesQuota]>(0.00))
   ColumnSales.SalesPersonQuotaHistory.rowguid uniqueidentifier NOT NULL default newid()Sales.SalesPersonQuotaHistory.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.SalesPersonQuotaHistory.ModifiedDate datetime2 NOT NULL default getdate()Sales.SalesPersonQuotaHistory.ModifiedDate datetime NOT NULL default getdate()
TableSales.SalesPersonQuotaHistorySales.SalesPersonQuotaHistory
   ColumnSales.SalesReason.SalesReasonID int identity NOT NULL Primary KeySales.SalesReason.SalesReasonID int identity NOT NULL Primary Key
   ColumnSales.SalesReason.Name nvarchar(50) NOT NULLSales.SalesReason.Name Name NOT NULL
   ColumnSales.SalesReason.ReasonType nvarchar(50) NOT NULLSales.SalesReason.ReasonType Name NOT NULL
   ColumnSales.SalesReason.ModifiedDate datetime2 NOT NULL default getdate()Sales.SalesReason.ModifiedDate datetime NOT NULL default getdate()
TableSales.SalesReasonSales.SalesReason
   ColumnSales.SalesTaxRate.SalesTaxRateID int identity NOT NULL Primary KeySales.SalesTaxRate.SalesTaxRateID int identity NOT NULL Primary Key
   ColumnSales.SalesTaxRate.StateProvinceID int NOT NULLSales.SalesTaxRate.StateProvinceID int NOT NULL
   ColumnSales.SalesTaxRate.TaxType tinyint NOT NULL CHECK ([TaxType]>=(1) AND [TaxType]<=(3))Sales.SalesTaxRate.TaxType tinyint NOT NULL CHECK ([TaxType]>=(1) AND [TaxType]<=(3))
   ColumnSales.SalesTaxRate.TaxRate decimal(10,4) NOT NULL default (0.00)Sales.SalesTaxRate.TaxRate smallmoney(10,4) NOT NULL default (0.00)
   ColumnSales.SalesTaxRate.Name nvarchar(50) NOT NULLSales.SalesTaxRate.Name Name NOT NULL
   ColumnSales.SalesTaxRate.rowguid uniqueidentifier NOT NULL default newid()Sales.SalesTaxRate.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.SalesTaxRate.ModifiedDate datetime2 NOT NULL default getdate()Sales.SalesTaxRate.ModifiedDate datetime NOT NULL default getdate()
TableSales.SalesTaxRateSales.SalesTaxRate
   ColumnSales.SalesTerritory.TerritoryID int identity NOT NULL Primary KeySales.SalesTerritory.TerritoryID int identity NOT NULL Primary Key
   ColumnSales.SalesTerritory.Name nvarchar(50) NOT NULLSales.SalesTerritory.Name Name NOT NULL
   ColumnSales.SalesTerritory.CountryRegionCode nvarchar(3) NOT NULLSales.SalesTerritory.CountryRegionCode nvarchar(3) NOT NULL
   ColumnSales.SalesTerritory.[Group] nvarchar(50) NOT NULLSales.SalesTerritory.[Group] nvarchar(50) NOT NULL
   ColumnSales.SalesTerritory.SalesYTD decimal(19,4) NOT NULL default (0.00) CHECK ([SalesYTD]>=(0.00))Sales.SalesTerritory.SalesYTD money(19,4) NOT NULL default (0.00) CHECK ([SalesYTD]>=(0.00))
   ColumnSales.SalesTerritory.SalesLastYear decimal(19,4) NOT NULL default (0.00) CHECK ([SalesLastYear]>=(0.00))Sales.SalesTerritory.SalesLastYear money(19,4) NOT NULL default (0.00) CHECK ([SalesLastYear]>=(0.00))
   ColumnSales.SalesTerritory.CostYTD decimal(19,4) NOT NULL default (0.00) CHECK ([CostYTD]>=(0.00))Sales.SalesTerritory.CostYTD money(19,4) NOT NULL default (0.00) CHECK ([CostYTD]>=(0.00))
   ColumnSales.SalesTerritory.CostLastYear decimal(19,4) NOT NULL default (0.00) CHECK ([CostLastYear]>=(0.00))Sales.SalesTerritory.CostLastYear money(19,4) NOT NULL default (0.00) CHECK ([CostLastYear]>=(0.00))
   ColumnSales.SalesTerritory.rowguid uniqueidentifier NOT NULL default newid()Sales.SalesTerritory.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.SalesTerritory.ModifiedDate datetime2 NOT NULL default getdate()Sales.SalesTerritory.ModifiedDate datetime NOT NULL default getdate()
TableSales.SalesTerritorySales.SalesTerritory
   ColumnSales.SalesTerritoryHistory.SalesPersonID int NOT NULL Primary KeySales.SalesTerritoryHistory.SalesPersonID int NOT NULL Primary Key
   ColumnSales.SalesTerritoryHistory.TerritoryID int NOT NULL Primary KeySales.SalesTerritoryHistory.TerritoryID int NOT NULL Primary Key
   ColumnSales.SalesTerritoryHistory.StartDate datetime2 NOT NULL Primary KeySales.SalesTerritoryHistory.StartDate datetime NOT NULL Primary Key
   ColumnSales.SalesTerritoryHistory.EndDate datetime2 NULLSales.SalesTerritoryHistory.EndDate datetime NULL
   ColumnSales.SalesTerritoryHistory.rowguid uniqueidentifier NOT NULL default newid()Sales.SalesTerritoryHistory.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.SalesTerritoryHistory.ModifiedDate datetime2 NOT NULL default getdate()Sales.SalesTerritoryHistory.ModifiedDate datetime NOT NULL default getdate()
TableSales.SalesTerritoryHistorySales.SalesTerritoryHistory
   ColumnProduction.ScrapReason.ScrapReasonID smallint identity NOT NULL Primary KeyProduction.ScrapReason.ScrapReasonID smallint identity NOT NULL Primary Key
   ColumnProduction.ScrapReason.Name nvarchar(50) NOT NULLProduction.ScrapReason.Name Name NOT NULL
   ColumnProduction.ScrapReason.ModifiedDate datetime2 NOT NULL default getdate()Production.ScrapReason.ModifiedDate datetime NOT NULL default getdate()
TableProduction.ScrapReasonProduction.ScrapReason
   ColumnHumanResources.Shift.ShiftID tinyint identity NOT NULL Primary KeyHumanResources.Shift.ShiftID tinyint identity NOT NULL Primary Key
   ColumnHumanResources.Shift.Name nvarchar(50) NOT NULLHumanResources.Shift.Name Name NOT NULL
   ColumnHumanResources.Shift.StartTime datetime2 NOT NULLHumanResources.Shift.StartTime datetime NOT NULL
   ColumnHumanResources.Shift.EndTime datetime2 NOT NULLHumanResources.Shift.EndTime datetime NOT NULL
   ColumnHumanResources.Shift.ModifiedDate datetime2 NOT NULL default getdate()HumanResources.Shift.ModifiedDate datetime NOT NULL default getdate()
TableHumanResources.ShiftHumanResources.Shift
   ColumnPurchasing.ShipMethod.ShipMethodID int identity NOT NULL Primary KeyPurchasing.ShipMethod.ShipMethodID int identity NOT NULL Primary Key
   ColumnPurchasing.ShipMethod.Name nvarchar(50) NOT NULLPurchasing.ShipMethod.Name Name NOT NULL
   ColumnPurchasing.ShipMethod.ShipBase decimal(19,4) NOT NULL default (0.00) CHECK ([ShipBase]>(0.00))Purchasing.ShipMethod.ShipBase money(19,4) NOT NULL default (0.00) CHECK ([ShipBase]>(0.00))
   ColumnPurchasing.ShipMethod.ShipRate decimal(19,4) NOT NULL default (0.00) CHECK ([ShipRate]>(0.00))Purchasing.ShipMethod.ShipRate money(19,4) NOT NULL default (0.00) CHECK ([ShipRate]>(0.00))
   ColumnPurchasing.ShipMethod.rowguid uniqueidentifier NOT NULL default newid()Purchasing.ShipMethod.rowguid uniqueidentifier NOT NULL default newid()
   ColumnPurchasing.ShipMethod.ModifiedDate datetime2 NOT NULL default getdate()Purchasing.ShipMethod.ModifiedDate datetime NOT NULL default getdate()
TablePurchasing.ShipMethodPurchasing.ShipMethod
   ColumnSales.ShoppingCartItem.ShoppingCartItemID int identity NOT NULL Primary KeySales.ShoppingCartItem.ShoppingCartItemID int identity NOT NULL Primary Key
   ColumnSales.ShoppingCartItem.ShoppingCartID nvarchar(50) NOT NULLSales.ShoppingCartItem.ShoppingCartID nvarchar(50) NOT NULL
   ColumnSales.ShoppingCartItem.Quantity int NOT NULL default (1) CHECK ([Quantity]>=(1))Sales.ShoppingCartItem.Quantity int NOT NULL default (1) CHECK ([Quantity]>=(1))
   ColumnSales.ShoppingCartItem.ProductID int NOT NULLSales.ShoppingCartItem.ProductID int NOT NULL
   ColumnSales.ShoppingCartItem.DateCreated datetime2 NOT NULL default getdate()Sales.ShoppingCartItem.DateCreated datetime NOT NULL default getdate()
   ColumnSales.ShoppingCartItem.ModifiedDate datetime2 NOT NULL default getdate()Sales.ShoppingCartItem.ModifiedDate datetime NOT NULL default getdate()
TableSales.ShoppingCartItemSales.ShoppingCartItem
   ColumnSales.SpecialOffer.SpecialOfferID int identity NOT NULL Primary KeySales.SpecialOffer.SpecialOfferID int identity NOT NULL Primary Key
   ColumnSales.SpecialOffer.Description nvarchar(255) NOT NULLSales.SpecialOffer.Description nvarchar(255) NOT NULL
   ColumnSales.SpecialOffer.DiscountPct decimal(10,4) NOT NULL default (0.00) CHECK ([DiscountPct]>=(0.00))Sales.SpecialOffer.DiscountPct smallmoney(10,4) NOT NULL default (0.00) CHECK ([DiscountPct]>=(0.00))
   ColumnSales.SpecialOffer.Type nvarchar(50) NOT NULLSales.SpecialOffer.Type nvarchar(50) NOT NULL
   ColumnSales.SpecialOffer.Category nvarchar(50) NOT NULLSales.SpecialOffer.Category nvarchar(50) NOT NULL
   ColumnSales.SpecialOffer.StartDate datetime2 NOT NULLSales.SpecialOffer.StartDate datetime NOT NULL
   ColumnSales.SpecialOffer.EndDate datetime2 NOT NULLSales.SpecialOffer.EndDate datetime NOT NULL
   ColumnSales.SpecialOffer.MinQty int NOT NULL default (0) CHECK ([MinQty]>=(0))Sales.SpecialOffer.MinQty int NOT NULL default (0) CHECK ([MinQty]>=(0))
   ColumnSales.SpecialOffer.MaxQty int NULL CHECK ([MaxQty]>=(0))Sales.SpecialOffer.MaxQty int NULL CHECK ([MaxQty]>=(0))
   ColumnSales.SpecialOffer.rowguid uniqueidentifier NOT NULL default newid()Sales.SpecialOffer.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.SpecialOffer.ModifiedDate datetime2 NOT NULL default getdate()Sales.SpecialOffer.ModifiedDate datetime NOT NULL default getdate()
TableSales.SpecialOfferSales.SpecialOffer
   ColumnSales.SpecialOfferProduct.SpecialOfferID int NOT NULL Primary KeySales.SpecialOfferProduct.SpecialOfferID int NOT NULL Primary Key
   ColumnSales.SpecialOfferProduct.ProductID int NOT NULL Primary KeySales.SpecialOfferProduct.ProductID int NOT NULL Primary Key
   ColumnSales.SpecialOfferProduct.rowguid uniqueidentifier NOT NULL default newid()Sales.SpecialOfferProduct.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.SpecialOfferProduct.ModifiedDate datetime2 NOT NULL default getdate()Sales.SpecialOfferProduct.ModifiedDate datetime NOT NULL default getdate()
TableSales.SpecialOfferProductSales.SpecialOfferProduct
   ColumnPerson.StateProvince.StateProvinceID int identity NOT NULL Primary KeyPerson.StateProvince.StateProvinceID int identity NOT NULL Primary Key
   ColumnPerson.StateProvince.StateProvinceCode nchar(3) NOT NULLPerson.StateProvince.StateProvinceCode nchar(3) NOT NULL
   ColumnPerson.StateProvince.CountryRegionCode nvarchar(3) NOT NULLPerson.StateProvince.CountryRegionCode nvarchar(3) NOT NULL
   ColumnPerson.StateProvince.IsOnlyStateProvinceFlag bit NOT NULL default (1)Person.StateProvince.IsOnlyStateProvinceFlag Flag NOT NULL default (1)
   ColumnPerson.StateProvince.Name nvarchar(50) NOT NULLPerson.StateProvince.Name Name NOT NULL
   ColumnPerson.StateProvince.TerritoryID int NOT NULLPerson.StateProvince.TerritoryID int NOT NULL
   ColumnPerson.StateProvince.rowguid uniqueidentifier NOT NULL default newid()Person.StateProvince.rowguid uniqueidentifier NOT NULL default newid()
   ColumnPerson.StateProvince.ModifiedDate datetime2 NOT NULL default getdate()Person.StateProvince.ModifiedDate datetime NOT NULL default getdate()
TablePerson.StateProvincePerson.StateProvince
   ColumnSales.Store.CustomerID int NOT NULL Primary KeySales.Store.CustomerID int NOT NULL Primary Key
   ColumnSales.Store.Name nvarchar(50) NOT NULLSales.Store.Name Name NOT NULL
   ColumnSales.Store.SalesPersonID int NULLSales.Store.SalesPersonID int NULL
   ColumnSales.Store.Demographics xml NULLSales.Store.Demographics xml NULL
   ColumnSales.Store.rowguid uniqueidentifier NOT NULL default newid()Sales.Store.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.Store.ModifiedDate datetime2 NOT NULL default getdate()Sales.Store.ModifiedDate datetime NOT NULL default getdate()
TableSales.StoreSales.Store
   ColumnSales.StoreContact.CustomerID int NOT NULL Primary KeySales.StoreContact.CustomerID int NOT NULL Primary Key
   ColumnSales.StoreContact.ContactID int NOT NULL Primary KeySales.StoreContact.ContactID int NOT NULL Primary Key
   ColumnSales.StoreContact.ContactTypeID int NOT NULLSales.StoreContact.ContactTypeID int NOT NULL
   ColumnSales.StoreContact.rowguid uniqueidentifier NOT NULL default newid()Sales.StoreContact.rowguid uniqueidentifier NOT NULL default newid()
   ColumnSales.StoreContact.ModifiedDate datetime2 NOT NULL default getdate()Sales.StoreContact.ModifiedDate datetime NOT NULL default getdate()
TableSales.StoreContactSales.StoreContact
   ColumnProduction.TransactionHistory.TransactionID int identity NOT NULL Primary KeyProduction.TransactionHistory.TransactionID int identity NOT NULL Primary Key
   ColumnProduction.TransactionHistory.ProductID int NOT NULLProduction.TransactionHistory.ProductID int NOT NULL
   ColumnProduction.TransactionHistory.ReferenceOrderID int NOT NULLProduction.TransactionHistory.ReferenceOrderID int NOT NULL
   ColumnProduction.TransactionHistory.ReferenceOrderLineID int NOT NULL default (0)Production.TransactionHistory.ReferenceOrderLineID int NOT NULL default (0)
   ColumnProduction.TransactionHistory.TransactionDate datetime2 NOT NULL default getdate()Production.TransactionHistory.TransactionDate datetime NOT NULL default getdate()
   ColumnProduction.TransactionHistory.TransactionType nchar(1) NOT NULL CHECK (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')Production.TransactionHistory.TransactionType nchar(1) NOT NULL CHECK (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')
   ColumnProduction.TransactionHistory.Quantity int NOT NULLProduction.TransactionHistory.Quantity int NOT NULL
   ColumnProduction.TransactionHistory.ActualCost decimal(19,4) NOT NULLProduction.TransactionHistory.ActualCost money(19,4) NOT NULL
   ColumnProduction.TransactionHistory.ModifiedDate datetime2 NOT NULL default getdate()Production.TransactionHistory.ModifiedDate datetime NOT NULL default getdate()
TableProduction.TransactionHistoryProduction.TransactionHistory
   ColumnProduction.TransactionHistoryArchive.TransactionID int NOT NULL Primary KeyProduction.TransactionHistoryArchive.TransactionID int NOT NULL Primary Key
   ColumnProduction.TransactionHistoryArchive.ProductID int NOT NULLProduction.TransactionHistoryArchive.ProductID int NOT NULL
   ColumnProduction.TransactionHistoryArchive.ReferenceOrderID int NOT NULLProduction.TransactionHistoryArchive.ReferenceOrderID int NOT NULL
   ColumnProduction.TransactionHistoryArchive.ReferenceOrderLineID int NOT NULL default (0)Production.TransactionHistoryArchive.ReferenceOrderLineID int NOT NULL default (0)
   ColumnProduction.TransactionHistoryArchive.TransactionDate datetime2 NOT NULL default getdate()Production.TransactionHistoryArchive.TransactionDate datetime NOT NULL default getdate()
   ColumnProduction.TransactionHistoryArchive.TransactionType nchar(1) NOT NULL CHECK (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')Production.TransactionHistoryArchive.TransactionType nchar(1) NOT NULL CHECK (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')
   ColumnProduction.TransactionHistoryArchive.Quantity int NOT NULLProduction.TransactionHistoryArchive.Quantity int NOT NULL
   ColumnProduction.TransactionHistoryArchive.ActualCost decimal(19,4) NOT NULLProduction.TransactionHistoryArchive.ActualCost money(19,4) NOT NULL
   ColumnProduction.TransactionHistoryArchive.ModifiedDate datetime2 NOT NULL default getdate()Production.TransactionHistoryArchive.ModifiedDate datetime NOT NULL default getdate()
TableProduction.TransactionHistoryArchiveProduction.TransactionHistoryArchive
   ColumnProduction.UnitMeasure.UnitMeasureCode nchar(3) NOT NULL Primary KeyProduction.UnitMeasure.UnitMeasureCode nchar(3) NOT NULL Primary Key
   ColumnProduction.UnitMeasure.Name nvarchar(50) NOT NULLProduction.UnitMeasure.Name Name NOT NULL
   ColumnProduction.UnitMeasure.ModifiedDate datetime2 NOT NULL default getdate()Production.UnitMeasure.ModifiedDate datetime NOT NULL default getdate()
TableProduction.UnitMeasureProduction.UnitMeasure
   ColumnPurchasing.Vendor.VendorID int identity NOT NULL Primary KeyPurchasing.Vendor.VendorID int identity NOT NULL Primary Key
   ColumnPurchasing.Vendor.AccountNumber nvarchar(15) NOT NULLPurchasing.Vendor.AccountNumber AccountNumber NOT NULL
   ColumnPurchasing.Vendor.Name nvarchar(50) NOT NULLPurchasing.Vendor.Name Name NOT NULL
   ColumnPurchasing.Vendor.CreditRating tinyint NOT NULL CHECK ([CreditRating]>=(1) AND [CreditRating]<=(5))Purchasing.Vendor.CreditRating tinyint NOT NULL CHECK ([CreditRating]>=(1) AND [CreditRating]<=(5))
   ColumnPurchasing.Vendor.PreferredVendorStatus bit NOT NULL default (1)Purchasing.Vendor.PreferredVendorStatus Flag NOT NULL default (1)
   ColumnPurchasing.Vendor.ActiveFlag bit NOT NULL default (1)Purchasing.Vendor.ActiveFlag Flag NOT NULL default (1)
   ColumnPurchasing.Vendor.PurchasingWebServiceURL nvarchar(1024) NULLPurchasing.Vendor.PurchasingWebServiceURL nvarchar(1024) NULL
   ColumnPurchasing.Vendor.ModifiedDate datetime2 NOT NULL default getdate()Purchasing.Vendor.ModifiedDate datetime NOT NULL default getdate()
TablePurchasing.VendorPurchasing.Vendor
   ColumnPurchasing.VendorAddress.VendorID int NOT NULL Primary KeyPurchasing.VendorAddress.VendorID int NOT NULL Primary Key
   ColumnPurchasing.VendorAddress.AddressID int NOT NULL Primary KeyPurchasing.VendorAddress.AddressID int NOT NULL Primary Key
   ColumnPurchasing.VendorAddress.AddressTypeID int NOT NULLPurchasing.VendorAddress.AddressTypeID int NOT NULL
   ColumnPurchasing.VendorAddress.ModifiedDate datetime2 NOT NULL default getdate()Purchasing.VendorAddress.ModifiedDate datetime NOT NULL default getdate()
TablePurchasing.VendorAddressPurchasing.VendorAddress
   ColumnPurchasing.VendorContact.VendorID int NOT NULL Primary KeyPurchasing.VendorContact.VendorID int NOT NULL Primary Key
   ColumnPurchasing.VendorContact.ContactID int NOT NULL Primary KeyPurchasing.VendorContact.ContactID int NOT NULL Primary Key
   ColumnPurchasing.VendorContact.ContactTypeID int NOT NULLPurchasing.VendorContact.ContactTypeID int NOT NULL
   ColumnPurchasing.VendorContact.ModifiedDate datetime2 NOT NULL default getdate()Purchasing.VendorContact.ModifiedDate datetime NOT NULL default getdate()
TablePurchasing.VendorContactPurchasing.VendorContact
   ColumnProduction.WorkOrder.WorkOrderID int identity NOT NULL Primary KeyProduction.WorkOrder.WorkOrderID int identity NOT NULL Primary Key
   ColumnProduction.WorkOrder.ProductID int NOT NULLProduction.WorkOrder.ProductID int NOT NULL
   ColumnProduction.WorkOrder.OrderQty int NOT NULL CHECK ([OrderQty]>(0))Production.WorkOrder.OrderQty int NOT NULL CHECK ([OrderQty]>(0))
   ColumnProduction.WorkOrder.StockedQty int NOT NULLProduction.WorkOrder.StockedQty int NOT NULL
   ColumnProduction.WorkOrder.ScrappedQty smallint NOT NULL CHECK ([ScrappedQty]>=(0))Production.WorkOrder.ScrappedQty smallint NOT NULL CHECK ([ScrappedQty]>=(0))
   ColumnProduction.WorkOrder.StartDate datetime2 NOT NULLProduction.WorkOrder.StartDate datetime NOT NULL
   ColumnProduction.WorkOrder.EndDate datetime2 NULLProduction.WorkOrder.EndDate datetime NULL
   ColumnProduction.WorkOrder.DueDate datetime2 NOT NULLProduction.WorkOrder.DueDate datetime NOT NULL
   ColumnProduction.WorkOrder.ScrapReasonID smallint NULLProduction.WorkOrder.ScrapReasonID smallint NULL
   ColumnProduction.WorkOrder.ModifiedDate datetime2 NOT NULL default getdate()Production.WorkOrder.ModifiedDate datetime NOT NULL default getdate()
TableProduction.WorkOrderProduction.WorkOrder
   ColumnProduction.WorkOrderRouting.WorkOrderID int NOT NULL Primary KeyProduction.WorkOrderRouting.WorkOrderID int NOT NULL Primary Key
   ColumnProduction.WorkOrderRouting.ProductID int NOT NULL Primary KeyProduction.WorkOrderRouting.ProductID int NOT NULL Primary Key
   ColumnProduction.WorkOrderRouting.OperationSequence smallint NOT NULL Primary KeyProduction.WorkOrderRouting.OperationSequence smallint NOT NULL Primary Key
   ColumnProduction.WorkOrderRouting.LocationID smallint NOT NULLProduction.WorkOrderRouting.LocationID smallint NOT NULL
   ColumnProduction.WorkOrderRouting.ScheduledStartDate datetime2 NOT NULLProduction.WorkOrderRouting.ScheduledStartDate datetime NOT NULL
   ColumnProduction.WorkOrderRouting.ScheduledEndDate datetime2 NOT NULLProduction.WorkOrderRouting.ScheduledEndDate datetime NOT NULL
   ColumnProduction.WorkOrderRouting.ActualStartDate datetime2 NULLProduction.WorkOrderRouting.ActualStartDate datetime NULL
   ColumnProduction.WorkOrderRouting.ActualEndDate datetime2 NULLProduction.WorkOrderRouting.ActualEndDate datetime NULL
   ColumnProduction.WorkOrderRouting.ActualResourceHrs decimal(9,4) NULL CHECK ([ActualResourceHrs]>=(0.0000))Production.WorkOrderRouting.ActualResourceHrs decimal(9,4) NULL CHECK ([ActualResourceHrs]>=(0.0000))
   ColumnProduction.WorkOrderRouting.PlannedCost decimal(19,4) NOT NULL CHECK ([PlannedCost]>(0.00))Production.WorkOrderRouting.PlannedCost money(19,4) NOT NULL CHECK ([PlannedCost]>(0.00))
   ColumnProduction.WorkOrderRouting.ActualCost decimal(19,4) NULL CHECK ([ActualCost]>(0.00))Production.WorkOrderRouting.ActualCost money(19,4) NULL CHECK ([ActualCost]>(0.00))
   ColumnProduction.WorkOrderRouting.ModifiedDate datetime2 NOT NULL default getdate()Production.WorkOrderRouting.ModifiedDate datetime NOT NULL default getdate()
TableProduction.WorkOrderRoutingProduction.WorkOrderRouting
View   Person.vAdditionalContactInfo
ViewHumanResources.vEmployeeHumanResources.vEmployee
ViewHumanResources.vEmployeeDepartmentHumanResources.vEmployeeDepartment
ViewHumanResources.vEmployeeDepartmentHistoryHumanResources.vEmployeeDepartmentHistory
ViewSales.vIndividualCustomerSales.vIndividualCustomer
ViewSales.vIndividualDemographicsSales.vIndividualDemographics
ViewHumanResources.vJobCandidateHumanResources.vJobCandidate
ViewHumanResources.vJobCandidateEducationHumanResources.vJobCandidateEducation
ViewHumanResources.vJobCandidateEmploymentHumanResources.vJobCandidateEmployment
ViewProduction.vProductAndDescriptionProduction.vProductAndDescription
ViewProduction.vProductModelCatalogDescriptionProduction.vProductModelCatalogDescription
ViewProduction.vProductModelInstructionsProduction.vProductModelInstructions
ViewSales.vSalesPersonSales.vSalesPerson
ViewSales.vSalesPersonSalesByFiscalYearsSales.vSalesPersonSalesByFiscalYears
ViewPerson.vStateProvinceCountryRegionPerson.vStateProvinceCountryRegion
ViewSales.vStoreWithDemographicsSales.vStoreWithDemographics
ViewPurchasing.vVendorPurchasing.vVendor
Proceduredbo.ufnGetAccountingEndDatedbo.ufnGetAccountingEndDate
Proceduredbo.ufnGetAccountingStartDatedbo.ufnGetAccountingStartDate
Proceduredbo.ufnGetContactInformationdbo.ufnGetContactInformation
Proceduredbo.ufnGetDocumentStatusTextdbo.ufnGetDocumentStatusText
Proceduredbo.ufnGetProductDealerPricedbo.ufnGetProductDealerPrice
Proceduredbo.ufnGetProductListPricedbo.ufnGetProductListPrice
Proceduredbo.ufnGetProductStandardCostdbo.ufnGetProductStandardCost
Proceduredbo.ufnGetPurchaseOrderStatusTextdbo.ufnGetPurchaseOrderStatusText
Proceduredbo.ufnGetSalesOrderStatusTextdbo.ufnGetSalesOrderStatusText
Proceduredbo.ufnGetStockdbo.ufnGetStock
Proceduredbo.ufnLeadingZerosdbo.ufnLeadingZeros
Proceduredbo.uspGetBillOfMaterialsdbo.uspGetBillOfMaterials
Proceduredbo.uspGetEmployeeManagersdbo.uspGetEmployeeManagers
Proceduredbo.uspGetManagerEmployeesdbo.uspGetManagerEmployees
Proceduredbo.uspGetWhereUsedProductIDdbo.uspGetWhereUsedProductID
Proceduredbo.uspLogErrordbo.uspLogError
Proceduredbo.uspPrintErrordbo.uspPrintError
ProcedureHumanResources.uspUpdateEmployeeHireInfoHumanResources.uspUpdateEmployeeHireInfo
ProcedureHumanResources.uspUpdateEmployeeLoginHumanResources.uspUpdateEmployeeLogin
ProcedureHumanResources.uspUpdateEmployeePersonalInfoHumanResources.uspUpdateEmployeePersonalInfo
IndexAK_Address_rowguidAK_Address_rowguid
IndexAK_AddressType_NameAK_AddressType_Name
IndexAK_AddressType_rowguidAK_AddressType_rowguid
IndexAK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDateAK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
Index   AK_Contact_rowguid
IndexAK_ContactType_NameAK_ContactType_Name
IndexAK_CountryRegion_NameAK_CountryRegion_Name
IndexAK_CreditCard_CardNumberAK_CreditCard_CardNumber
IndexAK_Culture_NameAK_Culture_Name
IndexAK_Currency_NameAK_Currency_Name
IndexAK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCodeAK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
IndexAK_Customer_AccountNumberAK_Customer_AccountNumber
IndexAK_Customer_rowguidAK_Customer_rowguid
IndexAK_CustomerAddress_rowguidAK_CustomerAddress_rowguid
IndexAK_Department_NameAK_Department_Name
Index   AK_Document_FileName_Revision
IndexAK_Employee_LoginIDAK_Employee_LoginID
IndexAK_Employee_NationalIDNumberAK_Employee_NationalIDNumber
IndexAK_Employee_rowguidAK_Employee_rowguid
IndexAK_EmployeeAddress_rowguidAK_EmployeeAddress_rowguid
IndexAK_Location_NameAK_Location_Name
IndexAK_Product_NameAK_Product_Name
IndexAK_Product_ProductNumberAK_Product_ProductNumber
IndexAK_Product_rowguidAK_Product_rowguid
IndexAK_ProductCategory_NameAK_ProductCategory_Name
IndexAK_ProductCategory_rowguidAK_ProductCategory_rowguid
IndexAK_ProductDescription_rowguidAK_ProductDescription_rowguid
IndexAK_ProductModel_NameAK_ProductModel_Name
IndexAK_ProductModel_rowguidAK_ProductModel_rowguid
IndexAK_ProductSubcategory_NameAK_ProductSubcategory_Name
IndexAK_ProductSubcategory_rowguidAK_ProductSubcategory_rowguid
IndexAK_SalesOrderDetail_rowguidAK_SalesOrderDetail_rowguid
IndexAK_SalesOrderHeader_rowguidAK_SalesOrderHeader_rowguid
IndexAK_SalesOrderHeader_SalesOrderNumberAK_SalesOrderHeader_SalesOrderNumber
IndexAK_SalesPerson_rowguidAK_SalesPerson_rowguid
IndexAK_SalesPersonQuotaHistory_rowguidAK_SalesPersonQuotaHistory_rowguid
IndexAK_SalesTaxRate_rowguidAK_SalesTaxRate_rowguid
IndexAK_SalesTaxRate_StateProvinceID_TaxTypeAK_SalesTaxRate_StateProvinceID_TaxType
IndexAK_SalesTerritory_NameAK_SalesTerritory_Name
IndexAK_SalesTerritory_rowguidAK_SalesTerritory_rowguid
IndexAK_SalesTerritoryHistory_rowguidAK_SalesTerritoryHistory_rowguid
IndexAK_ScrapReason_NameAK_ScrapReason_Name
IndexAK_Shift_NameAK_Shift_Name
IndexAK_Shift_StartTime_EndTimeAK_Shift_StartTime_EndTime
IndexAK_ShipMethod_NameAK_ShipMethod_Name
IndexAK_ShipMethod_rowguidAK_ShipMethod_rowguid
IndexAK_SpecialOffer_rowguidAK_SpecialOffer_rowguid
IndexAK_SpecialOfferProduct_rowguidAK_SpecialOfferProduct_rowguid
IndexAK_StateProvince_NameAK_StateProvince_Name
IndexAK_StateProvince_rowguidAK_StateProvince_rowguid
IndexAK_StateProvince_StateProvinceCode_CountryRegionCodeAK_StateProvince_StateProvinceCode_CountryRegionCode
IndexAK_Store_rowguidAK_Store_rowguid
IndexAK_StoreContact_rowguidAK_StoreContact_rowguid
IndexAK_UnitMeasure_NameAK_UnitMeasure_Name
IndexAK_Vendor_AccountNumberAK_Vendor_AccountNumber
IndexIX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeIX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
IndexIX_Address_StateProvinceIDIX_Address_StateProvinceID
IndexIX_BillOfMaterials_UnitMeasureCodeIX_BillOfMaterials_UnitMeasureCode
Index   IX_Contact_EmailAddress
IndexIX_CountryRegionCurrency_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
IndexIX_Customer_TerritoryIDIX_Customer_TerritoryID
IndexIX_Employee_ManagerIDIX_Employee_ManagerID
IndexIX_EmployeeDepartmentHistory_DepartmentIDIX_EmployeeDepartmentHistory_DepartmentID
IndexIX_EmployeeDepartmentHistory_ShiftIDIX_EmployeeDepartmentHistory_ShiftID
IndexIX_JobCandidate_EmployeeIDIX_JobCandidate_EmployeeID
IndexIX_ProductReview_ProductID_NameIX_ProductReview_ProductID_Name
IndexIX_ProductVendor_UnitMeasureCodeIX_ProductVendor_UnitMeasureCode
IndexIX_ProductVendor_VendorIDIX_ProductVendor_VendorID
IndexIX_PurchaseOrderDetail_ProductIDIX_PurchaseOrderDetail_ProductID
IndexIX_PurchaseOrderHeader_EmployeeIDIX_PurchaseOrderHeader_EmployeeID
IndexIX_PurchaseOrderHeader_VendorIDIX_PurchaseOrderHeader_VendorID
IndexIX_SalesOrderDetail_ProductIDIX_SalesOrderDetail_ProductID
IndexIX_SalesOrderHeader_CustomerIDIX_SalesOrderHeader_CustomerID
IndexIX_SalesOrderHeader_SalesPersonIDIX_SalesOrderHeader_SalesPersonID
IndexIX_ShoppingCartItem_ShoppingCartID_ProductIDIX_ShoppingCartItem_ShoppingCartID_ProductID
IndexIX_SpecialOfferProduct_ProductIDIX_SpecialOfferProduct_ProductID
IndexIX_Store_SalesPersonIDIX_Store_SalesPersonID
IndexIX_StoreContact_ContactIDIX_StoreContact_ContactID
IndexIX_StoreContact_ContactTypeIDIX_StoreContact_ContactTypeID
IndexIX_TransactionHistory_ProductIDIX_TransactionHistory_ProductID
IndexIX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineIDIX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
IndexIX_TransactionHistoryArchive_ProductIDIX_TransactionHistoryArchive_ProductID
IndexIX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineIDIX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
IndexIX_VendorAddress_AddressIDIX_VendorAddress_AddressID
IndexIX_VendorContact_ContactIDIX_VendorContact_ContactID
IndexIX_VendorContact_ContactTypeIDIX_VendorContact_ContactTypeID
IndexIX_WorkOrder_ProductIDIX_WorkOrder_ProductID
IndexIX_WorkOrder_ScrapReasonIDIX_WorkOrder_ScrapReasonID
IndexIX_WorkOrderRouting_ProductIDIX_WorkOrderRouting_ProductID
IndexPK_Address_AddressIDPK_Address_AddressID
IndexPK_AddressType_AddressTypeIDPK_AddressType_AddressTypeID
IndexPK_AWBuildVersion_SystemInformationIDPK_AWBuildVersion_SystemInformationID
IndexPK_BillOfMaterials_BillOfMaterialsIDPK_BillOfMaterials_BillOfMaterialsID
IndexPK_Contact_ContactIDPK_Contact_ContactID
IndexPK_ContactCreditCard_ContactID_CreditCardIDPK_ContactCreditCard_ContactID_CreditCardID
IndexPK_ContactType_ContactTypeIDPK_ContactType_ContactTypeID
IndexPK_CountryRegion_CountryRegionCodePK_CountryRegion_CountryRegionCode
IndexPK_CountryRegionCurrency_CountryRegionCode_CurrencyCodePK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
IndexPK_CreditCard_CreditCardIDPK_CreditCard_CreditCardID
IndexPK_Culture_CultureIDPK_Culture_CultureID
IndexPK_Currency_CurrencyCodePK_Currency_CurrencyCode
IndexPK_CurrencyRate_CurrencyRateIDPK_CurrencyRate_CurrencyRateID
IndexPK_Customer_CustomerIDPK_Customer_CustomerID
IndexPK_CustomerAddress_CustomerID_AddressIDPK_CustomerAddress_CustomerID_AddressID
IndexPK_DatabaseLog_DatabaseLogIDPK_DatabaseLog_DatabaseLogID
IndexPK_Department_DepartmentIDPK_Department_DepartmentID
IndexPK_Document_DocumentIDPK_Document_DocumentID
IndexPK_Employee_EmployeeIDPK_Employee_EmployeeID
IndexPK_EmployeeAddress_EmployeeID_AddressIDPK_EmployeeAddress_EmployeeID_AddressID
IndexPK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentIDPK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
IndexPK_EmployeePayHistory_EmployeeID_RateChangeDatePK_EmployeePayHistory_EmployeeID_RateChangeDate
IndexPK_ErrorLog_ErrorLogIDPK_ErrorLog_ErrorLogID
IndexPK_Illustration_IllustrationIDPK_Illustration_IllustrationID
IndexPK_Individual_CustomerIDPK_Individual_CustomerID
IndexPK_JobCandidate_JobCandidateIDPK_JobCandidate_JobCandidateID
IndexPK_Location_LocationIDPK_Location_LocationID
IndexPK_Product_ProductIDPK_Product_ProductID
IndexPK_ProductCategory_ProductCategoryIDPK_ProductCategory_ProductCategoryID
IndexPK_ProductCostHistory_ProductID_StartDatePK_ProductCostHistory_ProductID_StartDate
IndexPK_ProductDescription_ProductDescriptionIDPK_ProductDescription_ProductDescriptionID
IndexPK_ProductDocument_ProductID_DocumentIDPK_ProductDocument_ProductID_DocumentID
IndexPK_ProductInventory_ProductID_LocationIDPK_ProductInventory_ProductID_LocationID
IndexPK_ProductListPriceHistory_ProductID_StartDatePK_ProductListPriceHistory_ProductID_StartDate
IndexPK_ProductModel_ProductModelIDPK_ProductModel_ProductModelID
IndexPK_ProductModelIllustration_ProductModelID_IllustrationIDPK_ProductModelIllustration_ProductModelID_IllustrationID
IndexPK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureIDPK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
IndexPK_ProductPhoto_ProductPhotoIDPK_ProductPhoto_ProductPhotoID
IndexPK_ProductProductPhoto_ProductID_ProductPhotoIDPK_ProductProductPhoto_ProductID_ProductPhotoID
IndexPK_ProductReview_ProductReviewIDPK_ProductReview_ProductReviewID
IndexPK_ProductSubcategory_ProductSubcategoryIDPK_ProductSubcategory_ProductSubcategoryID
IndexPK_ProductVendor_ProductID_VendorIDPK_ProductVendor_ProductID_VendorID
IndexPK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailIDPK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
IndexPK_PurchaseOrderHeader_PurchaseOrderIDPK_PurchaseOrderHeader_PurchaseOrderID
IndexPK_SalesOrderDetail_SalesOrderID_SalesOrderDetailIDPK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
IndexPK_SalesOrderHeader_SalesOrderIDPK_SalesOrderHeader_SalesOrderID
IndexPK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonIDPK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
IndexPK_SalesPerson_SalesPersonIDPK_SalesPerson_SalesPersonID
IndexPK_SalesPersonQuotaHistory_SalesPersonID_QuotaDatePK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
IndexPK_SalesReason_SalesReasonIDPK_SalesReason_SalesReasonID
IndexPK_SalesTaxRate_SalesTaxRateIDPK_SalesTaxRate_SalesTaxRateID
IndexPK_SalesTerritory_TerritoryIDPK_SalesTerritory_TerritoryID
IndexPK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryIDPK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
IndexPK_ScrapReason_ScrapReasonIDPK_ScrapReason_ScrapReasonID
IndexPK_Shift_ShiftIDPK_Shift_ShiftID
IndexPK_ShipMethod_ShipMethodIDPK_ShipMethod_ShipMethodID
IndexPK_ShoppingCartItem_ShoppingCartItemIDPK_ShoppingCartItem_ShoppingCartItemID
IndexPK_SpecialOffer_SpecialOfferIDPK_SpecialOffer_SpecialOfferID
IndexPK_SpecialOfferProduct_SpecialOfferID_ProductIDPK_SpecialOfferProduct_SpecialOfferID_ProductID
IndexPK_StateProvince_StateProvinceIDPK_StateProvince_StateProvinceID
IndexPK_Store_CustomerIDPK_Store_CustomerID
IndexPK_StoreContact_CustomerID_ContactIDPK_StoreContact_CustomerID_ContactID
IndexPK_TransactionHistory_TransactionIDPK_TransactionHistory_TransactionID
IndexPK_TransactionHistoryArchive_TransactionIDPK_TransactionHistoryArchive_TransactionID
IndexPK_UnitMeasure_UnitMeasureCodePK_UnitMeasure_UnitMeasureCode
IndexPK_Vendor_VendorIDPK_Vendor_VendorID
IndexPK_VendorAddress_VendorID_AddressIDPK_VendorAddress_VendorID_AddressID
IndexPK_VendorContact_VendorID_ContactIDPK_VendorContact_VendorID_ContactID
IndexPK_WorkOrder_WorkOrderIDPK_WorkOrder_WorkOrderID
IndexPK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequencePK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
Index   PXML_Contact_AddContact
Index   PXML_Individual_Demographics
Index   PXML_ProductModel_CatalogDescription
Index   PXML_ProductModel_Instructions
Index   PXML_Store_Demographics
Index   XMLPATH_Individual_Demographics
Index   XMLPROPERTY_Individual_Demographics
Index   XMLVALUE_Individual_Demographics
Trigger   dEmployee
Trigger   dVendor
Trigger   iduSalesOrderDetail
Trigger   iPurchaseOrderDetail
Trigger   iStore
Trigger   iuIndividual
Trigger   iWorkOrder
Trigger   uPurchaseOrderDetail
Trigger   uPurchaseOrderHeader
Trigger   uSalesOrderHeader
Trigger   uWorkOrder
Foreign Key   FK_Address_StateProvince_StateProvinceID
Foreign Key   FK_BillOfMaterials_Product_ComponentID
Foreign Key   FK_BillOfMaterials_Product_ProductAssemblyID
Foreign Key   FK_BillOfMaterials_UnitMeasure_UnitMeasureCode
Foreign Key   FK_ContactCreditCard_CreditCard_CreditCardID
Foreign Key   FK_CountryRegionCurrency_Currency_CurrencyCode
Foreign Key   FK_CurrencyRate_Currency_FromCurrencyCode
Foreign Key   FK_CurrencyRate_Currency_ToCurrencyCode
Foreign Key   FK_Customer_SalesTerritory_TerritoryID
Foreign Key   FK_CustomerAddress_Customer_CustomerID
Foreign Key   FK_Employee_Employee_ManagerID
Foreign Key   FK_EmployeeAddress_Employee_EmployeeID
Foreign Key   FK_EmployeeDepartmentHistory_Department_DepartmentID
Foreign Key   FK_EmployeeDepartmentHistory_Employee_EmployeeID
Foreign Key   FK_EmployeeDepartmentHistory_Shift_ShiftID
Foreign Key   FK_EmployeePayHistory_Employee_EmployeeID
Foreign Key   FK_Individual_Customer_CustomerID
Foreign Key   FK_JobCandidate_Employee_EmployeeID
Foreign Key   FK_Product_ProductModel_ProductModelID
Foreign Key   FK_Product_ProductSubcategory_ProductSubcategoryID
Foreign Key   FK_Product_UnitMeasure_SizeUnitMeasureCode
Foreign Key   FK_Product_UnitMeasure_WeightUnitMeasureCode
Foreign Key   FK_ProductCostHistory_Product_ProductID
Foreign Key   FK_ProductDocument_Document_DocumentID
Foreign Key   FK_ProductDocument_Product_ProductID
Foreign Key   FK_ProductInventory_Location_LocationID
Foreign Key   FK_ProductInventory_Product_ProductID
Foreign Key   FK_ProductListPriceHistory_Product_ProductID
Foreign Key   FK_ProductModelIllustration_Illustration_IllustrationID
Foreign Key   FK_ProductModelIllustration_ProductModel_ProductModelID
Foreign Key   FK_ProductModelProductDescriptionCulture_Culture_CultureID
Foreign Key   FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID
Foreign Key   FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID
Foreign Key   FK_ProductProductPhoto_Product_ProductID
Foreign Key   FK_ProductProductPhoto_ProductPhoto_ProductPhotoID
Foreign Key   FK_ProductReview_Product_ProductID
Foreign Key   FK_ProductSubcategory_ProductCategory_ProductCategoryID
Foreign Key   FK_ProductVendor_Vendor_VendorID
Foreign Key   FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID
Foreign Key   FK_PurchaseOrderHeader_ShipMethod_ShipMethodID
Foreign Key   FK_PurchaseOrderHeader_Vendor_VendorID
Foreign Key   FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID
Foreign Key   FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID
Foreign Key   FK_SalesOrderHeader_CreditCard_CreditCardID
Foreign Key   FK_SalesOrderHeader_CurrencyRate_CurrencyRateID
Foreign Key   FK_SalesOrderHeader_Customer_CustomerID
Foreign Key   FK_SalesOrderHeader_SalesPerson_SalesPersonID
Foreign Key   FK_SalesOrderHeader_SalesTerritory_TerritoryID
Foreign Key   FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID
Foreign Key   FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID
Foreign Key   FK_SalesPerson_SalesTerritory_TerritoryID
Foreign Key   FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID
Foreign Key   FK_SalesTerritoryHistory_SalesPerson_SalesPersonID
Foreign Key   FK_SalesTerritoryHistory_SalesTerritory_TerritoryID
Foreign Key   FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID
Foreign Key   FK_StateProvince_CountryRegion_CountryRegionCode
Foreign Key   FK_Store_Customer_CustomerID
Foreign Key   FK_Store_SalesPerson_SalesPersonID
Foreign Key   FK_StoreContact_Store_CustomerID
Foreign Key   FK_TransactionHistory_Product_ProductID
Foreign Key   FK_VendorAddress_Vendor_VendorID
Foreign Key   FK_VendorContact_Vendor_VendorID
Foreign Key   FK_WorkOrder_Product_ProductID
Foreign Key   FK_WorkOrder_ScrapReason_ScrapReasonID
Foreign Key   FK_WorkOrderRouting_Location_LocationID
Foreign Key   FK_WorkOrderRouting_WorkOrder_WorkOrderID

Summary

Object TypeOrphaned itemsNot matchedMatched
Tables0700
Fields0114365
Views1016
Indexes111155
Procedures0713
Triggers1100
Relatioships6600