doctor_db - Laravel Schema Designer

users

id increments
email string (255)
password string (60)
remember_token string (100)
username string (40)
timestamps timestamps

roles

id increments
name string
description string
timestamps timestamps

permissions

id increments
slug string (40)

login_attempts

id increments
user_id ^FK bigInteger
login_ip string (60)
timestamps timestamps

profiles

id increments
user_id ^FK bigInteger
first_name string (100)
last_name string (100)
father_name string (100)
mother_name string (100)
dob date
sex enum
blood_group enum
marital_status enum
mobile string (20)
alternate_mobile string (20)
address string

qualifications

id increments
doctor_id ^FK bigInteger
certificate_id ^FK integer
others_title string
timestamps timestamps
src string

schedules

id increments
chamber_id ^FK bigInteger
day enum
start_time time
end_time string
status boolean

search

id increments
keyword string
user_id ^FK bigInteger
timestamps timestamps

physical_conditions

id increments
patient_id ^FK bigInteger
timestamps timestamps

medical_records

id increments
patient_id ^FK bigInteger
doctor_id ^FK bigInteger
timestamps timestamps

degrees

id increments
title string
type string

chambers

id increments
doctor_id ^FK bigInteger

doctors

id increments
user_id ^FK bigInteger
timestamps timestamps
routing_id string
status boolean

patients

id increments
user_id ^FK bigInteger
timestamps timestamps

address

id increments
timestamps timestamps

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