[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