[thesite] the evolt database

[Daniel J. Cody]

rudy wrote:
>>lemme know if anythings out of place
>>
> 
> NUMBER(10) should be NUMBER(8), both places
> 
> NUMBER for ACTIVE may be better as NUMBER(1)

oky

> 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?

more or less.. i don't think we've ever had anyone reply through the web 
based interface before, and thats why i didnt build in the functionality 
to track replies either. maybe in a future edition :)

.djc.