1. Are there preferred data types for customer, employee and workorder table record fields?
I was thinking that there has to be an organization that publishes official rules or guidelines regarding these things.
2. Also, is it necessary or better for indexes, primary or otherwise, to be INT as apposed to CHAR?
For instance, a US State table that contains state names and their abbreviations. Is it ok to use the abbreviation column as the primary index or is it better to have a separate INT primary index?