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))
ReportedJobs	ReportedJobs_issueCategories_is_array_check	((jsonb_typeof("issueCategories") = 'array'::text))
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))))
Jobs	Jobs_closedAt_check	((((status = 'CLOSED'::"enum_Jobs_status") AND ("closedAt" IS NOT NULL)) OR (status = 'DELETED'::"enum_Jobs_status") OR ((status <> ALL (ARRAY['CLOSED'::"enum_Jobs_status", 'DELETED'::"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_metadata_closureInfo_valid	( CASE WHEN ((jsonb_typeof(metadata) = 'object'::text) AND (metadata ? 'closureInfo'::text)) THEN (((jsonb_typeof((metadata -> 'closureInfo'::text)) = 'object'::text) AND (((metadata -> 'closureInfo'::text) ->> 'triggerType'::text) = ANY (ARRAY['EMPLOYER_DEACTIVATION'::text, 'JOB_EXPIRY'::text])) AND (((metadata -> 'closureInfo'::text) ->> 'employerResponseStatus'::text) = ANY (ARRAY['PENDING'::text, 'DISMISSED'::text, 'SUBMITTED'::text])) AND (jsonb_typeof(((metadata -> 'closureInfo'::text) -> 'jobStatusLogId'::text)) = 'string'::text) AND (length(btrim(((metadata -> 'closureInfo'::text) ->> 'jobStatusLogId'::text))) > 0) AND ((((metadata -> 'closureInfo'::text) ->> 'employerResponseStatus'::text) <> 'SUBMITTED'::text) OR ((jsonb_typeof(((metadata -> 'closureInfo'::text) -> 'answers'::text)) = 'object'::text) AND (jsonb_typeof((((metadata -> 'closureInfo'::text) -> 'answers'::text) -> 'reason'::text)) = 'string'::text) AND (length(btrim((((metadata -> 'closureInfo'::text) -> 'answers'::text) ->> 'reason'::text))) > 0) AND (jsonb_typeof(((metadata -> 'closureInfo'::text) -> 'submittedAt'::text)) = 'string'::text) AND (length(btrim(((metadata -> 'closureInfo'::text) ->> 'submittedAt'::text))) > 0) AND (jsonb_typeof(((metadata -> 'closureInfo'::text) -> 'submittedByUserId'::text)) = 'string'::text) AND (length(btrim(((metadata -> 'closureInfo'::text) ->> 'submittedByUserId'::text))) > 0)))) IS TRUE) ELSE true END) NOT VALID
Jobs	Jobs_minAge_check	(((("minAge" IS NOT NULL) AND ("minAge" >= 0) AND ("minAge" <= 100)) OR ("minAge" IS NULL)))
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))
AccountManagerHubspotDealBatches	AccountManagerHubspotDealBatches_companyIds_check	((jsonb_typeof("companyIds") = 'array'::text))
AccountManagerHubspotDealBatches	AccountManagerHubspotDealBatches_results_check	((jsonb_typeof(results) = 'array'::text))
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))))
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")) OR (("statusChangeReason" = 'LAST_USER_DELETED'::"enum_CompanyStatusLog_statusChangeReason") AND (status = 'DELETED'::"enum_Company_status"))))
CompanyFraudRuleExemptions	CompanyFraudRuleExemptions_reason_check	((length(btrim(reason)) > 0))
CompanyFraudRuleExemptions	CompanyFraudRuleExemptions_revocation_check	(((("revokedAt" IS NULL) AND ("RevokedById" IS NULL) AND ("revocationReason" IS NULL)) OR (("revokedAt" IS NOT NULL) AND (length(btrim("revocationReason")) > 0))))
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))))
CompanyApplicationCountAggregates	CompanyApplicationCountAggregates_applicationCount_check	(("applicationCount" >= 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)))
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))))
WorkbenchPresets	WorkbenchPresets_access_class_check	((("accessClass" IS NULL) OR ("accessClass" = ANY (ARRAY['STANDARD'::text, 'RESTRICTED'::text]))))
WorkbenchPresets	WorkbenchPresets_enabled_classification_check	(((NOT "isEnabled") OR (("groupKey" IS NOT NULL) AND ("accessClass" IS NOT NULL) AND ("ownerTeamKey" IS NOT NULL))))
CompanyVerificationRequestStatusChangeLogs	previousStatus_and_updatedStatus_check	(("previousStatus" <> "updatedStatus"))
OdysseyPointAllocations	OdysseyPointAllocations_value_check	((value > 0))
JobCSVExportRequests	JobCSVExportRequests_reportingWindowDays_check	((("reportingWindowDays" >= 1) AND ("reportingWindowDays" <= 90)))
UserResumeParserUsageCounts	UserResumeParserUsageCounts_countForDaxtra_check	(("countForDaxtra" > 0))
MatchKeywordsPool	MatchKeywordsPool_normalized_source_check	(((NOT "isNormalized") OR ("sourceId" IS NOT NULL)))
JobStatusLogs	JobStatusLogs_closureInfo_valid	((("closureInfo" IS NULL) OR (((jsonb_typeof("closureInfo") = 'object'::text) AND (("closureInfo" ->> 'triggerType'::text) = ANY (ARRAY['EMPLOYER_DEACTIVATION'::text, 'JOB_EXPIRY'::text])) AND (("closureInfo" ->> 'employerResponseStatus'::text) = ANY (ARRAY['PENDING'::text, 'DISMISSED'::text, 'SUBMITTED'::text])) AND (jsonb_typeof(("closureInfo" -> 'jobStatusLogId'::text)) = 'string'::text) AND (length(btrim(("closureInfo" ->> 'jobStatusLogId'::text))) > 0) AND ((("closureInfo" ->> 'employerResponseStatus'::text) <> 'SUBMITTED'::text) OR ((jsonb_typeof(("closureInfo" -> 'answers'::text)) = 'object'::text) AND (jsonb_typeof((("closureInfo" -> 'answers'::text) -> 'reason'::text)) = 'string'::text) AND (length(btrim((("closureInfo" -> 'answers'::text) ->> 'reason'::text))) > 0) AND (jsonb_typeof(("closureInfo" -> 'submittedAt'::text)) = 'string'::text) AND (length(btrim(("closureInfo" ->> 'submittedAt'::text))) > 0) AND (jsonb_typeof(("closureInfo" -> 'submittedByUserId'::text)) = 'string'::text) AND (length(btrim(("closureInfo" ->> 'submittedByUserId'::text))) > 0)))) IS TRUE))) NOT VALID
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))
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"))
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))