Data Model
The 本製品 uses the HubDB endpoints in the HubSpot CMS API to model HubDB tables as relational tables and views.
Tables
The 本製品 models draft tables as SQL tables. Most tables in HubDB are dynamic, but all share the following columns: Id, CreatedAt, UpdatedAt, PublishedAt, PagePath, PageName and ChildTableId.
Note that the 本製品 will discover a draft version of every table that has been published.
Views
The 本製品 models published tables as read-only SQL views.
Aside from the Owners view, which lists owners available for an account, views in HubDB are dynamic.
All dynamic views share these columns: Id, CreatedAt, UpdatedAt, PublishedAt, PagePath, PageName and ChildTableId.
Stored Procedures
Stored Procedures are function-like interfaces to HubDB. They can be used to perform tasks such as importing data and publishing tables.