DakotaRidge
Member
- Local time
- Today, 00:57
- Joined
- Jul 21, 2025
- Messages
- 97
Thanks, GaP42. The purpose of my Personal Finance and Health database is only to help my family with these two needs. The database is not designed to be a commercial product that has data about the 7,000 diseases, all medicines, and all food products. That would be waaaaaaaaay over my head.Just as a side note - your reliance on Myers Briggs may be somewhat over confidence: to quote from wikipedia:
And further:
Whether that has an impact on your design that is another matter. Such personality / psychological tests are often subject to revision as further knowledge develops, however Myers Briggs is well known for having a flawed methodology in its development.
And just as a further aside, as someone who has been involved in the health system and disease monitoring, the range of disease, the categorisations, the symptoms that pertain to each, the drugs that might be prescribed for each is a VERY complex field. You could spend a lifetime, full time in simply maintaining an accurate representation of this: two areas I have had experience with is the International Classification of Diseases (US uses ICD-9 - as a means of cost management, however when I left work we were on ICD 10 and moving to ICD 11) and SNOMED CT - the Systematized Nomenclature of Medicine: Clinical Terminology, and that does not include the linkage the drugs, commercial names and dosages. Good luck with that. I would not go near trying to implement, as seems to be your want with a barge pole - full listing of SNOMED CT on your access db as it will exceed to 2GB limit. Rather you need to be able to be flexible to add in sensibly only those items that are actually experienced by your "clients" - in a generic normalised schema where a disease is experienced by one or more people (for a duration or chronic) treated though various modalities/ procedures/ drugs (with different effectiveness/side-effects), with changing status of disease progression, and changing reported symptoms (that may or may not relate to that disease). At a simple level a client has one or more diseases. They may also undergo one or more treatments for a disease (a principally for the treatment of the specific disease experienced because some may treat more than one disease type) - so unlike what appears in your database - the drugs used by a client in the treatment of a specific disease can be identified with the specific dosage/ frequency applied for a specified period of time
I purchased a copy of Mosby's a month or two ago from a Goodwill-like store. I may need to take a class in medicine to make good use of it. It's a thousand pages.
Yes, some psyches have attacked MBTI for years. I took a leadership workshop when I was in the federal government, and the consultants running the workshop used MBTI. I let it sit for about two decades, but when I was working on a proposal management database several years ago, I decided to use it to help proposal professionals understand members of their teams. I figured that it was better to use MBTI than nothing. I considered using The Big Five and the Golden Personality Profile, but I never found enough literature to understand those systems. The literature for MBTI, on the other hand, is extensive. I even called and talked to John Golden one day. I would gladly use Golden if there was enough literature for it. John was living in Coral Gables, Florida, when we talked. I am from Florida.
My goal is not to recommend treatments for diseases or illnesses. My goal is to make family members aware of the costs of not dealing with medical issues early. I figure that a person should have one or two physicals each year, go to a doctor when he/she notices an issue. and plan for more medical expenses in later life.
I have only been building health capabilities into my database for the past three months. Again, the main focus is on the cost. I pay my medical costs using a health insurance plan that I started decades ago when I was in the government. I am also on Medicare.
Because of my personality, via MBTI, there are medical things I will and will not do. I have no problem with vaccinations, but I will refuse any surgery, and I won't take blood samples for diabetes.
MBTI nails my personality to a T, which is why I like it. Only about 3% of the population has my personality. So when database developers disagree with the way that I develop databases, I know why. I am a visual thinker, I am an introvert, and I am not judgmental.
My database may have fields for dosages and frequency, but the focus is on test results. My doctor runs 46 tests on me. See my previous posts.