Tracking Health Disorders, Part 2
Working and relating symptom data
Issue: 14.4 (July/August 2016)
Author: J.C. Cruz
Author Bio: JC is a freelance writer based in British Columbia. He is a regular contributor to MacTech Magazine and Dr Dobb's Journal. Away from the writing pile, JC spends quality time with his nephew, as a proper uncle should.
Article Description: No description available.
Article Length (in bytes): 49,418
Starting Page Number: 43
Article Number: 14407
project-14407.zip Updated: 2016-07-04 14:35:23
Related Web Link(s):
Excerpt of article text...
In my last article, I explained how I tracked and managed disorder data in my personal health solution. Today, I take a step further by adding symptom data to the mix.
First, I explain what symptoms are and why they should be tracked. I show how each symptom relates to each disorder, then design two databases: one to hold the data, another to hold the relations. Next, I design the views for entering and displaying symptom data. And I implement the workflow routines for handling both data and relations.
The updated demo project (FooHealth, Mk8) is available from the magazine's website. Readers must have a working knowledge of Xojo, SQL, and object-oriented design.
The Concept of Symptoms
A health disorder, be it illness or injury, is always heralded by symptoms,
deviationsfrom what is normal baseline health. These symptoms often vary in length and type. Some are acute, lasting for the duration of the disorder. When the disorder is treated or when it goes into remission, the symptoms themselves disappear. Other symptoms are chronic, outlasting the disorder, leaving permanent effects.
In general, there are two types of symptoms:
presentedand medical. Presented symptoms are those experiencedby user-patients. It may be some sort of pain, persistent or mobile. It may be a sensation, like a tingling feeling in one's skin or "stars" in one's field of vision. It may be a limitation, such as a locked wrist or a weak grip. It may also be an absence such as being unable to sweat.
...End of Excerpt. Please purchase the magazine to read the full article.