469,950 Members | 1,883 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

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 2473
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
By using this site, you agree to our Privacy Policy and Terms of Use.