glints.employer

Table	Constraint Name	Constraint
CreditPurchaseOrderXenditQRCodePaymentRequests	CreditPurchaseOrderXenditQRCodePaymentRequests_expiryAt_check	(("expiryAt" > "requestedAt"))
CompanyCreditInventoryAddThroughProductPurchaseLogs	CompanyCreditInventoryAddThroughProductPurchaseLogs_creditProdu	((("creditProductPurchaseOrderId" IS NOT NULL) OR ("offlineSalesTransactionId" IS NOT NULL)))
PurchaseOrderProducts	PurchaseOrderProducts_quantity_check	((quantity > 0))
PurchaseOrderProducts	timePeriod_and_timePeriodUnit_check	(((("timePeriod" IS NOT NULL) AND ("timePeriod" > 0) AND ("timePeriodUnit" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL))))
CreditPackages	CreditPackages_freeCredits_check	((("freeCredits" IS NULL) OR ("freeCredits" > 0)))
CreditPackages	CreditPackages_paidCredits_check	(("paidCredits" > 0))
CreditPackages	timePeriod_and_timePeriodUnit_check	(((("timePeriod" IS NOT NULL) AND ("timePeriod" > 0) AND ("timePeriodUnit" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL))))
CompanyCreditInventories	CompanyCreditInventories_amount_check	((amount >= 0))
CompanyProductFreeTrialOffers	CompanyProductFreeTrialOffers_productQuantity_check	(("productQuantity" > 0))
CreditPrices	CreditPrices_amount_check	((amount >= (0)::numeric))
CreditProductPurchaseOrderCreditBenefits	CreditProductPurchaseOrderCreditBenefits_amount_check	((amount > 0))
CreditProductPurchaseOrderCreditBenefits	timePeriod_and_timePeriodUnit_check	(((("timePeriod" IS NOT NULL) AND ("timePeriod" > 0) AND ("timePeriodUnit" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL))))
CompanyProductSubscriptionFreeTrialOffers	CompanyProductSubscriptionFreeTrialOffers_productQuantity_check	(("productQuantity" > 0))
CompanyProductSubscriptionFreeTrialOffers	CompanyProductSubscriptionFreeTrialOffers_trialTimePeriod_check	(("trialTimePeriod" > 0))
CompanyProductSubscriptionFreeTrialOffers	timePeriod_and_timePeriodUnit_check	(((("timePeriod" IS NOT NULL) AND ("timePeriod" > 0) AND ("timePeriodUnit" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL))))
CompanyProductSubscriptions	bufferTimePeriod_bufferTimePeriodUnit_check	(((("bufferTimePeriod" IS NOT NULL) AND ("bufferTimePeriod" > 0) AND ("bufferTimePeriodUnit" IS NOT NULL)) OR (("bufferTimePeriod" IS NULL) AND ("bufferTimePeriodUnit" IS NULL))))
PurchaseOrderXenditPaymentRequests	PurchaseOrderXenditPaymentRequests_expiryAt_check	(("expiryAt" > "requestedAt"))
CreditProductPurchaseOrders	CreditProductPurchaseOrders_creditDiscountAmount_check	((("creditDiscountAmount" IS NULL) OR ("creditDiscountAmount" > 0)))
CreditProductPurchaseOrders	CreditProductPurchaseOrders_creditDiscountPercentage_check	((("creditDiscountPercentage" IS NULL) OR ("creditDiscountPercentage" > (0)::numeric)))
CreditProductPurchaseOrders	CreditProductPurchaseOrders_creditQuantity_check	(("creditQuantity" > 0))
CreditProductPurchaseOrders	CreditProductPurchaseOrders_failureType_nullable_check	((((status = 'FAILED'::employer_purchases."enum_CreditProductPurchaseOrders_status") AND ("failureType" IS NOT NULL)) OR ((status <> 'FAILED'::employer_purchases."enum_CreditProductPurchaseOrders_status") AND ("failureType" IS NULL))))
CreditProductPurchaseOrders	CreditProductPurchaseOrders_productQuantity_check	(("productQuantity" > 0))
CreditProductPurchaseOrders	productTimePeriod_and_productTimePeriodUnit_check	(((("productTimePeriod" IS NOT NULL) AND ("productTimePeriod" > 0) AND ("productTimePeriodUnit" IS NOT NULL)) OR (("productTimePeriod" IS NULL) AND ("productTimePeriodUnit" IS NULL))))
CompanyCreditInventoryLogs	CompanyCreditInventoryLogs_amount_check	((amount > 0))
CompanyCreditInventoryLogs	CompanyCreditInventoryLogs_finalBalance_check	(("finalBalance" >= 0))
CompanyProductInventories	CompanyProductInventories_amount_check	(((amount)::numeric >= (0)::numeric))
CompanyProductInventories	CompanyProductInventories_daysBeforeExpiryReminder_check	((("daysBeforeExpiryReminder" IS NULL) OR ("daysBeforeExpiryReminder" > 0)))
CreditProductPackages	CreditProductPackages_creditDiscountAmount_check	((("creditDiscountAmount" IS NULL) OR ("creditDiscountAmount" > 0)))
CreditProductPackages	CreditProductPackages_creditQuantity_check	(("creditQuantity" > 0))
CreditProductPackages	CreditProductPackages_productQuantity_check	(("productQuantity" > 0))
CreditProductPackages	timePeriod_and_timePeriodUnit_check	(((("timePeriod" IS NOT NULL) AND ("timePeriod" > 0) AND ("timePeriodUnit" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL))))
Products	timePeriod_and_timePeriodUnit_check	(((("timePeriod" IS NOT NULL) AND ("timePeriod" > 0) AND ("timePeriodUnit" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL))))
PremiumPlanProductVariantDetails	SubscriptionPlanProductVariantDetai_maxConcurrentJobSlots_check	((("maxConcurrentJobSlots" IS NULL) OR ("maxConcurrentJobSlots" > 0)))
PremiumPlanProductVariantDetails	SubscriptionPlanProductVariantDetai_minConcurrentJobSlots_check	((("minConcurrentJobSlots" IS NULL) OR ("minConcurrentJobSlots" > 0)))
PremiumPlanProductVariantDetails	SubscriptionPlanProductVariantDetails_maxConcurrentJobSlots_gre	((("minConcurrentJobSlots" IS NULL) OR ("maxConcurrentJobSlots" IS NULL) OR ("minConcurrentJobSlots" <= "maxConcurrentJobSlots")))
CreditPurchaseOrderSubscriptionDetails	CreditPurchaseOrderSubscriptio_paymentFrequencyTimePeriod_check	(("paymentFrequencyTimePeriod" > 0))
CompanyProductInventoryLogs	CompanyProductInventoryLogs_amount_check	(((amount)::numeric >= (0)::numeric))
CompanyProductInventoryLogs	CompanyProductInventoryLogs_finalBalance_check	((("finalBalance")::numeric >= (0)::numeric))
CompanyProductInventoryLogs	timePeriod_columns_check	(((("timePeriod" IS NOT NULL) AND ("timePeriod" > (0)::numeric) AND ("timePeriodUnit" IS NOT NULL) AND ("timePeriodValidityType" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL) AND ("timePeriodValidityType" IS NULL))))
JobBoostRecords	JobBoostRecords_boostedAt_boostEndsAt_check	(("boostedAt" < "boostEndsAt"))
JobProductInventoryLogs	JobProductInventoryLogs_amount_check	((amount >= 0))
JobProductInventoryLogs	JobProductInventoryLogs_finalBalance_check	(("finalBalance" >= 0))
CreditPurchaseOrders	CreditPurchaseOrders_freeCredits_check	((("freeCredits" IS NULL) OR ("freeCredits" > 0)))
CreditPurchaseOrders	CreditPurchaseOrders_paidCredits_check	(("paidCredits" > 0))
CreditPurchaseOrders	CreditPurchaseOrders_pricePerCredit_check	(("pricePerCredit" >= (0)::numeric))
CreditPurchaseOrders	CreditPurchaseOrders_taxPercentage_check	(("taxPercentage" >= (0)::numeric))
CreditPurchaseOrders	creditTimePeriod_and_creditTimePeriodUnit_check	(((("creditTimePeriod" IS NOT NULL) AND ("creditTimePeriod" > 0) AND ("creditTimePeriodUnit" IS NOT NULL)) OR (("creditTimePeriod" IS NULL) AND ("creditTimePeriodUnit" IS NULL))))
JobProductInventories	JobProductInventories_amount_check	((amount >= 0))
PurchaseOrderProductPricingDetails	PurchaseOrderProductPricingDetails_discountPercentage_check	(((("discountPercentage" IS NOT NULL) AND ("discountPercentage" > (0)::numeric)) OR ("discountPercentage" IS NULL)))
PurchaseOrderProductPricingDetails	PurchaseOrderProductPricingDetails_pricePerItem_check	(("pricePerItem" >= (0)::numeric))
PurchaseOrderInvoices	PurchaseOrderInvoices_failureMessage_nullable_check	((((status = 'FAILED'::employer_purchases."enum_employer_purchases_PurchaseOrderInvoices_status") AND ("failureMessage" IS NOT NULL)) OR ((status = ANY (ARRAY['IN_PROGRESS'::employer_purchases."enum_employer_purchases_PurchaseOrderInvoices_status", 'SUCCESS'::employer_purchases."enum_employer_purchases_PurchaseOrderInvoices_status"])) AND ("failureMessage" IS NULL)) OR (status = 'NOT_AVAILABLE'::employer_purchases."enum_employer_purchases_PurchaseOrderInvoices_status")))
CreditProductPurchaseOrderAfterPurchaseActionLogs	CreditProductPurchaseOrderAfterPurchaseActionLogs_failureType_n	((((status = 'FAILED'::employer_purchases."enum_CreditProductPurchaseOrderAfterPurchaseActionLogs_status") AND ("failureType" IS NOT NULL)) OR ((status <> 'FAILED'::employer_purchases."enum_CreditProductPurchaseOrderAfterPurchaseActionLogs_status") AND ("failureType" IS NULL))))
HierarchicalJobCategoryFreeRecommendedTalentCount	HierarchicalJobCategoryFreeRec_freeRecommendedTalentCount_check	(("freeRecommendedTalentCount" >= 0))
CompanyProductSubscriptionAfterPaymentReceivedLogs	CompanyProductSubscriptionAfterPaymentReceivedLogs_failureReaso	((((status = 'FAILED'::employer_purchases."enum_CompanyProductSubscriptionAfterPaymentReceivedLogs_status") AND ("failureReason" IS NOT NULL)) OR ((status <> 'FAILED'::employer_purchases."enum_CompanyProductSubscriptionAfterPaymentReceivedLogs_status") AND ("failureReason" IS NULL))))
CreditProductSubscriptionPackages	CreditProductSubscriptionPacka_paymentFrequencyTimePeriod_check	(("paymentFrequencyTimePeriod" > 0))
CreditProductSubscriptionPackages	CreditProductSubscriptionPackages_creditQuantity_check	(("creditQuantity" > 0))
CreditProductSubscriptionPackages	CreditProductSubscriptionPackages_productQuantity_check	(("productQuantity" > 0))
CreditProductSubscriptionPackages	timePeriod_and_timePeriodUnit_check	(((("timePeriod" IS NOT NULL) AND ("timePeriod" > 0) AND ("timePeriodUnit" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL))))
OfflineSalesTransactions	OfflineSalesTransactions_price_check	((((price IS NOT NULL) AND (price > (0)::numeric)) OR (price IS NULL)))
CompanyProductInventoryAddThroughOfflineSalesLogs	CompanyProductInventoryAddThroughOfflineSalesLogs_price_check	((((price IS NOT NULL) AND (price > (0)::numeric)) OR (price IS NULL)))
CreditPurchaseOrderInvoices	CreditPurchaseOrderInvoices_failureMessage_nullable_check	((((status = 'FAILED'::employer_purchases."enum_employer_purchases_CreditPurchaseOrderInvoices_status") AND ("failureMessage" IS NOT NULL)) OR ((status = ANY (ARRAY['IN_PROGRESS'::employer_purchases."enum_employer_purchases_CreditPurchaseOrderInvoices_status", 'SUCCESS'::employer_purchases."enum_employer_purchases_CreditPurchaseOrderInvoices_status"])) AND ("failureMessage" IS NULL)) OR (status = 'NOT_AVAILABLE'::employer_purchases."enum_employer_purchases_CreditPurchaseOrderInvoices_status")))
CreditPurchaseOrderXenditInvoicePaymentRequests	CreditPurchaseOrderXenditInvoicePaymentRequests_expiryAt_check	(("expiryAt" > "requestedAt"))
ProductUsageJobProductBenefits	ProductUsageJobProductBenefits_amount_check	((amount > 0))
CompanyCreditInventoryBreakdowns	CompanyCreditInventoryBreakdowns_amount_check	((amount >= 0))
ProductCreditBenefits	ProductCreditBenefits_amount_check	((amount > 0))
ProductCreditBenefits	timePeriod_and_timePeriodUnit_check	(((("timePeriod" IS NOT NULL) AND ("timePeriod" > 0) AND ("timePeriodUnit" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL))))
RecurringCreditTopUp	RecurringCreditTopUp_amount_check	((amount > 0))
RecurringCreditTopUp	RecurringCreditTopUp_creditProductPurchaseOrderId_offlineSalesT	((("creditProductPurchaseOrderId" IS NOT NULL) OR ("offlineSalesTransactionId" IS NOT NULL)))
RecurringCreditTopUp	RecurringCreditTopUp_nextAllocationDate_less_than_equal_endDate	((("nextAllocationDate" IS NULL) OR (("nextAllocationDate" >= "startDate") AND ("nextAllocationDate" < "endDate"))))
RecurringCreditTopUp	RecurringCreditTopUp_startDate_less_than_equal_endDate_check	(("startDate" < "endDate"))
RecurringCreditTopUp	timePeriod_and_timePeriodUnit_check	(((("timePeriod" IS NOT NULL) AND ("timePeriod" > 0) AND ("timePeriodUnit" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL))))
PurchaseOrderProductAfterPaymentActionLogs	PurchaseOrderProductAfterPaymentActionLogs_failureType_nullable	((((status = 'FAILED'::employer_purchases."enum_PurchaseOrderProductAfterPaymentActionLogs_status") AND ("failureType" IS NOT NULL)) OR ((status <> 'FAILED'::employer_purchases."enum_PurchaseOrderProductAfterPaymentActionLogs_status") AND ("failureType" IS NULL))))
PurchaseOrderPricingDetails	PurchaseOrderPricingDetails_subtotal_check	((subtotal >= (0)::numeric))
PurchaseOrderPricingDetails	PurchaseOrderPricingDetails_taxPercentage_check	(("taxPercentage" >= (0)::numeric))