24.02. Other tables
Name of table | Description of table |
---|---|
Abbreviations | Stores abbreviation codes and their expansion for dispensing directions |
Account_code | Stores account codes associated with each item |
Authorisations | Tables that store authorisers and pending authorisations |
Backorders | One record for Customer backorder. |
Bill of Materials | One record for each mSupply user |
Cold chain (sensors and temperature logs) | Everything to do with storing cold chain records |
Contacts | One record for each contact |
Currency | One record for each curency |
Custom stock fields | Holds the details of the values that are selectable in the 5th - 8th user fields when receiving stock |
Drug interactions | Drug interactions and Drug interaction groups |
Item Categories | One record for item category |
Item Departments | The departments that an item can be assigned to |
Item Directions | The default directions that are assigned to items |
Item notes | The notes that are attached to items |
Item Warning Link | A join table that stores which items have which warnings |
Labels | Miscellaneous labels |
Location | Each record contains one shelf location. |
Log | Each record contains one event recorded by mSupply |
Name category tables | Tables that store the categories that can be assigned to names (customers, suppliers, donors, manufacturers etc.) |
Prescribers | One record for each prescriber |
Regimen records, Regimen and Regimen Lines | Everything to do with storing ARV regimen records |
Reminders | A reminder is an event with a due date- like a to-do |
Stores | Stores and join tables that control access per-store |
Users | One record for each mSupply user |
Warnings | The warnings which can be attached to items |
Previous: 24.01. Main tables | | Next: 24.03. Foreign keys |