clinic - Laravel Schema Designer

departments

id increments
timestamps timestamps
softDeletes softDeletes
name text
description longText

docotors

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
phone string
department_id string
address longText
image string
profile longText

holidays

id increments
softDeletes softDeletes
timestamps timestamps
doctor_id integer
day date
notes text

appointments

id increments
timestamps timestamps
softDeletes softDeletes
doctor_id integer
patient_id integer
day date
time_from time
time_to time
notes text
status enum

time_schedules

timestamps timestamps
id increments
softDeletes softDeletes
doctor_id integer
day date
time_from time
time_to time
appointments_duration integer
notes text

patients

timestamps timestamps
id increments
softDeletes softDeletes
name text
email string
phone string
address text
birth_date date
gender enum
blood_category integer
doctor_id integer
image string
notes text

invoices

id increments
timestamps timestamps
softDeletes softDeletes
patient_id integer
doctor_id integer
discount double
discount_type enum
total double
total_after_discount double
notes text
paid_amount double
reference_id integer

invoice_items

id increments
timestamps timestamps
softDeletes softDeletes
item_id integer
item_type string
inventory_id integer
quantity float
sale_price float
invoice_id integer
total float
category_id integer

patient_cases

timestamps timestamps
softDeletes softDeletes
id increments
doctor_id integer
patient_id integer
title string
details longText

patient_documents

id increments
timestamps timestamps
softDeletes softDeletes
patient_id integer
title string
attachment string

invoice_payments

id increments
timestamps timestamps
softDeletes softDeletes
invoice_id integer
patient_id integer
amount float
date date
notes text

expenses

id increments
timestamps timestamps
softDeletes softDeletes
category_id integer
amount float
date date
notes text

prescriptions

id increments
timestamps timestamps
softDeletes softDeletes
doctor_id integer
patient_id integer
date date
history longText
notes longText

prescription_items

id increments
timestamps timestamps
softDeletes softDeletes
prescription_id integer
item_id integer
item_type string
notes longText

lab_reports

id increments
timestamps timestamps
softDeletes softDeletes
patient_id integer
doctor_id integer
date date
details longText

lab_report_templates

id increments
timestamps timestamps
softDeletes softDeletes
name string
details longText

products

id increments
timestamps timestamps
softDeletes softDeletes
category_id string
name string
sale_price float
purchase_price float
generic_name string
expire_date date

inventories

id increments
timestamps timestamps
softDeletes softDeletes
name string
address text
phone string

inventories_products

id increments
softDeletes softDeletes
timestamps timestamps
inventory_id integer
product_id integer
quantity float

donors

id increments
timestamps timestamps
softDeletes softDeletes
category_id integer
name string
phone string
email string
last_donation_date date
date date
age string
gender enum

beds

id increments
timestamps timestamps
softDeletes softDeletes
category_id integer
number string
notes text
status enum

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string
description longText
type string
category_id integer

bed_allotments

id increments
timestamps timestamps
softDeletes softDeletes
patient_id integer
date_from timestamp
date_to timestamp
notes text

reference

id increments
timestamps timestamps
softDeletes softDeletes
name string
description text
patient_amount float
reference_amount float
amount_type enum

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