TalentHuntEnquiries


Description

None of the keys in this table are unique since we want to allow duplicates, this being a public form. You do not want someone else to enter your email and then you are not allowed to enter a enquiry.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
companyName varchar 255 null
companyAddress text 2147483647 null
companyPostalCode varchar 255 null
CompanyCityId int4 10 null
Cities.id TalentHuntEnquiries_CompanyCityId_fkey R
companyLegalName varchar 255 null
companyPhone varchar 255 √ null
PrimaryEnquirerId uuid 2147483647 null
TalentHuntEnquirers.id TalentHuntEnquiries_PrimaryEnquirerId_fkey R
primaryEnquirerRole varchar 255 null
SupervisorId uuid 2147483647 √ null
TalentHuntEnquirers.id TalentHuntEnquiries_SupervisorId_fkey R
supervisorRole varchar 255 √ null
createdAt timestamptz 35,6 null
updatedAt timestamptz 35,6 null
companyPhoneCountryCode varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
TalentHuntEnquiries_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
company_phone_country_code_check (((("companyPhone" IS NOT NULL) AND ("companyPhoneCountryCode" IS NOT NULL)) OR (("companyPhone" IS NULL) AND ("companyPhoneCountryCode" IS NULL))))

Relationships

Close relationships within degrees of separation