simple or global column names?
От | george young |
---|---|
Тема | simple or global column names? |
Дата | |
Msg-id | 20051108102826.1dfe7b32.gry@ll.mit.edu обсуждение исходный текст |
Ответы |
Re: simple or global column names?
|
Список | pgsql-novice |
[PostgreSQL 7.4RC2 on i686-pc-linux-gnu] [soon to upgrade to 8.x] I have a simple schema design question. I'm torn between: create table steps(step text, step_version int, substep text, substep_version int); and: create table steps(step text, version int, substep text, substep_version int) I.e., should a field in steps be "version" or "step_version"? On one hand, the "step_" prefix is redundant noise in this context, but for doing joins, it seems like globally distinct names might make things clearer. Are there other advantages/disadvantages to these naming schemes? My goals (in this major schema reorganization) are simplicty, clarity, and in particular, to facilitate nieve users' read-only ODBC access through Excel or other GUI clients. -- George Young -- "Are the gods not just?" "Oh no, child. What would become of us if they were?" (CSL)
В списке pgsql-novice по дате отправления: