472,145 Members | 1,406 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

multiple parents confusion

Hi I'm making a nightlife listings system.

I have a table that stores listings, the type of listing can be either
an event at a night-club event, at a gig or at a bar. So i could just
assign a number to define the type.

But, the listing needs to have a parent of either club, gig or bar.
What's the best way to handle this?

At the moment there are 3 FK-fields that if not set to zero contain the
id of either club bar or gig. It somehow doesn't seem right.
Any ideas?

Cheers TWIOF

Sep 4 '06 #1
1 2534
Also, i could make a seperate listings table for each type (bar, club,
gig) but if added a new type I'd have to create a new table each time,
doesn't seem right either.

Sep 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Abbey Krystowiak | last post: by
reply views Thread by Hananiel | last post: by
29 posts views Thread by MAHESH MANDHARE | last post: by
47 posts views Thread by Mark | last post: by
3 posts views Thread by Andrew Meador | last post: by
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.