posting_followers


Description

A row in this table represents a follower of a posting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
posting_follower_id varchar 2147483647 null

Primary key.

account_id varchar 2147483647 null

The account the posting belongs to.

posting_id varchar 2147483647 null
postings.posting_id posting_followers_posting_id_fkeyC

ID of the posting connected to this entity.

user_id varchar 2147483647 null
users.user_id posting_followers_user_id_fkeyC

ID of the follower.

follower_rank numeric 131089 null

The position of the follower for the posting, starting with zero.

row_updated_at timestamp 29,6 CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.

Indexes

Constraint Name Type Sort Column(s)
posting_followers_pkey Primary key Asc posting_follower_id
posting_followers_account_id_index Performance Asc account_id
posting_followers_posting_id_index Performance Asc posting_id
posting_followers_user_id_idx Performance Asc user_id

Relationships