| id |
uuid |
|
false |
public.cart public.player_equipment public.refund public.slot |
|
Unique identifier of the match player.(DC2Type:uuid) |
| user_id |
uuid |
|
false |
|
public.user |
User who is participating as this player.(DC2Type:uuid) |
| game_id |
uuid |
|
false |
|
public.game |
The match this player is participating in.(DC2Type:uuid) |
| slot |
integer |
|
false |
|
|
Slot index for the player position (0-3). |
| is_host |
boolean |
false |
false |
|
|
Whether this player is the host of the match. |
| terms_of_service_id |
uuid |
|
false |
|
public.terms_of_service |
Terms of service acceptance record for this player.(DC2Type:uuid) |
| joined_match_at |
timestamp(0) with time zone |
'2013-01-01 13:37:00+00'::timestamp with time zone |
false |
|
|
The date and time when the player joined the match.(DC2Type:datetimetz_immutable) |
| confirmed_match_at |
timestamp(0) with time zone |
NULL::timestamp with time zone |
true |
|
|
The date and time when the player confirmed their participation.(DC2Type:datetimetz_immutable) |
| left_match_at |
timestamp(0) with time zone |
NULL::timestamp with time zone |
true |
|
|
The date and time when the player left the match.(DC2Type:datetimetz_immutable) |
| status |
varchar(255) |
'WAITING_FOR_PLAYER'::character varying |
false |
|
|
Current status of the player: WAITING_FOR_PLAYER, PLAYER_CONFIRMED, or PLAYER_LEFT. |
| discount_id |
uuid |
|
true |
|
public.discount |
Discount applied to this player's match fees.(DC2Type:uuid) |
| expected_payment_of_slots |
integer |
|
false |
|
|
Number of slots this player is expected to pay for when split payment is enabled. |
