medical - Laravel Schema Designer

users

id increments
user_type enum
timestamps timestamps
softDeletes softDeletes

roles

id increments
timestamps timestamps
softDeletes softDeletes

permissions

id increments
timestamps timestamps
softDeletes softDeletes

cities

id increments
timestamps timestamps
softDeletes softDeletes

countries

id increments
timestamps timestamps
softDeletes softDeletes

nationalities

id increments
timestamps timestamps
softDeletes softDeletes

doctor_data

id increments
doctor_id ^FK integer
timestamps timestamps
softDeletes softDeletes

services

id increments
price integer
timestamps timestamps
softDeletes softDeletes

specifications

id increments
timestamps timestamps
softDeletes softDeletes

appointments

id increments
patient_id ^FK integer
doctor_id ^FK integer
service_id ^FK integer
status string
time time
date date
timestamps timestamps
softDeletes softDeletes

rates

id increments
patient_id ^FK integer
appointment_id ^FK integer
rate integer
comment text
timestamps timestamps
softDeletes softDeletes

sliders

id increments
timestamps timestamps
softDeletes softDeletes

settings

id increments
timestamps timestamps
softDeletes softDeletes

coupons

id increments
timestamps timestamps
softDeletes softDeletes

notifications

id increments
timestamps timestamps
softDeletes softDeletes

app_media

id increments
timestamps timestamps
softDeletes softDeletes

wallet_transactions

id increments
timestamps timestamps
softDeletes softDeletes

wallets

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

addresses

id increments
patient_id ^FK integer
is_main boolean
timestamps timestamps
softDeletes softDeletes

chats

id increments
timestamps timestamps
softDeletes softDeletes

messages

id increments
chat_id ^FK integer
sender_id ^FK integer
receiver_id ^FK integer
message text
read_at datetime
timestamps timestamps
softDeletes softDeletes

support_employee_data

id increments
support_employee_id ^FK integer
timestamps timestamps
softDeletes softDeletes

contact_us

id increments
timestamps timestamps
softDeletes softDeletes

reports

id increments
patient_id ^FK integer
doctor_id ^FK integer
report_message text
timestamps timestamps
softDeletes softDeletes

doctor_service

id increments
doctor_id ^FK integer
service_id ^FK integer

educations

id increments
timestamps timestamps
softDeletes softDeletes

key_words

id increments
type enum
timestamps timestamps
softDeletes softDeletes

doctor_key_words

id increments
doctor_id ^FK integer
key_word_id ^FK integer

scientific_degrees

id increments
timestamps timestamps
softDeletes softDeletes

city_doctor

id increments
city_id ^FK integer
doctor_id ^FK integer

clinics

id increments
doctor_id ^FK integer
timestamps timestamps
softDeletes softDeletes

medicines

id increments
appointment_id ^FK integer
name string
dose_per_day integer
timestamps timestamps
softDeletes softDeletes

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