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

providers

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

issue_types

id increments
name string (50)
parent_id ^FK bigInteger
sub_category_id ^FK bigInteger

doctor_issue_doctor

id increments
doctor_id ^FK bigInteger
doctor_issue_id ^FK bigInteger

provider_category

id increments
provider_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
provider_id ^FK bigInteger
rate integer
comment string

orders

id increments
user_id ^FK bigInteger
provider_id ^FK bigInteger
type tinyInteger
contact_type tinyInteger
reservation_code tinyInteger
user_confirm_start boolean
provider_schedule_day_id ^FK bigInteger
provider_schedule_time_id ^FK bigInteger
vat_per integer
vat_amount decimal
final_total decimal
admin_commission_per tinyInteger
admin_commission decimal
status tinyInteger
pay_type tinyInteger
pay_status tinyInteger
pay_data json
lat float
lng float
map_desc string
notes text

provider_issue_type

id increments
provider_id ^FK bigInteger
issue_type_id ^FK bigInteger

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