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