This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision |
| tables_fields [2020/01/07 01:35] – lou | tables_fields [2021/10/08 09:14] (current) – Gary Willetts |
|---|
| {{indexmenu_n>2000}} | {{indexmenu_n>2100}} |
| {{:msupplybanner.jpg?}} | {{:msupplybanner.jpg?}} |
| ====== 20. Data Tables and Fields ====== | ====== 24. Data Tables and Fields ====== |
| The following tables list the main data tables in mSupply (there are some others, but we're not telling you about those!). This information will help you if you are building your own reports. | The following tables list the main data tables in mSupply (there are some others, but we're not telling you about those!). This information will help you if you are building your own reports. |
| |
| {{indexmenu>:tables_fields:#1|msort}} | {{indexmenu>:tables_fields:#1|msort}} |
| |
| ---- | |
| \\ | |
| \\ | |
| |<750px>| | |<750px>| |
| ^Summary of table names ^[[tables_fields:main_tables|Main Tables]] ^[[tables_fields:other_tables|Other Tables]] ^[[tables_fields:foreign_keys|Foreign Keys]]^[[tables_fields:internal_tables|Internal Tables]] | | ^Summary of table names ^[[tables_fields:main_tables|Main Tables]] ^[[tables_fields:other_tables|Other Tables]] ^[[tables_fields:foreign_keys|Foreign Keys]]^[[tables_fields:internal_tables|Internal Tables]] | |
| |::: |{{indexmenu>:tables_fields:main_tables:#1|nsort}}|{{indexmenu>:tables_fields:other_tables:#1|nsort}}|{{indexmenu>:tables_fields:foreign_keys:#1|nsort}} //[[tables_fields:foreign_keys|Table listing all foreign keys]]// |{{indexmenu>:tables_fields:internal_tables#:1|nsort}} [[tables_fields:internal_tables#item_store_join]]\\ [[tables_fields:internal_tables#name_store_join]]\\ [[tables_fields:internal_tables#name_group]]\\ [[tables_fields:internal_tables#numbers]]\\ [[tables_fields:internal_tables#number_re-use]]\\ [[tables_fields:internal_tables#permissions]]\\ [[tables_fields:internal_tables#prefs]]\\ [[tables_fields:internal_tables#reports]]\\ [[tables_fields:internal_tables#ship_method]]\\ [[tables_fields:internal_tables#sync_out]]\\ [[tables_fields:internal_tables#transaction_category]]\\ [[tables_fields:internal_tables#transaction_notes]]\\ [[tables_fields:internal_tables#units]]\\ | | |::: |{{indexmenu>:tables_fields:main_tables:#1|nsort}}|{{indexmenu>:tables_fields:other_tables:#1|nsort}}|{{indexmenu>:tables_fields:foreign_keys:#1|nsort}} //[[tables_fields:foreign_keys|Table listing all foreign keys]]// |{{indexmenu>:tables_fields:internal_tables#:1|nsort}} [[tables_fields:internal_tables#item_store_join]]\\ [[tables_fields:internal_tables#name_store_join]]\\ [[tables_fields:internal_tables#name_group]]\\ [[tables_fields:internal_tables#numbers]]\\ [[tables_fields:internal_tables#number_re-use]]\\ [[tables_fields:internal_tables#permissions]]\\ [[tables_fields:internal_tables#prefs]]\\ [[tables_fields:internal_tables#reports]]\\ [[tables_fields:internal_tables#ship_method]]\\ [[tables_fields:internal_tables#sync_out]]\\ [[tables_fields:internal_tables#transaction_category]]\\ [[tables_fields:internal_tables#transaction_notes]]\\ [[tables_fields:internal_tables#units]]\\ [[tables_fields:internal_tables#insuranceProvider]]\\ [[tables_fields:internal_tables#nameInsuranceJoin]]| |
| |
| |
| ---- | ---- |
| \\ | \\ |
| | // Previous topic: **[[integration|19. Integration of Other Systems with mSupply]]** | | Return to: **[[start|mSupply User Guide Home Page]]** | | Next topic: **[[admin|21. Technical Administration]]** // | | | // Previous topic: **[[integration]]** | | Next topic: **[[admin|]]** // | |
| |
| |
| ---- struct data ---- | ---- struct data ---- |
| | pagestatus.status : |
| ---- | ---- |
| |