Editing Technical:Back-end Server (section)

=== Servers and access ===
Used for the server list and for server status information for the back-end to reference.
{| class="wikitable"
|+servers
!Key
!Type
!Nullable / Default
!Description
|-
|id
|uuid (PK)
|NOT NULL
|
|-
|secret
|text
|NOT NULL
|Secret key used by game servers to contact the back-end
|-
|address
|text
|NOT NULL
|Connection address complete with the port
|-
|name
|text
|NOT NULL
|Public name for the server
|-
|rules
|text
|NOT NULL
|Individual server rules
|-
|listed
|boolean
|true
|Certain servers may be delisted
|-
|region
|varchar(2)
|NOT NULL
|<bdi>ISO 3166-1 alpha-2 code</bdi>
|-
|last_ping
|timestamptz
|NOT NULL
|Last time the server contacted the back-end
|-
|last_players
|integer
|NOT NULL
|Last reported player count
|}
Session tokens are assigned before connecting to a server from (a launcher? or the website? via REST API) or by the server itself if authenticated directly by password. In the latter case, the player will not see the session token and it is only used for the character lock. Session tokens are valid only for one session or one connection to a server. The same character must not be used in multiple servers at once or in the same server multiple times.
{| class="wikitable"
|+session_tokens
!Key
!Type
!Nullable / Default
!Description
|-
|id
|serial (PK)
|NOT NULL
|
|-
|server_id
|servers.id (FK)
|NOT NULL
|
|-
|character_id
|characters.id (FK)
|
|Set value indicates “character lock”
|-
|user_id
|users.id (FK)
|NOT NULL
|
|-
|token
|text
|NOT NULL
|
|-
|expires_at
|timestamptz
|
|
|-
|created_at
|timestamptz
|
|
|}