Omaha Database schema

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Omaha Database schema

Postby NKL300 » Mon Sep 13, 2010 10:14 am

Hi Guys,

Is this available and are their flags for wraps and/or number of outs and nut outs?

Cheers
NKL300
 
Posts: 8
Joined: Sat Sep 04, 2010 12:33 pm

Re: Omaha Database schema

Postby kraada » Mon Sep 13, 2010 12:26 pm

It doesn't appear the schema has been updated yet to include omaha.

There are no flags for wraps or specific entries for outs (or nut outs) at this point in time.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Omaha Database schema

Postby NKL300 » Mon Sep 13, 2010 4:11 pm

Can you publish it or attach to this post?
NKL300
 
Posts: 8
Joined: Sat Sep 04, 2010 12:33 pm

Re: Omaha Database schema

Postby kraada » Mon Sep 13, 2010 5:18 pm

If you are capable of reading the SQL notation, it's actually already on your machine in the file schema.postgres.sql - it's a text file that you can open in notepad/wordpad/Word or any similar program. I don't have a pretty PDF-ized version for you or I'd gladly attach it for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Omaha Database schema

Postby NKL300 » Mon Sep 13, 2010 8:24 pm

Thanks, got it

Is there a way of telling what someone lowest holdcard ID is for a certain action.

PFR >= 91 and therefore its easy to find the bottom of their raising range?

Is this possible for a report or HUD :twisted:
NKL300
 
Posts: 8
Joined: Sat Sep 04, 2010 12:33 pm

Re: Omaha Database schema

Postby kraada » Tue Sep 14, 2010 8:48 am

Not through a custom statistic; you could build this as a custom report, but the id numbers aren't sorted by overall strength. id 1 is AAAA, id 2 is AAAK, id 3 is AAAQ and so on.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests