Users_cdc_test


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
email varchar 255 null
password varchar 255 null
passwordResetToken varchar 255 √ null
passwordResetTokenExpiry timestamptz 35,6 √ null
preferences jsonb 2147483647 √ null
firstName varchar 255 √ null
lastName varchar 255 √ null
createdAt timestamptz 35,6 null
updatedAt timestamptz 35,6 null
CountryCode varchar 255 null
Countries.code Users_cdc_test_CountryCode_fkey N
phone varchar 255 √ null
birthDate date 13 √ null
Nationality varchar 255 √ null
Countries.code Users_cdc_test_Nationality_fkey R
lastSeen timestamptz 35,6 √ null
emailVerificationToken varchar 255 √ null
emailVerificationTokenExpiry date 13 √ null
preferredLanguage varchar 255 √ null
intro text 2147483647 √ null
resume varchar 255 √ null
profilePic varchar 255 √ null
portfolio jsonb 2147483647 √ null
role enum_Users_role 2147483647 'CANDIDATE'::"enum_Users_role"
gender enum_Users_gender 2147483647 √ null
race enum_Users_race 2147483647 √ null
isEmployed bool 1 √ null
isPublic bool 1 false
slug varchar 255 √ null
CityId int4 10 √ null
Cities.id Users_cdc_test_CityId_fkey N
metadata jsonb 2147483647 √ null
resumeText text 2147483647 √ null
residentialStatus enum_Users_residentialStatus 2147483647 √ null
candidateStatus enum_Users_candidateStatus 2147483647 'I_AM_LOOKING_FOR_JOB'::"enum_Users_candidateStatus"
candidateStatusExpiryMonth int4 10 √ null
candidateStatusExpiryYear int4 10 √ null
shadowBanned bool 1 false
BanningOperatorId uuid 2147483647 √ null
Users.id Users_cdc_test_BanningOperatorId_fkey R
banNote text 2147483647 √ null
bannedAt timestamptz 35,6 √ null
phoneNumberVerificationToken text 2147483647 √ null
phoneNumberVerificationTokenExpiry timestamptz 35,6 √ now()
companyRole text 2147483647 √ null
LocationId uuid 2147483647 √ null
Locations.id Users_cdc_test_LocationId_fkey N
highestEducationLevel enum_EducationLevel_type 2147483647 √ null
whatsappVerificationToken text 2147483647 √ null
whatsappVerificationTokenExpiry timestamptz 35,6 √ now()
whatsappNumber varchar 30 √ NULL::character varying
careerStartDate date 13 √ null
EmployerServiceRepId uuid 2147483647 √ null
Users.id Users_cdc_test_EmployerServiceRepId_fkey N
age int4 10 √ 25
workDurationInMonths varchar 255 √ 25

Indexes

Constraint Name Type Sort Column(s)
Users_cdc_test_pkey Primary key Asc id
Users_cdc_test_email_key Must be unique Asc email

Check Constraints

Constraint Name Constraint
company_role_in_company_only_check (((("companyRole" IS NOT NULL) AND (role = 'COMPANY'::"enum_Users_role")) OR ("companyRole" IS NULL)))
shadowBanned_BanningOperatorId_bannedAt_consistencyCheck (((("shadowBanned" IS FALSE) AND ("BanningOperatorId" IS NULL) AND ("banNote" IS NULL) AND ("bannedAt" IS NULL)) OR (("shadowBanned" IS TRUE) AND ("BanningOperatorId" IS NOT NULL) AND ("bannedAt" IS NOT NULL))))

Relationships

Close relationships within degrees of separation