Home
tek_doc
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
role_id
FK
integer
id
bigIncrements
first_name
string
(299)
last_name
string
(299)
email
string
(299)
dob
date
gender
string
(10)
password
string
(299)
status
tinyInteger
stripe_id
string
(299)
phone_number
string
(20)
profile_pic
text
subscription_status
tinyInteger
timestamps
timestamps
initial_status
tinyInteger
roles
id
increments
role
string
(50)
timestamps
timestamps
medical_histories
id
bigIncrements
user_id
bigInteger
whose_status
tinyInteger
timestamps
timestamps
height_in_feet
double
height_in_inch
double
relative_id
FK
integer
weight
double
smoke
tinyInteger
alcohol_status
tinyInteger
traveled_over_sea
tinyInteger
doc_last_visit
date
relative_infos
id
increments
user_id
FK
bigInteger
relative_name
string
(299)
relative_email
string
(299)
relative_dob
date
relation
FK
integer
timestamps
timestamps
booking_infos
id
bigIncrements
history_id
FK
bigInteger
medical_problem
text
doctor_id
FK
bigInteger
image_url
string
(299)
status
tinyInteger
slot_id
FK
integer
update_status
tinyInteger
timestamps
timestamps
doctors_slots
id
increments
sloted_date_id
FK
integer
doctor_id
FK
bigInteger
date
date
start_time
time
end_time
time
timestamps
timestamps
prescriptions
id
increments
booking_id
FK
bigInteger
prescription
text
comment
string
(299)
timestamps
timestamps
payments
id
increments
user_id
FK
bigInteger
booking_id
FK
bigInteger
discount_percentage
integer
discount_amount
decimal
total_amount
double
amount
double
payment_status
tinyInteger
timestamps
timestamps
reviews
id
increments
booking_id
FK
bigInteger
doctor_id
FK
bigInteger
patient_id
FK
bigInteger
doctor_satisfaction
tinyInteger
timestamps
timestamps
patient_satisfaction
tinyInteger
password_resets
id
increments
email
string
(299)
token
text
otp
string
(10)
timestamps
timestamps
medications
id
increments
history_id
FK
bigInteger
medication
text
timestamps
timestamps
allergies
id
increments
history_id
FK
bigInteger
allergy
string
(299)
timestamps
timestamps
health_prolems
id
increments
health_problem
string
(299)
timestamps
timestamps
patient_family_prolems
id
increments
history_id
FK
bigInteger
family_problem_id
FK
integer
timestamps
timestamps
patient_health_problems
id
increments
history_id
FK
bigInteger
health_problem_id
FK
integer
timestamps
timestamps
family_problems
id
increments
family_problem
string
(299)
timestamps
timestamps
doctor_infos
id
increments
doctor_id
FK
bigInteger
document_name
text
clinic_name
string
(299)
speciality
string
(299)
description
text
timestamps
timestamps
diabetes
id
increments
history_id
FK
bigInteger
who_has
FK
integer
timestamps
timestamps
possible_members_list
id
increments
member
string
(299)
timestamps
timestamps
sloted_dates
id
increments
timestamps
timestamps
sloted_date
date
doctor_id
FK
bigInteger
e_prescriptions
id
increments
booking_id
FK
integer
npi
integer
dea
string
(10)
pharmacy_name
string
(299)
pharmacy_address
string
(299)
pharmacy_phone
string
(299)
pharmacy_fax
string
(299)
notes
text
timestamps
timestamps
verification_status
tinyInteger
prescription_medication
id
increments
timestamps
timestamps
prescription_id
FK
integer
tablet_name
string
(299)
tablet_quantity
string
(299)
supply_days
integer
substitution
tinyInteger
sig
text
×
Comments for tek_doc
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01