Re: sql schema advice sought - Mailing list pgsql-general

From Jonathan Vanasco
Subject Re: sql schema advice sought
Date
Msg-id A520DD20-0B23-406F-95D3-CE67C9C34709@2xlp.com
Whole thread Raw
In response to Re: sql schema advice sought  (Jaime Silvela <JSilvela@Bear.com>)
List 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 by date:

Previous
From: "Ben Trewern"
Date:
Subject: Re: Webappication and PostgreSQL login roles
Next
From: Scott Marlowe
Date:
Subject: Re: UPDATE on two large datasets is very slow