Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @startuml
- skinparam linetype ortho
- hide circle
- skinparam roundcorner 20
- title AdventureWorks2017
- Entity dbo.AWBuildVersion #62A9FF {
- * "SystemInformationID" : tinyint
- --
- "Database Version" : nvarchar(25)
- "VersionDate" : datetime
- "ModifiedDate" : datetime
- }
- Entity dbo.DatabaseLog #62A9FF {
- * "DatabaseLogID" : int
- --
- "PostTime" : datetime
- "DatabaseUser" : sysname
- "Event" : sysname
- * "Schema" : sysname
- * "Object" : sysname
- "TSQL" : nvarchar(MAX)
- "XmlEvent" :
- }
- Entity dbo.ErrorLog #62A9FF {
- * "ErrorLogID" : int
- --
- "ErrorTime" : datetime
- "UserName" : sysname
- "ErrorNumber" : int
- * "ErrorSeverity" : int
- * "ErrorState" : int
- * "ErrorProcedure" : nvarchar(126)
- * "ErrorLine" : int
- "ErrorMessage" : nvarchar(4000)
- }
- Entity HumanResources.Department #06DCFB {
- * "DepartmentID" : smallint
- --
- "Name" : Name
- "GroupName" : Name
- "ModifiedDate" : datetime
- }
- Entity HumanResources.Employee #06DCFB {
- * "BusinessEntityID" : int
- --
- "NationalIDNumber" : nvarchar(15)
- "LoginID" : nvarchar(256)
- * "OrganizationNode" : hierarchyid
- * "OrganizationLevel" : smallint
- "JobTitle" : nvarchar(50)
- "BirthDate" : date
- "MaritalStatus" : nchar(1)
- "Gender" : nchar(1)
- "HireDate" : date
- "SalariedFlag" : Flag
- "VacationHours" : smallint
- "SickLeaveHours" : smallint
- "CurrentFlag" : Flag
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity HumanResources.EmployeeDepartmentHistory #06DCFB {
- * "BusinessEntityID" : int
- * "DepartmentID" : smallint
- * "ShiftID" : tinyint
- * "StartDate" : date
- --
- * "EndDate" : date
- "ModifiedDate" : datetime
- }
- Entity HumanResources.EmployeePayHistory #06DCFB {
- * "BusinessEntityID" : int
- * "RateChangeDate" : datetime
- --
- "Rate" : money
- "PayFrequency" : tinyint
- "ModifiedDate" : datetime
- }
- Entity HumanResources.JobCandidate #06DCFB {
- * "JobCandidateID" : int
- --
- * "BusinessEntityID" : int
- * "Resume" : HRResumeSchemaCollection
- "ModifiedDate" : datetime
- }
- Entity HumanResources.Shift #06DCFB {
- * "ShiftID" : tinyint
- --
- "Name" : Name
- "StartTime" : time
- "EndTime" : time
- "ModifiedDate" : datetime
- }
- Entity Person.Address #01FCEF {
- * "AddressID" : int
- --
- "AddressLine1" : nvarchar(60)
- * "AddressLine2" : nvarchar(60)
- "City" : nvarchar(30)
- "StateProvinceID" : int
- "PostalCode" : nvarchar(15)
- * "SpatialLocation" : geography
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Person.AddressType #01FCEF {
- * "AddressTypeID" : int
- --
- "Name" : Name
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Person.BusinessEntity #01FCEF {
- * "BusinessEntityID" : int
- --
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Person.BusinessEntityAddress #01FCEF {
- * "BusinessEntityID" : int
- * "AddressID" : int
- * "AddressTypeID" : int
- --
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Person.BusinessEntityContact #01FCEF {
- * "BusinessEntityID" : int
- * "PersonID" : int
- * "ContactTypeID" : int
- --
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Person.ContactType #01FCEF {
- * "ContactTypeID" : int
- --
- "Name" : Name
- "ModifiedDate" : datetime
- }
- Entity Person.CountryRegion #01FCEF {
- * "CountryRegionCode" : nvarchar(3)
- --
- "Name" : Name
- "ModifiedDate" : datetime
- }
- Entity Person.EmailAddress #01FCEF {
- * "BusinessEntityID" : int
- * "EmailAddressID" : int
- --
- * "EmailAddress" : nvarchar(50)
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Person.Password #01FCEF {
- * "BusinessEntityID" : int
- --
- "PasswordHash" : varchar(128)
- "PasswordSalt" : varchar(10)
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Person.Person #01FCEF {
- * "BusinessEntityID" : int
- --
- "PersonType" : nchar(2)
- "NameStyle" : NameStyle
- * "Title" : nvarchar(8)
- "FirstName" : Name
- * "MiddleName" : Name
- "LastName" : Name
- * "Suffix" : nvarchar(10)
- "EmailPromotion" : int
- * "AdditionalContactInfo" : AdditionalContactInfoSchemaCollection
- * "Demographics" : IndividualSurveySchemaCollection
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Person.PersonPhone #01FCEF {
- * "BusinessEntityID" : int
- * "PhoneNumber" : Phone
- * "PhoneNumberTypeID" : int
- --
- "ModifiedDate" : datetime
- }
- Entity Person.PhoneNumberType #01FCEF {
- * "PhoneNumberTypeID" : int
- --
- "Name" : Name
- "ModifiedDate" : datetime
- }
- Entity Person.StateProvince #01FCEF {
- * "StateProvinceID" : int
- --
- "StateProvinceCode" : nchar(3)
- "CountryRegionCode" : nvarchar(3)
- "IsOnlyStateProvinceFlag" : Flag
- "Name" : Name
- "TerritoryID" : int
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Production.BillOfMaterials #03EBA6 {
- * "BillOfMaterialsID" : int
- --
- * "ProductAssemblyID" : int
- "ComponentID" : int
- "StartDate" : datetime
- * "EndDate" : datetime
- "UnitMeasureCode" : nchar(3)
- "BOMLevel" : smallint
- "PerAssemblyQty" : decimal(8,2)
- "ModifiedDate" : datetime
- }
- Entity Production.Culture #03EBA6 {
- * "CultureID" : nchar(6)
- --
- "Name" : Name
- "ModifiedDate" : datetime
- }
- Entity Production.Document #03EBA6 {
- * "DocumentNode" : hierarchyid
- --
- * "DocumentLevel" : smallint
- "Title" : nvarchar(50)
- "Owner" : int
- "FolderFlag" : bit
- "FileName" : nvarchar(400)
- "FileExtension" : nvarchar(8)
- "Revision" : nchar(5)
- "ChangeNumber" : int
- "Status" : tinyint
- * "DocumentSummary" : nvarchar(MAX)
- * "Document" : varbinary
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Production.Illustration #03EBA6 {
- * "IllustrationID" : int
- --
- * "Diagram" :
- "ModifiedDate" : datetime
- }
- Entity Production.Location #03EBA6 {
- * "LocationID" : smallint
- --
- "Name" : Name
- "CostRate" : smallmoney
- "Availability" : decimal(8,2)
- "ModifiedDate" : datetime
- }
- Entity Production.Product #03EBA6 {
- * "ProductID" : int
- --
- "Name" : Name
- "ProductNumber" : nvarchar(25)
- "MakeFlag" : Flag
- "FinishedGoodsFlag" : Flag
- * "Color" : nvarchar(15)
- "SafetyStockLevel" : smallint
- "ReorderPoint" : smallint
- "StandardCost" : money
- "ListPrice" : money
- * "Size" : nvarchar(5)
- * "SizeUnitMeasureCode" : nchar(3)
- * "WeightUnitMeasureCode" : nchar(3)
- * "Weight" : decimal(8,2)
- "DaysToManufacture" : int
- * "ProductLine" : nchar(2)
- * "Class" : nchar(2)
- * "Style" : nchar(2)
- * "ProductSubcategoryID" : int
- * "ProductModelID" : int
- "SellStartDate" : datetime
- * "SellEndDate" : datetime
- * "DiscontinuedDate" : datetime
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Production.ProductCategory #03EBA6 {
- * "ProductCategoryID" : int
- --
- "Name" : Name
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Production.ProductCostHistory #03EBA6 {
- * "ProductID" : int
- * "StartDate" : datetime
- --
- * "EndDate" : datetime
- "StandardCost" : money
- "ModifiedDate" : datetime
- }
- Entity Production.ProductDescription #03EBA6 {
- * "ProductDescriptionID" : int
- --
- "Description" : nvarchar(400)
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Production.ProductDocument #03EBA6 {
- * "ProductID" : int
- * "DocumentNode" : hierarchyid
- --
- "ModifiedDate" : datetime
- }
- Entity Production.ProductInventory #03EBA6 {
- * "ProductID" : int
- * "LocationID" : smallint
- --
- "Shelf" : nvarchar(10)
- "Bin" : tinyint
- "Quantity" : smallint
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Production.ProductListPriceHistory #03EBA6 {
- * "ProductID" : int
- * "StartDate" : datetime
- --
- * "EndDate" : datetime
- "ListPrice" : money
- "ModifiedDate" : datetime
- }
- Entity Production.ProductModel #03EBA6 {
- * "ProductModelID" : int
- --
- "Name" : Name
- * "CatalogDescription" : ProductDescriptionSchemaCollection
- * "Instructions" : ManuInstructionsSchemaCollection
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Production.ProductModelIllustration #03EBA6 {
- * "ProductModelID" : int
- * "IllustrationID" : int
- --
- "ModifiedDate" : datetime
- }
- Entity Production.ProductModelProductDescriptionCulture #03EBA6 {
- * "ProductModelID" : int
- * "ProductDescriptionID" : int
- * "CultureID" : nchar(6)
- --
- "ModifiedDate" : datetime
- }
- Entity Production.ProductPhoto #03EBA6 {
- * "ProductPhotoID" : int
- --
- * "ThumbNailPhoto" : varbinary
- * "ThumbnailPhotoFileName" : nvarchar(50)
- * "LargePhoto" : varbinary
- * "LargePhotoFileName" : nvarchar(50)
- "ModifiedDate" : datetime
- }
- Entity Production.ProductProductPhoto #03EBA6 {
- * "ProductID" : int
- * "ProductPhotoID" : int
- --
- "Primary" : Flag
- "ModifiedDate" : datetime
- }
- Entity Production.ProductReview #03EBA6 {
- * "ProductReviewID" : int
- --
- "ProductID" : int
- "ReviewerName" : Name
- "ReviewDate" : datetime
- "EmailAddress" : nvarchar(50)
- "Rating" : int
- * "Comments" : nvarchar(3850)
- "ModifiedDate" : datetime
- }
- Entity Production.ProductSubcategory #03EBA6 {
- * "ProductSubcategoryID" : int
- --
- "ProductCategoryID" : int
- "Name" : Name
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Production.ScrapReason #03EBA6 {
- * "ScrapReasonID" : smallint
- --
- "Name" : Name
- "ModifiedDate" : datetime
- }
- Entity Production.TransactionHistory #03EBA6 {
- * "TransactionID" : int
- --
- "ProductID" : int
- "ReferenceOrderID" : int
- "ReferenceOrderLineID" : int
- "TransactionDate" : datetime
- "TransactionType" : nchar(1)
- "Quantity" : int
- "ActualCost" : money
- "ModifiedDate" : datetime
- }
- Entity Production.TransactionHistoryArchive #03EBA6 {
- * "TransactionID" : int
- --
- "ProductID" : int
- "ReferenceOrderID" : int
- "ReferenceOrderLineID" : int
- "TransactionDate" : datetime
- "TransactionType" : nchar(1)
- "Quantity" : int
- "ActualCost" : money
- "ModifiedDate" : datetime
- }
- Entity Production.UnitMeasure #03EBA6 {
- * "UnitMeasureCode" : nchar(3)
- --
- "Name" : Name
- "ModifiedDate" : datetime
- }
- Entity Production.WorkOrder #03EBA6 {
- * "WorkOrderID" : int
- --
- "ProductID" : int
- "OrderQty" : int
- "StockedQty" : int
- "ScrappedQty" : smallint
- "StartDate" : datetime
- * "EndDate" : datetime
- "DueDate" : datetime
- * "ScrapReasonID" : smallint
- "ModifiedDate" : datetime
- }
- Entity Production.WorkOrderRouting #03EBA6 {
- * "WorkOrderID" : int
- * "ProductID" : int
- * "OperationSequence" : smallint
- --
- "LocationID" : smallint
- "ScheduledStartDate" : datetime
- "ScheduledEndDate" : datetime
- * "ActualStartDate" : datetime
- * "ActualEndDate" : datetime
- * "ActualResourceHrs" : decimal(9,4)
- "PlannedCost" : money
- * "ActualCost" : money
- "ModifiedDate" : datetime
- }
- Entity Purchasing.ProductVendor #01F33E {
- * "ProductID" : int
- * "BusinessEntityID" : int
- --
- "AverageLeadTime" : int
- "StandardPrice" : money
- * "LastReceiptCost" : money
- * "LastReceiptDate" : datetime
- "MinOrderQty" : int
- "MaxOrderQty" : int
- * "OnOrderQty" : int
- "UnitMeasureCode" : nchar(3)
- "ModifiedDate" : datetime
- }
- Entity Purchasing.PurchaseOrderDetail #01F33E {
- * "PurchaseOrderID" : int
- * "PurchaseOrderDetailID" : int
- --
- "DueDate" : datetime
- "OrderQty" : smallint
- "ProductID" : int
- "UnitPrice" : money
- "LineTotal" : money
- "ReceivedQty" : decimal(8,2)
- "RejectedQty" : decimal(8,2)
- "StockedQty" : decimal(9,2)
- "ModifiedDate" : datetime
- }
- Entity Purchasing.PurchaseOrderHeader #01F33E {
- * "PurchaseOrderID" : int
- --
- "RevisionNumber" : tinyint
- "Status" : tinyint
- "EmployeeID" : int
- "VendorID" : int
- "ShipMethodID" : int
- "OrderDate" : datetime
- * "ShipDate" : datetime
- "SubTotal" : money
- "TaxAmt" : money
- "Freight" : money
- "TotalDue" : money
- "ModifiedDate" : datetime
- }
- Entity Purchasing.ShipMethod #01F33E {
- * "ShipMethodID" : int
- --
- "Name" : Name
- "ShipBase" : money
- "ShipRate" : money
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Purchasing.Vendor #01F33E {
- * "BusinessEntityID" : int
- --
- "AccountNumber" : AccountNumber
- "Name" : Name
- "CreditRating" : tinyint
- "PreferredVendorStatus" : Flag
- "ActiveFlag" : Flag
- * "PurchasingWebServiceURL" : nvarchar(1024)
- "ModifiedDate" : datetime
- }
- Entity Sales.CountryRegionCurrency #62D0FF {
- * "CountryRegionCode" : nvarchar(3)
- * "CurrencyCode" : nchar(3)
- --
- "ModifiedDate" : datetime
- }
- Entity Sales.CreditCard #62D0FF {
- * "CreditCardID" : int
- --
- "CardType" : nvarchar(50)
- "CardNumber" : nvarchar(25)
- "ExpMonth" : tinyint
- "ExpYear" : smallint
- "ModifiedDate" : datetime
- }
- Entity Sales.Currency #62D0FF {
- * "CurrencyCode" : nchar(3)
- --
- "Name" : Name
- "ModifiedDate" : datetime
- }
- Entity Sales.CurrencyRate #62D0FF {
- * "CurrencyRateID" : int
- --
- "CurrencyRateDate" : datetime
- "FromCurrencyCode" : nchar(3)
- "ToCurrencyCode" : nchar(3)
- "AverageRate" : money
- "EndOfDayRate" : money
- "ModifiedDate" : datetime
- }
- Entity Sales.Customer #62D0FF {
- * "CustomerID" : int
- --
- * "PersonID" : int
- * "StoreID" : int
- * "TerritoryID" : int
- "AccountNumber" : varchar(10)
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Sales.PersonCreditCard #62D0FF {
- * "BusinessEntityID" : int
- * "CreditCardID" : int
- --
- "ModifiedDate" : datetime
- }
- Entity Sales.SalesOrderDetail #62D0FF {
- * "SalesOrderID" : int
- * "SalesOrderDetailID" : int
- --
- * "CarrierTrackingNumber" : nvarchar(25)
- "OrderQty" : smallint
- "ProductID" : int
- "SpecialOfferID" : int
- "UnitPrice" : money
- "UnitPriceDiscount" : money
- "LineTotal" : numeric
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Sales.SalesOrderHeader #62D0FF {
- * "SalesOrderID" : int
- --
- "RevisionNumber" : tinyint
- "OrderDate" : datetime
- "DueDate" : datetime
- * "ShipDate" : datetime
- "Status" : tinyint
- "OnlineOrderFlag" : Flag
- "SalesOrderNumber" : nvarchar(25)
- * "PurchaseOrderNumber" : OrderNumber
- * "AccountNumber" : AccountNumber
- "CustomerID" : int
- * "SalesPersonID" : int
- * "TerritoryID" : int
- "BillToAddressID" : int
- "ShipToAddressID" : int
- "ShipMethodID" : int
- * "CreditCardID" : int
- * "CreditCardApprovalCode" : varchar(15)
- * "CurrencyRateID" : int
- "SubTotal" : money
- "TaxAmt" : money
- "Freight" : money
- "TotalDue" : money
- * "Comment" : nvarchar(128)
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Sales.SalesOrderHeaderSalesReason #62D0FF {
- * "SalesOrderID" : int
- * "SalesReasonID" : int
- --
- "ModifiedDate" : datetime
- }
- Entity Sales.SalesPerson #62D0FF {
- * "BusinessEntityID" : int
- --
- * "TerritoryID" : int
- * "SalesQuota" : money
- "Bonus" : money
- "CommissionPct" : smallmoney
- "SalesYTD" : money
- "SalesLastYear" : money
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Sales.SalesPersonQuotaHistory #62D0FF {
- * "BusinessEntityID" : int
- * "QuotaDate" : datetime
- --
- "SalesQuota" : money
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Sales.SalesReason #62D0FF {
- * "SalesReasonID" : int
- --
- "Name" : Name
- "ReasonType" : Name
- "ModifiedDate" : datetime
- }
- Entity Sales.SalesTaxRate #62D0FF {
- * "SalesTaxRateID" : int
- --
- "StateProvinceID" : int
- "TaxType" : tinyint
- "TaxRate" : smallmoney
- "Name" : Name
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Sales.SalesTerritory #62D0FF {
- * "TerritoryID" : int
- --
- "Name" : Name
- "CountryRegionCode" : nvarchar(3)
- "Group" : nvarchar(50)
- "SalesYTD" : money
- "SalesLastYear" : money
- "CostYTD" : money
- "CostLastYear" : money
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Sales.SalesTerritoryHistory #62D0FF {
- * "BusinessEntityID" : int
- * "TerritoryID" : int
- * "StartDate" : datetime
- --
- * "EndDate" : datetime
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Sales.ShoppingCartItem #62D0FF {
- * "ShoppingCartItemID" : int
- --
- "ShoppingCartID" : nvarchar(50)
- "Quantity" : int
- "ProductID" : int
- "DateCreated" : datetime
- "ModifiedDate" : datetime
- }
- Entity Sales.SpecialOffer #62D0FF {
- * "SpecialOfferID" : int
- --
- "Description" : nvarchar(255)
- "DiscountPct" : smallmoney
- "Type" : nvarchar(50)
- "Category" : nvarchar(50)
- "StartDate" : datetime
- "EndDate" : datetime
- "MinQty" : int
- * "MaxQty" : int
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Sales.SpecialOfferProduct #62D0FF {
- * "SpecialOfferID" : int
- * "ProductID" : int
- --
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- Entity Sales.Store #62D0FF {
- * "BusinessEntityID" : int
- --
- "Name" : Name
- * "SalesPersonID" : int
- * "Demographics" : StoreSurveySchemaCollection
- "rowguid" : uniqueidentifier
- "ModifiedDate" : datetime
- }
- HumanResources.Employee - Person.Person
- HumanResources.EmployeeDepartmentHistory - HumanResources.Department
- HumanResources.EmployeeDepartmentHistory - HumanResources.Employee
- HumanResources.EmployeeDepartmentHistory - HumanResources.Shift
- HumanResources.EmployeePayHistory - HumanResources.Employee
- HumanResources.JobCandidate - HumanResources.Employee
- Person.Address - Person.StateProvince
- Person.BusinessEntityAddress - Person.Address
- Person.BusinessEntityAddress - Person.AddressType
- Person.BusinessEntityAddress - Person.BusinessEntity
- Person.BusinessEntityContact - Person.BusinessEntity
- Person.BusinessEntityContact - Person.ContactType
- Person.BusinessEntityContact - Person.Person
- Person.EmailAddress - Person.Person
- Person.Password - Person.Person
- Person.Person - Person.BusinessEntity
- Person.PersonPhone - Person.Person
- Person.PersonPhone - Person.PhoneNumberType
- Person.StateProvince - Person.CountryRegion
- Person.StateProvince - Sales.SalesTerritory
- Production.BillOfMaterials - Production.Product
- Production.BillOfMaterials - Production.Product
- Production.BillOfMaterials - Production.UnitMeasure
- Production.Document - HumanResources.Employee
- Production.Product - Production.ProductModel
- Production.Product - Production.ProductSubcategory
- Production.Product - Production.UnitMeasure
- Production.Product - Production.UnitMeasure
- Production.ProductCostHistory - Production.Product
- Production.ProductDocument - Production.Document
- Production.ProductDocument - Production.Product
- Production.ProductInventory - Production.Location
- Production.ProductInventory - Production.Product
- Production.ProductListPriceHistory - Production.Product
- Production.ProductModelIllustration - Production.Illustration
- Production.ProductModelIllustration - Production.ProductModel
- Production.ProductModelProductDescriptionCulture - Production.Culture
- Production.ProductModelProductDescriptionCulture - Production.ProductDescription
- Production.ProductModelProductDescriptionCulture - Production.ProductModel
- Production.ProductProductPhoto - Production.Product
- Production.ProductProductPhoto - Production.ProductPhoto
- Production.ProductReview - Production.Product
- Production.ProductSubcategory - Production.ProductCategory
- Production.TransactionHistory - Production.Product
- Production.WorkOrder - Production.Product
- Production.WorkOrder - Production.ScrapReason
- Production.WorkOrderRouting - Production.Location
- Production.WorkOrderRouting - Production.WorkOrder
- Purchasing.ProductVendor - Production.Product
- Purchasing.ProductVendor - Production.UnitMeasure
- Purchasing.ProductVendor - Purchasing.Vendor
- Purchasing.PurchaseOrderDetail - Production.Product
- Purchasing.PurchaseOrderDetail - Purchasing.PurchaseOrderHeader
- Purchasing.PurchaseOrderHeader - HumanResources.Employee
- Purchasing.PurchaseOrderHeader - Purchasing.ShipMethod
- Purchasing.PurchaseOrderHeader - Purchasing.Vendor
- Purchasing.Vendor - Person.BusinessEntity
- Sales.CountryRegionCurrency - Person.CountryRegion
- Sales.CountryRegionCurrency - Sales.Currency
- Sales.CurrencyRate - Sales.Currency
- Sales.CurrencyRate - Sales.Currency
- Sales.Customer - Person.Person
- Sales.Customer - Sales.SalesTerritory
- Sales.Customer - Sales.Store
- Sales.PersonCreditCard - Sales.CreditCard
- Sales.PersonCreditCard - Person.Person
- Sales.SalesOrderDetail - Sales.SalesOrderHeader
- Sales.SalesOrderDetail - Sales.SpecialOfferProduct
- Sales.SalesOrderHeader - Person.Address
- Sales.SalesOrderHeader - Person.Address
- Sales.SalesOrderHeader - Sales.CreditCard
- Sales.SalesOrderHeader - Sales.CurrencyRate
- Sales.SalesOrderHeader - Sales.Customer
- Sales.SalesOrderHeader - Sales.SalesPerson
- Sales.SalesOrderHeader - Sales.SalesTerritory
- Sales.SalesOrderHeader - Purchasing.ShipMethod
- Sales.SalesOrderHeaderSalesReason - Sales.SalesOrderHeader
- Sales.SalesOrderHeaderSalesReason - Sales.SalesReason
- Sales.SalesPerson - HumanResources.Employee
- Sales.SalesPerson - Sales.SalesTerritory
- Sales.SalesPersonQuotaHistory - Sales.SalesPerson
- Sales.SalesTaxRate - Person.StateProvince
- Sales.SalesTerritory - Person.CountryRegion
- Sales.SalesTerritoryHistory - Sales.SalesPerson
- Sales.SalesTerritoryHistory - Sales.SalesTerritory
- Sales.ShoppingCartItem - Production.Product
- Sales.SpecialOfferProduct - Production.Product
- Sales.SpecialOfferProduct - Sales.SpecialOffer
- Sales.Store - Person.BusinessEntity
- Sales.Store - Sales.SalesPerson
- 'Add hidden links to force the model to stretch out
- Sales.SpecialOfferProduct -[hidden]- Purchasing.PurchaseOrderDetail
- Sales.SpecialOfferProduct -[hidden]- Production.WorkOrderRouting
- Sales.SpecialOfferProduct -[hidden]- Purchasing.PurchaseOrderDetail
- Sales.SpecialOfferProduct -[hidden]- Production.Document
- Sales.SpecialOfferProduct -[hidden]- Person.AddressType
- Sales.SpecialOfferProduct -[hidden]- Production.ProductPhoto
- Sales.SpecialOfferProduct -[hidden]- Production.ProductReview
- Sales.SpecialOfferProduct -[hidden]- Production.TransactionHistory
- Sales.SpecialOfferProduct -[hidden]- Production.ProductDescription
- Sales.SpecialOfferProduct -[hidden]- Sales.SalesOrderHeader
- Sales.SalesOrderHeaderSalesReason -[hidden]- Production.ProductInventory
- Sales.SalesOrderHeaderSalesReason -[hidden]- Production.Product
- Sales.SalesOrderHeaderSalesReason -[hidden]- Person.BusinessEntityContact
- Sales.SalesOrderHeaderSalesReason -[hidden]- dbo.AWBuildVersion
- Sales.SalesOrderHeaderSalesReason -[hidden]- Sales.PersonCreditCard
- Sales.SalesOrderHeaderSalesReason -[hidden]- Sales.SalesReason
- Sales.SalesOrderHeaderSalesReason -[hidden]- HumanResources.Department
- Sales.SalesOrderHeaderSalesReason -[hidden]- dbo.DatabaseLog
- Sales.SalesOrderHeaderSalesReason -[hidden]- Production.Document
- Sales.SalesOrderHeaderSalesReason -[hidden]- Production.UnitMeasure
- Sales.CountryRegionCurrency -[hidden]- Production.Culture
- Sales.CountryRegionCurrency -[hidden]- Production.ScrapReason
- Sales.CountryRegionCurrency -[hidden]- Sales.Customer
- Sales.CountryRegionCurrency -[hidden]- Person.BusinessEntityAddress
- Sales.CountryRegionCurrency -[hidden]- Production.WorkOrderRouting
- Sales.CountryRegionCurrency -[hidden]- Sales.SalesTaxRate
- Sales.CountryRegionCurrency -[hidden]- Sales.Store
- Sales.CountryRegionCurrency -[hidden]- Production.TransactionHistoryArchive
- Sales.CountryRegionCurrency -[hidden]- Person.BusinessEntityContact
- Sales.CountryRegionCurrency -[hidden]- Production.Document
- Purchasing.PurchaseOrderHeader -[hidden]- Production.Document
- Purchasing.PurchaseOrderHeader -[hidden]- Production.Document
- Purchasing.PurchaseOrderHeader -[hidden]- Person.PersonPhone
- Purchasing.PurchaseOrderHeader -[hidden]- Sales.SpecialOffer
- Purchasing.PurchaseOrderHeader -[hidden]- Production.ProductReview
- Purchasing.PurchaseOrderHeader -[hidden]- HumanResources.EmployeePayHistory
- Purchasing.PurchaseOrderHeader -[hidden]- Production.WorkOrder
- Purchasing.PurchaseOrderHeader -[hidden]- Sales.Customer
- Purchasing.PurchaseOrderHeader -[hidden]- Sales.SpecialOffer
- Purchasing.PurchaseOrderHeader -[hidden]- Production.TransactionHistoryArchive
- Production.TransactionHistoryArchive -[hidden]- Production.TransactionHistory
- Production.TransactionHistoryArchive -[hidden]- Sales.SpecialOfferProduct
- Production.TransactionHistoryArchive -[hidden]- Production.WorkOrderRouting
- Production.TransactionHistoryArchive -[hidden]- Sales.SpecialOffer
- Production.TransactionHistoryArchive -[hidden]- Production.ProductReview
- Production.TransactionHistoryArchive -[hidden]- Production.ProductSubcategory
- Production.TransactionHistoryArchive -[hidden]- Production.WorkOrderRouting
- Production.TransactionHistoryArchive -[hidden]- Purchasing.PurchaseOrderDetail
- Production.TransactionHistoryArchive -[hidden]- Production.ProductProductPhoto
- Production.TransactionHistoryArchive -[hidden]- Person.ContactType
- Production.ProductPhoto -[hidden]- HumanResources.EmployeePayHistory
- Production.ProductPhoto -[hidden]- dbo.ErrorLog
- Production.ProductPhoto -[hidden]- Person.Person
- Production.ProductPhoto -[hidden]- Person.BusinessEntityAddress
- Production.ProductPhoto -[hidden]- Production.ProductModel
- Production.ProductPhoto -[hidden]- Person.BusinessEntity
- Production.ProductPhoto -[hidden]- Production.Document
- Production.ProductPhoto -[hidden]- Production.WorkOrderRouting
- Production.ProductPhoto -[hidden]- dbo.ErrorLog
- Production.ProductPhoto -[hidden]- Sales.SalesOrderHeader
- Production.Culture -[hidden]- Purchasing.ShipMethod
- Production.Culture -[hidden]- Person.BusinessEntity
- Production.Culture -[hidden]- Sales.SalesPersonQuotaHistory
- Production.Culture -[hidden]- HumanResources.Shift
- Production.Culture -[hidden]- Production.Culture
- Production.Culture -[hidden]- Purchasing.PurchaseOrderHeader
- Production.Culture -[hidden]- Purchasing.ProductVendor
- Production.Culture -[hidden]- Purchasing.PurchaseOrderDetail
- Production.Culture -[hidden]- Production.Culture
- Production.Culture -[hidden]- Production.ProductPhoto
- Production.ProductProductPhoto -[hidden]- Sales.CountryRegionCurrency
- Production.ProductProductPhoto -[hidden]- Production.WorkOrder
- Production.ProductProductPhoto -[hidden]- HumanResources.Department
- Production.ProductProductPhoto -[hidden]- Sales.SalesTerritory
- Production.ProductProductPhoto -[hidden]- HumanResources.Employee
- Production.ProductProductPhoto -[hidden]- Person.Address
- Production.ProductProductPhoto -[hidden]- Person.Password
- Production.ProductProductPhoto -[hidden]- Person.PhoneNumberType
- Production.ProductProductPhoto -[hidden]- Person.PhoneNumberType
- Production.ProductProductPhoto -[hidden]- Sales.Customer
- Production.Document -[hidden]- Purchasing.Vendor
- Production.Document -[hidden]- Production.ProductCostHistory
- Production.Document -[hidden]- Sales.SalesPersonQuotaHistory
- Production.Document -[hidden]- Sales.CountryRegionCurrency
- Production.Document -[hidden]- Sales.SalesOrderHeader
- Production.Document -[hidden]- Production.ProductModelIllustration
- Production.Document -[hidden]- Production.ProductCostHistory
- Production.Document -[hidden]- Production.Location
- Production.Document -[hidden]- Person.EmailAddress
- Production.Document -[hidden]- Person.Password
- Production.ProductPhoto -[hidden]- Sales.SalesPersonQuotaHistory
- Production.ProductPhoto -[hidden]- Sales.CountryRegionCurrency
- Production.ProductPhoto -[hidden]- Person.CountryRegion
- Production.ProductPhoto -[hidden]- Sales.SalesTaxRate
- Production.ProductPhoto -[hidden]- Person.Address
- Production.ProductPhoto -[hidden]- Purchasing.PurchaseOrderDetail
- Production.ProductPhoto -[hidden]- Sales.SalesTerritoryHistory
- Production.ProductPhoto -[hidden]- HumanResources.JobCandidate
- Production.ProductPhoto -[hidden]- Person.StateProvince
- Production.ProductPhoto -[hidden]- Person.PhoneNumberType
- Sales.SalesOrderDetail -[hidden]- Sales.SpecialOffer
- Sales.SalesOrderDetail -[hidden]- Person.BusinessEntity
- Sales.SalesOrderDetail -[hidden]- Production.WorkOrderRouting
- Sales.SalesOrderDetail -[hidden]- HumanResources.JobCandidate
- Sales.SalesOrderDetail -[hidden]- HumanResources.Employee
- Sales.SalesOrderDetail -[hidden]- dbo.AWBuildVersion
- Sales.SalesOrderDetail -[hidden]- Sales.SalesTerritoryHistory
- Sales.SalesOrderDetail -[hidden]- Purchasing.Vendor
- Sales.SalesOrderDetail -[hidden]- Production.Illustration
- Sales.SalesOrderDetail -[hidden]- dbo.DatabaseLog
- Person.Address -[hidden]- Purchasing.ProductVendor
- Person.Address -[hidden]- Sales.SalesOrderDetail
- Person.Address -[hidden]- Person.ContactType
- Person.Address -[hidden]- Production.ProductPhoto
- Person.Address -[hidden]- Production.ProductModelProductDescriptionCulture
- Person.Address -[hidden]- Purchasing.ProductVendor
- Person.Address -[hidden]- HumanResources.JobCandidate
- Person.Address -[hidden]- Sales.Customer
- Person.Address -[hidden]- Purchasing.PurchaseOrderHeader
- Person.Address -[hidden]- HumanResources.EmployeeDepartmentHistory
- Production.ProductSubcategory -[hidden]- Production.WorkOrderRouting
- Production.ProductSubcategory -[hidden]- Production.ProductDescription
- Production.ProductSubcategory -[hidden]- Production.Illustration
- Production.ProductSubcategory -[hidden]- Person.BusinessEntity
- Production.ProductSubcategory -[hidden]- HumanResources.JobCandidate
- Production.ProductSubcategory -[hidden]- Sales.SalesOrderDetail
- Production.ProductSubcategory -[hidden]- Production.ProductListPriceHistory
- Production.ProductSubcategory -[hidden]- Purchasing.PurchaseOrderHeader
- Production.ProductSubcategory -[hidden]- Purchasing.PurchaseOrderHeader
- Production.ProductSubcategory -[hidden]- Sales.SalesTerritory
- Sales.Currency -[hidden]- Sales.SalesReason
- Sales.Currency -[hidden]- Person.Person
- Sales.Currency -[hidden]- Production.ProductCostHistory
- Sales.Currency -[hidden]- Production.WorkOrderRouting
- Sales.Currency -[hidden]- Sales.Currency
- Sales.Currency -[hidden]- dbo.DatabaseLog
- Sales.Currency -[hidden]- Person.CountryRegion
- Sales.Currency -[hidden]- Production.BillOfMaterials
- Sales.Currency -[hidden]- Sales.Store
- Sales.Currency -[hidden]- Production.ProductDescription
- @enduml
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement