[thesite] the evolt database

rudy r937 at interlog.com
Mon Aug 27 17:08:44 CDT 2001


>lemme know if anythings out of place

NUMBER(10) should be NUMBER(8), both places

NUMBER for ACTIVE may be better as NUMBER(1)

in the original design, there was a one-to-many relationship between
CONTACT and RESPONSE, but this current design looks like there will only be
one response possible per contact

i'm not saying that's wrong, just an observation

for example, if the contacted party then replies, it would be an actual
email, right?  so it would be outside this system?  or else, if the person
replied via the web form, it would be a new contact row, right?  is that
the rationale?

as for starting from scratch, dude, if you are going to do that, then put
your LONG field last

rudy





More information about the thesite mailing list