search

t2t2 / draft

MOVIES MOVIES MOVIES!
http://boxofficedraft.com/
MIT License
18 stars 8 forks source link

Box office earnings #10

Closed TheAntonioReyes closed 11 years ago

TheAntonioReyes commented 11 years ago

Maybe I'm missing something but shouldn't the movies table also have a column for current box office earnings?

t2t2 commented 11 years ago

I haven't made it yet cause it's not super-duper-need-it-now-or-why-the-heck-am-I-doing-this-anyway until first move comes out (April 19th). Priorities FTW! As for the implementation I think it should be a separate table (movie_earnings?) with movie_id, date and total_earnings so historical data (and fancy graphs!) would be also available

TheAntonioReyes commented 11 years ago

Gotcha, I'm used to using journal tables. So basically when you update the movies table it would create a new row in a journal table with the value before you change it. It keeps the tables smaller but then you need to deal with sparse data.