action_article


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('action_article_id_seq'::regclass)
user_id int8 19 null
user.id action_article_user_id_foreignR
action text 2147483647 null
target_id int8 19 null
article.id action_article_target_id_foreignR
updated_at timestamptz 35,6 √ CURRENT_TIMESTAMP
created_at timestamptz 35,6 √ CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
action_article_pkey Primary key Asc id
action_article_action_index Performance Asc action
action_article_target_id_action_index Performance Asc/Asc target_id + action
action_article_user_id_action_index Performance Asc/Asc user_id + action
action_article_user_id_action_target_id_unique Must be unique Asc/Asc/Asc user_id + action + target_id

Check Constraints

Constraint Name Constraint
action_article_action_check ((action = 'subscribe'::text))

Relationships

Close relationships within degrees of separation