Skip to content

public.club_price_list

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false Unique identifier for the price list(DC2Type:uuid)
assigned_club_id uuid false public.club Reference to the club this price list is assigned to. Required for all price lists.(DC2Type:uuid)
created_at date false Timestamp when the price list was created(DC2Type:date_immutable)
valid_from date false Date from which this price list becomes valid and applicable(DC2Type:date_immutable)
pricing json false JSON array containing custom pricing rules and conditions for different time slots or scenarios
contentful_id varchar(64) false Unique identifier from Contentful CMS for syncing price list data
fallback_price_per_hour_amount bigint false
fallback_price_per_hour_currency character(3) false (DC2Type:currency)
is_active boolean false false Flag indicating whether this price list is currently active and should be used for pricing calculations
title varchar(255) NULL::character varying true Human-readable title or name for the price list

Constraints

Name Type Definition
fk_705c444f6b81b2bd FOREIGN KEY FOREIGN KEY (assigned_club_id) REFERENCES club(id)
club_price_list_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
club_price_list_pkey CREATE UNIQUE INDEX club_price_list_pkey ON public.club_price_list USING btree (id)
idx_705c444f6b81b2bd CREATE INDEX idx_705c444f6b81b2bd ON public.club_price_list USING btree (assigned_club_id)
uniq_705c444fd756ce8c CREATE UNIQUE INDEX uniq_705c444fd756ce8c ON public.club_price_list USING btree (contentful_id)

Relations

er


Generated by tbls