| id |
uuid |
|
false |
public.game |
|
Unique identifier for the match series(DC2Type:uuid) |
| court_id |
uuid |
|
false |
|
public.court |
Reference to the court used for the match series(DC2Type:uuid) |
| owner_id |
uuid |
|
false |
|
public.user |
Reference to the user who owns this match series(DC2Type:uuid) |
| created_at |
timestamp(0) with time zone |
|
false |
|
|
Timestamp when the match series was created(DC2Type:datetimetz_immutable) |
| status |
varchar(255) |
|
false |
|
|
Current status of the match series (DRAFT, ACTIVE, TERMINATED) |
| payment_plan |
varchar(255) |
|
false |
|
|
Payment plan type (PREPAID or FLEX) |
| match_duration_in_seconds |
integer |
|
false |
|
|
Duration of each match in seconds |
| type |
varchar(255) |
|
false |
|
|
Type of match series (SUMMER or WINTER) |
| weekday |
varchar(255) |
|
false |
|
|
Day of the week when matches occur (e.g., MONDAY, TUESDAY) |
| note |
varchar(255) |
NULL::character varying |
true |
|
|
Optional note or description for the match series |
| starts_at |
time(0) without time zone |
|
false |
|
|
Time when the matches start (in H:i format)(DC2Type:time_immutable) |
| discount_percentage |
integer |
|
false |
|
|
Discount percentage applied to the match series |
| club_id |
uuid |
|
false |
|
public.club |
Reference to the club where the match series takes place(DC2Type:uuid) |
| discount_id |
uuid |
|
true |
|
public.discount |
Unique identifier of the discount.(DC2Type:uuid) |
| activated_at |
timestamp(0) with time zone |
NULL::timestamp with time zone |
true |
|
|
Timestamp when the match series was activated(DC2Type:datetimetz_immutable) |
| terminated_at |
timestamp(0) with time zone |
NULL::timestamp with time zone |
true |
|
|
Timestamp when the match series was terminated(DC2Type:datetimetz_immutable) |
