When looking through your iMIS database you may see a lot of tables and not know what many of them are for. If you need to write custom SQL queries or do troubleshooting with some issues, it is quite useful to know what information is stored where. Here are some more tables to get you started.

Users Tables:
  • ContactMain table contains all the contacts you have inside iMIS.
  • GroupMain table contains all groups and organizations you have inside iMIS.
Website Tables:
  • Content table contains the content used on the iMIS website. You can view when a content page was created, last changed by who, settings of the page and the location.
  • DocumentStorage table contains information related to the documents that have been uploaded to iMIS. Related to the DocumentMain table but might contain more relevant information to you.
Transactions Tables:
  • GatewayTransaction table contains transactions that have gone through the payment gateways.
  • Invoice table contains invoice information.
  • Order table contains orders requested. Includes failed and successful orders.
Misc Table:
  • Error Table contains errors that have occurred and have been recorded to the database. An additional troubleshooting step if you need to check for errors. Usually, this table is empty.

For more information on iMIS database tables or general information on iMIS, feel free to contact us.