db design - saving lists
Posted: Tue Mar 13, 2007 9:24 pm
I have a system with three tables: shows, schedule, and channel. Shows are inserted into the schedule and assigned to a channel, so the relevant columns are something like:
shows:
id
name
channel_id
channels
id
name
schedule
id
show_id
start_time
end_time
Now, the user is able to build (via javascript) a block of shows and either insert it into the schedule, or insert it into the schedule at a later time. How would you recommend saving these lists? They need to be named (ie: "Sunday Line-up"). I was thinking of something like:
lists
show_id
list_name (this would be the primary key)
order
but that to me just feels wrong for some reason. What do you think?
shows:
id
name
channel_id
channels
id
name
schedule
id
show_id
start_time
end_time
Now, the user is able to build (via javascript) a block of shows and either insert it into the schedule, or insert it into the schedule at a later time. How would you recommend saving these lists? They need to be named (ie: "Sunday Line-up"). I was thinking of something like:
lists
show_id
list_name (this would be the primary key)
order
but that to me just feels wrong for some reason. What do you think?