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