efg-dev - Laravel Schema Designer

league_chats

id increments
timestamps timestamps
league_id ^FK bigInteger
message string
sender_id ^FK bigInteger

league_chat_reads

id increments
timestamps timestamps
league_chats_id ^FK bigInteger
user_id bigInteger
read tinyInteger

users

id increments
timestamps timestamps
name string
email string
password string
username string

conversations

id increments
timestamps timestamps
sender_id ^FK bigInteger
receiver_id ^FK bigInteger

messages

id increments
timestamps timestamps
conversation_id ^FK bigInteger
sender_id ^FK bigInteger
message string
receiver_id ^FK bigInteger
read tinyInteger

leagues

id increments
timestamps timestamps
name string
creator_id ^FK bigInteger

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