Hi Peter

>TABLE.iTABLE is always the primary integer key.
>TABLE.cTABLE is an alternate character key.

TABLE.iTABLE? Isn't that redundant? If you ask me, its not very precise either. Why not TABLE.id and TABLE.name. ACtually as nice in theory as that is, I prefer to do TABLE.id_TBL (Shortened version of TABLE) that way, your relationshipd are easier to match. But .name is still a better idea than just renaming it after the table:

EMPLOYEE.Name
ITEMS.Name
MANUFACTURER.Name
SUPPLIER.Name

>TABLE.dStart instead of TABLE.StartDate
>TABLE.tStart instead of TABLE.StartDtTim

This I'm not going to touch just because I know its an example off the top of your head :-)