Clinics - Laravel Schema Designer

Discounts

id increments
timestamps timestamps
link string (100)
percentage decimal
duration integer
discount_code string
discounted_type string (50)
discounted_id integer

Advertisements

id increments
timestamps timestamps
image string (200)
duration integer
discount_id integer
clinic_id integer

Cities

id increments
timestamps timestamps
name string (100)

Type_of_specialties

id increments
timestamps timestamps
name string (100)
color string
icon string (250)

Specialties

id increments
timestamps timestamps
name string (100)

Clinics

id increments
timestamps timestamps
name string (100)
address string (150)
image string (100)
link string (100)
city_id integer
specialty_id integer
type_of_specialty_id integer

Doctors

id increments
timestamps timestamps
name string (100)
image string (100)
nationality string (50)
price decimal
detailes text
clinic_id integer
specialty_id integer
type_of_specialty_id integer

Services

id increments
timestamps timestamps
service_name_id string (100)
details string (200)
price decimal
price_subtract boolean
doctor_id integer

Bookings

id increments
timestamps timestamps
status enum
service_id string
appointment string
price boolean
discounted_price decimal
discount_id integer
patient_id integer

Patients

id increments
timestamps timestamps
first_name string (100)
title string (100)
mobile string (20)
email string (50)
address string (150)

Booking_items

id increments
service_id integer
booking_id integer

Service_names

id increments
name string

Appointments

id increments
week_day string
from_hour_to_hour time

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