TalkPHP - View Single Post

tony · 09-20-2009, 08:41 PM

It seems like a hierarchy structure, although season doesn't have a lot of data to put on it from the looks of it, so I will go with a 1-to-many relationship between shows > episodes and just make season a field to episodes. Something like this:

Code:

-shows
--show_id
--name
--description

-episodes
--episode_id
--show_idfk
--name
--season
--description
--more fields, etc..

the show_idfk field in the table episodes would help to make the relationship with the shows table (fk stands for foreign key).

09-20-2009, 08:41 PM	#4 (permalink)
tony The Addict Join Date: Aug 2008 Posts: 336 Thanks: 8	It seems like a hierarchy structure, although season doesn't have a lot of data to put on it from the looks of it, so I will go with a 1-to-many relationship between shows > episodes and just make season a field to episodes. Something like this: Code: -shows --show_id --name --description -episodes --episode_id --show_idfk --name --season --description --more fields, etc.. the show_idfk field in the table episodes would help to make the relationship with the shows table (fk stands for foreign key).