actions_log
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) |
| NO | PRIMARY | None | AUTO_INCREMENT |
action_id | int(11) |
| NO |
| None | FK->actions.action_id |
user_id | int(11) |
| NO |
| None |
|
time | int(10) |
| NO |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
action_id | BTREE | No | No | action_id |
actions
Field | Type | Collation | Null | Key | Default | Extra |
action_id | int(11) |
| NO | PRIMARY | None | AUTO_INCREMENT |
action | varchar(75) | utf8_general_ci | NO |
| None |
|
qualifiers | text | utf8_general_ci | NO |
| None |
|
response | varchar(75) | utf8_general_ci | NO |
| None |
|
response_vars | text | utf8_general_ci | NO |
| None |
|
active | tinyint(4) |
| NO |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | action_id |
alert
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| NO | PRIMARY | None | AUTO_INCREMENT |
user_id | int(11) unsigned |
| YES |
| 0 | FK->users.id |
alert_type | tinyint(4) |
| NO |
| None |
|
alert_recipient | varchar(200) | utf8_general_ci | YES |
| NULL |
|
alert_code | varchar(30) | utf8_general_ci | YES |
| NULL |
|
alert_confirmed | tinyint(4) |
| NO |
| 0 |
|
alert_lat | varchar(150) | utf8_general_ci | YES |
| NULL |
|
alert_lon | varchar(150) | utf8_general_ci | YES |
| NULL |
|
alert_radius | tinyint(4) | utf8_general_ci | NO |
| 20 |
|
alert_ip | varchar(100) | utf8_general_ci | YES |
| NULL |
|
alert_type: 1 - Mobile, 2 - Email
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
uniq_alert_code | BTREE | Yes | 0 | alert_code |
user_id | BTREE | No | 0 | user_id |
alert_category
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| NO | PRIMARY | None | AUTO_INCREMENT |
alert_id | bigint(20) unsigned |
| YES |
| NULL | FK->alert.id |
category_id | int(11) unsigned |
| YES |
| NULL | FK->category.id |
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
alert_id | BTREE | No | 0 | alert_id |
category_id | BTREE | No | 0 | category_id |
alert_sent
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| NO | PRIMARY | None | AUTO_INCREMENT |
incident_id | bigint(20) unsigned |
| NO |
| None | FK->incident.id |
alert_id | bigint(20) unsigned |
| NO |
| None | FK->alert.id |
alert_date | datetime |
| YES |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
incident_id | BTREE | No | 0 | incident_id |
alert_id | BTREE | No | 0 | alert_id |
api_banned
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| NO | PRIMARY | None | AUTO_INCREMENT |
banned_ipaddress | varchar(50) | utf8_general_ci | NO |
| None |
|
banned_date | datetime |
| NO |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
api_log
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| NO | PRIMARY | None | AUTO_INCREMENT |
api_task | varchar(10) | utf8_general_ci | NO |
| None |
|
api_parameters | varchar(100) | utf8_general_ci | NO |
| None |
|
api_record | tinyint(11) |
| NO |
| None |
|
api_ipaddress | varchar(50) | utf8_general_ci | NO |
| None |
|
api_date | datetime |
| NO |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
api_settings
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| NO | PRIMARY | None | AUTO_INCREMENT |
default_record_limit | int(11) |
| NO |
| None |
|
max_record_limit | int(11) |
| YES |
| NULL |
|
max_requests_per_ip_address | int(11) |
| YES |
| NULL |
|
max_requests_quota_basis | int(11) |
| YES |
| NULL |
|
modification_date | datetime |
| NO |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
badge
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| NO | PRIMARY | None | AUTO_INCREMENT |
name | varchar(250) | utf8_general_ci | NO |
| None |
|
description | text | utf8_general_ci | NO |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
badge_users
Field | Type | Collation | Null | Key | Default | Extra |
user_id | int(11) unsigned |
| NO |
| None | FK->users.id |
badge_id | int(11) |
| NO |
| None | FK->badge.id |
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | user_id |
category
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| NO | PRIMARY | None | AUTO_INCREMENT |
parent_id | int(11) |
| NO |
| None |
|
locale | varchar(10) | utf8_general_ci | NO |
| en_US |
|
category_position | tinyint(4) |
| NO |
| 0 |
|
category_title | varchar(255) | utf8_general_ci | YES |
| NULL |
|
category_description | text | utf8_general_ci | YES |
| NULL |
|
category_color | varchar(20) | utf8_general_ci | YES |
| NULL |
|
category_image | varchar(255) | utf8_general_ci | YES |
| NULL |
|
category_image_ thumb | varchar(255) | utf8_general_ci | YES |
| NULL |
|
category_visible | tinyint(4) |
| NO |
| 1 |
|
category_trusted | tinyint(4) |
| NO |
| 0 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 5 | id |
category_visible | BTREE | No | 0 | category_visible |
| parent_id | BTREE | No | 0 | parent_id |
category_lang
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| NO | PRIMARY | None | AUTO_INCREMENT |
category_id | int(11) unsigned |
| NO |
| None | FK->category.id |
locale | varchar(10) | utf8_general_ci | YES |
| NULL |
|
category_title | varchar(255) | utf8_general_ci | YES |
| NULL |
|
category_description | text | utf8_general_ci | YES |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
category_id | BTREE | No | 0 | category_id |
checkin
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| NO |
| None | AUTO_INCREMENT |
user_id | int(11) unsigned |
| NO |
| None | FK->users.id |
location_id | bigint(20) unsigned |
| NO |
| None | FK->location.id |
incident_id | bigint(20) unsigned |
| YES |
| 0 | FK->incident.id |
checkin_ | varchar(255) | utf8_general_ci | YES |
| NULL |
|
checkin_date | datetime |
| NO |
| None |
|
checkin_auto | enum(‘0’, ‘1’) | utf8_general_ci | YES |
| 0 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
incident_id | BTREE | No | 0 | incident_id |
user_id | BTREE | No | 0 | user_id |
location_id | BTREE | No | 0 | location_id |
city
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| NO | PRIMARY | None | AUTO_INCREMENT |
country_id | int(11) |
| YES |
| NULL | FK->country.id |
city | varchar(200) | utf8_general_ci | YES |
| NULL |
|
city_lat | varchar(200) | utf8_general_ci | YES |
| NULL |
|
city_lon | varchar(200) | utf8_general_ci | YES |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
country_id | BTREE | No | 0 | country_id |
cluster
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
location_id | bigint(20) unsigned |
| No |
| 0 | FK->location.id |
latitude | double |
| No |
| None |
|
longitude | double |
| No |
| None |
|
latitude_min | double |
| No |
| None |
|
longitude_min | double |
| No |
| None |
|
latitude_ | double |
| No |
| None |
|
longitude_max | double |
| No |
| None |
|
child_count | int(11) |
| No |
| None |
|
parent_id | int(11) |
| No |
| None |
|
left_side | int(11) |
| No |
| None |
|
right_side | int(11) |
| No |
| None |
|
level | int(11) |
| No |
| None |
|
incident_id | bigint(20) unsigned |
| No |
| None | FK->incident.id |
category_id | int(11) unsigned |
| No |
| 0 | FK->category.id |
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
location_id | BTREE | No | 0 | location_id |
incident_id | BTREE | No | 0 | incident_id |
category_id | BTREE | No | 0 | category_id |
comment
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| NO | PRIMARY | None | AUTO_INCREMENT |
incident_id | bigint(20) unsigned |
| Yes |
| NULL | FK->incident.id |
checkin_id | bigint(20) unsigned |
| Yes |
| NULL | FK->checkin.id |
user_id | int(11) unsigned |
| Yes |
| NULL | FK->users.id |
comment_ | varchar(100) | utf8_general_ci | Yes |
| NULL |
|
comment_ email | varchar(120) | utf8_general_ci | Yes |
| NULL |
|
comment_ description | text | utf8_general_ci | Yes |
| NULL |
|
comment_ip | varchar(100) | utf8_general_ci | Yes |
| NULL |
|
comment_ | varchar(15) | utf8_general_ci | NO |
| 0 |
|
comment_ spam | tinyint(4) |
| NO |
| 0 |
|
comment_ | tinyint(4) |
| NO |
| 0 |
|
comment_ date | datetime |
| Yes |
| NULL |
|
comment_ | datetime |
| Yes |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
incident_id | BTREE | No | 0 | incident_id |
checkin_id | BTREE | No | 0 | checkin_id |
user_id | BTREE | No | 0 | user_id |
country
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
iso | varchar(10) | utf8_general_ci | Yes |
| NULL |
|
country | varchar(100) | utf8_general_ci | Yes |
| NULL |
|
capital | varchar(100) | utf8_general_ci | Yes |
| NULL |
|
cities | tinyint(4) |
| No |
| 0 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 247 | id |
externalapp
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
name | varchar(255) | l atin_swedish_ci | No |
| None |
|
url | varchar(255) | l atin_swedish_ci | No |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 2 | id |
feed
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| NO | PRIMARY | None | AUTO_INCREMENT |
feed_name | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
feed_url | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
feed_cache | text | utf8_general_ci | Yes |
| NULL |
|
feed_active | tinyint(4) |
| Yes |
| 1 |
|
feed_update | int(11) |
| No |
| 0 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 1 | id |
feed_item
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
feed_id | int(11) unsigned |
| No |
| None | FK->feed.id |
location_id | bigint(20) unsigned |
| Yes |
| 0 | FK ->location.id |
incident_id | bigint(20) unsigned |
| No |
| 0 | FK->incident.id |
item_title | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
item_description | text | utf8_general_ci | Yes |
| NULL |
|
item_link | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
item_date | datetime |
| Yes |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
feed_id | BTREE | No | 0 | feed_id |
incident_id | BTREE | No | 0 | incident_id |
location_id | BTREE | No | 0 | location_id |
form
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
form_title | varchar(200) | utf8_general_ci | No |
| None |
|
form_ | text | utf8_general_ci | Yes |
| NULL |
|
form_active | tinyint(4) |
| Yes |
| 1 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 1 | id |
form_title | BTREE | Yes | 1 | form_title |
form_field
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
form_id | int(11) |
| No |
| 1 | FK->form.id |
field_name | varchar(200) | utf8_general_ci | Yes |
| NULL |
|
field_type | tinyint(4) |
| No |
| 1 |
|
field_required | tinyint(4) |
| Yes |
| 0 |
|
field_position | tinyint(4) |
| No |
| 0 |
|
field_default | text | utf8_general_ci | Yes |
| NULL |
|
field_maxlength | int(11) |
| No |
| 0 |
|
field_width | smallint(6) |
| No |
| 0 |
|
field_height | tinyint(4) |
| Yes |
| 5 |
|
field_isdate | tinyint(4) |
| No |
| 0 |
|
field_ispublic_visible | int(11) |
| No |
| 0 |
|
field_ispublic_submit | int(11) |
| No |
| 0 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
fk_form_id | BTREE | No | 0 | form_id |
field_name | BTREE | Yes |
| field_name |
form_field_option
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
form_field_id | int(11) |
| No |
| 0 | FK->form_field.id |
option_name | varchar(200) | utf8_general_ci | Yes |
| NULL |
|
option_value | text | utf8_general_ci | Yes |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
form_field_id | BTREE | No | 0 | form_field_id |
form_response
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) |
| No | PRIMARY | None | AUTO_INCREMENT |
form_field_id | int(11) |
| No |
| None | FK->form_field.id |
incident_id | bigint(20) unsigned |
| No |
| None | FK->incident.id |
form_response | text | utf8_general_ci | No |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
fk_form_field_id | BTREE | No | 0 | form_field_id |
incident_id | BTREE | No | 0 | incident_id |
geometry
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
incident_id | bigint(20) unsigned |
| No |
| None | FK->incident.id |
geometry | geometry |
| No |
| None |
|
geometry_label | varchar(150) | utf8_general_ci | Yes |
| NULL |
|
geometry_ | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
geometry_ | varchar(20) | utf8_general_ci | Yes |
| NULL |
|
geometry_ | varchar(5) | utf8_general_ci | Yes |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
geometry | SPATIAL | No | 0 | geometry(32) |
incident_id | BTREE | No | 0 | incident_id |
incident
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
location_id | bigint(20) unsigned |
| No |
| None | FK ->location.id |
form_id | int(11) |
| No |
| 1 | FK -> form.id |
locale | varchar(10) | utf8_general_ci | No |
| en_US |
|
user_id | int(11) unsigned |
| Yes |
| NULL | FK ->users.id |
incident_title | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
incident_ | longtext | utf8_general_ci | Yes |
| NULL |
|
incident_date | datetime |
| Yes |
| NULL |
|
incident_mode | tinyint(4) |
| No |
| 1 |
|
incident_active | tinyint(4) |
| No |
| 0 |
|
incident_verified | tinyint(4) |
| No |
| 1 |
|
incident_dateadd | datetime |
| Yes |
| NULL |
|
incident_dateadd_gmt | datetime |
| Yes |
| NULL |
|
incident_ | datetime |
| Yes |
| NULL |
|
incident_alert_ | tinyint(4) |
| No |
| 0 |
|
incident_zoom | tinyint(4) |
| Yes |
| NULL |
|
incident_mode: 1 - Web, 2 - SMS, 3 - Email, 4 - Twitter
incident_alert_status: 0 - Not tagged for sending, 1 - Tagged for sending, 2 - Alerts have been sent
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 1 | id |
location_id | BTREE | No | 1 | location_id |
incident_active | BTREE | No | 1 | incident_active |
incident_date | BTREE | No | 1 | incident_date |
form_id | BTREE | No | 1 | form_id |
user_id | BTREE | No | 1 | user_id |
| incident_mode | BTREE | No | 1 | incident_mode |
| incident_verified | BTREE | No | 2 | incident_verified |
incident_category
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
incident_id | bigint(20) unsigned |
| No |
| None |
|
category_id | int(11) unsigned |
| No |
| 0 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 1 | id |
incident_category_ids | BTREE | Yes | 0 | incident_id |
| incident_id | BTREE | Yes | 0 | incident_id |
| category_id | BTREE | Yes | 1 | category_id |
incident_lang
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
incident_id | bigint(20) unsigned |
| No |
| None | FK ->incident.id |
locale | varchar(10) | utf8_general_ci | Yes |
| NULL |
|
incident_title | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
incident_ | longtext | utf8_general_ci | Yes |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
incident_id | BTREE | No | 0 | incident_id |
incident_person
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
incident_id | bigint(20) unsigned |
| Yes |
| NULL | FK->incident.id |
person_first | varchar(200) | utf8_general_ci | Yes |
| NULL |
|
person_last | varchar(200) | utf8_general_ci | Yes |
| NULL |
|
person_email | varchar(120) | utf8_general_ci | Yes |
| NULL |
|
person_phone | varchar(60) | utf8_general_ci | Yes |
| NULL |
|
person_ip | varchar(50) | utf8_general_ci | Yes |
| NULL |
|
person_date | datetime |
| Yes |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
incident_id | BTREE | No | 0 | incident_id |
layer
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
layer_name | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
layer_url | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
layer_file | varchar(100) | utf8_general_ci | Yes |
| NULL |
|
layer_color | varchar(20) | utf8_general_ci | Yes |
| NULL |
|
layer_visible | tinyint(4) |
| No |
| 1 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
level
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
level_title | varchar(200) | utf8_general_ci | Yes |
| NULL |
|
level_ | varchar(200) | utf8_general_ci | Yes |
| NULL |
|
level_weight | tinyint(4) |
| No |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 5 | id |
location
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
location_name | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
country_id | int(11) |
| No |
| 0 | FK->country.id |
latitude | double |
| No |
| 0 |
|
longitude | double |
| No |
| 0 |
|
location_visible | tinyint(4) |
| No |
| 1 |
|
location_date | datetime |
| Yes |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 1 | id |
country_id | BTREE | No | 1 | country_id |
| latitude | BTREE | No | 1 | latitude |
| longitude | BTREE | No | 1 | longitude |
maintenance
Field | Type | Collation | Null | Key | Default | Extra |
allowed_ip | varchar(15) | utf_general_ci | No | PRIMARY | NONE |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | allowed_ip |
media
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
location_id | bigint(20) unsigned |
| Yes |
| NULL | FK->location.id |
incident_id | bigint(20) unsigned |
| Yes |
| NULL | FK ->incident.id |
checkin_id | bigint(20) unsigned |
| Yes |
| NULL | FK ->checkin.id |
message_id | bigint(20) unsigned |
| Yes |
| NULL | FK ->message.id |
badge_id | int(11) |
| Yes |
| NULL |
|
media_type | tinyint(4) |
| Yes |
| NULL |
|
media_title | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
media_ description | longtext | utf8_general_ci | Yes |
| NULL |
|
media_link | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
media_medium | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
media_thumb | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
media_date | datetime |
| Yes |
| NULL |
|
media_active | tinyint(4) |
| No |
| 1 |
|
media_type: 1 - Images, 2 - Video, 3 - Audio, 4 - News, 5 - Podcast
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
location_id | BTREE | No | 0 | location_id |
incident_id | BTREE | No | 0 | incident_id |
badge_id | BTREE | No | 0 | badge_id |
checkin_id | BTREE | No | 0 | checkin_id |
message_id | BTREE | No | 0 | message_id |
message
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
parent_id | bigint(20) |
| Yes |
| 0 |
|
incident_id | bigint(20) unsigned |
| Yes |
| NULL | FK->incident.id |
user_id | int(11) unsigned |
| Yes |
| 0 | FK->users.id |
reporter_id | bigint(20) unsigned |
| Yes |
| NULL | FK ->reporter.id |
service_messageid | varchar(100) | utf8_general_ci | Yes |
| NULL |
|
message_ | varchar(100) | utf8_general_ci | Yes |
| NULL |
|
message_to | varchar(100) | utf8_general_ci | Yes |
| NULL |
|
message | text | utf8_general_ci | Yes |
| NULL |
|
message_ | text | utf8_general_ci | Yes |
| NULL |
|
message_ | tinyint(4) |
| Yes |
| 1 |
|
message_ | datetime |
| Yes |
| NULL |
|
message_ level | tinyint(4) |
| Yes |
| 0 |
|
latitude | double |
| Yes |
| NULL |
|
longitude | double |
| Yes |
| NULL |
|
message_type: 1 - Inbox, 2 - Outbox(from admin), 3 - Deleted
message_level: 0 - Unread, 1 - Read, 99 - Spam
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
user_id | BTREE | No | 0 | user_id |
incident_id | BTREE | No | 0 | incident_id |
reporter_id | BTREE | No | 0 | reporter_id |
openid
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
user_id | int(11) unsigned |
| No |
| None | FK->users.id |
openid | varchar(255) | utf8_general_ci | No |
| None |
|
openid_email | varchar(127) | utf8_general_ci | No |
| None |
|
openid_server | varchar(255) | utf8_general_ci | No |
| None |
|
openid_date | datetime |
| No |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
openid | BTREE | No | 0 | openid |
user_id | BTREE | No | 0 | user_id |
page
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
page_title | varchar(255) | utf8_general_ci | No |
| None |
|
page_description | longtext | utf8_general_ci | Yes |
| NULL |
|
page_tab | varchar(100) | utf8_general_ci | No |
| None |
|
page_active | tinyint(4) |
| No |
| 0 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
permissions
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
name | varchar(32) | latin1_swedish_ci | No |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 18 | id |
name_UNIQUE | BTREE | Yes | 18 |
|
permissions_roles
Field | Type | Collation | Null | Key | Default | Extra |
role_id | int(11) unsigned |
| No |
| None | FK->roles.id |
permission_id | int(11) |
| No |
| None | FK->permissions.id |
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | role_id |
plugin
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
plugin_name | varchar(100) | utf8_general_ci | No |
| None |
|
plugin_url | varchar(250) | utf8_general_ci | Yes |
| NULL |
|
plugin_ description | text | utf8_general_ci | Yes |
| NULL |
|
plugin_priority | tinyint(4) |
| Yes |
| 0 |
|
plugin_active | tinyint(4) |
| Yes |
| 0 |
|
plugin_installed | tinyint(4) |
| Yes |
| 0 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 5 | id |
plugin_name | BTREE | No | 5 | plugin_name |
private_message
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) |
| No | PRIMARY | None | AUTO_INCREMENT |
parent_id | int(11) |
| No |
| None |
|
user_id | int(11) unsigned |
| No |
| None | FK->users.id |
from_user_id | int(11) |
| Yes |
| 0 | FK ->users.id |
private_ | varchar(255) | utf8_general_ci | No |
| None |
|
private_ | text | utf8_general_ci | No |
| None |
|
private_ message_date | datetime |
| No |
| None |
|
private_ | tinyint(4) |
| No |
| 1 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
user_id | BTREE | No | 0 | user_id |
rating
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
user_id | int(11) unsigned |
| Yes |
| 0 | FK->users.id |
incident_id | bigint(20) unsigned |
| Yes |
| NULL | FK->incident_id |
comment_id | bigint(20) unsigned |
| Yes |
| 0 | FK->comment.id |
rating | tinyint(4) |
| Yes |
| 0 |
|
rating_ip | varchar(100) | utf8_general_ci | Yes |
| NULL |
|
rating_date | datetime |
| Yes |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
user_id | BTREE | No | 0 | user_id |
incident_id | BTREE | No | 0 | incident_id |
comment_id | BTREE | No | 0 | comment_id |
reporter
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
location_id | bigint(20) unsigned |
| Yes |
| NULL | FK->location.id |
user_id | int(11) unisigned |
| Yes |
| NULL | FK->users.if |
service_id | int(10) unsigned |
| Yes |
| NULL | FK->service.id |
level_id | int(11) unsigned |
| Yes |
| NULL | FK->level.id |
service_ | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
reporter_first | varchar(200) | utf8_general_ci | Yes |
| NULL |
|
reporter_last | varchar(200) | utf8_general_ci | Yes |
| NULL |
|
reporter_email | varchar(120) | utf8_general_ci | Yes |
| NULL |
|
reporter_phone | varchar(60) | utf8_general_ci | Yes |
| NULL |
|
reporter_ip | varchar(50) | utf8_general_ci | Yes |
| NULL |
|
reporter_date | datetime |
| Yes |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
user_id | BTREE | No | 0 | user_id |
location_id | BTREE | No | 0 | location_id |
service_id | BTREE | No | 0 | service_id |
level_id | BTREE | No | 0 | level_id |
roles
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| NO | PRIMARY | None | AUTO_INCREMENT |
name | varchar(32) | utf8_general_ci | No |
| None |
|
description | varchar(255) | utf8_general_ci | No |
| None |
|
access_level | tinyint(4) |
| No |
| 0 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 4 | id |
uniq_name | BTREE | Yes | 4 | name |
roles_users
Field | Type | Collation | Null | Key | Default | Extra |
user_id | int(11) unsigned |
| No |
| None | FK->users.id |
role_id | int(11) |
| No |
| None | FK->roles. id |
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | user_id |
fk_role_id | BTREE | No | 0 | role_id |
scheduler
Field | Type | Collation | Null | Key | Default | Extra |
id | int(10) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
scheduler_ name | varchar(100) | utf8_general_ci | No |
| None |
|
scheduler_last | int(10) unsigned |
| No |
| 0 |
|
scheduler_ weekday | smallint(6) |
| No |
| -1 |
|
scheduler_day | smallint(6) |
| No |
| -1 |
|
scheduler_hour | smallint(6) |
| No |
| -1 |
|
scheduler_ minute | smallint(6) |
| No |
| None |
|
scheduler_ controller | varchar(100) | utf8_general_ci | No |
| None |
|
scheduler_ | tinyint(4) |
| No |
| 1 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 5 | id |
scheduler_log
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
scheduler_id | int(10) unsigned |
| No |
| None | FK->scheduler.id |
scheduler_ status | varchar(20) | utf8_general_ci | Yes |
| NULL |
|
scheduler_date | int(10) unsigned |
| No |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
scheduler_id | BTREE | No | 0 | scheduler_id |
service
Field | Type | Collation | Null | Key | Default | Extra |
id | int(10) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
service_name | varchar(100) | utf8_general_ci | Yes |
| NULL |
|
service_ description | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
service_url | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
service_api | varchar(255) | utf8_general_ci | Yes |
| NULL |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 3 | id |
sessions
Field | Type | Collation | Null | Key | Default | Extra |
session_id | varchar(127) | utf8_general_ci | No |
| None |
|
last_activity | int(10) unsigned |
| No |
| None |
|
data | text | utf8_general_ci | No |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | No | 0 | session_id |
settings
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
key | varchar(100) | utf8_general_ci | No |
|
|
|
value | text | utf8_general_ci | Yes |
| Null |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 1 | id |
uq_settings_key | BTREE | Yes | 1 | key |
users
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
riverid | varchar(128) | utf8_general_ci | No |
| None |
|
name | varchar(200) | utf8_general_ci | Yes |
| NULL |
|
varchar(127) | utf8_general_ci | No |
| None |
| |
username | varchar(100) | utf8_general_ci | No |
| None |
|
password | char(50) | utf8_general_ci | No |
| None |
|
logins | int(10) unsigned |
| No |
| 0 |
|
last_login | int(10) unsigned |
| No |
| 0 |
|
notify | tinyint(1) |
| No |
| 0 |
|
updated | timestamp on update CURRENT_ |
| No |
| CURRENT_ | ON UPDATE CURRENT_TIMESTAMP |
color | varchar(6) | utf8_general_ci | No |
| FF0000 |
|
code | varchar(30) | utf8_general_ci | Yes |
| NULL |
|
confirmed | tinyint(1) |
| No |
| 1 |
|
public_profile | tinyint(1) |
| No |
| 1 |
|
approved | tinyint(1) |
| No |
| 1 |
|
needinfo | tinyint(1) |
| No |
| 0 |
|
notify: Flag incase admin opts for email_notifications
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 1 | id |
uniq_username | BTREE | Yes | 1 | username |
uniq_email | BTREE | Yes | 1 |
user_devices
Field | Type | Collation | Null | Key | Default | Extra |
id | varchar(255) | utf8_general_ci | No | PRIMARY | None |
|
user_id | int(11) unsigned |
| No |
| None | FK->users.id |
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
user_id | BTREE | No | 0 | user_id |
user_tokens
Field | Type | Collation | Null | Key | Default | Extra |
id | int(11) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
user_id | int(11) unsigned |
| No |
| None | FK->users.id |
user_agent | varchar(40) | utf8_general_ci | No |
| None |
|
token | varchar(64) | utf8_general_ci | No |
| None |
|
created | int(10) unsigned |
| No |
| None |
|
expires | int(10) |
| No |
| None |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
uniq_token | BTREE | Yes | 0 | token |
fk_user_id | BTREE | No | 0 | user_id |
verified
Field | Type | Collation | Null | Key | Default | Extra |
id | bigint(20) unsigned |
| No | PRIMARY | None | AUTO_INCREMENT |
incident_id | bigint(20) |
| Yes |
| NULL | FK->incident.id |
user_id | int(11) |
| Yes |
| NULL | FK->users.id |
verified_date | datetime |
| Yes |
| NULL |
|
verified_status | tinyint(4) |
| No |
| 0 |
|
Indexes
Keyname | Type | Unique | Cardinality | Field |
PRIMARY | BTREE | Yes | 0 | id |
incident_id | BTREE | No | 0 | incident_id |