Put it in one table with a status field-that is the best way to handle this
issue. One field change/update (Status) in one table is easier to make then
moving all the information from one table to another table when a person
changes status! (If there's 2 tables someone would have to append it or
retype/etc- it gets messy really quickly- believe me I inherited a database
with several tables active/inactive/terminated/etc...versus a simple status
code- I converted them all to one table. The original set up was not pretty
with the types of reports/claims that needed to happen... but I digress)
However, you need to always be diligent when running queries (ie: player
list not listing players and prospective players but only actual players).
It becomes habit pretty quickly- and make sure you leave good documentation
about it.
-----Original Message-----
From: Alexander Aguilar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 12:41 PM
To: CF-Talk
Subject: OT: database modeling
I'm working on an amateur sport team's website and they of course want to
keep track of their player information. On their website they want a
contact/membership form for prospective players. Now the data that is
stored for a Player and a Prospect is very similar (personal info [height,
weight, age], contact info and prowess [batting style, specialty,
experience,etc]. A prospect is not a member of the team until approved by
the team.
Initially, I was leaning toward building a Prospects table but as I
mentioned the fields are basically the same as the Player table. Now I'm
thinking I should put prospect data directly into the Player table but
differentiate it by using a "status" column which would one of the three
following values (active | inactive | prospect). My question is which is
the better way to handle Prospects (ie, separate Prospect table or use
Player table with status field) ?
thanks,
alex
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
