HEM Database schema

**astralcreep** · 02-05-2009, 07:58 AM

Hi,

I was just wondering is there is a document which describes the holdem manager database schema. Something similar to the PT3 schema document.

Are there any other resources that would be useful for understanding the schema structure?

Cheers,

A

**Al1** · 02-05-2009, 12:41 PM

Escalated to Roy (Programmer), he will answer asap.

**Rvg72** · 02-08-2009, 01:43 AM

Hi, we don't currently have a document like this that is publicly available however in the Reports forum there is a lot of discussion about various tables and columns and for some of the main tables some details on the various values

Roy

**Suiteng** · 10-21-2012, 07:03 AM

Originally Posted by Rvg72

Hi, we don't currently have a document like this that is publicly available however in the Reports forum there is a lot of discussion about various tables and columns and for some of the main tables some details on the various values

Roy

i can not find the reports forum, could you please give me a link to the discussion threads you mentioned before?

**fozzy71** · 10-21-2012, 08:04 PM

The old sub-forums were all merged to this forum and all of the old stickied threads were lost as a result. I recreated one of the stickies here - Formulas for every HM1 Stat! (Updated Nov 12, 2009)

If you need further info you will need to search this main forum for it. With HM1 you can enable logging in PSQL and use the logs to better understand the schema but we do not have a documented schema. HM2 will soon have an exposed API via the HM Query Language that third party developers can use to access the HM2 database but that is a ways off yet.

**Suiteng** · 10-22-2012, 05:46 PM

hi im currently working with HM2 database, are there similiar formulas for HM2 stat? the one for HM1 was very useful.

**fozzy71** · 10-22-2012, 07:18 PM

Originally Posted by Suiteng

hi im currently working with HM2 database, are there similiar formulas for HM2 stat? the one for HM1 was very useful.

There are not similar stats available yet for the HM2 database. In our next release we will begin to implement the new HMQL (Holdem Manager Query Language) for third party developers to get the information they need but it will take some time for us to write the FAQ with the associated HMQL code that you will need to access the information and expand on the features of the initial HMQL release.