healer - Laravel Schema Designer

patients

id increments
timestamps timestamps
name string (50)
phone string (11)
email string (50)
date_of_birth date
password string (50)

doctors

id increments
timestamps timestamps
name string (50)
email string (50)
certificate boolean
password string (50)
license_no string (50)
job_title string (50)
description string (300)
session_price smallInteger
active boolean
rate tinyInteger
user_id ^FK integer

articles

id increments
timestamps timestamps
title string (50)
author string (50)
doctor_id ^FK integer
content text
publish_date date
category_id ^FK integer
user_id ^FK integer

categories

id increments
name string (50)
user_id ^FK integer

posts

id increments
timestamps timestamps
patient_id ^FK integer
content text
publish_date datetime
category_id ^FK integer

comments

id increments
timestamps timestamps
post_id ^FK integer
patient_id ^FK integer
doctor_id ^FK integer
content string
publish_date datetime

sessions

id increments
timestamps timestamps
doctor_id ^FK integer
patient_id ^FK integer
date_time datetime

feedbacks

id increments
timestamps timestamps
patient_id ^FK integer
doctor_id ^FK integer
rate tinyInteger
content string (300)

doctor_info

id increments
doctor_id ^FK integer
info string (300)

users

id increments
timestamps timestamps
name string (50)
email string (50)
email_verified_at timestamp
password string (50)
rememberToken rememberToken

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