Item type | Primary Item | Secondary Item |
---|
Column | Person.Address.AddressID int identity NOT NULL Primary Key | Person.Address.AddressID int identity NOT NULL Primary Key |
Column | Person.Address.AddressLine1 nvarchar(60) NOT NULL | Person.Address.AddressLine1 nvarchar(60) NOT NULL |
Column | Person.Address.AddressLine2 nvarchar(60) NULL | Person.Address.AddressLine2 nvarchar(60) NULL |
Column | Person.Address.City nvarchar(30) NOT NULL | Person.Address.City nvarchar(30) NOT NULL |
Column | Person.Address.StateProvinceID int NOT NULL | Person.Address.StateProvinceID int NOT NULL |
Column | Person.Address.PostalCode nvarchar(15) NOT NULL | Person.Address.PostalCode nvarchar(15) NOT NULL |
Column | Person.Address.rowguid uniqueidentifier NOT NULL default newid() | Person.Address.rowguid uniqueidentifier NOT NULL default newid() |
Column | Person.Address.ModifiedDate datetime2 NOT NULL default getdate() | Person.Address.ModifiedDate datetime NOT NULL default getdate() |
Table | Person.Address | Person.Address |
Column | Person.AddressType.AddressTypeID int identity NOT NULL Primary Key | Person.AddressType.AddressTypeID int identity NOT NULL Primary Key |
Column | Person.AddressType.Name nvarchar(50) NOT NULL | Person.AddressType.Name Name NOT NULL |
Column | Person.AddressType.rowguid uniqueidentifier NOT NULL default newid() | Person.AddressType.rowguid uniqueidentifier NOT NULL default newid() |
Column | Person.AddressType.ModifiedDate datetime2 NOT NULL default getdate() | Person.AddressType.ModifiedDate datetime NOT NULL default getdate() |
Table | Person.AddressType | Person.AddressType |
Column | dbo.AWBuildVersion.SystemInformationID tinyint identity NOT NULL Primary Key | dbo.AWBuildVersion.SystemInformationID tinyint identity NOT NULL Primary Key |
Column | dbo.AWBuildVersion.[Database Version] nvarchar(25) NOT NULL | dbo.AWBuildVersion.[Database Version] nvarchar(25) NOT NULL |
Column | dbo.AWBuildVersion.VersionDate datetime2 NOT NULL | dbo.AWBuildVersion.VersionDate datetime NOT NULL |
Column | dbo.AWBuildVersion.ModifiedDate datetime2 NOT NULL default getdate() | dbo.AWBuildVersion.ModifiedDate datetime NOT NULL default getdate() |
Table | dbo.AWBuildVersion | dbo.AWBuildVersion |
Column | Production.BillOfMaterials.BillOfMaterialsID int identity NOT NULL Primary Key | Production.BillOfMaterials.BillOfMaterialsID int identity NOT NULL Primary Key |
Column | Production.BillOfMaterials.ProductAssemblyID int NULL | Production.BillOfMaterials.ProductAssemblyID int NULL |
Column | Production.BillOfMaterials.ComponentID int NOT NULL | Production.BillOfMaterials.ComponentID int NOT NULL |
Column | Production.BillOfMaterials.StartDate datetime2 NOT NULL default getdate() | Production.BillOfMaterials.StartDate datetime NOT NULL default getdate() |
Column | Production.BillOfMaterials.EndDate datetime2 NULL | Production.BillOfMaterials.EndDate datetime NULL |
Column | Production.BillOfMaterials.UnitMeasureCode nchar(3) NOT NULL | Production.BillOfMaterials.UnitMeasureCode nchar(3) NOT NULL |
Column | Production.BillOfMaterials.BOMLevel smallint NOT NULL | Production.BillOfMaterials.BOMLevel smallint NOT NULL |
Column | Production.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)) |
Column | Production.BillOfMaterials.ModifiedDate datetime2 NOT NULL default getdate() | Production.BillOfMaterials.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.BillOfMaterials | Production.BillOfMaterials |
Column | Person.Contact.ContactID int identity NOT NULL Primary Key | Person.Contact.ContactID int identity NOT NULL Primary Key |
Column | Person.Contact.NameStyle bit NOT NULL default (0) | Person.Contact.NameStyle NameStyle NOT NULL default (0) |
Column | Person.Contact.Title nvarchar(8) NULL | Person.Contact.Title nvarchar(8) NULL |
Column | Person.Contact.FirstName nvarchar(50) NOT NULL | Person.Contact.FirstName Name NOT NULL |
Column | Person.Contact.MiddleName nvarchar(50) NULL | Person.Contact.MiddleName Name NULL |
Column | Person.Contact.LastName nvarchar(50) NOT NULL | Person.Contact.LastName Name NOT NULL |
Column | Person.Contact.Suffix nvarchar(10) NULL | Person.Contact.Suffix nvarchar(10) NULL |
Column | Person.Contact.EmailAddress nvarchar(50) NULL | Person.Contact.EmailAddress nvarchar(50) NULL |
Column | Person.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)) |
Column | Person.Contact.Phone nvarchar(25) NULL | Person.Contact.Phone Phone NULL |
Column | Person.Contact.PasswordHash varchar(128) NOT NULL | Person.Contact.PasswordHash varchar(128) NOT NULL |
Column | Person.Contact.PasswordSalt varchar(10) NOT NULL | Person.Contact.PasswordSalt varchar(10) NOT NULL |
Column | Person.Contact.AdditionalContactInfo xml NULL | Person.Contact.AdditionalContactInfo xml NULL |
Column | Person.Contact.rowguid uniqueidentifier NOT NULL default newid() | Person.Contact.rowguid uniqueidentifier NOT NULL default newid() |
Column | Person.Contact.ModifiedDate datetime2 NOT NULL default getdate() | Person.Contact.ModifiedDate datetime NOT NULL default getdate() |
Table | Person.Contact | Person.Contact |
Column | Sales.ContactCreditCard.ContactID int NOT NULL Primary Key | Sales.ContactCreditCard.ContactID int NOT NULL Primary Key |
Column | Sales.ContactCreditCard.CreditCardID int NOT NULL Primary Key | Sales.ContactCreditCard.CreditCardID int NOT NULL Primary Key |
Column | Sales.ContactCreditCard.ModifiedDate datetime2 NOT NULL default getdate() | Sales.ContactCreditCard.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.ContactCreditCard | Sales.ContactCreditCard |
Column | Person.ContactType.ContactTypeID int identity NOT NULL Primary Key | Person.ContactType.ContactTypeID int identity NOT NULL Primary Key |
Column | Person.ContactType.Name nvarchar(50) NOT NULL | Person.ContactType.Name Name NOT NULL |
Column | Person.ContactType.ModifiedDate datetime2 NOT NULL default getdate() | Person.ContactType.ModifiedDate datetime NOT NULL default getdate() |
Table | Person.ContactType | Person.ContactType |
Column | Person.CountryRegion.CountryRegionCode nvarchar(3) NOT NULL Primary Key | Person.CountryRegion.CountryRegionCode nvarchar(3) NOT NULL Primary Key |
Column | Person.CountryRegion.Name nvarchar(50) NOT NULL | Person.CountryRegion.Name Name NOT NULL |
Column | Person.CountryRegion.ModifiedDate datetime2 NOT NULL default getdate() | Person.CountryRegion.ModifiedDate datetime NOT NULL default getdate() |
Table | Person.CountryRegion | Person.CountryRegion |
Column | Sales.CountryRegionCurrency.CountryRegionCode nvarchar(3) NOT NULL Primary Key | Sales.CountryRegionCurrency.CountryRegionCode nvarchar(3) NOT NULL Primary Key |
Column | Sales.CountryRegionCurrency.CurrencyCode nchar(3) NOT NULL Primary Key | Sales.CountryRegionCurrency.CurrencyCode nchar(3) NOT NULL Primary Key |
Column | Sales.CountryRegionCurrency.ModifiedDate datetime2 NOT NULL default getdate() | Sales.CountryRegionCurrency.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.CountryRegionCurrency | Sales.CountryRegionCurrency |
Column | Sales.CreditCard.CreditCardID int identity NOT NULL Primary Key | Sales.CreditCard.CreditCardID int identity NOT NULL Primary Key |
Column | Sales.CreditCard.CardType nvarchar(50) NOT NULL | Sales.CreditCard.CardType nvarchar(50) NOT NULL |
Column | Sales.CreditCard.CardNumber nvarchar(25) NOT NULL | Sales.CreditCard.CardNumber nvarchar(25) NOT NULL |
Column | Sales.CreditCard.ExpMonth tinyint NOT NULL | Sales.CreditCard.ExpMonth tinyint NOT NULL |
Column | Sales.CreditCard.ExpYear smallint NOT NULL | Sales.CreditCard.ExpYear smallint NOT NULL |
Column | Sales.CreditCard.ModifiedDate datetime2 NOT NULL default getdate() | Sales.CreditCard.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.CreditCard | Sales.CreditCard |
Column | Production.Culture.CultureID nchar(6) NOT NULL Primary Key | Production.Culture.CultureID nchar(6) NOT NULL Primary Key |
Column | Production.Culture.Name nvarchar(50) NOT NULL | Production.Culture.Name Name NOT NULL |
Column | Production.Culture.ModifiedDate datetime2 NOT NULL default getdate() | Production.Culture.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.Culture | Production.Culture |
Column | Sales.Currency.CurrencyCode nchar(3) NOT NULL Primary Key | Sales.Currency.CurrencyCode nchar(3) NOT NULL Primary Key |
Column | Sales.Currency.Name nvarchar(50) NOT NULL | Sales.Currency.Name Name NOT NULL |
Column | Sales.Currency.ModifiedDate datetime2 NOT NULL default getdate() | Sales.Currency.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.Currency | Sales.Currency |
Column | Sales.CurrencyRate.CurrencyRateID int identity NOT NULL Primary Key | Sales.CurrencyRate.CurrencyRateID int identity NOT NULL Primary Key |
Column | Sales.CurrencyRate.CurrencyRateDate datetime2 NOT NULL | Sales.CurrencyRate.CurrencyRateDate datetime NOT NULL |
Column | Sales.CurrencyRate.FromCurrencyCode nchar(3) NOT NULL | Sales.CurrencyRate.FromCurrencyCode nchar(3) NOT NULL |
Column | Sales.CurrencyRate.ToCurrencyCode nchar(3) NOT NULL | Sales.CurrencyRate.ToCurrencyCode nchar(3) NOT NULL |
Column | Sales.CurrencyRate.AverageRate decimal(19,4) NOT NULL | Sales.CurrencyRate.AverageRate money(19,4) NOT NULL |
Column | Sales.CurrencyRate.EndOfDayRate decimal(19,4) NOT NULL | Sales.CurrencyRate.EndOfDayRate money(19,4) NOT NULL |
Column | Sales.CurrencyRate.ModifiedDate datetime2 NOT NULL default getdate() | Sales.CurrencyRate.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.CurrencyRate | Sales.CurrencyRate |
Column | Sales.Customer.CustomerID int identity NOT NULL Primary Key | Sales.Customer.CustomerID int identity NOT NULL Primary Key |
Column | Sales.Customer.TerritoryID int NULL | Sales.Customer.TerritoryID int NULL |
Column | Sales.Customer.AccountNumber varchar(10) NOT NULL | Sales.Customer.AccountNumber varchar(10) NOT NULL |
Column | Sales.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') |
Column | Sales.Customer.rowguid uniqueidentifier NOT NULL default newid() | Sales.Customer.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.Customer.ModifiedDate datetime2 NOT NULL default getdate() | Sales.Customer.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.Customer | Sales.Customer |
Column | Sales.CustomerAddress.CustomerID int NOT NULL Primary Key | Sales.CustomerAddress.CustomerID int NOT NULL Primary Key |
Column | Sales.CustomerAddress.AddressID int NOT NULL Primary Key | Sales.CustomerAddress.AddressID int NOT NULL Primary Key |
Column | Sales.CustomerAddress.AddressTypeID int NOT NULL | Sales.CustomerAddress.AddressTypeID int NOT NULL |
Column | Sales.CustomerAddress.rowguid uniqueidentifier NOT NULL default newid() | Sales.CustomerAddress.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.CustomerAddress.ModifiedDate datetime2 NOT NULL default getdate() | Sales.CustomerAddress.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.CustomerAddress | Sales.CustomerAddress |
Column | dbo.DatabaseLog.DatabaseLogID int identity NOT NULL Primary Key | dbo.DatabaseLog.DatabaseLogID int identity NOT NULL Primary Key |
Column | dbo.DatabaseLog.PostTime datetime2 NOT NULL | dbo.DatabaseLog.PostTime datetime NOT NULL |
Column | dbo.DatabaseLog.DatabaseUser nvarchar(128) NOT NULL | dbo.DatabaseLog.DatabaseUser sysname(128) NOT NULL |
Column | dbo.DatabaseLog.Event nvarchar(128) NOT NULL | dbo.DatabaseLog.Event sysname(128) NOT NULL |
Column | dbo.DatabaseLog.[Schema] nvarchar(128) NULL | dbo.DatabaseLog.[Schema] sysname(128) NULL |
Column | dbo.DatabaseLog.Object nvarchar(128) NULL | dbo.DatabaseLog.Object sysname(128) NULL |
Column | dbo.DatabaseLog.TSQL nvarchar(max) NOT NULL | dbo.DatabaseLog.TSQL nvarchar(max) NOT NULL |
Column | dbo.DatabaseLog.XmlEvent xml NOT NULL | dbo.DatabaseLog.XmlEvent xml NOT NULL |
Table | dbo.DatabaseLog | dbo.DatabaseLog |
Column | HumanResources.Department.DepartmentID smallint identity NOT NULL Primary Key | HumanResources.Department.DepartmentID smallint identity NOT NULL Primary Key |
Column | HumanResources.Department.Name nvarchar(50) NOT NULL | HumanResources.Department.Name Name NOT NULL |
Column | HumanResources.Department.GroupName nvarchar(50) NOT NULL | HumanResources.Department.GroupName Name NOT NULL |
Column | HumanResources.Department.ModifiedDate datetime2 NOT NULL default getdate() | HumanResources.Department.ModifiedDate datetime NOT NULL default getdate() |
Table | HumanResources.Department | HumanResources.Department |
Column | Production.Document.DocumentID int identity NOT NULL Primary Key | Production.Document.DocumentID int identity NOT NULL Primary Key |
Column | Production.Document.Title nvarchar(50) NOT NULL | Production.Document.Title nvarchar(50) NOT NULL |
Column | Production.Document.FileName nvarchar(400) NOT NULL | Production.Document.FileName nvarchar(400) NOT NULL |
Column | Production.Document.FileExtension nvarchar(8) NOT NULL | Production.Document.FileExtension nvarchar(8) NOT NULL |
Column | Production.Document.Revision nchar(5) NOT NULL | Production.Document.Revision nchar(5) NOT NULL |
Column | Production.Document.ChangeNumber int NOT NULL default (0) | Production.Document.ChangeNumber int NOT NULL default (0) |
Column | Production.Document.Status tinyint NOT NULL CHECK ([Status]>=(1) AND [Status]<=(3)) | Production.Document.Status tinyint NOT NULL CHECK ([Status]>=(1) AND [Status]<=(3)) |
Column | Production.Document.DocumentSummary nvarchar(max) NULL | Production.Document.DocumentSummary nvarchar(max) NULL |
Column | Production.Document.Document varbinary NULL | Production.Document.Document varbinary NULL |
Column | Production.Document.ModifiedDate datetime2 NOT NULL default getdate() | Production.Document.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.Document | Production.Document |
Column | HumanResources.Employee.EmployeeID int identity NOT NULL Primary Key | HumanResources.Employee.EmployeeID int identity NOT NULL Primary Key |
Column | HumanResources.Employee.NationalIDNumber nvarchar(15) NOT NULL | HumanResources.Employee.NationalIDNumber nvarchar(15) NOT NULL |
Column | HumanResources.Employee.ContactID int NOT NULL | HumanResources.Employee.ContactID int NOT NULL |
Column | HumanResources.Employee.LoginID nvarchar(256) NOT NULL | HumanResources.Employee.LoginID nvarchar(256) NOT NULL |
Column | HumanResources.Employee.ManagerID int NULL | HumanResources.Employee.ManagerID int NULL |
Column | HumanResources.Employee.Title nvarchar(50) NOT NULL | HumanResources.Employee.Title nvarchar(50) NOT NULL |
Column | HumanResources.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())) |
Column | HumanResources.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') |
Column | HumanResources.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') |
Column | HumanResources.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())) |
Column | HumanResources.Employee.SalariedFlag bit NOT NULL default (1) | HumanResources.Employee.SalariedFlag Flag NOT NULL default (1) |
Column | HumanResources.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)) |
Column | HumanResources.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)) |
Column | HumanResources.Employee.CurrentFlag bit NOT NULL default (1) | HumanResources.Employee.CurrentFlag Flag NOT NULL default (1) |
Column | HumanResources.Employee.rowguid uniqueidentifier NOT NULL default newid() | HumanResources.Employee.rowguid uniqueidentifier NOT NULL default newid() |
Column | HumanResources.Employee.ModifiedDate datetime2 NOT NULL default getdate() | HumanResources.Employee.ModifiedDate datetime NOT NULL default getdate() |
Table | HumanResources.Employee | HumanResources.Employee |
Column | HumanResources.EmployeeAddress.EmployeeID int NOT NULL Primary Key | HumanResources.EmployeeAddress.EmployeeID int NOT NULL Primary Key |
Column | HumanResources.EmployeeAddress.AddressID int NOT NULL Primary Key | HumanResources.EmployeeAddress.AddressID int NOT NULL Primary Key |
Column | HumanResources.EmployeeAddress.rowguid uniqueidentifier NOT NULL default newid() | HumanResources.EmployeeAddress.rowguid uniqueidentifier NOT NULL default newid() |
Column | HumanResources.EmployeeAddress.ModifiedDate datetime2 NOT NULL default getdate() | HumanResources.EmployeeAddress.ModifiedDate datetime NOT NULL default getdate() |
Table | HumanResources.EmployeeAddress | HumanResources.EmployeeAddress |
Column | HumanResources.EmployeeDepartmentHistory.EmployeeID int NOT NULL Primary Key | HumanResources.EmployeeDepartmentHistory.EmployeeID int NOT NULL Primary Key |
Column | HumanResources.EmployeeDepartmentHistory.DepartmentID smallint NOT NULL Primary Key | HumanResources.EmployeeDepartmentHistory.DepartmentID smallint NOT NULL Primary Key |
Column | HumanResources.EmployeeDepartmentHistory.ShiftID tinyint NOT NULL Primary Key | HumanResources.EmployeeDepartmentHistory.ShiftID tinyint NOT NULL Primary Key |
Column | HumanResources.EmployeeDepartmentHistory.StartDate datetime2 NOT NULL Primary Key | HumanResources.EmployeeDepartmentHistory.StartDate datetime NOT NULL Primary Key |
Column | HumanResources.EmployeeDepartmentHistory.EndDate datetime2 NULL | HumanResources.EmployeeDepartmentHistory.EndDate datetime NULL |
Column | HumanResources.EmployeeDepartmentHistory.ModifiedDate datetime2 NOT NULL default getdate() | HumanResources.EmployeeDepartmentHistory.ModifiedDate datetime NOT NULL default getdate() |
Table | HumanResources.EmployeeDepartmentHistory | HumanResources.EmployeeDepartmentHistory |
Column | HumanResources.EmployeePayHistory.EmployeeID int NOT NULL Primary Key | HumanResources.EmployeePayHistory.EmployeeID int NOT NULL Primary Key |
Column | HumanResources.EmployeePayHistory.RateChangeDate datetime2 NOT NULL Primary Key | HumanResources.EmployeePayHistory.RateChangeDate datetime NOT NULL Primary Key |
Column | HumanResources.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)) |
Column | HumanResources.EmployeePayHistory.PayFrequency tinyint NOT NULL CHECK ([PayFrequency]=(2) OR [PayFrequency]=(1)) | HumanResources.EmployeePayHistory.PayFrequency tinyint NOT NULL CHECK ([PayFrequency]=(2) OR [PayFrequency]=(1)) |
Column | HumanResources.EmployeePayHistory.ModifiedDate datetime2 NOT NULL default getdate() | HumanResources.EmployeePayHistory.ModifiedDate datetime NOT NULL default getdate() |
Table | HumanResources.EmployeePayHistory | HumanResources.EmployeePayHistory |
Column | dbo.ErrorLog.ErrorLogID int identity NOT NULL Primary Key | dbo.ErrorLog.ErrorLogID int identity NOT NULL Primary Key |
Column | dbo.ErrorLog.ErrorTime datetime2 NOT NULL default getdate() | dbo.ErrorLog.ErrorTime datetime NOT NULL default getdate() |
Column | dbo.ErrorLog.UserName nvarchar(128) NOT NULL | dbo.ErrorLog.UserName sysname(128) NOT NULL |
Column | dbo.ErrorLog.ErrorNumber int NOT NULL | dbo.ErrorLog.ErrorNumber int NOT NULL |
Column | dbo.ErrorLog.ErrorSeverity int NULL | dbo.ErrorLog.ErrorSeverity int NULL |
Column | dbo.ErrorLog.ErrorState int NULL | dbo.ErrorLog.ErrorState int NULL |
Column | dbo.ErrorLog.ErrorProcedure nvarchar(126) NULL | dbo.ErrorLog.ErrorProcedure nvarchar(126) NULL |
Column | dbo.ErrorLog.ErrorLine int NULL | dbo.ErrorLog.ErrorLine int NULL |
Column | dbo.ErrorLog.ErrorMessage nvarchar(4000) NOT NULL | dbo.ErrorLog.ErrorMessage nvarchar(4000) NOT NULL |
Table | dbo.ErrorLog | dbo.ErrorLog |
Column | Production.Illustration.IllustrationID int identity NOT NULL Primary Key | Production.Illustration.IllustrationID int identity NOT NULL Primary Key |
Column | Production.Illustration.Diagram xml NULL | Production.Illustration.Diagram xml NULL |
Column | Production.Illustration.ModifiedDate datetime2 NOT NULL default getdate() | Production.Illustration.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.Illustration | Production.Illustration |
Column | Sales.Individual.CustomerID int NOT NULL Primary Key | Sales.Individual.CustomerID int NOT NULL Primary Key |
Column | Sales.Individual.ContactID int NOT NULL | Sales.Individual.ContactID int NOT NULL |
Column | Sales.Individual.Demographics xml NULL | Sales.Individual.Demographics xml NULL |
Column | Sales.Individual.ModifiedDate datetime2 NOT NULL default getdate() | Sales.Individual.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.Individual | Sales.Individual |
Column | HumanResources.JobCandidate.JobCandidateID int identity NOT NULL Primary Key | HumanResources.JobCandidate.JobCandidateID int identity NOT NULL Primary Key |
Column | HumanResources.JobCandidate.EmployeeID int NULL | HumanResources.JobCandidate.EmployeeID int NULL |
Column | HumanResources.JobCandidate.Resume xml NULL | HumanResources.JobCandidate.Resume xml NULL |
Column | HumanResources.JobCandidate.ModifiedDate datetime2 NOT NULL default getdate() | HumanResources.JobCandidate.ModifiedDate datetime NOT NULL default getdate() |
Table | HumanResources.JobCandidate | HumanResources.JobCandidate |
Column | Production.Location.LocationID smallint identity NOT NULL Primary Key | Production.Location.LocationID smallint identity NOT NULL Primary Key |
Column | Production.Location.Name nvarchar(50) NOT NULL | Production.Location.Name Name NOT NULL |
Column | Production.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)) |
Column | Production.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)) |
Column | Production.Location.ModifiedDate datetime2 NOT NULL default getdate() | Production.Location.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.Location | Production.Location |
Column | Production.Product.ProductID int identity NOT NULL Primary Key | Production.Product.ProductID int identity NOT NULL Primary Key |
Column | Production.Product.Name nvarchar(50) NOT NULL | Production.Product.Name Name NOT NULL |
Column | Production.Product.ProductNumber nvarchar(25) NOT NULL | Production.Product.ProductNumber nvarchar(25) NOT NULL |
Column | Production.Product.MakeFlag bit NOT NULL default (1) | Production.Product.MakeFlag Flag NOT NULL default (1) |
Column | Production.Product.FinishedGoodsFlag bit NOT NULL default (1) | Production.Product.FinishedGoodsFlag Flag NOT NULL default (1) |
Column | Production.Product.Color nvarchar(15) NULL | Production.Product.Color nvarchar(15) NULL |
Column | Production.Product.SafetyStockLevel smallint NOT NULL CHECK ([SafetyStockLevel]>(0)) | Production.Product.SafetyStockLevel smallint NOT NULL CHECK ([SafetyStockLevel]>(0)) |
Column | Production.Product.ReorderPoint smallint NOT NULL CHECK ([ReorderPoint]>(0)) | Production.Product.ReorderPoint smallint NOT NULL CHECK ([ReorderPoint]>(0)) |
Column | Production.Product.StandardCost decimal(19,4) NOT NULL CHECK ([StandardCost]>=(0.00)) | Production.Product.StandardCost money(19,4) NOT NULL CHECK ([StandardCost]>=(0.00)) |
Column | Production.Product.ListPrice decimal(19,4) NOT NULL CHECK ([ListPrice]>=(0.00)) | Production.Product.ListPrice money(19,4) NOT NULL CHECK ([ListPrice]>=(0.00)) |
Column | Production.Product.Size nvarchar(5) NULL | Production.Product.Size nvarchar(5) NULL |
Column | Production.Product.SizeUnitMeasureCode nchar(3) NULL | Production.Product.SizeUnitMeasureCode nchar(3) NULL |
Column | Production.Product.WeightUnitMeasureCode nchar(3) NULL | Production.Product.WeightUnitMeasureCode nchar(3) NULL |
Column | Production.Product.Weight decimal(8,2) NULL CHECK ([Weight]>(0.00)) | Production.Product.Weight decimal(8,2) NULL CHECK ([Weight]>(0.00)) |
Column | Production.Product.DaysToManufacture int NOT NULL CHECK ([DaysToManufacture]>=(0)) | Production.Product.DaysToManufacture int NOT NULL CHECK ([DaysToManufacture]>=(0)) |
Column | 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) | 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) |
Column | Production.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) |
Column | Production.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) |
Column | Production.Product.ProductSubcategoryID int NULL | Production.Product.ProductSubcategoryID int NULL |
Column | Production.Product.ProductModelID int NULL | Production.Product.ProductModelID int NULL |
Column | Production.Product.SellStartDate datetime2 NOT NULL | Production.Product.SellStartDate datetime NOT NULL |
Column | Production.Product.SellEndDate datetime2 NULL | Production.Product.SellEndDate datetime NULL |
Column | Production.Product.DiscontinuedDate datetime2 NULL | Production.Product.DiscontinuedDate datetime NULL |
Column | Production.Product.rowguid uniqueidentifier NOT NULL default newid() | Production.Product.rowguid uniqueidentifier NOT NULL default newid() |
Column | Production.Product.ModifiedDate datetime2 NOT NULL default getdate() | Production.Product.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.Product | Production.Product |
Column | Production.ProductCategory.ProductCategoryID int identity NOT NULL Primary Key | Production.ProductCategory.ProductCategoryID int identity NOT NULL Primary Key |
Column | Production.ProductCategory.Name nvarchar(50) NOT NULL | Production.ProductCategory.Name Name NOT NULL |
Column | Production.ProductCategory.rowguid uniqueidentifier NOT NULL default newid() | Production.ProductCategory.rowguid uniqueidentifier NOT NULL default newid() |
Column | Production.ProductCategory.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductCategory.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductCategory | Production.ProductCategory |
Column | Production.ProductCostHistory.ProductID int NOT NULL Primary Key | Production.ProductCostHistory.ProductID int NOT NULL Primary Key |
Column | Production.ProductCostHistory.StartDate datetime2 NOT NULL Primary Key | Production.ProductCostHistory.StartDate datetime NOT NULL Primary Key |
Column | Production.ProductCostHistory.EndDate datetime2 NULL | Production.ProductCostHistory.EndDate datetime NULL |
Column | Production.ProductCostHistory.StandardCost decimal(19,4) NOT NULL CHECK ([StandardCost]>=(0.00)) | Production.ProductCostHistory.StandardCost money(19,4) NOT NULL CHECK ([StandardCost]>=(0.00)) |
Column | Production.ProductCostHistory.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductCostHistory.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductCostHistory | Production.ProductCostHistory |
Column | Production.ProductDescription.ProductDescriptionID int identity NOT NULL Primary Key | Production.ProductDescription.ProductDescriptionID int identity NOT NULL Primary Key |
Column | Production.ProductDescription.Description nvarchar(400) NOT NULL | Production.ProductDescription.Description nvarchar(400) NOT NULL |
Column | Production.ProductDescription.rowguid uniqueidentifier NOT NULL default newid() | Production.ProductDescription.rowguid uniqueidentifier NOT NULL default newid() |
Column | Production.ProductDescription.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductDescription.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductDescription | Production.ProductDescription |
Column | Production.ProductDocument.ProductID int NOT NULL Primary Key | Production.ProductDocument.ProductID int NOT NULL Primary Key |
Column | Production.ProductDocument.DocumentID int NOT NULL Primary Key | Production.ProductDocument.DocumentID int NOT NULL Primary Key |
Column | Production.ProductDocument.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductDocument.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductDocument | Production.ProductDocument |
Column | Production.ProductInventory.ProductID int NOT NULL Primary Key | Production.ProductInventory.ProductID int NOT NULL Primary Key |
Column | Production.ProductInventory.LocationID smallint NOT NULL Primary Key | Production.ProductInventory.LocationID smallint NOT NULL Primary Key |
Column | Production.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') |
Column | Production.ProductInventory.Bin tinyint NOT NULL CHECK ([Bin]>=(0) AND [Bin]<=(100)) | Production.ProductInventory.Bin tinyint NOT NULL CHECK ([Bin]>=(0) AND [Bin]<=(100)) |
Column | Production.ProductInventory.Quantity smallint NOT NULL default (0) | Production.ProductInventory.Quantity smallint NOT NULL default (0) |
Column | Production.ProductInventory.rowguid uniqueidentifier NOT NULL default newid() | Production.ProductInventory.rowguid uniqueidentifier NOT NULL default newid() |
Column | Production.ProductInventory.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductInventory.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductInventory | Production.ProductInventory |
Column | Production.ProductListPriceHistory.ProductID int NOT NULL Primary Key | Production.ProductListPriceHistory.ProductID int NOT NULL Primary Key |
Column | Production.ProductListPriceHistory.StartDate datetime2 NOT NULL Primary Key | Production.ProductListPriceHistory.StartDate datetime NOT NULL Primary Key |
Column | Production.ProductListPriceHistory.EndDate datetime2 NULL | Production.ProductListPriceHistory.EndDate datetime NULL |
Column | Production.ProductListPriceHistory.ListPrice decimal(19,4) NOT NULL CHECK ([ListPrice]>(0.00)) | Production.ProductListPriceHistory.ListPrice money(19,4) NOT NULL CHECK ([ListPrice]>(0.00)) |
Column | Production.ProductListPriceHistory.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductListPriceHistory.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductListPriceHistory | Production.ProductListPriceHistory |
Column | Production.ProductModel.ProductModelID int identity NOT NULL Primary Key | Production.ProductModel.ProductModelID int identity NOT NULL Primary Key |
Column | Production.ProductModel.Name nvarchar(50) NOT NULL | Production.ProductModel.Name Name NOT NULL |
Column | Production.ProductModel.CatalogDescription xml NULL | Production.ProductModel.CatalogDescription xml NULL |
Column | Production.ProductModel.Instructions xml NULL | Production.ProductModel.Instructions xml NULL |
Column | Production.ProductModel.rowguid uniqueidentifier NOT NULL default newid() | Production.ProductModel.rowguid uniqueidentifier NOT NULL default newid() |
Column | Production.ProductModel.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductModel.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductModel | Production.ProductModel |
Column | Production.ProductModelIllustration.ProductModelID int NOT NULL Primary Key | Production.ProductModelIllustration.ProductModelID int NOT NULL Primary Key |
Column | Production.ProductModelIllustration.IllustrationID int NOT NULL Primary Key | Production.ProductModelIllustration.IllustrationID int NOT NULL Primary Key |
Column | Production.ProductModelIllustration.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductModelIllustration.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductModelIllustration | Production.ProductModelIllustration |
Column | Production.ProductModelProductDescriptionCulture.ProductModelID int NOT NULL Primary Key | Production.ProductModelProductDescriptionCulture.ProductModelID int NOT NULL Primary Key |
Column | Production.ProductModelProductDescriptionCulture.ProductDescriptionID int NOT NULL Primary Key | Production.ProductModelProductDescriptionCulture.ProductDescriptionID int NOT NULL Primary Key |
Column | Production.ProductModelProductDescriptionCulture.CultureID nchar(6) NOT NULL Primary Key | Production.ProductModelProductDescriptionCulture.CultureID nchar(6) NOT NULL Primary Key |
Column | Production.ProductModelProductDescriptionCulture.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductModelProductDescriptionCulture.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductModelProductDescriptionCulture | Production.ProductModelProductDescriptionCulture |
Column | Production.ProductPhoto.ProductPhotoID int identity NOT NULL Primary Key | Production.ProductPhoto.ProductPhotoID int identity NOT NULL Primary Key |
Column | Production.ProductPhoto.ThumbNailPhoto varbinary NULL | Production.ProductPhoto.ThumbNailPhoto varbinary NULL |
Column | Production.ProductPhoto.ThumbnailPhotoFileName nvarchar(50) NULL | Production.ProductPhoto.ThumbnailPhotoFileName nvarchar(50) NULL |
Column | Production.ProductPhoto.LargePhoto varbinary NULL | Production.ProductPhoto.LargePhoto varbinary NULL |
Column | Production.ProductPhoto.LargePhotoFileName nvarchar(50) NULL | Production.ProductPhoto.LargePhotoFileName nvarchar(50) NULL |
Column | Production.ProductPhoto.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductPhoto.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductPhoto | Production.ProductPhoto |
Column | Production.ProductProductPhoto.ProductID int NOT NULL Primary Key | Production.ProductProductPhoto.ProductID int NOT NULL Primary Key |
Column | Production.ProductProductPhoto.ProductPhotoID int NOT NULL Primary Key | Production.ProductProductPhoto.ProductPhotoID int NOT NULL Primary Key |
Column | Production.ProductProductPhoto.[Primary] bit NOT NULL default (0) | Production.ProductProductPhoto.[Primary] Flag NOT NULL default (0) |
Column | Production.ProductProductPhoto.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductProductPhoto.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductProductPhoto | Production.ProductProductPhoto |
Column | Production.ProductReview.ProductReviewID int identity NOT NULL Primary Key | Production.ProductReview.ProductReviewID int identity NOT NULL Primary Key |
Column | Production.ProductReview.ProductID int NOT NULL | Production.ProductReview.ProductID int NOT NULL |
Column | Production.ProductReview.ReviewerName nvarchar(50) NOT NULL | Production.ProductReview.ReviewerName Name NOT NULL |
Column | Production.ProductReview.ReviewDate datetime2 NOT NULL default getdate() | Production.ProductReview.ReviewDate datetime NOT NULL default getdate() |
Column | Production.ProductReview.EmailAddress nvarchar(50) NOT NULL | Production.ProductReview.EmailAddress nvarchar(50) NOT NULL |
Column | Production.ProductReview.Rating int NOT NULL CHECK ([Rating]>=(1) AND [Rating]<=(5)) | Production.ProductReview.Rating int NOT NULL CHECK ([Rating]>=(1) AND [Rating]<=(5)) |
Column | Production.ProductReview.Comments nvarchar(3850) NULL | Production.ProductReview.Comments nvarchar(3850) NULL |
Column | Production.ProductReview.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductReview.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductReview | Production.ProductReview |
Column | Production.ProductSubcategory.ProductSubcategoryID int identity NOT NULL Primary Key | Production.ProductSubcategory.ProductSubcategoryID int identity NOT NULL Primary Key |
Column | Production.ProductSubcategory.ProductCategoryID int NOT NULL | Production.ProductSubcategory.ProductCategoryID int NOT NULL |
Column | Production.ProductSubcategory.Name nvarchar(50) NOT NULL | Production.ProductSubcategory.Name Name NOT NULL |
Column | Production.ProductSubcategory.rowguid uniqueidentifier NOT NULL default newid() | Production.ProductSubcategory.rowguid uniqueidentifier NOT NULL default newid() |
Column | Production.ProductSubcategory.ModifiedDate datetime2 NOT NULL default getdate() | Production.ProductSubcategory.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ProductSubcategory | Production.ProductSubcategory |
Column | Purchasing.ProductVendor.ProductID int NOT NULL Primary Key | Purchasing.ProductVendor.ProductID int NOT NULL Primary Key |
Column | Purchasing.ProductVendor.VendorID int NOT NULL Primary Key | Purchasing.ProductVendor.VendorID int NOT NULL Primary Key |
Column | Purchasing.ProductVendor.AverageLeadTime int NOT NULL CHECK ([AverageLeadTime]>=(1)) | Purchasing.ProductVendor.AverageLeadTime int NOT NULL CHECK ([AverageLeadTime]>=(1)) |
Column | Purchasing.ProductVendor.StandardPrice decimal(19,4) NOT NULL CHECK ([StandardPrice]>(0.00)) | Purchasing.ProductVendor.StandardPrice money(19,4) NOT NULL CHECK ([StandardPrice]>(0.00)) |
Column | Purchasing.ProductVendor.LastReceiptCost decimal(19,4) NULL CHECK ([LastReceiptCost]>(0.00)) | Purchasing.ProductVendor.LastReceiptCost money(19,4) NULL CHECK ([LastReceiptCost]>(0.00)) |
Column | Purchasing.ProductVendor.LastReceiptDate datetime2 NULL | Purchasing.ProductVendor.LastReceiptDate datetime NULL |
Column | Purchasing.ProductVendor.MinOrderQty int NOT NULL CHECK ([MinOrderQty]>=(1)) | Purchasing.ProductVendor.MinOrderQty int NOT NULL CHECK ([MinOrderQty]>=(1)) |
Column | Purchasing.ProductVendor.MaxOrderQty int NOT NULL CHECK ([MaxOrderQty]>=(1)) | Purchasing.ProductVendor.MaxOrderQty int NOT NULL CHECK ([MaxOrderQty]>=(1)) |
Column | Purchasing.ProductVendor.OnOrderQty int NULL CHECK ([OnOrderQty]>=(0)) | Purchasing.ProductVendor.OnOrderQty int NULL CHECK ([OnOrderQty]>=(0)) |
Column | Purchasing.ProductVendor.UnitMeasureCode nchar(3) NOT NULL | Purchasing.ProductVendor.UnitMeasureCode nchar(3) NOT NULL |
Column | Purchasing.ProductVendor.ModifiedDate datetime2 NOT NULL default getdate() | Purchasing.ProductVendor.ModifiedDate datetime NOT NULL default getdate() |
Table | Purchasing.ProductVendor | Purchasing.ProductVendor |
Column | Purchasing.PurchaseOrderDetail.PurchaseOrderID int NOT NULL Primary Key | Purchasing.PurchaseOrderDetail.PurchaseOrderID int NOT NULL Primary Key |
Column | Purchasing.PurchaseOrderDetail.PurchaseOrderDetailID int identity NOT NULL Primary Key | Purchasing.PurchaseOrderDetail.PurchaseOrderDetailID int identity NOT NULL Primary Key |
Column | Purchasing.PurchaseOrderDetail.DueDate datetime2 NOT NULL | Purchasing.PurchaseOrderDetail.DueDate datetime NOT NULL |
Column | Purchasing.PurchaseOrderDetail.OrderQty smallint NOT NULL CHECK ([OrderQty]>(0)) | Purchasing.PurchaseOrderDetail.OrderQty smallint NOT NULL CHECK ([OrderQty]>(0)) |
Column | Purchasing.PurchaseOrderDetail.ProductID int NOT NULL | Purchasing.PurchaseOrderDetail.ProductID int NOT NULL |
Column | Purchasing.PurchaseOrderDetail.UnitPrice decimal(19,4) NOT NULL CHECK ([UnitPrice]>=(0.00)) | Purchasing.PurchaseOrderDetail.UnitPrice money(19,4) NOT NULL CHECK ([UnitPrice]>=(0.00)) |
Column | Purchasing.PurchaseOrderDetail.LineTotal decimal(25,4) NOT NULL | Purchasing.PurchaseOrderDetail.LineTotal money(19,4) NOT NULL |
Column | Purchasing.PurchaseOrderDetail.ReceivedQty decimal(8,2) NOT NULL CHECK ([ReceivedQty]>=(0.00)) | Purchasing.PurchaseOrderDetail.ReceivedQty decimal(8,2) NOT NULL CHECK ([ReceivedQty]>=(0.00)) |
Column | Purchasing.PurchaseOrderDetail.RejectedQty decimal(8,2) NOT NULL CHECK ([RejectedQty]>=(0.00)) | Purchasing.PurchaseOrderDetail.RejectedQty decimal(8,2) NOT NULL CHECK ([RejectedQty]>=(0.00)) |
Column | Purchasing.PurchaseOrderDetail.StockedQty decimal(9,2) NOT NULL | Purchasing.PurchaseOrderDetail.StockedQty decimal(9,2) NOT NULL |
Column | Purchasing.PurchaseOrderDetail.ModifiedDate datetime2 NOT NULL default getdate() | Purchasing.PurchaseOrderDetail.ModifiedDate datetime NOT NULL default getdate() |
Table | Purchasing.PurchaseOrderDetail | Purchasing.PurchaseOrderDetail |
Column | Purchasing.PurchaseOrderHeader.PurchaseOrderID int identity NOT NULL Primary Key | Purchasing.PurchaseOrderHeader.PurchaseOrderID int identity NOT NULL Primary Key |
Column | Purchasing.PurchaseOrderHeader.RevisionNumber tinyint NOT NULL default (0) | Purchasing.PurchaseOrderHeader.RevisionNumber tinyint NOT NULL default (0) |
Column | Purchasing.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)) |
Column | Purchasing.PurchaseOrderHeader.EmployeeID int NOT NULL | Purchasing.PurchaseOrderHeader.EmployeeID int NOT NULL |
Column | Purchasing.PurchaseOrderHeader.VendorID int NOT NULL | Purchasing.PurchaseOrderHeader.VendorID int NOT NULL |
Column | Purchasing.PurchaseOrderHeader.ShipMethodID int NOT NULL | Purchasing.PurchaseOrderHeader.ShipMethodID int NOT NULL |
Column | Purchasing.PurchaseOrderHeader.OrderDate datetime2 NOT NULL default getdate() | Purchasing.PurchaseOrderHeader.OrderDate datetime NOT NULL default getdate() |
Column | Purchasing.PurchaseOrderHeader.ShipDate datetime2 NULL | Purchasing.PurchaseOrderHeader.ShipDate datetime NULL |
Column | Purchasing.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)) |
Column | Purchasing.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)) |
Column | Purchasing.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)) |
Column | Purchasing.PurchaseOrderHeader.TotalDue decimal(21,4) NOT NULL | Purchasing.PurchaseOrderHeader.TotalDue money(19,4) NOT NULL |
Column | Purchasing.PurchaseOrderHeader.ModifiedDate datetime2 NOT NULL default getdate() | Purchasing.PurchaseOrderHeader.ModifiedDate datetime NOT NULL default getdate() |
Table | Purchasing.PurchaseOrderHeader | Purchasing.PurchaseOrderHeader |
Column | Sales.SalesOrderDetail.SalesOrderID int NOT NULL Primary Key | Sales.SalesOrderDetail.SalesOrderID int NOT NULL Primary Key |
Column | Sales.SalesOrderDetail.SalesOrderDetailID int identity NOT NULL Primary Key | Sales.SalesOrderDetail.SalesOrderDetailID int identity NOT NULL Primary Key |
Column | Sales.SalesOrderDetail.CarrierTrackingNumber nvarchar(25) NULL | Sales.SalesOrderDetail.CarrierTrackingNumber nvarchar(25) NULL |
Column | Sales.SalesOrderDetail.OrderQty smallint NOT NULL CHECK ([OrderQty]>(0)) | Sales.SalesOrderDetail.OrderQty smallint NOT NULL CHECK ([OrderQty]>(0)) |
Column | Sales.SalesOrderDetail.ProductID int NOT NULL | Sales.SalesOrderDetail.ProductID int NOT NULL |
Column | Sales.SalesOrderDetail.SpecialOfferID int NOT NULL | Sales.SalesOrderDetail.SpecialOfferID int NOT NULL |
Column | Sales.SalesOrderDetail.UnitPrice decimal(19,4) NOT NULL CHECK ([UnitPrice]>=(0.00)) | Sales.SalesOrderDetail.UnitPrice money(19,4) NOT NULL CHECK ([UnitPrice]>=(0.00)) |
Column | Sales.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)) |
Column | Sales.SalesOrderDetail.LineTotal numeric(38,6) NOT NULL | Sales.SalesOrderDetail.LineTotal numeric(38,6) NOT NULL |
Column | Sales.SalesOrderDetail.rowguid uniqueidentifier NOT NULL default newid() | Sales.SalesOrderDetail.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.SalesOrderDetail.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SalesOrderDetail.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SalesOrderDetail | Sales.SalesOrderDetail |
Column | Sales.SalesOrderHeader.SalesOrderID int identity NOT NULL Primary Key | Sales.SalesOrderHeader.SalesOrderID int identity NOT NULL Primary Key |
Column | Sales.SalesOrderHeader.RevisionNumber tinyint NOT NULL default (0) | Sales.SalesOrderHeader.RevisionNumber tinyint NOT NULL default (0) |
Column | Sales.SalesOrderHeader.OrderDate datetime2 NOT NULL default getdate() | Sales.SalesOrderHeader.OrderDate datetime NOT NULL default getdate() |
Column | Sales.SalesOrderHeader.DueDate datetime2 NOT NULL | Sales.SalesOrderHeader.DueDate datetime NOT NULL |
Column | Sales.SalesOrderHeader.ShipDate datetime2 NULL | Sales.SalesOrderHeader.ShipDate datetime NULL |
Column | Sales.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)) |
Column | Sales.SalesOrderHeader.OnlineOrderFlag bit NOT NULL default (1) | Sales.SalesOrderHeader.OnlineOrderFlag Flag NOT NULL default (1) |
Column | Sales.SalesOrderHeader.SalesOrderNumber nvarchar(25) NOT NULL | Sales.SalesOrderHeader.SalesOrderNumber nvarchar(25) NOT NULL |
Column | Sales.SalesOrderHeader.PurchaseOrderNumber nvarchar(25) NULL | Sales.SalesOrderHeader.PurchaseOrderNumber OrderNumber NULL |
Column | Sales.SalesOrderHeader.AccountNumber nvarchar(15) NULL | Sales.SalesOrderHeader.AccountNumber AccountNumber NULL |
Column | Sales.SalesOrderHeader.CustomerID int NOT NULL | Sales.SalesOrderHeader.CustomerID int NOT NULL |
Column | Sales.SalesOrderHeader.ContactID int NOT NULL | Sales.SalesOrderHeader.ContactID int NOT NULL |
Column | Sales.SalesOrderHeader.SalesPersonID int NULL | Sales.SalesOrderHeader.SalesPersonID int NULL |
Column | Sales.SalesOrderHeader.TerritoryID int NULL | Sales.SalesOrderHeader.TerritoryID int NULL |
Column | Sales.SalesOrderHeader.BillToAddressID int NOT NULL | Sales.SalesOrderHeader.BillToAddressID int NOT NULL |
Column | Sales.SalesOrderHeader.ShipToAddressID int NOT NULL | Sales.SalesOrderHeader.ShipToAddressID int NOT NULL |
Column | Sales.SalesOrderHeader.ShipMethodID int NOT NULL | Sales.SalesOrderHeader.ShipMethodID int NOT NULL |
Column | Sales.SalesOrderHeader.CreditCardID int NULL | Sales.SalesOrderHeader.CreditCardID int NULL |
Column | Sales.SalesOrderHeader.CreditCardApprovalCode varchar(15) NULL | Sales.SalesOrderHeader.CreditCardApprovalCode varchar(15) NULL |
Column | Sales.SalesOrderHeader.CurrencyRateID int NULL | Sales.SalesOrderHeader.CurrencyRateID int NULL |
Column | Sales.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)) |
Column | Sales.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)) |
Column | Sales.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)) |
Column | Sales.SalesOrderHeader.TotalDue decimal(21,4) NOT NULL | Sales.SalesOrderHeader.TotalDue money(19,4) NOT NULL |
Column | Sales.SalesOrderHeader.[Comment] nvarchar(128) NULL | Sales.SalesOrderHeader.[Comment] nvarchar(128) NULL |
Column | Sales.SalesOrderHeader.rowguid uniqueidentifier NOT NULL default newid() | Sales.SalesOrderHeader.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.SalesOrderHeader.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SalesOrderHeader.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SalesOrderHeader | Sales.SalesOrderHeader |
Column | Sales.SalesOrderHeaderSalesReason.SalesOrderID int NOT NULL Primary Key | Sales.SalesOrderHeaderSalesReason.SalesOrderID int NOT NULL Primary Key |
Column | Sales.SalesOrderHeaderSalesReason.SalesReasonID int NOT NULL Primary Key | Sales.SalesOrderHeaderSalesReason.SalesReasonID int NOT NULL Primary Key |
Column | Sales.SalesOrderHeaderSalesReason.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SalesOrderHeaderSalesReason.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SalesOrderHeaderSalesReason | Sales.SalesOrderHeaderSalesReason |
Column | Sales.SalesPerson.SalesPersonID int NOT NULL Primary Key | Sales.SalesPerson.SalesPersonID int NOT NULL Primary Key |
Column | Sales.SalesPerson.TerritoryID int NULL | Sales.SalesPerson.TerritoryID int NULL |
Column | Sales.SalesPerson.SalesQuota decimal(19,4) NULL CHECK ([SalesQuota]>(0.00)) | Sales.SalesPerson.SalesQuota money(19,4) NULL CHECK ([SalesQuota]>(0.00)) |
Column | Sales.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)) |
Column | Sales.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)) |
Column | Sales.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)) |
Column | Sales.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)) |
Column | Sales.SalesPerson.rowguid uniqueidentifier NOT NULL default newid() | Sales.SalesPerson.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.SalesPerson.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SalesPerson.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SalesPerson | Sales.SalesPerson |
Column | Sales.SalesPersonQuotaHistory.SalesPersonID int NOT NULL Primary Key | Sales.SalesPersonQuotaHistory.SalesPersonID int NOT NULL Primary Key |
Column | Sales.SalesPersonQuotaHistory.QuotaDate datetime2 NOT NULL Primary Key | Sales.SalesPersonQuotaHistory.QuotaDate datetime NOT NULL Primary Key |
Column | Sales.SalesPersonQuotaHistory.SalesQuota decimal(19,4) NOT NULL CHECK ([SalesQuota]>(0.00)) | Sales.SalesPersonQuotaHistory.SalesQuota money(19,4) NOT NULL CHECK ([SalesQuota]>(0.00)) |
Column | Sales.SalesPersonQuotaHistory.rowguid uniqueidentifier NOT NULL default newid() | Sales.SalesPersonQuotaHistory.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.SalesPersonQuotaHistory.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SalesPersonQuotaHistory.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SalesPersonQuotaHistory | Sales.SalesPersonQuotaHistory |
Column | Sales.SalesReason.SalesReasonID int identity NOT NULL Primary Key | Sales.SalesReason.SalesReasonID int identity NOT NULL Primary Key |
Column | Sales.SalesReason.Name nvarchar(50) NOT NULL | Sales.SalesReason.Name Name NOT NULL |
Column | Sales.SalesReason.ReasonType nvarchar(50) NOT NULL | Sales.SalesReason.ReasonType Name NOT NULL |
Column | Sales.SalesReason.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SalesReason.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SalesReason | Sales.SalesReason |
Column | Sales.SalesTaxRate.SalesTaxRateID int identity NOT NULL Primary Key | Sales.SalesTaxRate.SalesTaxRateID int identity NOT NULL Primary Key |
Column | Sales.SalesTaxRate.StateProvinceID int NOT NULL | Sales.SalesTaxRate.StateProvinceID int NOT NULL |
Column | Sales.SalesTaxRate.TaxType tinyint NOT NULL CHECK ([TaxType]>=(1) AND [TaxType]<=(3)) | Sales.SalesTaxRate.TaxType tinyint NOT NULL CHECK ([TaxType]>=(1) AND [TaxType]<=(3)) |
Column | Sales.SalesTaxRate.TaxRate decimal(10,4) NOT NULL default (0.00) | Sales.SalesTaxRate.TaxRate smallmoney(10,4) NOT NULL default (0.00) |
Column | Sales.SalesTaxRate.Name nvarchar(50) NOT NULL | Sales.SalesTaxRate.Name Name NOT NULL |
Column | Sales.SalesTaxRate.rowguid uniqueidentifier NOT NULL default newid() | Sales.SalesTaxRate.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.SalesTaxRate.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SalesTaxRate.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SalesTaxRate | Sales.SalesTaxRate |
Column | Sales.SalesTerritory.TerritoryID int identity NOT NULL Primary Key | Sales.SalesTerritory.TerritoryID int identity NOT NULL Primary Key |
Column | Sales.SalesTerritory.Name nvarchar(50) NOT NULL | Sales.SalesTerritory.Name Name NOT NULL |
Column | Sales.SalesTerritory.CountryRegionCode nvarchar(3) NOT NULL | Sales.SalesTerritory.CountryRegionCode nvarchar(3) NOT NULL |
Column | Sales.SalesTerritory.[Group] nvarchar(50) NOT NULL | Sales.SalesTerritory.[Group] nvarchar(50) NOT NULL |
Column | Sales.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)) |
Column | Sales.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)) |
Column | Sales.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)) |
Column | Sales.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)) |
Column | Sales.SalesTerritory.rowguid uniqueidentifier NOT NULL default newid() | Sales.SalesTerritory.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.SalesTerritory.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SalesTerritory.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SalesTerritory | Sales.SalesTerritory |
Column | Sales.SalesTerritoryHistory.SalesPersonID int NOT NULL Primary Key | Sales.SalesTerritoryHistory.SalesPersonID int NOT NULL Primary Key |
Column | Sales.SalesTerritoryHistory.TerritoryID int NOT NULL Primary Key | Sales.SalesTerritoryHistory.TerritoryID int NOT NULL Primary Key |
Column | Sales.SalesTerritoryHistory.StartDate datetime2 NOT NULL Primary Key | Sales.SalesTerritoryHistory.StartDate datetime NOT NULL Primary Key |
Column | Sales.SalesTerritoryHistory.EndDate datetime2 NULL | Sales.SalesTerritoryHistory.EndDate datetime NULL |
Column | Sales.SalesTerritoryHistory.rowguid uniqueidentifier NOT NULL default newid() | Sales.SalesTerritoryHistory.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.SalesTerritoryHistory.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SalesTerritoryHistory.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SalesTerritoryHistory | Sales.SalesTerritoryHistory |
Column | Production.ScrapReason.ScrapReasonID smallint identity NOT NULL Primary Key | Production.ScrapReason.ScrapReasonID smallint identity NOT NULL Primary Key |
Column | Production.ScrapReason.Name nvarchar(50) NOT NULL | Production.ScrapReason.Name Name NOT NULL |
Column | Production.ScrapReason.ModifiedDate datetime2 NOT NULL default getdate() | Production.ScrapReason.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.ScrapReason | Production.ScrapReason |
Column | HumanResources.Shift.ShiftID tinyint identity NOT NULL Primary Key | HumanResources.Shift.ShiftID tinyint identity NOT NULL Primary Key |
Column | HumanResources.Shift.Name nvarchar(50) NOT NULL | HumanResources.Shift.Name Name NOT NULL |
Column | HumanResources.Shift.StartTime datetime2 NOT NULL | HumanResources.Shift.StartTime datetime NOT NULL |
Column | HumanResources.Shift.EndTime datetime2 NOT NULL | HumanResources.Shift.EndTime datetime NOT NULL |
Column | HumanResources.Shift.ModifiedDate datetime2 NOT NULL default getdate() | HumanResources.Shift.ModifiedDate datetime NOT NULL default getdate() |
Table | HumanResources.Shift | HumanResources.Shift |
Column | Purchasing.ShipMethod.ShipMethodID int identity NOT NULL Primary Key | Purchasing.ShipMethod.ShipMethodID int identity NOT NULL Primary Key |
Column | Purchasing.ShipMethod.Name nvarchar(50) NOT NULL | Purchasing.ShipMethod.Name Name NOT NULL |
Column | Purchasing.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)) |
Column | Purchasing.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)) |
Column | Purchasing.ShipMethod.rowguid uniqueidentifier NOT NULL default newid() | Purchasing.ShipMethod.rowguid uniqueidentifier NOT NULL default newid() |
Column | Purchasing.ShipMethod.ModifiedDate datetime2 NOT NULL default getdate() | Purchasing.ShipMethod.ModifiedDate datetime NOT NULL default getdate() |
Table | Purchasing.ShipMethod | Purchasing.ShipMethod |
Column | Sales.ShoppingCartItem.ShoppingCartItemID int identity NOT NULL Primary Key | Sales.ShoppingCartItem.ShoppingCartItemID int identity NOT NULL Primary Key |
Column | Sales.ShoppingCartItem.ShoppingCartID nvarchar(50) NOT NULL | Sales.ShoppingCartItem.ShoppingCartID nvarchar(50) NOT NULL |
Column | Sales.ShoppingCartItem.Quantity int NOT NULL default (1) CHECK ([Quantity]>=(1)) | Sales.ShoppingCartItem.Quantity int NOT NULL default (1) CHECK ([Quantity]>=(1)) |
Column | Sales.ShoppingCartItem.ProductID int NOT NULL | Sales.ShoppingCartItem.ProductID int NOT NULL |
Column | Sales.ShoppingCartItem.DateCreated datetime2 NOT NULL default getdate() | Sales.ShoppingCartItem.DateCreated datetime NOT NULL default getdate() |
Column | Sales.ShoppingCartItem.ModifiedDate datetime2 NOT NULL default getdate() | Sales.ShoppingCartItem.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.ShoppingCartItem | Sales.ShoppingCartItem |
Column | Sales.SpecialOffer.SpecialOfferID int identity NOT NULL Primary Key | Sales.SpecialOffer.SpecialOfferID int identity NOT NULL Primary Key |
Column | Sales.SpecialOffer.Description nvarchar(255) NOT NULL | Sales.SpecialOffer.Description nvarchar(255) NOT NULL |
Column | Sales.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)) |
Column | Sales.SpecialOffer.Type nvarchar(50) NOT NULL | Sales.SpecialOffer.Type nvarchar(50) NOT NULL |
Column | Sales.SpecialOffer.Category nvarchar(50) NOT NULL | Sales.SpecialOffer.Category nvarchar(50) NOT NULL |
Column | Sales.SpecialOffer.StartDate datetime2 NOT NULL | Sales.SpecialOffer.StartDate datetime NOT NULL |
Column | Sales.SpecialOffer.EndDate datetime2 NOT NULL | Sales.SpecialOffer.EndDate datetime NOT NULL |
Column | Sales.SpecialOffer.MinQty int NOT NULL default (0) CHECK ([MinQty]>=(0)) | Sales.SpecialOffer.MinQty int NOT NULL default (0) CHECK ([MinQty]>=(0)) |
Column | Sales.SpecialOffer.MaxQty int NULL CHECK ([MaxQty]>=(0)) | Sales.SpecialOffer.MaxQty int NULL CHECK ([MaxQty]>=(0)) |
Column | Sales.SpecialOffer.rowguid uniqueidentifier NOT NULL default newid() | Sales.SpecialOffer.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.SpecialOffer.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SpecialOffer.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SpecialOffer | Sales.SpecialOffer |
Column | Sales.SpecialOfferProduct.SpecialOfferID int NOT NULL Primary Key | Sales.SpecialOfferProduct.SpecialOfferID int NOT NULL Primary Key |
Column | Sales.SpecialOfferProduct.ProductID int NOT NULL Primary Key | Sales.SpecialOfferProduct.ProductID int NOT NULL Primary Key |
Column | Sales.SpecialOfferProduct.rowguid uniqueidentifier NOT NULL default newid() | Sales.SpecialOfferProduct.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.SpecialOfferProduct.ModifiedDate datetime2 NOT NULL default getdate() | Sales.SpecialOfferProduct.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.SpecialOfferProduct | Sales.SpecialOfferProduct |
Column | Person.StateProvince.StateProvinceID int identity NOT NULL Primary Key | Person.StateProvince.StateProvinceID int identity NOT NULL Primary Key |
Column | Person.StateProvince.StateProvinceCode nchar(3) NOT NULL | Person.StateProvince.StateProvinceCode nchar(3) NOT NULL |
Column | Person.StateProvince.CountryRegionCode nvarchar(3) NOT NULL | Person.StateProvince.CountryRegionCode nvarchar(3) NOT NULL |
Column | Person.StateProvince.IsOnlyStateProvinceFlag bit NOT NULL default (1) | Person.StateProvince.IsOnlyStateProvinceFlag Flag NOT NULL default (1) |
Column | Person.StateProvince.Name nvarchar(50) NOT NULL | Person.StateProvince.Name Name NOT NULL |
Column | Person.StateProvince.TerritoryID int NOT NULL | Person.StateProvince.TerritoryID int NOT NULL |
Column | Person.StateProvince.rowguid uniqueidentifier NOT NULL default newid() | Person.StateProvince.rowguid uniqueidentifier NOT NULL default newid() |
Column | Person.StateProvince.ModifiedDate datetime2 NOT NULL default getdate() | Person.StateProvince.ModifiedDate datetime NOT NULL default getdate() |
Table | Person.StateProvince | Person.StateProvince |
Column | Sales.Store.CustomerID int NOT NULL Primary Key | Sales.Store.CustomerID int NOT NULL Primary Key |
Column | Sales.Store.Name nvarchar(50) NOT NULL | Sales.Store.Name Name NOT NULL |
Column | Sales.Store.SalesPersonID int NULL | Sales.Store.SalesPersonID int NULL |
Column | Sales.Store.Demographics xml NULL | Sales.Store.Demographics xml NULL |
Column | Sales.Store.rowguid uniqueidentifier NOT NULL default newid() | Sales.Store.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.Store.ModifiedDate datetime2 NOT NULL default getdate() | Sales.Store.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.Store | Sales.Store |
Column | Sales.StoreContact.CustomerID int NOT NULL Primary Key | Sales.StoreContact.CustomerID int NOT NULL Primary Key |
Column | Sales.StoreContact.ContactID int NOT NULL Primary Key | Sales.StoreContact.ContactID int NOT NULL Primary Key |
Column | Sales.StoreContact.ContactTypeID int NOT NULL | Sales.StoreContact.ContactTypeID int NOT NULL |
Column | Sales.StoreContact.rowguid uniqueidentifier NOT NULL default newid() | Sales.StoreContact.rowguid uniqueidentifier NOT NULL default newid() |
Column | Sales.StoreContact.ModifiedDate datetime2 NOT NULL default getdate() | Sales.StoreContact.ModifiedDate datetime NOT NULL default getdate() |
Table | Sales.StoreContact | Sales.StoreContact |
Column | Production.TransactionHistory.TransactionID int identity NOT NULL Primary Key | Production.TransactionHistory.TransactionID int identity NOT NULL Primary Key |
Column | Production.TransactionHistory.ProductID int NOT NULL | Production.TransactionHistory.ProductID int NOT NULL |
Column | Production.TransactionHistory.ReferenceOrderID int NOT NULL | Production.TransactionHistory.ReferenceOrderID int NOT NULL |
Column | Production.TransactionHistory.ReferenceOrderLineID int NOT NULL default (0) | Production.TransactionHistory.ReferenceOrderLineID int NOT NULL default (0) |
Column | Production.TransactionHistory.TransactionDate datetime2 NOT NULL default getdate() | Production.TransactionHistory.TransactionDate datetime NOT NULL default getdate() |
Column | Production.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') |
Column | Production.TransactionHistory.Quantity int NOT NULL | Production.TransactionHistory.Quantity int NOT NULL |
Column | Production.TransactionHistory.ActualCost decimal(19,4) NOT NULL | Production.TransactionHistory.ActualCost money(19,4) NOT NULL |
Column | Production.TransactionHistory.ModifiedDate datetime2 NOT NULL default getdate() | Production.TransactionHistory.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.TransactionHistory | Production.TransactionHistory |
Column | Production.TransactionHistoryArchive.TransactionID int NOT NULL Primary Key | Production.TransactionHistoryArchive.TransactionID int NOT NULL Primary Key |
Column | Production.TransactionHistoryArchive.ProductID int NOT NULL | Production.TransactionHistoryArchive.ProductID int NOT NULL |
Column | Production.TransactionHistoryArchive.ReferenceOrderID int NOT NULL | Production.TransactionHistoryArchive.ReferenceOrderID int NOT NULL |
Column | Production.TransactionHistoryArchive.ReferenceOrderLineID int NOT NULL default (0) | Production.TransactionHistoryArchive.ReferenceOrderLineID int NOT NULL default (0) |
Column | Production.TransactionHistoryArchive.TransactionDate datetime2 NOT NULL default getdate() | Production.TransactionHistoryArchive.TransactionDate datetime NOT NULL default getdate() |
Column | Production.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') |
Column | Production.TransactionHistoryArchive.Quantity int NOT NULL | Production.TransactionHistoryArchive.Quantity int NOT NULL |
Column | Production.TransactionHistoryArchive.ActualCost decimal(19,4) NOT NULL | Production.TransactionHistoryArchive.ActualCost money(19,4) NOT NULL |
Column | Production.TransactionHistoryArchive.ModifiedDate datetime2 NOT NULL default getdate() | Production.TransactionHistoryArchive.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.TransactionHistoryArchive | Production.TransactionHistoryArchive |
Column | Production.UnitMeasure.UnitMeasureCode nchar(3) NOT NULL Primary Key | Production.UnitMeasure.UnitMeasureCode nchar(3) NOT NULL Primary Key |
Column | Production.UnitMeasure.Name nvarchar(50) NOT NULL | Production.UnitMeasure.Name Name NOT NULL |
Column | Production.UnitMeasure.ModifiedDate datetime2 NOT NULL default getdate() | Production.UnitMeasure.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.UnitMeasure | Production.UnitMeasure |
Column | Purchasing.Vendor.VendorID int identity NOT NULL Primary Key | Purchasing.Vendor.VendorID int identity NOT NULL Primary Key |
Column | Purchasing.Vendor.AccountNumber nvarchar(15) NOT NULL | Purchasing.Vendor.AccountNumber AccountNumber NOT NULL |
Column | Purchasing.Vendor.Name nvarchar(50) NOT NULL | Purchasing.Vendor.Name Name NOT NULL |
Column | Purchasing.Vendor.CreditRating tinyint NOT NULL CHECK ([CreditRating]>=(1) AND [CreditRating]<=(5)) | Purchasing.Vendor.CreditRating tinyint NOT NULL CHECK ([CreditRating]>=(1) AND [CreditRating]<=(5)) |
Column | Purchasing.Vendor.PreferredVendorStatus bit NOT NULL default (1) | Purchasing.Vendor.PreferredVendorStatus Flag NOT NULL default (1) |
Column | Purchasing.Vendor.ActiveFlag bit NOT NULL default (1) | Purchasing.Vendor.ActiveFlag Flag NOT NULL default (1) |
Column | Purchasing.Vendor.PurchasingWebServiceURL nvarchar(1024) NULL | Purchasing.Vendor.PurchasingWebServiceURL nvarchar(1024) NULL |
Column | Purchasing.Vendor.ModifiedDate datetime2 NOT NULL default getdate() | Purchasing.Vendor.ModifiedDate datetime NOT NULL default getdate() |
Table | Purchasing.Vendor | Purchasing.Vendor |
Column | Purchasing.VendorAddress.VendorID int NOT NULL Primary Key | Purchasing.VendorAddress.VendorID int NOT NULL Primary Key |
Column | Purchasing.VendorAddress.AddressID int NOT NULL Primary Key | Purchasing.VendorAddress.AddressID int NOT NULL Primary Key |
Column | Purchasing.VendorAddress.AddressTypeID int NOT NULL | Purchasing.VendorAddress.AddressTypeID int NOT NULL |
Column | Purchasing.VendorAddress.ModifiedDate datetime2 NOT NULL default getdate() | Purchasing.VendorAddress.ModifiedDate datetime NOT NULL default getdate() |
Table | Purchasing.VendorAddress | Purchasing.VendorAddress |
Column | Purchasing.VendorContact.VendorID int NOT NULL Primary Key | Purchasing.VendorContact.VendorID int NOT NULL Primary Key |
Column | Purchasing.VendorContact.ContactID int NOT NULL Primary Key | Purchasing.VendorContact.ContactID int NOT NULL Primary Key |
Column | Purchasing.VendorContact.ContactTypeID int NOT NULL | Purchasing.VendorContact.ContactTypeID int NOT NULL |
Column | Purchasing.VendorContact.ModifiedDate datetime2 NOT NULL default getdate() | Purchasing.VendorContact.ModifiedDate datetime NOT NULL default getdate() |
Table | Purchasing.VendorContact | Purchasing.VendorContact |
Column | Production.WorkOrder.WorkOrderID int identity NOT NULL Primary Key | Production.WorkOrder.WorkOrderID int identity NOT NULL Primary Key |
Column | Production.WorkOrder.ProductID int NOT NULL | Production.WorkOrder.ProductID int NOT NULL |
Column | Production.WorkOrder.OrderQty int NOT NULL CHECK ([OrderQty]>(0)) | Production.WorkOrder.OrderQty int NOT NULL CHECK ([OrderQty]>(0)) |
Column | Production.WorkOrder.StockedQty int NOT NULL | Production.WorkOrder.StockedQty int NOT NULL |
Column | Production.WorkOrder.ScrappedQty smallint NOT NULL CHECK ([ScrappedQty]>=(0)) | Production.WorkOrder.ScrappedQty smallint NOT NULL CHECK ([ScrappedQty]>=(0)) |
Column | Production.WorkOrder.StartDate datetime2 NOT NULL | Production.WorkOrder.StartDate datetime NOT NULL |
Column | Production.WorkOrder.EndDate datetime2 NULL | Production.WorkOrder.EndDate datetime NULL |
Column | Production.WorkOrder.DueDate datetime2 NOT NULL | Production.WorkOrder.DueDate datetime NOT NULL |
Column | Production.WorkOrder.ScrapReasonID smallint NULL | Production.WorkOrder.ScrapReasonID smallint NULL |
Column | Production.WorkOrder.ModifiedDate datetime2 NOT NULL default getdate() | Production.WorkOrder.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.WorkOrder | Production.WorkOrder |
Column | Production.WorkOrderRouting.WorkOrderID int NOT NULL Primary Key | Production.WorkOrderRouting.WorkOrderID int NOT NULL Primary Key |
Column | Production.WorkOrderRouting.ProductID int NOT NULL Primary Key | Production.WorkOrderRouting.ProductID int NOT NULL Primary Key |
Column | Production.WorkOrderRouting.OperationSequence smallint NOT NULL Primary Key | Production.WorkOrderRouting.OperationSequence smallint NOT NULL Primary Key |
Column | Production.WorkOrderRouting.LocationID smallint NOT NULL | Production.WorkOrderRouting.LocationID smallint NOT NULL |
Column | Production.WorkOrderRouting.ScheduledStartDate datetime2 NOT NULL | Production.WorkOrderRouting.ScheduledStartDate datetime NOT NULL |
Column | Production.WorkOrderRouting.ScheduledEndDate datetime2 NOT NULL | Production.WorkOrderRouting.ScheduledEndDate datetime NOT NULL |
Column | Production.WorkOrderRouting.ActualStartDate datetime2 NULL | Production.WorkOrderRouting.ActualStartDate datetime NULL |
Column | Production.WorkOrderRouting.ActualEndDate datetime2 NULL | Production.WorkOrderRouting.ActualEndDate datetime NULL |
Column | Production.WorkOrderRouting.ActualResourceHrs decimal(9,4) NULL CHECK ([ActualResourceHrs]>=(0.0000)) | Production.WorkOrderRouting.ActualResourceHrs decimal(9,4) NULL CHECK ([ActualResourceHrs]>=(0.0000)) |
Column | Production.WorkOrderRouting.PlannedCost decimal(19,4) NOT NULL CHECK ([PlannedCost]>(0.00)) | Production.WorkOrderRouting.PlannedCost money(19,4) NOT NULL CHECK ([PlannedCost]>(0.00)) |
Column | Production.WorkOrderRouting.ActualCost decimal(19,4) NULL CHECK ([ActualCost]>(0.00)) | Production.WorkOrderRouting.ActualCost money(19,4) NULL CHECK ([ActualCost]>(0.00)) |
Column | Production.WorkOrderRouting.ModifiedDate datetime2 NOT NULL default getdate() | Production.WorkOrderRouting.ModifiedDate datetime NOT NULL default getdate() |
Table | Production.WorkOrderRouting | Production.WorkOrderRouting |
View | | Person.vAdditionalContactInfo |
View | HumanResources.vEmployee | HumanResources.vEmployee |
View | HumanResources.vEmployeeDepartment | HumanResources.vEmployeeDepartment |
View | HumanResources.vEmployeeDepartmentHistory | HumanResources.vEmployeeDepartmentHistory |
View | Sales.vIndividualCustomer | Sales.vIndividualCustomer |
View | Sales.vIndividualDemographics | Sales.vIndividualDemographics |
View | HumanResources.vJobCandidate | HumanResources.vJobCandidate |
View | HumanResources.vJobCandidateEducation | HumanResources.vJobCandidateEducation |
View | HumanResources.vJobCandidateEmployment | HumanResources.vJobCandidateEmployment |
View | Production.vProductAndDescription | Production.vProductAndDescription |
View | Production.vProductModelCatalogDescription | Production.vProductModelCatalogDescription |
View | Production.vProductModelInstructions | Production.vProductModelInstructions |
View | Sales.vSalesPerson | Sales.vSalesPerson |
View | Sales.vSalesPersonSalesByFiscalYears | Sales.vSalesPersonSalesByFiscalYears |
View | Person.vStateProvinceCountryRegion | Person.vStateProvinceCountryRegion |
View | Sales.vStoreWithDemographics | Sales.vStoreWithDemographics |
View | Purchasing.vVendor | Purchasing.vVendor |
Procedure | dbo.ufnGetAccountingEndDate | dbo.ufnGetAccountingEndDate |
Procedure | dbo.ufnGetAccountingStartDate | dbo.ufnGetAccountingStartDate |
Procedure | dbo.ufnGetContactInformation | dbo.ufnGetContactInformation |
Procedure | dbo.ufnGetDocumentStatusText | dbo.ufnGetDocumentStatusText |
Procedure | dbo.ufnGetProductDealerPrice | dbo.ufnGetProductDealerPrice |
Procedure | dbo.ufnGetProductListPrice | dbo.ufnGetProductListPrice |
Procedure | dbo.ufnGetProductStandardCost | dbo.ufnGetProductStandardCost |
Procedure | dbo.ufnGetPurchaseOrderStatusText | dbo.ufnGetPurchaseOrderStatusText |
Procedure | dbo.ufnGetSalesOrderStatusText | dbo.ufnGetSalesOrderStatusText |
Procedure | dbo.ufnGetStock | dbo.ufnGetStock |
Procedure | dbo.ufnLeadingZeros | dbo.ufnLeadingZeros |
Procedure | dbo.uspGetBillOfMaterials | dbo.uspGetBillOfMaterials |
Procedure | dbo.uspGetEmployeeManagers | dbo.uspGetEmployeeManagers |
Procedure | dbo.uspGetManagerEmployees | dbo.uspGetManagerEmployees |
Procedure | dbo.uspGetWhereUsedProductID | dbo.uspGetWhereUsedProductID |
Procedure | dbo.uspLogError | dbo.uspLogError |
Procedure | dbo.uspPrintError | dbo.uspPrintError |
Procedure | HumanResources.uspUpdateEmployeeHireInfo | HumanResources.uspUpdateEmployeeHireInfo |
Procedure | HumanResources.uspUpdateEmployeeLogin | HumanResources.uspUpdateEmployeeLogin |
Procedure | HumanResources.uspUpdateEmployeePersonalInfo | HumanResources.uspUpdateEmployeePersonalInfo |
Index | AK_Address_rowguid | AK_Address_rowguid |
Index | AK_AddressType_Name | AK_AddressType_Name |
Index | AK_AddressType_rowguid | AK_AddressType_rowguid |
Index | AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate | AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate |
Index | | AK_Contact_rowguid |
Index | AK_ContactType_Name | AK_ContactType_Name |
Index | AK_CountryRegion_Name | AK_CountryRegion_Name |
Index | AK_CreditCard_CardNumber | AK_CreditCard_CardNumber |
Index | AK_Culture_Name | AK_Culture_Name |
Index | AK_Currency_Name | AK_Currency_Name |
Index | AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode | AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode |
Index | AK_Customer_AccountNumber | AK_Customer_AccountNumber |
Index | AK_Customer_rowguid | AK_Customer_rowguid |
Index | AK_CustomerAddress_rowguid | AK_CustomerAddress_rowguid |
Index | AK_Department_Name | AK_Department_Name |
Index | | AK_Document_FileName_Revision |
Index | AK_Employee_LoginID | AK_Employee_LoginID |
Index | AK_Employee_NationalIDNumber | AK_Employee_NationalIDNumber |
Index | AK_Employee_rowguid | AK_Employee_rowguid |
Index | AK_EmployeeAddress_rowguid | AK_EmployeeAddress_rowguid |
Index | AK_Location_Name | AK_Location_Name |
Index | AK_Product_Name | AK_Product_Name |
Index | AK_Product_ProductNumber | AK_Product_ProductNumber |
Index | AK_Product_rowguid | AK_Product_rowguid |
Index | AK_ProductCategory_Name | AK_ProductCategory_Name |
Index | AK_ProductCategory_rowguid | AK_ProductCategory_rowguid |
Index | AK_ProductDescription_rowguid | AK_ProductDescription_rowguid |
Index | AK_ProductModel_Name | AK_ProductModel_Name |
Index | AK_ProductModel_rowguid | AK_ProductModel_rowguid |
Index | AK_ProductSubcategory_Name | AK_ProductSubcategory_Name |
Index | AK_ProductSubcategory_rowguid | AK_ProductSubcategory_rowguid |
Index | AK_SalesOrderDetail_rowguid | AK_SalesOrderDetail_rowguid |
Index | AK_SalesOrderHeader_rowguid | AK_SalesOrderHeader_rowguid |
Index | AK_SalesOrderHeader_SalesOrderNumber | AK_SalesOrderHeader_SalesOrderNumber |
Index | AK_SalesPerson_rowguid | AK_SalesPerson_rowguid |
Index | AK_SalesPersonQuotaHistory_rowguid | AK_SalesPersonQuotaHistory_rowguid |
Index | AK_SalesTaxRate_rowguid | AK_SalesTaxRate_rowguid |
Index | AK_SalesTaxRate_StateProvinceID_TaxType | AK_SalesTaxRate_StateProvinceID_TaxType |
Index | AK_SalesTerritory_Name | AK_SalesTerritory_Name |
Index | AK_SalesTerritory_rowguid | AK_SalesTerritory_rowguid |
Index | AK_SalesTerritoryHistory_rowguid | AK_SalesTerritoryHistory_rowguid |
Index | AK_ScrapReason_Name | AK_ScrapReason_Name |
Index | AK_Shift_Name | AK_Shift_Name |
Index | AK_Shift_StartTime_EndTime | AK_Shift_StartTime_EndTime |
Index | AK_ShipMethod_Name | AK_ShipMethod_Name |
Index | AK_ShipMethod_rowguid | AK_ShipMethod_rowguid |
Index | AK_SpecialOffer_rowguid | AK_SpecialOffer_rowguid |
Index | AK_SpecialOfferProduct_rowguid | AK_SpecialOfferProduct_rowguid |
Index | AK_StateProvince_Name | AK_StateProvince_Name |
Index | AK_StateProvince_rowguid | AK_StateProvince_rowguid |
Index | AK_StateProvince_StateProvinceCode_CountryRegionCode | AK_StateProvince_StateProvinceCode_CountryRegionCode |
Index | AK_Store_rowguid | AK_Store_rowguid |
Index | AK_StoreContact_rowguid | AK_StoreContact_rowguid |
Index | AK_UnitMeasure_Name | AK_UnitMeasure_Name |
Index | AK_Vendor_AccountNumber | AK_Vendor_AccountNumber |
Index | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
Index | IX_Address_StateProvinceID | IX_Address_StateProvinceID |
Index | IX_BillOfMaterials_UnitMeasureCode | IX_BillOfMaterials_UnitMeasureCode |
Index | | IX_Contact_EmailAddress |
Index | IX_CountryRegionCurrency_CurrencyCode | IX_CountryRegionCurrency_CurrencyCode |
Index | IX_Customer_TerritoryID | IX_Customer_TerritoryID |
Index | IX_Employee_ManagerID | IX_Employee_ManagerID |
Index | IX_EmployeeDepartmentHistory_DepartmentID | IX_EmployeeDepartmentHistory_DepartmentID |
Index | IX_EmployeeDepartmentHistory_ShiftID | IX_EmployeeDepartmentHistory_ShiftID |
Index | IX_JobCandidate_EmployeeID | IX_JobCandidate_EmployeeID |
Index | IX_ProductReview_ProductID_Name | IX_ProductReview_ProductID_Name |
Index | IX_ProductVendor_UnitMeasureCode | IX_ProductVendor_UnitMeasureCode |
Index | IX_ProductVendor_VendorID | IX_ProductVendor_VendorID |
Index | IX_PurchaseOrderDetail_ProductID | IX_PurchaseOrderDetail_ProductID |
Index | IX_PurchaseOrderHeader_EmployeeID | IX_PurchaseOrderHeader_EmployeeID |
Index | IX_PurchaseOrderHeader_VendorID | IX_PurchaseOrderHeader_VendorID |
Index | IX_SalesOrderDetail_ProductID | IX_SalesOrderDetail_ProductID |
Index | IX_SalesOrderHeader_CustomerID | IX_SalesOrderHeader_CustomerID |
Index | IX_SalesOrderHeader_SalesPersonID | IX_SalesOrderHeader_SalesPersonID |
Index | IX_ShoppingCartItem_ShoppingCartID_ProductID | IX_ShoppingCartItem_ShoppingCartID_ProductID |
Index | IX_SpecialOfferProduct_ProductID | IX_SpecialOfferProduct_ProductID |
Index | IX_Store_SalesPersonID | IX_Store_SalesPersonID |
Index | IX_StoreContact_ContactID | IX_StoreContact_ContactID |
Index | IX_StoreContact_ContactTypeID | IX_StoreContact_ContactTypeID |
Index | IX_TransactionHistory_ProductID | IX_TransactionHistory_ProductID |
Index | IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID | IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID |
Index | IX_TransactionHistoryArchive_ProductID | IX_TransactionHistoryArchive_ProductID |
Index | IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID | IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID |
Index | IX_VendorAddress_AddressID | IX_VendorAddress_AddressID |
Index | IX_VendorContact_ContactID | IX_VendorContact_ContactID |
Index | IX_VendorContact_ContactTypeID | IX_VendorContact_ContactTypeID |
Index | IX_WorkOrder_ProductID | IX_WorkOrder_ProductID |
Index | IX_WorkOrder_ScrapReasonID | IX_WorkOrder_ScrapReasonID |
Index | IX_WorkOrderRouting_ProductID | IX_WorkOrderRouting_ProductID |
Index | PK_Address_AddressID | PK_Address_AddressID |
Index | PK_AddressType_AddressTypeID | PK_AddressType_AddressTypeID |
Index | PK_AWBuildVersion_SystemInformationID | PK_AWBuildVersion_SystemInformationID |
Index | PK_BillOfMaterials_BillOfMaterialsID | PK_BillOfMaterials_BillOfMaterialsID |
Index | PK_Contact_ContactID | PK_Contact_ContactID |
Index | PK_ContactCreditCard_ContactID_CreditCardID | PK_ContactCreditCard_ContactID_CreditCardID |
Index | PK_ContactType_ContactTypeID | PK_ContactType_ContactTypeID |
Index | PK_CountryRegion_CountryRegionCode | PK_CountryRegion_CountryRegionCode |
Index | PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode | PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode |
Index | PK_CreditCard_CreditCardID | PK_CreditCard_CreditCardID |
Index | PK_Culture_CultureID | PK_Culture_CultureID |
Index | PK_Currency_CurrencyCode | PK_Currency_CurrencyCode |
Index | PK_CurrencyRate_CurrencyRateID | PK_CurrencyRate_CurrencyRateID |
Index | PK_Customer_CustomerID | PK_Customer_CustomerID |
Index | PK_CustomerAddress_CustomerID_AddressID | PK_CustomerAddress_CustomerID_AddressID |
Index | PK_DatabaseLog_DatabaseLogID | PK_DatabaseLog_DatabaseLogID |
Index | PK_Department_DepartmentID | PK_Department_DepartmentID |
Index | PK_Document_DocumentID | PK_Document_DocumentID |
Index | PK_Employee_EmployeeID | PK_Employee_EmployeeID |
Index | PK_EmployeeAddress_EmployeeID_AddressID | PK_EmployeeAddress_EmployeeID_AddressID |
Index | PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID | PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID |
Index | PK_EmployeePayHistory_EmployeeID_RateChangeDate | PK_EmployeePayHistory_EmployeeID_RateChangeDate |
Index | PK_ErrorLog_ErrorLogID | PK_ErrorLog_ErrorLogID |
Index | PK_Illustration_IllustrationID | PK_Illustration_IllustrationID |
Index | PK_Individual_CustomerID | PK_Individual_CustomerID |
Index | PK_JobCandidate_JobCandidateID | PK_JobCandidate_JobCandidateID |
Index | PK_Location_LocationID | PK_Location_LocationID |
Index | PK_Product_ProductID | PK_Product_ProductID |
Index | PK_ProductCategory_ProductCategoryID | PK_ProductCategory_ProductCategoryID |
Index | PK_ProductCostHistory_ProductID_StartDate | PK_ProductCostHistory_ProductID_StartDate |
Index | PK_ProductDescription_ProductDescriptionID | PK_ProductDescription_ProductDescriptionID |
Index | PK_ProductDocument_ProductID_DocumentID | PK_ProductDocument_ProductID_DocumentID |
Index | PK_ProductInventory_ProductID_LocationID | PK_ProductInventory_ProductID_LocationID |
Index | PK_ProductListPriceHistory_ProductID_StartDate | PK_ProductListPriceHistory_ProductID_StartDate |
Index | PK_ProductModel_ProductModelID | PK_ProductModel_ProductModelID |
Index | PK_ProductModelIllustration_ProductModelID_IllustrationID | PK_ProductModelIllustration_ProductModelID_IllustrationID |
Index | PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID | PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID |
Index | PK_ProductPhoto_ProductPhotoID | PK_ProductPhoto_ProductPhotoID |
Index | PK_ProductProductPhoto_ProductID_ProductPhotoID | PK_ProductProductPhoto_ProductID_ProductPhotoID |
Index | PK_ProductReview_ProductReviewID | PK_ProductReview_ProductReviewID |
Index | PK_ProductSubcategory_ProductSubcategoryID | PK_ProductSubcategory_ProductSubcategoryID |
Index | PK_ProductVendor_ProductID_VendorID | PK_ProductVendor_ProductID_VendorID |
Index | PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID |
Index | PK_PurchaseOrderHeader_PurchaseOrderID | PK_PurchaseOrderHeader_PurchaseOrderID |
Index | PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID | PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID |
Index | PK_SalesOrderHeader_SalesOrderID | PK_SalesOrderHeader_SalesOrderID |
Index | PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID | PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID |
Index | PK_SalesPerson_SalesPersonID | PK_SalesPerson_SalesPersonID |
Index | PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate | PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate |
Index | PK_SalesReason_SalesReasonID | PK_SalesReason_SalesReasonID |
Index | PK_SalesTaxRate_SalesTaxRateID | PK_SalesTaxRate_SalesTaxRateID |
Index | PK_SalesTerritory_TerritoryID | PK_SalesTerritory_TerritoryID |
Index | PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID | PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID |
Index | PK_ScrapReason_ScrapReasonID | PK_ScrapReason_ScrapReasonID |
Index | PK_Shift_ShiftID | PK_Shift_ShiftID |
Index | PK_ShipMethod_ShipMethodID | PK_ShipMethod_ShipMethodID |
Index | PK_ShoppingCartItem_ShoppingCartItemID | PK_ShoppingCartItem_ShoppingCartItemID |
Index | PK_SpecialOffer_SpecialOfferID | PK_SpecialOffer_SpecialOfferID |
Index | PK_SpecialOfferProduct_SpecialOfferID_ProductID | PK_SpecialOfferProduct_SpecialOfferID_ProductID |
Index | PK_StateProvince_StateProvinceID | PK_StateProvince_StateProvinceID |
Index | PK_Store_CustomerID | PK_Store_CustomerID |
Index | PK_StoreContact_CustomerID_ContactID | PK_StoreContact_CustomerID_ContactID |
Index | PK_TransactionHistory_TransactionID | PK_TransactionHistory_TransactionID |
Index | PK_TransactionHistoryArchive_TransactionID | PK_TransactionHistoryArchive_TransactionID |
Index | PK_UnitMeasure_UnitMeasureCode | PK_UnitMeasure_UnitMeasureCode |
Index | PK_Vendor_VendorID | PK_Vendor_VendorID |
Index | PK_VendorAddress_VendorID_AddressID | PK_VendorAddress_VendorID_AddressID |
Index | PK_VendorContact_VendorID_ContactID | PK_VendorContact_VendorID_ContactID |
Index | PK_WorkOrder_WorkOrderID | PK_WorkOrder_WorkOrderID |
Index | PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence | PK_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 |