Database Documentation

[gramulka66]

Our company has decided to use JBPM (3.2.1) and as database administrator I am looking for some database documentation, which can help me understand the use of the tables. Even better a explanation of the columns in the tables.
In any case; Can somebody point me to some database documentation?

[kukeltje]

there is a nice sticky post at the top of this forum about the data model. It is for 3.1 but mostly the same for 3.2

[gramulka66]

I see. To be honest I was hoping for more details regarding the columns. In any case it gives you a nice overview. Thanks for you answer.

[kukeltje]

what kind of details regarding the colums? with the jbpm source it is possible to generate ddl scripts for all kinds of databases. Ask one of the developers in your company to help out. If you want even more info, please ask, but in more detail what you want to know.

btw, the indexes are not optimized for all queries. There might be some work for you there to tune that in your specific environment.

[gramulka66]

What I am looking for is some kind of the database reference guide, which include a short description of the columns (or I other words, what kind of information does the column hold). The optimal would be, if you from the column name could get a picture of the contents. Example; with a column named personaddress, I would assume the column hold a persons address. But what it the column is named tokenindex, then I would have no idea (it might be lack of JBPM understanding).
Hope it is more clear now.............