ybdl - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (250)
email string (250)
password string (250)
confirmation_code string (250)
mobile bigInteger
role_id integer
confirmed tinyInteger
remember_token string (100)
status tinyInteger

member

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
name string (250)
gender tinyInteger
country integer
address text
city integer
state integer
pincode integer

subscriptionplan

id increments
timestamps timestamps
title string (250)
duration integer
price float
description text

nutritionist

id increments
timestamps timestamps
softDeletes softDeletes
fname string (250)
lname string (250)
selfintro text
designation string (250)
user_id ^FK integer

subscription

id increments
timestamps timestamps
user_id ^FK integer
subscriptionplan_id ^FK integer
duration integer
price float
start_date date
end_date date
paymentstatus string (100)
paymentmethod integer
paymentrefnotes text

roles

id increments
timestamps timestamps
name string (100)
all tinyInteger
sort tinyInteger
description text
status tinyInteger

messages

id increments
timestamps timestamps
nutritionist_id ^FK integer
member_id ^FK integer
conversationdatetime timestamp
message text

assaigned_roles

id increments
timestamps timestamps
user_id ^FK integer
role_id ^FK integer

question_options

id increments
timestamps timestamps
name string (250)
qid ^FK integer
flag integer
ans_code integer
status tinyInteger

question

id increments
timestamps timestamps
softDeletes softDeletes
name string (250)
qcode string (100)
module_type_id integer
help_text string (250)
subquestion integer
skip integer
status tinyInteger
validation string (250)
answer_type integer

answer

id increments
timestamps timestamps
qid ^FK integer
ans_code integer
answer text
status integer
member_id ^FK integer
nutrition_id ^FK integer

subscription_history

id increments
timestamps timestamps
softDeletes softDeletes
member_id ^FK integer
subscriptionplan_id ^FK integer

permissions

id increments
timestamps timestamps
softDeletes softDeletes
name string (250)
display_name string (250)
system integer
sort tinyInteger

permission_role

id increments
timestamps timestamps
permission_id ^FK integer
role_id ^FK integer

notes

id increments
timestamps timestamps
softDeletes softDeletes
nutritionist_id ^FK integer
member_id ^FK integer
notes text

dreamplans

id increments
timestamps timestamps
softDeletes softDeletes
nutritionist_id ^FK integer
member_id ^FK integer
uploaddocument text

member_nutritionist

id increments
timestamps timestamps
softDeletes softDeletes
member_id ^FK integer
nutritionist_id ^FK integer

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