whatsappDB - Laravel Schema Designer

users

id increments
name string (255)
phone string (11)
token string (255)
is_active boolean
timestamps timestamps

messages

id increments
media_id ^FK integer
sender_id ^FK integer
reciepient_id ^FK integer
chat_id integer
body longText
status tinyInteger
is_deleted boolean
timestamps timestamps

profiles

id increments
media_id ^FK integer
user_id integer
username string (211)
timestamps timestamps

user_statuses

id increments
media_id ^FK integer
text_body longText
exipry_status boolean
timestamps timestamps
user_id ^FK integer

media

id increments
media_url string (211)
media_type string (50)
timestamps timestamps

devices

id increments
user_id ^FK integer
device_name string (211)
device_id string (211)
status boolean
is_active boolean
timestamps timestamps

chats

id increments
user_id ^FK integer
chat_session string (211)
timestamps timestamps

groups

id increments
media_id ^FK integer
user_id ^FK integer
chat_id ^FK integer
group_name string (11)
timestamps timestamps

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