similar to: Strange Database Mapping Question

I have the following two tables: create table teams ( id int not null auto_increment, short_name varchar(12) not null, long_name varchar(50) not null, logo varchar(20) not null, primary key (id) ); create table rounds ( id int not null auto_increment, home_team_id int not null, away_team_id int

I have a model, Game, that has_many :teams. There''s a home team and an away team. I created two foreign keys, so each game can have two teams associated with it. Here''s the Team model: class Team < ActiveRecord::Base belongs_to :game, :class_name => ''Game'', :foreign_key => ''hometeam_id'' belongs_to :game, :class_name =>

Hi everyone! I have a problem with defining 2 fk referencing the same table. I have a Program table and a Team table. The Program should have an away team and a home team fk. From my understanding, "the fk column should be named after the class of the target table, converted to lowercase, with _id appended". But, in my case, I have 2 fk referencing the same table. How can I do this?

I have the following tables teams id :string name :string and matches id: home_team :team_id visitor_team :team_id how can I reflect that kind of relationship in a RoR model? thanks and keep up the good work.

Really stupid question, but have you wrapped this all in an App class? If you don''t have a wxApp subclass driving your applications then all sorts of badness would happen. > I''m writing a custom little application for my boss''s high school > football team to track there stats play by play. > > My problem is that when I start the application, it

Hi. I''ve got a file that contains a table that looks like this: <table> <tr><td>column title a</td><td>column title b</td></tr> <tr><td>row 1 a</td><td>row 1 b</td></tr> <tr><td>row 2 a</td><td>row 2 b</td></tr> <tr><td>row 3 a</td><td>row 3

I''ve created a table in a SQL Server database using a migration, successfully. I''ve tried to change the name of a column in the table and got the error message above when running ''rake db:migrate''. Previously I have developed using MySQL and Sqlite and migrations have worked successfully. This is an error I have not seen before. Has anybody seen this and worked

I tried to get Samba running on my new Trustix installation all day yesterday with no luck. I'm a newbie, so there's a lot I don't know yet. At any rate, I have the Smb, nmbd, and smbd services running. I've got my smb.conf file set up properly from what I can tell. When I try the following command on my Linux box: smbclient //192.168.1.102/backup -U jesse I get the error,