public.club

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
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		(DC2Type:uuid)
contentful_id	varchar(64)		false
name	varchar(255)	NULL::character varying	true
address_street_name	varchar(255)	NULL::character varying	true
address_building_number	varchar(255)	NULL::character varying	true
address_postal_code	varchar(255)	NULL::character varying	true
address_locality_name	varchar(255)	NULL::character varying	true
location_latitude	numeric(9,7)		false
location_longitude	numeric(9,7)		false
contact_name	varchar(255)	NULL::character varying	true
contact_website	varchar(255)	NULL::character varying	true
contact_phone_number	varchar(255)	NULL::character varying	true
contact_email_address	varchar(255)	NULL::character varying	true
contact_profile_image_url	varchar(255)	NULL::character varying	true
is_active	boolean	false	false
main_image_id	uuid		true		public.image	(DC2Type:uuid)
opening_times_as_json	json	'{}'::json	false
operator_name	varchar(255)		false
court_pricing_as_json	json	'{}'::json	false
timezone	varchar(255)		false
default_price_per_hour_amount	bigint		false
default_price_per_hour_currency	character(3)	NULL::bpchar	false			(DC2Type:currency)
description	text		true
subdivision_code	varchar(255)	NULL::character varying	true
wellpass_api_key	varchar(255)	NULL::character varying	true
is_wellpass_enabled	boolean	false	false
is_shown_in_app	boolean	false	false

Constraints

Name	Type	Definition
club_pkey	PRIMARY KEY	PRIMARY KEY (id)
fk_b8ee3872e4873418	FOREIGN KEY	FOREIGN KEY (main_image_id) REFERENCES image(id)

Indexes

Name	Definition
club_pkey	CREATE UNIQUE INDEX club_pkey ON public.club USING btree (id)
uniq_b8ee3872d756ce8c	CREATE UNIQUE INDEX uniq_b8ee3872d756ce8c ON public.club USING btree (contentful_id)
uniq_b8ee3872e4873418	CREATE UNIQUE INDEX uniq_b8ee3872e4873418 ON public.club USING btree (main_image_id)

Relations

---

Generated by tbls