Re: Help with schema

2009-05-06 Thread John M
In addition to Malcolms comments, you'll need a way to track if the agent was fired or not, you could do this in several ways: 1. a date fired field (you may want a date hired), a fired boolean field, or a more complicated way, an archive type setup that moves the fired agents to another table (th

Re: Help with schema

2009-05-05 Thread Malcolm Tredinnick
On Tue, 2009-05-05 at 06:02 -0700, Chris McComas wrote: > I have a site/database that tracks baseball players and their agents. > Players can have multiple agents at one time, they also can fire > agents and hire new ones at anytime, and I'd like to track all of > their agents, current, or previou

Help with schema

2009-05-05 Thread Chris McComas
I have a site/database that tracks baseball players and their agents. Players can have multiple agents at one time, they also can fire agents and hire new ones at anytime, and I'd like to track all of their agents, current, or previous. I was thinking of this schema for my models, but wasn't sure