(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)