Development & Code
Tech Stack
Front-end development
Design
Documentation
Translation
The Ushahidi Platform Facebook bot
Hackathon and events
Enhancement Proposals
Database | Table details
Details for all tables in the Platform database
apikeys
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
api_key
text
NO
NULL
client_id
text
YES
NULL
client_secret
text
YES
NULL
created
int(11)
NO
0
updated
int(11)
YES
NULL
config
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
group_name
varchar(50)
NO
MUL
NULL
config_key
varchar(50)
NO
NULL
config_value
text
YES
NULL
updated
timestamp
NO
MUL
CURRENT_TIMESTAMP
on update CURRENT_TIMESTAMP
contacts
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
user_id
int(11)
YES
MUL
NULL
data_source
varchar(150)
YES
MUL
NULL
type
varchar(20)
YES
NULL
contact
varchar(255)
NO
NULL
created
int(11)
NO
MUL
0
updated
int(11)
YES
MUL
NULL
can_notify
tinyint(1)
NO
0
country_codes
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
country_name
varchar(255)
NO
0
dial_code
varchar(255)
NO
0
country_code
varchar(255)
NO
MUL
0
csv
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
columns
text
NO
NULL
maps_to
text
YES
NULL
fixed
text
YES
NULL
filename
varchar(255)
NO
NULL
size
int(11)
NO
0
mime
varchar(50)
NO
created
int(11)
NO
0
updated
int(11)
YES
NULL
status
varchar(255)
YES
NULL
errors
varchar(255)
YES
NULL
processed
varchar(255)
YES
NULL
collection_id
int(11)
YES
NULL
export_batches
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
export_job_id
int(11)
NO
MUL
NULL
status
varchar(255)
NO
pending
batch_number
int(11)
NO
0
filename
varchar(255)
YES
has_headers
tinyint(1)
NO
0
rows
int(11)
NO
0
created
int(11)
NO
0
updated
int(11)
YES
0
export_job
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
user_id
int(11)
NO
MUL
NULL
entity_type
varchar(255)
NO
NULL
fields
mediumtext
YES
NULL
filters
mediumtext
YES
NULL
status
varchar(255)
YES
NULL
url
text
YES
NULL
created
int(11)
NO
0
updated
int(11)
NO
0
url_expiration
varchar(12)
YES
0
status_details
varchar(255)
YES
0
header_row
mediumtext
YES
NULL
hxl_meta_data_id
int(11)
YES
UNI
NULL
include_hxl
tinyint(1)
NO
0
send_to_browser
tinyint(1)
NO
0
send_to_hdx
tinyint(1)
NO
0
hxl_heading_row
mediumtext
YES
NULL
total_rows
int(11)
YES
NULL
total_batches
int(11)
YES
NULL
form_attribute_hxl_attribute_tag
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
form_attribute_id
int(11)
NO
MUL
0
hxl_attribute_id
int(11)
YES
MUL
NULL
hxl_tag_id
int(11)
NO
MUL
0
export_job_id
int(11)
NO
MUL
0
form_attribute
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
key
varchar(150)
NO
UNI
NULL
label
varchar(150)
NO
NULL
instructions
text
YES
NULL
input
varchar(30)
NO
text
type
varchar(30)
NO
varchar
required
tinyint(1)
NO
0
default
varchar(150)
YES
NULL
priority
int(11)
NO
MUL
99
options
text
YES
NULL
cardinality
int(11)
NO
1
config
text
YES
NULL
form_stage_id
omt(11)
YES
MUL
NULL
response_private
tinyint(1)
NO
0
description
varchar(255)
YES
NULL
form_roles
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
form_id
int(11)
NO
MUL
NULL
role_id
int(11)
NO
MUL
NULL
form_stages
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
form_id
int(11)
NO
MUL
NULL
label
varchar(150)
NO
NULL
priority
int(11)
NO
99
icon
varchar(100)
YES
NULL
required
tinyint(1)
NO
0
type
varchar(255)
NO
task
description
varchar(255)
YES
NULL
show_when_published
tinyint(1)
NO
1
task_is_internal_only
tinyint(1)
NO
1
form_stages_posts
Field
Type
Null
Key
Default
Extra
form_stage_id
int(11)
NO
PRI
NULL
post_id
int(11)
NO
PRI
NULL
completed
tinyint(1)
NO
0
forms
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
parent_id
int(11)
YES
MUL
NULL
name
varchar(255)
NO
NULL
description
text
YES
NULL
type
varchar(30)
NO
report
created
int(11)
NO
MUL
0
updated
int(11)
YES
MUL
NULL
disabled
tinyint(1)
NO
0
require_approval
tinyint(1)
NO
1
everyone_can_create
tinyint(1)
NO
1
color
varchar(6)
YES
NULL
hide_author
tinyint(1)
NO
0
hide_time
tinyint(1)
NO
0
hide_location
tinyint(1)
NO
0
targeted_survey
tinyint(1)
NO
0
hxl_attribute_type_tag
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
form_attribute_type
varchar(255)
NO
0
hxl_tag_id
int(11)
NO
MUL
0
hxl_attributes
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
attribute
varchar(255)
NO
UNI
0
description
varchar(255)
NO
0
hxl_license
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
name
varchar(255)
NO
MUL
0
link
varchar(255)
NO
0
code
varchar(255)
NO
UNI
0
hxl_meta_data
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
private
tinyint(1)
NO
1
dataset_title
varchar(255)
NO
MUL
NULL
license_id
int(11)
NO
MUL
NULL
user_id
int(11)
NO
MUL
NULL
organisation_id
varchar(255)
NO
NULL
source
varchar(255)
NO
NULL
created
int(11)
NO
0
updated
int(11)
YES
NULL
organisation_name
varchar(255)
YES
NULL
hxl_tag_attributes
Field
Type
Null
Key
Default
Extra
tag_id
int(11)
NO
PRI
0
attribute_id
int(11)
NO
PRI
0
hxl_tags
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
tag_name
varchar(255)
NO
UNI
0
description
varchar(255)
NO
0
layers
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
media_id
int(11)
YES
MUL
NULL
name
varchar(50)
NO
NULL
type
varchar(20)
NO
geojson
data_url
varchar(255)
YES
NULL
options
varchar(255)
YES
NULL
acte
int(1)
NO
1
invisible_by_default
int(1)
NO
1
created
int(11)
NO
MUL
0
updated
int(11)
NO
MUL
0
media
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
user_id
int(11)
YES
MUL
NULL
mime
varchar(50)
NO
NULL
caption
varchar(255)
NO
o_filename
varchar(255)
NO
NULL
o_size
int(11)
NO
NULL
o_width
int(11)
YES
NULL
o_height
int(11)
YES
NULL
created
int(11)
NO
MUL
0
updated
int(11)
YES
MUL
NULL
messages
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
parent_id
int(11)
YES
MUL
NULL
contact_id
int(11)
YES
MUL
NULL
post_id
int(11)
YES
MUL
NULL
user_id
int(11)
YES
MUL
NULL
data_source
varchar(150)
YES
MUL
NULL
data_source_message_id
varchar(255)
YES
NULL
title
varchar(255)
YES
NULL
message
text
YES
NULL
datetime
datetime
YES
NULL
type
varchar(20)
YES
MUL
NULL
status
varchar(20)
NO
MUL
pending
direction
varchar(20)
NO
MUL
incoming
created
int(11)
NO
MUL
0
additional_data
text
YES
NULL
notification_post_id
int(11)
YES
MUL
NULL
notification_queue
Field
Type
Null
Key
Default
Extra
id
int(11)
NO
PRI
NULL
auto_increment
post_id
int(11)
NO
MUL
NULL
set_id
int(11)
NO
MUL
NULL
created
int(11)int(11)
NO