Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | CHAR | 36 | null |
|
|
||||||
| user_id | MEDIUMINT UNSIGNED | 8 | √ | null |
|
|
To be set to null if account is deleted |
||||
| type | enum('STEAM', 'GOG', 'DISCORD', 'PATREON') | 7 | null |
|
|
The service that this service id links to. |
|||||
| service_id | VARCHAR | 100 | √ | null |
|
|
To be set to null if account is deleted unless ownership is true |
||||
| public | BIT | 1 | √ | null |
|
|
|||||
| ownership | BIT | 1 | √ | null |
|
|
If true, this link confirms that the user owns FAForever. If true the link must never be deleted even if the linked account gets deleted. In this case we keep a dangling link so the id cannot be reused |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| unique_service_id | Must be unique | Asc/Asc | type + service_id |
| user_ibfk_1 | Performance | Asc | user_id |
Relationships
Close relationships within degrees of separation
