chats - Laravel Schema Designer

users

id increments
image string
name string (255)
email string
password string
timestamps timestamps

chat_groups

id increments
name string
description string
timestamps timestamps

chat_group_members

id increments
group_id ^FK integer
user_id ^FK integer
role enum
timestamps timestamps

chat_messages

id increments
parent_id ^FK integer
receiver_id ^FK integer
sender_id ^FK integer
content_type enum
content string
timestamps timestamps

chat_group_messages

id increments
chat_group_id ^FK integer
parent_id ^FK integer
sender_id ^FK integer
content_type enum
content string
softDeletes softDeletes
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01