PremiumPlanProductVariantDetails


Columns

Column Type Size Nulls Auto Default Children Parents Comments
productId uuid 2147483647 null
Products.id SubscriptionPlanProductVariantDetails_productId_fkey C
planType "employer_commerce"."enum_SubscriptionPlan_types" 2147483647 null
minConcurrentJobSlots int4 10 √ null
maxConcurrentJobSlots int4 10 √ null
hasVIPMembership bool 1 null
hasCSVDownload bool 1 null
hasJobExternalUrl bool 1 null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
automatedCSVExport jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
SubscriptionPlanProductVariantDetails_pkey Primary key Asc productId
PremiumPlanProductVariantDetails_productId_planType_key Must be unique Asc/Asc productId + planType

Check Constraints

Constraint Name Constraint
SubscriptionPlanProductVariantDetai_minConcurrentJobSlots_check ((("minConcurrentJobSlots" IS NULL) OR ("minConcurrentJobSlots" > 0)))
SubscriptionPlanProductVariantDetails_maxConcurrentJobSlots_gre ((("minConcurrentJobSlots" IS NULL) OR ("maxConcurrentJobSlots" IS NULL) OR ("minConcurrentJobSlots" <= "maxConcurrentJobSlots")))
SubscriptionPlanProductVariantDetai_maxConcurrentJobSlots_check ((("maxConcurrentJobSlots" IS NULL) OR ("maxConcurrentJobSlots" > 0)))

Relationships

Close relationships within degrees of separation