Database Best Practices
| От | ghoffman@ucsd.edu (Gary Hoffman) |
|---|---|
| Тема | Database Best Practices |
| Дата | |
| Msg-id | fc.00249f0e003806cd00249f0e003806cd.3806d2@irpsbbs.ucsd.edu обсуждение исходный текст |
| Ответы |
Re: [GENERAL] Database Best Practices
|
| Список | pgsql-general |
To all the database experts out there: As I begin to design my PostGreSQL tables, I'm looking for some over-the-shoulder advice on the order of "best practices" recommendations. Has anyone gathered their experience together into such a book or website? For example, I'd like to know, in designing a name-and-address table, - should a title field be provided? (Mr., Dr., etc.) - how about a suffix (Jr., III, etc.) - how many address lines should I have for a home address? - should all the fields be type 'text'? Should Zip be 'text' or 'int4'? - what schema handles Zip-plus-four best (including the blasted hyphen)? - what is the best database schema for a universal, international address table that includes individuals and companies? Now that I know _how_ to create tables and columns, I want to know _how_best_ to do so. Thanks for your tips. Gary ************************************************************************** * Gary B. Hoffman, Computing Services Manager e-mail: ghoffman@ucsd.edu * * Graduate School of International Relations and Pacific Studies (IR/PS) * * University of California, San Diego (UCSD) voice: (858) 534-1989 * * 9500 Gilman Dr., La Jolla, CA 92093-0519 USA fax: (858) 534-3939 * **************************************************************************
В списке pgsql-general по дате отправления: