clinic_system - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string
username string
email string
phone string
password string
job integer
active boolean
clinic_id ^FK integer

clinics

id increments
timestamps timestamps
softDeletes softDeletes
name string

appointments

id increments
timestamps timestamps
softDeletes softDeletes
appointment_date date
appointment_time time
status tinyInteger
clinic_id ^FK integer
patient_id ^FK integer
notes text

admin

id increments
timestamps timestamps
softDeletes softDeletes
username string
password string
phone string
email string

settings

id increments
timestamps timestamps
softDeletes softDeletes
duration integer
cost decimal
working_hours_id ^FK integer
clinic_id ^FK integer

patients

id increments
timestamps timestamps
softDeletes softDeletes
phone string
date_of_birth date
gender boolean
name string
clinic_id ^FK integer
email string
notes text
insurance_id ^FK integer
area_id ^FK integer

services

id increments
timestamps timestamps
softDeletes softDeletes
name string
cost string
clinic_id ^FK integer
service_type string

insurances

id increments
timestamps timestamps
softDeletes softDeletes
name string
insurance_discount_percentage decimal
patient_discount_percentage decimal

patient_attachments

id increments
timestamps timestamps
softDeletes softDeletes
file_name string
file_path string
file_type string

working_hours

id increments
timestamps timestamps
softDeletes softDeletes
day string
working_hours integer
from time
to time
clinic_id ^FK integer

prescriptions

id increments
timestamps timestamps
softDeletes softDeletes
drug_id ^FK integer
photo string
padding_top decimal
padding_bottom decimal
padding_left decimal
padding_right decimal
show_name boolean
show_age boolean
show_date boolean
clinic_id ^FK integer

drugs

id increments
timestamps timestamps
softDeletes softDeletes
name string
concentration string
info text
clinic_id ^FK integer

medical_tests

id increments
timestamps timestamps
softDeletes softDeletes
name string
clinic_id ^FK integer
patient_id ^FK integer

areas

id increments
timestamps timestamps
softDeletes softDeletes
name string
clinic_id ^FK integer

subscriptions

id increments
timestamps timestamps
softDeletes softDeletes
service_id ^FK integer

laboratories

timestamps timestamps
softDeletes softDeletes
name string
phone string
email string
officer_in_charge string
id increments
clinic_id ^FK integer
Specialization string

laboratory_requests

id increments
timestamps timestamps
softDeletes softDeletes
laboratory_id ^FK integer
patient_id ^FK integer
request_date date
laboratory_note text
doctor_notes text
status boolean
cost decimal
request_change_date date
appointment_id ^FK integer

laboratory_users

id increments
timestamps timestamps
softDeletes softDeletes
laboratory_id ^FK integer
name string
phone string
password string

attachment_services

id increments
timestamps timestamps
softDeletes softDeletes
name string
serviceable_id integer
serviceable_type string
cost decimal
amount decimal

additional_values

id increments
timestamps timestamps
softDeletes softDeletes
type tinyInteger
additionable_id integer
addition_id integer
additionable_type string
clinic_id ^FK integer

payment_transactions

id increments
timestamps timestamps
softDeletes softDeletes
safe_id integer
clinic_id ^FK integer
paymentable_id integer
paymentable_type string
pay_date date
effect tinyInteger
type tinyInteger
amount decimal

options

id increments
timestamps timestamps
softDeletes softDeletes
value string
clinic_id ^FK integer

additions

id increments
timestamps timestamps
softDeletes softDeletes
name string
addition_for integer
addition_type integer

appointment_service

id increments
timestamps timestamps
softDeletes softDeletes
appointment_id ^FK integer
service_id ^FK integer
cost decimal

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