Database | Table details
Details for all tables in the Platform database
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 |