public.user_group
[BASE TABLE]
id
[uuid]
public_name
[varchar(255)]
internal_name
[varchar(60)]
note
[text]
created_at
[timestamp(0) with time zone]
type
[varchar(255)]
invite_code
[varchar(10)]
deactivated_by_id
[uuid]
deactivated_at
[timestamp(0) with time zone]
active
[boolean]
public.user
[BASE TABLE]
id
[uuid]
first_name
[varchar(255)]
last_name
[varchar(255)]
email
[varchar(255)]
gender
[varchar(255)]
birthday
[date]
skill_level
[varchar(255)]
is_age_public
[boolean]
profile_image_path
[varchar(255)]
is_marketing_consent_granted
[boolean]
marketing_consent_granted_at
[timestamp(0) with time zone]
get_stream_token
[text]
email_address_id
[uuid]
preferred_playing_times
[text]
dominant_hands
[text]
locale
[varchar(255)]
is_deleted
[boolean]
deleted_at
[timestamp(0) with time zone]
created_at
[timestamp(0) with time zone]
phone_number
[varchar(255)]
FOREIGN KEY (deactivated_by_id) REFERENCES "user"(id)
public.user_group_club
[BASE TABLE]
user_group_id
[uuid]
club_id
[uuid]
FOREIGN KEY (user_group_id) REFERENCES user_group(id) ON DELETE CASCADE
public.member
[BASE TABLE]
id
[uuid]
group_id
[uuid]
user_id
[uuid]
created_at
[timestamp(0) with time zone]
email_address
[varchar(255)]
status
[varchar(255)]
added_by_id
[uuid]
FOREIGN KEY (group_id) REFERENCES user_group(id)
public.discount
[BASE TABLE]
id
[uuid]
group_id
[uuid]
created_at
[timestamp(0) with time zone]
valid_from
[timestamp(0) with time zone]
valid_till
[timestamp(0) with time zone]
percentage
[integer]
is_enabled
[boolean]
applicable_on_days
[text]
applicable_from_time
[time(0) without time zone]
applicable_till_time
[time(0) without time zone]
applicable_on_sports
[text]
applicable_on_locations
[text]
max_playable_hours_in_validity_period
[integer]
kind
[varchar(255)]
played_hours_in_validity_period
[double precision]
played_hours_last_computed_at
[timestamp(0) with time zone]
origin
[varchar(255)]
FOREIGN KEY (group_id) REFERENCES user_group(id)