manorama - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (30)
age integer
email string (30)
sex string (20)
mobile string (30)
address string (30)
district string (20)
state string (20)
country string (20)
password string (500)
image string (500)
E-medal_status smallInteger
description string (30)
status smallInteger
otp string (500)
otpSendTime datetime
otpFlag integer
otp_Status integer

events

id increments
timestamps timestamps
name string (30)
slug string (30)
status tinyInteger
image string (500)

categories

id increments
timestamps timestamps
name string (30)
slug string (30)
status tinyInteger
event_id ^FK integer
amount string (500)

banners

id increments
timestamps timestamps
image string (500)
title string (30)
slug string (30)
status integer
button_text string (500)
button_link string (500)

user_purchase

id increments
timestamps timestamps
user_id ^FK bigInteger
event_id ^FK bigInteger
category_id ^FK bigInteger
payment_status enum

admin_user

id increments
timestamps timestamps
name string (30)
email string (500)
mobile string (30)
password string (500)
status smallInteger
role_id ^FK bigInteger

user_activity

id increments
timestamps timestamps
user_id ^FK bigInteger
covered_dist string (30)
activity_image string (500)
category_id ^FK integer
start_time timestamp
end_time timestamp
is_verified tinyInteger
e_medal string (500)
start_time_phto string (500)
end_time_photo string (500)
finisher_photo string (500)

cms_pages

id increments
timestamps timestamps
title string (500)
sub_title string (500)
slug string (500)
image string (500)
content text
status integer

youtube_videos

timestamps timestamps
id increments
link string (500)
status tinyInteger
date_of_publishing timestamps

payment_report

id increments
timestamps timestamps
user_id ^FK integer
purchase_id ^FK integer
category_id ^FK integer
status tinyInteger
purchase_date date

system_settings

id increments
timestamps timestamps
brochure string (500)
status tinyInteger
metatags string (500)
enquiry_email string (500)
phone integer
site_title string (500)
site_description text
copyright string (500)
e_medal string (500)

all_notifications

id increments
timestamps timestamps
name string (500)

notifications

id increments
timestamps timestamps
notification_id ^FK integer
user_id ^FK integer
purchase_id ^FK integer
status tinyInteger

Faq

id increments
timestamps timestamps
question string (50)
answer string (50)
status tinyInteger

Finished_photos

id increments
timestamps timestamps
user_id integer
image string (500)
status tinyInteger

roles

id increments
timestamps timestamps
name string (500)
description string (500)

permissions

id increments
timestamps timestamps
title string (500)
slug string (500)
description string (500)

role_has_permissions

id increments
timestamps timestamps
role_id ^FK bigInteger
perm_id ^FK bigInteger

razorpay_request_parent

id increments
timestamps timestamps
order_id integer
parent json

razorpay_response_parent

id increments
timestamps timestamps
order_response_id ^FK bigInteger
parent json

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