I have created a table on my database with a series of serial numbers and a true/false value to tell me whether or not they have been issued. I would like to either insert these values into a transactional email or attach a text file with the serial number to the email. What would be my best approach for this and what files would I need to edit to accomplish this? (not quite familiar with the magento model yet)
As for additional table, I definitely would not recommend to create any as Magento uses EAV database model (Entity–attribute–value) and you won’t be able to link this newly created table and apply it to your products.
What I actually do recommend is to add those serial number as attribute and in this way you will be able to apply them to your products. For example, create attribute group - Serial Numbers and in it create 2 attributes - Number and verification. For number put values that you have for serial numbers, for verification - yes/no.
It really depends on what you are ultimately trying to accomplish which files you may need to either modify or create. There are a lot of ways to skin this monster. But, I hope I’ve assisted by pointing you in the right direction to start.