hona - Laravel Schema Designer

settings

id increments
timestamps timestamps
logo string (255)
app_name string (255)
slogan string (255)

contacts

id increments
timestamps timestamps
name string (255)
email string (255)
message text

doctors

id increments
timestamps timestamps
name string (255)
email string (255)
password string (255)
api_token string (255)
profissional_statement string (255)
hospital_id ^FK integer
practicing_from date
started_at datetime
end_at string
visita double (8,2)
specialization_id ^FK integer

symptoms

id increments
timestamps timestamps
type string
place string
symptom_form string

password_resets

id increments
timestamps timestamps
email string (255)
token string (255)

hospitals

id increments
timestamps timestamps
name string (255)
city string
country string
contact string
rate double (8,2)
city_id ^FK integer
district_id ^FK integer
specialization_id ^FK integer

messages

id increments
timestamps timestamps
user_id ^FK integer
body text

specializations

id increments
timestamps timestamps
specialization_name string

hospitals_users

id increments
timestamps timestamps
user_id integer
hospital_id ^FK integer
user_rating double (8,2)
user_opinion string (255)

avatars

id increments
timestamps timestamps
path string (255)
avatarable_id integer
avatarable_type string (255)

doctors_books

id increments
timestamps timestamps
patient_id integer
doctor_id ^FK integer
hospital_id ^FK integer
visita double
user_rating double
examination_date datetime
comment text

users_bot_messages

id increments
timestamps timestamps
user_id ^FK integer
body text

diseases

id increments
timestamps timestamps
name string
age decimal
sex enum
pain_type string
pain_place string
bload_preasue double
disease_sickness string
suger_level string
sport_excercising string
danger string

medications

id increments
timestamps timestamps
brand_name string (255)
name string (255)
describtion text
minimum_dose double (8,2)
maximum_dose double (8,2)
dose_unit string

clinical_pharmacologies

id increments
timestamps timestamps
medication_id ^FK integer
discribtion text

indication_usages

id increments
timestamps timestamps
medication_id ^FK integer
fda_approved boolean
describtion text

usages_symptoms

id increments
timestamps timestamps
usage_id ^FK integer
symptom_name string (255)

contraindications

id increments
timestamps timestamps
medication_id ^FK integer
contraindication text

warnings

id increments
timestamps timestamps
medication_id ^FK integer
warning text

recommed_medcations

id increments
timestamps timestamps
patient_id integer
medication string (255)
medication_id ^FK integer

recommend_doctors

id increments
timestamps timestamps
patient_id integer
doctor string (255)
doctor_id ^FK integer
rating decimal

users

id increments
timestamps timestamps
name string (255)
email string (255)
phone string (255)
work text
address string (255)
birth date
city_id ^FK integer
district_id ^FK integer
following_count integer
password string (255)
follower_count integer
api_token string
sex enum

cities

id increments
timestamps timestamps
name string (255)

districts

id increments
timestamps timestamps
name string (255)
city_id ^FK integer

friends

id increments
timestamps timestamps
user_id ^FK integer
friend_id integer
relationship string (255)

sports

id increments
timestamps timestamps
name string (255)
describtion text
duration integer
duration_unit string
times integer
each string

user_sports

id increments
timestamps timestamps
user_id ^FK integer
sport_id ^FK integer
note text

meeting_medications

id increments
timestamps timestamps
meeting_id ^FK integer
medication_id ^FK integer
doc_advice text
times increments
unit string
duration string
amount string

meeting_diseases

id increments
timestamps timestamps
doctors_book_id ^FK integer
disease_id ^FK integer
note text

meeting_symptoms

id increments
timestamps timestamps
doctors_book_id ^FK integer
symptom_id ^FK integer
note text

precautions

id increments
timestamps timestamps
medication_id ^FK integer
precaution text

adverse_reactions

id increments
timestamps timestamps
reaction text
medication_id ^FK integer

drug_abuses

id increments
timestamps timestamps
dependance text
medication_id ^FK integer

overdoses

id increments
timestamps timestamps
resault text
medication_id ^FK integer

adminstrate_doses

id increments
timestamps timestamps
medication_id ^FK integer
quantity_from double
quantity_to double
dose_unit string
recommendation text

how_supplies

id increments
timestamps timestamps
medication_id ^FK integer
describtion text

sencitivities

id increments
timestamps timestamps
name string
type string
age string
sex enum

users_sencitivities

id increments
timestamps timestamps
patient_id integer
sencitivity_id ^FK integer
note text

pharmacies

id increments
timestamps timestamps
name string
city_id ^FK integer
district_id ^FK integer
start_at datetime
finish_at datetime
has_delivery boolean

ph_repositories

id increments
timestamps timestamps
pharmacy_id ^FK integer
medication_id ^FK integer
amount double
unit string (255)

dependances

id increments
timestamps timestamps
user_id ^FK integer
name string
birth date

diets

id increments
timestamps timestamps

users_diets

id increments
timestamps timestamps
diet_id ^FK integer
patient_id integer
started_at date
end_at date
duration string
note text

disease_symptoms

id increments
timestamps timestamps
disease_id ^FK integer
symptom_id ^FK integer

diagnosis

id increments
timestamps timestamps
patient_id ^FK integer