doctors - Laravel Schema Designer

users

id increments
image string
name string
type boolean
code integer
country_code string (4)
phone string (15)
email string (50)
city_id ^FK bigInteger
password string
is_blocked boolean
is_approved boolean
is_active boolean
lang string (5)
is_notify boolean

doctors

id increments
is_available boolean
type boolean
image string
cover string
id_image string
name string
birthday date
nationality_id ^FK bigInteger
phone string (15)
country_code string (5)
email string (50)
experience_year integer
professional_license string
bio text
qualification_id ^FK bigInteger
university_id ^FK bigInteger
college_id ^FK bigInteger
graduation_year date
bank_id ^FK bigInteger
bank_account_name string
bank_account_number bigInteger
password string
code integer
map_desc string
lat float
lng float
avg_rate decimal
lang string

doctor_issues

id increments
name string (50)

doctor_issue_doctor

id increments
doctor_id ^FK bigInteger
doctor_issue_id ^FK bigInteger

category_doctor

id increments
doctor_id ^FK bigInteger
category_id ^FK bigInteger

categories

id increments
name string
is_active boolean
parent_id ^FK bigInteger

doctor_certificates

id increments
doctor_id ^FK bigInteger
certificate string

qualifications

id increments
name string (50)

doctor_schedules

id increments
doctor_id bigInteger
day enum
start_time time
end_time time

services

id increments
name string
price decimal

sliders

id increments
title string
label string (50)
image string

colleges

id increments
name string

universities

id increments
timestamps timestamps

rates

id increments
user_id ^FK bigInteger
doctor_id ^FK bigInteger
rate integer
comment string

orders

id increments
user_id ^FK bigInteger
doctor_id ^FK bigInteger

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