Additional Columns

[jonwinton]

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)
  • Except for users

Pages Table

• First Publish Time (publishedAt)
• Last Publish Time (republishedAt)
• Archived (archivedAt)
• Unpublished (unpublishedAt)

[TTaitFoster]

Additional Columns