clinics - Laravel Schema Designer

admins

id increments
timestamps timestamps
name string (191)
email string (191)
phone string (191)
password string (191)
is_active tinyInteger

about_us

id increments
timestamps timestamps
title string (191)
description text
image string (191)

banners

id increments
timestamps timestamps
image string (191)

patients

id increments
timestamps timestamps
name string (191)
email string (191)
phone string (191)
avatar string (191)
birthday string (191)
gender tinyInteger
device_token string (191)
password string (191)
is_active tinyInteger

branches

id increments
timestamps timestamps
name string (191)
address string (191)
longitude string (191)
latitude string (191)
timing_from string (191)
timing_to string (191)
image string (191)
city_id ^FK integer
clinic_id ^FK integer
logo string (191)
fb_link string (191)
snapchat_link string (191)
instagram_link string (191)
twitter_link string (191)

cities

id increments
timestamps timestamps
name string (191)

facilities

id increments
timestamps timestamps
name string (191)
branch_id ^FK integer

offers

id increments
timestamps timestamps
title string (191)
content text
image string (191)
price double
branch_id ^FK integer
start_date date
end_date date

offer_items

id increments
timestamps timestamps
offer_id ^FK integer
service_id ^FK integer
sub_service ^FK integer

services

id increments
timestamps timestamps
name string (191)
image string (191)
branch_id ^FK integer

sub_services

id increments
timestamps timestamps
name string (191)
price double
service_id ^FK integer

branch_service

id increments
timestamps timestamps
branch_id ^FK integer
service_id ^FK integer

prescriptions

id increments
timestamps timestamps
patient_id ^FK integer
dr_name string (191)
file string (191)
day string (191)

notifications

id increments
timestamps timestamps
title string (191)
content text
patient_id ^FK integer

chats

id increments
timestamps timestamps
patient_id ^FK integer
admin_id ^FK integer

chat_message

id increments
timestamps timestamps
chat_id ^FK integer
patient_id ^FK integer
admin_id ^FK integer
message text

appointments

id increments
timestamps timestamps
branch_id ^FK integer
patient_id ^FK integer
offer_id ^FK integer
service_id ^FK integer
sub_service_id ^FK integer
month string (191)
day date
slot tinyInteger
time string (191)
status enum

clinics

clinic_id increments
timestamps timestamps

patient_notifications

patientNotification_id increments
timestamps timestamps
patient_id ^FK integer
notification_id ^FK integer

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