QuestionUpvotes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
QuestionId uuid 2147483647 null
Questions.id QuestionUpvotes_QuestionId_fkey C

composite primary key, foreign key reference to qn_ans.“Questions”
UserId uuid 2147483647 null
Users.id QuestionUpvotes_UserId_fkey R

composite primary key, foreign key reference to public.“Users”
createdAt timestamptz 35,6 now()

created time
deletedAt timestamptz 35,6 √ null
id uuid 2147483647 public.gen_random_uuid()
QuestionUpvoteNotifications.QuestionUpvoteId QuestionUpvoteNotifications_QuestionUpvoteId_fkey R

Indexes

Constraint Name Type Sort Column(s)
QuestionUpvotes_pkey Primary key Asc id
QuestionUpvotes_QuestionId_UserId_key Must be unique Asc/Asc QuestionId + UserId

Relationships

Close relationships within degrees of separation