learnstock - Laravel Schema Designer

roles

id increments
title string (125)
slug string (125)
timestamps timestamps

permissions

id increments
title string (125)
slug string (256)
timestamps timestamps

role_permission

id increments
role_id ^FK integer
permission_id ^FK integer

admin_users

id increments
name string (125)
email string (125)
password string (256)
phone string (125)
role_id ^FK integer
status integer
remember_token string (256)
reset_key text
reset_time datetime
timestamps timestamps
softDeletes softDeletes

users

id increments
name string (256)
email string (256)
mobile string (125)
photo string (256)
location string (256)
latitude string (125)
longitude string (125)
status integer
timestamps timestamps
softDeletes softDeletes

user_otp

id increments
user_id ^FK integer
otp integer
status integer
timestamps timestamps

trending

id increments
title string (125)
type integer
media string (256)
status integer
timestamps timestamps
softDeletes softDeletes
description text

top_videos

id increments
title string (256)
tagline string (125)
video string (256)
status integer
timestamps timestamps

banners

id increments
title string (256)
image string (256)
status integer
timestamps timestamps

simply_simplified

id increments
category_id ^FK integer
title string (256)
tagline string (125)
thumbnail string (256)
video string (256)
is_featured integer
status integer
timestamps timestamps
softDeletes softDeletes

bmt

id increments
title string (256)
tagline string (256)
thumbnail string (256)
video string (256)
is_featured integer
status integer
timestamps timestamps
softDeletes softDeletes

ias_me_graduate

id increments
category_id ^FK integer
title string (256)
tagline string (256)
thumbnail string (256)
video string (256)
is_featured integer
status integer
timestamps timestamps
softDeletes softDeletes

ias_me_school

id increments
category_id ^FK integer
sub_category string (125)
title string (256)
tagline string (125)
thumbnail string (256)
video string (256)
is_featured integer
status integer
timestamps timestamps
softDeletes softDeletes

mains_gear_basic

id increments
title string (256)
tagline string (256)
thumbnail string (256)
video string (256)
is_featured integer
status integer
timestamps timestamps
softDeletes softDeletes

mains_gear_advanced

id increments
title string (256)
tagline string (256)
topics string (256)
questions string (256)
status integer
timestamps timestamps
softDeletes softDeletes

mains_gear_advanced_solution

id increments
mains_gear_advanced_id ^FK integer
title string (256)
tagline string (256)
thumbnail string (256)
video string (256)
timestamps timestamps

testpresso

id increments
category_id ^FK integer
question string (256)
weightage integer
answer_key text
reference string (256)
status integer
timestamps timestamps
softDeletes softDeletes

testpresso_options

id increments
testpresso_id ^FK integer
option string (256)
is_answer integer
timestamps timestamps

user_test_results

id increments
user_id ^FK integer
test_id ^FK integer
is_correct integer
timestamps timestamps

user_devices

id increments
user_id ^FK integer
device_id string (256)
device_type integer
session_id string (256)
is_logout integer
login_time datetime
logout_time datetime
timestamps timestamps

user_video_log

id increments
user_id ^FK integer
video_id integer
type integer
time string (125)
timestamps timestamps

settings

id increments
title string (256)
slug string (256)
description text
type integer
timestamps timestamps

notifications

id increments
user_id ^FK integer
type integer
title string (256)
image string (256)
description text
is_view integer
timestamps timestamps

pages

id increments
title string (256)
slug string (256)
image string (256)
description text
timestamps timestamps

plans

id increments
title string (256)
amount string (125)
description text
validity string (125)
parent_id integer
timestamps timestamps
softDeletes softDeletes

plan_varients

id increments
plan_id ^FK integer
varient integer
category_id integer
timestamps timestamps

user_plan

id increments
user_id ^FK integer
plan_id ^FK integer
is_active integer
purchased_on datetime
activated_on datetime
expire_on datetime
timestamps timestamps

user_feature_availables

id increments
user_id ^FK integer
plan_id ^FK integer
user_plan_id ^FK integer
varient integer
category_id integer
timestamps timestamps

faq

id increments
question string (256)
answer text
timestamps timestamps

simply_simplified_category

id increments
title string (256)
description text
timestamps timestamps

ias_me_graduate_category

id increments
title string (256)
description text
timestamps timestamps

ias_me_school_category

id increments
title string (256)
description text
timestamps timestamps

testpresso_category

id increments
title string (256)
description text
timestamps timestamps

free_videos

id increments
varient integer
title string (256)
tagline string (256)
thumbnail string (256)
video string (256)
status integer
timestamps timestamps
softDeletes softDeletes

e_waste_center

id increments
title string (256)
description text
state string (125)
district string (125)
mobile string (125)
email string (125)
open_hour string (125)
latitude string (125)
longitude string (125)
timestamps timestamps