Re: sql schema advice sought

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
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -