=============== EARLY DRAFT =================

Purpose:
As we dig through dozens and dozens of cases we are finding trends and common individuals and organizations. A db tool will be helpful in identifying these commonalities.

Suggested Schema Items:

Victim
- Age/dob
- first, middle, last name
- Current address (usually asylum)
- Current phone
- City Appraisal District record
- Previous address (usually liquidated home)
- – City Appraisal District record
- Date liquidated
- Previous phone
- Date taken into custody
- Hospital(s)
- Rehab facility
- – City Appraisal District record of all property owned

Mother
- first, middle, last name
- Current address
- City Appraisal District record
- Current phone
- Age
- – City Appraisal District record of all property owned
Father
- first, middle, last name
- Current address
- City Appraisal District record
- Current phone
- Age
- – City Appraisal District record of all property owned
Husband(s)
- first, middle, last name
- Current address
- City Appraisal District record
- Current phone
- Age
- – City Appraisal District record of all property owned
Wives(s)
- first, middle, last name
- Current address
- City Appraisal District record
- Current phone
- Age
- – City Appraisal District record of all property owned
Son(s)
- first, middle, last name
- Current address
- City Appraisal District record
- Current phone
- Age
- – City Appraisal District record of all property owned
Daugher(s)
- first, middle, last name
- Current address
- City Appraisal District record
- Current phone
- Age
- – City Appraisal District record of all property owned
Interested Party(s) (These individuals show up in court records and appear to be friends.)
- first, middle, last name
- Current address
- City Appraisal District record
- Current phone
- Age
- – City Appraisal District record of all property owned

============================
Guardian Ad Litem
- first, middle, last name
- Business address
- City Appraisal District record
- Business phone
- Home address
- City Appraisal District record
- Home phone
- Cell phone
- Age
- State license
- – City Appraisal District record of all property owned

**** Same for guardian’s wife(s), sons, daughters
============================

Same all items above for
- Guardian of the Person
- – State license
- Guardian of the Estate
- – State license
- Attorney At Litem
- – Bar record
- – Link to business advertisement(s)
- Attorney for the Guardian
- – Bar record
- – Link to business advertisement(s)
- Probate Judge
- Court Visitor (This is a volunteer investigator for some cases.)
- Applicant (This is the individual causing the victim to be taken into custody.)
- APS social worker
- – Link to state license
- APS supervisor
- – Link to state license
- Investigating psychiatrist
- – Link to state license
- – Link to business advertisement(s)
- Investigating psychologist(s)
- – Link to state license
- – Link to business advertisement(s)
- Other doctor(s)
- – Link to state license
- – Link to business advertisement(s)
- Other individual(s)
- – Relationshiop
============================