Development & Code
Tech Stack
Front-end development
Design
Documentation
Translation
The Ushahidi Platform Facebook bot
Hackathon and events
Enhancement Proposals
Database | Tables overview
This is a list of all tables used for the Ushahidi Platform.
Table
Description
Relevant areas of Ushahidi UI/functionality
Comments
apikeys
Generate API keys for external services that connect with the platform API
Setting -> General (it shows your API Key).
-
config
Stores configuration for the deployment
-
-
contacts
Stores contact information for users
Used for: SMS contacts, twitter contacts , mail contacts. Messages are usually associated with contacts.
-
country_codes
Stores countrycodes for targeted surveys
Settings -> Surveys -> Create targeted survey
This feature needs the targeted survey feature-flag to be turned on.
csv
Stores details about a CSV export.
Used by the UI to check on CSV export status (done, in progress ,etc) and get the url to download the file generated.
Settings -> Export data
-
export_batches
Used to separate a large export in chunks to be processed.
Settings -> Export data
-
export_job
Used to store data about the exports requested by the user in the csv endpoint.
Settings->Export data
-
form_attribute_hxl_attribute_tag
Stores the relationship between an HXL tag and attribute and a form attribute. For instance the match of a
#meta tag
+value attribute
with a "description" field
Settings-> Export data
HDX Feature - available only in some deployments through the Export UI
form_attributes
Stores information about each field (question) in a survey.
Settings -> Surveys -> Create/Edit survey
-
form_roles
Stores information if a survey is restricted to specific roles only.
Settings -> Surveys -> Create/Edit survey -> Configuration-
-
form_stages
Stores information about each section in a survey, for example post or tasks.
Settings
-> Surveys -> Create/Edit survey
-
form_stages_posts
Stores relations between posts and forms_stages and if a task is completed in a post.
Settings -> Surveys -> Create/Edit survey
Add post
Edit post
View post
-
forms
Stores basic information about each survey
Settings -> Surveys
Add post
View post
Edit/Structure post
-
hxl_attribute_type_tag
Stores the types of attributes that can be matched with each HXL attribute. For instance you can only match #geo (+lat + lon) to location fields.
Settings -> Export data
HDX feature - only available in some deployments through export UI.
Uses this field to show the list of available tags for each field
hxl_attributes
All the available HXL attributes
Settings -> Export data
HDX feature only available in some deployments.
hxl_license
All the available HDX licenses
Settings -> Export data
HDX feature only available in some deployments.
hxl_meta_data
Information required to save a dataset into HDX (humdata.org) such as license selected, name, and privacy settings
Settings -> Export data
HDX feature only available in some deployments.
hxl_tag_attributes
Relationship between HXL Tags and Attributes (which attributes are available for each tag)
This field is used to show the correct attributes when you select a tag
Settings -> Export data
HDX feature only available in some deployments.
hxl_tags
Stores all the available HXL tags
Settings -> Export data
HDX feature only available in some deployments.
Last modified 2yr ago
Copy link