| id |
uuid |
|
false |
|
|
Unique identifier for the service term(DC2Type:uuid) |
| terms_of_service_id |
uuid |
|
false |
|
public.terms_of_service |
Reference to the parent terms of service document(DC2Type:uuid) |
| action |
varchar(255) |
|
false |
|
|
Action type this term applies to (e.g., BOOK, CANCEL, JOIN) |
| applicable_phases |
text |
|
false |
|
|
Game phases this term applies to (e.g., CONFIRMING, SCHEDULED, RUNNING)(DC2Type:simple_array) |
| due_fee_amount |
bigint |
|
true |
|
|
Fee amount in smallest currency unit (cents) that applies to this term |
| due_fee_currency |
varchar(3) |
|
true |
|
|
ISO 4217 currency code for the due fee (e.g., EUR, USD) |
| applicable_kinds |
text |
|
false |
|
|
Game kinds this term applies to (OPEN or PRIVATE)(DC2Type:simple_array) |
| type |
varchar(255) |
|
false |
|
|
Type classification of the service term |
| applicable_from |
timestamp(0) with time zone |
NULL::timestamp with time zone |
true |
|
|
Start date from which this term becomes applicable(DC2Type:datetimetz_immutable) |
| applicable_till |
timestamp(0) with time zone |
NULL::timestamp with time zone |
true |
|
|
End date until which this term remains applicable(DC2Type:datetimetz_immutable) |
| is_action_allowed |
boolean |
false |
false |
|
|
Flag indicating whether the action is allowed under this term |
| applicable_roles |
text |
|
false |
|
|
User roles this term applies to (HOST, PARTICIPANT, STAFF, SYSTEM)(DC2Type:simple_array) |
| legacy_type |
varchar(255) |
NULL::character varying |
true |
|
|
Legacy type identifier for backward compatibility |
