clinic - Laravel Schema Designer

patients

id increments
timestamps timestamps
softDeletes softDeletes
phone string (191)
city_id integer
date_of_birth date
gender boolean
old_file string (191)
name string (191)
clinic_id integer
email string (191)
notes text

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
user_name string (191)
email string (191)
phone string (191)
clinic_id integer
password string (191)
active boolean
job enum

appointments

id increments
timestamps timestamps
softDeletes softDeletes
appointment_date date
appointment_time time
status tinyInteger
clinic_id integer
patient_id integer
service_id integer
insurance_id integer
notes text
cost decimal
payed decimal

services

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
cost decimal
clinic_id integer

Extra_Medical_Service

id increments
timestamps timestamps
softDeletes softDeletes
name string
cost decimal

Expenses

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
category tinyInteger
cost decimal
Expenses_date date
notes string

Insurances

id increments
timestamps timestamps
softDeletes softDeletes
name string
ins_discount double
patient_discount decimal

patient_extra_field

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
field_type enum
patient_id integer
view text
clinic_id integer

Analytics

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
patient_id integer
clinic_id integer
lab_id integer

Rays

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
patient_id integer

Medicens

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
med_present double
med_description text

Extra_field_options

id increments
timestamps timestamps
softDeletes softDeletes
selectname string

subscriptions

id increments
timestamps timestamps
softDeletes softDeletes
current_package string (191)
price decimal
end_date date
bills text

Reports

id increments
timestamps timestamps
softDeletes softDeletes
from date
to date
type tinyInteger
category tinyInteger

Labs

id increments
timestamps timestamps
softDeletes softDeletes
patient_id integer
phone string
email string
responsible_name string
lab_service tinyInteger

Labs_extra_field

id increments
timestamps timestamps
softDeletes softDeletes
type tinyInteger
name string

clinic

id increments
timestamps timestamps
softDeletes softDeletes
name string
patient_id integer
doctor_id integer
specialty tinyInteger
phone string
status boolean

Doctor

id increments
timestamps timestamps
softDeletes softDeletes
name string
specialty tinyInteger

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