MyBac - Laravel Schema Designer

users

id increments
name string (255)
email string (255)
email_verified_at datetime
password string (255)
roles json
rememberToken rememberToken
softDeletes softDeletes
timestamps timestamps
subscription_id bigInteger

user_providers

id increments
timestamps timestamps
user_id ^FK bigInteger
provider_type enum
provider_hash string
provider_email string
provider_name string
provider_avatar string

courses

id increments
name string
description text
objective text
authors json
tags json
image string
campaigns json
timestamps timestamps
softDeletes softDeletes

campaigns

id increments
name string
missions json
rewards json
timestamps timestamps
softDeletes softDeletes

missions

id increments
user_id ^FK bigInteger
name string
description text
objective text
image string
tags json
dificulty integer
practice_blocks json
challenge_blocks json
rewards json
timestamps timestamps
softDeletes softDeletes

blocks

id increments
type enum
tags json
content json
difficulty integer
timestamps timestamps
softDeletes softDeletes
practice boolean

metrics

id increments
timestamp timestamp
name string
user_id ^FK bigInteger
mission_id ^FK bigInteger
content json

stickers

id increments
name string
description string
image string
precent integer
hidden boolean
timestamps timestamps
user_id ^FK bigInteger

roles

slug string
name string
permissions json
timestamps timestamps

user_global_stats

id increments
user_id ^FK bigInteger
experience integer
rank string
coins integer
battles_won integer
campaigns_completed integer
missions_completed integer
timestamps timestamps

user_mission_results

id increments
user_id ^FK bigInteger
mission_id ^FK bigInteger
timestamps timestamps
correct integer
mistakes integer
time_spent integer

user_courses

id increments
user_id ^FK bigInteger
course_id ^FK bigInteger
missions_total integer
missions_completed integer
last_played timestamp
timestamps timestamps
softDeletes softDeletes

subscriptions

id increments
timestamps timestamps

quests

id increments
timestamp timestamp
user_id ^FK bigInteger
type enum
value integer
content json
total integer

videos

id increments
timestamps timestamps
softDeletes softDeletes
name string
url string

tags

slug string
label string
icon string

rewards

id increments
timestamps timestamps
target_type enum
target_id bigInteger
coins integer
experience_points integer

user_course_stats

id increments
timestamps timestamps
course_id ^FK bigInteger
user_id ^FK bigInteger

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