Greetings, my question is if I can find somewhere Entity Relationship Diagram of Database OpenProject, the work that I do is join two data bases OpenProject (each with enough information).
I think the entity relationship diagram may not be quite as helpful since it is quite big.
Could you tell a bit more which data base tables you want to join?
Maybe the data you want to use can easier be retrieved by the API.
The idea is to make the union of two data bases OpenProject one, am writing a script in PHP to q Realize work, we know that there is big problems with ‘id’ in the tables generated automatically, but I managed to solve that problem .
Achieve merge the two databases but when displaying the projects does not display my module “WIKI” in the migrated projects.
Please I would like to receive information about the required tables for the module is found wikis enabled on projects OpenProject
Attached a picture which shows that the module is not shown wikis (noting that the migrated projects consist of wikis and the option modules in the general configuration is at-enabled wikis)
Replies (4)
Hi Ariel,
I think the entity relationship diagram may not be quite as helpful since it is quite big.
Could you tell a bit more which data base tables you want to join?
Maybe the data you want to use can easier be retrieved by the API.
Best,
Robin
Many Thanks for the reply Robin.
The idea is to make the union of two data bases OpenProject one, am writing a script in PHP to q Realize work, we know that there is big problems with ‘id’ in the tables generated automatically, but I managed to solve that problem .
Achieve merge the two databases but when displaying the projects does not display my module “WIKI” in the migrated projects.
Please I would like to receive information about the required tables for the module is found wikis enabled on projects OpenProject
Attached a picture which shows that the module is not shown wikis (noting that the migrated projects consist of wikis and the option modules in the general configuration is at-enabled wikis)
Thank you very much.
Hi Ariel,
please find attached an entity relationship diagram of OpenProject (core).
The attachment is called “Entity-Relationship-Diagram-OpenProject”.
Not sure how helpful this is for what you want to accomplish but it provides an overview.
Best,
Robin
Thank you very much Robin.
I will work on my project following this model