| From: | Jonathan Vanasco <postgres(at)2xlp(dot)com> |
|---|---|
| To: | Jaime Silvela <JSilvela(at)Bear(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: sql schema advice sought |
| Date: | 2007-04-03 15:30:39 |
| Message-ID: | A520DD20-0B23-406F-95D3-CE67C9C34709@2xlp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2007-04-03 15:41:39 | Re: Using C# to create stored procedures |
| Previous Message | Jonathan Vanasco | 2007-04-03 15:27:57 | Re: inserting multiple values in version 8.1.5 |