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