Data model
AdventureWorks OLTP
Logical record types and their declared fields.
draftModule version 0.1.0
Registered DataModel
Provenance
draftModule version 0.1.0MIT
- Module
github.com/demo-db/adventureworks/adventureworks- Version
0.1.0- Source commit
c91e06e9c12380e7709f66ab1e69cf7f858f67c1- MeaningGraph revision
570a84bc87c32877707da18ee04f2d390f898a8a71df6dea646403091c4b1563- ModelSpec source
model/adventureworks.modelspec.hcl- ModelSpec AST
model/adventureworks.modelspec.json- Archived definition
- Download the exact registered definition
Logical structure
Record types
Record type
HumanResources_Department
Key: DepartmentID
DepartmentIDintRequiredKey fieldNamestringRequiredGroupNamestringRequiredModifiedDatestringRequired
Record type
HumanResources_Employee
Key: BusinessEntityID
BusinessEntityIDrecord referenceRecord:Person_PersonRequiredKey fieldNationalIDNumberstringRequiredLoginIDstringRequiredOrganizationNodedocumentOrganizationLevelintJobTitlestringRequiredBirthDatestringRequiredMaritalStatusstringRequiredGenderstringRequiredHireDatestringRequiredSalariedFlagintRequiredVacationHoursintRequiredSickLeaveHoursintRequiredCurrentFlagintRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
HumanResources_EmployeeDepartmentHistory
Key: BusinessEntityIDStartDateDepartmentIDShiftID
BusinessEntityIDrecord referenceRecord:HumanResources_EmployeeRequiredKey fieldDepartmentIDrecord referenceRecord:HumanResources_DepartmentRequiredKey fieldShiftIDrecord referenceRecord:HumanResources_ShiftRequiredKey fieldStartDatestringRequiredKey fieldEndDatestringModifiedDatestringRequired
Record type
HumanResources_EmployeePayHistory
Key: BusinessEntityIDRateChangeDate
BusinessEntityIDrecord referenceRecord:HumanResources_EmployeeRequiredKey fieldRateChangeDatestringRequiredKey fieldRatedecimalRequiredPayFrequencyintRequiredModifiedDatestringRequired
Record type
HumanResources_JobCandidate
Key: JobCandidateID
JobCandidateIDintRequiredKey fieldBusinessEntityIDrecord referenceRecord:HumanResources_EmployeeResumestringModifiedDatestringRequired
Record type
HumanResources_Shift
Key: ShiftID
ShiftIDintRequiredKey fieldNamestringRequiredStartTimestringRequiredEndTimestringRequiredModifiedDatestringRequired
Record type
Person_Address
Key: AddressID
AddressIDintRequiredKey fieldAddressLine1stringRequiredAddressLine2stringCitystringRequiredStateProvinceIDrecord referenceRecord:Person_StateProvinceRequiredPostalCodestringRequiredSpatialLocationdocumentrowguidstringRequiredModifiedDatestringRequired
Record type
Person_AddressType
Key: AddressTypeID
AddressTypeIDintRequiredKey fieldNamestringRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Person_BusinessEntity
Key: BusinessEntityID
BusinessEntityIDintRequiredKey fieldrowguidstringRequiredModifiedDatestringRequired
Record type
Person_BusinessEntityAddress
Key: BusinessEntityIDAddressIDAddressTypeID
BusinessEntityIDrecord referenceRecord:Person_BusinessEntityRequiredKey fieldAddressIDrecord referenceRecord:Person_AddressRequiredKey fieldAddressTypeIDrecord referenceRecord:Person_AddressTypeRequiredKey fieldrowguidstringRequiredModifiedDatestringRequired
Record type
Person_BusinessEntityContact
Key: BusinessEntityIDPersonIDContactTypeID
BusinessEntityIDrecord referenceRecord:Person_BusinessEntityRequiredKey fieldPersonIDrecord referenceRecord:Person_PersonRequiredKey fieldContactTypeIDrecord referenceRecord:Person_ContactTypeRequiredKey fieldrowguidstringRequiredModifiedDatestringRequired
Record type
Person_ContactType
Key: ContactTypeID
ContactTypeIDintRequiredKey fieldNamestringRequiredModifiedDatestringRequired
Record type
Person_CountryRegion
Key: CountryRegionCode
CountryRegionCodestringRequiredKey fieldNamestringRequiredModifiedDatestringRequired
Record type
Person_EmailAddress
Key: BusinessEntityIDEmailAddressID
BusinessEntityIDrecord referenceRecord:Person_PersonRequiredKey fieldEmailAddressIDintRequiredKey fieldEmailAddressstringrowguidstringRequiredModifiedDatestringRequired
Record type
Person_Password
Key: BusinessEntityID
BusinessEntityIDrecord referenceRecord:Person_PersonRequiredKey fieldPasswordHashstringRequiredPasswordSaltstringRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Person_Person
Key: BusinessEntityID
BusinessEntityIDrecord referenceRecord:Person_BusinessEntityRequiredKey fieldPersonTypestringRequiredNameStyleintRequiredTitlestringFirstNamestringRequiredMiddleNamestringLastNamestringRequiredSuffixstringEmailPromotionintRequiredAdditionalContactInfostringDemographicsstringrowguidstringRequiredModifiedDatestringRequired
Record type
Person_PersonPhone
Key: BusinessEntityIDPhoneNumberPhoneNumberTypeID
BusinessEntityIDrecord referenceRecord:Person_PersonRequiredKey fieldPhoneNumberstringRequiredKey fieldPhoneNumberTypeIDrecord referenceRecord:Person_PhoneNumberTypeRequiredKey fieldModifiedDatestringRequired
Record type
Person_PhoneNumberType
Key: PhoneNumberTypeID
PhoneNumberTypeIDintRequiredKey fieldNamestringRequiredModifiedDatestringRequired
Record type
Person_StateProvince
Key: StateProvinceID
StateProvinceIDintRequiredKey fieldStateProvinceCodestringRequiredCountryRegionCoderecord referenceRecord:Person_CountryRegionRequiredIsOnlyStateProvinceFlagintRequiredNamestringRequiredTerritoryIDrecord referenceRecord:Sales_SalesTerritoryRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Production_BillOfMaterials
Key: BillOfMaterialsID
BillOfMaterialsIDintRequiredKey fieldProductAssemblyIDrecord referenceRecord:Production_ProductComponentIDrecord referenceRecord:Production_ProductRequiredStartDatestringRequiredEndDatestringUnitMeasureCoderecord referenceRecord:Production_UnitMeasureRequiredBOMLevelintRequiredPerAssemblyQtydecimalRequiredModifiedDatestringRequired
Record type
Production_Culture
Key: CultureID
CultureIDstringRequiredKey fieldNamestringRequiredModifiedDatestringRequired
Record type
Production_Document
Key: DocumentNode
DocumentNodedocumentRequiredKey fieldDocumentLevelintTitlestringRequiredOwnerrecord referenceRecord:HumanResources_EmployeeRequiredFolderFlagintRequiredFileNamestringRequiredFileExtensionstringRequiredRevisionstringRequiredChangeNumberintRequiredStatusintRequiredDocumentSummarystringDocumentdocumentrowguidstringRequiredModifiedDatestringRequired
Record type
Production_Illustration
Key: IllustrationID
IllustrationIDintRequiredKey fieldDiagramstringModifiedDatestringRequired
Record type
Production_Location
Key: LocationID
LocationIDintRequiredKey fieldNamestringRequiredCostRatedecimalRequiredAvailabilitydecimalRequiredModifiedDatestringRequired
Record type
Production_Product
Key: ProductID
ProductIDintRequiredKey fieldNamestringRequiredProductNumberstringRequiredMakeFlagintRequiredFinishedGoodsFlagintRequiredColorstringSafetyStockLevelintRequiredReorderPointintRequiredStandardCostdecimalRequiredListPricedecimalRequiredSizestringSizeUnitMeasureCoderecord referenceRecord:Production_UnitMeasureWeightUnitMeasureCoderecord referenceRecord:Production_UnitMeasureWeightdecimalDaysToManufactureintRequiredProductLinestringClassstringStylestringProductSubcategoryIDrecord referenceRecord:Production_ProductSubcategoryProductModelIDrecord referenceRecord:Production_ProductModelSellStartDatestringRequiredSellEndDatestringDiscontinuedDatestringrowguidstringRequiredModifiedDatestringRequired
Record type
Production_ProductCategory
Key: ProductCategoryID
ProductCategoryIDintRequiredKey fieldNamestringRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Production_ProductCostHistory
Key: ProductIDStartDate
ProductIDrecord referenceRecord:Production_ProductRequiredKey fieldStartDatestringRequiredKey fieldEndDatestringStandardCostdecimalRequiredModifiedDatestringRequired
Record type
Production_ProductDescription
Key: ProductDescriptionID
ProductDescriptionIDintRequiredKey fieldDescriptionstringRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Production_ProductDocument
Key: ProductIDDocumentNode
ProductIDrecord referenceRecord:Production_ProductRequiredKey fieldDocumentNoderecord referenceRecord:Production_DocumentRequiredKey fieldModifiedDatestringRequired
Record type
Production_ProductInventory
Key: ProductIDLocationID
ProductIDrecord referenceRecord:Production_ProductRequiredKey fieldLocationIDrecord referenceRecord:Production_LocationRequiredKey fieldShelfstringRequiredBinintRequiredQuantityintRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Production_ProductListPriceHistory
Key: ProductIDStartDate
ProductIDrecord referenceRecord:Production_ProductRequiredKey fieldStartDatestringRequiredKey fieldEndDatestringListPricedecimalRequiredModifiedDatestringRequired
Record type
Production_ProductModel
Key: ProductModelID
ProductModelIDintRequiredKey fieldNamestringRequiredCatalogDescriptionstringInstructionsstringrowguidstringRequiredModifiedDatestringRequired
Record type
Production_ProductModelIllustration
Key: ProductModelIDIllustrationID
ProductModelIDrecord referenceRecord:Production_ProductModelRequiredKey fieldIllustrationIDrecord referenceRecord:Production_IllustrationRequiredKey fieldModifiedDatestringRequired
Record type
Production_ProductModelProductDescriptionCulture
Key: ProductModelIDProductDescriptionIDCultureID
ProductModelIDrecord referenceRecord:Production_ProductModelRequiredKey fieldProductDescriptionIDrecord referenceRecord:Production_ProductDescriptionRequiredKey fieldCultureIDrecord referenceRecord:Production_CultureRequiredKey fieldModifiedDatestringRequired
Record type
Production_ProductPhoto
Key: ProductPhotoID
ProductPhotoIDintRequiredKey fieldThumbNailPhotodocumentThumbnailPhotoFileNamestringLargePhotodocumentLargePhotoFileNamestringModifiedDatestringRequired
Record type
Production_ProductProductPhoto
Key: ProductIDProductPhotoID
ProductIDrecord referenceRecord:Production_ProductRequiredKey fieldProductPhotoIDrecord referenceRecord:Production_ProductPhotoRequiredKey fieldPrimaryintRequiredModifiedDatestringRequired
Record type
Production_ProductReview
Key: ProductReviewID
ProductReviewIDintRequiredKey fieldProductIDrecord referenceRecord:Production_ProductRequiredReviewerNamestringRequiredReviewDatestringRequiredEmailAddressstringRequiredRatingintRequiredCommentsstringModifiedDatestringRequired
Record type
Production_ProductSubcategory
Key: ProductSubcategoryID
ProductSubcategoryIDintRequiredKey fieldProductCategoryIDrecord referenceRecord:Production_ProductCategoryRequiredNamestringRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Production_ScrapReason
Key: ScrapReasonID
ScrapReasonIDintRequiredKey fieldNamestringRequiredModifiedDatestringRequired
Record type
Production_TransactionHistory
Key: TransactionID
TransactionIDintRequiredKey fieldProductIDrecord referenceRecord:Production_ProductRequiredReferenceOrderIDintRequiredReferenceOrderLineIDintRequiredTransactionDatestringRequiredTransactionTypestringRequiredQuantityintRequiredActualCostdecimalRequiredModifiedDatestringRequired
Record type
Production_TransactionHistoryArchive
Key: TransactionID
TransactionIDintRequiredKey fieldProductIDintRequiredReferenceOrderIDintRequiredReferenceOrderLineIDintRequiredTransactionDatestringRequiredTransactionTypestringRequiredQuantityintRequiredActualCostdecimalRequiredModifiedDatestringRequired
Record type
Production_UnitMeasure
Key: UnitMeasureCode
UnitMeasureCodestringRequiredKey fieldNamestringRequiredModifiedDatestringRequired
Record type
Production_WorkOrder
Key: WorkOrderID
WorkOrderIDintRequiredKey fieldProductIDrecord referenceRecord:Production_ProductRequiredOrderQtyintRequiredStockedQtydecimalScrappedQtyintRequiredStartDatestringRequiredEndDatestringDueDatestringRequiredScrapReasonIDrecord referenceRecord:Production_ScrapReasonModifiedDatestringRequired
Record type
Production_WorkOrderRouting
Key: WorkOrderIDProductIDOperationSequence
WorkOrderIDrecord referenceRecord:Production_WorkOrderRequiredKey fieldProductIDintRequiredKey fieldOperationSequenceintRequiredKey fieldLocationIDrecord referenceRecord:Production_LocationRequiredScheduledStartDatestringRequiredScheduledEndDatestringRequiredActualStartDatestringActualEndDatestringActualResourceHrsdecimalPlannedCostdecimalRequiredActualCostdecimalModifiedDatestringRequired
Record type
Purchasing_ProductVendor
Key: ProductIDBusinessEntityID
ProductIDrecord referenceRecord:Production_ProductRequiredKey fieldBusinessEntityIDrecord referenceRecord:Purchasing_VendorRequiredKey fieldAverageLeadTimeintRequiredStandardPricedecimalRequiredLastReceiptCostdecimalLastReceiptDatestringMinOrderQtyintRequiredMaxOrderQtyintRequiredOnOrderQtyintUnitMeasureCoderecord referenceRecord:Production_UnitMeasureRequiredModifiedDatestringRequired
Record type
Purchasing_PurchaseOrderDetail
Key: PurchaseOrderIDPurchaseOrderDetailID
PurchaseOrderIDrecord referenceRecord:Purchasing_PurchaseOrderHeaderRequiredKey fieldPurchaseOrderDetailIDintRequiredKey fieldDueDatestringRequiredOrderQtyintRequiredProductIDrecord referenceRecord:Production_ProductRequiredUnitPricedecimalRequiredLineTotaldecimalReceivedQtydecimalRequiredRejectedQtydecimalRequiredStockedQtydecimalModifiedDatestringRequired
Record type
Purchasing_PurchaseOrderHeader
Key: PurchaseOrderID
PurchaseOrderIDintRequiredKey fieldRevisionNumberintRequiredStatusintRequiredEmployeeIDrecord referenceRecord:HumanResources_EmployeeRequiredVendorIDrecord referenceRecord:Purchasing_VendorRequiredShipMethodIDrecord referenceRecord:Purchasing_ShipMethodRequiredOrderDatestringRequiredShipDatestringSubTotaldecimalRequiredTaxAmtdecimalRequiredFreightdecimalRequiredTotalDuedecimalRequiredModifiedDatestringRequired
Record type
Purchasing_ShipMethod
Key: ShipMethodID
ShipMethodIDintRequiredKey fieldNamestringRequiredShipBasedecimalRequiredShipRatedecimalRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Purchasing_Vendor
Key: BusinessEntityID
BusinessEntityIDrecord referenceRecord:Person_BusinessEntityRequiredKey fieldAccountNumberstringRequiredNamestringRequiredCreditRatingintRequiredPreferredVendorStatusintRequiredActiveFlagintRequiredPurchasingWebServiceURLstringModifiedDatestringRequired
Record type
Sales_CountryRegionCurrency
Key: CountryRegionCodeCurrencyCode
CountryRegionCoderecord referenceRecord:Person_CountryRegionRequiredKey fieldCurrencyCoderecord referenceRecord:Sales_CurrencyRequiredKey fieldModifiedDatestringRequired
Record type
Sales_CreditCard
Key: CreditCardID
CreditCardIDintRequiredKey fieldCardTypestringRequiredCardNumberstringRequiredExpMonthintRequiredExpYearintRequiredModifiedDatestringRequired
Record type
Sales_Currency
Key: CurrencyCode
CurrencyCodestringRequiredKey fieldNamestringRequiredModifiedDatestringRequired
Record type
Sales_CurrencyRate
Key: CurrencyRateID
CurrencyRateIDintRequiredKey fieldCurrencyRateDatestringRequiredFromCurrencyCoderecord referenceRecord:Sales_CurrencyRequiredToCurrencyCoderecord referenceRecord:Sales_CurrencyRequiredAverageRatedecimalRequiredEndOfDayRatedecimalRequiredModifiedDatestringRequired
Record type
Sales_Customer
Key: CustomerID
CustomerIDintRequiredKey fieldPersonIDrecord referenceRecord:Person_PersonStoreIDrecord referenceRecord:Sales_StoreTerritoryIDrecord referenceRecord:Sales_SalesTerritoryAccountNumberstringrowguidstringRequiredModifiedDatestringRequired
Record type
Sales_PersonCreditCard
Key: BusinessEntityIDCreditCardID
BusinessEntityIDrecord referenceRecord:Person_PersonRequiredKey fieldCreditCardIDrecord referenceRecord:Sales_CreditCardRequiredKey fieldModifiedDatestringRequired
Record type
Sales_SalesOrderDetail
Key: SalesOrderIDSalesOrderDetailID
SalesOrderIDrecord referenceRecord:Sales_SalesOrderHeaderRequiredKey fieldSalesOrderDetailIDintRequiredKey fieldCarrierTrackingNumberstringOrderQtyintRequiredProductIDrecord referenceRecord:Sales_SpecialOfferProductRequiredSpecialOfferIDrecord referenceRecord:Sales_SpecialOfferProductRequiredUnitPricedecimalRequiredUnitPriceDiscountdecimalRequiredLineTotaldecimalrowguidstringRequiredModifiedDatestringRequired
Record type
Sales_SalesOrderHeader
Key: SalesOrderID
SalesOrderIDintRequiredKey fieldRevisionNumberintRequiredOrderDatestringRequiredDueDatestringRequiredShipDatestringStatusintRequiredOnlineOrderFlagintRequiredSalesOrderNumberstringPurchaseOrderNumberstringAccountNumberstringCustomerIDrecord referenceRecord:Sales_CustomerRequiredSalesPersonIDrecord referenceRecord:Sales_SalesPersonTerritoryIDrecord referenceRecord:Sales_SalesTerritoryBillToAddressIDrecord referenceRecord:Person_AddressRequiredShipToAddressIDrecord referenceRecord:Person_AddressRequiredShipMethodIDrecord referenceRecord:Purchasing_ShipMethodRequiredCreditCardIDrecord referenceRecord:Sales_CreditCardCreditCardApprovalCodestringCurrencyRateIDrecord referenceRecord:Sales_CurrencyRateSubTotaldecimalRequiredTaxAmtdecimalRequiredFreightdecimalRequiredTotalDuedecimalCommentstringrowguidstringRequiredModifiedDatestringRequired
Record type
Sales_SalesOrderHeaderSalesReason
Key: SalesOrderIDSalesReasonID
SalesOrderIDrecord referenceRecord:Sales_SalesOrderHeaderRequiredKey fieldSalesReasonIDrecord referenceRecord:Sales_SalesReasonRequiredKey fieldModifiedDatestringRequired
Record type
Sales_SalesPerson
Key: BusinessEntityID
BusinessEntityIDrecord referenceRecord:HumanResources_EmployeeRequiredKey fieldTerritoryIDrecord referenceRecord:Sales_SalesTerritorySalesQuotadecimalBonusdecimalRequiredCommissionPctdecimalRequiredSalesYTDdecimalRequiredSalesLastYeardecimalRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Sales_SalesPersonQuotaHistory
Key: BusinessEntityIDQuotaDate
BusinessEntityIDrecord referenceRecord:Sales_SalesPersonRequiredKey fieldQuotaDatestringRequiredKey fieldSalesQuotadecimalRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Sales_SalesReason
Key: SalesReasonID
SalesReasonIDintRequiredKey fieldNamestringRequiredReasonTypestringRequiredModifiedDatestringRequired
Record type
Sales_SalesTaxRate
Key: SalesTaxRateID
SalesTaxRateIDintRequiredKey fieldStateProvinceIDrecord referenceRecord:Person_StateProvinceRequiredTaxTypeintRequiredTaxRatedecimalRequiredNamestringRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Sales_SalesTerritory
Key: TerritoryID
TerritoryIDintRequiredKey fieldNamestringRequiredCountryRegionCoderecord referenceRecord:Person_CountryRegionRequiredGroupstringRequiredSalesYTDdecimalRequiredSalesLastYeardecimalRequiredCostYTDdecimalRequiredCostLastYeardecimalRequiredrowguidstringRequiredModifiedDatestringRequired
Record type
Sales_SalesTerritoryHistory
Key: BusinessEntityIDStartDateTerritoryID
BusinessEntityIDrecord referenceRecord:Sales_SalesPersonRequiredKey fieldTerritoryIDrecord referenceRecord:Sales_SalesTerritoryRequiredKey fieldStartDatestringRequiredKey fieldEndDatestringrowguidstringRequiredModifiedDatestringRequired
Record type
Sales_ShoppingCartItem
Key: ShoppingCartItemID
ShoppingCartItemIDintRequiredKey fieldShoppingCartIDstringRequiredQuantityintRequiredProductIDrecord referenceRecord:Production_ProductRequiredDateCreatedstringRequiredModifiedDatestringRequired
Record type
Sales_SpecialOffer
Key: SpecialOfferID
SpecialOfferIDintRequiredKey fieldDescriptionstringRequiredDiscountPctdecimalRequiredTypestringRequiredCategorystringRequiredStartDatestringRequiredEndDatestringRequiredMinQtyintRequiredMaxQtyintrowguidstringRequiredModifiedDatestringRequired
Record type
Sales_SpecialOfferProduct
Key: SpecialOfferIDProductID
SpecialOfferIDrecord referenceRecord:Sales_SpecialOfferRequiredKey fieldProductIDrecord referenceRecord:Production_ProductRequiredKey fieldrowguidstringRequiredModifiedDatestringRequired
Record type
Sales_Store
Key: BusinessEntityID
BusinessEntityIDrecord referenceRecord:Person_BusinessEntityRequiredKey fieldNamestringRequiredSalesPersonIDrecord referenceRecord:Sales_SalesPersonDemographicsstringrowguidstringRequiredModifiedDatestringRequired
Record type
dbo_AWBuildVersion
Key: SystemInformationID
SystemInformationIDintRequiredKey fieldDatabase_VersionstringRequiredVersionDatestringRequiredModifiedDatestringRequired
Record type
dbo_DatabaseLog
Key: DatabaseLogID
DatabaseLogIDintRequiredKey fieldPostTimestringRequiredDatabaseUserstringRequiredEventstringRequiredSchemastringObjectstringTSQLstringRequiredXmlEventstringRequired
Record type
dbo_ErrorLog
Key: ErrorLogID
ErrorLogIDintRequiredKey fieldErrorTimestringRequiredUserNamestringRequiredErrorNumberintRequiredErrorSeverityintErrorStateintErrorProcedurestringErrorLineintErrorMessagestringRequired