(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 ‘Used Time’,
INVALIDTIME
datetime DEFAULT NULL COMMENT ‘Invalid Time’,
COLLARTIME
datetime DEFAULT NULL COMMENT ‘Collection Time’,
LOSTTIME
datetime DEFAULT NULL COMMENT ‘Lost Time’,
UPDATETIME
datetime DEFAULT NULL COMMENT ‘Last Update Time’,
DESTROYTIME
datetime DEFAULT NULL COMMENT ‘Destruction Time’,
ATTRIBUTIVECOMCODE
varchar(40) COLLATE utf8mb4_bin DEFAULT NULL COMMENT ‘Attributive Branch Code’,
PROVIDECOMTIME
datetime DEFAULT NULL COMMENT ‘Department Distribution Time’,
TRANSSTATUSTIME
datetime DEFAULT NULL COMMENT ‘Status Transition Time’,
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)