5分钟彩数据库管理

表: klsf_history

表结构

字段名	类型	允许NULL	键	默认值	额外	注释
id	bigint(20) unsigned	NO	PRI		auto_increment
issue_no	bigint(20) unsigned	NO	UNI
draw_date	date	NO	MUL
draw_time	time	NO	MUL
number_1	tinyint(3) unsigned	NO
number_2	tinyint(3) unsigned	NO
number_3	tinyint(3) unsigned	NO
number_4	tinyint(3) unsigned	NO
number_5	tinyint(3) unsigned	NO
number_6	tinyint(3) unsigned	NO
number_7	tinyint(3) unsigned	NO
number_8	tinyint(3) unsigned	NO
sum_value	smallint(5) unsigned	NO
sum_single_double	tinyint(1)	NO
sum_big_small	tinyint(1)	NO
first_dragon_tiger	tinyint(1)	NO
second_dragon_tiger	tinyint(1)	NO
third_dragon_tiger	tinyint(1)	NO
fourth_dragon_tiger	tinyint(1)	NO
last_big_small	tinyint(1)	NO
group_code	tinyint(3)	NO
raw_data	text	NO
created_at	timestamp	NO		CURRENT_TIMESTAMP
updated_at	datetime	YES

数据预览 (前10行)

id	issue_no	draw_date	draw_time	number_1	number_2	number_3	number_4	number_5	number_6	number_7	number_8	sum_value	sum_single_double	sum_big_small	first_dragon_tiger	second_dragon_tiger	third_dragon_tiger	fourth_dragon_tiger	last_big_small	group_code	raw_data	created_at	updated_at
1	31221105	2025-01-27	23:58:40	2	8	19	15	5	1	6	4	60	1	1	1	0	0	0	1	3	{"preDrawIssue":31221105,"preDrawCode":"02,08,19,15,05,01,06,04","preDrawTime":"2025-01-27 23:58:40"...	2026-02-10 14:56:11	NULL
2	31221104	2025-01-27	23:53:40	5	14	16	10	17	20	13	4	99	0	0	0	0	1	1	0	3	{"preDrawIssue":31221104,"preDrawCode":"05,14,16,10,17,20,13,04","preDrawTime":"2025-01-27 23:53:40"...	2026-02-10 14:56:11	NULL
3	31221103	2025-01-27	23:48:40	8	11	13	16	7	10	2	6	73	0	1	0	0	0	0	1	3	{"preDrawIssue":31221103,"preDrawCode":"08,11,13,16,07,10,02,06","preDrawTime":"2025-01-27 23:48:40"...	2026-02-10 14:56:11	NULL
4	31221102	2025-01-27	23:43:40	1	4	2	16	20	9	18	3	73	0	1	1	1	1	1	1	3	{"preDrawIssue":31221102,"preDrawCode":"01,04,02,16,20,09,18,03","preDrawTime":"2025-01-27 23:43:40"...	2026-02-10 14:56:11	NULL
5	31221101	2025-01-27	23:38:40	11	3	19	1	15	10	20	14	93	0	0	1	1	0	1	1	3	{"preDrawIssue":31221101,"preDrawCode":"11,03,19,01,15,10,20,14","preDrawTime":"2025-01-27 23:38:40"...	2026-02-10 14:56:11	NULL
6	31221100	2025-01-27	23:33:40	3	15	5	2	7	20	8	19	79	0	1	1	0	1	1	0	3	{"preDrawIssue":31221100,"preDrawCode":"03,15,05,02,07,20,08,19","preDrawTime":"2025-01-27 23:33:40"...	2026-02-10 14:56:11	NULL
7	31221099	2025-01-27	23:28:40	6	1	16	4	11	15	3	13	69	0	1	1	1	0	1	0	3	{"preDrawIssue":31221099,"preDrawCode":"06,01,16,04,11,15,03,13","preDrawTime":"2025-01-27 23:28:40"...	2026-02-10 14:56:11	NULL
8	31221098	2025-01-27	23:23:40	7	10	14	6	13	16	1	17	84	1	2	1	0	1	1	1	3	{"preDrawIssue":31221098,"preDrawCode":"07,10,14,06,13,16,01,17","preDrawTime":"2025-01-27 23:23:40"...	2026-02-10 14:56:11	NULL
9	31221097	2025-01-27	23:18:40	18	3	14	8	11	20	2	17	93	0	0	0	0	1	1	1	3	{"preDrawIssue":31221097,"preDrawCode":"18,03,14,08,11,20,02,17","preDrawTime":"2025-01-27 23:18:40"...	2026-02-10 14:56:11	NULL
10	31221096	2025-01-27	23:13:40	8	10	2	19	18	15	6	1	79	0	1	0	0	1	0	0	3	{"preDrawIssue":31221096,"preDrawCode":"08,10,02,19,18,15,06,01","preDrawTime":"2025-01-27 23:13:40"...	2026-02-10 14:56:11	NULL