article


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('article_id_seq'::regclass)
action_article.target_id action_article_target_id_foreignR
article.upstream_id article_upstream_id_foreignR
article_boost.article_id article_boost_article_id_foreignR
article_read.article_id article_read_article_id_foreignR
article_read_count.article_id article_read_count_article_id_foreignR
article_recommend_setting.article_id article_recommend_setting_article_id_foreignR
article_tag.article_id article_tag_article_id_foreignR
collection.article_id collection_article_id_foreignR
collection.entrance_id collection_entrance_id_foreignR
comment.article_id comment_article_id_foreignR
draft.upstream_id draft_upstream_id_foreignR
matters_choice.article_id matters_choice_article_id_foreignR
matters_today.article_id matters_today_article_id_foreignR
report.article_id report_article_id_foreignR
uuid uuid 2147483647 null
author_id int8 19 null
user.id article_author_id_foreignR
upstream_id int8 19 √ null
article.id article_upstream_id_foreignR
title varchar 255 null
slug varchar 255 null
cover int8 19 √ null
asset.id article_cover_foreignR
summary varchar 255 null
word_count int4 10 null
data_hash varchar 255 √ null
media_hash varchar 255 √ null
content text 2147483647 null
state text 2147483647 'active'::text
public bool 1 √ false
live bool 1 √ false
created_at timestamptz 35,6 √ CURRENT_TIMESTAMP
updated_at timestamptz 35,6 √ CURRENT_TIMESTAMP
draft_id int8 19 √ null
draft.id article_draft_id_foreignR
remark text 2147483647 √ null
sticky bool 1 √ false
language varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
article_pkey Primary key Asc id
article_author_id_index Performance Asc author_id
article_author_id_state_index Performance Asc/Asc author_id + state
article_created_at_index Performance Asc created_at
article_media_hash_index Performance Asc media_hash
article_state_index Performance Asc state

Check Constraints

Constraint Name Constraint
article_state_check ((state = ANY (ARRAY['active'::text, 'banned'::text, 'archived'::text])))

Relationships

Close relationships within degrees of separation