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

​