Poker Tracker Omaha Database Diagram

Project
Diagram	pokertracker_omaha
Company
Author
Version
Created	02/04/2008 9:16:09 PM
Last modified	02/04/2008 9:17:26 PM

Database Description
Database Annotation

Database Name	Database_1
Database Character Set
Comment
Database Create SQL	CREATE DATABASE "Database_1";

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
blind_structure_id	int2	NO	NO	NO
blind_structure_desc	text	NO	NO	NO
big_bet	int4	NO	NO	NO

IndexName	Columns
blind_structure_idx_01	blind_structure_id
blind_structure_idx_02	blind_structure_desc

ConstraintName	ConstraintKind	Check Expression	Columns
blind_structure_idx_02	UNIQUE		blind_structure_desc
blind_structure_idx_01	UNIQUE		blind_structure_id

Table Create SQL

CREATE TABLE "public"."blind_structure" (
  "blind_structure_id" int2,
  "blind_structure_desc" text,
  "big_bet" int4,
  CONSTRAINT "blind_structure_idx_02" UNIQUE("blind_structure_desc"),
  CONSTRAINT "blind_structure_idx_01" UNIQUE("blind_structure_id")
)
WITHOUT OIDS;

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
window	text	NO	NO	NO
datawindow	text	NO	NO	NO
pref_key	text	NO	NO	NO
custom_id	int4	NO	NO	NO
custom_name	text	NO	NO	NO
preference	text	NO	NO	NO
user_preferred	int2	NO	NO	NO

IndexName	Columns
datawindow_prefs_idx1	window,datawindow,pref_key,custom_id

ConstraintName	ConstraintKind	Check Expression	Columns
datawindow_prefs_idx1	UNIQUE		window,datawindow,pref_key,custom_id

Table Create SQL

CREATE TABLE "public"."datawindow_prefs" (
  "window" text,
  "datawindow" text,
  "pref_key" text,
  "custom_id" int4,
  "custom_name" text,
  "preference" text,
  "user_preferred" int2,
  CONSTRAINT "datawindow_prefs_idx1" UNIQUE("window","datawindow","pref_key","custom_id")
)
WITHOUT OIDS;

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
date_from	timestamp with time zone	NO	NO	NO
date_to	timestamp with time zone	NO	NO	NO
dst_value	int2	NO	NO	NO

IndexName

Columns

ConstraintName

ConstraintKind

Check Expression

Columns

Table Create SQL

CREATE TABLE "public"."dst" (
  "date_from" timestamp with time zone,
  "date_to" timestamp with time zone,
  "dst_value" int2
)
WITHOUT OIDS;

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
date_written	timestamp	NO	NO	NO
file_name	text	NO	NO	NO
error_msg	text	NO	NO	NO
came_from	text	NO	NO	NO

IndexName	Columns
error_msgs_idx01	date_written
error_msgs_idx02	came_from

ConstraintName

ConstraintKind

Check Expression

Columns

Table Create SQL

CREATE TABLE "public"."error_msgs" (
  "date_written" timestamp,
  "file_name" text,
  "error_msg" text,
  "came_from" text
)
WITHOUT OIDS;

CREATE INDEX "error_msgs_idx01" ON "public"."error_msgs" USING BTREE ("date_written");
CREATE INDEX "error_msgs_idx02" ON "public"."error_msgs" USING BTREE ("came_from");

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
exdate	timestamp with time zone	NO	NO	NO
usd	float4	NO	NO	NO
gbp	float4	NO	NO	NO
euro	float4	NO	NO	NO

IndexName	Columns
exrates_idx_01	exdate

ConstraintName	ConstraintKind	Check Expression	Columns
exrates_idx_01	UNIQUE		exdate

Table Create SQL

CREATE TABLE "public"."exrates" (
  "exdate" timestamp with time zone,
  "usd" float4,
  "gbp" float4,
  "euro" float4,
  CONSTRAINT "exrates_idx_01" UNIQUE("exdate")
)
WITHOUT OIDS;

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
game_id	int4	NO	NO	NO
game_number	int8	NO	NO	NO
site_id	int2	NO	NO	NO
date_played	timestamp with time zone	NO	NO	NO
game_level_id	int2	NO	NO	NO
flop_1	varchar(2)	NO	NO	NO
flop_2	varchar(2)	NO	NO	NO
flop_3	varchar(2)	NO	NO	NO
turn	varchar(2)	NO	NO	NO
river	varchar(2)	NO	NO	NO
pot	float4	NO	NO	NO
rake	float4	NO	NO	NO
player_id	int4	NO	NO	NO
player_id_low	int4	NO	NO	NO
import_date	timestamp with time zone	NO	NO	NO
game_notes	text	NO	NO	NO
table_name	text	NO	NO	NO
winning_hand	text	NO	NO	NO
winning_hand_low	text	NO	NO	NO
real_player_id	int4	NO	NO	NO
real_player_id_low	int4	NO	NO	NO
players_saw_flop	int2	NO	NO	NO
number_of_players	int2	NO	NO	NO
ub_game_number	text	NO	NO	NO
ub_kill_game	int2	NO	NO	NO
low_possible	int2	NO	NO	NO
cur_ind	float4	NO	NO	NO
exrate	float4	NO	NO	NO

IndexName	Columns
game_idx_01	game_id
game_idx_02	game_number,site_id
game_idx_03	ub_game_number
game_idx_04	date_played
game_idx_05	real_player_id

ConstraintName	ConstraintKind	Check Expression	Columns
game_idx_01	UNIQUE		game_id
game_idx_03	UNIQUE		ub_game_number
game_idx_02	UNIQUE		game_number,site_id

Table Create SQL

CREATE TABLE "public"."game" (
  "game_id" int4,
  "game_number" int8,
  "site_id" int2,
  "date_played" timestamp with time zone,
  "game_level_id" int2,
  "flop_1" varchar(2),
  "flop_2" varchar(2),
  "flop_3" varchar(2),
  "turn" varchar(2),
  "river" varchar(2),
  "pot" float4,
  "rake" float4,
  "player_id" int4,
  "player_id_low" int4,
  "import_date" timestamp with time zone,
  "game_notes" text,
  "table_name" text,
  "winning_hand" text,
  "winning_hand_low" text,
  "real_player_id" int4,
  "real_player_id_low" int4,
  "players_saw_flop" int2,
  "number_of_players" int2,
  "ub_game_number" text,
  "ub_kill_game" int2,
  "low_possible" int2,
  "cur_ind" float4,
  "exrate" float4,
  CONSTRAINT "game_idx_01" UNIQUE("game_id"),
  CONSTRAINT "game_idx_03" UNIQUE("ub_game_number"),
  CONSTRAINT "game_idx_02" UNIQUE("game_number","site_id")
)
WITHOUT OIDS;

CREATE INDEX "game_idx_04" ON "public"."game" USING BTREE ("date_played");
CREATE INDEX "game_idx_05" ON "public"."game" USING BTREE ("real_player_id");

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
game_level_id	int2	NO	NO	NO
game_level_desc	text	NO	NO	NO
game_type_id	int2	NO	NO	NO
game_level_big_bet	float4	NO	NO	NO
pl_nl	int2	NO	NO	NO

IndexName	Columns
game_level_idx_01	game_level_id
game_level_idx_02	game_level_desc

ConstraintName	ConstraintKind	Check Expression	Columns
game_level_idx_02	UNIQUE		game_level_desc
game_level_idx_01	UNIQUE		game_level_id

Table Create SQL

CREATE TABLE "public"."game_level" (
  "game_level_id" int2,
  "game_level_desc" text,
  "game_type_id" int2,
  "game_level_big_bet" float4,
  "pl_nl" int2,
  CONSTRAINT "game_level_idx_02" UNIQUE("game_level_desc"),
  CONSTRAINT "game_level_idx_01" UNIQUE("game_level_id")
)
WITHOUT OIDS;

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
game_id	int4	NO	NO	NO
player_id	int4	NO	NO	NO
seat_number	int2	NO	NO	NO
button	int2	NO	NO	NO
hole_card_1	varchar(2)	NO	NO	NO
hole_card_2	varchar(2)	NO	NO	NO
hole_card_3	varchar(2)	NO	NO	NO
hole_card_4	varchar(2)	NO	NO	NO
suited	varchar(4)	NO	NO	NO
pre_flop_bet	float4	NO	NO	NO
flop_bet	float4	NO	NO	NO
turn_bet	float4	NO	NO	NO
river_bet	float4	NO	NO	NO
total_bet	float4	NO	NO	NO
total_won	float4	NO	NO	NO
when_folded	text	NO	NO	NO
played_hand	varchar(1)	NO	NO	NO
player_notes	text	NO	NO	NO
final_hand	text	NO	NO	NO
final_hand_low	text	NO	NO	NO
hand_rank_id	int2	NO	NO	NO
all_in	int2	NO	NO	NO
forced_all_in	int2	NO	NO	NO
hole_cards	varchar(4)	NO	NO	NO
card_order1	int2	NO	NO	NO
card_order2	int2	NO	NO	NO
card_order3	int2	NO	NO	NO
card_order4	int2	NO	NO	NO
connector_hand	int2	NO	NO	NO
connector_hand2	int2	NO	NO	NO
connector_hand2g	int2	NO	NO	NO
connector_hand3	int2	NO	NO	NO
pair_hand	int2	NO	NO	NO
pair_hand2	int2	NO	NO	NO
trip_hand	int2	NO	NO	NO
won_hand	int2	NO	NO	NO
won_low	int2	NO	NO	NO
session_id	int4	NO	NO	NO
off_the_button	int2	NO	NO	NO
number_of_players	int2	NO	NO	NO
big_blind_n	int2	NO	NO	NO
small_blind_n	int2	NO	NO	NO
pre_flop_raise_n	int2	NO	NO	NO
flop_raise_n	int2	NO	NO	NO
flop_ck_raise_n	int2	NO	NO	NO
turn_bet_raise_n	int2	NO	NO	NO
turn_bet_ck_raise_n	int2	NO	NO	NO
river_bet_raise_n	int2	NO	NO	NO
river_bet_ck_raise_n	int2	NO	NO	NO
went_to_showdown_n	int2	NO	NO	NO
saw_flop_n	int2	NO	NO	NO
saw_flop_blind_n	int2	NO	NO	NO
attempted_steal	int2	NO	NO	NO
chance_to_steal	int2	NO	NO	NO
steal_attempted	int2	NO	NO	NO
folded_to_steal_attempt	int2	NO	NO	NO
raised_first_pf	int2	NO	NO	NO
vol_put_money_in_pot	int2	NO	NO	NO
limp_with_prev_callers	int2	NO	NO	NO
ppossible_actions	int2	NO	NO	NO
pfold	int2	NO	NO	NO
pcheck	int2	NO	NO	NO
praise	int2	NO	NO	NO
pcall	int2	NO	NO	NO
limp_call_reraise_pf	int2	NO	NO	NO
pfr_check	int2	NO	NO	NO
pfr_call	int2	NO	NO	NO
pfr_fold	int2	NO	NO	NO
pfr_bet	int2	NO	NO	NO
pfr_raise	int2	NO	NO	NO
folded_to_river_bet	int2	NO	NO	NO
fpossible_actions	int2	NO	NO	NO
ffold	int2	NO	NO	NO
fcheck	int2	NO	NO	NO
fbet	int2	NO	NO	NO
fraise	int2	NO	NO	NO
fcall	int2	NO	NO	NO
tpossible_actions	int2	NO	NO	NO
tfold	int2	NO	NO	NO
tcheck	int2	NO	NO	NO
tbet	int2	NO	NO	NO
traise	int2	NO	NO	NO
tcall	int2	NO	NO	NO
rpossible_actions	int2	NO	NO	NO
rfold	int2	NO	NO	NO
rcheck	int2	NO	NO	NO
rbet	int2	NO	NO	NO
rraise	int2	NO	NO	NO
rcall	int2	NO	NO	NO
blind_amt	float4	NO	NO	NO
real_player_id	int4	NO	NO	NO
cold_call_pf	int2	NO	NO	NO
steal_hu_chance	int2	NO	NO	NO
steal_hu_fold	int2	NO	NO	NO
chip_count	float4	NO	NO	NO
ub_kill_blind	int2	NO	NO	NO

IndexName	Columns
game_players_idx_01	game_id,player_id
game_players_idx_02	player_id,session_id
game_players_idx_03	session_id
game_players_idx_04	real_player_id
game_players_idx_05	player_id

ConstraintName	ConstraintKind	Check Expression	Columns
game_players_idx_01	UNIQUE		game_id,player_id

Table Create SQL

CREATE TABLE "public"."game_players" (
  "game_id" int4,
  "player_id" int4,
  "seat_number" int2,
  "button" int2,
  "hole_card_1" varchar(2),
  "hole_card_2" varchar(2),
  "hole_card_3" varchar(2),
  "hole_card_4" varchar(2),
  "suited" varchar(4),
  "pre_flop_bet" float4,
  "flop_bet" float4,
  "turn_bet" float4,
  "river_bet" float4,
  "total_bet" float4,
  "total_won" float4,
  "when_folded" text,
  "played_hand" varchar(1),
  "player_notes" text,
  "final_hand" text,
  "final_hand_low" text,
  "hand_rank_id" int2,
  "all_in" int2,
  "forced_all_in" int2,
  "hole_cards" varchar(4),
  "card_order1" int2,
  "card_order2" int2,
  "card_order3" int2,
  "card_order4" int2,
  "connector_hand" int2,
  "connector_hand2" int2,
  "connector_hand2g" int2,
  "connector_hand3" int2,
  "pair_hand" int2,
  "pair_hand2" int2,
  "trip_hand" int2,
  "won_hand" int2,
  "won_low" int2,
  "session_id" int4,
  "off_the_button" int2,
  "number_of_players" int2,
  "big_blind_n" int2,
  "small_blind_n" int2,
  "pre_flop_raise_n" int2,
  "flop_raise_n" int2,
  "flop_ck_raise_n" int2,
  "turn_bet_raise_n" int2,
  "turn_bet_ck_raise_n" int2,
  "river_bet_raise_n" int2,
  "river_bet_ck_raise_n" int2,
  "went_to_showdown_n" int2,
  "saw_flop_n" int2,
  "saw_flop_blind_n" int2,
  "attempted_steal" int2,
  "chance_to_steal" int2,
  "steal_attempted" int2,
  "folded_to_steal_attempt" int2,
  "raised_first_pf" int2,
  "vol_put_money_in_pot" int2,
  "limp_with_prev_callers" int2,
  "ppossible_actions" int2,
  "pfold" int2,
  "pcheck" int2,
  "praise" int2,
  "pcall" int2,
  "limp_call_reraise_pf" int2,
  "pfr_check" int2,
  "pfr_call" int2,
  "pfr_fold" int2,
  "pfr_bet" int2,
  "pfr_raise" int2,
  "folded_to_river_bet" int2,
  "fpossible_actions" int2,
  "ffold" int2,
  "fcheck" int2,
  "fbet" int2,
  "fraise" int2,
  "fcall" int2,
  "tpossible_actions" int2,
  "tfold" int2,
  "tcheck" int2,
  "tbet" int2,
  "traise" int2,
  "tcall" int2,
  "rpossible_actions" int2,
  "rfold" int2,
  "rcheck" int2,
  "rbet" int2,
  "rraise" int2,
  "rcall" int2,
  "blind_amt" float4,
  "real_player_id" int4,
  "cold_call_pf" int2,
  "steal_hu_chance" int2,
  "steal_hu_fold" int2,
  "chip_count" float4,
  "ub_kill_blind" int2,
  CONSTRAINT "game_players_idx_01" UNIQUE("game_id","player_id")
)
WITHOUT OIDS;

CREATE INDEX "game_players_idx_02" ON "public"."game_players" USING BTREE ("player_id" , "session_id");
CREATE INDEX "game_players_idx_03" ON "public"."game_players" USING BTREE ("session_id");
CREATE INDEX "game_players_idx_04" ON "public"."game_players" USING BTREE ("real_player_id");
CREATE INDEX "game_players_idx_05" ON "public"."game_players" USING BTREE ("player_id");

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
game_number	int8	NO	NO	NO
site_id	int2	NO	NO	NO
hand_history	text	NO	NO	NO
import_date	timestamp with time zone	NO	NO	NO

IndexName	Columns
hand_histories_idx_01	game_number,site_id,import_date

ConstraintName	ConstraintKind	Check Expression	Columns
hand_histories_idx_01	UNIQUE		game_number,site_id,import_date

Table Create SQL

CREATE TABLE "public"."hand_histories" (
  "game_number" int8,
  "site_id" int2,
  "hand_history" text,
  "import_date" timestamp with time zone,
  CONSTRAINT "hand_histories_idx_01" UNIQUE("game_number","site_id","import_date")
)
WITHOUT OIDS;

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
hand_rank_id	int2	NO	NO	NO
hand_rank_desc	text	NO	NO	NO

IndexName	Columns
hand_rank_idx_01	hand_rank_id

ConstraintName	ConstraintKind	Check Expression	Columns
hand_rank_idx_01	UNIQUE		hand_rank_id

Table Create SQL

CREATE TABLE "public"."hand_rank" (
  "hand_rank_id" int2,
  "hand_rank_desc" text,
  CONSTRAINT "hand_rank_idx_01" UNIQUE("hand_rank_id")
)
WITHOUT OIDS;

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
date_played	timestamp with time zone	NO	NO	NO
game_level_id	int2	NO	NO	NO
site_id	int2	NO	NO	NO
player_id	int4	NO	NO	NO
session_id	int4	NO	NO	NO
opponent_id	int4	NO	NO	NO
won_from	float4	NO	NO	NO
times_beat	int2	NO	NO	NO
real_player_id	int4	NO	NO	NO
real_opp_id	int4	NO	NO	NO

IndexName	Columns
player_winnings_idx_01	real_player_id
player_winnings_idx_02	player_id
player_winnings_idx_ad	session_id

ConstraintName

ConstraintKind

Check Expression

Columns

Table Create SQL

CREATE TABLE "public"."player_winnings" (
  "date_played" timestamp with time zone,
  "game_level_id" int2,
  "site_id" int2,
  "player_id" int4,
  "session_id" int4,
  "opponent_id" int4,
  "won_from" float4,
  "times_beat" int2,
  "real_player_id" int4,
  "real_opp_id" int4
)
WITHOUT OIDS;

CREATE INDEX "player_winnings_idx_01" ON "public"."player_winnings" USING BTREE ("real_player_id");
CREATE INDEX "player_winnings_idx_02" ON "public"."player_winnings" USING BTREE ("player_id");
CREATE INDEX "player_winnings_idx_ad" ON "public"."player_winnings" USING BTREE ("session_id");

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
player_id	int4	NO	NO	NO
screen_name	text	NO	NO	NO
location	text	NO	NO	NO
general_description	text	NO	NO	NO
treeview_icon	int2	NO	NO	NO
site_id	int2	NO	NO	NO
alias_id	int4	NO	NO	NO
main_site_id	int2	NO	NO	NO
hide_ind	int2	NO	NO	NO
ring_player	int2	NO	NO	NO
tourney_player	int2	NO	NO	NO
tourney_hide_ind	int2	NO	NO	NO
last_icon	int2	NO	NO	NO
last_auto_rated	timestamp with time zone	NO	NO	NO
last_batch_rated	timestamp with time zone	NO	NO	NO
icon_before_batch_rate	int2	NO	NO	NO
no_auto_rate	int2	NO	NO	NO
icon_file	text	NO	NO	NO

IndexName	Columns
player_idx_01	screen_name,main_site_id
player_idx_02	player_id
players_idx_03	main_site_id

ConstraintName	ConstraintKind	Check Expression	Columns
player_idx_02	UNIQUE		player_id
player_idx_01	UNIQUE		screen_name,main_site_id

Table Create SQL

CREATE TABLE "public"."players" (
  "player_id" int4,
  "screen_name" text,
  "location" text,
  "general_description" text,
  "treeview_icon" int2,
  "site_id" int2,
  "alias_id" int4,
  "main_site_id" int2,
  "hide_ind" int2,
  "ring_player" int2,
  "tourney_player" int2,
  "tourney_hide_ind" int2,
  "last_icon" int2,
  "last_auto_rated" timestamp with time zone,
  "last_batch_rated" timestamp with time zone,
  "icon_before_batch_rate" int2,
  "no_auto_rate" int2,
  "icon_file" text,
  CONSTRAINT "player_idx_02" UNIQUE("player_id"),
  CONSTRAINT "player_idx_01" UNIQUE("screen_name","main_site_id")
)
WITHOUT OIDS;

CREATE INDEX "players_idx_03" ON "public"."players" USING BTREE ("main_site_id");

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
site_id	int2	NO	NO	NO
site_abbrev	varchar(3)	NO	NO	NO
site_name	text	NO	NO	NO

IndexName	Columns
poker_sites_idx_01	site_id
poker_sites_idx_02	site_abbrev

ConstraintName	ConstraintKind	Check Expression	Columns
poker_sites_idx_02	UNIQUE		site_abbrev
poker_sites_idx_01	UNIQUE		site_id

Table Create SQL

CREATE TABLE "public"."poker_sites" (
  "site_id" int2,
  "site_abbrev" varchar(3),
  "site_name" text,
  CONSTRAINT "poker_sites_idx_02" UNIQUE("site_abbrev"),
  CONSTRAINT "poker_sites_idx_01" UNIQUE("site_id")
)
WITHOUT OIDS;

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
pref_key	varchar(20)	NO	NO	NO
pref_value	varchar(50)	NO	NO	NO
long_pref	text	NO	NO	NO

IndexName	Columns
prefs_idx_01	pref_key

ConstraintName	ConstraintKind	Check Expression	Columns
prefs_idx_01	UNIQUE		pref_key

Table Create SQL

CREATE TABLE "public"."prefs" (
  "pref_key" varchar(20),
  "pref_value" varchar(50),
  "long_pref" text,
  CONSTRAINT "prefs_idx_01" UNIQUE("pref_key")
)
WITHOUT OIDS;

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
session_id	int4	NO	NO	NO
player_id	int4	NO	NO	NO
session_start	timestamp with time zone	NO	NO	NO
session_end	timestamp with time zone	NO	NO	NO
table_name	text	NO	NO	NO
seat_number	int2	NO	NO	NO
session_notes	text	NO	NO	NO
game_level_id	int2	NO	NO	NO
amount_won	float4	NO	NO	NO
total_hands	int2	NO	NO	NO
site_id	int2	NO	NO	NO
vol_saw_flop	int2	NO	NO	NO
pre_flop_raise	int2	NO	NO	NO
att_steal	int2	NO	NO	NO
chance_to_steal	int2	NO	NO	NO
won_hand	int2	NO	NO	NO
went_to_sd	int2	NO	NO	NO
won_at_sd	int2	NO	NO	NO
real_player_id	int4	NO	NO	NO
tot_players	int2	NO	NO	NO
tot_saw_flop	int2	NO	NO	NO
tot_pot	float4	NO	NO	NO
cur_ind	float4	NO	NO	NO
exrate	float4	NO	NO	NO

IndexName	Columns
session_idx_01	session_id
session_idx_02	player_id
session_idx_03	session_start
session_idx_04	real_player_id

ConstraintName	ConstraintKind	Check Expression	Columns
session_idx_01	UNIQUE		session_id

Table Create SQL

CREATE TABLE "public"."session" (
  "session_id" int4,
  "player_id" int4,
  "session_start" timestamp with time zone,
  "session_end" timestamp with time zone,
  "table_name" text,
  "seat_number" int2,
  "session_notes" text,
  "game_level_id" int2,
  "amount_won" float4,
  "total_hands" int2,
  "site_id" int2,
  "vol_saw_flop" int2,
  "pre_flop_raise" int2,
  "att_steal" int2,
  "chance_to_steal" int2,
  "won_hand" int2,
  "went_to_sd" int2,
  "won_at_sd" int2,
  "real_player_id" int4,
  "tot_players" int2,
  "tot_saw_flop" int2,
  "tot_pot" float4,
  "cur_ind" float4,
  "exrate" float4,
  CONSTRAINT "session_idx_01" UNIQUE("session_id")
)
WITHOUT OIDS;

CREATE INDEX "session_idx_02" ON "public"."session" USING BTREE ("player_id");
CREATE INDEX "session_idx_03" ON "public"."session" USING BTREE ("session_start");
CREATE INDEX "session_idx_04" ON "public"."session" USING BTREE ("real_player_id");

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
tourney_id	int4	NO	NO	NO
site_id	int2	NO	NO	NO
tourney_number	int4	NO	NO	NO
tourney_start	timestamp with time zone	NO	NO	NO
tourney_end	timestamp with time zone	NO	NO	NO
buy_in	float4	NO	NO	NO
fee	float4	NO	NO	NO
tourney_type	int2	NO	NO	NO
table_type	int2	NO	NO	NO
start_game_number	int8	NO	NO	NO
end_game_number	int8	NO	NO	NO
summary_text	text	NO	NO	NO
target_tourney_number	int4	NO	NO	NO
number_of_players	int2	NO	NO	NO
tourney_notes	text	NO	NO	NO
summary_loaded	int2	NO	NO	NO
pp_table_name	text	NO	NO	NO
game_type_id	int2	NO	NO	NO

IndexName	Columns
tourney_idx_01	tourney_id
tourney_idx_02	site_id,tourney_number
tourney_idx_03	summary_loaded,tourney_start
tourney_idx_04	tourney_start

ConstraintName	ConstraintKind	Check Expression	Columns
tourney_idx_02	UNIQUE		site_id,tourney_number
tourney_idx_01	UNIQUE		tourney_id

Table Create SQL

CREATE TABLE "public"."tourney" (
  "tourney_id" int4,
  "site_id" int2,
  "tourney_number" int4,
  "tourney_start" timestamp with time zone,
  "tourney_end" timestamp with time zone,
  "buy_in" float4,
  "fee" float4,
  "tourney_type" int2,
  "table_type" int2,
  "start_game_number" int8,
  "end_game_number" int8,
  "summary_text" text,
  "target_tourney_number" int4,
  "number_of_players" int2,
  "tourney_notes" text,
  "summary_loaded" int2,
  "pp_table_name" text,
  "game_type_id" int2,
  CONSTRAINT "tourney_idx_02" UNIQUE("site_id","tourney_number"),
  CONSTRAINT "tourney_idx_01" UNIQUE("tourney_id")
)
WITHOUT OIDS;

CREATE INDEX "tourney_idx_03" ON "public"."tourney" USING BTREE ("summary_loaded" , "tourney_start");
CREATE INDEX "tourney_idx_04" ON "public"."tourney" USING BTREE ("tourney_start");

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
tourney_id	int4	NO	NO	NO
game_id	int4	NO	NO	NO
game_number	int8	NO	NO	NO
date_played	timestamp with time zone	NO	NO	NO
blind_structure_id	int2	NO	NO	NO
game_level	varchar(5)	NO	NO	NO
pp_game_number	int8	NO	NO	NO
flop_1	varchar(2)	NO	NO	NO
flop_2	varchar(2)	NO	NO	NO
flop_3	varchar(2)	NO	NO	NO
turn	varchar(2)	NO	NO	NO
river	varchar(2)	NO	NO	NO
pot	float4	NO	NO	NO
player_id	int4	NO	NO	NO
import_date	timestamp with time zone	NO	NO	NO
game_notes	text	NO	NO	NO
table_name	text	NO	NO	NO
winning_hand	text	NO	NO	NO
real_player_id	int4	NO	NO	NO
players_saw_flop	int2	NO	NO	NO
number_of_players	int2	NO	NO	NO
heads_up	int2	NO	NO	NO
ub_game_number	varchar(30)	NO	NO	NO
winning_hand_low	text	NO	NO	NO
player_id_low	int4	NO	NO	NO
real_player_id_low	int4	NO	NO	NO
low_possible	int2	NO	NO	NO

IndexName	Columns
tourney_game_idx_01	tourney_id,game_id
tourney_game_idx_02	tourney_id,game_number
tourney_game_idx_03	ub_game_number
tourney_game_idx_04	real_player_id

ConstraintName	ConstraintKind	Check Expression	Columns
tourney_game_idx_01	UNIQUE		tourney_id,game_id
tourney_game_idx_03	UNIQUE		ub_game_number
tourney_game_idx_02	UNIQUE		tourney_id,game_number

Table Create SQL

CREATE TABLE "public"."tourney_game" (
  "tourney_id" int4,
  "game_id" int4,
  "game_number" int8,
  "date_played" timestamp with time zone,
  "blind_structure_id" int2,
  "game_level" varchar(5),
  "pp_game_number" int8,
  "flop_1" varchar(2),
  "flop_2" varchar(2),
  "flop_3" varchar(2),
  "turn" varchar(2),
  "river" varchar(2),
  "pot" float4,
  "player_id" int4,
  "import_date" timestamp with time zone,
  "game_notes" text,
  "table_name" text,
  "winning_hand" text,
  "real_player_id" int4,
  "players_saw_flop" int2,
  "number_of_players" int2,
  "heads_up" int2,
  "ub_game_number" varchar(30),
  "winning_hand_low" text,
  "player_id_low" int4,
  "real_player_id_low" int4,
  "low_possible" int2,
  CONSTRAINT "tourney_game_idx_01" UNIQUE("tourney_id","game_id"),
  CONSTRAINT "tourney_game_idx_03" UNIQUE("ub_game_number"),
  CONSTRAINT "tourney_game_idx_02" UNIQUE("tourney_id","game_number")
)
WITHOUT OIDS;

CREATE INDEX "tourney_game_idx_04" ON "public"."tourney_game" USING BTREE ("real_player_id");

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
tourney_id	int4	NO	NO	NO
game_id	int4	NO	NO	NO
player_id	int4	NO	NO	NO
seat_number	int2	NO	NO	NO
button	int2	NO	NO	NO
hole_card_1	varchar(2)	NO	NO	NO
hole_card_2	varchar(2)	NO	NO	NO
suited	varchar(4)	NO	NO	NO
pre_flop_bet	float4	NO	NO	NO
flop_bet	float4	NO	NO	NO
turn_bet	float4	NO	NO	NO
river_bet	float4	NO	NO	NO
total_bet	float4	NO	NO	NO
total_won	float4	NO	NO	NO
when_folded	text	NO	NO	NO
final_hand	text	NO	NO	NO
hand_rank_id	int2	NO	NO	NO
all_in	int2	NO	NO	NO
forced_all_in	int2	NO	NO	NO
hole_cards	varchar(4)	NO	NO	NO
card_order1	int2	NO	NO	NO
card_order2	int2	NO	NO	NO
card_order3	int2	NO	NO	NO
connector_hand	int2	NO	NO	NO
pair_hand	int2	NO	NO	NO
won_hand	int2	NO	NO	NO
off_the_button	int2	NO	NO	NO
number_of_players	int2	NO	NO	NO
big_blind_n	int2	NO	NO	NO
small_blind_n	int2	NO	NO	NO
pre_flop_raise_n	int2	NO	NO	NO
flop_raise_n	int2	NO	NO	NO
flop_ck_raise_n	int2	NO	NO	NO
turn_bet_raise_n	int2	NO	NO	NO
turn_bet_ck_raise_n	int2	NO	NO	NO
river_bet_raise_n	int2	NO	NO	NO
river_bet_ck_raise_n	int2	NO	NO	NO
went_to_showdown_n	int2	NO	NO	NO
saw_flop_n	int2	NO	NO	NO
saw_flop_blind_n	int2	NO	NO	NO
attempted_steal	int2	NO	NO	NO
chance_to_steal	int2	NO	NO	NO
steal_attempted	int2	NO	NO	NO
folded_to_steal_attempt	int2	NO	NO	NO
raised_first_pf	int2	NO	NO	NO
vol_put_money_in_pot	int2	NO	NO	NO
limp_with_prev_callers	int2	NO	NO	NO
ppossible_actions	int2	NO	NO	NO
pfold	int2	NO	NO	NO
pcheck	int2	NO	NO	NO
pbet	int2	NO	NO	NO
praise	int2	NO	NO	NO
pcall	int2	NO	NO	NO
limp_call_reraise_pf	int2	NO	NO	NO
pfr_check	int2	NO	NO	NO
pfr_call	int2	NO	NO	NO
pfr_fold	int2	NO	NO	NO
pfr_bet	int2	NO	NO	NO
pfr_raise	int2	NO	NO	NO
folded_to_river_bet	int2	NO	NO	NO
fpossible_actions	int2	NO	NO	NO
ffold	int2	NO	NO	NO
fcheck	int2	NO	NO	NO
fbet	int2	NO	NO	NO
fraise	int2	NO	NO	NO
fcall	int2	NO	NO	NO
tpossible_actions	int2	NO	NO	NO
tfold	int2	NO	NO	NO
tcheck	int2	NO	NO	NO
tbet	int2	NO	NO	NO
traise	int2	NO	NO	NO
tcall	int2	NO	NO	NO
rpossible_actions	int2	NO	NO	NO
rfold	int2	NO	NO	NO
rcheck	int2	NO	NO	NO
rbet	int2	NO	NO	NO
rraise	int2	NO	NO	NO
rcall	int2	NO	NO	NO
real_player_id	int4	NO	NO	NO
cold_call_pf	int2	NO	NO	NO
steal_hu_chance	int2	NO	NO	NO
steal_hu_fold	int2	NO	NO	NO
chip_count	float4	NO	NO	NO
blind_amt	float4	NO	NO	NO
ante_amt	float4	NO	NO	NO
hole_card_3	varchar(2)	NO	NO	NO
hole_card_4	varchar(2)	NO	NO	NO
final_hand_low	text	NO	NO	NO
card_order4	int2	NO	NO	NO
connector_hand2	int2	NO	NO	NO
connector_hand2g	int2	NO	NO	NO
connector_hand3	int2	NO	NO	NO
pair_hand2	int2	NO	NO	NO
trip_hand	int2	NO	NO	NO
won_low	int2	NO	NO	NO

IndexName	Columns
tourney_game_players_idx_01	tourney_id,game_id,player_id
tourney_game_players_idx_02	player_id,tourney_id
tourney_game_players_idx_03	real_player_id
tourney_game_players_idx_04	player_id

ConstraintName	ConstraintKind	Check Expression	Columns
tourney_game_players_idx_01	UNIQUE		tourney_id,game_id,player_id

Table Create SQL

CREATE TABLE "public"."tourney_game_players" (
  "tourney_id" int4,
  "game_id" int4,
  "player_id" int4,
  "seat_number" int2,
  "button" int2,
  "hole_card_1" varchar(2),
  "hole_card_2" varchar(2),
  "suited" varchar(4),
  "pre_flop_bet" float4,
  "flop_bet" float4,
  "turn_bet" float4,
  "river_bet" float4,
  "total_bet" float4,
  "total_won" float4,
  "when_folded" text,
  "final_hand" text,
  "hand_rank_id" int2,
  "all_in" int2,
  "forced_all_in" int2,
  "hole_cards" varchar(4),
  "card_order1" int2,
  "card_order2" int2,
  "card_order3" int2,
  "connector_hand" int2,
  "pair_hand" int2,
  "won_hand" int2,
  "off_the_button" int2,
  "number_of_players" int2,
  "big_blind_n" int2,
  "small_blind_n" int2,
  "pre_flop_raise_n" int2,
  "flop_raise_n" int2,
  "flop_ck_raise_n" int2,
  "turn_bet_raise_n" int2,
  "turn_bet_ck_raise_n" int2,
  "river_bet_raise_n" int2,
  "river_bet_ck_raise_n" int2,
  "went_to_showdown_n" int2,
  "saw_flop_n" int2,
  "saw_flop_blind_n" int2,
  "attempted_steal" int2,
  "chance_to_steal" int2,
  "steal_attempted" int2,
  "folded_to_steal_attempt" int2,
  "raised_first_pf" int2,
  "vol_put_money_in_pot" int2,
  "limp_with_prev_callers" int2,
  "ppossible_actions" int2,
  "pfold" int2,
  "pcheck" int2,
  "pbet" int2,
  "praise" int2,
  "pcall" int2,
  "limp_call_reraise_pf" int2,
  "pfr_check" int2,
  "pfr_call" int2,
  "pfr_fold" int2,
  "pfr_bet" int2,
  "pfr_raise" int2,
  "folded_to_river_bet" int2,
  "fpossible_actions" int2,
  "ffold" int2,
  "fcheck" int2,
  "fbet" int2,
  "fraise" int2,
  "fcall" int2,
  "tpossible_actions" int2,
  "tfold" int2,
  "tcheck" int2,
  "tbet" int2,
  "traise" int2,
  "tcall" int2,
  "rpossible_actions" int2,
  "rfold" int2,
  "rcheck" int2,
  "rbet" int2,
  "rraise" int2,
  "rcall" int2,
  "real_player_id" int4,
  "cold_call_pf" int2,
  "steal_hu_chance" int2,
  "steal_hu_fold" int2,
  "chip_count" float4,
  "blind_amt" float4,
  "ante_amt" float4,
  "hole_card_3" varchar(2),
  "hole_card_4" varchar(2),
  "final_hand_low" text,
  "card_order4" int2,
  "connector_hand2" int2,
  "connector_hand2g" int2,
  "connector_hand3" int2,
  "pair_hand2" int2,
  "trip_hand" int2,
  "won_low" int2,
  CONSTRAINT "tourney_game_players_idx_01" UNIQUE("tourney_id","game_id","player_id")
)
WITHOUT OIDS;

CREATE INDEX "tourney_game_players_idx_02" ON "public"."tourney_game_players" USING BTREE ("player_id" , "tourney_id");
CREATE INDEX "tourney_game_players_idx_03" ON "public"."tourney_game_players" USING BTREE ("real_player_id");
CREATE INDEX "tourney_game_players_idx_04" ON "public"."tourney_game_players" USING BTREE ("player_id");

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
tourney_id	int4	NO	NO	NO
place_of_finish	int2	NO	NO	NO
player_id	int4	NO	NO	NO
amt_won	float4	NO	NO	NO
real_player_id	int4	NO	NO	NO
sat_seat_won	int2	NO	NO	NO
actual_buy_in	float4	NO	NO	NO
actual_fee	float4	NO	NO	NO
total_rebuys	int2	NO	NO	NO
rebuy_amt	float4	NO	NO	NO
total_addons	int2	NO	NO	NO
addon_amt	float4	NO	NO	NO

IndexName	Columns
tourney_summary_idx_01	tourney_id,player_id
tourney_summary_idx_02	real_player_id

ConstraintName	ConstraintKind	Check Expression	Columns
tourney_summary_idx_01	UNIQUE		tourney_id,player_id

Table Create SQL

CREATE TABLE "public"."tourney_summary" (
  "tourney_id" int4,
  "place_of_finish" int2,
  "player_id" int4,
  "amt_won" float4,
  "real_player_id" int4,
  "sat_seat_won" int2,
  "actual_buy_in" float4,
  "actual_fee" float4,
  "total_rebuys" int2,
  "rebuy_amt" float4,
  "total_addons" int2,
  "addon_amt" float4,
  CONSTRAINT "tourney_summary_idx_01" UNIQUE("tourney_id","player_id")
)
WITHOUT OIDS;

CREATE INDEX "tourney_summary_idx_02" ON "public"."tourney_summary" USING BTREE ("real_player_id");

Table Description
Table Annotation

Param Name	Param Value
Temporary	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
db_version	text	NO	NO	NO

IndexName

Columns

ConstraintName

ConstraintKind

Check Expression

Columns

Table Create SQL

CREATE TABLE "public"."version_info" (
  "db_version" text
)
WITHOUT OIDS;