sc_db - Laravel Schema Designer

users

id increments
timestamps timestamps
firstname string
lastname string
username string
role_as integer
phone bigInteger
country string
profile_image string
email string
eamil_verified_at string
fcm_token string
password string
c_password string

pictures

id increments
timestamps timestamps
path string
extension string
name string
user_id string

friends

id increments
timestamps timestamps
user_id string
friend_id string

friendRequests

id increments
timestamps timestamps
user_id integer
auth_id integer

posts

id increments
timestamps timestamps
user_id integer
body string
image string

comments

id increments
timestamps timestamps
user_id ^FK integer
post_id ^FK integer
comment_id ^FK integer
comment string

forget_passwords

id increments
timestamps timestamps
email string
code integer

comment_helper

id increments
timestamps timestamps
comment_id ^FK integer
content string
status tinyInteger

user_helper

id increments
timestamps timestamps
user_id ^FK integer
content string
status tinyInteger

post_helper

id increments
timestamps timestamps
post_id ^FK integer
content string
status string

conversations

id increments
timestamps timestamps
user_id ^FK integer
label string
last_messsage_id ^FK integer

messages

id increments
timestamps timestamps
conversation_id string
user_id string
body string
type enum

participants

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

recipients

id increments
timestamps timestamps
user_id ^FK integer
message_id ^FK integer
read_at timestamp

likes

id increments
timestamps timestamps
user_id ^FK integer
post_id ^FK integer

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