(root@localhost)[test] 10:03:41>select count() from vsunusedmark;----
±---------+
| count() |
±---------+
| 44124732 |
±---------+
1 row in set (9.35 sec)
(root@localhost)[test] 10:04:02>show create table vsunusedmark\G
*************************** 1. row ***************************
Table: vsunusedmark
Create Table: CREATE TABLE vsunusedmark (
VISAPRE varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
VISASERIALNO varchar(100) COLLATE utf8mb4_bin NOT NULL,
VISACODE varchar(40) COLLATE utf8mb4_bin NOT NULL,
VISANAME varchar(200) COLLATE utf8mb4_bin NOT NULL,
PRESSBATCHNO varchar(32) COLLATE utf8mb4_bin NOT NULL,
BUSINESSNO varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
VISAAMOUNT decimal(15,3) DEFAULT NULL,
USEDATE datetime NOT NULL,
USERTYPE varchar(2) COLLATE utf8mb4_bin NOT NULL,
USERCODE varchar(40) COLLATE utf8mb4_bin NOT NULL,
USERNAME varchar(240) COLLATE utf8mb4_bin NOT NULL,
VISASTATUS varchar(40) COLLATE utf8mb4_bin NOT NULL,
PROVIDETIMES decimal(15,0) DEFAULT NULL,
RECYCLETIMES decimal(15,0) DEFAULT NULL,
VERIFIEDCANCELFLAG varchar(2) COLLATE utf8mb4_bin NOT NULL,
BEFORESTATUS varchar(40) COLLATE utf8mb4_bin DEFAULT NULL,
REMARK varchar(510) COLLATE utf8mb4_bin DEFAULT NULL,
FLAG varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
COMCODE varchar(40) COLLATE utf8mb4_bin DEFAULT NULL,
USEDENDDATE datetime DEFAULT NULL,
GDVISACODE varchar(510) COLLATE utf8mb4_bin DEFAULT NULL,
GDVISASERIALNO varchar(510) COLLATE utf8mb4_bin DEFAULT NULL,
USEDTIME datetime DEFAULT NULL COMMENT ‘已使用时间’,
INVALIDTIME datetime DEFAULT NULL COMMENT ‘作废时间’,
COLLARTIME datetime DEFAULT NULL COMMENT ‘领用时间’,
LOSTTIME datetime DEFAULT NULL COMMENT ‘已丢失时间’,
UPDATETIME datetime DEFAULT NULL COMMENT ‘最后一次更新时间’,
DESTROYTIME datetime DEFAULT NULL COMMENT ‘销毁时间’,
ATTRIBUTIVECOMCODE varchar(40) COLLATE utf8mb4_bin DEFAULT NULL COMMENT ‘归属省分机构代码’,
PROVIDECOMTIME datetime DEFAULT NULL COMMENT ‘发放到部门时间’,
TRANSSTATUSTIME datetime DEFAULT NULL COMMENT ‘状态转化时间’,
PRIMARY KEY (VISACODE,VISASERIALNO),
KEY IDX_VSUNUSEDMARK_BUSINESSNO (BUSINESSNO),
KEY IDX_VSUNUSEDMARK_CODE_STAT (VISACODE,VISASTATUS),
KEY IDX_VSUNUSEDMARK_COMCODE (COMCODE),
KEY IDX_VSUNUSEDMARK_UCODE_VSTAT (VISASTATUS,USERCODE),
KEY IDX_VSUNUSEDMARK_UPDATETIME (UPDATETIME),
KEY IDX_VSUNUSEDMARK_USERCODE (USERCODE),
KEY IDX_VSUNUSEDMARK_VISASERIALNO (VISASERIALNO),
KEY IDX_VSUNUSEDMARK_VISA_USR (VISACODE,USERCODE),
KEY IDX_VSUNUSED_VCSN (VISASERIALNO,VISACODE),
KEY IDX_VSUNUSED_COMCODE_VISACODE (COMCODE,VISACODE),
KEY idx_vsunusedmark_acomcode (ATTRIBUTIVECOMCODE)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
1 row in set (0.00 sec)