Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | MEDIUMINT UNSIGNED | 8 | √ | null |
|
|
|||||||||||
| display_name | VARCHAR | 100 | null |
|
|
||||||||||||
| VARCHAR | 100 | null |
|
|
|||||||||||||
| uploader | MEDIUMINT UNSIGNED | 8 | √ | null |
|
|
|||||||||||
| average_review_score | DOUBLE | 22 | 0 |
|
|
||||||||||||
| reviews | INT | 10 | 0 |
|
|
||||||||||||
| recommended | BIT | 1 | 0 |
|
|
Boolean to indicate if a mod is a high quality FAF Mod |
|||||||||||
| create_time | TIMESTAMP | 19 | current_timestamp() |
|
|
When this entry was created. |
|||||||||||
| update_time | TIMESTAMP | 19 | current_timestamp() |
|
|
When this entry was updated |
|||||||||||
| license | INT | 10 | null |
|
|
||||||||||||
| repository_url | VARCHAR | 255 | √ | null |
|
|
Link to repository |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| display_name | Must be unique | Asc | display_name |
| mod_average_review_score_index | Performance | Asc | average_review_score |
| mod_license_id_fk | Performance | Asc | license |
| uploader | Performance | Asc | uploader |
Relationships
Close relationships within degrees of separation
