glints.public

Table	Constraint Name	Constraint
WhatsappLogs	WhatsappLogs_failureReason_nullable_check	((((status = 'FAILED'::"enum_WhatsappLogs_status") AND ("failureReason" IS NOT NULL)) OR ((status <> 'FAILED'::"enum_WhatsappLogs_status") AND ("failureReason" IS NULL))))
LiveRooms	LiveRooms_maxParticipants_check	(("maxParticipants" >= 0))
Preferences	Preferences_maxSalaryExpectation_check	(((("salaryExpectation" IS NOT NULL) AND (COALESCE("maxSalaryExpectation", 0) >= COALESCE("salaryExpectation", 0))) OR ("maxSalaryExpectation" IS NULL)))
Preferences	preferredStartDateCheck	(("preferredStartDate" <= '9999-12-31 23:59:59+00'::timestamp with time zone))
OdysseyMaxApplicationsNotifications	OdysseyMaxApplicationsNotifications_applicationCount_check	(("applicationCount" > 0))
ReportedJobs	ReportedJobs_resolution_reason_if_invalid	(((("resolutionStatus" = 'INVALID'::"enum_ReportResolutionStatus") AND ("resolutionReason" IS NOT NULL)) OR (("resolutionStatus" = ANY (ARRAY['PENDING'::"enum_ReportResolutionStatus", 'VALID'::"enum_ReportResolutionStatus"])) AND ("resolutionReason" IS NULL))))
Companies	check_chatTranscripts_length	((array_length("chatTranscripts", 1) <= 5))
Companies	check_companyPICSelfies_length	((array_length("companyPICSelfies", 1) <= 5))
UserCompanyRoleLogs	previousRole_and_updatedRole_check	(("previousRole" <> "updatedRole"))
Users_cdc_test	company_role_in_company_only_check	(((("companyRole" IS NOT NULL) AND (role = 'COMPANY'::"enum_Users_role")) OR ("companyRole" IS NULL)))
Users_cdc_test	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))))
OdysseyTargets	OdysseyTargets_applicationsPerWeek_check	(("applicationsPerWeek" > 0))
OdysseyTargets	OdysseyTargets_durationInDays_check	(("durationInDays" > 0))
ExpertClassTicketTypePriceOptions	ExpertClassTicketTypePriceOptions_isDefault_true_or_null	("isDefault")
Jobs	Jobs_closedAt_check	((((status = 'CLOSED'::"enum_Jobs_status") AND ("closedAt" IS NOT NULL)) OR ((status <> 'CLOSED'::"enum_Jobs_status") AND ("closedAt" IS NULL))))
Jobs	Jobs_expiryDate_check	(("expiryDate" <= (now() + '41 days'::interval))) NOT VALID
Jobs	Jobs_HierarchicalJobCategoryId_not_null_non_closed_Jobs	(((status = 'CLOSED'::"enum_Jobs_status") OR ("HierarchicalJobCategoryId" IS NOT NULL)))
Jobs	Jobs_maxAge_check	(((("maxAge" IS NOT NULL) AND ("maxAge" >= 0) AND ("maxAge" <= 100)) OR ("maxAge" IS NULL)))
Jobs	Jobs_minAge_check	(((("minAge" IS NOT NULL) AND ("minAge" >= 0) AND ("minAge" <= 100)) OR ("minAge" IS NULL)))
Jobs	Jobs_no_duplicate_job_constraint	(((companies_get_country_code("CompanyId") <> 'VN'::text) OR (status <> 'OPEN'::"enum_Jobs_status") OR jobs_check_duplicate_job(id, (title)::text, "DistrictId", "descriptionRaw"))) NOT VALID
Jobs	minAge_and_maxAge_check	(((("minAge" IS NOT NULL) AND ("maxAge" IS NOT NULL) AND ("minAge" < "maxAge")) OR ("minAge" IS NULL) OR ("maxAge" IS NULL)))
TalentHuntEnquirers	phone_country_code_check	((((phone IS NOT NULL) AND ("phoneCountryCode" IS NOT NULL)) OR ((phone IS NULL) AND ("phoneCountryCode" IS NULL))))
JobDrafts	JobDrafts_maxAge_check	(((("maxAge" IS NOT NULL) AND ("maxAge" >= 0) AND ("maxAge" <= 100)) OR ("maxAge" IS NULL)))
JobDrafts	JobDrafts_minAge_check	(((("minAge" IS NOT NULL) AND ("minAge" >= 0) AND ("minAge" <= 100)) OR ("minAge" IS NULL)))
JobDrafts	minAge_and_maxAge_check	(((("minAge" IS NOT NULL) AND ("maxAge" IS NOT NULL) AND ("minAge" < "maxAge")) OR ("minAge" IS NULL) OR ("maxAge" IS NULL)))
OrderPayments	OrderPayments_amount_check	((total > (0)::numeric))
JobFraudAnalysisRecords	JobFraudAnalysisRecords_analysisStatus_reason_nullable_check	(((("analysisStatus" = 'FAILED'::"enum_JobFraudAnalysisRecords_analysisStatus") AND ("reasonForFailure" IS NOT NULL)) OR (("analysisStatus" <> 'FAILED'::"enum_JobFraudAnalysisRecords_analysisStatus") AND ("reasonForFailure" IS NULL))))
ExpertApplicationWorkExperiences	ExpertApplicationWorkExperiences_experienceType_check	(("experienceType" = 'WORK'::"enum_Experiences_type"))
XenditPaymentRequestCallbackLogs	XenditPaymentRequestCallbackLogs_transactionFailureCode_nullabl	(((("transactionStatus" = 'FAILED'::"enum_XenditPaymentRequestCallbackLogs_transactionStatus") AND ("transactionFailureCode" IS NOT NULL)) OR (("transactionStatus" <> 'FAILED'::"enum_XenditPaymentRequestCallbackLogs_transactionStatus") AND ("transactionFailureCode" IS NULL))))
RevenueCatWebhookLogs	RevenueCatWebhookLogs_failureReason_nullable_check	((((status = 'FAILED'::"enum_RevenueCatWebhookLogs_status") AND ("failureReason" IS NOT NULL)) OR ((status <> 'FAILED'::"enum_RevenueCatWebhookLogs_status") AND ("failureReason" IS NULL)))) NOT VALID
CompanyStatusLog	CompanyStatusLog_statusChangeReason_check	((("statusChangeReason" IS NULL) OR (("statusChangeReason" = 'VERIFICATION_WHITELISTED_EMAIL_DOMAIN'::"enum_CompanyStatusLog_statusChangeReason") AND (status = 'VERIFIED'::"enum_Company_status")) OR (("statusChangeReason" = ANY (ARRAY['DUPLICATE_LEGAL_REGISTRATION_NUMBER'::"enum_CompanyStatusLog_statusChangeReason", 'BLACKLISTED_LEGAL_REGISTRATION_NUMBER'::"enum_CompanyStatusLog_statusChangeReason", 'INVALID_BUSINESS_LICENSE'::"enum_CompanyStatusLog_statusChangeReason"])) AND (status = 'REJECTED'::"enum_Company_status"))))
ExpertClassTicketTypes	ExpertClassTicketType_endSalesAt_check	(("endSalesAt" > "startSalesAt"))
ExpertClassTicketTypes	ExpertClassTicketTypes_quantity_check	(("reservedQuantity" <= "maxQuantity"))
ExpertClassTicketTypePriceRangeOptions	ExpertClassTicketTypePriceRangeOptions_from_greater_than_to	(("from" < "to"))
CompanyVerificationRequests	CompanyVerificationRequests_approved_status_check	((((status = 'APPROVED'::"enum_CompanyVerificationRequests_status") AND ("approvedAt" IS NOT NULL)) OR ((status <> 'APPROVED'::"enum_CompanyVerificationRequests_status") AND ("approvedAt" IS NULL))))
CompanyVerificationRequests	rejectionReasons_and_rejectionReasonText_check	((((status = 'REJECTED'::"enum_CompanyVerificationRequests_status") AND ("rejectionReasons" IS NOT NULL) AND ("rejectionReasonText" IS NOT NULL)) OR ((status <> 'REJECTED'::"enum_CompanyVerificationRequests_status") AND ("rejectionReasons" IS NULL) AND ("rejectionReasonText" IS NULL))))
StreakPointSources	StreakPointSources_streakAmount_check	(("streakAmount" > 0))
CompanyApplicationCountAggregates	CompanyApplicationCountAggregates_applicationCount_check	(("applicationCount" >= 0))
ExpertClassBanners	ExpertClassBanners_endsAt_check	(("endsAt" > "startsAt"))
ExpertClassBanners	ExpertClassBanners_order_check	(("order" > 0))
HoustonTransferCompanyTaskLogs	HoustonTransferCompanyTaskLogs_taskStatus_errorMessage_check	((("taskStatus" = 'FAILURE'::"enum_HoustonTransferCompanyTaskLogs_taskStatus") OR ("errorMessage" IS NULL)))
HoustonTransferCompanyTaskLogs	HoustonTransferCompanyTaskLogs_taskStatus_jobsTransferred_check	((("taskStatus" = 'SUCCESS'::"enum_HoustonTransferCompanyTaskLogs_taskStatus") OR ("jobsTransferred" IS NULL)))
ExpertClassReminderNotifications	ExpertClassReminderNotifications_millisBeforeStartTime_check	(("millisBeforeStartTime" >= 0))
ExpertClassReminderNotifications	ExpertClassReminderNotifications_millisBeforeStartTime_options_	((("millisBeforeStartTime" = 3600000) OR ("millisBeforeStartTime" = 86400000)))
CompanyDeletionRequests	CompanyDeletionRequests_status_errorMessage_check	((((status = 'FAILURE'::"enum_CompanyDeletionRequests_status") AND ("errorMessage" IS NOT NULL)) OR ((status <> 'FAILURE'::"enum_CompanyDeletionRequests_status") AND ("errorMessage" IS NULL))))
Users	company_role_in_company_only_check	(((("companyRole" IS NOT NULL) AND (role = 'COMPANY'::"enum_Users_role")) OR ("companyRole" IS NULL)))
Users	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))))
CompanyVerificationRequestStatusChangeLogs	previousStatus_and_updatedStatus_check	(("previousStatus" <> "updatedStatus"))
OdysseyPointAllocations	OdysseyPointAllocations_value_check	((value > 0))
OdysseyWeeklyTargetNotifications	OdysseyWeeklyTargetNotifications_pointsToNextBadge_check	(("pointsToNextBadge" > 0))
UserResumeParserUsageCounts	UserResumeParserUsageCounts_countForDaxtra_check	(("countForDaxtra" > 0))
ExpertClassPromotionCodes	ExpertClassPromotionCodes_code_lowercase_check	(((code)::text = lower((code)::text)))
ExpertClassPromotionCodes	ExpertClassPromotionCodes_maxAmountDiscount_check	(((("maxAmountDiscount" IS NOT NULL) AND ("maxAmountDiscount" > (0)::numeric)) OR ("maxAmountDiscount" IS NULL)))
ExpertClassPromotionCodes	ExpertClassPromotionCodes_minExpertClassPriceToApply_check	(((("minExpertClassPriceToApply" IS NOT NULL) AND ("minExpertClassPriceToApply" > (0)::numeric)) OR ("minExpertClassPriceToApply" IS NULL)))
ExpertClassPromotionCodes	ExpertClassPromotionCodes_startsAt_check	((("expiresAt" IS NULL) OR ("startsAt" <= "expiresAt"))) NOT VALID
ExpertClassApplications	ExpertClassApplications_applicationStatus_check	(((("classStatus" IS NOT NULL) AND ("applicationStatus" = 'APPROVED'::"enum_ExpertClassApplicationStatus_type")) OR (("classStatus" IS NULL) AND ("applicationStatus" <> 'APPROVED'::"enum_ExpertClassApplicationStatus_type"))))
ExpertClassApplications	ExpertClassApplications_numberOfRelatedClasses_check	(("numberOfRelatedClasses" >= 0))
DailyMetricsForJobs	DailyMetricsForJobs_applicationsCount_check	(("applicationsCount" >= 0))
DailyMetricsForJobs	DailyMetricsForJobs_clicksCount_check	(("clicksCount" >= 0))
DailyMetricsForJobs	DailyMetricsForJobs_expiredApplicationsCount_check	(("expiredApplicationsCount" >= 0))
DailyMetricsForJobs	DailyMetricsForJobs_impressionsCount_check	(("impressionsCount" >= 0))
DailyMetricsForJobs	DailyMetricsForJobs_processedApplicationsCount_check	(("processedApplicationsCount" >= 0))
DailyMetricsForJobs	DailyMetricsForJobs_shortlistedApplicationsCount_check	(("shortlistedApplicationsCount" >= 0))
DailyMetricsForJobs	DailyMetricsForJobs_viewedApplicationsCount_check	(("viewedApplicationsCount" >= 0))
UserMessagingResponseStatistics	UserMessagingResponseStatistics_responseRate_check	((("responseRate" >= (0)::double precision) AND ("responseRate" <= (1)::double precision)))
UserMessagingResponseStatistics	UserMessagingResponseStatistics_responseTime_check	(("responseTime" >= (0)::double precision))
ExpertClassApplicationCSVExportRequests	ExpertClassApplicationCSVExportRequests_toDate_greater_than_fro	(("fromDate" <= "toDate"))
RecommendationRejectionReasons	RecommendationRejectionReasons_otherReason_check	(((reason = 'OTHER'::"enum_Recommendations_rejectionReason") OR ((reason <> 'OTHER'::"enum_Recommendations_rejectionReason") AND ("otherReason" IS NULL))))
FraudUpdateForJobs	FraudUpdateForJobs_fraudReportFlag_check	(("previousFraudReportFlag" <> "newFraudReportFlag"))
FraudUpdateForJobs	FraudUpdateForJobs_updateType_houstonUserId_nullable_check	(((("updateType" = 'MANUAL'::"enum_FraudUpdateForJobs_updateType") AND ("houstonUserId" IS NOT NULL)) OR (("updateType" = 'AUTO'::"enum_FraudUpdateForJobs_updateType") AND ("houstonUserId" IS NULL))))
SuggestedJobValuesByCategory	SuggestedJobValuesByCategory_check_experience_range	(("minYearsOfExperience" < "maxYearsOfExperience"))
SuggestedJobValuesByCategory	SuggestedJobValuesByCategory_maxYearsOfExperience_check	((("maxYearsOfExperience" >= 0) AND ("maxYearsOfExperience" <= 50)))
SuggestedJobValuesByCategory	SuggestedJobValuesByCategory_minYearsOfExperience_check	((("minYearsOfExperience" >= 0) AND ("minYearsOfExperience" <= 50)))
Following	FollowerUserId_cannot_be_equal_to_FollowerUserId	(("FollowedUserId" <> "FollowerUserId"))
MobileAppVersions	MobileAppVersions_major_check	((major >= 0))
MobileAppVersions	MobileAppVersions_minor_check	((minor >= 0))
MobileAppVersions	MobileAppVersions_patch_check	((patch >= 0))
AppleLoginFields	AppleLoginFields_IdentitiesType_check	(("IdentitiesType" = 'APPLE'::"enum_Identities_type"))
ExpertClassGoogleInAppPayments	ExpertClassGoogleInAppPayments_paymentProvider_check	(("paymentProvider" = 'GOOGLE_PLAY'::"enum_Payment_provider"))
TalentHuntEnquiries	company_phone_country_code_check	(((("companyPhone" IS NOT NULL) AND ("companyPhoneCountryCode" IS NOT NULL)) OR (("companyPhone" IS NULL) AND ("companyPhoneCountryCode" IS NULL))))
FraudCaseFiles	FraudCaseFiles_status_valid	((((status = 'PENDING'::"enum_FraudCaseFiles_status") AND ("statusReason" = ANY (ARRAY['FURTHER_INVESTIGATION_REQUIRED'::"enum_FraudCaseFiles_statusReason", 'WAITING_FOR_FOLLOW_UP_RESULT'::"enum_FraudCaseFiles_statusReason", 'WAITING_FOR_QUANTITATIVE_EVIDENCE'::"enum_FraudCaseFiles_statusReason", 'REOPENED'::"enum_FraudCaseFiles_statusReason"]))) OR ((status = 'RESOLVED'::"enum_FraudCaseFiles_status") AND ("statusReason" = ANY (ARRAY['CONFIRMED_FRAUD'::"enum_FraudCaseFiles_statusReason", 'DIRECT_TO_QUALITY'::"enum_FraudCaseFiles_statusReason", 'COMPANY_ALREADY_BLOCKED'::"enum_FraudCaseFiles_statusReason", 'CONFIRMED_NOT_FRAUD'::"enum_FraudCaseFiles_statusReason"]))) OR ((status = 'IGNORED'::"enum_FraudCaseFiles_status") AND ("statusReason" IS NULL))))
NoRecentApplicationStatusNotifications	data_json_applications_count_value_check	(("dataJson" @? '$."applicationsCount"[*]?(@ >= 0)'::jsonpath))
NoRecentApplicationStatusNotifications	data_json_applicationsCreatedSince_key_value_check	(((("dataJson")::json -> 'applicationsCreatedSince'::text) IS NOT NULL))
NoRecentApplicationStatusNotifications	data_json_applicationsCreatedUntil_key_value_check	(((("dataJson")::json -> 'applicationsCreatedUntil'::text) IS NOT NULL))
NoRecentApplicationStatusNotifications	data_json_applicationsStatuses_key_value_check	((((("dataJson")::json -> 'applicationsStatuses'::text) IS NOT NULL) AND (json_array_length((("dataJson")::json -> 'applicationsStatuses'::text)) >= 1)))
NoRecentApplicationStatusNotifications	data_json_company_logo_key_value_check	((((("dataJson")::json -> 'companyLogos'::text) IS NOT NULL) AND (json_array_length((("dataJson")::json -> 'companyLogos'::text)) >= 1)))
NoRecentApplicationStatusNotifications	data_json_job_title_key_value_check	(((("dataJson")::json -> 'jobTitle'::text) IS NOT NULL))