Database: Admin schema
Description of the tables in the Admin schema
In a completely new instance of Zcore, many of the tables in the admin database are empty, to be populated once the user creates forms using Zcore's Dynasite form creation tool. Some of the tables are pre-populated for convenience; however, they may be deleted in future builds.
| Table | Status | Description |
|---|---|---|
| APPUPDATE | empty | Logs application updates |
| DISTRICT | populated w/ Zambian values | used for patient id assignment widget |
| DRUGS | populated w/ Zambian values | used for dropdown in drugs tag |
| FIELD_ENUMERATION | empty | used to store dropdown values entered using in dynasite |
| FLOW | populated w/ values | used to store what "category" a form is in. |
| FORM | empty | used to store form metadata entered using dynasite |
| FORM_FIELD | empty | used to store form field data entered using dynasite |
| FORM_TYPE | loaded w/ values | dropdown used in form creation/editing in dynasite |
| IMMUNIZATION | populated w/ Zambian values | used in immunization dropdown |
| IMMUNIZATION_TYPE | populated w/ Zambian values | used in immunization dropdown |
| PAGE_ITEM | empty | used to store page item data entered using dynasite |
| RULE_DEFINITION | empty | used to store rule defiitions entered using dynasite |
| SEX | loaded w/ values | used for sex dropdown (m/f) |
| SITE | empty | used to store site info |
PDF version