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)]
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]
FOREIGN KEY (group_id) REFERENCES user_group(id)
public.match_player
[BASE TABLE]
id
[uuid]
user_id
[uuid]
game_id
[uuid]
slot
[integer]
is_host
[boolean]
terms_of_service_id
[uuid]
joined_match_at
[timestamp(0) with time zone]
confirmed_match_at
[timestamp(0) with time zone]
left_match_at
[timestamp(0) with time zone]
status
[varchar(255)]
discount_id
[uuid]
expected_payment_of_slots
[integer]
FOREIGN KEY (discount_id) REFERENCES discount(id)
public.match_series
[BASE TABLE]
id
[uuid]
court_id
[uuid]
owner_id
[uuid]
created_at
[timestamp(0) with time zone]
status
[varchar(255)]
payment_plan
[varchar(255)]
match_duration_in_seconds
[integer]
type
[varchar(255)]
weekday
[varchar(255)]
note
[varchar(255)]
starts_at
[time(0) without time zone]
discount_percentage
[integer]
club_id
[uuid]
discount_id
[uuid]
activated_at
[timestamp(0) with time zone]
terminated_at
[timestamp(0) with time zone]
FOREIGN KEY (discount_id) REFERENCES discount(id)