CourseDoubtDiscussionChat

13427 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"CourseDoubtDiscussionChat_id_seq"'::regclass)
uuid uuid 2147483647 null
userId int4 10 null
User.id Implied Constraint R
courseDoubtDiscussionId int4 10 null
CourseDoubtDiscussion.id Implied Constraint R
message text 2147483647 √ null
isDeleted bool 1 √ false
fileLink varchar 255 √ null
filetype varchar 255 √ null
fileSize varchar 255 √ null
fileName varchar 255 √ null
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
replyMessage jsonb 2147483647 √ null
readBy jsonb 2147483647 √ null
replyTo int4 10 √ null
isEdited bool 1 √ false
mentionedUsers jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
CourseDoubtDiscussionChat_pkey Primary key Asc id
CourseDoubtDiscussionChat_id_idx Performance Asc id
CourseDoubtDiscussionChat_uuid_idx Performance Asc uuid
CourseDoubtDiscussionChat_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation