AdventureWorks OLTP Schema November 2005 Sales SalesPersonQuotaHistory PK,FK1 U1 PK DatabaseLog ErrorLogID PK Er
Views 123 Downloads 78 File size 34KB
AdventureWorks OLTP Schema November 2005
Sales SalesPersonQuotaHistory
PK,FK1
U1
PK
DatabaseLog
ErrorLogID
PK
ErrorTime UserName ErrorNumber ErrorSeverity ErrorState ErrorProcedure ErrorLine ErrorMessage
AWBuildVersion SystemInformationID Database Version VersionDate ModifiedDate
SalesPersonID TerritoryID StartDate
U1
DatabaseLogID PostTime DatabaseUser Event Schema Object TSQL XmlEvent
EndDate rowguid ModifiedDate
U1
PK
PK
TerritoryID
U1
Name CountryRegionCode Group SalesYTD SalesLastYear CostYTD CostLastYear rowguid ModifiedDate
PK
CustomerID
FK1 U1
TerritoryID AccountNumber CustomerType rowguid ModifiedDate
U2
CustomerAddress
U1
Name GroupName ModifiedDate
EmployeeDepartmentHistory EmployeeID DepartmentID StartDate ShiftID
CustomerID AddressID
FK2 U1
AddressTypeID rowguid ModifiedDate
U1 FK9
PK,FK2
CustomerID
FK1
ContactID Demographics ModifiedDate
Person
Shift PK
ShiftID
U1 U2 U2
Name StartTime EndTime ModifiedDate
U2 FK2 U1 FK1
NationalIDNumber ContactID LoginID ManagerID ShiftID Title BirthDate MaritalStatus Gender HireDate SalariedFlag VacationHours SickLeaveHours CurrentFlag rowguid ModifiedDate
JobCandidate PK
JobCandidateID
FK1
EmployeeID Resume ModifiedDate
U3
SalesReason
CurrencyRate PK
CurrencyRateID
U1 CurrencyRateDate FK1,U1 FromCurrencyCode FK2,U1 ToCurrencyCode AverageRate EndOfDayRate ModifiedDate
PK
CurrencyCode
U1
Name ModifiedDate
PK
Contact PK
Store PK,FK1
CustomerID
U1
Name Demographics rowguid ModifiedDate SalesPersonID
FK2
U1
PK,FK1 PK
SalesTaxRate PK
SalesTaxRateID
FK1,U2 StateProvinceID U2 TaxType TaxRate Name U1 rowguid ModifiedDate
PK
ShoppingCartItemID
FK1
ShoppingCartID Quantity ProductID DateCreated ModifiedDate
rowguid ModifiedDate
NameStyle Title FirstName MiddleName LastName Suffix EmailAddress EmailPromotion Phone PasswordHash PasswordSalt AdditionalContactInfo rowguid ModifiedDate
Address PK
AddressID
U2 U2 U2 FK1,U2 U2 U1
AddressLine1 AddressLine2 City StateProvinceID PostalCode rowguid ModifiedDate
PK,FK3 PK,FK1
CustomerID ContactID
FK2 U1
ContactTypeID rowguid ModifiedDate
ContactType
U1
AddressType
ContactTypeID Name ModifiedDate
PK
AddressTypeID
PK
CountryRegionCode
U1
Name ModifiedDate
PK,FK1 PK
PK,FK2 PK,FK1
SpecialOfferID ProductID
U1
rowguid ModifiedDate
ProductReview PK
ProductReviewID
FK1
ProductID ReviewerName ReviewDate EmailAddress Rating Comments ModifiedDate
EndDate ListPrice ModifiedDate
U1 U2
Name rowguid ModifiedDate
PK
ProductID
U1 U2
Name ProductNumber MakeFlag FinishedGoodsFlag Color SafetyStockLevel ReorderPoint StandardCost ListPrice Size SizeUnitMeasureCode WeightUnitMeasureCode Weight DaysToManufacture ProductLine Class Style ProductSubcategoryID ProductModelID SellStartDate SellEndDate DiscontinuedDate rowguid ModifiedDate
BillOfMaterialsID
FK3 FK4
UnitMeasure UnitMeasureCode U3
Schemas
PurchaseOrderHeader PK PK,FK3
FK1 FK2
PurchaseOrderID ShipMethodID RevisionNumber Status EmployeeID VendorID OrderDate ShipDate SubTotal TaxAmt Freight TotalDue ModifiedDate
Name ShipBase ShipRate rowguid ModifiedDate
VendorID ContactID
U1
FK2
ContactTypeID ModifiedDate
U2
Vendor
Purchasing
ShipMethodID
PK,FK3 PK,FK1
VendorAddress
Sales
PK
PK
VendorID
U1
AccountNumber Name CreditRating PreferredVendorStatus ActiveFlag PurchasingWebServiceURL ModifiedDate
PK,FK3 PK,FK1
VendorID AddressID
FK2
AddressTypeID ModifiedDate
FK2
dbo FK1
ShipMethodID PurchaseOrderID PurchaseOrderDetailID DueDate OrderQty ProductID UnitPrice LineTotal ReceivedQty RejectedQty StockedQty ModifiedDate
ProductID VendorID AverageLeadTime StandardPrice LastReceiptCost LastReceiptDate MinOrderQty MaxOrderQty OnOrderQty UnitMeasureCode ModifiedDate
TransactionID
PK
IllustrationID
ModifiedDate
Diagram ModifiedDate
ProductProductPhoto PK,FK1 PK,FK2
ProductID ProductPhotoID
ProductModel PK
ProductModelID
U1
Name CatalogDescription Instructions rowguid ModifiedDate
U2
ProductModelProductDescriptionCulture PK,FK3 PK,FK2 PK,FK1
ProductModelID ProductDescriptionID CultureID ModifiedDate
ProductSubcategory PK
ProductSubcategoryID
FK1 U1 U2
ProductCategoryID Name rowguid ModifiedDate
ProductCategory PK
ProductCategoryID
U1 U2
Name rowguid ModifiedDate
ProductDescription PK
ProductDescriptionID
U1
Description rowguid ModifiedDate
ProductDocument PK,FK2 PK,FK1
ProductCostHistory PK,FK1 PK
ProductID StartDate
Culture PK
CultureID
U1
Name ModifiedDate
ProductID DocumentID ModifiedDate
EndDate StandardCost ModifiedDate
WorkOrderRouting
ProductInventory
TransactionHistory
FK1
PK,FK1 PK,FK3
PK,FK2 PK,FK2 PK
Name ModifiedDate
PK
ProductVendor
PurchaseOrderDetail
U1
Illustration
ProductModelID IllustrationID
Product
FK2 FK1
PK
ProductPhotoID
Primary ModifiedDate
BillOfMaterials PK
PK,FK2 PK,FK1
ThumbNailPhoto ThumbnailPhotoFileName LargePhoto LargePhotoFileName ModifiedDate
ProductID StartDate
FK1,U1 ProductAssemblyID FK2,U1 ComponentID U1 StartDate EndDate FK3 UnitMeasureCode BOMLevel PerAssemblyQty ModifiedDate
VendorContact
HumanResources
U1
ProductListPriceHistory
ShipMethod
Production
SpecialOfferProduct
ProductPhoto
U3 StateProvinceCode FK1,U3 CountryRegionCode IsOnlyStateProvinceFlag U1 Name FK2 TerritoryID U2 rowguid ModifiedDate
ContactID
Purchasing
Person
SalesOrderID SalesOrderDetailID
ProductModelIllustration
EmployeeAddress
U1
U1
CarrierTrackingNumber OrderQty ProductID SpecialOfferID UnitPrice UnitPriceDiscount LineTotal rowguid ModifiedDate
FK2 FK2
ShoppingCartItem
StateProvinceID
CountryRegion
EmployeeID RateChangeDate
EmployeeID AddressID
Name ReasonType ModifiedDate
SalesOrderDetail
PK
PK
PK,FK1 PK,FK2
SalesReasonID
StateProvince
EmployeePayHistory
Rate PayFrequency ModifiedDate
PK
Currency
StoreContact
PK,FK1 PK
Description DiscountPct Type Category StartDate EndDate MinQty MaxQty rowguid ModifiedDate
Production
Employee EmployeeID
SpecialOfferID
Individual
EndDate ModifiedDate
PK
PK
ModifiedDate
RevisionNumber OrderDate DueDate ShipDate Status OnlineOrderFlag SalesOrderNumber PurchaseOrderNumber AccountNumber CustomerID ContactID SalesPersonID TerritoryID BillToAddressID ShipToAddressID ShipMethodID CreditCardApprovalCode CurrencyRateID SubTotal TaxAmt Freight TotalDue Comment rowguid ModifiedDate CreditCardID
FK5 PK,FK3 PK,FK1
SpecialOffer
SalesOrderID
FK6 FK3 FK7 FK8 FK1 FK2 FK4
Customer
CardType CardNumber ExpMonth ExpYear ModifiedDate
SalesOrderID SalesReasonID
SalesOrderHeader
Department
PK,FK2 PK,FK1 PK PK,FK3
PK,FK1 PK,FK2
SalesTerritory
U2
DepartmentID
SalesQuota rowguid ModifiedDate
CreditCardID
U1
SalesOrderHeaderSalesReason
U2
HumanResources PK
PK
ContactID CreditCardID ModifiedDate
TerritoryID SalesQuota Bonus CommissionPct SalesYTD SalesLastYear rowguid ModifiedDate
SalesTerritoryHistory
dbo
SalesPersonID QuotaDate
PK,FK2 PK,FK1
SalesPersonID
FK2
PK,FK1 PK,FK2 PK PK
PK,FK1 PK
SalesPerson
Best Print Results if: 11X17 paper Samples and Sample Databases at Landscape http://CodePlex.com/SqlServerSamples Fit to 1 sheet
ErrorLog
CreditCard
ContactCreditCard
PK,FK2 PK,FK1
ProductID ReferenceOrderID TransactionDate TransactionType Quantity ActualCost ModifiedDate ReferenceOrderLineID
ProductID LocationID Shelf Bin Quantity rowguid ModifiedDate
PK,FK2 PK PK
WorkOrderID ProductID OperationSequence
FK1
LocationID ScheduledStartDate ScheduledEndDate ActualStartDate ActualEndDate ActualResourceHrs PlannedCost ActualCost ModifiedDate
Location PK
LocationID
U1
Name CostRate Availability ModifiedDate
Document PK
U1 U1
DocumentID Title FileName FileExtension Revision ChangeNumber Status DocumentSummary Document ModifiedDate
ScrapReason
WorkOrder PK
WorkOrderID
PK
ScrapReasonID
FK1
ProductID OrderQty StockedQty ScrappedQty StartDate EndDate DueDate ScrapReasonID ModifiedDate
U1
Name ModifiedDate
FK2
TransactionHistoryArchive PK
TransactionID ProductID ReferenceOrderID TransactionDate TransactionType Quantity ActualCost ModifiedDate ReferenceOrderLineID