Table |
Description |
Relevant areas of the Ushahidi UI/Functionality |
Comments |
|---|---|---|---|
|
Stores user defined actions triggered by certain events e.g, assign a badge when a user submits 3 reports |
Admin->Manage->Actions |
* |
|
Stores a log of actions triggered, user who triggered it and date it was triggered |
Admin->Manage->Actions |
* |
|
Stores alerts subscribers’ information(phone number/email address, and subscription confirmation, location radius of alerts to be sent to them) |
Get Alerts |
* |
|
Stores categories subscribers would like to recieve alerts about |
Get Alerts |
* |
|
Stores a log of alerts sent out to subscribers |
* |
* |
|
Stores a list of all IP addresses banned from accessing a deployment’s API |
Admin->Settings->API-> |
* |
|
Stores a log of all API tasks, parameters and returns carried out, along with the date of access and accessing IP |
-Admin->Settings->API-> |
* |
|
Stores boundaries/limitations set with regards to API access |
-Admin->Settings->API-> |
* |
|
Stores description of badges to be assigned |
-Admin->Manage->Badges |
* |
|
Stores assigned badge information i.e user and corresponding badge assigned to that particular user |
-Admin->Manage->Badges(you can assign a badge to a user from this page) |
* |
|
Holds information about categories defined for a deployment |
-Admin->Dashboard |
* |
|
Holds translations for category titles and descriptions in selected languages |
Same as above |
* |
|
Stores checkin information - for deployments that have checkins enabled |
-Homepage |
* |
|
Stores cities of countries retrieved by user. |
-Admin->Settings->Map(the retrieve cities from geonames link populates this table) |
* |
|
Stores informations used for clustering of reports on the map. |
-Homepage (Main map) |
* |
|
Stores comments made on reports/checkins |
-Report details |
* |
|
Stores a list of all countries in the world and their capital cities |
-Admin->Settings->Map( |
* |
|
Stores information about any external apps that communicate with your deployment, mainly our mobile apps(iPhone and Android) |
-Homepage(Links to mobile apps on the How to Report Box on the main page) |
* |
|
Stores information about RSS Feeds a deployment subscribes to |
-Admin->Dashboard |
* |
|
Stores feed items pulled from each RSS Feed |
-Homepage->Official and Mainstream news |
* |
|
Stores all report submission forms created(default+custom) |
-Admin->Manage->Forms |
* |
|
Stores all custom form fields created by users |
-Admin->Manage->Forms |
* |
|
Stores options related to custom form fields e.g, who can submit answers, toggle field or not etc |
-Admin->Manage->Forms->Edit form fields |
* |
|
Stores responses to custom form fields |
-Admin->Reports->Edit Reports |
* |
|
Stores map geometries i.e polygons, lines etc |
-Reports->More information(for an individual report) |
* |
|
Stores reports submittted |
-Homepage(main map) |
* |
|
Stores stored reports’ categories |
-Admin->Reports->View Reports |
* |
|
Holds translations for report titles and descriptions in selected languages |
Same as above |
* |
|
Holds information provided by people who submit reports with their personal information i.e name, email address, phone number |
-Admin->Reports->View Reports |
* |
|
Holds static layer information |
-Admin->Manage->Layers |
* |
|
Stores level of trust assigned to reporters of the platform |
-Admin->Messages->SMS->Reporters |
To be affected if reporters table is removed. Was classified as a dormant table in the platform Benchmarking report |
|
Stores location information for submitted reports |
-Homepage |
* |
|
Puts a site in maintenance mode if there's any data in this table.IP addresses serve as a whitelist for maintenance mode |
|
* |
|
Stores any media submitted along with a report/checkin e.g a news link, photo, video |
-Reports |
* |
|
Stores tweets, emails and SMS messages pulled into a deployment |
-Admin->Dashboard |
* |
|
Stores users’ openid information |
Admin->Login(With current changes made to login page, no longer existent) |
Maybe OpenID should be made into a plugin? -BH |
|
Stores user created pages |
-Homepage |
* |
|
Stores permissions used for access control |
-Admin->Users->Manage Roles and Permissions |
|
|
Stores permissions assigned to roles |
-Admin->Users->Manage Roles and Permissions |
|
|
Holds a list of all plugins installed on a deployment |
Admin->Addons->Plugins |
* |
|
Stores private messages sent between Members |
-Members->Dashboard |
* |
|
Stores credibility ratings assigned to submitted reports |
-Admin->Reports->Comments |
* |
|
Holds information about people who submit reports via email, twitter and SMS |
-Admin->Messages->SMS->Reporters |
Was classified as a dormant table in the platform Benchmarking report |
|
Defines user access levels and privileges on a deployment |
-Admin->Users->View Users |
|
|
Stores roles assigned to users registered on a deployment |
-Admin->Users->View Users |
* |
|
Stores schedules for the following tasks:- |
Admin->Manage->Scheduler |
* |
|
Stores a log of scheduler actions |
Admin->Manage->Scheduler->Scheduler log |
* |
|
Stores information about different services via which info is pulled into the platform from i.e SMS, Email, Twitter |
-Admin->Dashboard |
* |
|
Stores session information |
* |
* |
|
Stores a deployment’s general settings e.g Site name, tagline, copyright statement, etc |
Well, basically affects everything on the frontend :) |
* |
|
Stores registered users’ information |
Admin->Users->View Users |
* |
|
Stores mobile IDs for users. Works with checkins. Ties mobile devices to users without logging in so that the ids on the devices make the distinction |
Admin->Checkins |
Was classified as a dormant table in the platform Benchmarking report. Might just be removed once RiverID is fully integrated into mobile apps |
|
Stores browser tokens assigned to users |
* |
* |
|
Stores all verified reports |
-Reports |
* |