| id |
uuid |
|
false |
public.event_registration |
|
Unique identifier for the club event(DC2Type:uuid) |
| contentful_id |
varchar(64) |
|
false |
|
|
Unique identifier from Contentful CMS for content synchronization |
| is_active |
boolean |
false |
false |
|
|
Flag indicating whether the event is currently active and visible |
| club_id |
uuid |
|
false |
|
public.club |
Reference to the club hosting this event. Required for all events.(DC2Type:uuid) |
| template_id |
uuid |
|
false |
|
public.event_template |
Reference to the event template defining the event type and default content(DC2Type:uuid) |
| event_period_starts_at |
timestamp(0) with time zone |
|
false |
|
|
Start date and time of the time period.(DC2Type:datetimetz_immutable) |
| event_period_ends_at |
timestamp(0) with time zone |
|
false |
|
|
End date and time of the time period.(DC2Type:datetimetz_immutable) |
| event_period_duration_in_seconds |
integer |
|
false |
|
|
Duration in seconds between startsAt and endsAt. |
| price_per_person_amount |
bigint |
|
false |
|
|
|
| price_per_person_currency |
character(3) |
|
false |
|
|
(DC2Type:currency) |
| stripe_price_id |
varchar(64) |
NULL::character varying |
true |
|
|
Stripe price ID for payment processing integration |
| status |
varchar(255) |
'OPEN_FOR_REGISTRATION'::character varying |
false |
|
|
Current status of the event (e.g., OPEN_FOR_REGISTRATION, CLOSED_FOR_REGISTRATION, CANCELLED) |
| max_confirmed_registrations |
integer |
10 |
false |
|
|
Maximum number of confirmed registrations allowed for this event |
| registration_opens_at |
timestamp(0) with time zone |
NULL::timestamp with time zone |
true |
|
|
Timestamp when registration opens for this event. Null means registration is immediately open.(DC2Type:datetimetz_immutable) |
| description |
text |
|
true |
|
|
Custom description text for this specific event instance, overrides template description if set |
| persons_per_team |
integer |
1 |
false |
|
|
Number of persons required per team for this event |
| type |
varchar(255) |
NULL::character varying |
false |
|
|
Type of event (e.g., REGULAR, TEAM) |
| is_registrations_hidden |
boolean |
false |
false |
|
|
Flag indicating whether the list of registrations should be hidden from participants |
| registration_closes_at |
timestamp(0) with time zone |
NULL::timestamp without time zone |
true |
|
|
Timestamp when registration closes for this event. Null means registration closes when event starts.(DC2Type:datetimetz_immutable) |
| free_cancellation_strategy |
varchar(255) |
'UNTIL_24H_BEFORE_EVENT'::character varying |
false |
|
|
|
| updated_by_id |
uuid |
|
true |
|
public.user |
Reference to the user who last updated this event. Set to NULL if user is deleted.(DC2Type:uuid) |
| cancellation_reason |
varchar(255) |
NULL::character varying |
true |
|
|
Reason provided when the event is cancelled (e.g., EVENT_CANCELLATION_OTHER, weather, insufficient registrations) |
| updated_at |
timestamp(0) with time zone |
NULL::timestamp with time zone |
true |
|
|
Timestamp when the event was last updated(DC2Type:datetimetz_immutable) |
| sport_id |
uuid |
|
false |
|
public.sport |
Reference to the sport type for this event. Required for all events.(DC2Type:uuid) |
