DB schema · JP Insurance

Joins

How the tables connect (matched by value, case-insensitive)

players.hs_user=sheet_summer.hs_accountPlayer ↔ summer sheet row
players.hs_user=sheet_august.usernamePlayer ↔ august sheet row
players.user_id=player_settings.user_idPlayer ↔ values edited on the dashboard
players.user_id=player_settings_log.user_idPlayer ↔ history of those edits

Player list pasted in chat, imported 2026-09-28 · 72 rows · 8 columns

Column	Type	Null	Key	Original name / note
`user_id`	`int(10) unsigned`	no	primary	Player ID
`name`	`varchar(191)`	no		Name
`hs_user`	`varchar(191)`	no	unique	HS user
`deals`	`int(10) unsigned`	yes		Deals
`financial_chat`	`varchar(255)`	yes		Financial chat
`status`	`varchar(32)`	no		Status
`created_at`	`timestamp`	no
`updated_at`	`timestamp`	no

user_id	name	hs_user	deals	financial_chat	status	created_at	updated_at
3	Dimitri Vandenberg	dimso	63	NULL	Active	2026-09-28 15:28:41	2026-09-28 15:28:41
4	Edvinas Obolenis	Frankyyy	55	NULL	Active	2026-09-28 15:28:41	2026-09-28 15:28:41
6	Janne Kristian Huhtala	Humppaukko	14	NULL	Active	2026-09-28 15:28:41	2026-09-28 15:28:41

Dashboard-edited values per player · 0 rows · 4 columns

Column	Type	Null	Key	Original name / note
`user_id`	`int(10) unsigned`	no	primary	players.user_id
`bitb_insurance_pct`	`decimal(5,2)`	yes		bitB insurance %, 25.00 or 40.00 (percent points)
`hv_pct`	`decimal(6,3)`	yes		HV Amount in percent points, 0–12.500; nominal = hv_pct / 100 × 800000
`updated_at`	`timestamp`	no

user_id	bitb_insurance_pct	hv_pct	updated_at
Table is empty.

Change history of player_settings · 0 rows · 8 columns

Column	Type	Null	Key	Original name / note
`id`	`int(10) unsigned`	no	primary
`user_id`	`int(10) unsigned`	no	index	players.user_id
`field`	`varchar(64)`	no		Changed player_settings column
`old_value`	`varchar(32)`	yes
`new_value`	`varchar(32)`	yes
`ip`	`varchar(45)`	yes		Editor IP address
`user_agent`	`varchar(255)`	yes
`changed_at`	`timestamp`	no

id	user_id	field	old_value	new_value	ip	user_agent	changed_at
Table is empty.

Google Sheet tab "august", imported 2026-09-28 · 93 rows · 19 columns

Column	Type	Null	Key	Original name / note
`row_no`	`int(10) unsigned`	no	primary	Row number in the sheet
`username`	`varchar(191)`	no	unique	username
`abi`	`double`	yes		abi
`total_buyin`	`double`	yes		total_buyin
`total_tourns`	`double`	yes		total_tourns
`max_prize_current`	`double`	yes		max_prize_current
`max_prize_uncovered`	`double`	yes		max_prize_uncovered
`max_hv_per_player`	`double`	yes		max_hv_per_player
`max_hv_total`	`double`	yes		max_hv_total
`pool_ev`	`double`	yes		Pool EV
`jp_ev`	`double`	yes		JP EV
`ev_x400_plus`	`double`	yes		EV x400+
`pool_ev_capped`	`double`	yes		Pool EV capped
`jp_ev_capped`	`double`	yes		JP EV capped
`ev_x400_plus_capped`	`double`	yes		EV x400+ capped
`delta_x400_plus`	`double`	yes		delta_x400+
`delta_jp_ev`	`double`	yes		delta_JP EV
`bi_swing_share`	`double`	yes		BI swing share
`new_swing_share`	`double`	yes		New swing share

row_no	username	abi	total_buyin	total_tourns	max_prize_current	max_prize_uncovered	max_hv_per_player	max_hv_total	pool_ev	jp_ev	ev_x400_plus	pool_ev_capped	jp_ev_capped	ev_x400_plus_capped	delta_x400_plus	delta_jp_ev	bi_swing_share	new_swing_share
2	3zerocool33	10.0283638068448	42781	4266	600	3000	1000	25000	-1442.80528499999	0	0	-1442.80528499999	0	0	0	0	0.0002231133653011016	0.000106160476638658
3	444Nuits	5.81049999999988	24473.8259999995	4212	4000	4000	500	12500	-35.2112880000002	0	86.2327532469148	-43.83456332469168	0	77.60947792222332	-8.623275325	0	0.0001276369809180123	0.0001025172556764224
4	4budlight	11.4150582278481	31562.6359999999	2765	400000	25000	1000	5000	-995.622497	107.135390693198	215.274121859629	-1106.813090111939	6.758670697902105	104.08352874769	-111.1905931	-100.37672	0.0001646068566824917	0.0008545667811600564

Google Sheet tab "summer", imported 2026-09-28 · 99 rows · 17 columns

Column	Type	Null	Key	Original name / note
`row_no`	`int(10) unsigned`	no	primary	Row number in the sheet
`hs_account`	`varchar(191)`	no	unique	HS Account
`abi`	`double`	yes		abi
`total_buyin`	`double`	yes		total_buyin
`total_tourns`	`double`	yes		total_tourns
`max_prize_current`	`double`	yes		max_prize_current
`max_prize_uncovered`	`double`	yes		max_prize_uncovered
`max_hv_per_player`	`double`	yes		max_hv_per_player
`max_hv_total`	`double`	yes		max_hv_total
`pool_ev`	`double`	yes		Pool EV
`jp_ev`	`double`	yes		JP EV
`ev_x400_plus`	`double`	yes		EV x400+
`pool_ev_capped`	`double`	yes		Pool EV capped
`jp_ev_capped`	`double`	yes		JP EV capped
`ev_x400_plus_capped`	`double`	yes		EV x400+ capped
`delta_x400_plus`	`double`	yes		delta_x400+
`delta_jp_ev`	`double`	yes		delta_JP EV

row_no	hs_account	abi	total_buyin	total_tourns	max_prize_current	max_prize_uncovered	max_hv_per_player	max_hv_total	pool_ev	jp_ev	ev_x400_plus	pool_ev_capped	jp_ev_capped	ev_x400_plus_capped	delta_x400_plus	delta_jp_ev
2	BLH37	160.445313807939	4101784.44749997	25565	1000000	250000	25000	500000	-47428.1711259999	14712.2113706492	27724.1687893749	-55024.82208219109	8416.756156330584	20127.51783318372	-7596.650956	-6295.455214
3	CaptainSnake	178.176593503074	3855919.66000003	21641	400000	250000	25000	125000	-42840.5523890001	5827.29850631044	19280.2942142592	-44671.18377164974	5341.966694455674	17449.66283160956	-1830.631383	-485.3318119
4	Cece9	308.921560242371	6627912.07500006	21455	1000000	250000	25000	500000	-118572.224445	20259.9351691542	34823.0560669085	-129397.7141227556	9487.574649312137	23997.56638915289	-10825.48968	-10772.36052