23. 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.

Note that if a field is indexed, finding information (querying) using that field will be very quick.

Summary of table names	Main Tables	Other Tables	Foreign Keys	Internal Tables
Table listing all foreign keys	item_store_join name_store_join name_group numbers number_re-use permissions prefs reports ship_method sync_out transaction_category transaction_notes units insuranceProvider nameInsuranceJoin

Previous topic: 23. Integration with other systems | | Next topic: 25. Technical Administration