ExpertClassTicketTypePriceRangeOptions


Description

Stores the options for possible expert class ticket price ranges. This table is just meant for showing the prices ranges on the expert class creation form

Columns

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

Start value of a price range

to numeric 19,4 null

End value of a price range

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)
ExpertClassTicketTypePriceRangeOptions_pkey Primary key Asc id
ExpertClassTicketTypePriceRangeOptions_from_currencyCode_unique Must be unique Asc/Asc from + currencyCode
ExpertClassTicketTypePriceRangeOptions_to_currencyCode_unique_i Must be unique Asc/Asc to + currencyCode

Check Constraints

Constraint Name Constraint
ExpertClassTicketTypePriceRangeOptions_from_greater_than_to (("from" < "to"))

Relationships