There is a wealth of good information at the HTMC site (which is maintained by some well-known - and prolific - biomeds in the USA). I would point you especially towards the "Database Tables".

Meanwhile, if you can provide an email address (include in your Profile, for example), I can send you some other files (.pdf, .xls) that may help when making your plans.

If you don't inspect ... don't expect.