[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cgiapp] Before I go off into a codestorm... [Mini-CRM Question]


On Thu, 19 May 2005, Jason Purdy wrote:

> So you'd recommend just widening the table, then?  

Possibly.  I don't really know very much about what your boss is
asking for.  If he's really just asking for new scalar properties that
which will be used by all (or most) people then I'd add them to the
people table.

If there's something more complex going on then I'd look for ways to
break out separate tables.  For example, if some people are affiliates
and affiliates have extra data associated with them then I'd add an
affilliate_info table linked to people via a foreign key.

-sam

---------------------------------------------------------------------
Web Archive:  http://www.mail-archive.com/suppressed/
              http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: suppressed
For additional commands, e-mail: suppressed


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.