ApplicationFormConfigByJobCategories


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
HierarchicalJobCategoryId uuid 2147483647 null
HierarchicalJobCategories.id ApplicationFormConfigByJobCatego_HierarchicalJobCategoryId_fkey R

Foreign key reference to HierarchicalJobCategories
questionConfigType enum_ApplicationQuestionConfigType 2147483647 null

Whether the question is for profile or application data
isDateOfBirthRequired enum_QuestionRequired_type 2147483647 null

Whether date of birth question is required
isGenderRequired enum_QuestionRequired_type 2147483647 null

Whether gender question is required
isEducationLevelRequired enum_QuestionRequired_type 2147483647 null

Whether highest education level question is required
isMonthlyExpectedSalaryRequired enum_QuestionRequired_type 2147483647 null

Whether monthly expected salary question is required
isResumeUploadRequired enum_QuestionRequired_type 2147483647 null

Whether resume upload question is required
firstQuestionReference varchar 255 √ null
CustomHiringManagerQuestionsConfigs.name ApplicationFormConfigByJobCategorie_firstQuestionReference_fkey R

First custom question from hiring manager
secondQuestionReference varchar 255 √ null
CustomHiringManagerQuestionsConfigs.name ApplicationFormConfigByJobCategori_secondQuestionReference_fkey R

Second custom question from hiring manager
thirdQuestionReference varchar 255 √ null
CustomHiringManagerQuestionsConfigs.name ApplicationFormConfigByJobCategorie_thirdQuestionReference_fkey R

Third custom question from hiring manager
isActive bool 1 null

Whether the question rule is active or not
createdAt timestamptz 35,6 √ now()
updatedAt timestamptz 35,6 √ now()
variant enum_AFC_variant 2147483647 √ null

The variant type for deciding which application form questions to display for a given job category
fourthQuestionReference varchar 255 √ NULL::character varying
CustomHiringManagerQuestionsConfigs.name ApplicationFormConfigByJobCategori_fourthQuestionReference_fkey R

Fourth custom question from hiring manager
fifthQuestionReference varchar 255 √ NULL::character varying
CustomHiringManagerQuestionsConfigs.name ApplicationFormConfigByJobCategorie_fifthQuestionReference_fkey R

Fifth custom question from hiring manager
sixthQuestionReference varchar 255 √ NULL::character varying
CustomHiringManagerQuestionsConfigs.name ApplicationFormConfigByJobCategorie_sixthQuestionReference_fkey R

Sixth custom question from hiring manager
isWhatsappNumberRequired enum_QuestionRequired_type 2147483647 'REQUIRED'::"enum_QuestionRequired_type"
isProfilePictureRequired enum_QuestionRequired_type 2147483647 'HIDDEN'::"enum_QuestionRequired_type"

Indexes

Constraint Name Type Sort Column(s)
ApplicationFormConfigByJobCategories_pkey Primary key Asc id
AFC_HierarchicalJobCategoryId_variant_unique_idx Must be unique Asc/Asc HierarchicalJobCategoryId + variant

Relationships

Close relationships within degrees of separation