Home
clinic
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
(191)
username
string
(191)
password
string
(191)
email
string
(191)
clinic_id
integer
job
enum
phonenumber
string
(191)
active
boolean
patients
id
increments
timestamps
timestamps
phone
string
(191)
area_id
integer
birthdate
date
gender
enum
name
string
(191)
notes
string
(191)
email
string
(191)
clinic_id
integer
insurance_id
integer
drugs
id
increments
timestamps
timestamps
name
string
(191)
concentration
integer
visits
id
increments
timestamps
timestamps
notes
string
(191)
setting_id
integer
patient_id
integer
clinic_id
integer
status
tinyInteger
appointments
id
increments
timestamps
timestamps
clinic_id
integer
appointment_time
time
appointment_date
date
patient_id
integer
paied
boolean
prescriptions
id
increments
timestamps
timestamps
clinic_id
integer
admins
id
increments
timestamps
timestamps
name
string
(191)
email
string
(191)
password
string
(191)
roles
id
increments
timestamps
timestamps
name
string
(191)
clinics
id
increments
timestamps
timestamps
name
string
(191)
settings
id
increments
timestamps
timestamps
appointment_status
string
(191)
work_hours
id
increments
timestamps
timestamps
day
enum
duration
integer
clinic_id
integer
visits_limit
integer
insurances
id
increments
timestamps
timestamps
insurance_name
string
(191)
insurance_discount
integer
patient_discount
integer
additional_fields
id
increments
timestamps
timestamps
field_name
string
(191)
field_type
string
(191)
required
boolean
laboratories
id
increments
timestamps
timestamps
name
string
(191)
phoneNumber
string
(191)
patient_attachments
id
increments
timestamps
timestamps
type
string
(191)
patient_id
integer
services
id
increments
timestamps
timestamps
name
string
(191)
cost
decimal
clinic_id
integer
clinic_intervals
id
increments
timestamps
timestamps
from
time
to
time
expenses
id
increments
timestamps
timestamps
expense_name
string
(191)
expense_items
id
increments
timestamps
timestamps
item_name
string
(191)
cost
integer
expense_date
date
medical_analyses
id
increments
timestamps
timestamps
name
string
(191)
medical_radiologies
id
increments
timestamps
timestamps
name
string
(191)
prescription_dimensions
id
increments
timestamps
timestamps
show_patient_name
boolean
show_patient_age
boolean
show_date
boolean
areas
id
increments
timestamps
timestamps
city_name
string
(191)
governorate
string
(191)
lab_requirements
id
increments
timestamps
timestamps
laboratory_id
integer
medicalAnalysis_id
integer
cost
integer
requirement_date
date
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01