ExpertClassPromotionMaxAmountDiscountOptions


Description

Stores the possible max amount discount values for ExpertClass promotion codes. This table is used for validating the maxAmountDiscount of the promo code before creating entries in ExpertClassPromotionCodes table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
maxAmountDiscount numeric 19,4 null

The maximum amount discount

currencyCode enum_ExpertClass_supported_currencyCode 2147483647 null

ISO 4217 Currency code

createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
ExpertClassPromotionMaxAmountDiscountOptions_pkey Primary key Asc id
ExpertClassPromotionMaxAmountDiscountOptions_maxAmountDiscount_ Must be unique Asc/Asc maxAmountDiscount + currencyCode

Relationships