Design+messaging+database schema

  • messages
    • to_id, to_type   (user or guest)
    • from_id, from_type  (user or guest)
    • message
    • created_at
  • guests
    • ip_address
    • name
  • friends
    • friend1_id  (user) 
    • friend2_id  (user)