Table Columns
Fact	GeneralType	GeneralSchema	GeneralObject	column_id	GeneralColumn	SQLServerType	collation_name	is_nullable	is_identity	From	Plus	Used	PK_column_id	DefaultName	DefaultCode	FormulaCode
16	U	dbo	AWBuildVersion	1	SystemInformationID	tinyint		False	True	1	1	1	1
16	U	dbo	AWBuildVersion	2	Database Version	nvarchar(0025)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	dbo	AWBuildVersion	3	VersionDate	datetime		False	False	0	0	0	0
16	U	dbo	AWBuildVersion	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_AWBuildVersion_ModifiedDate	(getdate())
16	U	dbo	DatabaseLog	1	DatabaseLogID	int		False	True	1	1	1596	1
16	U	dbo	DatabaseLog	2	PostTime	datetime		False	False	0	0	0	0
16	U	dbo	DatabaseLog	3	DatabaseUser	sysname	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	dbo	DatabaseLog	4	Event	sysname	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	dbo	DatabaseLog	5	Schema	sysname	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	dbo	DatabaseLog	6	Object	sysname	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	dbo	DatabaseLog	7	TSQL	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	dbo	DatabaseLog	8	XmlEvent	xml		False	False	0	0	0	0
16	U	dbo	ErrorLog	1	ErrorLogID	int		False	True	1	1	1	1
16	U	dbo	ErrorLog	2	ErrorTime	datetime		False	False	0	0	0	0	DF_ErrorLog_ErrorTime	(getdate())
16	U	dbo	ErrorLog	3	UserName	sysname	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	dbo	ErrorLog	4	ErrorNumber	int		False	False	0	0	0	0
16	U	dbo	ErrorLog	5	ErrorSeverity	int		True	False	0	0	0	0
16	U	dbo	ErrorLog	6	ErrorState	int		True	False	0	0	0	0
16	U	dbo	ErrorLog	7	ErrorProcedure	nvarchar(0126)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	dbo	ErrorLog	8	ErrorLine	int		True	False	0	0	0	0
16	U	dbo	ErrorLog	9	ErrorMessage	nvarchar(4000)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	HumanResources	Department	1	DepartmentID	smallint		False	True	1	1	16	1
16	U	HumanResources	Department	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	HumanResources	Department	3	GroupName	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	HumanResources	Department	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_Department_ModifiedDate	(getdate())
16	U	HumanResources	Employee	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	HumanResources	Employee	2	NationalIDNumber	nvarchar(0015)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	HumanResources	Employee	3	LoginID	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	HumanResources	Employee	4	OrganizationNode	hierarchyid		True	False	0	0	0	0
16	U	HumanResources	Employee	5	OrganizationLevel	smallint		True	False	0	0	0	0			([OrganizationNode].[GetLevel]())
16	U	HumanResources	Employee	6	JobTitle	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	HumanResources	Employee	7	BirthDate	date		False	False	0	0	0	0
16	U	HumanResources	Employee	8	MaritalStatus	nchar(0001)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	HumanResources	Employee	9	Gender	nchar(0001)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	HumanResources	Employee	10	HireDate	date		False	False	0	0	0	0
16	U	HumanResources	Employee	11	SalariedFlag	Flag		False	False	0	0	0	0	DF_Employee_SalariedFlag	((1))
16	U	HumanResources	Employee	12	VacationHours	smallint		False	False	0	0	0	0	DF_Employee_VacationHours	((0))
16	U	HumanResources	Employee	13	SickLeaveHours	smallint		False	False	0	0	0	0	DF_Employee_SickLeaveHours	((0))
16	U	HumanResources	Employee	14	CurrentFlag	Flag		False	False	0	0	0	0	DF_Employee_CurrentFlag	((1))
16	U	HumanResources	Employee	15	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_Employee_rowguid	(newid())
16	U	HumanResources	Employee	16	ModifiedDate	datetime		False	False	0	0	0	0	DF_Employee_ModifiedDate	(getdate())
16	U	HumanResources	EmployeeDepartmentHistory	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	HumanResources	EmployeeDepartmentHistory	2	DepartmentID	smallint		False	False	0	0	0	2
16	U	HumanResources	EmployeeDepartmentHistory	3	ShiftID	tinyint		False	False	0	0	0	3
16	U	HumanResources	EmployeeDepartmentHistory	4	StartDate	date		False	False	0	0	0	4
16	U	HumanResources	EmployeeDepartmentHistory	5	EndDate	date		True	False	0	0	0	0
16	U	HumanResources	EmployeeDepartmentHistory	6	ModifiedDate	datetime		False	False	0	0	0	0	DF_EmployeeDepartmentHistory_ModifiedDate	(getdate())
16	U	HumanResources	EmployeePayHistory	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	HumanResources	EmployeePayHistory	2	RateChangeDate	datetime		False	False	0	0	0	2
16	U	HumanResources	EmployeePayHistory	3	Rate	money		False	False	0	0	0	0
16	U	HumanResources	EmployeePayHistory	4	PayFrequency	tinyint		False	False	0	0	0	0
16	U	HumanResources	EmployeePayHistory	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_EmployeePayHistory_ModifiedDate	(getdate())
16	U	HumanResources	JobCandidate	1	JobCandidateID	int		False	True	1	1	13	1
16	U	HumanResources	JobCandidate	2	BusinessEntityID	int		True	False	0	0	0	0
16	U	HumanResources	JobCandidate	3	Resume	xml		True	False	0	0	0	0
16	U	HumanResources	JobCandidate	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_JobCandidate_ModifiedDate	(getdate())
16	U	HumanResources	Shift	1	ShiftID	tinyint		False	True	1	1	3	1
16	U	HumanResources	Shift	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	HumanResources	Shift	3	StartTime	time(7)		False	False	0	0	0	0
16	U	HumanResources	Shift	4	EndTime	time(7)		False	False	0	0	0	0
16	U	HumanResources	Shift	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_Shift_ModifiedDate	(getdate())
16	U	Person	Address	1	AddressID	int		False	True	1	1	32521	1
16	U	Person	Address	2	AddressLine1	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	Address	3	AddressLine2	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Person	Address	4	City	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	Address	5	StateProvinceID	int		False	False	0	0	0	0
16	U	Person	Address	6	PostalCode	nvarchar(0015)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	Address	7	SpatialLocation	geography		True	False	0	0	0	0
16	U	Person	Address	8	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_Address_rowguid	(newid())
16	U	Person	Address	9	ModifiedDate	datetime		False	False	0	0	0	0	DF_Address_ModifiedDate	(getdate())
16	U	Person	AddressType	1	AddressTypeID	int		False	True	1	1	6	1
16	U	Person	AddressType	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	AddressType	3	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_AddressType_rowguid	(newid())
16	U	Person	AddressType	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_AddressType_ModifiedDate	(getdate())
16	U	Person	BusinessEntity	1	BusinessEntityID	int		False	True	1	1	20777	1
16	U	Person	BusinessEntity	2	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_BusinessEntity_rowguid	(newid())
16	U	Person	BusinessEntity	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_BusinessEntity_ModifiedDate	(getdate())
16	U	Person	BusinessEntityAddress	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Person	BusinessEntityAddress	2	AddressID	int		False	False	0	0	0	2
16	U	Person	BusinessEntityAddress	3	AddressTypeID	int		False	False	0	0	0	3
16	U	Person	BusinessEntityAddress	4	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_BusinessEntityAddress_rowguid	(newid())
16	U	Person	BusinessEntityAddress	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_BusinessEntityAddress_ModifiedDate	(getdate())
16	U	Person	BusinessEntityContact	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Person	BusinessEntityContact	2	PersonID	int		False	False	0	0	0	2
16	U	Person	BusinessEntityContact	3	ContactTypeID	int		False	False	0	0	0	3
16	U	Person	BusinessEntityContact	4	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_BusinessEntityContact_rowguid	(newid())
16	U	Person	BusinessEntityContact	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_BusinessEntityContact_ModifiedDate	(getdate())
16	U	Person	ContactType	1	ContactTypeID	int		False	True	1	1	20	1
16	U	Person	ContactType	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	ContactType	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_ContactType_ModifiedDate	(getdate())
16	U	Person	CountryRegion	1	CountryRegionCode	nvarchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	1
16	U	Person	CountryRegion	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	CountryRegion	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_CountryRegion_ModifiedDate	(getdate())
16	U	Person	EmailAddress	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Person	EmailAddress	2	EmailAddressID	int		False	True	1	1	19972	2
16	U	Person	EmailAddress	3	EmailAddress	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Person	EmailAddress	4	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_EmailAddress_rowguid	(newid())
16	U	Person	EmailAddress	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_EmailAddress_ModifiedDate	(getdate())
16	U	Person	Password	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Person	Password	2	PasswordHash	varchar(0128)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	Password	3	PasswordSalt	varchar(0010)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	Password	4	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_Password_rowguid	(newid())
16	U	Person	Password	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_Password_ModifiedDate	(getdate())
16	U	Person	Person	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Person	Person	2	PersonType	nchar(0002)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	Person	3	NameStyle	NameStyle		False	False	0	0	0	0	DF_Person_NameStyle	((0))
16	U	Person	Person	4	Title	nvarchar(0008)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Person	Person	5	FirstName	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	Person	6	MiddleName	Name	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Person	Person	7	LastName	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	Person	8	Suffix	nvarchar(0010)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Person	Person	9	EmailPromotion	int		False	False	0	0	0	0	DF_Person_EmailPromotion	((0))
16	U	Person	Person	10	AdditionalContactInfo	xml		True	False	0	0	0	0
16	U	Person	Person	11	Demographics	xml		True	False	0	0	0	0
16	U	Person	Person	12	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_Person_rowguid	(newid())
16	U	Person	Person	13	ModifiedDate	datetime		False	False	0	0	0	0	DF_Person_ModifiedDate	(getdate())
16	U	Person	PersonPhone	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Person	PersonPhone	2	PhoneNumber	Phone	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	2
16	U	Person	PersonPhone	3	PhoneNumberTypeID	int		False	False	0	0	0	3
16	U	Person	PersonPhone	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_PersonPhone_ModifiedDate	(getdate())
16	U	Person	PhoneNumberType	1	PhoneNumberTypeID	int		False	True	1	1	3	1
16	U	Person	PhoneNumberType	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	PhoneNumberType	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_PhoneNumberType_ModifiedDate	(getdate())
16	U	Person	StateProvince	1	StateProvinceID	int		False	True	1	1	181	1
16	U	Person	StateProvince	2	StateProvinceCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	StateProvince	3	CountryRegionCode	nvarchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	StateProvince	4	IsOnlyStateProvinceFlag	Flag		False	False	0	0	0	0	DF_StateProvince_IsOnlyStateProvinceFlag	((1))
16	U	Person	StateProvince	5	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Person	StateProvince	6	TerritoryID	int		False	False	0	0	0	0
16	U	Person	StateProvince	7	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_StateProvince_rowguid	(newid())
16	U	Person	StateProvince	8	ModifiedDate	datetime		False	False	0	0	0	0	DF_StateProvince_ModifiedDate	(getdate())
16	U	Production	BillOfMaterials	1	BillOfMaterialsID	int		False	True	1	1	3482	1
16	U	Production	BillOfMaterials	2	ProductAssemblyID	int		True	False	0	0	0	0
16	U	Production	BillOfMaterials	3	ComponentID	int		False	False	0	0	0	0
16	U	Production	BillOfMaterials	4	StartDate	datetime		False	False	0	0	0	0	DF_BillOfMaterials_StartDate	(getdate())
16	U	Production	BillOfMaterials	5	EndDate	datetime		True	False	0	0	0	0
16	U	Production	BillOfMaterials	6	UnitMeasureCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	BillOfMaterials	7	BOMLevel	smallint		False	False	0	0	0	0
16	U	Production	BillOfMaterials	8	PerAssemblyQty	decimal(08,02)		False	False	0	0	0	0	DF_BillOfMaterials_PerAssemblyQty	((1.00))
16	U	Production	BillOfMaterials	9	ModifiedDate	datetime		False	False	0	0	0	0	DF_BillOfMaterials_ModifiedDate	(getdate())
16	U	Production	Culture	1	CultureID	nchar(0006)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	1
16	U	Production	Culture	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	Culture	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_Culture_ModifiedDate	(getdate())
16	U	Production	Document	1	DocumentNode	hierarchyid		False	False	0	0	0	1
16	U	Production	Document	2	DocumentLevel	smallint		True	False	0	0	0	0			([DocumentNode].[GetLevel]())
16	U	Production	Document	3	Title	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	Document	4	Owner	int		False	False	0	0	0	0
16	U	Production	Document	5	FolderFlag	bit		False	False	0	0	0	0	DF_Document_FolderFlag	((0))
16	U	Production	Document	6	FileName	nvarchar(0400)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	Document	7	FileExtension	nvarchar(0008)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	Document	8	Revision	nchar(0005)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	Document	9	ChangeNumber	int		False	False	0	0	0	0	DF_Document_ChangeNumber	((0))
16	U	Production	Document	10	Status	tinyint		False	False	0	0	0	0
16	U	Production	Document	11	DocumentSummary	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	Document	12	Document	varbinary(max )		True	False	0	0	0	0
16	U	Production	Document	13	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_Document_rowguid	(newid())
16	U	Production	Document	14	ModifiedDate	datetime		False	False	0	0	0	0	DF_Document_ModifiedDate	(getdate())
16	U	Production	Illustration	1	IllustrationID	int		False	True	1	1	7	1
16	U	Production	Illustration	2	Diagram	xml		True	False	0	0	0	0
16	U	Production	Illustration	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_Illustration_ModifiedDate	(getdate())
16	U	Production	Location	1	LocationID	smallint		False	True	1	1	60	1
16	U	Production	Location	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	Location	3	CostRate	smallmoney		False	False	0	0	0	0	DF_Location_CostRate	((0.00))
16	U	Production	Location	4	Availability	decimal(08,02)		False	False	0	0	0	0	DF_Location_Availability	((0.00))
16	U	Production	Location	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_Location_ModifiedDate	(getdate())
16	U	Production	Product	1	ProductID	int		False	True	1	1	999	1
16	U	Production	Product	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	Product	3	ProductNumber	nvarchar(0025)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	Product	4	MakeFlag	Flag		False	False	0	0	0	0	DF_Product_MakeFlag	((1))
16	U	Production	Product	5	FinishedGoodsFlag	Flag		False	False	0	0	0	0	DF_Product_FinishedGoodsFlag	((1))
16	U	Production	Product	6	Color	nvarchar(0015)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	Product	7	SafetyStockLevel	smallint		False	False	0	0	0	0
16	U	Production	Product	8	ReorderPoint	smallint		False	False	0	0	0	0
16	U	Production	Product	9	StandardCost	money		False	False	0	0	0	0
16	U	Production	Product	10	ListPrice	money		False	False	0	0	0	0
16	U	Production	Product	11	Size	nvarchar(0005)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	Product	12	SizeUnitMeasureCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	Product	13	WeightUnitMeasureCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	Product	14	Weight	decimal(08,02)		True	False	0	0	0	0
16	U	Production	Product	15	DaysToManufacture	int		False	False	0	0	0	0
16	U	Production	Product	16	ProductLine	nchar(0002)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	Product	17	Class	nchar(0002)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	Product	18	Style	nchar(0002)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	Product	19	ProductSubcategoryID	int		True	False	0	0	0	0
16	U	Production	Product	20	ProductModelID	int		True	False	0	0	0	0
16	U	Production	Product	21	SellStartDate	datetime		False	False	0	0	0	0
16	U	Production	Product	22	SellEndDate	datetime		True	False	0	0	0	0
16	U	Production	Product	23	DiscontinuedDate	datetime		True	False	0	0	0	0
16	U	Production	Product	24	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_Product_rowguid	(newid())
16	U	Production	Product	25	ModifiedDate	datetime		False	False	0	0	0	0	DF_Product_ModifiedDate	(getdate())
16	U	Production	ProductCategory	1	ProductCategoryID	int		False	True	1	1	4	1
16	U	Production	ProductCategory	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	ProductCategory	3	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_ProductCategory_rowguid	(newid())
16	U	Production	ProductCategory	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductCategory_ModifiedDate	(getdate())
16	U	Production	ProductCostHistory	1	ProductID	int		False	False	0	0	0	1
16	U	Production	ProductCostHistory	2	StartDate	datetime		False	False	0	0	0	2
16	U	Production	ProductCostHistory	3	EndDate	datetime		True	False	0	0	0	0
16	U	Production	ProductCostHistory	4	StandardCost	money		False	False	0	0	0	0
16	U	Production	ProductCostHistory	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductCostHistory_ModifiedDate	(getdate())
16	U	Production	ProductDescription	1	ProductDescriptionID	int		False	True	1	1	2010	1
16	U	Production	ProductDescription	2	Description	nvarchar(0400)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	ProductDescription	3	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_ProductDescription_rowguid	(newid())
16	U	Production	ProductDescription	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductDescription_ModifiedDate	(getdate())
16	U	Production	ProductDocument	1	ProductID	int		False	False	0	0	0	1
16	U	Production	ProductDocument	2	DocumentNode	hierarchyid		False	False	0	0	0	2
16	U	Production	ProductDocument	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductDocument_ModifiedDate	(getdate())
16	U	Production	ProductInventory	1	ProductID	int		False	False	0	0	0	1
16	U	Production	ProductInventory	2	LocationID	smallint		False	False	0	0	0	2
16	U	Production	ProductInventory	3	Shelf	nvarchar(0010)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	ProductInventory	4	Bin	tinyint		False	False	0	0	0	0
16	U	Production	ProductInventory	5	Quantity	smallint		False	False	0	0	0	0	DF_ProductInventory_Quantity	((0))
16	U	Production	ProductInventory	6	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_ProductInventory_rowguid	(newid())
16	U	Production	ProductInventory	7	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductInventory_ModifiedDate	(getdate())
16	U	Production	ProductListPriceHistory	1	ProductID	int		False	False	0	0	0	1
16	U	Production	ProductListPriceHistory	2	StartDate	datetime		False	False	0	0	0	2
16	U	Production	ProductListPriceHistory	3	EndDate	datetime		True	False	0	0	0	0
16	U	Production	ProductListPriceHistory	4	ListPrice	money		False	False	0	0	0	0
16	U	Production	ProductListPriceHistory	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductListPriceHistory_ModifiedDate	(getdate())
16	U	Production	ProductModel	1	ProductModelID	int		False	True	1	1	128	1
16	U	Production	ProductModel	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	ProductModel	3	CatalogDescription	xml		True	False	0	0	0	0
16	U	Production	ProductModel	4	Instructions	xml		True	False	0	0	0	0
16	U	Production	ProductModel	5	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_ProductModel_rowguid	(newid())
16	U	Production	ProductModel	6	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductModel_ModifiedDate	(getdate())
16	U	Production	ProductModelIllustration	1	ProductModelID	int		False	False	0	0	0	1
16	U	Production	ProductModelIllustration	2	IllustrationID	int		False	False	0	0	0	2
16	U	Production	ProductModelIllustration	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductModelIllustration_ModifiedDate	(getdate())
16	U	Production	ProductModelProductDescriptionCulture	1	ProductModelID	int		False	False	0	0	0	1
16	U	Production	ProductModelProductDescriptionCulture	2	ProductDescriptionID	int		False	False	0	0	0	2
16	U	Production	ProductModelProductDescriptionCulture	3	CultureID	nchar(0006)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	3
16	U	Production	ProductModelProductDescriptionCulture	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductModelProductDescriptionCulture_ModifiedDate	(getdate())
16	U	Production	ProductPhoto	1	ProductPhotoID	int		False	True	1	1	181	1
16	U	Production	ProductPhoto	2	ThumbNailPhoto	varbinary(max )		True	False	0	0	0	0
16	U	Production	ProductPhoto	3	ThumbnailPhotoFileName	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	ProductPhoto	4	LargePhoto	varbinary(max )		True	False	0	0	0	0
16	U	Production	ProductPhoto	5	LargePhotoFileName	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	ProductPhoto	6	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductPhoto_ModifiedDate	(getdate())
16	U	Production	ProductProductPhoto	1	ProductID	int		False	False	0	0	0	1
16	U	Production	ProductProductPhoto	2	ProductPhotoID	int		False	False	0	0	0	2
16	U	Production	ProductProductPhoto	3	Primary	Flag		False	False	0	0	0	0	DF_ProductProductPhoto_Primary	((0))
16	U	Production	ProductProductPhoto	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductProductPhoto_ModifiedDate	(getdate())
16	U	Production	ProductReview	1	ProductReviewID	int		False	True	1	1	4	1
16	U	Production	ProductReview	2	ProductID	int		False	False	0	0	0	0
16	U	Production	ProductReview	3	ReviewerName	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	ProductReview	4	ReviewDate	datetime		False	False	0	0	0	0	DF_ProductReview_ReviewDate	(getdate())
16	U	Production	ProductReview	5	EmailAddress	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	ProductReview	6	Rating	int		False	False	0	0	0	0
16	U	Production	ProductReview	7	Comments	nvarchar(3850)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Production	ProductReview	8	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductReview_ModifiedDate	(getdate())
16	U	Production	ProductSubcategory	1	ProductSubcategoryID	int		False	True	1	1	37	1
16	U	Production	ProductSubcategory	2	ProductCategoryID	int		False	False	0	0	0	0
16	U	Production	ProductSubcategory	3	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	ProductSubcategory	4	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_ProductSubcategory_rowguid	(newid())
16	U	Production	ProductSubcategory	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductSubcategory_ModifiedDate	(getdate())
16	U	Production	ScrapReason	1	ScrapReasonID	smallint		False	True	1	1	16	1
16	U	Production	ScrapReason	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	ScrapReason	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_ScrapReason_ModifiedDate	(getdate())
16	U	Production	TransactionHistory	1	TransactionID	int		False	True	100000	1	213442	1
16	U	Production	TransactionHistory	2	ProductID	int		False	False	0	0	0	0
16	U	Production	TransactionHistory	3	ReferenceOrderID	int		False	False	0	0	0	0
16	U	Production	TransactionHistory	4	ReferenceOrderLineID	int		False	False	0	0	0	0	DF_TransactionHistory_ReferenceOrderLineID	((0))
16	U	Production	TransactionHistory	5	TransactionDate	datetime		False	False	0	0	0	0	DF_TransactionHistory_TransactionDate	(getdate())
16	U	Production	TransactionHistory	6	TransactionType	nchar(0001)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	TransactionHistory	7	Quantity	int		False	False	0	0	0	0
16	U	Production	TransactionHistory	8	ActualCost	money		False	False	0	0	0	0
16	U	Production	TransactionHistory	9	ModifiedDate	datetime		False	False	0	0	0	0	DF_TransactionHistory_ModifiedDate	(getdate())
16	U	Production	TransactionHistoryArchive	1	TransactionID	int		False	False	0	0	0	1
16	U	Production	TransactionHistoryArchive	2	ProductID	int		False	False	0	0	0	0
16	U	Production	TransactionHistoryArchive	3	ReferenceOrderID	int		False	False	0	0	0	0
16	U	Production	TransactionHistoryArchive	4	ReferenceOrderLineID	int		False	False	0	0	0	0	DF_TransactionHistoryArchive_ReferenceOrderLineID	((0))
16	U	Production	TransactionHistoryArchive	5	TransactionDate	datetime		False	False	0	0	0	0	DF_TransactionHistoryArchive_TransactionDate	(getdate())
16	U	Production	TransactionHistoryArchive	6	TransactionType	nchar(0001)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	TransactionHistoryArchive	7	Quantity	int		False	False	0	0	0	0
16	U	Production	TransactionHistoryArchive	8	ActualCost	money		False	False	0	0	0	0
16	U	Production	TransactionHistoryArchive	9	ModifiedDate	datetime		False	False	0	0	0	0	DF_TransactionHistoryArchive_ModifiedDate	(getdate())
16	U	Production	UnitMeasure	1	UnitMeasureCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	1
16	U	Production	UnitMeasure	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Production	UnitMeasure	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_UnitMeasure_ModifiedDate	(getdate())
16	U	Production	WorkOrder	1	WorkOrderID	int		False	True	1	1	72591	1
16	U	Production	WorkOrder	2	ProductID	int		False	False	0	0	0	0
16	U	Production	WorkOrder	3	OrderQty	int		False	False	0	0	0	0
16	U	Production	WorkOrder	4	StockedQty	int		False	False	0	0	0	0			(isnull([OrderQty]-[ScrappedQty],(0)))
16	U	Production	WorkOrder	5	ScrappedQty	smallint		False	False	0	0	0	0
16	U	Production	WorkOrder	6	StartDate	datetime		False	False	0	0	0	0
16	U	Production	WorkOrder	7	EndDate	datetime		True	False	0	0	0	0
16	U	Production	WorkOrder	8	DueDate	datetime		False	False	0	0	0	0
16	U	Production	WorkOrder	9	ScrapReasonID	smallint		True	False	0	0	0	0
16	U	Production	WorkOrder	10	ModifiedDate	datetime		False	False	0	0	0	0	DF_WorkOrder_ModifiedDate	(getdate())
16	U	Production	WorkOrderRouting	1	WorkOrderID	int		False	False	0	0	0	1
16	U	Production	WorkOrderRouting	2	ProductID	int		False	False	0	0	0	2
16	U	Production	WorkOrderRouting	3	OperationSequence	smallint		False	False	0	0	0	3
16	U	Production	WorkOrderRouting	4	LocationID	smallint		False	False	0	0	0	0
16	U	Production	WorkOrderRouting	5	ScheduledStartDate	datetime		False	False	0	0	0	0
16	U	Production	WorkOrderRouting	6	ScheduledEndDate	datetime		False	False	0	0	0	0
16	U	Production	WorkOrderRouting	7	ActualStartDate	datetime		True	False	0	0	0	0
16	U	Production	WorkOrderRouting	8	ActualEndDate	datetime		True	False	0	0	0	0
16	U	Production	WorkOrderRouting	9	ActualResourceHrs	decimal(09,04)		True	False	0	0	0	0
16	U	Production	WorkOrderRouting	10	PlannedCost	money		False	False	0	0	0	0
16	U	Production	WorkOrderRouting	11	ActualCost	money		True	False	0	0	0	0
16	U	Production	WorkOrderRouting	12	ModifiedDate	datetime		False	False	0	0	0	0	DF_WorkOrderRouting_ModifiedDate	(getdate())
16	U	Purchasing	ProductVendor	1	ProductID	int		False	False	0	0	0	1
16	U	Purchasing	ProductVendor	2	BusinessEntityID	int		False	False	0	0	0	2
16	U	Purchasing	ProductVendor	3	AverageLeadTime	int		False	False	0	0	0	0
16	U	Purchasing	ProductVendor	4	StandardPrice	money		False	False	0	0	0	0
16	U	Purchasing	ProductVendor	5	LastReceiptCost	money		True	False	0	0	0	0
16	U	Purchasing	ProductVendor	6	LastReceiptDate	datetime		True	False	0	0	0	0
16	U	Purchasing	ProductVendor	7	MinOrderQty	int		False	False	0	0	0	0
16	U	Purchasing	ProductVendor	8	MaxOrderQty	int		False	False	0	0	0	0
16	U	Purchasing	ProductVendor	9	OnOrderQty	int		True	False	0	0	0	0
16	U	Purchasing	ProductVendor	10	UnitMeasureCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Purchasing	ProductVendor	11	ModifiedDate	datetime		False	False	0	0	0	0	DF_ProductVendor_ModifiedDate	(getdate())
16	U	Purchasing	PurchaseOrderDetail	1	PurchaseOrderID	int		False	False	0	0	0	1
16	U	Purchasing	PurchaseOrderDetail	2	PurchaseOrderDetailID	int		False	True	1	1	8845	2
16	U	Purchasing	PurchaseOrderDetail	3	DueDate	datetime		False	False	0	0	0	0
16	U	Purchasing	PurchaseOrderDetail	4	OrderQty	smallint		False	False	0	0	0	0
16	U	Purchasing	PurchaseOrderDetail	5	ProductID	int		False	False	0	0	0	0
16	U	Purchasing	PurchaseOrderDetail	6	UnitPrice	money		False	False	0	0	0	0
16	U	Purchasing	PurchaseOrderDetail	7	LineTotal	money		False	False	0	0	0	0			(isnull([OrderQty]*[UnitPrice],(0.00)))
16	U	Purchasing	PurchaseOrderDetail	8	ReceivedQty	decimal(08,02)		False	False	0	0	0	0
16	U	Purchasing	PurchaseOrderDetail	9	RejectedQty	decimal(08,02)		False	False	0	0	0	0
16	U	Purchasing	PurchaseOrderDetail	10	StockedQty	decimal(09,02)		False	False	0	0	0	0			(isnull([ReceivedQty]-[RejectedQty],(0.00)))
16	U	Purchasing	PurchaseOrderDetail	11	ModifiedDate	datetime		False	False	0	0	0	0	DF_PurchaseOrderDetail_ModifiedDate	(getdate())
16	U	Purchasing	PurchaseOrderHeader	1	PurchaseOrderID	int		False	True	1	1	4012	1
16	U	Purchasing	PurchaseOrderHeader	2	RevisionNumber	tinyint		False	False	0	0	0	0	DF_PurchaseOrderHeader_RevisionNumber	((0))
16	U	Purchasing	PurchaseOrderHeader	3	Status	tinyint		False	False	0	0	0	0	DF_PurchaseOrderHeader_Status	((1))
16	U	Purchasing	PurchaseOrderHeader	4	EmployeeID	int		False	False	0	0	0	0
16	U	Purchasing	PurchaseOrderHeader	5	VendorID	int		False	False	0	0	0	0
16	U	Purchasing	PurchaseOrderHeader	6	ShipMethodID	int		False	False	0	0	0	0
16	U	Purchasing	PurchaseOrderHeader	7	OrderDate	datetime		False	False	0	0	0	0	DF_PurchaseOrderHeader_OrderDate	(getdate())
16	U	Purchasing	PurchaseOrderHeader	8	ShipDate	datetime		True	False	0	0	0	0
16	U	Purchasing	PurchaseOrderHeader	9	SubTotal	money		False	False	0	0	0	0	DF_PurchaseOrderHeader_SubTotal	((0.00))
16	U	Purchasing	PurchaseOrderHeader	10	TaxAmt	money		False	False	0	0	0	0	DF_PurchaseOrderHeader_TaxAmt	((0.00))
16	U	Purchasing	PurchaseOrderHeader	11	Freight	money		False	False	0	0	0	0	DF_PurchaseOrderHeader_Freight	((0.00))
16	U	Purchasing	PurchaseOrderHeader	12	TotalDue	money		False	False	0	0	0	0			(isnull(([SubTotal]+[TaxAmt])+[Freight],(0)))
16	U	Purchasing	PurchaseOrderHeader	13	ModifiedDate	datetime		False	False	0	0	0	0	DF_PurchaseOrderHeader_ModifiedDate	(getdate())
16	U	Purchasing	ShipMethod	1	ShipMethodID	int		False	True	1	1	5	1
16	U	Purchasing	ShipMethod	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Purchasing	ShipMethod	3	ShipBase	money		False	False	0	0	0	0	DF_ShipMethod_ShipBase	((0.00))
16	U	Purchasing	ShipMethod	4	ShipRate	money		False	False	0	0	0	0	DF_ShipMethod_ShipRate	((0.00))
16	U	Purchasing	ShipMethod	5	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_ShipMethod_rowguid	(newid())
16	U	Purchasing	ShipMethod	6	ModifiedDate	datetime		False	False	0	0	0	0	DF_ShipMethod_ModifiedDate	(getdate())
16	U	Purchasing	Vendor	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Purchasing	Vendor	2	AccountNumber	AccountNumber	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Purchasing	Vendor	3	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Purchasing	Vendor	4	CreditRating	tinyint		False	False	0	0	0	0
16	U	Purchasing	Vendor	5	PreferredVendorStatus	Flag		False	False	0	0	0	0	DF_Vendor_PreferredVendorStatus	((1))
16	U	Purchasing	Vendor	6	ActiveFlag	Flag		False	False	0	0	0	0	DF_Vendor_ActiveFlag	((1))
16	U	Purchasing	Vendor	7	PurchasingWebServiceURL	nvarchar(1024)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Purchasing	Vendor	8	ModifiedDate	datetime		False	False	0	0	0	0	DF_Vendor_ModifiedDate	(getdate())
16	U	Sales	CountryRegionCurrency	1	CountryRegionCode	nvarchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	1
16	U	Sales	CountryRegionCurrency	2	CurrencyCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	2
16	U	Sales	CountryRegionCurrency	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_CountryRegionCurrency_ModifiedDate	(getdate())
16	U	Sales	CreditCard	1	CreditCardID	int		False	True	1	1	19237	1
16	U	Sales	CreditCard	2	CardType	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	CreditCard	3	CardNumber	nvarchar(0025)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	CreditCard	4	ExpMonth	tinyint		False	False	0	0	0	0
16	U	Sales	CreditCard	5	ExpYear	smallint		False	False	0	0	0	0
16	U	Sales	CreditCard	6	ModifiedDate	datetime		False	False	0	0	0	0	DF_CreditCard_ModifiedDate	(getdate())
16	U	Sales	Currency	1	CurrencyCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	1
16	U	Sales	Currency	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	Currency	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_Currency_ModifiedDate	(getdate())
16	U	Sales	CurrencyRate	1	CurrencyRateID	int		False	True	1	1	13532	1
16	U	Sales	CurrencyRate	2	CurrencyRateDate	datetime		False	False	0	0	0	0
16	U	Sales	CurrencyRate	3	FromCurrencyCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	CurrencyRate	4	ToCurrencyCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	CurrencyRate	5	AverageRate	money		False	False	0	0	0	0
16	U	Sales	CurrencyRate	6	EndOfDayRate	money		False	False	0	0	0	0
16	U	Sales	CurrencyRate	7	ModifiedDate	datetime		False	False	0	0	0	0	DF_CurrencyRate_ModifiedDate	(getdate())
16	U	Sales	Customer	1	CustomerID	int		False	True	1	1	30118	1
16	U	Sales	Customer	2	PersonID	int		True	False	0	0	0	0
16	U	Sales	Customer	3	StoreID	int		True	False	0	0	0	0
16	U	Sales	Customer	4	TerritoryID	int		True	False	0	0	0	0
16	U	Sales	Customer	5	AccountNumber	varchar(0010)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0			(isnull('AW'+[dbo].[ufnLeadingZeros]([CustomerID]),''))
16	U	Sales	Customer	6	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_Customer_rowguid	(newid())
16	U	Sales	Customer	7	ModifiedDate	datetime		False	False	0	0	0	0	DF_Customer_ModifiedDate	(getdate())
16	U	Sales	PersonCreditCard	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Sales	PersonCreditCard	2	CreditCardID	int		False	False	0	0	0	2
16	U	Sales	PersonCreditCard	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_PersonCreditCard_ModifiedDate	(getdate())
16	U	Sales	SalesOrderDetail	1	SalesOrderID	int		False	False	0	0	0	1
16	U	Sales	SalesOrderDetail	2	SalesOrderDetailID	int		False	True	1	1	121317	2
16	U	Sales	SalesOrderDetail	3	CarrierTrackingNumber	nvarchar(0025)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Sales	SalesOrderDetail	4	OrderQty	smallint		False	False	0	0	0	0
16	U	Sales	SalesOrderDetail	5	ProductID	int		False	False	0	0	0	0
16	U	Sales	SalesOrderDetail	6	SpecialOfferID	int		False	False	0	0	0	0
16	U	Sales	SalesOrderDetail	7	UnitPrice	money		False	False	0	0	0	0
16	U	Sales	SalesOrderDetail	8	UnitPriceDiscount	money		False	False	0	0	0	0	DF_SalesOrderDetail_UnitPriceDiscount	((0.0))
16	U	Sales	SalesOrderDetail	9	LineTotal	numeric(38,06)		False	False	0	0	0	0			(isnull(([UnitPrice]*((1.0)-[UnitPriceDiscount]))*[OrderQty],(0.0)))
16	U	Sales	SalesOrderDetail	10	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_SalesOrderDetail_rowguid	(newid())
16	U	Sales	SalesOrderDetail	11	ModifiedDate	datetime		False	False	0	0	0	0	DF_SalesOrderDetail_ModifiedDate	(getdate())
16	U	Sales	SalesOrderHeader	1	SalesOrderID	int		False	True	1	1	75123	1
16	U	Sales	SalesOrderHeader	2	RevisionNumber	tinyint		False	False	0	0	0	0	DF_SalesOrderHeader_RevisionNumber	((0))
16	U	Sales	SalesOrderHeader	3	OrderDate	datetime		False	False	0	0	0	0	DF_SalesOrderHeader_OrderDate	(getdate())
16	U	Sales	SalesOrderHeader	4	DueDate	datetime		False	False	0	0	0	0
16	U	Sales	SalesOrderHeader	5	ShipDate	datetime		True	False	0	0	0	0
16	U	Sales	SalesOrderHeader	6	Status	tinyint		False	False	0	0	0	0	DF_SalesOrderHeader_Status	((1))
16	U	Sales	SalesOrderHeader	7	OnlineOrderFlag	Flag		False	False	0	0	0	0	DF_SalesOrderHeader_OnlineOrderFlag	((1))
16	U	Sales	SalesOrderHeader	8	SalesOrderNumber	nvarchar(0025)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0			(isnull(N'SO'+CONVERT([nvarchar](23),[SalesOrderID]),N'*** ERROR ***'))
16	U	Sales	SalesOrderHeader	9	PurchaseOrderNumber	OrderNumber	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Sales	SalesOrderHeader	10	AccountNumber	AccountNumber	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Sales	SalesOrderHeader	11	CustomerID	int		False	False	0	0	0	0
16	U	Sales	SalesOrderHeader	12	SalesPersonID	int		True	False	0	0	0	0
16	U	Sales	SalesOrderHeader	13	TerritoryID	int		True	False	0	0	0	0
16	U	Sales	SalesOrderHeader	14	BillToAddressID	int		False	False	0	0	0	0
16	U	Sales	SalesOrderHeader	15	ShipToAddressID	int		False	False	0	0	0	0
16	U	Sales	SalesOrderHeader	16	ShipMethodID	int		False	False	0	0	0	0
16	U	Sales	SalesOrderHeader	17	CreditCardID	int		True	False	0	0	0	0
16	U	Sales	SalesOrderHeader	18	CreditCardApprovalCode	varchar(0015)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Sales	SalesOrderHeader	19	CurrencyRateID	int		True	False	0	0	0	0
16	U	Sales	SalesOrderHeader	20	SubTotal	money		False	False	0	0	0	0	DF_SalesOrderHeader_SubTotal	((0.00))
16	U	Sales	SalesOrderHeader	21	TaxAmt	money		False	False	0	0	0	0	DF_SalesOrderHeader_TaxAmt	((0.00))
16	U	Sales	SalesOrderHeader	22	Freight	money		False	False	0	0	0	0	DF_SalesOrderHeader_Freight	((0.00))
16	U	Sales	SalesOrderHeader	23	TotalDue	money		False	False	0	0	0	0			(isnull(([SubTotal]+[TaxAmt])+[Freight],(0)))
16	U	Sales	SalesOrderHeader	24	Comment	nvarchar(0128)	SQL_Latin1_General_CP1_CI_AS	True	False	0	0	0	0
16	U	Sales	SalesOrderHeader	25	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_SalesOrderHeader_rowguid	(newid())
16	U	Sales	SalesOrderHeader	26	ModifiedDate	datetime		False	False	0	0	0	0	DF_SalesOrderHeader_ModifiedDate	(getdate())
16	U	Sales	SalesOrderHeaderSalesReason	1	SalesOrderID	int		False	False	0	0	0	1
16	U	Sales	SalesOrderHeaderSalesReason	2	SalesReasonID	int		False	False	0	0	0	2
16	U	Sales	SalesOrderHeaderSalesReason	3	ModifiedDate	datetime		False	False	0	0	0	0	DF_SalesOrderHeaderSalesReason_ModifiedDate	(getdate())
16	U	Sales	SalesPerson	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Sales	SalesPerson	2	TerritoryID	int		True	False	0	0	0	0
16	U	Sales	SalesPerson	3	SalesQuota	money		True	False	0	0	0	0
16	U	Sales	SalesPerson	4	Bonus	money		False	False	0	0	0	0	DF_SalesPerson_Bonus	((0.00))
16	U	Sales	SalesPerson	5	CommissionPct	smallmoney		False	False	0	0	0	0	DF_SalesPerson_CommissionPct	((0.00))
16	U	Sales	SalesPerson	6	SalesYTD	money		False	False	0	0	0	0	DF_SalesPerson_SalesYTD	((0.00))
16	U	Sales	SalesPerson	7	SalesLastYear	money		False	False	0	0	0	0	DF_SalesPerson_SalesLastYear	((0.00))
16	U	Sales	SalesPerson	8	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_SalesPerson_rowguid	(newid())
16	U	Sales	SalesPerson	9	ModifiedDate	datetime		False	False	0	0	0	0	DF_SalesPerson_ModifiedDate	(getdate())
16	U	Sales	SalesPersonQuotaHistory	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Sales	SalesPersonQuotaHistory	2	QuotaDate	datetime		False	False	0	0	0	2
16	U	Sales	SalesPersonQuotaHistory	3	SalesQuota	money		False	False	0	0	0	0
16	U	Sales	SalesPersonQuotaHistory	4	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_SalesPersonQuotaHistory_rowguid	(newid())
16	U	Sales	SalesPersonQuotaHistory	5	ModifiedDate	datetime		False	False	0	0	0	0	DF_SalesPersonQuotaHistory_ModifiedDate	(getdate())
16	U	Sales	SalesReason	1	SalesReasonID	int		False	True	1	1	10	1
16	U	Sales	SalesReason	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	SalesReason	3	ReasonType	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	SalesReason	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_SalesReason_ModifiedDate	(getdate())
16	U	Sales	SalesTaxRate	1	SalesTaxRateID	int		False	True	1	1	31	1
16	U	Sales	SalesTaxRate	2	StateProvinceID	int		False	False	0	0	0	0
16	U	Sales	SalesTaxRate	3	TaxType	tinyint		False	False	0	0	0	0
16	U	Sales	SalesTaxRate	4	TaxRate	smallmoney		False	False	0	0	0	0	DF_SalesTaxRate_TaxRate	((0.00))
16	U	Sales	SalesTaxRate	5	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	SalesTaxRate	6	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_SalesTaxRate_rowguid	(newid())
16	U	Sales	SalesTaxRate	7	ModifiedDate	datetime		False	False	0	0	0	0	DF_SalesTaxRate_ModifiedDate	(getdate())
16	U	Sales	SalesTerritory	1	TerritoryID	int		False	True	1	1	10	1
16	U	Sales	SalesTerritory	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	SalesTerritory	3	CountryRegionCode	nvarchar(0003)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	SalesTerritory	4	Group	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	SalesTerritory	5	SalesYTD	money		False	False	0	0	0	0	DF_SalesTerritory_SalesYTD	((0.00))
16	U	Sales	SalesTerritory	6	SalesLastYear	money		False	False	0	0	0	0	DF_SalesTerritory_SalesLastYear	((0.00))
16	U	Sales	SalesTerritory	7	CostYTD	money		False	False	0	0	0	0	DF_SalesTerritory_CostYTD	((0.00))
16	U	Sales	SalesTerritory	8	CostLastYear	money		False	False	0	0	0	0	DF_SalesTerritory_CostLastYear	((0.00))
16	U	Sales	SalesTerritory	9	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_SalesTerritory_rowguid	(newid())
16	U	Sales	SalesTerritory	10	ModifiedDate	datetime		False	False	0	0	0	0	DF_SalesTerritory_ModifiedDate	(getdate())
16	U	Sales	SalesTerritoryHistory	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Sales	SalesTerritoryHistory	2	TerritoryID	int		False	False	0	0	0	2
16	U	Sales	SalesTerritoryHistory	3	StartDate	datetime		False	False	0	0	0	3
16	U	Sales	SalesTerritoryHistory	4	EndDate	datetime		True	False	0	0	0	0
16	U	Sales	SalesTerritoryHistory	5	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_SalesTerritoryHistory_rowguid	(newid())
16	U	Sales	SalesTerritoryHistory	6	ModifiedDate	datetime		False	False	0	0	0	0	DF_SalesTerritoryHistory_ModifiedDate	(getdate())
16	U	Sales	ShoppingCartItem	1	ShoppingCartItemID	int		False	True	1	1	5	1
16	U	Sales	ShoppingCartItem	2	ShoppingCartID	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	ShoppingCartItem	3	Quantity	int		False	False	0	0	0	0	DF_ShoppingCartItem_Quantity	((1))
16	U	Sales	ShoppingCartItem	4	ProductID	int		False	False	0	0	0	0
16	U	Sales	ShoppingCartItem	5	DateCreated	datetime		False	False	0	0	0	0	DF_ShoppingCartItem_DateCreated	(getdate())
16	U	Sales	ShoppingCartItem	6	ModifiedDate	datetime		False	False	0	0	0	0	DF_ShoppingCartItem_ModifiedDate	(getdate())
16	U	Sales	SpecialOffer	1	SpecialOfferID	int		False	True	1	1	16	1
16	U	Sales	SpecialOffer	2	Description	nvarchar(0255)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	SpecialOffer	3	DiscountPct	smallmoney		False	False	0	0	0	0	DF_SpecialOffer_DiscountPct	((0.00))
16	U	Sales	SpecialOffer	4	Type	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	SpecialOffer	5	Category	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	SpecialOffer	6	StartDate	datetime		False	False	0	0	0	0
16	U	Sales	SpecialOffer	7	EndDate	datetime		False	False	0	0	0	0
16	U	Sales	SpecialOffer	8	MinQty	int		False	False	0	0	0	0	DF_SpecialOffer_MinQty	((0))
16	U	Sales	SpecialOffer	9	MaxQty	int		True	False	0	0	0	0
16	U	Sales	SpecialOffer	10	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_SpecialOffer_rowguid	(newid())
16	U	Sales	SpecialOffer	11	ModifiedDate	datetime		False	False	0	0	0	0	DF_SpecialOffer_ModifiedDate	(getdate())
16	U	Sales	SpecialOfferProduct	1	SpecialOfferID	int		False	False	0	0	0	1
16	U	Sales	SpecialOfferProduct	2	ProductID	int		False	False	0	0	0	2
16	U	Sales	SpecialOfferProduct	3	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_SpecialOfferProduct_rowguid	(newid())
16	U	Sales	SpecialOfferProduct	4	ModifiedDate	datetime		False	False	0	0	0	0	DF_SpecialOfferProduct_ModifiedDate	(getdate())
16	U	Sales	Store	1	BusinessEntityID	int		False	False	0	0	0	1
16	U	Sales	Store	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False	False	0	0	0	0
16	U	Sales	Store	3	SalesPersonID	int		True	False	0	0	0	0
16	U	Sales	Store	4	Demographics	xml		True	False	0	0	0	0
16	U	Sales	Store	5	rowguid	uniqueidentifier		False	False	0	0	0	0	DF_Store_rowguid	(newid())
16	U	Sales	Store	6	ModifiedDate	datetime		False	False	0	0	0	0	DF_Store_ModifiedDate	(getdate())