houzeo-chat - Laravel Schema Designer

ch_room

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
is_group_chat boolean

ch_room_mappings

id increments
timestamps timestamps
user_id ^FK integer
ch_room_id ^FK integer

ch_messages

id increments
timestamps timestamps
softDeletes softDeletes
is_forwarded boolean
ch_room_id ^FK integer
created_by ^FK integer
body string (5000)
seen boolean

ch_attachments

id increments
timestamps timestamps
softDeletes softDeletes
ch_message_id ^FK integer
file string (250)

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (80)
email string (80)
phone_no string (20)

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