| id |
uuid |
|
false |
public.club_facility public.club_image public.coach_club public.court public.game public.group public.liked_clubs public.training_schedule public.user_group_club public.opening_time public.match_series public.club_event public.club_price_list public.day_opening_time_override public.access_grant public.club_equipment |
|
Unique identifier for the club(DC2Type:uuid) |
| contentful_id |
varchar(64) |
|
false |
|
|
External identifier from Contentful CMS for content management |
| name |
varchar(255) |
NULL::character varying |
true |
|
|
Display name of the club |
| address_street_name |
varchar(255) |
NULL::character varying |
true |
|
|
Street name of the address |
| address_building_number |
varchar(255) |
NULL::character varying |
true |
|
|
Building/house number of the address |
| address_postal_code |
varchar(255) |
NULL::character varying |
true |
|
|
Postal/ZIP code of the address |
| address_locality_name |
varchar(255) |
NULL::character varying |
true |
|
|
City or locality name of the address |
| location_latitude |
numeric(9,7) |
|
false |
|
|
Latitude coordinate of the geographic position (decimal degrees). |
| location_longitude |
numeric(9,7) |
|
false |
|
|
Longitude coordinate of the geographic position (decimal degrees). |
| contact_name |
varchar(255) |
NULL::character varying |
true |
|
|
Contact name or organization name. |
| contact_website |
varchar(255) |
NULL::character varying |
true |
|
|
Website URL for the contact. |
| contact_phone_number |
varchar(255) |
NULL::character varying |
true |
|
|
Phone number for contacting. |
| contact_email_address |
varchar(255) |
NULL::character varying |
true |
|
|
Email address for contacting. |
| contact_profile_image_url |
varchar(255) |
NULL::character varying |
true |
|
|
URL to the contact profile image or avatar. |
| is_active |
boolean |
false |
false |
|
|
Flag indicating whether the club is currently active and operational |
| main_image_id |
uuid |
|
true |
|
public.image |
Unique identifier for the image record(DC2Type:uuid) |
| opening_times_as_json |
json |
'{}'::json |
false |
|
|
JSON-encoded opening hours schedule for the club |
| operator_name |
varchar(255) |
|
false |
|
|
Name of the club operator or management company |
| court_pricing_as_json |
json |
'{}'::json |
false |
|
|
JSON-encoded pricing information for court reservations |
| timezone |
varchar(255) |
|
false |
|
|
IANA timezone identifier for the club location (e.g., Europe/Berlin) |
| default_price_per_hour_amount |
bigint |
|
false |
|
|
|
| default_price_per_hour_currency |
character(3) |
NULL::bpchar |
false |
|
|
(DC2Type:currency) |
| description |
text |
|
true |
|
|
Detailed description of the club, its features, and offerings |
| subdivision_code |
varchar(255) |
NULL::character varying |
true |
|
|
ISO 3166-2 subdivision code (e.g., DE-BE for Berlin, Germany) for regional settings |
| wellpass_api_key |
varchar(255) |
NULL::character varying |
true |
|
|
API key for Wellpass integration to enable partner access |
| is_wellpass_enabled |
boolean |
false |
false |
|
|
Flag indicating whether Wellpass integration is enabled for this club |
| is_shown_in_app |
boolean |
false |
false |
|
|
Flag indicating whether the club should be visible in the mobile app |
