draft


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('draft_id_seq'::regclass)
article.draft_id article_draft_id_foreignR
uuid uuid 2147483647 null
author_id int8 19 null
user.id draft_author_id_foreignR
upstream_id int8 19 √ null
article.id draft_upstream_id_foreignR
title varchar 255 null
cover int8 19 √ null
asset.id draft_cover_foreignR
summary text 2147483647 √ null
content text 2147483647 √ null
archived bool 1 √ false
publish_state text 2147483647 'unpublished'::text
tags _text 2147483647 √ null
scheduled_at timestamptz 35,6 √ null
created_at timestamptz 35,6 √ CURRENT_TIMESTAMP
updated_at timestamptz 35,6 √ CURRENT_TIMESTAMP
collection _text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
draft_pkey Primary key Asc id
draft_archived_index Performance Asc archived
draft_author_id_archived_index Performance Asc/Asc author_id + archived
draft_publish_state_index Performance Asc publish_state
draft_uuid_unique Must be unique Asc uuid

Check Constraints

Constraint Name Constraint
draft_publish_state_check ((publish_state = ANY (ARRAY['unpublished'::text, 'pending'::text, 'published'::text, 'error'::text])))

Relationships

Close relationships within degrees of separation