First draft of member database schema: Please reviewgreenspun.com : LUSENET : Pinedas.com Development : One Thread |
I have put together an initial schema for the "member" database. Please review it, and tell me if there is other information that we might need.Thanks, epp
member table: - last name - first name - middle name - id - spouse - e-mail address - password - url
contact table: - member id - address line 1 - address line 2 - city - state - zip code - country - telephone - published (flag to determine if this is displayed or not)
-- Anonymous, February 20, 2000
Derek, the database is password protected. You'll see two things: (a) a password in the "member" table and (b) the member can choose to publish or not publish his/her contact information in the "contact" table. A member can provide as little or as much information about himself/herself as he/she wishes.epp
-- Anonymous, February 20, 2000
From the looks of things, it certainly looks like you got everything. Guy
-- Anonymous, February 20, 2000
Everything looks fine.. We should password protect the contact table altough...
-- Anonymous, February 20, 2000