Willo-Patient - Laravel Schema Designer

patients

id increments
name string (255)
gender tinyInteger
d_o_b date
email string (255)
password string (255)
latitude decimal (10,8)
longitude decimal (10,8)
pin_code string (255)
google_id char (255)
fb_id char (255)
email_verified_at string (255)
terms tinyInteger
country_id bigInteger
softDeletes softDeletes
timestamps timestamps

categories

id increments
name enum
softDeletes softDeletes
timestamps timestamps

doctors

id increments
lang string (255)
name string (255)
phone string (255)
email string (255)
password string (255)
trem tinyInteger
status enum
latitude string (255)
longitude string (255)
location text
fb_id bigInteger
google_id bigInteger
apple_id bigInteger
pin_code integer
about text
full_perfessional_title string (255)
d_o_b date
softDeletes softDeletes
timestamps timestamps
year_experience integer
viewers bigInteger

rattings

id increments
stars enum
doctor_id ^FK bigInteger
patient_id ^FK bigInteger
comment text
timestamps timestamps

settings

id increments
api_key_map string (255)
timestamps timestamps

bookings

id increments
doctor_id ^FK bigInteger
patient_id ^FK bigInteger
content text
type enum
clinic_id bigInteger
date date
time time
patient_name string (255)
longitude decimal (10,8)
latitude decimal (10,8)
location text
status enum
booking_type_id ^FK bigInteger
softDeletes softDeletes
timestamps timestamps
shift_id ^FK bigInteger
is_review tinyInteger
next_review tinyInteger
review_date date

payments

id increments
credit_card_number integer
card_holder_name integer
expiry_date date
cvv_code integer
doctor_id ^FK bigInteger
patient_id ^FK bigInteger
payment_method_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

notifications

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
content text
read_at datetime
is_read tinyInteger

offerables

id increments
offerable_type string
offerable_id bigInteger
offer_id bigInteger
softDeletes softDeletes
timestamps timestamps

offers

id increments
promo_code string (255)
views integer
expiry_date date
patient_count integer
timestamps timestamps

countries

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string (255)
name_en string (255)
name_ro string (255)
image string (255)

specialties

id increments
name_ar string (255)
name_en string (255)
name_ro string (255)
image string
timestamps timestamps
softDeletes softDeletes

doctor_specialty

id increments
timestamps timestamps
softDeletes softDeletes
doctor_id ^FK bigInteger
specialty_id ^FK bigInteger

lisences

id increments
timestamps timestamps
softDeletes softDeletes
image string (255)
doctor_id ^FK bigInteger

working_hour_settings

id increments
hour integer
sentence_en string (255)
timestamps timestamps
softDeletes softDeletes
shift_id ^FK bigInteger
sentence_ar string (255)
sentence_ro string (255)

payment_methods

id increments
timestamps timestamps
name_ar string (255)
name_ro string (255)
name_en string (255)
type enum

places

id increments
timestamps timestamps
phone string (255)
latitude decimal (10,8)
longitude decimal (10,8)
cost float
location string (255)
duration time
doctor_id ^FK bigInteger

place_types

id increments
timestamps timestamps
name_ar string (255)
name_ro string (255)
name_en string (255)
place_id ^FK bigInteger

place_images

id increments
timestamps timestamps
name string
place_id ^FK bigInteger

shifts

id increments
start time
end time
setting_id ^FK bigInteger
softDeletes softDeletes
timestamps timestamps
days_of_week_id ^FK integer
place_id ^FK bigInteger

days_of_week

id increments
name_ar string (255)
name_en string (255)
name_ro string (255)
timestamps timestamps

medical_examinations

id increments
comment_and_description text
doctor_description text
doctor_recommandation text
timestamps timestamps
softDeletes softDeletes
booking_id ^FK bigInteger

prescriptions

id increments
timestamps timestamps
type enum
medicine_name string (255)
note text
dosage_id ^FK bigInteger
prescription_validation_id ^FK bigInteger
booking_id ^FK bigInteger

booking_images

id increments
name string (255)
booking_id ^FK bigInteger
softDeletes softDeletes
timestamps timestamps
type enum

dosages

id increments
name_ar string (255)
name_en string (255)
name_ro string (255)
timestamps timestamps
softDeletes softDeletes

prescription_validation

id increments
name_ar string (255)
name_en string (255)
name_ro string (255)
timestamps timestamps
softDeletes softDeletes

medical_analysis

id increments
name string (255)
analysis_for text
note text
medical_analysis_type_id ^FK integer
softDeletes softDeletes
timestamps timestamps
booking_id ^FK bigInteger

medical_analysis_types

id increments
name_ar string (255)
name_en string (255)
name_ro string (255)
timestamps timestamps

medical_x_rays

id increments
timestamps timestamps
name string (255)
x_ray_for text
note text
medical_x_ray_type_id ^FK bigInteger
booking_id ^FK bigInteger

medical_x_ray_types

id increments
name_ar string (255)
name_en string (255)
name_ro string (255)
timestamps timestamps

insurance_companies

id increments
timestamps timestamps
softDeletes softDeletes
name_ro string (255)
name_en string (255)
name_ar string (255)
image string (255)
location text

doctor_insurance_companies

id increments
timestamps timestamps
insurance_company_id ^FK bigInteger
doctor_id ^FK bigInteger

doctor_general_titles

id increments
name_ar string (255)
name_en string (255)
name_ro string (255)
type tinyInteger
timestamps timestamps

doctors_doctor_general_titles

id increments
timestamps timestamps
doctor_id ^FK bigInteger
doctor_general_tiltle_id ^FK bigInteger

assistants

id increments
timestamps timestamps
name string (255)
phone string (255)
doctor_id ^FK bigInteger

bank_doctor

id increments
timestamps timestamps
num integer
doctor_id ^FK bigInteger
bank_id ^FK bigInteger
beneficiary_name string (255)

banks

timestamps timestamps
id increments
name_en string (255)
name_ar string (255)
name_ro string (255)

certificates

id increments
timestamps timestamps
image string (255)
doctor_id ^FK bigInteger