| Both sides previous revision Previous revision Next revision | Previous revision |
| tables_fields:other_tables [2020/01/07 01:05] – ↷ Page moved from tables:other_tables to tables_fields:other_tables lou | tables_fields:other_tables [2023/01/31 02:53] (current) – Adam Dewey |
|---|
| {{indexmenu_n>10}} | {{indexmenu_n>20}} |
| |
| ====== 20.02. Other tables ====== | ====== 24.02. Other tables ====== |
| |
| ^ Name of table ^ Description of table ^ | ^ Name of table ^ Description of table ^ |
| ^ [[tables:other_tables:abbreviation|Abbreviations]] | Stores abbreviation codes and their expansion for dispensing directions | | ^ [[tables_fields:other_tables:abbreviation|Abbreviations]] | Stores abbreviation codes and their expansion for dispensing directions | |
| ^ [[tables:other_tables:account_code|Account_code]] | Stores account codes associated with each item | | ^ [[tables_fields:other_tables:account_code|Account_code]] | Stores account codes associated with each item | |
| ^ [[tables:other_tables:authorisation|Authorisations]] | Tables that store authorisers and pending authorisations | | ^ [[tables_fields:other_tables:authorisation|Authorisations]] | Tables that store authorisers and pending authorisations | |
| ^ [[tables:other_tables:backorder|Backorders]] | One record for //Customer// backorder. | | ^ [[tables_fields:other_tables:backorder|Backorders]] | One record for //Customer// backorder. | |
| ^ [[tables:other_tables:bill_of_materials|Bill of Materials]] | One record for each mSupply user | | ^ [[tables_fields:other_tables:bill_of_materials|Bill of Materials]] | One record for each mSupply user | |
| ^ [[tables:other_tables:contact|Contacts]] | One record for each contact | | ^ [[tables_fields:other_tables:coldchain|Cold chain (sensors and temperature logs)]] ^ Everything to do with storing cold chain records| |
| ^ [[tables:other_tables:currency|Currency]] | One record for each curency | | ^ [[tables_fields:other_tables:contact|Contacts]] | One record for each contact | |
| ^ [[tables:other_tables:custom_stock|Custom stock fields]] | Holds the details of the values that are selectable in the 5th - 8th user fields when receiving stock | | ^ [[tables_fields:other_tables:currency|Currency]] | One record for each curency | |
| ^ [[tables:other_tables:drug_interaction|Drug interactions]] | Drug interactions and Drug interaction groups | | ^ [[tables_fields:other_tables:custom_stock|Custom stock fields]] | Holds the details of the values that are selectable in the 5th - 8th user fields when receiving stock | |
| ^ [[tables:other_tables:item_category|Item Categories]] | One record for item category | | ^ [[tables_fields:other_tables:drug_interaction|Drug interactions]] | Drug interactions and Drug interaction groups | |
| ^ [[tables:other_tables:item_dept|Item Departments]] | The departments that an item can be assigned to | | ^ [[tables_fields:other_tables:item_category|Item Categories]] | One record for item category | |
| ^ [[tables:other_tables:item_direction|Item Directions]] | The default directions that are assigned to items | | ^ [[tables_fields:other_tables:item_dept|Item Departments]] | The departments that an item can be assigned to | |
| ^ [[tables:other_tables:item_note|Item notes]] | The notes that are attached to items | | ^ [[tables_fields:other_tables:item_direction|Item Directions]] | The default directions that are assigned to items | |
| ^ [[tables:other_tables:item_warning_join|Item Warning Link]] | A join table that stores which items have which warnings | | ^ [[tables_fields:other_tables:item_note|Item notes]] | The notes that are attached to items | |
| ^ [[tables:other_tables:label|Labels]] | Miscellaneous labels | | ^ [[tables_fields:other_tables:item_warning_join|Item Warning Link]] | A join table that stores which items have which warnings | |
| ^ [[tables:other_tables:location|Location]] | Each record contains one shelf location. | | ^ [[tables_fields:other_tables:label|Labels]] | Miscellaneous labels | |
| ^ [[tables:other_tables:log|Log]] | Each record contains one event recorded by mSupply | | ^ [[tables_fields:other_tables:location|Location]] | Each record contains one shelf location. | |
| ^ [[tables:other_tables:name_category|Name category tables]] | Tables that store the categories that can be assigned to names (customers, suppliers, donors, manufacturers etc.) | | ^ [[tables_fields:other_tables:log|Log]] | Each record contains one event recorded by mSupply | |
| ^ [[tables:other_tables:prescriber|Prescribers]] | One record for each prescriber | | ^ [[tables_fields:other_tables:name_category|Name category tables]] | Tables that store the categories that can be assigned to names (customers, suppliers, donors, manufacturers etc.) | |
| ^ [[tables:other_tables:regimen|Regimen records, Regimen and Regimen Lines]] ^ Everything to do with storing ARV regimen records | | ^ [[tables_fields:other_tables:prescriber|Prescribers]] | One record for each prescriber | |
| ^ [[tables:other_tables:reminder|Reminders]] | A reminder is an event with a due date- like a to-do | | ^ [[tables_fields:other_tables:regimen|Regimen records, Regimen and Regimen Lines]] ^ Everything to do with storing ARV regimen records | |
| ^ [[tables:other_tables:store|Stores]] | Stores and join tables that control access per-store | | ^ [[tables_fields:other_tables:reminder|Reminders]] | A reminder is an event with a due date- like a to-do | |
| ^ [[tables:other_tables:user|Users]] | One record for each mSupply user | | ^ [[tables_fields:other_tables:store|Stores]] | Stores and join tables that control access per-store | |
| ^ [[tables:other_tables:warning|Warnings]] | The warnings which can be attached to items | | ^ [[tables_fields:other_tables:user|Users]] | One record for each mSupply user | |
| | ^ [[tables_fields:other_tables:warning|Warnings]] | The warnings which can be attached to items | |
| |
| \\ | \\ |
| \\ | \\ |
| | // Previous: **[[tables:main_tables |20.01. Main tables]]** | | Next: **[[tables:foreign_keys:|20.03. Foreign keys]]** // | | | // Previous: **[[tables_fields:main_tables]]** | | Next: **[[tables_fields:foreign_keys:]]** // | |
| |
| ---- struct data ---- | ---- struct data ---- |
| | pagestatus.status : |
| ---- | ---- |
| |