Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | MEDIUMINT UNSIGNED | 8 | √ | null |
|
|
|||||
| order | MEDIUMINT UNSIGNED | 8 | null |
|
|
||||||
| name | VARCHAR | 255 | null |
|
|
||||||
| description | TEXT | 65535 | √ | null |
|
|
|||||
| type | enum('SC', 'SCFA', 'CUSTOM') | 6 | CUSTOM |
|
|
SC=vanilla Supreme Commander campaign, SCFA=Forged Alliance campaign, CUSTOM=community campaign |
|||||
| faction | enum('UEF', 'CYBRAN', 'AEON', 'SERAPHIM', 'CUSTOM') | 8 | null |
|
|
Describes the faction to be played in the scenario. Custom means the user can select a faction. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| unique_name | Must be unique | Asc | name |
Relationships
Close relationships within degrees of separation
