TalentHuntEnquirers


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
TalentHuntEnquiries.PrimaryEnquirerId TalentHuntEnquiries_PrimaryEnquirerId_fkey R
TalentHuntEnquiries.SupervisorId TalentHuntEnquiries_SupervisorId_fkey R
email varchar 255 √ null
firstName varchar 255 √ null
lastName varchar 255 √ null
phone varchar 255 √ null
createdAt timestamptz 35,6 null
updatedAt timestamptz 35,6 null
phoneCountryCode varchar 255 √ null

Indexes

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

Check Constraints

Constraint Name Constraint
phone_country_code_check ((((phone IS NOT NULL) AND ("phoneCountryCode" IS NOT NULL)) OR ((phone IS NULL) AND ("phoneCountryCode" IS NULL))))

Relationships

Close relationships within degrees of separation