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		0