I made a conversations/messages system a while back, and did it like this.
users
id | etc.
conversations
id | title | etc.
users_conversations
user_id | conversation_id
messages
id | user_id | body | etc.
conversations_messages
conversation_id | message_id
Ahh, cheers dude. Yeah, that looks like a good approach. Seems logical. Thanks again.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community