Loading

Database design dilema

Chuck D

I have a small database dilema that I am trying to solve. I have 3 database tables: Lyrics, Tablature and Concert. Each table will hold a record for its own unique guitar tab, lyric or concert venue. I also have a comments table. I want users to be able to comment in each of those sections (Lyrics, Tablature, Concert) for a particular lyric, tab or concert...what is the best way to design the relationship with the comments table? Any ideas?? Thx

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mahesh Chand19y ago
What about having 3 tables from comments for seperate objects? It will give you flexibility of modifying your database later?

If you want to use a single table, you will have to have an additional column with type of the comments for each comment type. Say "g" for guitar and so on.
0