Groups


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
DeletedPosts.GroupId DeletedPosts_GroupId_fkey C
GroupRenameNotifications.GroupId GroupRenameNotifications_GroupId_fkey C
GroupShares.GroupId GroupShares_GroupId_fkey N
GroupUsers.GroupId GroupUsers_GroupId_fkey R
MyGroupNewPostsNotificationTopGroups.groupId MyGroupNewPostsNotificationTopGroups_groupId_fkey C
Posts.GroupId Posts_GroupId_fkey R

primary key
createdAt timestamptz 35,6 now()

created time
updatedAt timestamptz 35,6 now()

updated time
profileImage text 2147483647 null

profile image file name on s3
coverImage text 2147483647 null

cover image file name on s3
name text 2147483647 null

group name
description text 2147483647 √ null

group description
UserId uuid 2147483647 null
Users.id Groups_UserId_fkey R

the creator, foreign key, reference to public.“Users”
GroupTypeId uuid 2147483647 null
GroupTypes.id Groups_GroupTypeId_fkey R

foreign key, reference to gcud.“GroupTypes”

Indexes

Constraint Name Type Sort Column(s)
Groups_pkey Primary key Asc id
gcud_Groups_createdAt_idx Performance Asc createdAt
gcud_Groups_GroupTypeId_idx Performance Asc GroupTypeId
gcud_Groups_UserId_idx Performance Asc UserId

Relationships

Close relationships within degrees of separation