Answers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
AnswerImages.AnswerId AnswerImages_AnswerId_fkey C
AnswerNotifications.AnswerId AnswerNotifications_AnswerId_fkey R
AnswerShares.AnswerId AnswerShares_AnswerId_fkey R
AnswerUpvotes.AnswerId AnswerUpvotes_AnswerId_fkey C
Comments.AnswerId Comments_AnswerId_fkey C

primary key
QuestionId uuid 2147483647 null
Questions.id Answers_QuestionId_fkey C

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

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

created time
updatedAt timestamptz 35,6 now()

updated time
content text 2147483647 null

answer detail, we might store json string here, the reason why we don’t use jsonb is graphql is strong type, cannot return any
deletedAt timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
Answers_pkey Primary key Asc id
qn_ans_Answers_createdAt_idx Performance Asc createdAt
qn_ans_Answers_QuestionId_idx Performance Asc QuestionId
qn_ans_Answers_UserId_idx Performance Asc UserId

Relationships

Close relationships within degrees of separation