Following


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
FollowingNewFollowerNotifications.FollowingId FollowingNewFollowerNotifications_FollowingId_fkey R
FollowedUserId uuid 2147483647 null
Users.id Following_FollowedUserId_fkey R
FollowerUserId uuid 2147483647 null
Users.id Following_FollowerUserId_fkey R
createdAt timestamptz 35,6 null
updatedAt timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
Following_pkey Primary key Asc id
Following_FollowerUserId_FollowedUserId Must be unique Asc/Asc FollowerUserId + FollowedUserId

Check Constraints

Constraint Name Constraint
FollowerUserId_cannot_be_equal_to_FollowerUserId (("FollowedUserId" <> "FollowerUserId"))

Relationships

Close relationships within degrees of separation