Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | 0 |
|
|
||
| username | VARCHAR | 100 | √ | '???' |
|
|
||
| displayusername | VARCHAR | 100 | √ | NULL |
|
|
||
| active | INT | 10 | 0 |
|
|
|||
| registered | TIMESTAMP | 19 | current_timestamp() |
|
|
|||
| registration_type | INT | 10 | 0 |
|
|
|||
| role | VARCHAR | 30 | √ | NULL |
|
|
||
| avatar | VARCHAR | 350 | √ | NULL |
|
|
||
| firstseen | DATETIME | 19 | √ | NULL |
|
|
||
| lastseen | DATETIME | 19 | √ | NULL |
|
|
||
| iq | INT | 10 | 0 |
|
|
|||
| annotations | INT | 10 | 0 |
|
|
|||
| questions | INT | 10 | 0 |
|
|
|||
| answers | INT | 10 | 0 |
|
|
|||
| pyongs | INT | 10 | 0 |
|
|
|||
| comments | INT | 10 | 0 |
|
|
|||
| transcriptions | INT | 10 | 0 |
|
|
|||
| posts | INT | 10 | 0 |
|
|
|||
| followers | INT | 10 | 0 |
|
|
|||
| following | INT | 10 | 0 |
|
|
|||
| created_at | TIMESTAMP | 19 | current_timestamp() |
|
|
|||
| updated_at | TIMESTAMP | 19 | current_timestamp() |
|
|