Hi,
I am a newbie to ROR and ActiveScaffold, below please find my DB
schema and the issue that I am seeing with relationship
Table Userviews
userview_id (Prim Key)
drama_id - belongs to table Drama
venue_id - belongs to table Venue
Table Dramas (has many showtimes)
drama_id (Prim Key)
drama_name
.
.
.
Table Venues (has many showtimes)
venue_id (Prim Key)
venue_name
.
.
.
Table Showtimes
show_id (Prim Key)
show_date
drama_id
drama_id - belongs to table Drama
venue_id - belongs to table Venue
The link between Drama & Showtime, Venue & Showtime, Userview & Venue,
Userview & Drama are working fine. The userview table is the one which
define which showtimes can be accessed by a user.
I am having trouble defining the relationship between Userviews &
Showtimes - can anyone check this and let me know how should these two
models be linked such that I can add a nested link from Userview
record to Showtimes based on the drama_id and venue_id for each
record.
Thanks
Ram