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/14 09:28] – links in footer revised to give live page titles 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. |
| |
| |<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]]| |
| |
| |
| |
| ---- struct data ---- | ---- struct data ---- |
| | pagestatus.status : |
| ---- | ---- |
| |