Data model
Northwind small-business database
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/northwind/northwind- Version
0.1.0- Repository
- https://github.com/demo-db/northwind
- Source commit
c07b4666734a3445b2b0c2fbaf84305dcdb1bf45- MeaningGraph revision
bb1d5a4e8a92bb37de0ff31eb5d40d77a3309c22efd0761ebd0afb03036035dc- ModelSpec source
model/northwind.modelspec.hcl- ModelSpec AST
model/northwind.modelspec.json- Archived definition
- Download the exact registered definition
- Archived source files
data-source/LICENSE.mdLICENSEmodel/northwind.modelspec.hclmodel/northwind.modelspec.json
Logical structure
Record types
Record type
Categories
Key: CategoryID
CategoryIDintRequiredKey fieldCategoryNamestringDescriptionstringPicturedocument
Record type
CustomerCustomerDemo
Key: CustomerIDCustomerTypeID
CustomerIDrecord referenceRecord:CustomersRequiredKey fieldCustomerTypeIDrecord referenceRecord:CustomerDemographicsRequiredKey field
Record type
CustomerDemographics
Key: CustomerTypeID
CustomerTypeIDstringRequiredKey fieldCustomerDescstring
Record type
Customers
Key: CustomerID
CustomerIDstringRequiredKey fieldCompanyNamestringContactNamestringContactTitlestringAddressstringCitystringRegionstringPostalCodestringCountrystringPhonestringFaxstring
Record type
EmployeeTerritories
Key: EmployeeIDTerritoryID
EmployeeIDrecord referenceRecord:EmployeesRequiredKey fieldTerritoryIDrecord referenceRecord:TerritoriesRequiredKey field
Record type
Employees
Key: EmployeeID
EmployeeIDintRequiredKey fieldLastNamestringFirstNamestringTitlestringTitleOfCourtesystringBirthDatedateHireDatedateAddressstringCitystringRegionstringPostalCodestringCountrystringHomePhonestringExtensionstringPhotodocumentNotesstringReportsTorecord referenceRecord:EmployeesPhotoPathstring
Record type
OrderDetails
Key: OrderIDProductID
Record type
Orders
Key: OrderID
OrderIDintRequiredKey fieldCustomerIDrecord referenceRecord:CustomersEmployeeIDrecord referenceRecord:EmployeesOrderDatedatetimeRequiredDatedatetimeShippedDatedatetimeShipViarecord referenceRecord:ShippersFreightdecimalShipNamestringShipAddressstringShipCitystringShipRegionstringShipPostalCodestringShipCountrystring
Record type
Products
Key: ProductID
ProductIDintRequiredKey fieldProductNamestringRequiredSupplierIDrecord referenceRecord:SuppliersCategoryIDrecord referenceRecord:CategoriesQuantityPerUnitstringUnitPricedecimalUnitsInStockintUnitsOnOrderintReorderLevelintDiscontinuedstringRequired
Record type
Regions
Key: RegionID
RegionIDintRequiredKey fieldRegionDescriptionstringRequired
Record type
Shippers
Key: ShipperID
ShipperIDintRequiredKey fieldCompanyNamestringRequiredPhonestring
Record type
Suppliers
Key: SupplierID
SupplierIDintRequiredKey fieldCompanyNamestringRequiredContactNamestringContactTitlestringAddressstringCitystringRegionstringPostalCodestringCountrystringPhonestringFaxstringHomePagestring
Record type
Territories
Key: TerritoryID
TerritoryIDstringRequiredKey fieldTerritoryDescriptionstringRequiredRegionIDrecord referenceRecord:RegionsRequired