Marrina Application - Laravel Schema Designer

branches

id increments
timestamps timestamps
softDeletes softDeletes
Name string (255)
working_from datetime
working_to datetime
lat string (255)
long string (255)

rooms

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
branch_id ^FK integer

doctors

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
image string (255)
password string (255)
phone string (255)
email string (255)

room_services

id increments
timestamps timestamps
softDeletes softDeletes
service_id ^FK integer
room_id ^FK integer

doctor_branches

id increments
timestamps timestamps
softDeletes softDeletes
doctor_id ^FK integer
branch_id ^FK integer

service_categories

id increments
timestamps timestamps
name string (255)

services

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
service_category_id ^FK integer
price_from decimal (8,2)
duration datetime
price_to decimal (8,2)

products

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
description longText
image string (255)
product_price string (255)
service_price string (255)

branch_products_stock

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK integer
branch_id ^FK integer
amount string (255)
unit_id ^FK integer

units

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
parent_id integer

unit_product_amount

id increments
timestamps timestamps
softDeletes softDeletes
unit_id ^FK integer
amount integer

faqs

id increments
timestamps timestamps
softDeletes softDeletes
model_type string (255)
model_id integer
name string (255)
description longText

purchases

id increments
timestamps timestamps
softDeletes softDeletes
code integer
note longText
supplier_id ^FK integer
total float

suppliers

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
phone string (255)
notes longText

purchase_products

id increments
timestamps timestamps
purchase_id ^FK integer
product_name string (255)
quantity string (255)

promo_codes

id increments
timestamps timestamps
expire_date datetime
limit integer
active boolean
discount float

tag

id increments
timestamps timestamps
softDeletes softDeletes
tag string (255)

tag_services

id increments
timestamps timestamps
tag_id ^FK integer
service_id ^FK integer

rates

id increments
timestamps timestamps
rate float
comment longText
user_id integer
model_id integer
model_type string (255)

favorites

id increments
timestamps timestamps
user_id integer
model_id integer
model_type string (255)

complaints

id increments
timestamps timestamps
name string (255)
email string (255)
phone string (255)
note longText

notifications

id increments
timestamps timestamps
user_id integer
link string (255)
content longText
model_id integer
model_type string (255)

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
email string (255)
password string (255)
phone string (255)
image string (255)
active boolean
latt string (255)
long string (255)
type enum

user_information

id increments
timestamps timestamps
user_id ^FK integer
option string (255)
value string (255)

doctor_schedules

id increments
timestamps timestamps
softDeletes softDeletes
created_by ^FK integer
doctor_id ^FK integer
branch_id ^FK integer
day string (255)
active boolean

doctor_time_slots

id increments
timestamps timestamps
doctor_working_hour_id ^FK integer
from datetime
to datetime

reservations

id increments
timestamps timestamps
softDeletes softDeletes
branch_id ^FK integer
room_id ^FK integer
doctor_id ^FK integer
patient_id ^FK integer
promo_code_id ^FK integer
status enum
total float
discount float
discount_type string (255)
discount_amount decimal (8,2)

invoices

id increments
timestamps timestamps
softDeletes softDeletes
reservation_id ^FK integer
total float (8,2)
promo_code integer
discount float (8,2)
discount_type string (255)

transactions

id increments
timestamps timestamps

reservation_services

id increments
timestamps timestamps
service_id ^FK integer
reservation_id ^FK integer
net_price decimal (8,2)

medications

id increments
timestamps timestamps
reservation_id ^FK integer
user_id ^FK integer
medication_name string (255)
dose integer
note longText
start_date date
end_date datetime

medication_dates

id increments
timestamps timestamps
softDeletes softDeletes
medication_id ^FK integer
date time

reservation_products

id increments
timestamps timestamps
product_id ^FK integer
reservation_id ^FK integer
quantity integer
price decimal (8,2)
total_price decimal (8,2)

invoice_items

id increments
timestamps timestamps
invoice_id ^FK integer
model_id integer
model_type string (255)
price float (8,2)

treatment_plans

id increments
timestamps timestamps
name string (255)
user_id ^FK integer
doctor_id ^FK integer
reservation_id ^FK integer

treatment_plan_services

id increments
timestamps timestamps
service_id ^FK integer
treatment_plan_id ^FK integer
status enum