Re: sql schema advice sought

Поиск
Список
Период
Сортировка
От Jonathan Vanasco
Тема Re: sql schema advice sought
Дата
Msg-id A520DD20-0B23-406F-95D3-CE67C9C34709@2xlp.com
обсуждение исходный текст
Ответ на Re: sql schema advice sought  (Jaime Silvela <JSilvela@Bear.com>)
Список pgsql-general
On Apr 3, 2007, at 9:56 AM, Jaime Silvela wrote:

> I have a similar situation. Here's what I do.
>
> I have a stand-alone comment table:
>    Comments
>        id
>        timestamp
>        text
>
> Then I have individual product tables to tie a table to a comment:
>    Table_A_Comment
>        id
>        id_ref_a references tableA
>        id_comment references Comments

thats perfect, and simple.

the unified table is too dirty :)   i've done stuff like that in the
past, and was always upset with it.




// Jonathan Vanasco

| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -



В списке pgsql-general по дате отправления:

Предыдущее
От: "Ben Trewern"
Дата:
Сообщение: Re: Webappication and PostgreSQL login roles
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: UPDATE on two large datasets is very slow