Polls


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
PollOptions.PollId PollOptions_PollId_fkey C

primary key
QuestionId uuid 2147483647 null
Questions.id Polls_QuestionId_fkey C

foreign key reference to qn_ans.“Questions”
type enum_Poll_type 2147483647 null

enum, refer to api codebase EPollType
createdAt timestamptz 35,6 now()

created time
updatedAt timestamptz 35,6 now()

updated time
deletedAt timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
Polls_pkey Primary key Asc id
Polls_QuestionId_key Must be unique Asc QuestionId

Relationships

Close relationships within degrees of separation