coop_map

35 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
type TINYINT UNSIGNED 3 null

deprecated, lookup parent scenario instead
id MEDIUMINT UNSIGNED 8 √ null
name VARCHAR 40 √ null
description LONGTEXT 2147483647 √ null
version DECIMAL 4 √ null
filename VARCHAR 200 √ null
order MEDIUMINT UNSIGNED 8 √ null
scenario_id MEDIUMINT UNSIGNED 8 √ null
coop_scenario.id coop_map_coop_scenario_id_fk R

TODO: Make not null after migration

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
coop_map_coop_scenario_id_fk Performance Asc scenario_id
filename Performance Asc filename

Relationships

Close relationships within degrees of separation