A collection of information about the database structure and types in Ghost. The database schema is defined in https://github.com/TryGhost/Ghost/blob/3e0864ad6d8c05904aa97e185bb2ec43326274a2/ghost/core/core/server/data/schema/schema.js.

Posts

Statuses:

• Can be: draft, scheduled, published, email
  • email are posts that are not published to the site but are emailed
• Only published posts are available via the Content API

Users

Statuses:

• Can be: TBD

Tags

• Visibility: Can be internal or public

Integrations

Types:

• internal - private from the api but allowed on starter (e.g. default frontend integration)
• built-in - accessible from api but not allowed on starter (e.g. Zapier)
• core - accessible from api and allowed on starter (e.g. Ghost Explore)
• custom - created by a user

Jobs

Statuses (ref):

• Can be: 'started', 'finished', 'failed', 'queued'
  • identify when the job is in progress, done, added to the queue, or errored