| 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 datetime NOT NULL default (getdate()) | Person.Address.ModifiedDate datetime2 NOT NULL default (getdate()) |
| Table | Person.Address | Person.Address |
| Column | Person.Contact.ContactID int identity NOT NULL Primary Key | Person.Contact.ContactID int identity NOT NULL Primary Key |
| Column | Person.Contact.NameStyle NameStyle NOT NULL default ((0)) | Person.Contact.NameStyle bit NOT NULL default ((0)) |
| Column | Person.Contact.Title nvarchar(8) NULL | Person.Contact.Title nvarchar(8) NULL |
| Column | Person.Contact.FirstName Name NOT NULL | Person.Contact.FirstName nvarchar(50) NOT NULL |
| Column | Person.Contact.MiddleName Name NULL | Person.Contact.MiddleName nvarchar(50) NULL |
| Column | Person.Contact.LastName Name NOT NULL | Person.Contact.LastName nvarchar(50) 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 Phone NULL | Person.Contact.Phone nvarchar(25) NULL |
| Column | Person.Contact.PasswordHash varchar(40) NOT NULL | Person.Contact.PasswordHash varchar(40) 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 datetime NOT NULL default (getdate()) | Person.Contact.ModifiedDate datetime2 NOT NULL default (getdate()) |
| Table | Person.Contact | Person.Contact |
| Column | Production.Product.ProductID int identity NOT NULL Primary Key | Production.Product.ProductID int identity NOT NULL Primary Key |
| Column | Production.Product.Name Name NOT NULL | Production.Product.Name nvarchar(50) NOT NULL |
| Column | Production.Product.ProductNumber nvarchar(25) NOT NULL | Production.Product.ProductNumber nvarchar(25) NOT NULL |
| Column | Production.Product.MakeFlag Flag NOT NULL default ((1)) | Production.Product.MakeFlag bit NOT NULL default ((1)) |
| Column | Production.Product.FinishedGoodsFlag Flag NOT NULL default ((1)) | Production.Product.FinishedGoodsFlag bit 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 money NOT NULL CHECK ([StandardCost]>=(0.00)) | Production.Product.StandardCost decimal(19,4) NOT NULL CHECK ([StandardCost]>=(0.00)) |
| Column | Production.Product.ListPrice money NOT NULL CHECK ([ListPrice]>=(0.00)) | Production.Product.ListPrice decimal(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 datetime NOT NULL | Production.Product.SellStartDate datetime2 NOT NULL |
| Column | Production.Product.SellEndDate datetime NULL | Production.Product.SellEndDate datetime2 NULL |
| Column | Production.Product.DiscontinuedDate datetime NULL | Production.Product.DiscontinuedDate datetime2 NULL |
| Column | Production.Product.rowguid uniqueidentifier NOT NULL default (newid()) | Production.Product.rowguid uniqueidentifier NOT NULL default (newid()) |
| Column | Production.Product.ModifiedDate datetime NOT NULL default (getdate()) | Production.Product.ModifiedDate datetime2 NOT NULL default (getdate()) |
| Table | Production.Product | Production.Product |