matches.ts
5.0 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
import * as moment from 'moment';
module.exports = function (sequelize: any, DataTypes: any) {
return sequelize.define('matches', {
id: {
type: DataTypes.INTEGER,
allowNull: false,
primaryKey: true,
comment: "比赛id"
},
competition_id: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "赛事id"
},
season_id: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "赛季id"
},
match_time: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "比赛时间"
},
home_team_id: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "主队id"
},
away_team_id: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "客队id"
},
home_scores: {
type: DataTypes.JSON,
allowNull: true,
comment: "主队比分数据"
},
away_scores: {
type: DataTypes.JSON,
allowNull: true,
comment: "客队比分数据"
},
agg_score: {
type: DataTypes.JSON,
allowNull: true,
comment: "双回合常规时间(包括加时时间)总比分"
},
status_id: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "比赛状态，详见状态码->比赛状态"
},
neutral: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "是否中立场，1-是、0-否"
},
note: {
type: DataTypes.STRING(255),
allowNull: true,
comment: "备注"
},
home_position: {
type: DataTypes.STRING(255),
allowNull: true,
comment: "主队排名"
},
away_position: {
type: DataTypes.STRING(255),
allowNull: true,
comment: "客队排名"
},
coverage: {
type: DataTypes.JSON,
allowNull: true,
comment: "动画、情报、阵容字段"
},
venue_id: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "场馆id"
},
referee_id: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "裁判id"
},
related_id: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "双回合中另一回合比赛id"
},
round: {
type: DataTypes.JSON,
allowNull: true,
comment: "关联信息"
},
environment: {
type: DataTypes.JSON,
allowNull: true,
comment: "比赛环境数据"
},
lottery: {
type: DataTypes.JSON,
allowNull: true,
comment: "彩票期号、序号（lottery 体彩查询存在）"
},
trend: {
type: DataTypes.JSON,
allowNull: true,
comment: "比赛趋势详情"
},
lineup: {
type: DataTypes.JSON,
allowNull: true,
comment: "比赛阵容详情"
},
stream: {
type: DataTypes.JSON,
allowNull: true,
comment: "比赛集锦录像地址"
},
odds: {
type: DataTypes.JSON,
allowNull: true,
comment: "bet365赔率"
},
history: {
type: DataTypes.JSON,
allowNull: true,
comment: "历史记录，交锋激励"
},
future: {
type: DataTypes.JSON,
allowNull: true,
comment: "未来赛程"
},
goal_distribution: {
type: DataTypes.JSON,
allowNull: true,
comment: "进球分布"
},
team_stats: {
type: DataTypes.JSON,
allowNull: true,
comment: "球队统计数据"
},
player_stats: {
type: DataTypes.JSON,
allowNull: true,
comment: "球员统计"
},
live: {
type: DataTypes.JSON,
allowNull: true,
comment: "获取历史比赛统计数据"
},
compensation: {
type: DataTypes.JSON,
allowNull: true,
comment: "比赛历史同赔统计列"
},
del_status: {
type: DataTypes.INTEGER,
allowNull: true,
comment: "删除状态:1待替换id,2已替换"
},
updated_at: {
type: DataTypes.BIGINT,
allowNull: true,
get() {
return moment(this.getDataValue('updated_at')).format('YYYY-MM-DD HH:mm:ss');
}
},
created_at: {
type: DataTypes.DATE,
allowNull: true
}
})
};