ApplicationQuestionAnswers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
ApplicationId uuid 2147483647 null
Applications.id ApplicationQuestionAnswers_ApplicationId_fkey R

Foreign Key to the Applications Table
QuestionName text 2147483647 null
CustomHiringManagerQuestionsConfigs.name ApplicationQuestionAnswers_QuestionName_fkey R

Foreign Key to the CustomHiringManagerQuestionsConfig Table
answer jsonb 2147483647 null

The answer filled by the candidate for the associated QuestionName, during the job application process
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
applicationFormVariant enum_AFC_variant 2147483647 √ null

The variant type for knowing which application form questions where shown to the user during job apply process

Indexes

Constraint Name Type Sort Column(s)
ApplicationQuestionAnswers_pkey Primary key Asc id
ApplicationId_QuestionName_unique_key Must be unique Asc/Asc ApplicationId + QuestionName

Relationships

Close relationships within degrees of separation