patientsHelp - Laravel Schema Designer

users

id increments
name string (200)
email string
password string
role enum
timestamps timestamps

doctors

id increments
timestamps timestamps
user_id ^FK integer
specialization string
availability string

posts

id increments
timestamps timestamps
title string
content text
author_id ^FK integer

appointments

id increments
timestamps timestamps
doctor_id ^FK integer
patient_id ^FK integer
appointment_date datetime
status enum

consultations

id increments
timestamps timestamps
patient_id ^FK integer
doctor_id ^FK integer
consultation_date datetime
status enum
notes text

ratings

id increments
timestamps timestamps
patient_id ^FK integer
doctor_id ^FK integer
rating integer
review text

teletherapy_sessions

id increments
timestamps timestamps
session_date datetime
session_link string
patient_id ^FK integer
doctor_id ^FK integer
duration integer
status enum
notes text

tests

id increments
timestamps timestamps
test_title string
description text
created_by ^FK integer

test_results

id increments
timestamps timestamps
patient_id ^FK integer
test_id ^FK integer
result string
analysis text
taken_at datetime

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