consultations - Laravel Schema Designer

contents

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)
description text
image string (256)
accesscategory_id bigInteger
accesslevel_id bigInteger
level_difficulty enum
sublevel_difficulty enum
contentable_id bigInteger
contentable_type string (256)
status enum
quality_evaluation integer
created_by_user_id bigInteger
updated_by_user_id bigInteger
deleted_by_user_id bigInteger

scenarios

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)
intro_text text
objectif string (256)
scenario_icon string (256)
practitioner_index integer
date datetime
allotted_time bigInteger
patient_id bigInteger
environment_id bigInteger
scenario_to_play_id bigInteger
json json

environments

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)

patients

id increments
timestamps timestamps
softDeletes softDeletes
firstname string (256)
lastname string (256)
age integer
avatar_id bigInteger
particularity_index integer
comment text
normal_weight bigInteger
weight bigInteger
height bigInteger
left_hear_media string (256)
right_hear_media string
left_eye_media string (256)
right_eye_media string (256)
tongue_media string (256)
temperature integer
personal_situation_id bigInteger
sys_tension integer
dia_tension integer
pul_tension integer
spo2_saturation integer
prbmp_saturation integer

avatars

id increments
timestamps timestamps
softDeletes softDeletes
image string (256)
model_index integer
gender_index smallInteger
morphotype_index smallInteger
ethnic_index smallInteger

personal_situations

id increments
timestamps timestamps
softDeletes softDeletes
children_number tinyInteger
lives_with_children boolean
has_children_custody boolean
children_injoint_custody boolean
activity_status_index integer
job string (256)
unemployment_duration date
studylevel_index integer
school_repetition boolean
grade_jump boolean
income_index integer
current_pet_index integer
former_pet_index integer
recent_travel_date date
travel_country string (256)
travel_duration_in_days bigInteger
lived_abroad_country string (256)
lived_aborad_return_date date
lived_aborad_duration_in_days bigInteger
current_country string (256)
smoking_habit_date date
smoking_amount integer
last_smoking_index integer
hobby_index string (256)
sport_id integer

toxic_drugs

id increments
timestamps timestamps
softDeletes softDeletes
personal_situation_id bigInteger
type_index bigInteger
medecine_type string (256)
medecine_subtype string (256)
last_use_date date
quitting_attempt_number bigInteger
last_quitting_duration_in_days bigInteger
frequency_index bigInteger

patient_backgrounds

id increments
timestamps timestamps
softDeletes softDeletes
antecedent_id bigInteger
patient_id bigInteger
affected_person_index integer
age integer
severity boolean
particularity text

antecendents

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)

custom_questions

id increments
timestamps timestamps
softDeletes softDeletes
patient_background_id bigInteger
question text
answer text
keywords text

drug_therapies

id increments
timestamps timestamps
softDeletes softDeletes
patient_id bigInteger
medecine_id bigInteger
dosage_type_index integer
dosage_attribute string (256)
quantity_weight decimal (5.2)
number_per_day integer
galenic_index integer
injection_way_index integer
duration integer
duration_type_index integer
treatment_rythme_index integer
rythme bigInteger
sup_factor text
complement text
scenario_id bigInteger
points integer
is_mandatory boolean
is_forbidden boolean

non_drug_therapies

id increments
timestamps timestamps
softDeletes softDeletes
type_index integer
patient_id bigInteger
scenario_id bigInteger
points integer
is_mandatory boolean
is_forbidden boolean

medecines

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)

complementary_exams

id increments
timestamps timestamps
softDeletes softDeletes
type_index integer
points integer
is_mandatory boolean
patient_id bigInteger
scenario_id bigInteger
is_forbidden boolean

follow_ups

id increments
timestamps timestamps
softDeletes softDeletes
type_index integer
points integer
patient_id bigInteger
is_mandatory boolean
scenario_id bigInteger
is_forbidden boolean

exam_results

id increments
timestamps timestamps
patient_id bigInteger
name string (256)
media string (256)

clinical_signs

id increments
timestamps timestamps
softDeletes softDeletes
patient_id bigInteger
is_mandatory boolean
title string (256)

question_overrides

id increments
timestamps timestamps
softDeletes softDeletes
clinical_sign_id bigInteger
clinical_sign_question_id bigInteger
points integer
answer_override text

clinical_sign_questions

id increments
timestamps timestamps
softDeletes softDeletes
title text

physical_exam_overrides

id increments
timestamps timestamps
softDeletes softDeletes
clinical_sign_id bigInteger
body_area_type_index integer

exams

id increments
timestamps timestamps
softDeletes softDeletes
physical_exam_overrides_id bigInteger
exam_type_index integer
points integer
tool_type_index integer
inspection_result string (256)
auscultation_result string (256)
palpation_result text
percution_animation string (256)
percution_audio string (256)

diagnostics

id increments
timestamps timestamps
softDeletes softDeletes
scenario_id bigInteger
antecedent_id bigInteger
points integer
question text

patient_questions

id increments
timestamps timestamps
softDeletes softDeletes
question text
answer_index integer
scenario_id bigInteger
points integer

sports

id increments
timestamps timestamps
softDeletes softDeletes
title string

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