|
没有永恒制胜的策略,加入我们,一起加油!
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
整体数据同步完成.其中每场比赛的当前积分榜,当前两队对战历史,当前两队近30+场战绩,当前未来赛事,必发数据 均己完结.
数据多还蛮充实,相比以前只用近三年数据好多了.
数据库表列表.
数据库视图列表.
SELECT
"亚赔",
DATE_FORMAT(mh.`MatchDate`, '%Y') AS '年份',
COUNT(1) AS "数据行数"
FROM
t_match_his mh
INNER JOIN t_asia_full af
ON mh.id = af.matchId
WHERE 1=1
GROUP BY DATE_FORMAT(mh.`MatchDate`, '%Y')
ORDER BY DATE_FORMAT(mh.`MatchDate`, '%Y')
结构体数据结构
- package pojo
- import (
- "fooy-parent/common/base/pojo"
- "time"
- )
- /**
- 亚赔全场数据表,初终盘
- */
- type AsiaFull struct {
- //比赛id
- MatchId string `xorm:" varchar(20) index"`
- //比赛时间
- MatchDate time.Time `xorm:" comment('MatchDate') index"`
- //数据时间
- OddDate string `xorm:" comment('数据时间') index varchar(20)"`
- //1,1澳门
- C1_Sp3 float64 `xorm:" comment('Sp3') index"`
- C1_SPanKou float64 `xorm:" comment('s让球') index"`
- C1_Sp0 float64 `xorm:" comment('Sp0') index"`
- C1_Ep3 float64 `xorm:" comment('Ep3') "`
- C1_EPanKou float64 `xorm:" comment('e让球') "`
- C1_Ep0 float64 `xorm:" comment('Ep0') "`
- //12,12易胜博
- C12_Sp3 float64 `xorm:" comment('Sp3') index"`
- C12_SPanKou float64 `xorm:" comment('s让球') index"`
- C12_Sp0 float64 `xorm:" comment('Sp0') index"`
- C12_Ep3 float64 `xorm:" comment('Ep3') "`
- C12_EPanKou float64 `xorm:" comment('e让球') "`
- C12_Ep0 float64 `xorm:" comment('Ep0') "`
- //14,14韦德
- C14_Sp3 float64 `xorm:" comment('Sp3') index"`
- C14_SPanKou float64 `xorm:" comment('s让球') index"`
- C14_Sp0 float64 `xorm:" comment('Sp0') index"`
- C14_Ep3 float64 `xorm:" comment('Ep3') "`
- C14_EPanKou float64 `xorm:" comment('e让球') "`
- C14_Ep0 float64 `xorm:" comment('Ep0') "`
- //17,17明陞
- C17_Sp3 float64 `xorm:" comment('Sp3') index"`
- C17_SPanKou float64 `xorm:" comment('s让球') index"`
- C17_Sp0 float64 `xorm:" comment('Sp0') index"`
- C17_Ep3 float64 `xorm:" comment('Ep3') "`
- C17_EPanKou float64 `xorm:" comment('e让球') "`
- C17_Ep0 float64 `xorm:" comment('Ep0') "`
- //19,19Interwetten
- C19_Sp3 float64 `xorm:" comment('Sp3') index"`
- C19_SPanKou float64 `xorm:" comment('s让球') index"`
- C19_Sp0 float64 `xorm:" comment('Sp0') index"`
- C19_Ep3 float64 `xorm:" comment('Ep3') "`
- C19_EPanKou float64 `xorm:" comment('e让球') "`
- C19_Ep0 float64 `xorm:" comment('Ep0') "`
- //22,2210BET
- C22_Sp3 float64 `xorm:" comment('Sp3') index"`
- C22_SPanKou float64 `xorm:" comment('s让球') index"`
- C22_Sp0 float64 `xorm:" comment('Sp0') index"`
- C22_Ep3 float64 `xorm:" comment('Ep3') "`
- C22_EPanKou float64 `xorm:" comment('e让球') "`
- C22_Ep0 float64 `xorm:" comment('Ep0') "`
- //23,23金宝博
- C23_Sp3 float64 `xorm:" comment('Sp3') index"`
- C23_SPanKou float64 `xorm:" comment('s让球') index"`
- C23_Sp0 float64 `xorm:" comment('Sp0') index"`
- C23_Ep3 float64 `xorm:" comment('Ep3') "`
- C23_EPanKou float64 `xorm:" comment('e让球') "`
- C23_Ep0 float64 `xorm:" comment('Ep0') "`
- //24,2412bet
- C24_Sp3 float64 `xorm:" comment('Sp3') index"`
- C24_SPanKou float64 `xorm:" comment('s让球') index"`
- C24_Sp0 float64 `xorm:" comment('Sp0') index"`
- C24_Ep3 float64 `xorm:" comment('Ep3') "`
- C24_EPanKou float64 `xorm:" comment('e让球') "`
- C24_Ep0 float64 `xorm:" comment('Ep0') "`
- //3,3Crown
- C3_Sp3 float64 `xorm:" comment('Sp3') index"`
- C3_SPanKou float64 `xorm:" comment('s让球') index"`
- C3_Sp0 float64 `xorm:" comment('Sp0') index"`
- C3_Ep3 float64 `xorm:" comment('Ep3') "`
- C3_EPanKou float64 `xorm:" comment('e让球') "`
- C3_Ep0 float64 `xorm:" comment('Ep0') "`
- //31,31利记
- C31_Sp3 float64 `xorm:" comment('Sp3') index"`
- C31_SPanKou float64 `xorm:" comment('s让球') index"`
- C31_Sp0 float64 `xorm:" comment('Sp0') index"`
- C31_Ep3 float64 `xorm:" comment('Ep3') "`
- C31_EPanKou float64 `xorm:" comment('e让球') "`
- C31_Ep0 float64 `xorm:" comment('Ep0') "`
- //35,35盈禾
- C35_Sp3 float64 `xorm:" comment('Sp3') index"`
- C35_SPanKou float64 `xorm:" comment('s让球') index"`
- C35_Sp0 float64 `xorm:" comment('Sp0') index"`
- C35_Ep3 float64 `xorm:" comment('Ep3') "`
- C35_EPanKou float64 `xorm:" comment('e让球') "`
- C35_Ep0 float64 `xorm:" comment('Ep0') "`
- //4,4立博
- C4_Sp3 float64 `xorm:" comment('Sp3') index"`
- C4_SPanKou float64 `xorm:" comment('s让球') index"`
- C4_Sp0 float64 `xorm:" comment('Sp0') index"`
- C4_Ep3 float64 `xorm:" comment('Ep3') "`
- C4_EPanKou float64 `xorm:" comment('e让球') "`
- C4_Ep0 float64 `xorm:" comment('Ep0') "`
- //42,4218Bet
- C42_Sp3 float64 `xorm:" comment('Sp3') index"`
- C42_SPanKou float64 `xorm:" comment('s让球') index"`
- C42_Sp0 float64 `xorm:" comment('Sp0') index"`
- C42_Ep3 float64 `xorm:" comment('Ep3') "`
- C42_EPanKou float64 `xorm:" comment('e让球') "`
- C42_Ep0 float64 `xorm:" comment('Ep0') "`
- //47,47平博
- C47_Sp3 float64 `xorm:" comment('Sp3') index"`
- C47_SPanKou float64 `xorm:" comment('s让球') index"`
- C47_Sp0 float64 `xorm:" comment('Sp0') index"`
- C47_Ep3 float64 `xorm:" comment('Ep3') "`
- C47_EPanKou float64 `xorm:" comment('e让球') "`
- C47_Ep0 float64 `xorm:" comment('Ep0') "`
- //48,48香港马会
- C48_Sp3 float64 `xorm:" comment('Sp3') index"`
- C48_SPanKou float64 `xorm:" comment('s让球') index"`
- C48_Sp0 float64 `xorm:" comment('Sp0') index"`
- C48_Ep3 float64 `xorm:" comment('Ep3') "`
- C48_EPanKou float64 `xorm:" comment('e让球') "`
- C48_Ep0 float64 `xorm:" comment('Ep0') "`
- //49,49BWin
- C49_Sp3 float64 `xorm:" comment('Sp3') index"`
- C49_SPanKou float64 `xorm:" comment('s让球') index"`
- C49_Sp0 float64 `xorm:" comment('Sp0') index"`
- C49_Ep3 float64 `xorm:" comment('Ep3') "`
- C49_EPanKou float64 `xorm:" comment('e让球') "`
- C49_Ep0 float64 `xorm:" comment('Ep0') "`
- //8,8Bet365
- C8_Sp3 float64 `xorm:" comment('Sp3') index"`
- C8_SPanKou float64 `xorm:" comment('s让球') index"`
- C8_Sp0 float64 `xorm:" comment('Sp0') index"`
- C8_Ep3 float64 `xorm:" comment('Ep3') "`
- C8_EPanKou float64 `xorm:" comment('e让球') "`
- C8_Ep0 float64 `xorm:" comment('Ep0') "`
- pojo.BasePojo `xorm:"extends"`
- }
复制代码
SELECT
"欧赔",
DATE_FORMAT(mh.`MatchDate`, '%Y') AS '年份',
COUNT(1) AS "数据行数"
FROM
t_match_his mh
INNER JOIN t_euro_full af
ON mh.id = af.matchId
WHERE 1=1
GROUP BY DATE_FORMAT(mh.`MatchDate`, '%Y')
ORDER BY DATE_FORMAT(mh.`MatchDate`, '%Y')
结构体数据结构
SELECT
"大小赔",
DATE_FORMAT(mh.`MatchDate`, '%Y') AS '年份',
COUNT(1) AS "数据行数"
FROM
t_match_his mh
INNER JOIN t_ou_full af
ON mh.id = af.matchId
WHERE 1=1
GROUP BY DATE_FORMAT(mh.`MatchDate`, '%Y')
ORDER BY DATE_FORMAT(mh.`MatchDate`, '%Y')
结构体数据结构
- package pojo
- import (
- "fooy-parent/common/base/pojo"
- "time"
- )
- /**
- 大小赔全场数据表,初终盘
- */
- type OuFull struct {
- //比赛id
- MatchId string `xorm:" varchar(20) index"`
- //比赛时间
- MatchDate time.Time `xorm:" comment('MatchDate') index"`
- //数据时间
- OddDate string `xorm:" comment('数据时间') index varchar(20)"`
- //1,1澳门
- C1_Sp3 float64 `xorm:" comment('Sp3') index"`
- C1_SPanKou float64 `xorm:" comment('s让球') index"`
- C1_Sp0 float64 `xorm:" comment('Sp0') index"`
- C1_Ep3 float64 `xorm:" comment('Ep3') "`
- C1_EPanKou float64 `xorm:" comment('e让球') "`
- C1_Ep0 float64 `xorm:" comment('Ep0') "`
- //12,12易胜博
- C12_Sp3 float64 `xorm:" comment('Sp3') index"`
- C12_SPanKou float64 `xorm:" comment('s让球') index"`
- C12_Sp0 float64 `xorm:" comment('Sp0') index"`
- C12_Ep3 float64 `xorm:" comment('Ep3') "`
- C12_EPanKou float64 `xorm:" comment('e让球') "`
- C12_Ep0 float64 `xorm:" comment('Ep0') "`
- //14,14韦德
- C14_Sp3 float64 `xorm:" comment('Sp3') index"`
- C14_SPanKou float64 `xorm:" comment('s让球') index"`
- C14_Sp0 float64 `xorm:" comment('Sp0') index"`
- C14_Ep3 float64 `xorm:" comment('Ep3') "`
- C14_EPanKou float64 `xorm:" comment('e让球') "`
- C14_Ep0 float64 `xorm:" comment('Ep0') "`
- //17,17明陞
- C17_Sp3 float64 `xorm:" comment('Sp3') index"`
- C17_SPanKou float64 `xorm:" comment('s让球') index"`
- C17_Sp0 float64 `xorm:" comment('Sp0') index"`
- C17_Ep3 float64 `xorm:" comment('Ep3') "`
- C17_EPanKou float64 `xorm:" comment('e让球') "`
- C17_Ep0 float64 `xorm:" comment('Ep0') "`
- //19,19Interwetten
- C19_Sp3 float64 `xorm:" comment('Sp3') index"`
- C19_SPanKou float64 `xorm:" comment('s让球') index"`
- C19_Sp0 float64 `xorm:" comment('Sp0') index"`
- C19_Ep3 float64 `xorm:" comment('Ep3') "`
- C19_EPanKou float64 `xorm:" comment('e让球') "`
- C19_Ep0 float64 `xorm:" comment('Ep0') "`
- //22,2210BET
- C22_Sp3 float64 `xorm:" comment('Sp3') index"`
- C22_SPanKou float64 `xorm:" comment('s让球') index"`
- C22_Sp0 float64 `xorm:" comment('Sp0') index"`
- C22_Ep3 float64 `xorm:" comment('Ep3') "`
- C22_EPanKou float64 `xorm:" comment('e让球') "`
- C22_Ep0 float64 `xorm:" comment('Ep0') "`
- //23,23金宝博
- C23_Sp3 float64 `xorm:" comment('Sp3') index"`
- C23_SPanKou float64 `xorm:" comment('s让球') index"`
- C23_Sp0 float64 `xorm:" comment('Sp0') index"`
- C23_Ep3 float64 `xorm:" comment('Ep3') "`
- C23_EPanKou float64 `xorm:" comment('e让球') "`
- C23_Ep0 float64 `xorm:" comment('Ep0') "`
- //24,2412bet
- C24_Sp3 float64 `xorm:" comment('Sp3') index"`
- C24_SPanKou float64 `xorm:" comment('s让球') index"`
- C24_Sp0 float64 `xorm:" comment('Sp0') index"`
- C24_Ep3 float64 `xorm:" comment('Ep3') "`
- C24_EPanKou float64 `xorm:" comment('e让球') "`
- C24_Ep0 float64 `xorm:" comment('Ep0') "`
- //3,3Crown
- C3_Sp3 float64 `xorm:" comment('Sp3') index"`
- C3_SPanKou float64 `xorm:" comment('s让球') index"`
- C3_Sp0 float64 `xorm:" comment('Sp0') index"`
- C3_Ep3 float64 `xorm:" comment('Ep3') "`
- C3_EPanKou float64 `xorm:" comment('e让球') "`
- C3_Ep0 float64 `xorm:" comment('Ep0') "`
- //31,31利记
- C31_Sp3 float64 `xorm:" comment('Sp3') index"`
- C31_SPanKou float64 `xorm:" comment('s让球') index"`
- C31_Sp0 float64 `xorm:" comment('Sp0') index"`
- C31_Ep3 float64 `xorm:" comment('Ep3') "`
- C31_EPanKou float64 `xorm:" comment('e让球') "`
- C31_Ep0 float64 `xorm:" comment('Ep0') "`
- //35,35盈禾
- C35_Sp3 float64 `xorm:" comment('Sp3') index"`
- C35_SPanKou float64 `xorm:" comment('s让球') index"`
- C35_Sp0 float64 `xorm:" comment('Sp0') index"`
- C35_Ep3 float64 `xorm:" comment('Ep3') "`
- C35_EPanKou float64 `xorm:" comment('e让球') "`
- C35_Ep0 float64 `xorm:" comment('Ep0') "`
- //4,4立博
- C4_Sp3 float64 `xorm:" comment('Sp3') index"`
- C4_SPanKou float64 `xorm:" comment('s让球') index"`
- C4_Sp0 float64 `xorm:" comment('Sp0') index"`
- C4_Ep3 float64 `xorm:" comment('Ep3') "`
- C4_EPanKou float64 `xorm:" comment('e让球') "`
- C4_Ep0 float64 `xorm:" comment('Ep0') "`
- //42,4218Bet
- C42_Sp3 float64 `xorm:" comment('Sp3') index"`
- C42_SPanKou float64 `xorm:" comment('s让球') index"`
- C42_Sp0 float64 `xorm:" comment('Sp0') index"`
- C42_Ep3 float64 `xorm:" comment('Ep3') "`
- C42_EPanKou float64 `xorm:" comment('e让球') "`
- C42_Ep0 float64 `xorm:" comment('Ep0') "`
- //47,47平博
- C47_Sp3 float64 `xorm:" comment('Sp3') index"`
- C47_SPanKou float64 `xorm:" comment('s让球') index"`
- C47_Sp0 float64 `xorm:" comment('Sp0') index"`
- C47_Ep3 float64 `xorm:" comment('Ep3') "`
- C47_EPanKou float64 `xorm:" comment('e让球') "`
- C47_Ep0 float64 `xorm:" comment('Ep0') "`
- //48,48香港马会
- C48_Sp3 float64 `xorm:" comment('Sp3') index"`
- C48_SPanKou float64 `xorm:" comment('s让球') index"`
- C48_Sp0 float64 `xorm:" comment('Sp0') index"`
- C48_Ep3 float64 `xorm:" comment('Ep3') "`
- C48_EPanKou float64 `xorm:" comment('e让球') "`
- C48_Ep0 float64 `xorm:" comment('Ep0') "`
- //49,49BWin
- C49_Sp3 float64 `xorm:" comment('Sp3') index"`
- C49_SPanKou float64 `xorm:" comment('s让球') index"`
- C49_Sp0 float64 `xorm:" comment('Sp0') index"`
- C49_Ep3 float64 `xorm:" comment('Ep3') "`
- C49_EPanKou float64 `xorm:" comment('e让球') "`
- C49_Ep0 float64 `xorm:" comment('Ep0') "`
- //8,8Bet365
- C8_Sp3 float64 `xorm:" comment('Sp3') index"`
- C8_SPanKou float64 `xorm:" comment('s让球') index"`
- C8_Sp0 float64 `xorm:" comment('Sp0') index"`
- C8_Ep3 float64 `xorm:" comment('Ep3') "`
- C8_EPanKou float64 `xorm:" comment('e让球') "`
- C8_Ep0 float64 `xorm:" comment('Ep0') "`
- pojo.BasePojo `xorm:"extends"`
- }
复制代码
|
|