I'm thinking about an addressbook database. I would like an opinion on my table layout (I still consider myself a mysql newbie):
table user uid username timestamp
table secret uid secret timestamp
table people pid uid firstname lastname birthday timestamp
table address aid pid address city province country code address_type timestamp
table email eid pid alias string email timestamp
Relationships: users (uid) can have many people (pid) in there contact list. people (pid) can have many addresses (aid). people (pid) can have many email addresses (eid).
Thoughts?
-- Neil Watson | Gentoo Linux Network Administrator | Uptime 12 days http://watson-wilson.ca | 2.4.22-ac1 AMD Athlon(tm) MP 2000+ x 2
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]