| 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] |