All notes
ExampleMessagingSystem

Messaging System Database Design

9lessons.info.

Users:
  uid, INT(11)
  email, VARCHAR(60)
  pwd, VARCHAR(30)

Conversaions:
  uid, INT(11)
  from, INT(11), FK(Users.uid)
  to, INT(11), FK(Users.uid)
  ip, VARCHAR(30)
  time, INT(11)
  status, INT(11)

Messages:
  uid, INT(11)
  content, TEXT
  user_fk
  ip
  time
  status