eceing3projetinfo - Laravel Schema Designer

users

user_id increments
name string
surname string
username string
email string
password string
role enum
birth_date datetime
title string
cv_url string
photo_id ^FK bigInteger
cover_id ^FK bigInteger
timestamps timestamps

posts

post_id bigInteger
author_id ^FK bigInteger
event_id ^FK bigInteger
type enum
location string
mood enum
image_url string
video_url string
visibility enum
timestamps timestamps

events

event_id bigInteger
author_id ^FK bigInteger
date datetime
name string
description string
location string
timestamps timestamps

comments

comment_id bigInteger
post_id ^FK bigInteger
author_id ^FK bigInteger
text text
timestamps timestamps

conversations

conversation_id bigInteger
message_id ^FK bigInteger

conversation_members

conversation_id ^FK bigInteger
user_id ^FK bigInteger

messages

message_id bigInteger
author_id ^FK bigInteger
type enum
content text
timestamps timestamps

notifications

notification_id bigInteger
user_id ^FK bigInteger
type enum
read boolean
reaction_id bigInteger
comment_id ^FK bigInteger
friend_request_id bigInteger
timestamps timestamps

entities

entity_id increments
author_id ^FK bigInteger
name string
location string
photo_url string
description string

friendships

friend1_id ^FK bigInteger
friend2_id ^FK bigInteger
timestamps timestamps

friend_requests

requester_id ^FK bigInteger
invited_id ^FK bigInteger
timestamps timestamps

job_offers

job_id bigInteger
author_id ^FK bigInteger
entity_id ^FK bigInteger
position string
description longText
timestamps timestamps

reactions

reaction_id bigInteger
post_id ^FK bigInteger
comment_id ^FK bigInteger
author_id ^FK bigInteger
type enum
timestamps timestamps

post_visibilities

post_id ^FK bigInteger
user_id ^FK bigInteger

sub_posts

parent_post_id ^FK bigInteger
child_post_id ^FK bigInteger

networks

user1_id ^FK integer
user2_id ^FK integer
timestamps timestamps

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