[User: Saurabh Sharma]

Columns

Schema Name Table Name Column Name Is_Nullable Column Collation MaxLength Precision Scale Datatype Datatype Desc Default Value Primary Key Foreign Key unique_key Check Constraint Computed Column Definition Object Desc Object Process Mapping
HumanResources EmployeePayHistory BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
HumanResources EmployeePayHistory RateChangeDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime PK
HumanResources EmployeePayHistory Rate False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_EmployeePayHistory_Rate
HumanResources EmployeePayHistory PayFrequency False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint CK_EmployeePayHistory_PayFrequency
HumanResources EmployeePayHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesOrderHeaderSalesReason SalesOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesOrderHeaderSalesReason SalesReasonID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesOrderHeaderSalesReason ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesPerson BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesPerson TerritoryID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesPerson SalesQuota True SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_SalesPerson_SalesQuota
Sales SalesPerson Bonus False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesPerson_Bonus
Sales SalesPerson CommissionPct False SQL_Latin1_General_CP1_CI_AS 4 10 4 smallmoney smallmoney ((0.00)) CK_SalesPerson_CommissionPct
Sales SalesPerson SalesYTD False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesPerson_SalesYTD
Sales SalesPerson SalesLastYear False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesPerson_SalesLastYear
Sales SalesPerson rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesPerson ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production Illustration IllustrationID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production Illustration Diagram True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Production Illustration ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
HumanResources JobCandidate JobCandidateID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
HumanResources JobCandidate BusinessEntityID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
HumanResources JobCandidate Resume True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
HumanResources JobCandidate ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production Location LocationID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK
Production Location Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production Location CostRate False SQL_Latin1_General_CP1_CI_AS 4 10 4 smallmoney smallmoney ((0.00)) CK_Location_CostRate
Production Location Availability False SQL_Latin1_General_CP1_CI_AS 5 8 2 decimal decimal(8, 2) ((0.00)) CK_Location_Availability
Production Location ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person Password BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person Password PasswordHash False SQL_Latin1_General_CP1_CI_AS 128 0 0 varchar varchar(128)
Person Password PasswordSalt False SQL_Latin1_General_CP1_CI_AS 10 0 0 varchar varchar(10)
Person Password rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person Password ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesPersonQuotaHistory BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesPersonQuotaHistory QuotaDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime PK
Sales SalesPersonQuotaHistory SalesQuota False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_SalesPersonQuotaHistory_SalesQuota
Sales SalesPersonQuotaHistory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesPersonQuotaHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person Person BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person Person PersonType False SQL_Latin1_General_CP1_CI_AS 4 0 0 nchar nchar(2) CK_Person_PersonType
Person Person NameStyle False SQL_Latin1_General_CP1_CI_AS 1 1 0 NameStyle NameStyle:bit ((0))
Person Person Title True SQL_Latin1_General_CP1_CI_AS 16 0 0 nvarchar nvarchar(8)
Person Person FirstName False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person Person MiddleName True SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person Person LastName False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person Person Suffix True SQL_Latin1_General_CP1_CI_AS 20 0 0 nvarchar nvarchar(10)
Person Person EmailPromotion False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((0)) CK_Person_EmailPromotion
Person Person AdditionalContactInfo True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Person Person Demographics True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Person Person rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person Person ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesReason SalesReasonID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SalesReason Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales SalesReason ReasonType False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales SalesReason ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesTaxRate SalesTaxRateID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SalesTaxRate StateProvinceID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesTaxRate TaxType False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint CK_SalesTaxRate_TaxType
Sales SalesTaxRate TaxRate False SQL_Latin1_General_CP1_CI_AS 4 10 4 smallmoney smallmoney ((0.00))
Sales SalesTaxRate Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales SalesTaxRate rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesTaxRate ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales PersonCreditCard BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales PersonCreditCard CreditCardID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales PersonCreditCard ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person PersonPhone BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person PersonPhone PhoneNumber False SQL_Latin1_General_CP1_CI_AS 50 0 0 Phone Phone:nvarchar(50) PK
Person PersonPhone PhoneNumberTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person PersonPhone ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesTerritory TerritoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SalesTerritory Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales SalesTerritory CountryRegionCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nvarchar nvarchar(3) FK
Sales SalesTerritory Group False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Sales SalesTerritory SalesYTD False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesTerritory_SalesYTD
Sales SalesTerritory SalesLastYear False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesTerritory_SalesLastYear
Sales SalesTerritory CostYTD False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesTerritory_CostYTD
Sales SalesTerritory CostLastYear False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesTerritory_CostLastYear
Sales SalesTerritory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesTerritory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person PhoneNumberType PhoneNumberTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person PhoneNumberType Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person PhoneNumberType ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production Product ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production Product Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production Product ProductNumber False SQL_Latin1_General_CP1_CI_AS 50 0 0 nvarchar nvarchar(25)
Production Product MakeFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Production Product FinishedGoodsFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Production Product Color True SQL_Latin1_General_CP1_CI_AS 30 0 0 nvarchar nvarchar(15)
Production Product SafetyStockLevel False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint CK_Product_SafetyStockLevel
Production Product ReorderPoint False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint CK_Product_ReorderPoint
Production Product StandardCost False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_Product_StandardCost
Production Product ListPrice False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_Product_ListPrice
Production Product Size True SQL_Latin1_General_CP1_CI_AS 10 0 0 nvarchar nvarchar(5)
Production Product SizeUnitMeasureCode True SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Production Product WeightUnitMeasureCode True SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Production Product Weight True SQL_Latin1_General_CP1_CI_AS 5 8 2 decimal decimal(8, 2) CK_Product_Weight
Production Product DaysToManufacture False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_Product_DaysToManufacture
Production Product ProductLine True SQL_Latin1_General_CP1_CI_AS 4 0 0 nchar nchar(2) CK_Product_ProductLine
Production Product Class True SQL_Latin1_General_CP1_CI_AS 4 0 0 nchar nchar(2) CK_Product_Class
Production Product Style True SQL_Latin1_General_CP1_CI_AS 4 0 0 nchar nchar(2) CK_Product_Style
Production Product ProductSubcategoryID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production Product ProductModelID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production Product SellStartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production Product SellEndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production Product DiscontinuedDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production Product rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production Product ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesTerritoryHistory BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesTerritoryHistory TerritoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesTerritoryHistory StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime PK
Sales SalesTerritoryHistory EndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales SalesTerritoryHistory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesTerritoryHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ScrapReason ScrapReasonID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK
Production ScrapReason Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production ScrapReason ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
HumanResources Shift ShiftID False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint PK
HumanResources Shift Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
HumanResources Shift StartTime False SQL_Latin1_General_CP1_CI_AS 5 16 7 time time(7)
HumanResources Shift EndTime False SQL_Latin1_General_CP1_CI_AS 5 16 7 time time(7)
HumanResources Shift ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductCategory ProductCategoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductCategory Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production ProductCategory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production ProductCategory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing ShipMethod ShipMethodID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Purchasing ShipMethod Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Purchasing ShipMethod ShipBase False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_ShipMethod_ShipBase
Purchasing ShipMethod ShipRate False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_ShipMethod_ShipRate
Purchasing ShipMethod rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Purchasing ShipMethod ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductCostHistory ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductCostHistory StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime PK
Production ProductCostHistory EndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production ProductCostHistory StandardCost False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_ProductCostHistory_StandardCost
Production ProductCostHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductDescription ProductDescriptionID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductDescription Description False SQL_Latin1_General_CP1_CI_AS 800 0 0 nvarchar nvarchar(400)
Production ProductDescription rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production ProductDescription ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales ShoppingCartItem ShoppingCartItemID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales ShoppingCartItem ShoppingCartID False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Sales ShoppingCartItem Quantity False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((1)) CK_ShoppingCartItem_Quantity
Sales ShoppingCartItem ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales ShoppingCartItem DateCreated False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales ShoppingCartItem ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductDocument ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductDocument DocumentNode False SQL_Latin1_General_CP1_CI_AS 892 0 0 hierarchyid hierarchyid PK FK
Production ProductDocument ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
dbo DatabaseLog DatabaseLogID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
dbo DatabaseLog PostTime False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
dbo DatabaseLog DatabaseUser False SQL_Latin1_General_CP1_CI_AS 256 0 0 sysname sysname
dbo DatabaseLog Event False SQL_Latin1_General_CP1_CI_AS 256 0 0 sysname sysname
dbo DatabaseLog Schema True SQL_Latin1_General_CP1_CI_AS 256 0 0 sysname sysname
dbo DatabaseLog Object True SQL_Latin1_General_CP1_CI_AS 256 0 0 sysname sysname
dbo DatabaseLog TSQL False SQL_Latin1_General_CP1_CI_AS -1 0 0 nvarchar nvarchar(MAX)
dbo DatabaseLog XmlEvent False SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Production ProductInventory ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductInventory LocationID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK FK
Production ProductInventory Shelf False SQL_Latin1_General_CP1_CI_AS 20 0 0 nvarchar nvarchar(10) CK_ProductInventory_Shelf
Production ProductInventory Bin False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint CK_ProductInventory_Bin
Production ProductInventory Quantity False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint ((0))
Production ProductInventory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production ProductInventory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SpecialOffer SpecialOfferID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SpecialOffer Description False SQL_Latin1_General_CP1_CI_AS 510 0 0 nvarchar nvarchar(255)
Sales SpecialOffer DiscountPct False SQL_Latin1_General_CP1_CI_AS 4 10 4 smallmoney smallmoney ((0.00)) CK_SpecialOffer_DiscountPct
Sales SpecialOffer Type False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Sales SpecialOffer Category False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Sales SpecialOffer StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales SpecialOffer EndDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales SpecialOffer MinQty False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((0)) CK_SpecialOffer_MinQty
Sales SpecialOffer MaxQty True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_SpecialOffer_MaxQty
Sales SpecialOffer rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SpecialOffer ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
dbo ErrorLog ErrorLogID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
dbo ErrorLog ErrorTime False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
dbo ErrorLog UserName False SQL_Latin1_General_CP1_CI_AS 256 0 0 sysname sysname
dbo ErrorLog ErrorNumber False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
dbo ErrorLog ErrorSeverity True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
dbo ErrorLog ErrorState True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
dbo ErrorLog ErrorProcedure True SQL_Latin1_General_CP1_CI_AS 252 0 0 nvarchar nvarchar(126)
dbo ErrorLog ErrorLine True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
dbo ErrorLog ErrorMessage False SQL_Latin1_General_CP1_CI_AS 8000 0 0 nvarchar nvarchar(4000)
Production ProductListPriceHistory ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductListPriceHistory StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime PK
Production ProductListPriceHistory EndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production ProductListPriceHistory ListPrice False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_ProductListPriceHistory_ListPrice
Production ProductListPriceHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person Address AddressID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person Address AddressLine1 False SQL_Latin1_General_CP1_CI_AS 120 0 0 nvarchar nvarchar(60)
Person Address AddressLine2 True SQL_Latin1_General_CP1_CI_AS 120 0 0 nvarchar nvarchar(60)
Person Address City False SQL_Latin1_General_CP1_CI_AS 60 0 0 nvarchar nvarchar(30)
Person Address StateProvinceID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Person Address PostalCode False SQL_Latin1_General_CP1_CI_AS 30 0 0 nvarchar nvarchar(15)
Person Address SpatialLocation True SQL_Latin1_General_CP1_CI_AS -1 0 0 geography geography
Person Address rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person Address ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SpecialOfferProduct SpecialOfferID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SpecialOfferProduct ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SpecialOfferProduct rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SpecialOfferProduct ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductModel ProductModelID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductModel Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production ProductModel CatalogDescription True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Production ProductModel Instructions True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Production ProductModel rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production ProductModel ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person AddressType AddressTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person AddressType Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person AddressType rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person AddressType ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person StateProvince StateProvinceID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person StateProvince StateProvinceCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3)
Person StateProvince CountryRegionCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nvarchar nvarchar(3) FK
Person StateProvince IsOnlyStateProvinceFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Person StateProvince Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person StateProvince TerritoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Person StateProvince rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person StateProvince ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductModelIllustration ProductModelID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductModelIllustration IllustrationID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductModelIllustration ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
dbo AWBuildVersion SystemInformationID False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint PK
dbo AWBuildVersion Database Version False SQL_Latin1_General_CP1_CI_AS 50 0 0 nvarchar nvarchar(25)
dbo AWBuildVersion VersionDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
dbo AWBuildVersion ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductModelProductDescriptionCulture ProductModelID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductModelProductDescriptionCulture ProductDescriptionID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductModelProductDescriptionCulture CultureID False SQL_Latin1_General_CP1_CI_AS 12 0 0 nchar nchar(6) PK FK
Production ProductModelProductDescriptionCulture ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production BillOfMaterials BillOfMaterialsID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production BillOfMaterials ProductAssemblyID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production BillOfMaterials ComponentID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production BillOfMaterials StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production BillOfMaterials EndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production BillOfMaterials UnitMeasureCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Production BillOfMaterials BOMLevel False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint
Production BillOfMaterials PerAssemblyQty False SQL_Latin1_General_CP1_CI_AS 5 8 2 decimal decimal(8, 2) ((1.00)) CK_BillOfMaterials_PerAssemblyQty
Production BillOfMaterials ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales Store BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales Store Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales Store SalesPersonID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales Store Demographics True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Sales Store rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales Store ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductPhoto ProductPhotoID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductPhoto ThumbNailPhoto True SQL_Latin1_General_CP1_CI_AS -1 0 0 varbinary varbinary(MAX)
Production ProductPhoto ThumbnailPhotoFileName True SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Production ProductPhoto LargePhoto True SQL_Latin1_General_CP1_CI_AS -1 0 0 varbinary varbinary(MAX)
Production ProductPhoto LargePhotoFileName True SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Production ProductPhoto ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductProductPhoto ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductProductPhoto ProductPhotoID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductProductPhoto Primary False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((0))
Production ProductProductPhoto ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production TransactionHistory TransactionID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production TransactionHistory ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production TransactionHistory ReferenceOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
Production TransactionHistory ReferenceOrderLineID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((0))
Production TransactionHistory TransactionDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production TransactionHistory TransactionType False SQL_Latin1_General_CP1_CI_AS 2 0 0 nchar nchar(1) CK_TransactionHistory_TransactionType
Production TransactionHistory Quantity False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
Production TransactionHistory ActualCost False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money
Production TransactionHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductReview ProductReviewID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductReview ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production ProductReview ReviewerName False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production ProductReview ReviewDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductReview EmailAddress False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Production ProductReview Rating False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_ProductReview_Rating
Production ProductReview Comments True SQL_Latin1_General_CP1_CI_AS 7700 0 0 nvarchar nvarchar(3850)
Production ProductReview ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person BusinessEntity BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person BusinessEntity rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person BusinessEntity ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production TransactionHistoryArchive TransactionID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production TransactionHistoryArchive ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
Production TransactionHistoryArchive ReferenceOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
Production TransactionHistoryArchive ReferenceOrderLineID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((0))
Production TransactionHistoryArchive TransactionDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production TransactionHistoryArchive TransactionType False SQL_Latin1_General_CP1_CI_AS 2 0 0 nchar nchar(1) CK_TransactionHistoryArchive_TransactionType
Production TransactionHistoryArchive Quantity False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
Production TransactionHistoryArchive ActualCost False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money
Production TransactionHistoryArchive ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductSubcategory ProductSubcategoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductSubcategory ProductCategoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production ProductSubcategory Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production ProductSubcategory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production ProductSubcategory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person BusinessEntityAddress BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityAddress AddressID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityAddress AddressTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityAddress rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person BusinessEntityAddress ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing ProductVendor ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Purchasing ProductVendor BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Purchasing ProductVendor AverageLeadTime False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_ProductVendor_AverageLeadTime
Purchasing ProductVendor StandardPrice False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_ProductVendor_StandardPrice
Purchasing ProductVendor LastReceiptCost True SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_ProductVendor_LastReceiptCost
Purchasing ProductVendor LastReceiptDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Purchasing ProductVendor MinOrderQty False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_ProductVendor_MinOrderQty
Purchasing ProductVendor MaxOrderQty False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_ProductVendor_MaxOrderQty
Purchasing ProductVendor OnOrderQty True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_ProductVendor_OnOrderQty
Purchasing ProductVendor UnitMeasureCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Purchasing ProductVendor ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person BusinessEntityContact BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityContact PersonID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityContact ContactTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityContact rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person BusinessEntityContact ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production UnitMeasure UnitMeasureCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) PK
Production UnitMeasure Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production UnitMeasure ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing Vendor BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Purchasing Vendor AccountNumber False SQL_Latin1_General_CP1_CI_AS 30 0 0 AccountNumber AccountNumber:nvarchar(30)
Purchasing Vendor Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Purchasing Vendor CreditRating False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint CK_Vendor_CreditRating
Purchasing Vendor PreferredVendorStatus False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Purchasing Vendor ActiveFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Purchasing Vendor PurchasingWebServiceURL True SQL_Latin1_General_CP1_CI_AS 2048 0 0 nvarchar nvarchar(1024)
Purchasing Vendor ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person ContactType ContactTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person ContactType Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person ContactType ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales CountryRegionCurrency CountryRegionCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nvarchar nvarchar(3) PK FK
Sales CountryRegionCurrency CurrencyCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) PK FK
Sales CountryRegionCurrency ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person CountryRegion CountryRegionCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nvarchar nvarchar(3) PK
Person CountryRegion Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person CountryRegion ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production WorkOrder WorkOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production WorkOrder ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production WorkOrder OrderQty False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_WorkOrder_OrderQty
Production WorkOrder StockedQty False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int (isnull([OrderQty]-[ScrappedQty],(0)))
Production WorkOrder ScrappedQty False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint CK_WorkOrder_ScrappedQty
Production WorkOrder StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrder EndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrder DueDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrder ScrapReasonID True SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint FK
Production WorkOrder ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing PurchaseOrderDetail PurchaseOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Purchasing PurchaseOrderDetail PurchaseOrderDetailID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Purchasing PurchaseOrderDetail DueDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Purchasing PurchaseOrderDetail OrderQty False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint CK_PurchaseOrderDetail_OrderQty
Purchasing PurchaseOrderDetail ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Purchasing PurchaseOrderDetail UnitPrice False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_PurchaseOrderDetail_UnitPrice
Purchasing PurchaseOrderDetail LineTotal False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money (isnull([OrderQty]*[UnitPrice],(0.00)))
Purchasing PurchaseOrderDetail ReceivedQty False SQL_Latin1_General_CP1_CI_AS 5 8 2 decimal decimal(8, 2) CK_PurchaseOrderDetail_ReceivedQty
Purchasing PurchaseOrderDetail RejectedQty False SQL_Latin1_General_CP1_CI_AS 5 8 2 decimal decimal(8, 2) CK_PurchaseOrderDetail_RejectedQty
Purchasing PurchaseOrderDetail StockedQty False SQL_Latin1_General_CP1_CI_AS 5 9 2 decimal decimal(9, 2) (isnull([ReceivedQty]-[RejectedQty],(0.00)))
Purchasing PurchaseOrderDetail ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales CreditCard CreditCardID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales CreditCard CardType False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Sales CreditCard CardNumber False SQL_Latin1_General_CP1_CI_AS 50 0 0 nvarchar nvarchar(25)
Sales CreditCard ExpMonth False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint
Sales CreditCard ExpYear False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint
Sales CreditCard ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production Culture CultureID False SQL_Latin1_General_CP1_CI_AS 12 0 0 nchar nchar(6) PK
Production Culture Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production Culture ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production WorkOrderRouting WorkOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production WorkOrderRouting ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production WorkOrderRouting OperationSequence False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK
Production WorkOrderRouting LocationID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint FK
Production WorkOrderRouting ScheduledStartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrderRouting ScheduledEndDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrderRouting ActualStartDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrderRouting ActualEndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrderRouting ActualResourceHrs True SQL_Latin1_General_CP1_CI_AS 5 9 4 decimal decimal(9, 4) CK_WorkOrderRouting_ActualResourceHrs
Production WorkOrderRouting PlannedCost False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_WorkOrderRouting_PlannedCost
Production WorkOrderRouting ActualCost True SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_WorkOrderRouting_ActualCost
Production WorkOrderRouting ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales Currency CurrencyCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) PK
Sales Currency Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales Currency ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing PurchaseOrderHeader PurchaseOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Purchasing PurchaseOrderHeader RevisionNumber False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint ((0))
Purchasing PurchaseOrderHeader Status False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint ((1)) CK_PurchaseOrderHeader_Status
Purchasing PurchaseOrderHeader EmployeeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Purchasing PurchaseOrderHeader VendorID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Purchasing PurchaseOrderHeader ShipMethodID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Purchasing PurchaseOrderHeader OrderDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing PurchaseOrderHeader ShipDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Purchasing PurchaseOrderHeader SubTotal False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_PurchaseOrderHeader_SubTotal
Purchasing PurchaseOrderHeader TaxAmt False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_PurchaseOrderHeader_TaxAmt
Purchasing PurchaseOrderHeader Freight False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_PurchaseOrderHeader_Freight
Purchasing PurchaseOrderHeader TotalDue False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money (isnull(([SubTotal]+[TaxAmt])+[Freight],(0)))
Purchasing PurchaseOrderHeader ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales CurrencyRate CurrencyRateID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales CurrencyRate CurrencyRateDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales CurrencyRate FromCurrencyCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Sales CurrencyRate ToCurrencyCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Sales CurrencyRate AverageRate False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money
Sales CurrencyRate EndOfDayRate False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money
Sales CurrencyRate ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales Customer CustomerID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales Customer PersonID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales Customer StoreID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales Customer TerritoryID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales Customer AccountNumber False SQL_Latin1_General_CP1_CI_AS 10 0 0 varchar varchar(10) (isnull('AW'+[dbo].[ufnLeadingZeros]([CustomerID]),''))
Sales Customer rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales Customer ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
HumanResources Department DepartmentID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK
HumanResources Department Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
HumanResources Department GroupName False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
HumanResources Department ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production Document DocumentNode False SQL_Latin1_General_CP1_CI_AS 892 0 0 hierarchyid hierarchyid PK
Production Document DocumentLevel True SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint ([DocumentNode].[GetLevel]())
Production Document Title False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Production Document Owner False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production Document FolderFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 bit bit ((0))
Production Document FileName False SQL_Latin1_General_CP1_CI_AS 800 0 0 nvarchar nvarchar(400)
Production Document FileExtension False SQL_Latin1_General_CP1_CI_AS 16 0 0 nvarchar nvarchar(8)
Production Document Revision False SQL_Latin1_General_CP1_CI_AS 10 0 0 nchar nchar(5)
Production Document ChangeNumber False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((0))
Production Document Status False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint CK_Document_Status
Production Document DocumentSummary True SQL_Latin1_General_CP1_CI_AS -1 0 0 nvarchar nvarchar(MAX)
Production Document Document True SQL_Latin1_General_CP1_CI_AS -1 0 0 varbinary varbinary(MAX)
Production Document rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid()) UK
Production Document ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesOrderDetail SalesOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesOrderDetail SalesOrderDetailID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SalesOrderDetail CarrierTrackingNumber True SQL_Latin1_General_CP1_CI_AS 50 0 0 nvarchar nvarchar(25)
Sales SalesOrderDetail OrderQty False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint CK_SalesOrderDetail_OrderQty
Sales SalesOrderDetail ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderDetail SpecialOfferID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderDetail UnitPrice False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_SalesOrderDetail_UnitPrice
Sales SalesOrderDetail UnitPriceDiscount False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.0)) CK_SalesOrderDetail_UnitPriceDiscount
Sales SalesOrderDetail LineTotal False SQL_Latin1_General_CP1_CI_AS 17 38 6 numeric numeric(38, 6) (isnull(([UnitPrice]*((1.0)-[UnitPriceDiscount]))*[OrderQty],(0.0)))
Sales SalesOrderDetail rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesOrderDetail ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person EmailAddress BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person EmailAddress EmailAddressID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person EmailAddress EmailAddress True SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Person EmailAddress rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person EmailAddress ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
HumanResources Employee BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
HumanResources Employee NationalIDNumber False SQL_Latin1_General_CP1_CI_AS 30 0 0 nvarchar nvarchar(15)
HumanResources Employee LoginID False SQL_Latin1_General_CP1_CI_AS 512 0 0 nvarchar nvarchar(256)
HumanResources Employee OrganizationNode True SQL_Latin1_General_CP1_CI_AS 892 0 0 hierarchyid hierarchyid
HumanResources Employee OrganizationLevel True SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint ([OrganizationNode].[GetLevel]())
HumanResources Employee JobTitle False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
HumanResources Employee BirthDate False SQL_Latin1_General_CP1_CI_AS 3 10 0 date date CK_Employee_BirthDate
HumanResources Employee MaritalStatus False SQL_Latin1_General_CP1_CI_AS 2 0 0 nchar nchar(1) CK_Employee_MaritalStatus
HumanResources Employee Gender False SQL_Latin1_General_CP1_CI_AS 2 0 0 nchar nchar(1) CK_Employee_Gender
HumanResources Employee HireDate False SQL_Latin1_General_CP1_CI_AS 3 10 0 date date CK_Employee_HireDate
HumanResources Employee SalariedFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
HumanResources Employee VacationHours False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint ((0)) CK_Employee_VacationHours
HumanResources Employee SickLeaveHours False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint ((0)) CK_Employee_SickLeaveHours
HumanResources Employee CurrentFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
HumanResources Employee rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
HumanResources Employee ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesOrderHeader SalesOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SalesOrderHeader RevisionNumber False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint ((0))
Sales SalesOrderHeader OrderDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesOrderHeader DueDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales SalesOrderHeader ShipDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales SalesOrderHeader Status False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint ((1)) CK_SalesOrderHeader_Status
Sales SalesOrderHeader OnlineOrderFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Sales SalesOrderHeader SalesOrderNumber False SQL_Latin1_General_CP1_CI_AS 50 0 0 nvarchar nvarchar(25) (isnull(N'SO'+CONVERT([nvarchar](23),[SalesOrderID]),N'*** ERROR ***'))
Sales SalesOrderHeader PurchaseOrderNumber True SQL_Latin1_General_CP1_CI_AS 50 0 0 OrderNumber OrderNumber:nvarchar(50)
Sales SalesOrderHeader AccountNumber True SQL_Latin1_General_CP1_CI_AS 30 0 0 AccountNumber AccountNumber:nvarchar(30)
Sales SalesOrderHeader CustomerID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader SalesPersonID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader TerritoryID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader BillToAddressID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader ShipToAddressID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader ShipMethodID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader CreditCardID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader CreditCardApprovalCode True SQL_Latin1_General_CP1_CI_AS 15 0 0 varchar varchar(15)
Sales SalesOrderHeader CurrencyRateID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader SubTotal False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesOrderHeader_SubTotal
Sales SalesOrderHeader TaxAmt False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesOrderHeader_TaxAmt
Sales SalesOrderHeader Freight False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesOrderHeader_Freight
Sales SalesOrderHeader TotalDue False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money (isnull(([SubTotal]+[TaxAmt])+[Freight],(0)))
Sales SalesOrderHeader Comment True SQL_Latin1_General_CP1_CI_AS 256 0 0 nvarchar nvarchar(128)
Sales SalesOrderHeader rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesOrderHeader ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
HumanResources EmployeeDepartmentHistory BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
HumanResources EmployeeDepartmentHistory DepartmentID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK FK
HumanResources EmployeeDepartmentHistory ShiftID False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint PK FK
HumanResources EmployeeDepartmentHistory StartDate False SQL_Latin1_General_CP1_CI_AS 3 10 0 date date PK
HumanResources EmployeeDepartmentHistory EndDate True SQL_Latin1_General_CP1_CI_AS 3 10 0 date date
HumanResources EmployeeDepartmentHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())