Turns out this is intended and this dev db is called a 'live dev'. We then have a 'dev dev' for playing with (I've only been here a day... no...

One thing I see as a potential problem is that logically you could have an 'ActorReview' and a 'ProductionReview' that share the same ReviewId which is not desired. In fact...

Yeh, this is almost exactly as I have it (with the exception of the review tables).

I don't see the advantage of having all those review type tables with exactly...

Ok thanks. You would not need an extra relation table for a many reviews to one show relationship though, it is not a many to many. With this approach you...

Agreed. So would you go with the first option or are you saying you would scrap the 'generic' review table altogether?

I like the first option as it enables you easily...