AdventureWorks 2008 OLTP Schema - Jeff Pries

AdventureWorks 2008

OLTP Schema

Sales

SalesPerson

Rev 10.00.0009

PK,FK1

Best Print Results if:

11X17 paper

Samples and Sample Databases at

Landscape



Fit to 1 sheet

dbo

PK

DatabaseLog

ErrorLogID

PK

ErrorTime

UserName

ErrorNumber

ErrorSeverity

ErrorState

ErrorProcedure

ErrorLine

ErrorMessage

AWBuildVersion

PK

PK,FK1

PK

BusinessEntityID

QuotaDate

U1

SalesQuota

rowguid

ModifiedDate

SalesTerritoryHistory

ErrorLog

SystemInformationID

Database Version

VersionDate

ModifiedDate

FK2

SalesPersonQuotaHistory

PK,FK1

PK,FK2

PK

BusinessEntityID

TerritoryID

StartDate

U1

EndDate

rowguid

ModifiedDate

SalesOrderHeader

TerritoryID

SalesQuota

Bonus

CommissionPct

SalesYTD

SalesLastYear

rowguid

ModifiedDate

U1

SalesTerritory

DatabaseLogID

PostTime

DatabaseUser

Event

Schema

Object

TSQL

XmlEvent

CurrencyRate

BusinessEntityID

PK

U1

Customer

U2

Store

PK

CustomerID

PK,FK5

PK

BusinessEntityID

SalesOrderID

FK7

ShipMethodID

RevisionNumber

OrderDate

DueDate

ShipDate

Status

OnlineOrderFlag

SalesOrderNumber

PurchaseOrderNumber

AccountNumber

TerritoryID

BillToAddressID

ShipToAddressID

CreditCardID

CreditCardApprovalCode

CurrencyRateID

SubTotal

TaxAmt

Freight

TotalDue

Comment

rowguid

ModifiedDate

U2

TerritoryID

FK6

FK1

FK2

FK8

Name

CountryRegionCode

Group

SalesYTD

SalesLastYear

CostYTD

CostLastYear

rowguid

ModifiedDate

FK4

PK,FK1,FK2 BusinessEntityID

HumanResources

U1

FK2

FK3

FK1

U1

U2

Name

Demographics

rowguid

ModifiedDate

Department

PK

PersonID

StoreID

TerritoryID

AccountNumber

rowguid

ModifiedDate

U1

U1

BusinessEntityID

DepartmentID

StartDate

ShiftID

U1

FK1,U1

FK2,U1

CurrencyRateDate

FromCurrencyCode

ToCurrencyCode

AverageRate

EndOfDayRate

ModifiedDate

Currency

PK

PersonCreditCard

PK,FK2

PK,FK1

Name

GroupName

ModifiedDate

BusinessEntityID

CreditCardID

U1

ModifiedDate

PK

CurrencyCode

U1

Name

ModifiedDate

SpecialOffer

PK

Description

DiscountPct

Type

Category

StartDate

EndDate

MinQty

MaxQty

rowguid

ModifiedDate

PK

SalesReasonID

SalesOrderHeaderSalesReason

PK,FK1

PK,FK1

PK,FK2

Name

ReasonType

ModifiedDate

BusinessEntityID

SalesOrderID

SalesReasonID

U1

ModifiedDate

SalesOrderDetail

PK,FK1

PK,FK1

PK

PK

SalesTaxRateID

FK1,U2

U2

StateProvinceID

TaxType

TaxRate

Name

rowguid

ModifiedDate

BusinessEntityID

SalesOrderID

SalesOrderDetailID

FK2

FK2

ShoppingCartItem

PK

ShoppingCartItemID

CardType

CardNumber

ExpMonth

ExpYear

ModifiedDate

FK1

ShoppingCartID

Quantity

ProductID

DateCreated

ModifiedDate

U1

SpecialOfferProduct

CarrierTrackingNumber

OrderQty

ProductID

SpecialOfferID

UnitPrice

UnitPriceDiscount

LineTotal

rowguid

ModifiedDate

CreditCardID

Person

SpecialOfferID

SalesReason

CreditCard

DepartmentID

EndDate

ModifiedDate

CurrencyRateID

SalesTaxRate

EmployeeDepartmentHistory

PK,FK2

PK,FK1

PK

PK,FK3

PK

U1

PK,FK2

PK,FK1

SpecialOfferID

ProductID

U1

rowguid

ModifiedDate

Production

ProductModelIllustration

Password

Employee

Shift

PK

ShiftID

U1

U2

U2

Name

StartTime

EndTime

ModifiedDate

BusinessEntityID

U2

U1

NationalIDNumber

LoginID

ShiftID

JobTitle

BirthDate

MaritalStatus

Gender

HireDate

SalariedFlag

VacationHours

SickLeaveHours

CurrentFlag

rowguid

ModifiedDate

JobCandidate

PK,FK1

PK

U3

BusinessEntityID

JobCandidateID

PK,FK1

PK,FK1

BusinessEntityID

ProductListPriceHistory

PasswordHash

PasswordSalt

Resume

ModifiedDate

U1

AddressID

U2

U2

U2

FK1,U2

U2

AddressLine1

AddressLine2

City

StateProvinceID

PostalCode

SpatialLocation

rowguid

ModifiedDate

U1

BusinessEntityID

EmallAddress

PersonType

NameStyle

Title

FirstName

MiddleName

LastName

Suffix

EmailPromotion

AdditionalContactInfo

Demographics

rowguid

ModifiedDate

PK,FK1

PK

BusinessEntityID

PhoneNumber

PhoneNumberTypeID

PK

StateProvinceID

U3

FK1,U3

StateProvinceCode

CountryRegionCode

IsOnlyStateProvinceFlag

Name

TerritoryID

rowguid

ModifiedDate

U1

FK2

U2

BusinessEntityID

RateChangeDate

PK,FK3

PK,FK1

BusinessEntityID

PersonID

FK2

ContactTypeID

ModifiedDate

PK

ProductReviewID

FK1

ProductID

ReviewerName

ReviewDate

EmailAddress

Rating

Comments

ModifiedDate

PK

PhoneNumberTypeID

TransactionHistory

ContactType

BusinessEntity

PK

Schemas

PK

ContactTypeID

U1

Name

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

FK3

FK4

PK

AddressTypeID

U1

U2

Name

rowguid

ModifiedDate

CountryRegion

BusinessEntityAddress

PK,FK3

PK,FK2

BusinessEntityID

rowguid

ModifiedDate

FK1

PK

CountryRegionCode

U1

Name

ModifiedDate

PK

TransactionID

FK1

ProductID

ReferenceOrderID

TransactionDate

TransactionType

Quantity

ActualCost

ModifiedDate

ReferenceOrderLineID

AddressID

BusinessEntityID

AddressTypeID

ModifiedDate

FK2

FK1

U3

ThumbNailPhoto

ThumbnailPhotoFileName

LargePhoto

LargePhotoFileName

ModifiedDate

Purchasing

Person

PurchaseOrderHeader

PK

FK1

FK4

Production

HumanResources

PurchaseOrderDetail

PK,FK2

PK

FK1

dbo

PurchaseOrderID

PurchaseOrderDetailID

DueDate

OrderQty

ProductID

UnitPrice

LineTotal

ReceivedQty

RejectedQty

StockedQty

ModifiedDate

PurchaseOrderID

ShipMethodID

VendorID

RevisionNumber

Status

OrderDate

ShipDate

SubTotal

TaxAmt

Freight

TotalDue

ModifiedDate

PK,FK1

BusinessEntityID

U1

AccountNumber

Name

CreditRating

PreferredVendorStatus

ActiveFlag

PurchasingWebServiceURL

ModifiedDate

ShipMethod

UnitMeasureCode

U1

Name

ModifiedDate

PK

ProductSubcategoryID

FK1

U1

U2

ProductCategoryID

Name

rowguid

ModifiedDate

PK,FK1

PK

ProductID

LocationID

Shelf

Bin

Quantity

rowguid

ModifiedDate

ProductCategoryID

U1

U2

Name

rowguid

ModifiedDate

PK,FK2

PK,FK1

ProductModelID

U1

Name

CatalogDescription

Instructions

rowguid

ModifiedDate

ProductModelProductDescriptionCulture

PK,FK3

PK,FK2

PK,FK1

ProductModelID

ProductDescriptionID

CultureID

ModifiedDate

ProductDescription

PK

ProductDescriptionID

U1

Description

rowguid

ModifiedDate

Culture

PK

CultureID

U1

Name

ModifiedDate

ProductID

DocumentNode

ModifiedDate

WorkOrderRouting

PK,FK2

PK

PK

WorkOrderID

ProductID

OperationSequence

FK1

LocationID

ScheduledStartDate

ScheduledEndDate

ActualStartDate

ActualEndDate

ActualResourceHrs

PlannedCost

ActualCost

ModifiedDate

Location

U1

Name

ShipBase

ShipRate

rowguid

ModifiedDate

U1

Name

CostRate

Availability

ModifiedDate

FK2

PK

ProductID

StartDate

ProductInventory

LocationID

WorkOrder

BusinessEntityID

ProductID

AverageLeadTime

StandardPrice

LastReceiptCost

LastReceiptDate

MinOrderQty

MaxOrderQty

OnOrderQty

UnitMeasureCode

ModifiedDate

PK

Document

PK

PK,FK3

PK,FK1

ProductModel

EndDate

StandardCost

ModifiedDate

ShipMethodID

ProductVendor

ProductID

ProductPhotoID

ProductCategory

ProductCostHistory

PK

U2

PK,FK1

PK,FK2

ProductDocument

UnitMeasure

PK

Diagram

ModifiedDate

ProductSubcategory

PK,FK2

PK,FK1

Vendor

IllustrationID

ProductProductPhoto

U2

Sales

Purchasing

PK

ModifiedDate

ProductPhotoID

Product

Name

AddressType

PK

Illustration

ProductModelID

IllustrationID

Primary

ModifiedDate

BillOfMaterialsID

FK1,U1 ProductAssemblyID

FK2,U1 ComponentID

U1

StartDate

EndDate

FK3

UnitMeasureCode

BOMLevel

PerAssemblyQty

ModifiedDate

PhoneNumberType

PK

ProductID

StartDate

EndDate

ListPrice

ModifiedDate

BillOfMaterials

BusinessEntityContact

Rate

PayFrequency

ModifiedDate

ProductPhoto

ProductReview

StateProvince

PersonPhone

PK,FK1

PK

PK,FK2

PK,FK1

PK

BusinessEntityID

EmailAddressID

EmailAddress

EmployeePayHistory

PK,FK1

PK

PK

Person

PK,FK1

PK,FK2

PK,FK1

Address

PK

WorkOrderID

FK1

ProductID

OrderQty

StockedQty

ScrappedQty

StartDate

EndDate

DueDate

ScrapReasonID

ModifiedDate

ScrapReason

PK

ScrapReasonID

U1

Name

ModifiedDate

FK2

PK

FK1

U1

U1

DocumentNode

DocumentLevel

Title

Owner

FolderFlag

FileName

FileExtension

Revision

ChangeNumber

Status

DocumentSummary

Document

rowguid

ModifiedDate

TransactionHistoryArchive

PK

TransactionID

ProductID

ReferenceOrderID

TransactionDate

TransactionType

Quantity

ActualCost

ModifiedDate

ReferenceOrderLineID

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download