Created
August 9, 2019 14:35
-
-
Save OsirisDBA/8f652f72d54f25cb429c366ea26f0390 to your computer and use it in GitHub Desktop.
AdventureWorks2017 PlantUML ERD
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| @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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment