Description
To support more advanced features in Clay we need to add some columns to the Postgres tables for each data structure
Columns To Add
For all public tables add the following:
- Created At (createdAt)
- Last Modified (updatedAt)
- Site ID (for the slug of the site)
Pages Table
- First Publish Time (publishedAt)
- Last Publish Time (republishedAt)
- Archived (archivedAt)
- Unpublished (unpublishedAt)
Description
To support more advanced features in Clay we need to add some columns to the Postgres tables for each data structure
Columns To Add
For all public tables add the following:
Pages Table