wecare - Laravel Schema Designer

admin_users

id increments
name string (255)
email string (255)
password string (255)
phone_number string (255)
role tinyInteger
location string (255)
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

service_category

id increments
name string (255)
description text
image text
is_active tinyInteger
created_by integer
timestamps timestamps
softDeletes softDeletes

job_title

id increments
title string (255)
category_id integer
description string (255)
image text
is_active tinyInteger
created_by integer
timestamps timestamps
softDeletes softDeletes

location

id increments
franchise_id ^FK integer
name text
slug text
is_active text
timestamps timestamps
softDeletes softDeletes

provinces

id increments
name text
slug text
is_active tinyInteger
timestamps timestamps

notification_categories

id increments
name text
slug text
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

client

id increments
company_id ^FK integer
name string (255)
email string (255)
phone_number string (255)
land_phone string (255)
position string (255)
is_active tinyInteger
is_approved tinyInteger
softDeletes softDeletes
timestamps timestamps

staff

id increments
name string (255)
sur_name string (255)
perfect_name string (255)
gender integer
dob date
image text
category_id integer
title_id integer
phone_number string (255)
er_contact_name string (255)
er_contact_relation string (255)
er_contact_phone string (255)
street_name text
street_number text
sub_urban text
state_id integer
pincode string (255)
location_id integer
work_location_id integer
in_work tinyInteger
is_active tinyInteger
is_approved tinyInteger
timestamps timestamps
softDeletes softDeletes

staff_document

id increments
staff_id integer
document text
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

jobs

id increments
company_id integer
title_id integer
category_id integer
location_id integer
instruction longText
ward_unit string (255)
job_date date
start_time time
end_time time
job_type tinyInteger
assigned_to integer
assigned_type tinyInteger
picked_by integer
status integer
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

client_manager

id increments
name string (255)
email string (255)
password string (255)
phone_number string
alt_phone_number string (255)
company_name string
company_logo text
street_number string (255)
street_name string (255)
sub_urban string (255)
location_id integer
state_id integer
franchise_id integer
is_approved tinyInteger
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

job_statuses

id increments
name string (255)
slug string (255)
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

time_sheet

id increments
job_id integer
job_date date
start_time time
end_time time
break_time time
staff_sign text
supervisor_name string (255)
supervisor_surname string (255)
orientation tinyInteger
supervisor_sign text
incident tinyInteger
protocol tinyInteger
incident_notified tinyInteger
timestamps timestamps
softDeletes softDeletes

admin_client

id increments
admin_id integer
client_id integer
content text
is_read tinyInteger
timestamps timestamps
softDeletes softDeletes

admin_staff

id increments
admin_id integer
staff_id integer
content text
is_read tinyInteger
timestamps timestamps
softDeletes softDeletes

staff_otp

id increments
staff_id ^FK integer
otp string (255)
is_active tinyInteger
timestamps timestamps

client_otp

id increments
client_id ^FK integer
otp string (255)
is_active tinyInteger
timestamps timestamps

staff_availability

id increments
staff_id ^FK integer
date date
am tinyInteger
pm integer
nd tinyInteger
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

settings

id increments
panel_name string (255)
panel_mail string (255)
panel_number string
about_us longText
privacy_policy longText
terms_condition longText
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

faq

id increments
ques string (255)
answer longText
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

notifications

id increments
from_staff integer
from_client integer
from_admin integer
to_staff integer
to_client integer
notification_type integer
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

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