Thinking ahead to use in a web application, I find it useful for audit purposes to maintain a field that reports the date/time of last update plus the client IP address fm which updated. Can aid in investigating abuse/break-in.
Mike, the per-person information doesn't include email address. (But that's such a glaring hole that I expect there'll be some reason for its absence.)
FYI, I created the database on my test system in order to see what fred - the generic db utility I tossed together - wd do to/with it. Flameout: Simple-minded ol' fred assumes/requires that the single key for each table is `id`, and he couldn't take yr actual keys - as well as the foreign keys, of course. (I tried inserting id, but MySQL allows only a single auto-incr key per table. Sighhhhhh!)
But there ARE other generic table processors and code-generators out there. Possibly worth investigating as a next step in the app'n development process.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
On both the site and the database design.
Now after a bit of looking and playing:
Thinking ahead to use in a web application, I find it useful for audit purposes to maintain a field that reports the date/time of last update plus the client IP address fm which updated. Can aid in investigating abuse/break-in.
Mike, the per-person information doesn't include email address. (But that's such a glaring hole that I expect there'll be some reason for its absence.)
FYI, I created the database on my test system in order to see what fred - the generic db utility I tossed together - wd do to/with it. Flameout: Simple-minded ol' fred assumes/requires that the single key for each table is `id`, and he couldn't take yr actual keys - as well as the foreign keys, of course. (I tried inserting id, but MySQL allows only a single auto-incr key per table. Sighhhhhh!)
But there ARE other generic table processors and code-generators out there. Possibly worth investigating as a next step in the app'n development process.