Platform Developer Documentation
Search…
👋
Welcome | README
Code of Conduct
Contributing | Getting Involved
Frequently Asked Questions
Join the Ushahidi community
Contributors ✨
🛣️ The Ushahidi Platform Roadmap
Privacy and security best practices
Development & Code
Development: Overview
How to get the source code
Setup Guides
Add code to Ushahidi
Development process
Coding Standards
Track and submit issues in Github
Upgrading Ushahidi
⚙️ Installation Helper
Tech Stack
API Documentation
Third party app development
Database | Tables overview
Database | Database Schema Diagram
Database | Table details
📐
Architecture
Use case internals
QA & Testing
The QA process
How to run QA tests
Defect Management
How to write QA test scripts
Hotfixes
Front-end development
Changing UI styles: introduction to the pattern library
Design
🎨
Design: overview
'Best practice' design
Ushahidi Platform 'Sticker Sheet'
User testing process
User testing script examples
Synthesising user testing results examples
Open Source Design
Documentation
Documentation
Contributing docs via GitHub
Translation
Localization and Translation
The Ushahidi Platform Facebook bot
The Facebook bot
Hackathon and events
Installathon, May 2019
Write/Speak/Code 2019
Open Design: Bangalore
Open Design: Taipei
📑
Google season of docs
Enhancement Proposals
Exchange Format
Importing data from previous versions
Powered By
GitBook
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.
Previous
Web hooks
Next - Tech Stack
Database | Database Schema Diagram
Last modified
2yr ago
Copy link