Reactions


Description

Reactions table, have many to one relationship with both Contents and Users tables

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
ReactionNotifications.ReactionId ReactionNotifications_ReactionId_fkey R

Primary Key.
ContentId uuid 2147483647 null
Contents.id Reactions_ContentId_fkey C

Foreign Key references Contents table.
UserId uuid 2147483647 null
Users.id Reactions_UserId_fkey C

Foreign Key references Users table.
type "gcud"."enum_Reactions_type" 2147483647 null

Reaction type.
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
Reactions_pkey Primary key Asc id
gcud_Reactions_ContentId_idx Performance Asc ContentId
gcud_Reactions_UserId_idx Performance Asc UserId
Reactions_ContentId_UserId_key Must be unique Asc/Asc ContentId + UserId

Relationships

Close relationships within degrees of separation