| PK_AWBuildVersion_SystemInformationID | AWBuildVersion | 8 | clustered, unique, primary key located on PRIMARY |
| PK_DatabaseLog_DatabaseLogID | DatabaseLog | 40 | nonclustered, unique, primary key located on PRIMARY |
| PK_ErrorLog_ErrorLogID | ErrorLog | 0 | clustered, unique, primary key located on PRIMARY |
| AK_Department_Name | Department | 16 | nonclustered, unique located on PRIMARY |
| PK_Department_DepartmentID | Department | 8 | clustered, unique, primary key located on PRIMARY |
| AK_Employee_LoginID | Employee | 40 | nonclustered, unique located on PRIMARY |
| AK_Employee_NationalIDNumber | Employee | 32 | nonclustered, unique located on PRIMARY |
| AK_Employee_rowguid | Employee | 16 | nonclustered, unique located on PRIMARY |
| IX_Employee_OrganizationLevel_OrganizationNode | Employee | 16 | nonclustered located on PRIMARY |
| IX_Employee_OrganizationNode | Employee | 16 | nonclustered located on PRIMARY |
| PK_Employee_BusinessEntityID | Employee | 16 | clustered, unique, primary key located on PRIMARY |
| IX_EmployeeDepartmentHistory_DepartmentID | EmployeeDepartmentHistory | 16 | nonclustered located on PRIMARY |
| IX_EmployeeDepartmentHistory_ShiftID | EmployeeDepartmentHistory | 16 | nonclustered located on PRIMARY |
| PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID | EmployeeDepartmentHistory | 16 | clustered, unique, primary key located on PRIMARY |
| PK_EmployeePayHistory_BusinessEntityID_RateChangeDate | EmployeePayHistory | 16 | clustered, unique, primary key located on PRIMARY |
| IX_JobCandidate_BusinessEntityID | JobCandidate | 16 | nonclustered located on PRIMARY |
| PK_JobCandidate_JobCandidateID | JobCandidate | 16 | clustered, unique, primary key located on PRIMARY |
| AK_Shift_Name | Shift | 16 | nonclustered, unique located on PRIMARY |
| AK_Shift_StartTime_EndTime | Shift | 16 | nonclustered, unique located on PRIMARY |
| PK_Shift_ShiftID | Shift | 8 | clustered, unique, primary key located on PRIMARY |
| AK_Address_rowguid | Address | 464 | nonclustered, unique located on PRIMARY |
| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode | Address | 1728 | nonclustered, unique located on PRIMARY |
| IX_Address_StateProvinceID | Address | 232 | nonclustered located on PRIMARY |
| PK_Address_AddressID | Address | 80 | clustered, unique, primary key located on PRIMARY |
| AK_AddressType_Name | AddressType | 16 | nonclustered, unique located on PRIMARY |
| AK_AddressType_rowguid | AddressType | 16 | nonclustered, unique located on PRIMARY |
| PK_AddressType_AddressTypeID | AddressType | 8 | clustered, unique, primary key located on PRIMARY |
| AK_BusinessEntity_rowguid | BusinessEntity | 496 | nonclustered, unique located on PRIMARY |
| PK_BusinessEntity_BusinessEntityID | BusinessEntity | 16 | clustered, unique, primary key located on PRIMARY |
| AK_BusinessEntityAddress_rowguid | BusinessEntityAddress | 624 | nonclustered, unique located on PRIMARY |
| IX_BusinessEntityAddress_AddressID | BusinessEntityAddress | 312 | nonclustered located on PRIMARY |
| IX_BusinessEntityAddress_AddressTypeID | BusinessEntityAddress | 312 | nonclustered located on PRIMARY |
| PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID | BusinessEntityAddress | 16 | clustered, unique, primary key located on PRIMARY |
| AK_BusinessEntityContact_rowguid | BusinessEntityContact | 48 | nonclustered, unique located on PRIMARY |
| IX_BusinessEntityContact_ContactTypeID | BusinessEntityContact | 32 | nonclustered located on PRIMARY |
| IX_BusinessEntityContact_PersonID | BusinessEntityContact | 32 | nonclustered located on PRIMARY |
| PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID | BusinessEntityContact | 16 | clustered, unique, primary key located on PRIMARY |
| AK_ContactType_Name | ContactType | 16 | nonclustered, unique located on PRIMARY |
| PK_ContactType_ContactTypeID | ContactType | 8 | clustered, unique, primary key located on PRIMARY |
| AK_CountryRegion_Name | CountryRegion | 16 | nonclustered, unique located on PRIMARY |
| PK_CountryRegion_CountryRegionCode | CountryRegion | 16 | clustered, unique, primary key located on PRIMARY |
| IX_EmailAddress_EmailAddress | EmailAddress | 1488 | nonclustered located on PRIMARY |
| PK_EmailAddress_BusinessEntityID_EmailAddressID | EmailAddress | 16 | clustered, unique, primary key located on PRIMARY |
| PK_Password_BusinessEntityID | Password | 16 | clustered, unique, primary key located on PRIMARY |
| AK_Person_rowguid | Person | 472 | nonclustered, unique located on PRIMARY |
| IX_Person_LastName_FirstName_MiddleName | Person | 912 | nonclustered located on PRIMARY |
| PK_Person_BusinessEntityID | Person | 144 | clustered, unique, primary key located on PRIMARY |
| PXML_Person_AddContact | Person | 0 | |
| PXML_Person_Demographics | Person | 0 | |
| XMLPATH_Person_Demographics | Person | 0 | |
| XMLPROPERTY_Person_Demographics | Person | 0 | |
| XMLVALUE_Person_Demographics | Person | 0 | |
| IX_PersonPhone_PhoneNumber | PersonPhone | 920 | nonclustered located on PRIMARY |
| PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID | PersonPhone | 16 | clustered, unique, primary key located on PRIMARY |
| PK_PhoneNumberType_PhoneNumberTypeID | PhoneNumberType | 8 | clustered, unique, primary key located on PRIMARY |
| AK_StateProvince_Name | StateProvince | 16 | nonclustered, unique located on PRIMARY |
| AK_StateProvince_rowguid | StateProvince | 16 | nonclustered, unique located on PRIMARY |
| AK_StateProvince_StateProvinceCode_CountryRegionCode | StateProvince | 16 | nonclustered, unique located on PRIMARY |
| PK_StateProvince_StateProvinceID | StateProvince | 16 | clustered, unique, primary key located on PRIMARY |
| IX_vStateProvinceCountryRegion | vStateProvinceCountryRegion | 16 | clustered, unique located on PRIMARY |
| AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate | BillOfMaterials | 16 | clustered, unique located on PRIMARY |
| IX_BillOfMaterials_UnitMeasureCode | BillOfMaterials | 96 | nonclustered located on PRIMARY |
| PK_BillOfMaterials_BillOfMaterialsID | BillOfMaterials | 88 | nonclustered, unique, primary key located on PRIMARY |
| AK_Culture_Name | Culture | 16 | nonclustered, unique located on PRIMARY |
| PK_Culture_CultureID | Culture | 8 | clustered, unique, primary key located on PRIMARY |
| AK_Document_DocumentLevel_DocumentNode | Document | 16 | nonclustered, unique located on PRIMARY |
| AK_Document_rowguid | Document | 16 | nonclustered, unique located on PRIMARY |
| IX_Document_FileName_Revision | Document | 16 | nonclustered located on PRIMARY |
| PK_Document_DocumentNode | Document | 8 | clustered, unique, primary key located on PRIMARY |
| UQ__Document__F73921F730F848ED | Document | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_Illustration_IllustrationID | Illustration | 8 | clustered, unique, primary key located on PRIMARY |
| AK_Location_Name | Location | 16 | nonclustered, unique located on PRIMARY |
| PK_Location_LocationID | Location | 8 | clustered, unique, primary key located on PRIMARY |
| AK_Product_Name | Product | 40 | nonclustered, unique located on PRIMARY |
| AK_Product_ProductNumber | Product | 32 | nonclustered, unique located on PRIMARY |
| AK_Product_rowguid | Product | 32 | nonclustered, unique located on PRIMARY |
| PK_Product_ProductID | Product | 16 | clustered, unique, primary key located on PRIMARY |
| AK_ProductCategory_Name | ProductCategory | 16 | nonclustered, unique located on PRIMARY |
| AK_ProductCategory_rowguid | ProductCategory | 16 | nonclustered, unique located on PRIMARY |
| PK_ProductCategory_ProductCategoryID | ProductCategory | 8 | clustered, unique, primary key located on PRIMARY |
| PK_ProductCostHistory_ProductID_StartDate | ProductCostHistory | 16 | clustered, unique, primary key located on PRIMARY |
| AK_ProductDescription_rowguid | ProductDescription | 40 | nonclustered, unique located on PRIMARY |
| PK_ProductDescription_ProductDescriptionID | ProductDescription | 16 | clustered, unique, primary key located on PRIMARY |
| PK_ProductDocument_ProductID_DocumentNode | ProductDocument | 8 | clustered, unique, primary key located on PRIMARY |
| PK_ProductInventory_ProductID_LocationID | ProductInventory | 16 | clustered, unique, primary key located on PRIMARY |
| PK_ProductListPriceHistory_ProductID_StartDate | ProductListPriceHistory | 16 | clustered, unique, primary key located on PRIMARY |
| AK_ProductModel_Name | ProductModel | 16 | nonclustered, unique located on PRIMARY |
| AK_ProductModel_rowguid | ProductModel | 16 | nonclustered, unique located on PRIMARY |
| PK_ProductModel_ProductModelID | ProductModel | 16 | clustered, unique, primary key located on PRIMARY |
| PXML_ProductModel_CatalogDescription | ProductModel | 0 | |
| PXML_ProductModel_Instructions | ProductModel | 0 | |
| PK_ProductModelIllustration_ProductModelID_IllustrationID | ProductModelIllustration | 8 | clustered, unique, primary key located on PRIMARY |
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID | ProductModelProductDescriptionCulture | 16 | clustered, unique, primary key located on PRIMARY |
| PK_ProductPhoto_ProductPhotoID | ProductPhoto | 16 | clustered, unique, primary key located on PRIMARY |
| PK_ProductProductPhoto_ProductID_ProductPhotoID | ProductProductPhoto | 32 | nonclustered, unique, primary key located on PRIMARY |
| IX_ProductReview_ProductID_Name | ProductReview | 40 | nonclustered located on PRIMARY |
| PK_ProductReview_ProductReviewID | ProductReview | 16 | clustered, unique, primary key located on PRIMARY |
| AK_ProductSubcategory_Name | ProductSubcategory | 16 | nonclustered, unique located on PRIMARY |
| AK_ProductSubcategory_rowguid | ProductSubcategory | 16 | nonclustered, unique located on PRIMARY |
| PK_ProductSubcategory_ProductSubcategoryID | ProductSubcategory | 8 | clustered, unique, primary key located on PRIMARY |
| AK_ScrapReason_Name | ScrapReason | 16 | nonclustered, unique located on PRIMARY |
| PK_ScrapReason_ScrapReasonID | ScrapReason | 8 | clustered, unique, primary key located on PRIMARY |
| IX_TransactionHistory_ProductID | TransactionHistory | 1336 | nonclustered located on PRIMARY |
| IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID | TransactionHistory | 1776 | nonclustered located on PRIMARY |
| PK_TransactionHistory_TransactionID | TransactionHistory | 80 | clustered, unique, primary key located on PRIMARY |
| IX_TransactionHistoryArchive_ProductID | TransactionHistoryArchive | 1064 | nonclustered located on PRIMARY |
| IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID | TransactionHistoryArchive | 1424 | nonclustered located on PRIMARY |
| PK_TransactionHistoryArchive_TransactionID | TransactionHistoryArchive | 80 | clustered, unique, primary key located on PRIMARY |
| AK_UnitMeasure_Name | UnitMeasure | 16 | nonclustered, unique located on PRIMARY |
| PK_UnitMeasure_UnitMeasureCode | UnitMeasure | 8 | clustered, unique, primary key located on PRIMARY |
| IX_vProductAndDescription | vProductAndDescription | 16 | clustered, unique located on PRIMARY |
| IX_WorkOrder_ProductID | WorkOrder | 872 | nonclustered located on PRIMARY |
| IX_WorkOrder_ScrapReasonID | WorkOrder | 880 | nonclustered located on PRIMARY |
| PK_WorkOrder_WorkOrderID | WorkOrder | 80 | clustered, unique, primary key located on PRIMARY |
| IX_WorkOrderRouting_ProductID | WorkOrderRouting | 960 | nonclustered located on PRIMARY |
| PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence | WorkOrderRouting | 80 | clustered, unique, primary key located on PRIMARY |
| IX_ProductVendor_BusinessEntityID | ProductVendor | 16 | nonclustered located on PRIMARY |
| IX_ProductVendor_UnitMeasureCode | ProductVendor | 16 | nonclustered located on PRIMARY |
| PK_ProductVendor_ProductID_BusinessEntityID | ProductVendor | 16 | clustered, unique, primary key located on PRIMARY |
| IX_PurchaseOrderDetail_ProductID | PurchaseOrderDetail | 152 | nonclustered located on PRIMARY |
| PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | PurchaseOrderDetail | 16 | clustered, unique, primary key located on PRIMARY |
| IX_PurchaseOrderHeader_EmployeeID | PurchaseOrderHeader | 64 | nonclustered located on PRIMARY |
| IX_PurchaseOrderHeader_VendorID | PurchaseOrderHeader | 64 | nonclustered located on PRIMARY |
| PK_PurchaseOrderHeader_PurchaseOrderID | PurchaseOrderHeader | 16 | clustered, unique, primary key located on PRIMARY |
| AK_ShipMethod_Name | ShipMethod | 16 | nonclustered, unique located on PRIMARY |
| AK_ShipMethod_rowguid | ShipMethod | 16 | nonclustered, unique located on PRIMARY |
| PK_ShipMethod_ShipMethodID | ShipMethod | 8 | clustered, unique, primary key located on PRIMARY |
| AK_Vendor_AccountNumber | Vendor | 16 | nonclustered, unique located on PRIMARY |
| PK_Vendor_BusinessEntityID | Vendor | 16 | clustered, unique, primary key located on PRIMARY |
| IX_CountryRegionCurrency_CurrencyCode | CountryRegionCurrency | 16 | nonclustered located on PRIMARY |
| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode | CountryRegionCurrency | 8 | clustered, unique, primary key located on PRIMARY |
| AK_CreditCard_CardNumber | CreditCard | 760 | nonclustered, unique located on PRIMARY |
| PK_CreditCard_CreditCardID | CreditCard | 16 | clustered, unique, primary key located on PRIMARY |
| AK_Currency_Name | Currency | 16 | nonclustered, unique located on PRIMARY |
| PK_Currency_CurrencyCode | Currency | 8 | clustered, unique, primary key located on PRIMARY |
| AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode | CurrencyRate | 384 | nonclustered, unique located on PRIMARY |
| PK_CurrencyRate_CurrencyRateID | CurrencyRate | 16 | clustered, unique, primary key located on PRIMARY |
| AK_Customer_AccountNumber | Customer | 432 | nonclustered, unique located on PRIMARY |
| AK_Customer_rowguid | Customer | 472 | nonclustered, unique located on PRIMARY |
| IX_Customer_TerritoryID | Customer | 296 | nonclustered located on PRIMARY |
| PK_Customer_CustomerID | Customer | 16 | clustered, unique, primary key located on PRIMARY |
| PK_PersonCreditCard_BusinessEntityID_CreditCardID | PersonCreditCard | 16 | clustered, unique, primary key located on PRIMARY |
| AK_SalesOrderDetail_rowguid | SalesOrderDetail | 3336 | nonclustered, unique located on PRIMARY |
| IX_SalesOrderDetail_ProductID | SalesOrderDetail | 1896 | nonclustered located on PRIMARY |
| PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID | SalesOrderDetail | 80 | clustered, unique, primary key located on PRIMARY |
| AK_SalesOrderHeader_rowguid | SalesOrderHeader | 736 | nonclustered, unique located on PRIMARY |
| AK_SalesOrderHeader_SalesOrderNumber | SalesOrderHeader | 800 | nonclustered, unique located on PRIMARY |
| IX_SalesOrderHeader_CustomerID | SalesOrderHeader | 360 | nonclustered located on PRIMARY |
| IX_SalesOrderHeader_SalesPersonID | SalesOrderHeader | 456 | nonclustered located on PRIMARY |
| PK_SalesOrderHeader_SalesOrderID | SalesOrderHeader | 80 | clustered, unique, primary key located on PRIMARY |
| PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID | SalesOrderHeaderSalesReason | 16 | clustered, unique, primary key located on PRIMARY |
| AK_SalesPerson_rowguid | SalesPerson | 16 | nonclustered, unique located on PRIMARY |
| PK_SalesPerson_BusinessEntityID | SalesPerson | 8 | clustered, unique, primary key located on PRIMARY |
| AK_SalesPersonQuotaHistory_rowguid | SalesPersonQuotaHistory | 16 | nonclustered, unique located on PRIMARY |
| PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate | SalesPersonQuotaHistory | 16 | clustered, unique, primary key located on PRIMARY |
| PK_SalesReason_SalesReasonID | SalesReason | 8 | clustered, unique, primary key located on PRIMARY |
| AK_SalesTaxRate_rowguid | SalesTaxRate | 16 | nonclustered, unique located on PRIMARY |
| AK_SalesTaxRate_StateProvinceID_TaxType | SalesTaxRate | 16 | nonclustered, unique located on PRIMARY |
| PK_SalesTaxRate_SalesTaxRateID | SalesTaxRate | 8 | clustered, unique, primary key located on PRIMARY |
| AK_SalesTerritory_Name | SalesTerritory | 16 | nonclustered, unique located on PRIMARY |
| AK_SalesTerritory_rowguid | SalesTerritory | 16 | nonclustered, unique located on PRIMARY |
| PK_SalesTerritory_TerritoryID | SalesTerritory | 8 | clustered, unique, primary key located on PRIMARY |
| AK_SalesTerritoryHistory_rowguid | SalesTerritoryHistory | 16 | nonclustered, unique located on PRIMARY |
| PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID | SalesTerritoryHistory | 8 | clustered, unique, primary key located on PRIMARY |
| IX_ShoppingCartItem_ShoppingCartID_ProductID | ShoppingCartItem | 16 | nonclustered located on PRIMARY |
| PK_ShoppingCartItem_ShoppingCartItemID | ShoppingCartItem | 8 | clustered, unique, primary key located on PRIMARY |
| AK_SpecialOffer_rowguid | SpecialOffer | 16 | nonclustered, unique located on PRIMARY |
| PK_SpecialOffer_SpecialOfferID | SpecialOffer | 8 | clustered, unique, primary key located on PRIMARY |
| AK_SpecialOfferProduct_rowguid | SpecialOfferProduct | 32 | nonclustered, unique located on PRIMARY |
| IX_SpecialOfferProduct_ProductID | SpecialOfferProduct | 16 | nonclustered located on PRIMARY |
| PK_SpecialOfferProduct_SpecialOfferID_ProductID | SpecialOfferProduct | 16 | clustered, unique, primary key located on PRIMARY |
| AK_Store_rowguid | Store | 32 | nonclustered, unique located on PRIMARY |
| IX_Store_SalesPersonID | Store | 32 | nonclustered located on PRIMARY |
| PK_Store_BusinessEntityID | Store | 16 | clustered, unique, primary key located on PRIMARY |
| PXML_Store_Demographics | Store | 0 | |