First draft of member database schema: Please review : LUSENET : 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.


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

Moderation questions? read the FAQ