Primary Keys
Fact GeneralSchema GeneralObject SQLServerFile SQLServerName table_type index_type Factor is_ofsk Key GeneralColumn
10 dbo AWBuildVersion PRIMARY PK_AWBuildVersion_SystemInformationID 1 1 0 0 PK [SystemInformationID]
10 dbo DatabaseLog PRIMARY PK_DatabaseLog_DatabaseLogID 0 2 0 0 PK [DatabaseLogID]
10 dbo ErrorLog PRIMARY PK_ErrorLog_ErrorLogID 1 1 0 0 PK [ErrorLogID]
10 HumanResources Department PRIMARY PK_Department_DepartmentID 1 1 0 0 PK [DepartmentID]
10 HumanResources Employee PRIMARY PK_Employee_BusinessEntityID 1 1 0 0 PK [BusinessEntityID]
10 HumanResources EmployeeDepartmentHistory PRIMARY PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID 1 1 0 0 PK [BusinessEntityID], [StartDate], [DepartmentID], [ShiftID]
10 HumanResources EmployeePayHistory PRIMARY PK_EmployeePayHistory_BusinessEntityID_RateChangeDate 1 1 0 0 PK [BusinessEntityID], [RateChangeDate]
10 HumanResources JobCandidate PRIMARY PK_JobCandidate_JobCandidateID 1 1 0 0 PK [JobCandidateID]
10 HumanResources Shift PRIMARY PK_Shift_ShiftID 1 1 0 0 PK [ShiftID]
10 Person Address PRIMARY PK_Address_AddressID 1 1 0 0 PK [AddressID]
10 Person AddressType PRIMARY PK_AddressType_AddressTypeID 1 1 0 0 PK [AddressTypeID]
10 Person BusinessEntity PRIMARY PK_BusinessEntity_BusinessEntityID 1 1 0 0 PK [BusinessEntityID]
10 Person BusinessEntityAddress PRIMARY PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID 1 1 0 0 PK [BusinessEntityID], [AddressID], [AddressTypeID]
10 Person BusinessEntityContact PRIMARY PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID 1 1 0 0 PK [BusinessEntityID], [PersonID], [ContactTypeID]
10 Person ContactType PRIMARY PK_ContactType_ContactTypeID 1 1 0 0 PK [ContactTypeID]
10 Person CountryRegion PRIMARY PK_CountryRegion_CountryRegionCode 1 1 0 0 PK [CountryRegionCode]
10 Person EmailAddress PRIMARY PK_EmailAddress_BusinessEntityID_EmailAddressID 1 1 0 0 PK [BusinessEntityID], [EmailAddressID]
10 Person Password PRIMARY PK_Password_BusinessEntityID 1 1 0 0 PK [BusinessEntityID]
10 Person Person PRIMARY PK_Person_BusinessEntityID 1 1 0 0 PK [BusinessEntityID]
10 Person PersonPhone PRIMARY PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID 1 1 0 0 PK [BusinessEntityID], [PhoneNumber], [PhoneNumberTypeID]
10 Person PhoneNumberType PRIMARY PK_PhoneNumberType_PhoneNumberTypeID 1 1 0 0 PK [PhoneNumberTypeID]
10 Person StateProvince PRIMARY PK_StateProvince_StateProvinceID 1 1 0 0 PK [StateProvinceID]
10 Production BillOfMaterials PRIMARY PK_BillOfMaterials_BillOfMaterialsID 1 2 0 0 PK [BillOfMaterialsID]
10 Production Culture PRIMARY PK_Culture_CultureID 1 1 0 0 PK [CultureID]
10 Production Document PRIMARY PK_Document_DocumentNode 1 1 0 0 PK [DocumentNode]
10 Production Illustration PRIMARY PK_Illustration_IllustrationID 1 1 0 0 PK [IllustrationID]
10 Production Location PRIMARY PK_Location_LocationID 1 1 0 0 PK [LocationID]
10 Production Product PRIMARY PK_Product_ProductID 1 1 0 0 PK [ProductID]
10 Production ProductCategory PRIMARY PK_ProductCategory_ProductCategoryID 1 1 0 0 PK [ProductCategoryID]
10 Production ProductCostHistory PRIMARY PK_ProductCostHistory_ProductID_StartDate 1 1 0 0 PK [ProductID], [StartDate]
10 Production ProductDescription PRIMARY PK_ProductDescription_ProductDescriptionID 1 1 0 0 PK [ProductDescriptionID]
10 Production ProductDocument PRIMARY PK_ProductDocument_ProductID_DocumentNode 1 1 0 0 PK [ProductID], [DocumentNode]
10 Production ProductInventory PRIMARY PK_ProductInventory_ProductID_LocationID 1 1 0 0 PK [ProductID], [LocationID]
10 Production ProductListPriceHistory PRIMARY PK_ProductListPriceHistory_ProductID_StartDate 1 1 0 0 PK [ProductID], [StartDate]
10 Production ProductModel PRIMARY PK_ProductModel_ProductModelID 1 1 0 0 PK [ProductModelID]
10 Production ProductModelIllustration PRIMARY PK_ProductModelIllustration_ProductModelID_IllustrationID 1 1 0 0 PK [ProductModelID], [IllustrationID]
10 Production ProductModelProductDescriptionCulture PRIMARY PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID 1 1 0 0 PK [ProductModelID], [ProductDescriptionID], [CultureID]
10 Production ProductPhoto PRIMARY PK_ProductPhoto_ProductPhotoID 1 1 0 0 PK [ProductPhotoID]
10 Production ProductProductPhoto PRIMARY PK_ProductProductPhoto_ProductID_ProductPhotoID 0 2 0 0 PK [ProductID], [ProductPhotoID]
10 Production ProductReview PRIMARY PK_ProductReview_ProductReviewID 1 1 0 0 PK [ProductReviewID]
10 Production ProductSubcategory PRIMARY PK_ProductSubcategory_ProductSubcategoryID 1 1 0 0 PK [ProductSubcategoryID]
10 Production ScrapReason PRIMARY PK_ScrapReason_ScrapReasonID 1 1 0 0 PK [ScrapReasonID]
10 Production TransactionHistory PRIMARY PK_TransactionHistory_TransactionID 1 1 0 0 PK [TransactionID]
10 Production TransactionHistoryArchive PRIMARY PK_TransactionHistoryArchive_TransactionID 1 1 0 0 PK [TransactionID]
10 Production UnitMeasure PRIMARY PK_UnitMeasure_UnitMeasureCode 1 1 0 0 PK [UnitMeasureCode]
10 Production WorkOrder PRIMARY PK_WorkOrder_WorkOrderID 1 1 0 0 PK [WorkOrderID]
10 Production WorkOrderRouting PRIMARY PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence 1 1 0 0 PK [WorkOrderID], [ProductID], [OperationSequence]
10 Purchasing ProductVendor PRIMARY PK_ProductVendor_ProductID_BusinessEntityID 1 1 0 0 PK [ProductID], [BusinessEntityID]
10 Purchasing PurchaseOrderDetail PRIMARY PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID 1 1 0 0 PK [PurchaseOrderID], [PurchaseOrderDetailID]
10 Purchasing PurchaseOrderHeader PRIMARY PK_PurchaseOrderHeader_PurchaseOrderID 1 1 0 0 PK [PurchaseOrderID]
10 Purchasing ShipMethod PRIMARY PK_ShipMethod_ShipMethodID 1 1 0 0 PK [ShipMethodID]
10 Purchasing Vendor PRIMARY PK_Vendor_BusinessEntityID 1 1 0 0 PK [BusinessEntityID]
10 Sales CountryRegionCurrency PRIMARY PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode 1 1 0 0 PK [CountryRegionCode], [CurrencyCode]
10 Sales CreditCard PRIMARY PK_CreditCard_CreditCardID 1 1 0 0 PK [CreditCardID]
10 Sales Currency PRIMARY PK_Currency_CurrencyCode 1 1 0 0 PK [CurrencyCode]
10 Sales CurrencyRate PRIMARY PK_CurrencyRate_CurrencyRateID 1 1 0 0 PK [CurrencyRateID]
10 Sales Customer PRIMARY PK_Customer_CustomerID 1 1 0 0 PK [CustomerID]
10 Sales PersonCreditCard PRIMARY PK_PersonCreditCard_BusinessEntityID_CreditCardID 1 1 0 0 PK [BusinessEntityID], [CreditCardID]
10 Sales SalesOrderDetail PRIMARY PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID 1 1 0 0 PK [SalesOrderID], [SalesOrderDetailID]
10 Sales SalesOrderHeader PRIMARY PK_SalesOrderHeader_SalesOrderID 1 1 0 0 PK [SalesOrderID]
10 Sales SalesOrderHeaderSalesReason PRIMARY PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID 1 1 0 0 PK [SalesOrderID], [SalesReasonID]
10 Sales SalesPerson PRIMARY PK_SalesPerson_BusinessEntityID 1 1 0 0 PK [BusinessEntityID]
10 Sales SalesPersonQuotaHistory PRIMARY PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate 1 1 0 0 PK [BusinessEntityID], [QuotaDate]
10 Sales SalesReason PRIMARY PK_SalesReason_SalesReasonID 1 1 0 0 PK [SalesReasonID]
10 Sales SalesTaxRate PRIMARY PK_SalesTaxRate_SalesTaxRateID 1 1 0 0 PK [SalesTaxRateID]
10 Sales SalesTerritory PRIMARY PK_SalesTerritory_TerritoryID 1 1 0 0 PK [TerritoryID]
10 Sales SalesTerritoryHistory PRIMARY PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID 1 1 0 0 PK [BusinessEntityID], [StartDate], [TerritoryID]
10 Sales ShoppingCartItem PRIMARY PK_ShoppingCartItem_ShoppingCartItemID 1 1 0 0 PK [ShoppingCartItemID]
10 Sales SpecialOffer PRIMARY PK_SpecialOffer_SpecialOfferID 1 1 0 0 PK [SpecialOfferID]
10 Sales SpecialOfferProduct PRIMARY PK_SpecialOfferProduct_SpecialOfferID_ProductID 1 1 0 0 PK [SpecialOfferID], [ProductID]
10 Sales Store PRIMARY PK_Store_BusinessEntityID 1 1 0 0 PK [BusinessEntityID]