Displaying 1 result from an estimated 1 matches for "createtheatres".
2009 Feb 21
2
Foreign-key confusion
...developed a script using scRUBYt that scrapes data from a website
and dumps the following four fields into my Shows table:
class CreateShows
create table :shows do |t|
t.string :date
t.string :venue
t.string :info
t.string :comics
The second table I created is called Theatres:
class CreateTheatres
create table :theatres do |t|
t.string :name
t.string :address
t.string :website_url
t.string :location
The :venue field in the Shows table corresponds to the :name field in
the Theatres table. How do I set up a relationship whereby Theatres have
many shows, while defining this (:venue...