studyApp - Laravel Schema Designer

users

id increments
timestamps timestamps

groups

id increments
timestamps timestamps
owner_id ^FK bigInteger
name string
category_id ^FK bigInteger
code string
bio text
weeklytimegoal integer
type enum
goal_id ^FK bigInteger
duration integer
is_online boolean

feeds

id increments
timestamps timestamps
user_id ^FK bigInteger
content longText
shares_count integer
likes_count integer
comments_count integer

feed_media

id increments
timestamps timestamps
feed_id ^FK bigInteger
media string
type enum

feed_likes

id increments
timestamps timestamps
user_id ^FK bigInteger
likeable_id bigInteger
likeable_type string

comment_feeds

id increments
timestamps timestamps
user_id ^FK bigInteger
comment text
commenteable_id bigInteger
commenteable_type string
parent_comment_id ^FK bigInteger

goals

id increments
timestamps timestamps
name string
user_id ^FK bigInteger
duration integer
type enum

categories

id increments
timestamps timestamps
name string
icon string

followers

id increments
timestamps timestamps
follower_id ^FK bigInteger
following_id ^FK bigInteger

focus_sessions

id increments
timestamps timestamps
feature_id ^FK bigInteger
user_id ^FK bigInteger
duration integer
start_time datetime
end_time datetime
completed boolean
notes text
pomodoro_type enum
multitasking_events_mode boolean
is_reminder boolean
goal_id ^FK bigInteger
group_id ^FK bigInteger
is_pomodoro tinyInteger

focus_session_events

id increments
timestamps timestamps
focus_session_id ^FK bigInteger
event_type enum
details text
event_time timestamp

features

id increments
timestamps timestamps
name string
desciption text

group_users

id increments
timestamps timestamps
user_id ^FK bigInteger
group_id ^FK bigInteger

wisdoms

id increments
timestamps timestamps
title text
owner string

reminders

id increments
timestamps timestamps
focus_session_id ^FK bigInteger
reminder_type enum

shares

id increments
timestamps timestamps
shared_feed_id ^FK bigInteger
sharing_user_id ^FK bigInteger
content text
shares_count integer
likes_count integer
comments_count integer

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