AdventureWorks OLTP Database Diagram
Page-1
Entity.1008
Sheet.1009
Address
Address
Sheet.1010
PK AddressID U2 AddressLine1 U2 AddressLine2 U2 City FK1,U2 S...
PKAddressIDU2AddressLine1U2AddressLine2U2CityFK1,U2StateProvinceIDU2PostalCodeU1rowguid ModifiedDate
Entity.1011
Sheet.1012
Contact
Contact
Sheet.1013
PK ContactID NameStyle Title FirstName MiddleName LastName Su...
PKContactID NameStyle Title FirstName MiddleName LastName Suffix EmailAddress EmailPromotion Phone PasswordHash PasswordSalt AdditionalContactInfoU1rowguid ModifiedDate
Entity.1014
Sheet.1015
AddressType
AddressType
Sheet.1016
PK AddressTypeID U1 Name U2 rowguid ModifiedDate
PKAddressTypeIDU1NameU2rowguid ModifiedDate
Entity.1017
Sheet.1018
ContactType
ContactType
Sheet.1019
PK ContactTypeID U1 Name ModifiedDate
PKContactTypeIDU1Name ModifiedDate
Entity.1020
Sheet.1021
StateProvince
StateProvince
Sheet.1022
PK StateProvinceID U3 StateProvinceCode FK1,U3 CountryRegionC...
PKStateProvinceIDU3StateProvinceCodeFK1,U3CountryRegionCode IsOnlyStateProvinceFlagU1NameFK2TerritoryIDU2rowguid ModifiedDate
Relationship.1023
Entity.1024
Sheet.1025
CountryRegion
CountryRegion
Sheet.1026
PK CountryRegionCode U1 Name ModifiedDate
PKCountryRegionCodeU1Name ModifiedDate
Relationship.1027
Entity.1028
Sheet.1029
Store
Store
Sheet.1030
PK,FK1 CustomerID Name Demographics U1 rowguid ModifiedDate F...
PK,FK1CustomerID Name DemographicsU1rowguid ModifiedDateFK2SalesPersonID
Entity.1031
Sheet.1032
StoreContact
StoreContact
Sheet.1033
PK,FK3 CustomerID PK,FK1 ContactID FK2 ContactTypeID U1 rowgu...
PK,FK3CustomerIDPK,FK1ContactIDFK2ContactTypeIDU1rowguid ModifiedDate
Relationship.1034
Relationship.1035
Relationship.1036
Entity.1037
Sheet.1038
Individual
Individual
Sheet.1039
PK,FK2 CustomerID FK1 ContactID Demographics ModifiedDate
PK,FK2CustomerIDFK1ContactID Demographics ModifiedDate
Relationship.1040
Entity.1041
Sheet.1042
Customer
Customer
Sheet.1043
PK CustomerID FK1 TerritoryID U1 AccountNumber CustomerType U...
PKCustomerIDFK1TerritoryIDU1AccountNumber CustomerTypeU2rowguid ModifiedDate
Relationship.1044
Relationship.1045
Entity.1046
Sheet.1047
CustomerAddress
CustomerAddress
Sheet.1048
PK,FK3 CustomerID PK,FK1 AddressID FK2 AddressTypeID U1 rowgu...
PK,FK3CustomerIDPK,FK1AddressIDFK2AddressTypeIDU1rowguid ModifiedDate
Relationship.1049
Relationship.1050
Relationship.1051
Entity.1052
Sheet.1053
SalesTerritory
SalesTerritory
Sheet.1054
PK TerritoryID U1 Name CountryRegionCode Group SalesYTD Sales...
PKTerritoryIDU1Name CountryRegionCode Group SalesYTD SalesLastYear CostYTD CostLastYearU2rowguid ModifiedDate
Relationship.1055
Relationship.1056
Entity.1057
Sheet.1058
SalesTerritoryHistory
SalesTerritoryHistory
Sheet.1059
PK,FK1 SalesPersonID PK,FK2 TerritoryID PK StartDate EndDate ...
PK,FK1SalesPersonIDPK,FK2TerritoryIDPKStartDate EndDateU1rowguid ModifiedDate
Relationship.1060
Entity.1061
Sheet.1062
SalesPersonQuotaHistory
SalesPersonQuotaHistory
Sheet.1063
PK,FK1 SalesPersonID PK QuotaDate SalesQuota U1 rowguid Modif...
PK,FK1SalesPersonIDPKQuotaDate SalesQuotaU1rowguid ModifiedDate
Entity.1064
Sheet.1065
SalesPerson
SalesPerson
Sheet.1066
PK,FK1 SalesPersonID FK2 TerritoryID SalesQuota Bonus Commiss...
PK,FK1SalesPersonIDFK2TerritoryID SalesQuota Bonus CommissionPct SalesYTD SalesLastYearU1rowguid ModifiedDate
Relationship.1067
Relationship.1068
Relationship.1069
Entity.1070
Sheet.1071
ContactCreditCard
ContactCreditCard
Sheet.1072
PK,FK2 ContactID PK,FK1 CreditCardID ModifiedDate
PK,FK2ContactIDPK,FK1CreditCardID ModifiedDate
Relationship.1073
Entity.1074
Sheet.1075
SalesOrderHeader
SalesOrderHeader
Sheet.1076
PK SalesOrderID RevisionNumber OrderDate DueDate ShipDate Sta...
PKSalesOrderID RevisionNumber OrderDate DueDate ShipDate Status OnlineOrderFlagU2SalesOrderNumber PurchaseOrderNumber AccountNumberFK6CustomerIDFK3ContactIDFK7SalesPersonIDFK8TerritoryIDFK1BillToAddressIDFK2ShipToAddressIDFK4ShipMethodID CreditCardApprovalCodeFK5CurrencyRateID SubTotal TaxAmt Freight TotalDue CommentU1rowguid ModifiedDateFK9CreditCardID
Relationship.1077
Relationship.1078
Relationship.1079
Relationship.1080
Relationship.1081
Relationship.1082
Entity.1083
Sheet.1084
SalesOrderHeaderSalesReason
SalesOrderHeaderSalesReason
Sheet.1085
PK,FK1 SalesOrderID PK,FK2 SalesReasonID ModifiedDate
PK,FK1SalesOrderIDPK,FK2SalesReasonID ModifiedDate
Relationship.1086
Entity.1087
Sheet.1088
SalesTaxRate
SalesTaxRate
Sheet.1089
PK SalesTaxRateID FK1,U2 StateProvinceID U2 TaxType TaxRate N...
PKSalesTaxRateIDFK1,U2StateProvinceIDU2TaxType TaxRate NameU1rowguid ModifiedDate
Relationship.1090
Entity.1091
Sheet.1092
ShoppingCartItem
ShoppingCartItem
Sheet.1093
PK ShoppingCartItemID ShoppingCartID Quantity FK1 ProductID D...
PKShoppingCartItemID ShoppingCartID QuantityFK1ProductID DateCreated ModifiedDate
Entity.1094
Sheet.1095
Product
Product
Sheet.1096
PK ProductID U1 Name U2 ProductNumber MakeFlag FinishedGoodsF...
PKProductIDU1NameU2ProductNumber MakeFlag FinishedGoodsFlag Color SafetyStockLevel ReorderPoint StandardCost ListPrice SizeFK3SizeUnitMeasureCodeFK4WeightUnitMeasureCode Weight DaysToManufacture ProductLine Class StyleFK2ProductSubcategoryIDFK1ProductModelID SellStartDate SellEndDate DiscontinuedDateU3rowguid ModifiedDate
Relationship.1097
Entity.1098
Sheet.1099
SalesOrderDetail
SalesOrderDetail
Sheet.1100
PK,FK1 SalesOrderID PK SalesOrderDetailID CarrierTrackingNumb...
PK,FK1SalesOrderIDPKSalesOrderDetailID CarrierTrackingNumber OrderQtyFK2ProductIDFK2SpecialOfferID UnitPrice UnitPriceDiscount LineTotalU1rowguid ModifiedDate
Relationship.1101
Entity.1102
Sheet.1103
Currency
Currency
Sheet.1104
PK CurrencyCode U1 Name ModifiedDate
PKCurrencyCodeU1Name ModifiedDate
Entity.1105
Sheet.1106
CurrencyRate
CurrencyRate
Sheet.1107
PK CurrencyRateID U1 CurrencyRateDate FK1,U1 FromCurrencyCode...
PKCurrencyRateIDU1CurrencyRateDateFK1,U1FromCurrencyCodeFK2,U1ToCurrencyCode AverageRate EndOfDayRate ModifiedDate
Relationship.1108
Relationship.1109
Relationship.1110
Entity.1111
Sheet.1112
CreditCard
CreditCard
Sheet.1113
PK CreditCardID CardType U1 CardNumber ExpMonth ExpYear Modif...
PKCreditCardID CardTypeU1CardNumber ExpMonth ExpYear ModifiedDate
Relationship.1114
Relationship.1115
Entity.1116
Sheet.1117
SalesReason
SalesReason
Sheet.1118
PK SalesReasonID Name ReasonType ModifiedDate
PKSalesReasonID Name ReasonType ModifiedDate
Relationship.1119
Entity.1120
Sheet.1121
SpecialOffer
SpecialOffer
Sheet.1122
PK SpecialOfferID Description DiscountPct Type Category Start...
PKSpecialOfferID Description DiscountPct Type Category StartDate EndDate MinQty MaxQtyU1rowguid ModifiedDate
Entity.1123
Sheet.1124
SpecialOfferProduct
SpecialOfferProduct
Sheet.1125
PK,FK2 SpecialOfferID PK,FK1 ProductID U1 rowguid ModifiedDate
PK,FK2SpecialOfferIDPK,FK1ProductIDU1rowguid ModifiedDate
Relationship.1126
Relationship.1127
Relationship.1128
Entity.1129
Sheet.1130
ProductListPriceHistory
ProductListPriceHistory
Sheet.1131
PK,FK1 ProductID PK StartDate EndDate ListPrice ModifiedDate
PK,FK1ProductIDPKStartDate EndDate ListPrice ModifiedDate
Relationship.1132
Entity.1133
Sheet.1134
ProductReview
ProductReview
Sheet.1135
PK ProductReviewID FK1 ProductID ReviewerName ReviewDate Emai...
PKProductReviewIDFK1ProductID ReviewerName ReviewDate EmailAddress Rating Comments ModifiedDate
Relationship.1136
Entity.1137
Sheet.1138
BillOfMaterials
BillOfMaterials
Sheet.1139
PK BillOfMaterialsID FK1,U1 ProductAssemblyID FK2,U1 Componen...
PKBillOfMaterialsIDFK1,U1ProductAssemblyIDFK2,U1ComponentIDU1StartDate EndDateFK3UnitMeasureCode BOMLevel PerAssemblyQty ModifiedDate
Relationship.1140
Relationship.1141
Entity.1142
Sheet.1143
ProductPhoto
ProductPhoto
Sheet.1144
PK ProductPhotoID ThumbNailPhoto ThumbnailPhotoFileName Large...
PKProductPhotoID ThumbNailPhoto ThumbnailPhotoFileName LargePhoto LargePhotoFileName ModifiedDate
Entity.1145
Sheet.1146
ProductProductPhoto
ProductProductPhoto
Sheet.1147
PK,FK1 ProductID PK,FK2 ProductPhotoID Primary ModifiedDate
PK,FK1ProductIDPK,FK2ProductPhotoID Primary ModifiedDate
Relationship.1148
Relationship.1149
Entity.1150
Sheet.1151
ProductSubcategory
ProductSubcategory
Sheet.1152
PK ProductSubcategoryID FK1 ProductCategoryID U1 Name U2 rowg...
PKProductSubcategoryIDFK1ProductCategoryIDU1NameU2rowguid ModifiedDate
Relationship.1153
Entity.1154
Sheet.1155
ProductCategory
ProductCategory
Sheet.1156
PK ProductCategoryID U1 Name U2 rowguid ModifiedDate
PKProductCategoryIDU1NameU2rowguid ModifiedDate
Relationship.1157
Entity.1158
Sheet.1159
ProductDocument
ProductDocument
Sheet.1160
PK,FK2 ProductID PK,FK1 DocumentID ModifiedDate
PK,FK2ProductIDPK,FK1DocumentID ModifiedDate
Relationship.1161
Entity.1162
Sheet.1163
ProductModel
ProductModel
Sheet.1164
PK ProductModelID U1 Name CatalogDescription Instructions U2 ...
PKProductModelIDU1Name CatalogDescription InstructionsU2rowguid ModifiedDate
Relationship.1165
Entity.1166
Sheet.1167
ProductModelIllustration
ProductModelIllustration
Sheet.1168
PK,FK2 ProductModelID PK,FK1 IllustrationID ModifiedDate
PK,FK2ProductModelIDPK,FK1IllustrationID ModifiedDate
Relationship.1169
Entity.1170
Sheet.1171
Illustration
Illustration
Sheet.1172
PK IllustrationID Diagram ModifiedDate
PKIllustrationID Diagram ModifiedDate
Relationship.1173
Entity.1174
Sheet.1175
ProductModelProductDescriptionCulture
ProductModelProductDescriptionCulture
Sheet.1176
PK,FK3 ProductModelID PK,FK2 ProductDescriptionID PK,FK1 Cult...
PK,FK3ProductModelIDPK,FK2ProductDescriptionIDPK,FK1CultureID ModifiedDate
Relationship.1177
Entity.1178
Sheet.1179
ProductDescription
ProductDescription
Sheet.1180
PK ProductDescriptionID Description U1 rowguid ModifiedDate
PKProductDescriptionID DescriptionU1rowguid ModifiedDate
Relationship.1181
Entity.1182
Sheet.1183
Culture
Culture
Sheet.1184
PK CultureID U1 Name ModifiedDate
PKCultureIDU1Name ModifiedDate
Relationship.1185
Entity.1186
Sheet.1187
UnitMeasure
UnitMeasure
Sheet.1188
PK UnitMeasureCode U1 Name ModifiedDate
PKUnitMeasureCodeU1Name ModifiedDate
Relationship.1189
Relationship.1190
Relationship.1191
Entity.1192
Sheet.1193
WorkOrderRouting
WorkOrderRouting
Sheet.1194
PK,FK2 WorkOrderID PK ProductID PK OperationSequence FK1 Loca...
PK,FK2WorkOrderIDPKProductIDPKOperationSequenceFK1LocationID ScheduledStartDate ScheduledEndDate ActualStartDate ActualEndDate ActualResourceHrs PlannedCost ActualCost ModifiedDate
Entity.1195
Sheet.1196
ProductInventory
ProductInventory
Sheet.1197
PK,FK2 ProductID PK,FK1 LocationID Shelf Bin Quantity rowguid...
PK,FK2ProductIDPK,FK1LocationID Shelf Bin Quantity rowguid ModifiedDate
Relationship.1198
Entity.1199
Sheet.1200
Location
Location
Sheet.1201
PK LocationID U1 Name CostRate Availability ModifiedDate
PKLocationIDU1Name CostRate Availability ModifiedDate
Relationship.1202
Relationship.1203
Entity.1204
Sheet.1205
ProductCostHistory
ProductCostHistory
Sheet.1206
PK,FK1 ProductID PK StartDate EndDate StandardCost ModifiedDate
PK,FK1ProductIDPKStartDate EndDate StandardCost ModifiedDate
Relationship.1207
Entity.1208
Sheet.1209
WorkOrder
WorkOrder
Sheet.1210
PK WorkOrderID FK1 ProductID OrderQty StockedQty ScrappedQty ...
PKWorkOrderIDFK1ProductID OrderQty StockedQty ScrappedQty StartDate EndDate DueDateFK2ScrapReasonID ModifiedDate
Relationship.1211
Relationship.1212
Entity.1213
Sheet.1214
ScrapReason
ScrapReason
Sheet.1215
PK ScrapReasonID U1 Name ModifiedDate
PKScrapReasonIDU1Name ModifiedDate
Relationship.1216
Entity.1217
Sheet.1218
TransactionHistory
TransactionHistory
Sheet.1219
PK TransactionID FK1 ProductID ReferenceOrderID TransactionDa...
PKTransactionIDFK1ProductID ReferenceOrderID TransactionDate TransactionType Quantity ActualCost ModifiedDate ReferenceOrderLineID
Entity.1220
Sheet.1221
TransactionHistoryArchive
TransactionHistoryArchive
Sheet.1222
PK TransactionID ProductID ReferenceOrderID TransactionDate T...
PKTransactionID ProductID ReferenceOrderID TransactionDate TransactionType Quantity ActualCost ModifiedDate ReferenceOrderLineID
Relationship.1223
Entity.1224
Sheet.1225
Document
Document
Sheet.1226
PK DocumentID Title U1 FileName FileExtension U1 Revision Cha...
PKDocumentID TitleU1FileName FileExtensionU1Revision ChangeNumber Status DocumentSummary Document ModifiedDate
Relationship.1227
Entity.1228
Sheet.1229
PurchaseOrderDetail
PurchaseOrderDetail
Sheet.1230
PK,FK2 ShipMethodID PK,FK2 PurchaseOrderID PK PurchaseOrderDe...
PK,FK2ShipMethodIDPK,FK2PurchaseOrderIDPKPurchaseOrderDetailID DueDate OrderQtyFK1ProductID UnitPrice LineTotal ReceivedQty RejectedQty StockedQty ModifiedDate
Relationship.1231
Entity.1232
Sheet.1233
PurchaseOrderHeader
PurchaseOrderHeader
Sheet.1234
PK PurchaseOrderID PK,FK3 ShipMethodID RevisionNumber Status ...
PKPurchaseOrderIDPK,FK3ShipMethodID RevisionNumber StatusFK1EmployeeIDFK2VendorID OrderDate ShipDate SubTotal TaxAmt Freight TotalDue ModifiedDate
Relationship.1235
Entity.1236
Sheet.1237
Vendor
Vendor
Sheet.1238
PK VendorID U1 AccountNumber Name CreditRating PreferredVendo...
PKVendorIDU1AccountNumber Name CreditRating PreferredVendorStatus ActiveFlag PurchasingWebServiceURL ModifiedDate
Relationship.1239
Entity.1240
Sheet.1241
VendorAddress
VendorAddress
Sheet.1242
PK,FK3 VendorID PK,FK1 AddressID FK2 AddressTypeID ModifiedDate
PK,FK3VendorIDPK,FK1AddressIDFK2AddressTypeID ModifiedDate
Relationship.1243
Relationship.1244
Relationship.1245
Entity.1246
Sheet.1247
VendorContact
VendorContact
Sheet.1248
PK,FK3 VendorID PK,FK1 ContactID FK2 ContactTypeID ModifiedDate
PK,FK3VendorIDPK,FK1ContactIDFK2ContactTypeID ModifiedDate
Relationship.1249
Relationship.1250
Relationship.1251
Entity.1252
Sheet.1253
ShipMethod
ShipMethod
Sheet.1254
PK ShipMethodID U1 Name ShipBase ShipRate U2 rowguid Modified...
PKShipMethodIDU1Name ShipBase ShipRateU2rowguid ModifiedDate
Relationship.1255
Relationship.1256
Entity.1257
Sheet.1258
ProductVendor
ProductVendor
Sheet.1259
PK,FK1 ProductID PK,FK3 VendorID AverageLeadTime StandardPric...
PK,FK1ProductIDPK,FK3VendorID AverageLeadTime StandardPrice LastReceiptCost LastReceiptDate MinOrderQty MaxOrderQty OnOrderQtyFK2UnitMeasureCode ModifiedDate
Relationship.1260
Relationship.1261
Relationship.1262
Entity.1263
Sheet.1264
AWBuildVersion
AWBuildVersion
Sheet.1265
PK SystemInformationID Database Version VersionDate ModifiedD...
PKSystemInformationID Database Version VersionDate ModifiedDate
Entity.1266
Sheet.1267
Employee
Employee
Sheet.1268
PK EmployeeID U2 NationalIDNumber FK2 ContactID U1 LoginID FK...
PKEmployeeIDU2NationalIDNumberFK2ContactIDU1LoginIDFK1ManagerID ShiftID Title BirthDate MaritalStatus Gender HireDate SalariedFlag VacationHours SickLeaveHours CurrentFlagU3rowguid ModifiedDate
Relationship.1269
Relationship.1270
Relationship.1271
Relationship.1272
Entity.1273
Sheet.1274
EmployeeDepartmentHistory
EmployeeDepartmentHistory
Sheet.1275
PK,FK2 EmployeeID PK,FK1 DepartmentID PK StartDate PK,FK3 Shi...
PK,FK2EmployeeIDPK,FK1DepartmentIDPKStartDatePK,FK3ShiftID EndDate ModifiedDate
Relationship.1276
Entity.1277
Sheet.1278
Department
Department
Sheet.1279
PK DepartmentID U1 Name GroupName ModifiedDate
PKDepartmentIDU1Name GroupName ModifiedDate
Relationship.1280
Entity.1281
Sheet.1282
JobCandidate
JobCandidate
Sheet.1283
PK JobCandidateID FK1 EmployeeID Resume ModifiedDate
PKJobCandidateIDFK1EmployeeID Resume ModifiedDate
Relationship.1284
Entity.1285
Sheet.1286
Shift
Shift
Sheet.1287
PK ShiftID U1 Name U2 StartTime U2 EndTime ModifiedDate
PKShiftIDU1NameU2StartTimeU2EndTime ModifiedDate
Entity.1288
Sheet.1289
EmployeePayHistory
EmployeePayHistory
Sheet.1290
PK,FK1 EmployeeID PK RateChangeDate Rate PayFrequency Modifie...
PK,FK1EmployeeIDPKRateChangeDate Rate PayFrequency ModifiedDate
Relationship.1291
Relationship.1292
Relationship.1293
Entity.1294
Sheet.1295
EmployeeAddress
EmployeeAddress
Sheet.1296
PK,FK1 EmployeeID PK,FK2 AddressID U1 rowguid ModifiedDate
PK,FK1EmployeeIDPK,FK2AddressIDU1rowguid ModifiedDate
Relationship.1297
Relationship.1298
Entity.1299
Sheet.1300
DatabaseLog
DatabaseLog
Sheet.1301
PK DatabaseLogID PostTime DatabaseUser Event Schema Object TS...
PKDatabaseLogID PostTime DatabaseUser Event Schema Object TSQL XmlEvent
Sheet.1302
Sheet.1303
Schemas
Schemas
Rounded rectangle.293
Purchasing
Purchasing
Rounded rectangle.294
Production
Production
Rounded rectangle.295
HumanResources
HumanResources
Rounded rectangle.302
Person
Person
Rounded rectangle.292
Sales
Sales
Rounded rectangle.288
dbo
dbo
Entity.1310
Sheet.1311
ErrorLog
ErrorLog
Sheet.1312
PK ErrorLogID ErrorTime UserName ErrorNumber ErrorSeverity Er...
PKErrorLogID ErrorTime UserName ErrorNumber ErrorSeverity ErrorState ErrorProcedure ErrorLine ErrorMessage
Lights.1313
Sheet.1314
Trend arrows 2.1315
Status icons.1316
Sheet.1317
Trend arrows 1.1318
Colored shapes.1319
Faces.1320
Sheet.1321
Traffic signal 1.1322
Sheet.1323
Sheet.1324
Sheet.1325
Ratings.1326
Sheet.1327
Traffic signal 2.1328
Sheet.1329
Sheet.1330
Sheet.1331
Filled circles.1332
Sheet.1333
Entity.1334
Sheet.1335
Address
Address
Sheet.1336
PK AddressID U2 AddressLine1 U2 AddressLine2 U2 City FK1,U2 S...
PKAddressIDU2AddressLine1U2AddressLine2U2CityFK1,U2StateProvinceIDU2PostalCodeU1rowguid ModifiedDate
Entity.1337
Sheet.1338
Contact
Contact
Sheet.1339
PK ContactID NameStyle Title FirstName MiddleName LastName Su...
PKContactID NameStyle Title FirstName MiddleName LastName Suffix EmailAddress EmailPromotion Phone PasswordHash PasswordSalt AdditionalContactInfoU1rowguid ModifiedDate
Entity.1340
Sheet.1341
AddressType
AddressType
Sheet.1342
PK AddressTypeID U1 Name U2 rowguid ModifiedDate
PKAddressTypeIDU1NameU2rowguid ModifiedDate
Entity.1343
Sheet.1344
ContactType
ContactType
Sheet.1345
PK ContactTypeID U1 Name ModifiedDate
PKContactTypeIDU1Name ModifiedDate
Entity.1346
Sheet.1347
StateProvince
StateProvince
Sheet.1348
PK StateProvinceID U3 StateProvinceCode FK1,U3 CountryRegionC...
PKStateProvinceIDU3StateProvinceCodeFK1,U3CountryRegionCode IsOnlyStateProvinceFlagU1NameFK2TerritoryIDU2rowguid ModifiedDate
Relationship.1349
Entity.1350
Sheet.1351
CountryRegion
CountryRegion
Sheet.1352
PK CountryRegionCode U1 Name ModifiedDate
PKCountryRegionCodeU1Name ModifiedDate
Relationship.1353
Entity.1354
Sheet.1355
Store
Store
Sheet.1356
PK,FK1 CustomerID Name Demographics U1 rowguid ModifiedDate F...
PK,FK1CustomerID Name DemographicsU1rowguid ModifiedDateFK2SalesPersonID
Entity.1357
Sheet.1358
StoreContact
StoreContact
Sheet.1359
PK,FK3 CustomerID PK,FK1 ContactID FK2 ContactTypeID U1 rowgu...
PK,FK3CustomerIDPK,FK1ContactIDFK2ContactTypeIDU1rowguid ModifiedDate
Relationship.1360
Relationship.1361
Relationship.1362
Entity.1363
Sheet.1364
Individual
Individual
Sheet.1365
PK,FK2 CustomerID FK1 ContactID Demographics ModifiedDate
PK,FK2CustomerIDFK1ContactID Demographics ModifiedDate
Relationship.1366
Entity.1367
Sheet.1368
Customer
Customer
Sheet.1369
PK CustomerID FK1 TerritoryID U1 AccountNumber CustomerType U...
PKCustomerIDFK1TerritoryIDU1AccountNumber CustomerTypeU2rowguid ModifiedDate
Relationship.1370
Relationship.1371
Entity.1372
Sheet.1373
CustomerAddress
CustomerAddress
Sheet.1374
PK,FK3 CustomerID PK,FK1 AddressID FK2 AddressTypeID U1 rowgu...
PK,FK3CustomerIDPK,FK1AddressIDFK2AddressTypeIDU1rowguid ModifiedDate
Relationship.1375
Relationship.1376
Relationship.1377
Entity.1378
Sheet.1379
SalesTerritory
SalesTerritory
Sheet.1380
PK TerritoryID U1 Name CountryRegionCode Group SalesYTD Sales...
PKTerritoryIDU1Name CountryRegionCode Group SalesYTD SalesLastYear CostYTD CostLastYearU2rowguid ModifiedDate
Relationship.1381
Relationship.1382
Entity.1383
Sheet.1384
SalesTerritoryHistory
SalesTerritoryHistory
Sheet.1385
PK,FK1 SalesPersonID PK,FK2 TerritoryID PK StartDate EndDate ...
PK,FK1SalesPersonIDPK,FK2TerritoryIDPKStartDate EndDateU1rowguid ModifiedDate
Relationship.1386
Entity.1387
Sheet.1388
SalesPersonQuotaHistory
SalesPersonQuotaHistory
Sheet.1389
PK,FK1 SalesPersonID PK QuotaDate SalesQuota U1 rowguid Modif...
PK,FK1SalesPersonIDPKQuotaDate SalesQuotaU1rowguid ModifiedDate
Entity.1390
Sheet.1391
SalesPerson
SalesPerson
Sheet.1392
PK,FK1 SalesPersonID FK2 TerritoryID SalesQuota Bonus Commiss...
PK,FK1SalesPersonIDFK2TerritoryID SalesQuota Bonus CommissionPct SalesYTD SalesLastYearU1rowguid ModifiedDate
Relationship.1393
Relationship.1394
Relationship.1395
Entity.1396
Sheet.1397
ContactCreditCard
ContactCreditCard
Sheet.1398
PK,FK2 ContactID PK,FK1 CreditCardID ModifiedDate
PK,FK2ContactIDPK,FK1CreditCardID ModifiedDate
Relationship.1399
Entity.1400
Sheet.1401
SalesOrderHeader
SalesOrderHeader
Sheet.1402
PK SalesOrderID RevisionNumber OrderDate DueDate ShipDate Sta...
PKSalesOrderID RevisionNumber OrderDate DueDate ShipDate Status OnlineOrderFlagU2SalesOrderNumber PurchaseOrderNumber AccountNumberFK6CustomerIDFK3ContactIDFK7SalesPersonIDFK8TerritoryIDFK1BillToAddressIDFK2ShipToAddressIDFK4ShipMethodID CreditCardApprovalCodeFK5CurrencyRateID SubTotal TaxAmt Freight TotalDue CommentU1rowguid ModifiedDateFK9CreditCardID
Relationship.1403
Relationship.1404
Relationship.1405
Relationship.1406
Relationship.1407
Relationship.1408
Entity.1409
Sheet.1410
SalesOrderHeaderSalesReason
SalesOrderHeaderSalesReason
Sheet.1411
PK,FK1 SalesOrderID PK,FK2 SalesReasonID ModifiedDate
PK,FK1SalesOrderIDPK,FK2SalesReasonID ModifiedDate
Relationship.1412
Entity.1413
Sheet.1414
SalesTaxRate
SalesTaxRate
Sheet.1415
PK SalesTaxRateID FK1,U2 StateProvinceID U2 TaxType TaxRate N...
PKSalesTaxRateIDFK1,U2StateProvinceIDU2TaxType TaxRate NameU1rowguid ModifiedDate
Relationship.1416
Entity.1417
Sheet.1418
ShoppingCartItem
ShoppingCartItem
Sheet.1419
PK ShoppingCartItemID ShoppingCartID Quantity FK1 ProductID D...
PKShoppingCartItemID ShoppingCartID QuantityFK1ProductID DateCreated ModifiedDate
Entity.1420
Sheet.1421
Product
Product
Sheet.1422
PK ProductID U1 Name U2 ProductNumber MakeFlag FinishedGoodsF...
PKProductIDU1NameU2ProductNumber MakeFlag FinishedGoodsFlag Color SafetyStockLevel ReorderPoint StandardCost ListPrice SizeFK3SizeUnitMeasureCodeFK4WeightUnitMeasureCode Weight DaysToManufacture ProductLine Class StyleFK2ProductSubcategoryIDFK1ProductModelID SellStartDate SellEndDate DiscontinuedDateU3rowguid ModifiedDate
Relationship.1423
Entity.1424
Sheet.1425
SalesOrderDetail
SalesOrderDetail
Sheet.1426
PK,FK1 SalesOrderID PK SalesOrderDetailID CarrierTrackingNumb...
PK,FK1SalesOrderIDPKSalesOrderDetailID CarrierTrackingNumber OrderQtyFK2ProductIDFK2SpecialOfferID UnitPrice UnitPriceDiscount LineTotalU1rowguid ModifiedDate
Relationship.1427
Entity.1428
Sheet.1429
Currency
Currency
Sheet.1430
PK CurrencyCode U1 Name ModifiedDate
PKCurrencyCodeU1Name ModifiedDate
Entity.1431
Sheet.1432
CurrencyRate
CurrencyRate
Sheet.1433
PK CurrencyRateID U1 CurrencyRateDate FK1,U1 FromCurrencyCode...
PKCurrencyRateIDU1CurrencyRateDateFK1,U1FromCurrencyCodeFK2,U1ToCurrencyCode AverageRate EndOfDayRate ModifiedDate
Relationship.1434
Relationship.1435
Relationship.1436
Entity.1437
Sheet.1438
CreditCard
CreditCard
Sheet.1439
PK CreditCardID CardType U1 CardNumber ExpMonth ExpYear Modif...
PKCreditCardID CardTypeU1CardNumber ExpMonth ExpYear ModifiedDate
Relationship.1440
Relationship.1441
Entity.1442
Sheet.1443
SalesReason
SalesReason
Sheet.1444
PK SalesReasonID Name ReasonType ModifiedDate
PKSalesReasonID Name ReasonType ModifiedDate
Relationship.1445
Entity.1446
Sheet.1447
SpecialOffer
SpecialOffer
Sheet.1448
PK SpecialOfferID Description DiscountPct Type Category Start...
PKSpecialOfferID Description DiscountPct Type Category StartDate EndDate MinQty MaxQtyU1rowguid ModifiedDate
Entity.1449
Sheet.1450
SpecialOfferProduct
SpecialOfferProduct
Sheet.1451
PK,FK2 SpecialOfferID PK,FK1 ProductID U1 rowguid ModifiedDate
PK,FK2SpecialOfferIDPK,FK1ProductIDU1rowguid ModifiedDate
Relationship.1452
Relationship.1453
Relationship.1454
Entity.1455
Sheet.1456
ProductListPriceHistory
ProductListPriceHistory
Sheet.1457
PK,FK1 ProductID PK StartDate EndDate ListPrice ModifiedDate
PK,FK1ProductIDPKStartDate EndDate ListPrice ModifiedDate
Relationship.1458
Entity.1459
Sheet.1460
ProductReview
ProductReview
Sheet.1461
PK ProductReviewID FK1 ProductID ReviewerName ReviewDate Emai...
PKProductReviewIDFK1ProductID ReviewerName ReviewDate EmailAddress Rating Comments ModifiedDate
Relationship.1462
Entity.1463
Sheet.1464
BillOfMaterials
BillOfMaterials
Sheet.1465
PK BillOfMaterialsID FK1,U1 ProductAssemblyID FK2,U1 Componen...
PKBillOfMaterialsIDFK1,U1ProductAssemblyIDFK2,U1ComponentIDU1StartDate EndDateFK3UnitMeasureCode BOMLevel PerAssemblyQty ModifiedDate
Relationship.1466
Relationship.1467
Entity.1468
Sheet.1469
ProductPhoto
ProductPhoto
Sheet.1470
PK ProductPhotoID ThumbNailPhoto ThumbnailPhotoFileName Large...
PKProductPhotoID ThumbNailPhoto ThumbnailPhotoFileName LargePhoto LargePhotoFileName ModifiedDate
Entity.1471
Sheet.1472
ProductProductPhoto
ProductProductPhoto
Sheet.1473
PK,FK1 ProductID PK,FK2 ProductPhotoID Primary ModifiedDate
PK,FK1ProductIDPK,FK2ProductPhotoID Primary ModifiedDate
Relationship.1474
Relationship.1475
Entity.1476
Sheet.1477
ProductSubcategory
ProductSubcategory
Sheet.1478
PK ProductSubcategoryID FK1 ProductCategoryID U1 Name U2 rowg...
PKProductSubcategoryIDFK1ProductCategoryIDU1NameU2rowguid ModifiedDate
Relationship.1479
Entity.1480
Sheet.1481
ProductCategory
ProductCategory
Sheet.1482
PK ProductCategoryID U1 Name U2 rowguid ModifiedDate
PKProductCategoryIDU1NameU2rowguid ModifiedDate
Relationship.1483
Entity.1484
Sheet.1485
ProductDocument
ProductDocument
Sheet.1486
PK,FK2 ProductID PK,FK1 DocumentID ModifiedDate
PK,FK2ProductIDPK,FK1DocumentID ModifiedDate
Relationship.1487
Entity.1488
Sheet.1489
ProductModel
ProductModel
Sheet.1490
PK ProductModelID U1 Name CatalogDescription Instructions U2 ...
PKProductModelIDU1Name CatalogDescription InstructionsU2rowguid ModifiedDate
Relationship.1491
Entity.1492
Sheet.1493
ProductModelIllustration
ProductModelIllustration
Sheet.1494
PK,FK2 ProductModelID PK,FK1 IllustrationID ModifiedDate
PK,FK2ProductModelIDPK,FK1IllustrationID ModifiedDate
Relationship.1495
Entity.1496
Sheet.1497
Illustration
Illustration
Sheet.1498
PK IllustrationID Diagram ModifiedDate
PKIllustrationID Diagram ModifiedDate
Relationship.1499
Entity.1500
Sheet.1501
ProductModelProductDescriptionCulture
ProductModelProductDescriptionCulture
Sheet.1502
PK,FK3 ProductModelID PK,FK2 ProductDescriptionID PK,FK1 Cult...
PK,FK3ProductModelIDPK,FK2ProductDescriptionIDPK,FK1CultureID ModifiedDate
Relationship.1503
Entity.1504
Sheet.1505
ProductDescription
ProductDescription
Sheet.1506
PK ProductDescriptionID Description U1 rowguid ModifiedDate
PKProductDescriptionID DescriptionU1rowguid ModifiedDate
Relationship.1507
Entity.1508
Sheet.1509
Culture
Culture
Sheet.1510
PK CultureID U1 Name ModifiedDate
PKCultureIDU1Name ModifiedDate
Relationship.1511
Entity.1512
Sheet.1513
UnitMeasure
UnitMeasure
Sheet.1514
PK UnitMeasureCode U1 Name ModifiedDate
PKUnitMeasureCodeU1Name ModifiedDate
Relationship.1515
Relationship.1516
Relationship.1517
Entity.1518
Sheet.1519
WorkOrderRouting
WorkOrderRouting
Sheet.1520
PK,FK2 WorkOrderID PK ProductID PK OperationSequence FK1 Loca...
PK,FK2WorkOrderIDPKProductIDPKOperationSequenceFK1LocationID ScheduledStartDate ScheduledEndDate ActualStartDate ActualEndDate ActualResourceHrs PlannedCost ActualCost ModifiedDate
Entity.1521
Sheet.1522
ProductInventory
ProductInventory
Sheet.1523
PK,FK2 ProductID PK,FK1 LocationID Shelf Bin Quantity rowguid...
PK,FK2ProductIDPK,FK1LocationID Shelf Bin Quantity rowguid ModifiedDate
Relationship.1524
Entity.1525
Sheet.1526
Location
Location
Sheet.1527
PK LocationID U1 Name CostRate Availability ModifiedDate
PKLocationIDU1Name CostRate Availability ModifiedDate
Relationship.1528
Relationship.1529
Entity.1530
Sheet.1531
ProductCostHistory
ProductCostHistory
Sheet.1532
PK,FK1 ProductID PK StartDate EndDate StandardCost ModifiedDate
PK,FK1ProductIDPKStartDate EndDate StandardCost ModifiedDate
Relationship.1533
Entity.1534
Sheet.1535
WorkOrder
WorkOrder
Sheet.1536
PK WorkOrderID FK1 ProductID OrderQty StockedQty ScrappedQty ...
PKWorkOrderIDFK1ProductID OrderQty StockedQty ScrappedQty StartDate EndDate DueDateFK2ScrapReasonID ModifiedDate
Relationship.1537
Relationship.1538
Entity.1539
Sheet.1540
ScrapReason
ScrapReason
Sheet.1541
PK ScrapReasonID U1 Name ModifiedDate
PKScrapReasonIDU1Name ModifiedDate
Relationship.1542
Entity.1543
Sheet.1544
TransactionHistory
TransactionHistory
Sheet.1545
PK TransactionID FK1 ProductID ReferenceOrderID TransactionDa...
PKTransactionIDFK1ProductID ReferenceOrderID TransactionDate TransactionType Quantity ActualCost ModifiedDate ReferenceOrderLineID
Entity.1546
Sheet.1547
TransactionHistoryArchive
TransactionHistoryArchive
Sheet.1548
PK TransactionID ProductID ReferenceOrderID TransactionDate T...
PKTransactionID ProductID ReferenceOrderID TransactionDate TransactionType Quantity ActualCost ModifiedDate ReferenceOrderLineID
Relationship.1549
Entity.1550
Sheet.1551
Document
Document
Sheet.1552
PK DocumentID Title U1 FileName FileExtension U1 Revision Cha...
PKDocumentID TitleU1FileName FileExtensionU1Revision ChangeNumber Status DocumentSummary Document ModifiedDate
Relationship.1553
Entity.1554
Sheet.1555
PurchaseOrderDetail
PurchaseOrderDetail
Sheet.1556
PK,FK2 ShipMethodID PK,FK2 PurchaseOrderID PK PurchaseOrderDe...
PK,FK2ShipMethodIDPK,FK2PurchaseOrderIDPKPurchaseOrderDetailID DueDate OrderQtyFK1ProductID UnitPrice LineTotal ReceivedQty RejectedQty StockedQty ModifiedDate
Relationship.1557
Entity.1558
Sheet.1559
PurchaseOrderHeader
PurchaseOrderHeader
Sheet.1560
PK PurchaseOrderID PK,FK3 ShipMethodID RevisionNumber Status ...
PKPurchaseOrderIDPK,FK3ShipMethodID RevisionNumber StatusFK1EmployeeIDFK2VendorID OrderDate ShipDate SubTotal TaxAmt Freight TotalDue ModifiedDate
Relationship.1561
Entity.1562
Sheet.1563
Vendor
Vendor
Sheet.1564
PK VendorID U1 AccountNumber Name CreditRating PreferredVendo...
PKVendorIDU1AccountNumber Name CreditRating PreferredVendorStatus ActiveFlag PurchasingWebServiceURL ModifiedDate
Relationship.1565
Entity.1566
Sheet.1567
VendorAddress
VendorAddress
Sheet.1568
PK,FK3 VendorID PK,FK1 AddressID FK2 AddressTypeID ModifiedDate
PK,FK3VendorIDPK,FK1AddressIDFK2AddressTypeID ModifiedDate
Relationship.1569
Relationship.1570
Relationship.1571
Entity.1572
Sheet.1573
VendorContact
VendorContact
Sheet.1574
PK,FK3 VendorID PK,FK1 ContactID FK2 ContactTypeID ModifiedDate
PK,FK3VendorIDPK,FK1ContactIDFK2ContactTypeID ModifiedDate
Relationship.1575
Relationship.1576
Relationship.1577
Entity.1578
Sheet.1579
ShipMethod
ShipMethod
Sheet.1580
PK ShipMethodID U1 Name ShipBase ShipRate U2 rowguid Modified...
PKShipMethodIDU1Name ShipBase ShipRateU2rowguid ModifiedDate
Relationship.1581
Relationship.1582
Entity.1583
Sheet.1584
ProductVendor
ProductVendor
Sheet.1585
PK,FK1 ProductID PK,FK3 VendorID AverageLeadTime StandardPric...
PK,FK1ProductIDPK,FK3VendorID AverageLeadTime StandardPrice LastReceiptCost LastReceiptDate MinOrderQty MaxOrderQty OnOrderQtyFK2UnitMeasureCode ModifiedDate
Relationship.1586
Relationship.1587
Relationship.1588
Entity.1589
Sheet.1590
AWBuildVersion
AWBuildVersion
Sheet.1591
PK SystemInformationID Database Version VersionDate ModifiedD...
PKSystemInformationID Database Version VersionDate ModifiedDate
Entity.1592
Sheet.1593
Employee
Employee
Sheet.1594
PK EmployeeID U2 NationalIDNumber FK2 ContactID U1 LoginID FK...
PKEmployeeIDU2NationalIDNumberFK2ContactIDU1LoginIDFK1ManagerID ShiftID Title BirthDate MaritalStatus Gender HireDate SalariedFlag VacationHours SickLeaveHours CurrentFlagU3rowguid ModifiedDate
Relationship.1595
Relationship.1596
Relationship.1597
Relationship.1598
Entity.1599
Sheet.1600
EmployeeDepartmentHistory
EmployeeDepartmentHistory
Sheet.1601
PK,FK2 EmployeeID PK,FK1 DepartmentID PK StartDate PK,FK3 Shi...
PK,FK2EmployeeIDPK,FK1DepartmentIDPKStartDatePK,FK3ShiftID EndDate ModifiedDate
Relationship.1602
Entity.1603
Sheet.1604
Department
Department
Sheet.1605
PK DepartmentID U1 Name GroupName ModifiedDate
PKDepartmentIDU1Name GroupName ModifiedDate
Relationship.1606
Entity.1607
Sheet.1608
JobCandidate
JobCandidate
Sheet.1609
PK JobCandidateID FK1 EmployeeID Resume ModifiedDate
PKJobCandidateIDFK1EmployeeID Resume ModifiedDate
Relationship.1610
Entity.1611
Sheet.1612
Shift
Shift
Sheet.1613
PK ShiftID U1 Name U2 StartTime U2 EndTime ModifiedDate
PKShiftIDU1NameU2StartTimeU2EndTime ModifiedDate
Entity.1614
Sheet.1615
EmployeePayHistory
EmployeePayHistory
Sheet.1616
PK,FK1 EmployeeID PK RateChangeDate Rate PayFrequency Modifie...
PK,FK1EmployeeIDPKRateChangeDate Rate PayFrequency ModifiedDate
Relationship.1617
Relationship.1618
Relationship.1619
Entity.1620
Sheet.1621
EmployeeAddress
EmployeeAddress
Sheet.1622
PK,FK1 EmployeeID PK,FK2 AddressID U1 rowguid ModifiedDate
PK,FK1EmployeeIDPK,FK2AddressIDU1rowguid ModifiedDate
Relationship.1623
Relationship.1624
Entity.1625
Sheet.1626
DatabaseLog
DatabaseLog
Sheet.1627
PK DatabaseLogID PostTime DatabaseUser Event Schema Object TS...
PKDatabaseLogID PostTime DatabaseUser Event Schema Object TSQL XmlEvent
Sheet.1628
Sheet.1629
Schemas
Schemas
Rounded rectangle.293
Purchasing
Purchasing
Rounded rectangle.294
Production
Production
Rounded rectangle.295
HumanResources
HumanResources
Rounded rectangle.302
Person
Person
Rounded rectangle.292
Sales
Sales
Rounded rectangle.288
dbo
dbo
Entity.1636
Sheet.1637
ErrorLog
ErrorLog
Sheet.1638
PK ErrorLogID ErrorTime UserName ErrorNumber ErrorSeverity Er...
PKErrorLogID ErrorTime UserName ErrorNumber ErrorSeverity ErrorState ErrorProcedure ErrorLine ErrorMessage
Lights.1639
Sheet.1640
Trend arrows 2.1641
Status icons.1642
Sheet.1643
Trend arrows 1.1644
Colored shapes.1645
Faces.1646
Sheet.1647
Traffic signal 1.1648
Sheet.1649
Sheet.1650
Sheet.1651
Ratings.1652
Sheet.1653
Traffic signal 2.1654
Sheet.1655
Sheet.1656
Sheet.1657
Filled circles.1658
Sheet.1659
Entity.1660
Sheet.1661
Address
Address
Sheet.1662
PK AddressID U2 AddressLine1 U2 AddressLine2 U2 City FK1,U2 S...
PKAddressIDU2AddressLine1U2AddressLine2U2CityFK1,U2StateProvinceIDU2PostalCodeU1rowguid ModifiedDate
Entity.1663
Sheet.1664
Contact
Contact
Sheet.1665
PK ContactID NameStyle Title FirstName MiddleName LastName Su...
PKContactID NameStyle Title FirstName MiddleName LastName Suffix EmailAddress EmailPromotion Phone PasswordHash PasswordSalt AdditionalContactInfoU1rowguid ModifiedDate
Entity.1666
Sheet.1667
AddressType
AddressType
Sheet.1668
PK AddressTypeID U1 Name U2 rowguid ModifiedDate
PKAddressTypeIDU1NameU2rowguid ModifiedDate
Entity.1669
Sheet.1670
ContactType
ContactType
Sheet.1671
PK ContactTypeID U1 Name ModifiedDate
PKContactTypeIDU1Name ModifiedDate
Entity.1672
Sheet.1673
StateProvince
StateProvince
Sheet.1674
PK StateProvinceID U3 StateProvinceCode FK1,U3 CountryRegionC...
PKStateProvinceIDU3StateProvinceCodeFK1,U3CountryRegionCode IsOnlyStateProvinceFlagU1NameFK2TerritoryIDU2rowguid ModifiedDate
Relationship.1675
Entity.1676
Sheet.1677
CountryRegion
CountryRegion
Sheet.1678
PK CountryRegionCode U1 Name ModifiedDate
PKCountryRegionCodeU1Name ModifiedDate
Relationship.1679
Entity.1680
Sheet.1681
Store
Store
Sheet.1682
PK,FK1 CustomerID Name Demographics U1 rowguid ModifiedDate F...
PK,FK1CustomerID Name DemographicsU1rowguid ModifiedDateFK2SalesPersonID
Entity.1683
Sheet.1684
StoreContact
StoreContact
Sheet.1685
PK,FK3 CustomerID PK,FK1 ContactID FK2 ContactTypeID U1 rowgu...
PK,FK3CustomerIDPK,FK1ContactIDFK2ContactTypeIDU1rowguid ModifiedDate
Relationship.1686
Relationship.1687
Relationship.1688
Entity.1689
Sheet.1690
Individual
Individual
Sheet.1691
PK,FK2 CustomerID FK1 ContactID Demographics ModifiedDate
PK,FK2CustomerIDFK1ContactID Demographics ModifiedDate
Relationship.1692
Entity.1693
Sheet.1694
Customer
Customer
Sheet.1695
PK CustomerID FK1 TerritoryID U1 AccountNumber CustomerType U...
PKCustomerIDFK1TerritoryIDU1AccountNumber CustomerTypeU2rowguid ModifiedDate
Relationship.1696
Relationship.1697
Entity.1698
Sheet.1699
CustomerAddress
CustomerAddress
Sheet.1700
PK,FK3 CustomerID PK,FK1 AddressID FK2 AddressTypeID U1 rowgu...
PK,FK3CustomerIDPK,FK1AddressIDFK2AddressTypeIDU1rowguid ModifiedDate
Relationship.1701
Relationship.1702
Relationship.1703
Entity.1704
Sheet.1705
SalesTerritory
SalesTerritory
Sheet.1706
PK TerritoryID U1 Name CountryRegionCode Group SalesYTD Sales...
PKTerritoryIDU1Name CountryRegionCode Group SalesYTD SalesLastYear CostYTD CostLastYearU2rowguid ModifiedDate
Relationship.1707
Relationship.1708
Entity.1709
Sheet.1710
SalesTerritoryHistory
SalesTerritoryHistory
Sheet.1711
PK,FK1 SalesPersonID PK,FK2 TerritoryID PK StartDate EndDate ...
PK,FK1SalesPersonIDPK,FK2TerritoryIDPKStartDate EndDateU1rowguid ModifiedDate
Relationship.1712
Entity.1713
Sheet.1714
SalesPersonQuotaHistory
SalesPersonQuotaHistory
Sheet.1715
PK,FK1 SalesPersonID PK QuotaDate SalesQuota U1 rowguid Modif...
PK,FK1SalesPersonIDPKQuotaDate SalesQuotaU1rowguid ModifiedDate
Entity.1716
Sheet.1717
SalesPerson
SalesPerson
Sheet.1718
PK,FK1 SalesPersonID FK2 TerritoryID SalesQuota Bonus Commiss...
PK,FK1SalesPersonIDFK2TerritoryID SalesQuota Bonus CommissionPct SalesYTD SalesLastYearU1rowguid ModifiedDate
Relationship.1719
Relationship.1720
Relationship.1721
Entity.1722
Sheet.1723
ContactCreditCard
ContactCreditCard
Sheet.1724
PK,FK2 ContactID PK,FK1 CreditCardID ModifiedDate
PK,FK2ContactIDPK,FK1CreditCardID ModifiedDate
Relationship.1725
Entity.1726
Sheet.1727
SalesOrderHeader
SalesOrderHeader
Sheet.1728
PK SalesOrderID RevisionNumber OrderDate DueDate ShipDate Sta...
PKSalesOrderID RevisionNumber OrderDate DueDate ShipDate Status OnlineOrderFlagU2SalesOrderNumber PurchaseOrderNumber AccountNumberFK6CustomerIDFK3ContactIDFK7SalesPersonIDFK8TerritoryIDFK1BillToAddressIDFK2ShipToAddressIDFK4ShipMethodID CreditCardApprovalCodeFK5CurrencyRateID SubTotal TaxAmt Freight TotalDue CommentU1rowguid ModifiedDateFK9CreditCardID
Relationship.1729
Relationship.1730
Relationship.1731
Relationship.1732
Relationship.1733
Relationship.1734
Entity.1735
Sheet.1736
SalesOrderHeaderSalesReason
SalesOrderHeaderSalesReason
Sheet.1737
PK,FK1 SalesOrderID PK,FK2 SalesReasonID ModifiedDate
PK,FK1SalesOrderIDPK,FK2SalesReasonID ModifiedDate
Relationship.1738
Entity.1739
Sheet.1740
SalesTaxRate
SalesTaxRate
Sheet.1741
PK SalesTaxRateID FK1,U2 StateProvinceID U2 TaxType TaxRate N...
PKSalesTaxRateIDFK1,U2StateProvinceIDU2TaxType TaxRate NameU1rowguid ModifiedDate
Relationship.1742
Entity.1743
Sheet.1744
ShoppingCartItem
ShoppingCartItem
Sheet.1745
PK ShoppingCartItemID ShoppingCartID Quantity FK1 ProductID D...
PKShoppingCartItemID ShoppingCartID QuantityFK1ProductID DateCreated ModifiedDate
Entity.1746
Sheet.1747
Product
Product
Sheet.1748
PK ProductID U1 Name U2 ProductNumber MakeFlag FinishedGoodsF...
PKProductIDU1NameU2ProductNumber MakeFlag FinishedGoodsFlag Color SafetyStockLevel ReorderPoint StandardCost ListPrice SizeFK3SizeUnitMeasureCodeFK4WeightUnitMeasureCode Weight DaysToManufacture ProductLine Class StyleFK2ProductSubcategoryIDFK1ProductModelID SellStartDate SellEndDate DiscontinuedDateU3rowguid ModifiedDate
Relationship.1749
Entity.1750
Sheet.1751
SalesOrderDetail
SalesOrderDetail
Sheet.1752
PK,FK1 SalesOrderID PK SalesOrderDetailID CarrierTrackingNumb...
PK,FK1SalesOrderIDPKSalesOrderDetailID CarrierTrackingNumber OrderQtyFK2ProductIDFK2SpecialOfferID UnitPrice UnitPriceDiscount LineTotalU1rowguid ModifiedDate
Relationship.1753
Entity.1754
Sheet.1755
Currency
Currency
Sheet.1756
PK CurrencyCode U1 Name ModifiedDate
PKCurrencyCodeU1Name ModifiedDate
Entity.1757
Sheet.1758
CurrencyRate
CurrencyRate
Sheet.1759
PK CurrencyRateID U1 CurrencyRateDate FK1,U1 FromCurrencyCode...
PKCurrencyRateIDU1CurrencyRateDateFK1,U1FromCurrencyCodeFK2,U1ToCurrencyCode AverageRate EndOfDayRate ModifiedDate
Relationship.1760
Relationship.1761
Relationship.1762
Entity.1763
Sheet.1764
CreditCard
CreditCard
Sheet.1765
PK CreditCardID CardType U1 CardNumber ExpMonth ExpYear Modif...
PKCreditCardID CardTypeU1CardNumber ExpMonth ExpYear ModifiedDate
Relationship.1766
Relationship.1767
Entity.1768
Sheet.1769
SalesReason
SalesReason
Sheet.1770
PK SalesReasonID Name ReasonType ModifiedDate
PKSalesReasonID Name ReasonType ModifiedDate
Relationship.1771
Entity.1772
Sheet.1773
SpecialOffer
SpecialOffer
Sheet.1774
PK SpecialOfferID Description DiscountPct Type Category Start...
PKSpecialOfferID Description DiscountPct Type Category StartDate EndDate MinQty MaxQtyU1rowguid ModifiedDate
Entity.1775
Sheet.1776
SpecialOfferProduct
SpecialOfferProduct
Sheet.1777
PK,FK2 SpecialOfferID PK,FK1 ProductID U1 rowguid ModifiedDate
PK,FK2SpecialOfferIDPK,FK1ProductIDU1rowguid ModifiedDate
Relationship.1778
Relationship.1779
Relationship.1780
Entity.1781
Sheet.1782
ProductListPriceHistory
ProductListPriceHistory
Sheet.1783
PK,FK1 ProductID PK StartDate EndDate ListPrice ModifiedDate
PK,FK1ProductIDPKStartDate EndDate ListPrice ModifiedDate
Relationship.1784
Entity.1785
Sheet.1786
ProductReview
ProductReview
Sheet.1787
PK ProductReviewID FK1 ProductID ReviewerName ReviewDate Emai...
PKProductReviewIDFK1ProductID ReviewerName ReviewDate EmailAddress Rating Comments ModifiedDate
Relationship.1788
Entity.1789
Sheet.1790
BillOfMaterials
BillOfMaterials
Sheet.1791
PK BillOfMaterialsID FK1,U1 ProductAssemblyID FK2,U1 Componen...
PKBillOfMaterialsIDFK1,U1ProductAssemblyIDFK2,U1ComponentIDU1StartDate EndDateFK3UnitMeasureCode BOMLevel PerAssemblyQty ModifiedDate
Relationship.1792
Relationship.1793
Entity.1794
Sheet.1795
ProductPhoto
ProductPhoto
Sheet.1796
PK ProductPhotoID ThumbNailPhoto ThumbnailPhotoFileName Large...
PKProductPhotoID ThumbNailPhoto ThumbnailPhotoFileName LargePhoto LargePhotoFileName ModifiedDate
Entity.1797
Sheet.1798
ProductProductPhoto
ProductProductPhoto
Sheet.1799
PK,FK1 ProductID PK,FK2 ProductPhotoID Primary ModifiedDate
PK,FK1ProductIDPK,FK2ProductPhotoID Primary ModifiedDate
Relationship.1800
Relationship.1801
Entity.1802
Sheet.1803
ProductSubcategory
ProductSubcategory
Sheet.1804
PK ProductSubcategoryID FK1 ProductCategoryID U1 Name U2 rowg...
PKProductSubcategoryIDFK1ProductCategoryIDU1NameU2rowguid ModifiedDate
Relationship.1805
Entity.1806
Sheet.1807
ProductCategory
ProductCategory
Sheet.1808
PK ProductCategoryID U1 Name U2 rowguid ModifiedDate
PKProductCategoryIDU1NameU2rowguid ModifiedDate
Relationship.1809
Entity.1810
Sheet.1811
ProductDocument
ProductDocument
Sheet.1812
PK,FK2 ProductID PK,FK1 DocumentID ModifiedDate
PK,FK2ProductIDPK,FK1DocumentID ModifiedDate
Relationship.1813
Entity.1814
Sheet.1815
ProductModel
ProductModel
Sheet.1816
PK ProductModelID U1 Name CatalogDescription Instructions U2 ...
PKProductModelIDU1Name CatalogDescription InstructionsU2rowguid ModifiedDate
Relationship.1817
Entity.1818
Sheet.1819
ProductModelIllustration
ProductModelIllustration
Sheet.1820
PK,FK2 ProductModelID PK,FK1 IllustrationID ModifiedDate
PK,FK2ProductModelIDPK,FK1IllustrationID ModifiedDate
Relationship.1821
Entity.1822
Sheet.1823
Illustration
Illustration
Sheet.1824
PK IllustrationID Diagram ModifiedDate
PKIllustrationID Diagram ModifiedDate
Relationship.1825
Entity.1826
Sheet.1827
ProductModelProductDescriptionCulture
ProductModelProductDescriptionCulture
Sheet.1828
PK,FK3 ProductModelID PK,FK2 ProductDescriptionID PK,FK1 Cult...
PK,FK3ProductModelIDPK,FK2ProductDescriptionIDPK,FK1CultureID ModifiedDate
Relationship.1829
Entity.1830
Sheet.1831
ProductDescription
ProductDescription
Sheet.1832
PK ProductDescriptionID Description U1 rowguid ModifiedDate
PKProductDescriptionID DescriptionU1rowguid ModifiedDate
Relationship.1833
Entity.1834
Sheet.1835
Culture
Culture
Sheet.1836
PK CultureID U1 Name ModifiedDate
PKCultureIDU1Name ModifiedDate
Relationship.1837
Entity.1838
Sheet.1839
UnitMeasure
UnitMeasure
Sheet.1840
PK UnitMeasureCode U1 Name ModifiedDate
PKUnitMeasureCodeU1Name ModifiedDate
Relationship.1841
Relationship.1842
Relationship.1843
Entity.1844
Sheet.1845
WorkOrderRouting
WorkOrderRouting
Sheet.1846
PK,FK2 WorkOrderID PK ProductID PK OperationSequence FK1 Loca...
PK,FK2WorkOrderIDPKProductIDPKOperationSequenceFK1LocationID ScheduledStartDate ScheduledEndDate ActualStartDate ActualEndDate ActualResourceHrs PlannedCost ActualCost ModifiedDate
Entity.1847
Sheet.1848
ProductInventory
ProductInventory
Sheet.1849
PK,FK2 ProductID PK,FK1 LocationID Shelf Bin Quantity rowguid...
PK,FK2ProductIDPK,FK1LocationID Shelf Bin Quantity rowguid ModifiedDate
Relationship.1850
Entity.1851
Sheet.1852
Location
Location
Sheet.1853
PK LocationID U1 Name CostRate Availability ModifiedDate
PKLocationIDU1Name CostRate Availability ModifiedDate
Relationship.1854
Relationship.1855
Entity.1856
Sheet.1857
ProductCostHistory
ProductCostHistory
Sheet.1858
PK,FK1 ProductID PK StartDate EndDate StandardCost ModifiedDate
PK,FK1ProductIDPKStartDate EndDate StandardCost ModifiedDate
Relationship.1859
Entity.1860
Sheet.1861
WorkOrder
WorkOrder
Sheet.1862
PK WorkOrderID FK1 ProductID OrderQty StockedQty ScrappedQty ...
PKWorkOrderIDFK1ProductID OrderQty StockedQty ScrappedQty StartDate EndDate DueDateFK2ScrapReasonID ModifiedDate
Relationship.1863
Relationship.1864
Entity.1865
Sheet.1866
ScrapReason
ScrapReason
Sheet.1867
PK ScrapReasonID U1 Name ModifiedDate
PKScrapReasonIDU1Name ModifiedDate
Relationship.1868
Entity.1869
Sheet.1870
TransactionHistory
TransactionHistory
Sheet.1871
PK TransactionID FK1 ProductID ReferenceOrderID TransactionDa...
PKTransactionIDFK1ProductID ReferenceOrderID TransactionDate TransactionType Quantity ActualCost ModifiedDate ReferenceOrderLineID
Entity.1872
Sheet.1873
TransactionHistoryArchive
TransactionHistoryArchive
Sheet.1874
PK TransactionID ProductID ReferenceOrderID TransactionDate T...
PKTransactionID ProductID ReferenceOrderID TransactionDate TransactionType Quantity ActualCost ModifiedDate ReferenceOrderLineID
Relationship.1875
Entity.1876
Sheet.1877
Document
Document
Sheet.1878
PK DocumentID Title U1 FileName FileExtension U1 Revision Cha...
PKDocumentID TitleU1FileName FileExtensionU1Revision ChangeNumber Status DocumentSummary Document ModifiedDate
Relationship.1879
Entity.1880
Sheet.1881
PurchaseOrderDetail
PurchaseOrderDetail
Sheet.1882
PK,FK2 ShipMethodID PK,FK2 PurchaseOrderID PK PurchaseOrderDe...
PK,FK2ShipMethodIDPK,FK2PurchaseOrderIDPKPurchaseOrderDetailID DueDate OrderQtyFK1ProductID UnitPrice LineTotal ReceivedQty RejectedQty StockedQty ModifiedDate
Relationship.1883
Entity.1884
Sheet.1885
PurchaseOrderHeader
PurchaseOrderHeader
Sheet.1886
PK PurchaseOrderID PK,FK3 ShipMethodID RevisionNumber Status ...
PKPurchaseOrderIDPK,FK3ShipMethodID RevisionNumber StatusFK1EmployeeIDFK2VendorID OrderDate ShipDate SubTotal TaxAmt Freight TotalDue ModifiedDate
Relationship.1887
Entity.1888
Sheet.1889
Vendor
Vendor
Sheet.1890
PK VendorID U1 AccountNumber Name CreditRating PreferredVendo...
PKVendorIDU1AccountNumber Name CreditRating PreferredVendorStatus ActiveFlag PurchasingWebServiceURL ModifiedDate
Relationship.1891
Entity.1892
Sheet.1893
VendorAddress
VendorAddress
Sheet.1894
PK,FK3 VendorID PK,FK1 AddressID FK2 AddressTypeID ModifiedDate
PK,FK3VendorIDPK,FK1AddressIDFK2AddressTypeID ModifiedDate
Relationship.1895
Relationship.1896
Relationship.1897
Entity.1898
Sheet.1899
VendorContact
VendorContact
Sheet.1900
PK,FK3 VendorID PK,FK1 ContactID FK2 ContactTypeID ModifiedDate
PK,FK3VendorIDPK,FK1ContactIDFK2ContactTypeID ModifiedDate
Relationship.1901
Relationship.1902
Relationship.1903
Entity.1904
Sheet.1905
ShipMethod
ShipMethod
Sheet.1906
PK ShipMethodID U1 Name ShipBase ShipRate U2 rowguid Modified...
PKShipMethodIDU1Name ShipBase ShipRateU2rowguid ModifiedDate
Relationship.1907
Relationship.1908
Entity.1909
Sheet.1910
ProductVendor
ProductVendor
Sheet.1911
PK,FK1 ProductID PK,FK3 VendorID AverageLeadTime StandardPric...
PK,FK1ProductIDPK,FK3VendorID AverageLeadTime StandardPrice LastReceiptCost LastReceiptDate MinOrderQty MaxOrderQty OnOrderQtyFK2UnitMeasureCode ModifiedDate
Relationship.1912
Relationship.1913
Relationship.1914
Entity.1915
Sheet.1916
AWBuildVersion
AWBuildVersion
Sheet.1917
PK SystemInformationID Database Version VersionDate ModifiedD...
PKSystemInformationID Database Version VersionDate ModifiedDate
Entity.1918
Sheet.1919
Employee
Employee
Sheet.1920
PK EmployeeID U2 NationalIDNumber FK2 ContactID U1 LoginID FK...
PKEmployeeIDU2NationalIDNumberFK2ContactIDU1LoginIDFK1ManagerID ShiftID Title BirthDate MaritalStatus Gender HireDate SalariedFlag VacationHours SickLeaveHours CurrentFlagU3rowguid ModifiedDate
Relationship.1921
Relationship.1922
Relationship.1923
Relationship.1924
Entity.1925
Sheet.1926
EmployeeDepartmentHistory
EmployeeDepartmentHistory
Sheet.1927
PK,FK2 EmployeeID PK,FK1 DepartmentID PK StartDate PK,FK3 Shi...
PK,FK2EmployeeIDPK,FK1DepartmentIDPKStartDatePK,FK3ShiftID EndDate ModifiedDate
Relationship.1928
Entity.1929
Sheet.1930
Department
Department
Sheet.1931
PK DepartmentID U1 Name GroupName ModifiedDate
PKDepartmentIDU1Name GroupName ModifiedDate
Relationship.1932
Entity.1933
Sheet.1934
JobCandidate
JobCandidate
Sheet.1935
PK JobCandidateID FK1 EmployeeID Resume ModifiedDate
PKJobCandidateIDFK1EmployeeID Resume ModifiedDate
Relationship.1936
Entity.1937
Sheet.1938
Shift
Shift
Sheet.1939
PK ShiftID U1 Name U2 StartTime U2 EndTime ModifiedDate
PKShiftIDU1NameU2StartTimeU2EndTime ModifiedDate
Entity.1940
Sheet.1941
EmployeePayHistory
EmployeePayHistory
Sheet.1942
PK,FK1 EmployeeID PK RateChangeDate Rate PayFrequency Modifie...
PK,FK1EmployeeIDPKRateChangeDate Rate PayFrequency ModifiedDate
Relationship.1943
Relationship.1944
Relationship.1945
Entity.1946
Sheet.1947
EmployeeAddress
EmployeeAddress
Sheet.1948
PK,FK1 EmployeeID PK,FK2 AddressID U1 rowguid ModifiedDate
PK,FK1EmployeeIDPK,FK2AddressIDU1rowguid ModifiedDate
Relationship.1949
Relationship.1950
Entity.1951
Sheet.1952
DatabaseLog
DatabaseLog
Sheet.1953
PK DatabaseLogID PostTime DatabaseUser Event Schema Object TS...
PKDatabaseLogID PostTime DatabaseUser Event Schema Object TSQL XmlEvent
Sheet.1954
Sheet.1955
Schemas
Schemas
Rounded rectangle.293
Purchasing
Purchasing
Rounded rectangle.294
Production
Production
Rounded rectangle.295
HumanResources
HumanResources
Rounded rectangle.302
Person
Person
Rounded rectangle.292
Sales
Sales
Rounded rectangle.288
dbo
dbo
Entity.1962
Sheet.1963
ErrorLog
ErrorLog
Sheet.1964
PK ErrorLogID ErrorTime UserName ErrorNumber ErrorSeverity Er...
PKErrorLogID ErrorTime UserName ErrorNumber ErrorSeverity ErrorState ErrorProcedure ErrorLine ErrorMessage
Lights.1965
Sheet.1966
Trend arrows 2.1967
Status icons.1968
Sheet.1969
Trend arrows 1.1970
Colored shapes.1971
Faces.1972
Sheet.1973
Traffic signal 1.1974
Sheet.1975
Sheet.1976
Sheet.1977
Ratings.1978
Sheet.1979
Traffic signal 2.1980
Sheet.1981
Sheet.1982
Sheet.1983
Filled circles.1984
Sheet.1985