Health Organizer Code

Team changes:
- about form with team information

When I ask to make a person a doctor and I answer no, it asks me to save anyway. May be the same problem is present with "make it a patient"

Unit of measurements conversion

Request of reference country to set up the data (i.e. °C or °F, Kg or lbs, etc.)

Copyright: year written automatically
Do not translate the author and the website in the about
Comments in the translation (like: "Do not translate")

Category of doctors (one fixed: "family doctor" that is used to filter the doctors to assign to the patients).
When you change a doctor assigned to a patient, ask if it was a mistake or the new doctor. If it's the new doctor, take an history of this

Name, surname, country, city and all the information to write inside the USB pen MUST BE written also in "clear words" for languages like Japanese/Chinese
Find some Japanese / Chinese doctor to test this...

Highlight (select) the start language in the menů

In the "safe life" USB  stick, write that I/HOR is not responsable of the data inserted by the user and suggest to contact the referent doctor to be sure the written data are correct.

Check/implement SSL db connection

Trace:
- natural father, mother
- legal father, mother
- brothers, sisters
- rent uterus
- transplants

Parking with GIS

Trigger on each table to trace the changes
Possibility to look at the changes
Delete the changes after X day

Check the xmin and the changes before to save the changes to handle different changes from different users in the same record

Login names for the program = PostgreSQL login user

Notes as extra information of the picture document. I.e. I have a JPG with some results and I store graphical objects information to show/hide on it.
In this way I can highlight some part, type notes, etc., but I also can print out the original document as it is 

Add the "Hippocratic Oath" in the about information?
Low priority
------------
Look if it is possible to create a class from TSQLTransaction that doesn't any transaction of to avoid the transaction start to avoid the ExecuteDirect in hor_dbopen.pas or implement CreateDb in the connection component or make the transaction a new option

Data import:
http://www.dados.gov.pt/pt/inicio/Inicio.aspx
http://www.infarmed.pt/portal/page/portal/INFARMED
http://www.atlasdasaude.pt/lista-de-medicamentos-infarmed



To create the SQL from the database use:
pg_dump --no-owner --no-privileges --inserts --username=postgres healthorganizer > mydb.sql
and after edit mydb.sql to comment out the line "COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';"
and, may be, to fix the serial start number ('setval(') and/or delete not wanted data ('insert into "t')