> Jochem van Dieten wrote:
>>
>> Are bands, dj's and other's really that different that they can't
>> exist in the same table?
>
> Bands are listed in the db with name, image, logo, website, type of
> band, and if they are an active record. Djs are a name, image and if
> they are an active record. Other can be almost anything and is
> mostly a descriptive block (such as the concert tomorrow night). It
> can get very complicated.
ISTM that you can at least get band and DJ together in the following 2
tables:
tblperformers:
intPerfID int(11) unsigned auto_increment
name
image
logo
website
typeID
tblperformertypes:
intPerfTypeID int(11) unsigned auto_increment
type
If you have the types DJ, Rockband, Soulband etc. puttng them together
should be no problem. And if you add the types Concert, Orchestra,
Standup Comedian etc. and a freetext field in the tblperformers table
you should be able to get them all in.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
