To clinica - Laravel Schema Designer

clinics

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
logo text
latitude double
longitude double
adress_en string
adress_ar string
rating integer
user_id integer
fees decimal
waiting_time integer
email string
phone string

doctors

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
logo text
clinic_id integer
brief string
nationality string
fees decimal
email string
rating integer
phone string
waiting_time integer
degree_id integer

specialities

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
icon text
color string
parent_id integer

degree

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

offers

id increments
timestamps timestamps
image_en text
image_ar text
start_at timestamp
expire_at timestamp
discount_id integer
clinic_id integer
doctor_id integer
clicks integer

ads

id increments
timestamps timestamps
softDeletes softDeletes
clinic_id integer
doctor_id integer
start_at timestamp
expire_at timestamp
clicks integer

appointments

id increments
timestamps timestamps
softDeletes softDeletes
from_hour double
to_hour double
date timestamp
status enum
bookings string

discounts

timestamps timestamps
id increments
softDeletes softDeletes
code string
name string
is_percent boolean
amount decimal
clinic_id integer
doctor_id integer
uses integer
max_uses integer
start_at timestamp
expire_at timestamp
user_id integer

users

id increments
timestamps timestamps
softDeletes softDeletes
user_name string
password string
mobile integer
verification_code string
verified string
login string
active string
role enum

patients

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
email string
phone string
country string

bookings

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
clinic_id integer
doctor_id integer
appointment_id integer
discount_id integer
price decimal
status enum

provider_specialities

id increments
timestamps timestamps
softDeletes softDeletes
clinic_id integer
doctor_id integer
specilaty_id integer

rate

id increments
timestamps timestamps
softDeletes softDeletes
booking_id integer
q1 integer
q2 integer
q3 integer
q4 integer
review text

setting

id increments
softDeletes softDeletes
key string (200)
value text

notification

id increments
timestamps timestamps
softDeletes softDeletes
message_ar mediumText
title string (120)
massage text
title_ar string (120)

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