public.cart
[BASE TABLE]
id
[uuid]
event_registration_id
[uuid]
match_player_id
[uuid]
public.event_registration
[BASE TABLE]
id
[uuid]
event_id
[uuid]
created_at
[timestamp(0) with time zone]
status
[varchar(255)]
team_id
[uuid]
created_by_id
[uuid]
cancelled_by_id
[uuid]
cancelled_at
[timestamp(0) with time zone]
FOREIGN KEY (event_registration_id) REFERENCES event_registration(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 (match_player_id) REFERENCES match_player(id)
public.cart_item
[BASE TABLE]
id
[uuid]
cart_id
[uuid]
type
[varchar(255)]
amount_amount
[bigint]
amount_currency
[character(3)]
quantity
[integer]
discount_percentage
[integer]
quantity_discountable
[integer]
FOREIGN KEY (cart_id) REFERENCES cart(id)
public.payment
[BASE TABLE]
id
[uuid]
status
[varchar(255)]
total_amount
[bigint]
total_currency
[character(3)]
stripe_client_secret
[varchar(255)]
is_paid
[boolean]
paid_at
[timestamp(0) with time zone]
voucher_id
[uuid]
stripe_payment_intent_id
[varchar(255)]
payment_source
[varchar(255)]
expired_at
[timestamp(0) with time zone]
voucher_redemption_id
[uuid]
cart_id
[uuid]
FOREIGN KEY (cart_id) REFERENCES cart(id)