>Ken,
>
>I'm with you on a few, but I agree, adding the xx_ to each field name so you know what table it belongs in, I don't like that, but don't see how it would hurt you.
>
>For PK/FK, we just use the table name with _id after it... Like we have customers and customer_id,
>
>In the invoices table with a PK of invoice_id would have a FK back to the customers table, it is still named customer_id... This makes joins alot easier... also, another reason we did this is that Crystal Reports uses same name fields to do joins.
>
>Also, one thing we didn't do, that I would do in my next app is to use User Defined Types... this way, you don't have to worry about changes messing up things... So, if you have a data type "fname" and you use that for all your first names, if you change its size, all your firstname fields change.
>
>BOb
I don't think it's easy to do. You cannot change User Defined Type. You've to drop it and create again.
--sb--