Home
carehub
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
doctors
id
increments
full_name
string
(64)
username
string
(32)
password
string
(80)
gender
string
email
string
(64)
phone_number
string
(16)
qualification
string
speciality
string
city
string
(64)
zip_code
string
(32)
country
string
(32)
identification_number
string
(64)
professional_id_number
string
(64)
bio
text
avatar
string
(60)
status
string
(64)
created_by
integer
updated_by
integer
rememberToken
rememberToken
timestamps
timestamps
chambers
id
increments
name
string
(128)
adress
text
created_by
integer
updated_by
integer
timestamps
timestamps
doctor_chambers
id
increments
doctor_id
FK
integer
chamber_id
FK
integer
chamber_phone_number
string
(16)
visiting_time
text
created_by
integer
updated_by
integer
timestamps
timestamps
patients
id
increments
full_name
string
(64)
username
string
(32)
password
string
(80)
email
string
(64)
phone_number
string
(16)
gender
string
(64)
age
integer
dob
date
blood_group
string
(8)
father_name
string
(64)
mother_name
string
(64)
adress
text
note
text
bio
text
avatar
string
(60)
created_by
integer
updated_by
integer
rememberToken
rememberToken
timestamps
timestamps
doctor_subscriptions
id
increments
doctor_id
FK
integer
subscription_period
string
(32)
total_amount
double
tax
double
payment_method_id
FK
integer
subscription_package_id
FK
integer
created_by
integer
timestamps
timestamps
payment_methods
id
increments
title
string
payment_details
text
status
string
(16)
timestamps
timestamps
subscription_packages
id
increments
title
string
amount
integer
time_frame
string
(64)
time_frame_type
string
status
string
(16)
complaints
id
increments
name
string
(100)
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
inspections
id
increments
name
string
(100)
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
investigations
id
increments
name
string
(100)
status
integer
timestamps
timestamps
advices
id
increments
name
string
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
categories
id
increments
name
string
(32)
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
schedules
id
increments
name
string
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
dosages
id
increments
name
string
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
durations
id
increments
name
string
(100)
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
notes
id
increments
name
string
(100)
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
drugs
id
increments
name
string
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
patient_symptoms
id
increments
name
string
(100)
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
doses
id
increments
name
string
(100)
status
integer
created_by
integer
updated_by
integer
timestamps
timestamps
drugs_doses
drug_id
FK
integer
dose_id
FK
integer
durgs_categories
drug_id
integer
categories_id
FK
integer
prescriptions
id
increments
doctor_chamber_id
FK
integer
patient_id
FK
integer
timestamps
timestamps
fitness
id
increments
name
string
(100)
unit
string
(10)
input
integer
prescriptions_fitness
fitness_id
FK
integer
prescription_id
FK
integer
prescriptions_complaints
prescription_id
FK
integer
complaint_id
FK
integer
prescriptions_inspections
prescription_id
integer
inspection_id
FK
integer
prescriptions_patient_symptoms
prescription_id
integer
patient_symptom_id
FK
integer
prescriptions_investigations
prescription_id
integer
investigation_id
FK
integer
prescriptions_advices
prescription_id
integer
advice_id
FK
integer
prescriptions_details
prescription_id
integer
category_id
FK
integer
drug_id
FK
integer
dose_id
FK
integer
schedule_id
FK
integer
duration_id
FK
integer
dosage_id
FK
integer
addition
text
patients_notes
id
increments
doctor_chamber_id
FK
integer
patient_id
FK
integer
note_id
FK
integer
timestamps
timestamps
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01