followup_seen

95 rows


Description

Create by KenG (2020/03/12), This table for users_seen of topic(followup)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
followup_id int4 10 null
followup.id fk_followup_seen_followup_id C
seen_username text 2147483647 null
seen_time timestamptz 35,6 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
pk_followup_seen Primary key Asc id
idx_followup_seen_followup_id Performance Asc followup_id
idx_followup_seen_username Performance Asc seen_username
uniq_followup_seen Must be unique Asc/Asc followup_id + seen_username

Relationships