Database | Table details
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 | |
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 |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
Field | Type | Null | Key | Default | Extra |
tag_id | int(11) | NO | PRI | 0 | |
attribute_id | int(11) | NO | PRI | 0 | |
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 | |
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 | |
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 | |
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 | |
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 | | 0 | |
