20. Data Tables and Fields

This is an old revision of the document!

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
	Aggregator table Drug_register Goods received line Goods received item_line Item List master line List master name join List master Name Preferences (Prefs) Purchase Order Lines Purchase Orders Quotes Requisition Stock_take Tenders Transaction lines Transactions	Abbreviation Account code authoriser Backorders Bill of Materials Master Cold chain Contact Currencies Custom Stock fields Drug Interactions Item category Item department Item directions Item Note Item Warning link Label Location & Location Movement Log Name category tables Periods Periods Prescribers Regimen Reminders Store Temperature & VVM Users Warnings	Table listing all foreign keys	item_store_join, name_store_join, name_group, numbers, number_re-use, permissions prefs, [tables_fields:internal_tables#reports]] ship_method, sync_out transaction_category, transaction_notes units

Previous topic: 19. Integration of Other Systems with mSupply \| \| Return to: mSupply User Guide Home Page \| \| Next topic: 21. Technical Administration