AccountNumber	AccountNumber	15	NOT NULL	Vendor, SalesOrderHeader
AccountNumber	varchar	10	NOT NULL	Customer
ActiveFlag	Flag	1	NOT NULL	Vendor
ActualCost	money	8	NOT NULL	TransactionHistory, TransactionHistoryArchive, WorkOrderRouting
ActualEndDate	datetime	8	NULL	WorkOrderRouting
ActualResourceHrs	decimal	5	NULL	WorkOrderRouting
ActualStartDate	datetime	8	NULL	WorkOrderRouting
AdditionalContactInfo	AdditionalContactInfoSchemaCollection	-1	NULL	Contact
AddressID	int	4	NOT NULL	EmployeeAddress, Address, VendorAddress, CustomerAddress
AddressLine1	nvarchar	60	NOT NULL	Address
AddressLine2	nvarchar	60	NULL	Address
AddressTypeID	int	4	NOT NULL	VendorAddress, CustomerAddress, AddressType
Availability	decimal	5	NOT NULL	Location
AverageLeadTime	int	4	NOT NULL	ProductVendor
AverageRate	money	8	NOT NULL	CurrencyRate
BillOfMaterialsID	int	4	NOT NULL	BillOfMaterials
BillToAddressID	int	4	NOT NULL	SalesOrderHeader
Bin	tinyint	1	NOT NULL	ProductInventory
BirthDate	datetime	8	NOT NULL	Employee
BOMLevel	smallint	2	NOT NULL	BillOfMaterials
Bonus	money	8	NOT NULL	SalesPerson
CardNumber	nvarchar	25	NOT NULL	CreditCard
CardType	nvarchar	50	NOT NULL	CreditCard
CarrierTrackingNumber	nvarchar	25	NULL	SalesOrderDetail
CatalogDescription	ProductDescriptionSchemaCollection	-1	NULL	ProductModel
Category	nvarchar	50	NOT NULL	SpecialOffer
ChangeNumber	int	4	NOT NULL	Document
City	nvarchar	30	NOT NULL	Address
Class	nchar	2	NULL	Product
Color	nvarchar	15	NULL	Product
Comment	nvarchar	128	NULL	SalesOrderHeader
Comments	nvarchar	3850	NULL	ProductReview
CommissionPct	smallmoney	4	NOT NULL	SalesPerson
ComponentID	int	4	NOT NULL	BillOfMaterials
ContactID	int	4	NOT NULL	SalesOrderHeader, ContactCreditCard, VendorContact, StoreContact, Individual, Contact, Employee
ContactTypeID	int	4	NOT NULL	ContactType, VendorContact, StoreContact
CostLastYear	money	8	NOT NULL	SalesTerritory
CostRate	smallmoney	4	NOT NULL	Location
CostYTD	money	8	NOT NULL	SalesTerritory
CountryRegionCode	nvarchar	3	NOT NULL	CountryRegion, StateProvince, CountryRegionCurrency, SalesTerritory
CreditCardApprovalCode	varchar	15	NULL	SalesOrderHeader
CreditCardID	int	4	NULL	SalesOrderHeader, ContactCreditCard, CreditCard
CreditRating	tinyint	1	NOT NULL	Vendor
CultureID	nchar	6	NOT NULL	ProductModelProductDescriptionCulture, Culture
CurrencyCode	nchar	3	NOT NULL	Currency, CountryRegionCurrency
CurrencyRateDate	datetime	8	NOT NULL	CurrencyRate
CurrencyRateID	int	4	NULL	SalesOrderHeader, CurrencyRate
CurrentFlag	Flag	1	NOT NULL	Employee
CustomerID	int	4	NOT NULL	SalesOrderHeader, Individual, CustomerAddress, Customer, StoreContact, Store
CustomerType	nchar	1	NOT NULL	Customer
Database Version	nvarchar	25	NOT NULL	AWBuildVersion
DatabaseLogID	int	4	NOT NULL	DatabaseLog
DatabaseUser	sysname	128	NOT NULL	DatabaseLog
DateCreated	datetime	8	NOT NULL	ShoppingCartItem
DaysToManufacture	int	4	NOT NULL	Product
Demographics	IndividualSurveySchemaCollection	-1	NULL	Individual
Demographics	StoreSurveySchemaCollection	-1	NULL	Store
DepartmentID	smallint	2	NOT NULL	Department, EmployeeDepartmentHistory
Description	nvarchar	255	NOT NULL	SpecialOffer
Description	nvarchar	400	NOT NULL	ProductDescription
Diagram		-1	NULL	Illustration
DiscontinuedDate	datetime	8	NULL	Product
DiscountPct	smallmoney	4	NOT NULL	SpecialOffer
Document	varbinary	-1	NULL	Document
DocumentID	int	4	NOT NULL	Document, ProductDocument
DocumentSummary	nvarchar	-1	NULL	Document
DueDate	datetime	8	NOT NULL	SalesOrderHeader, WorkOrder, PurchaseOrderDetail
EmailAddress	nvarchar	50	NULL	Contact, ProductReview
EmailPromotion	int	4	NOT NULL	Contact
EmployeeID	int	4	NOT NULL	EmployeeAddress, EmployeeDepartmentHistory, JobCandidate, PurchaseOrderHeader, EmployeePayHistory, Employee
EndDate	datetime	8	NULL	ProductListPriceHistory, SalesTerritoryHistory, ProductCostHistory, SpecialOffer, EmployeeDepartmentHistory, BillOfMaterials, WorkOrder
EndOfDayRate	money	8	NOT NULL	CurrencyRate
EndTime	datetime	8	NOT NULL	Shift
ErrorLine	int	4	NULL	ErrorLog
ErrorLogID	int	4	NOT NULL	ErrorLog
ErrorMessage	nvarchar	4000	NOT NULL	ErrorLog
ErrorNumber	int	4	NOT NULL	ErrorLog
ErrorProcedure	nvarchar	126	NULL	ErrorLog
ErrorSeverity	int	4	NULL	ErrorLog
ErrorState	int	4	NULL	ErrorLog
ErrorTime	datetime	8	NOT NULL	ErrorLog
Event	sysname	128	NOT NULL	DatabaseLog
ExpMonth	tinyint	1	NOT NULL	CreditCard
ExpYear	smallint	2	NOT NULL	CreditCard
FileExtension	nvarchar	8	NOT NULL	Document
FileName	nvarchar	400	NOT NULL	Document
FinishedGoodsFlag	Flag	1	NOT NULL	Product
FirstName	Name	50	NOT NULL	Contact
Freight	money	8	NOT NULL	PurchaseOrderHeader, SalesOrderHeader
FromCurrencyCode	nchar	3	NOT NULL	CurrencyRate
Gender	nchar	1	NOT NULL	Employee
Group	nvarchar	50	NOT NULL	SalesTerritory
GroupName	Name	50	NOT NULL	Department
HireDate	datetime	8	NOT NULL	Employee
IllustrationID	int	4	NOT NULL	ProductModelIllustration, Illustration
Instructions	ManuInstructionsSchemaCollection	-1	NULL	ProductModel
IsOnlyStateProvinceFlag	Flag	1	NOT NULL	StateProvince
JobCandidateID	int	4	NOT NULL	JobCandidate
LargePhoto	varbinary	-1	NULL	ProductPhoto
LargePhotoFileName	nvarchar	50	NULL	ProductPhoto
LastName	Name	50	NOT NULL	Contact
LastReceiptCost	money	8	NULL	ProductVendor
LastReceiptDate	datetime	8	NULL	ProductVendor
LineTotal	money	8	NOT NULL	PurchaseOrderDetail
LineTotal	numeric	17	NOT NULL	SalesOrderDetail
ListPrice	money	8	NOT NULL	ProductListPriceHistory, Product
LocationID	smallint	2	NOT NULL	ProductInventory, WorkOrderRouting, Location
LoginID	nvarchar	256	NOT NULL	Employee
MakeFlag	Flag	1	NOT NULL	Product
ManagerID	int	4	NULL	Employee
MaritalStatus	nchar	1	NOT NULL	Employee
MaxOrderQty	int	4	NOT NULL	ProductVendor
MaxQty	int	4	NULL	SpecialOffer
MiddleName	Name	50	NULL	Contact
MinOrderQty	int	4	NOT NULL	ProductVendor
MinQty	int	4	NOT NULL	SpecialOffer
ModifiedDate	datetime	8	NOT NULL	UnitMeasure, Individual, ScrapReason, ProductSubcategory, Shift, ProductProductPhoto, ProductReview, SalesOrderDetail, Address, Store, TransactionHistory, CustomerAddress, Document, Customer, ShoppingCartItem, Culture, TransactionHistoryArchive, JobCandidate, ContactCreditCard, PurchaseOrderHeader, VendorContact, PurchaseOrderDetail, SpecialOfferProduct, CountryRegionCurrency, Vendor, VendorAddress, StoreContact, ShipMethod, Department, AWBuildVersion, SalesTaxRate, SalesReason, EmployeeDepartmentHistory, WorkOrderRouting, CurrencyRate, EmployeePayHistory, WorkOrder, Employee, SpecialOffer, CreditCard, EmployeeAddress, Currency, ProductVendor, ProductDescription, ProductDocument, ProductCostHistory, ContactType, Contact, SalesTerritoryHistory, ProductModel, ProductModelIllustration, ProductListPriceHistory, ProductInventory, BillOfMaterials, SalesPerson, StateProvince, SalesPersonQuotaHistory, Illustration, Location, SalesOrderHeaderSalesReason, Product, ProductCategory, CountryRegion, SalesOrderHeader, SalesTerritory, ProductModelProductDescriptionCulture, ProductPhoto, AddressType
Name	Name	50	NOT NULL	ContactType, Product, UnitMeasure, ShipMethod, SalesReason, SalesTaxRate, ProductSubcategory, Shift, ScrapReason, CountryRegion, ProductCategory, SalesTerritory, Department, Store, Location, AddressType, Vendor, Culture, ProductModel, StateProvince, Currency
NameStyle	NameStyle	1	NOT NULL	Contact
NationalIDNumber	nvarchar	15	NOT NULL	Employee
Object	sysname	128	NULL	DatabaseLog
OnlineOrderFlag	Flag	1	NOT NULL	SalesOrderHeader
OnOrderQty	int	4	NULL	ProductVendor
OperationSequence	smallint	2	NOT NULL	WorkOrderRouting
OrderDate	datetime	8	NOT NULL	SalesOrderHeader, PurchaseOrderHeader
OrderQty	int	4	NOT NULL	WorkOrder
OrderQty	smallint	2	NOT NULL	PurchaseOrderDetail, SalesOrderDetail
PasswordHash	varchar	40	NOT NULL	Contact
PasswordSalt	varchar	10	NOT NULL	Contact
PayFrequency	tinyint	1	NOT NULL	EmployeePayHistory
PerAssemblyQty	decimal	5	NOT NULL	BillOfMaterials
Phone	Phone	25	NULL	Contact
PlannedCost	money	8	NOT NULL	WorkOrderRouting
PostalCode	nvarchar	15	NOT NULL	Address
PostTime	datetime	8	NOT NULL	DatabaseLog
PreferredVendorStatus	Flag	1	NOT NULL	Vendor
Primary	Flag	1	NOT NULL	ProductProductPhoto
ProductAssemblyID	int	4	NULL	BillOfMaterials
ProductCategoryID	int	4	NOT NULL	ProductCategory, ProductSubcategory
ProductDescriptionID	int	4	NOT NULL	ProductModelProductDescriptionCulture, ProductDescription
ProductID	int	4	NOT NULL	SpecialOfferProduct, Product, ProductReview, ProductProductPhoto, ShoppingCartItem, PurchaseOrderDetail, ProductDocument, ProductListPriceHistory, ProductVendor, WorkOrderRouting, ProductInventory, SalesOrderDetail, WorkOrder, TransactionHistory, ProductCostHistory, TransactionHistoryArchive
ProductLine	nchar	2	NULL	Product
ProductModelID	int	4	NOT NULL	ProductModelProductDescriptionCulture, ProductModelIllustration, ProductModel, Product
ProductNumber	nvarchar	25	NOT NULL	Product
ProductPhotoID	int	4	NOT NULL	ProductProductPhoto, ProductPhoto
ProductReviewID	int	4	NOT NULL	ProductReview
ProductSubcategoryID	int	4	NULL	Product, ProductSubcategory
PurchaseOrderDetailID	int	4	NOT NULL	PurchaseOrderDetail
PurchaseOrderID	int	4	NOT NULL	PurchaseOrderHeader, PurchaseOrderDetail
PurchaseOrderNumber	OrderNumber	25	NULL	SalesOrderHeader
PurchasingWebServiceURL	nvarchar	1024	NULL	Vendor
Quantity	int	4	NOT NULL	TransactionHistory, ShoppingCartItem, TransactionHistoryArchive
Quantity	smallint	2	NOT NULL	ProductInventory
QuotaDate	datetime	8	NOT NULL	SalesPersonQuotaHistory
Rate	money	8	NOT NULL	EmployeePayHistory
RateChangeDate	datetime	8	NOT NULL	EmployeePayHistory
Rating	int	4	NOT NULL	ProductReview
ReasonType	Name	50	NOT NULL	SalesReason
ReceivedQty	decimal	5	NOT NULL	PurchaseOrderDetail
ReferenceOrderID	int	4	NOT NULL	TransactionHistoryArchive, TransactionHistory
ReferenceOrderLineID	int	4	NOT NULL	TransactionHistoryArchive, TransactionHistory
RejectedQty	decimal	5	NOT NULL	PurchaseOrderDetail
ReorderPoint	smallint	2	NOT NULL	Product
Resume	HRResumeSchemaCollection	-1	NULL	JobCandidate
ReviewDate	datetime	8	NOT NULL	ProductReview
ReviewerName	Name	50	NOT NULL	ProductReview
Revision	nchar	5	NOT NULL	Document
RevisionNumber	tinyint	1	NOT NULL	PurchaseOrderHeader, SalesOrderHeader
rowguid	uniqueidentifier	16	NOT NULL	Product, Address, Customer, SalesTaxRate, AddressType, EmployeeAddress, SalesTerritory, CustomerAddress, SalesPerson, StoreContact, Contact, SalesOrderHeader, ShipMethod, ProductSubcategory, ProductCategory, SpecialOfferProduct, ProductModel, SalesPersonQuotaHistory, ProductDescription, ProductInventory, SalesOrderDetail, Employee, SpecialOffer, StateProvince, SalesTerritoryHistory, Store
SafetyStockLevel	smallint	2	NOT NULL	Product
SalariedFlag	Flag	1	NOT NULL	Employee
SalesLastYear	money	8	NOT NULL	SalesPerson, SalesTerritory
SalesOrderDetailID	int	4	NOT NULL	SalesOrderDetail
SalesOrderID	int	4	NOT NULL	SalesOrderHeader, SalesOrderHeaderSalesReason, SalesOrderDetail
SalesOrderNumber	nvarchar	25	NOT NULL	SalesOrderHeader
SalesPersonID	int	4	NOT NULL	SalesPersonQuotaHistory, SalesTerritoryHistory, Store, SalesPerson, SalesOrderHeader
SalesQuota	money	8	NULL	SalesPerson, SalesPersonQuotaHistory
SalesReasonID	int	4	NOT NULL	SalesReason, SalesOrderHeaderSalesReason
SalesTaxRateID	int	4	NOT NULL	SalesTaxRate
SalesYTD	money	8	NOT NULL	SalesPerson, SalesTerritory
ScheduledEndDate	datetime	8	NOT NULL	WorkOrderRouting
ScheduledStartDate	datetime	8	NOT NULL	WorkOrderRouting
Schema	sysname	128	NULL	DatabaseLog
ScrappedQty	smallint	2	NOT NULL	WorkOrder
ScrapReasonID	smallint	2	NULL	WorkOrder, ScrapReason
SellEndDate	datetime	8	NULL	Product
SellStartDate	datetime	8	NOT NULL	Product
Shelf	nvarchar	10	NOT NULL	ProductInventory
ShiftID	tinyint	1	NOT NULL	EmployeeDepartmentHistory, Shift
ShipBase	money	8	NOT NULL	ShipMethod
ShipDate	datetime	8	NULL	PurchaseOrderHeader, SalesOrderHeader
ShipMethodID	int	4	NOT NULL	ShipMethod, SalesOrderHeader, PurchaseOrderHeader
ShipRate	money	8	NOT NULL	ShipMethod
ShipToAddressID	int	4	NOT NULL	SalesOrderHeader
ShoppingCartID	nvarchar	50	NOT NULL	ShoppingCartItem
ShoppingCartItemID	int	4	NOT NULL	ShoppingCartItem
SickLeaveHours	smallint	2	NOT NULL	Employee
Size	nvarchar	5	NULL	Product
SizeUnitMeasureCode	nchar	3	NULL	Product
SpecialOfferID	int	4	NOT NULL	SpecialOfferProduct, SalesOrderDetail, SpecialOffer
StandardCost	money	8	NOT NULL	Product, ProductCostHistory
StandardPrice	money	8	NOT NULL	ProductVendor
StartDate	datetime	8	NOT NULL	BillOfMaterials, ProductCostHistory, EmployeeDepartmentHistory, ProductListPriceHistory, WorkOrder, SpecialOffer, SalesTerritoryHistory
StartTime	datetime	8	NOT NULL	Shift
StateProvinceCode	nchar	3	NOT NULL	StateProvince
StateProvinceID	int	4	NOT NULL	SalesTaxRate, StateProvince, Address
Status	tinyint	1	NOT NULL	PurchaseOrderHeader, SalesOrderHeader, Document
StockedQty	decimal	5	NOT NULL	PurchaseOrderDetail
StockedQty	int	4	NOT NULL	WorkOrder
Style	nchar	2	NULL	Product
SubTotal	money	8	NOT NULL	PurchaseOrderHeader, SalesOrderHeader
Suffix	nvarchar	10	NULL	Contact
SystemInformationID	tinyint	1	NOT NULL	AWBuildVersion
TaxAmt	money	8	NOT NULL	PurchaseOrderHeader, SalesOrderHeader
TaxRate	smallmoney	4	NOT NULL	SalesTaxRate
TaxType	tinyint	1	NOT NULL	SalesTaxRate
TerritoryID	int	4	NOT NULL	SalesTerritoryHistory, SalesPerson, Customer, SalesTerritory, StateProvince, SalesOrderHeader
ThumbNailPhoto	varbinary	-1	NULL	ProductPhoto
ThumbnailPhotoFileName	nvarchar	50	NULL	ProductPhoto
Title	nvarchar	8	NULL	Contact
Title	nvarchar	50	NOT NULL	Document, Employee
ToCurrencyCode	nchar	3	NOT NULL	CurrencyRate
TotalDue	money	8	NOT NULL	SalesOrderHeader, PurchaseOrderHeader
TransactionDate	datetime	8	NOT NULL	TransactionHistory, TransactionHistoryArchive
TransactionID	int	4	NOT NULL	TransactionHistoryArchive, TransactionHistory
TransactionType	nchar	1	NOT NULL	TransactionHistoryArchive, TransactionHistory
TSQL	nvarchar	-1	NOT NULL	DatabaseLog
Type	nvarchar	50	NOT NULL	SpecialOffer
UnitMeasureCode	nchar	3	NOT NULL	ProductVendor, UnitMeasure, BillOfMaterials
UnitPrice	money	8	NOT NULL	PurchaseOrderDetail, SalesOrderDetail
UnitPriceDiscount	money	8	NOT NULL	SalesOrderDetail
UserName	sysname	128	NOT NULL	ErrorLog
VacationHours	smallint	2	NOT NULL	Employee
VendorID	int	4	NOT NULL	VendorAddress, VendorContact, Vendor, PurchaseOrderHeader, ProductVendor
VersionDate	datetime	8	NOT NULL	AWBuildVersion
Weight	decimal	5	NULL	Product
WeightUnitMeasureCode	nchar	3	NULL	Product
WorkOrderID	int	4	NOT NULL	WorkOrder, WorkOrderRouting
XmlEvent		-1	NOT NULL	DatabaseLog