23. 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 item_line Item 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 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 reports ship_method sync_out transaction_category transaction_notes units insuranceProvider nameInsuranceJoin

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