Hello @JesusCalvo and welcome to the OpenEMR community. I hope you find all the answers you’re looking for. Since this your first post I will assume you are not very familiar with the OpenEMR project or the resources available. Let me give some links to articles in the OpenEMR wiki which may help in your mission.
Yes, OpenEMR is capable of helping you with all those things. To run through your list of items:
- getting started: not sure if you mean the very beginning step of installing OpenEMR? If so, here’s the tip of the iceberg
https://www.open-emr.org/wiki/index.php/OpenEMR_Installation_Guides
- The default OpenEMR database is a MySQL database and if you install a database front- end such as adminer or phpMySQL you can have direct access to run queries and manipulate the database structure itself.
Here’s a wiki article that looks at the most basic beginning of this is. Though note that using the main menu to access the database is obsolete; you’ll need to use the standalone DBMS you installed.
https://www.open-emr.org/wiki/index.php/HOWTO:_Create_And_Use_Database_Views
Then there’s this, which may have evolved in the 2 versions of OpenEMR that have been developed since it was written.
https://www.open-emr.org/wiki/index.php/Database_Structure
The interoperability standards are all addressed and used to varying degrees in OpenEMR, but it’s too intricate to discuss fully in this post. Here’s some clue about how you can do some of your own focussed research.
The OpenEMR org has three main repositories of information on the project:
-
this forum in which you can find the answers given to other users when they asked questions. Search for topics with the search tool:
-
The OpenEMR wiki, which is the static repository of documentation. Here’s a forum post talking about finding your way around the wiki:
- git-hub, for the developer’s view of OpenEMR, if you’re into that. Just go to the wiki and search on that term, then start burrowing through the links!
I know this is a lot to digest at once! If/ when you develop specific questions come on back here and ask them, in the posting category most closely related to your topic.
I’m looking forward to hearing from you!
Best- Harley