- 论坛徽章:
- 0
|
文件内容:
`ACCOUNT_NO` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号',
`ACCOUNT_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '账户名',
`ACCOUNT_TYPE` tinyint(1) NULL DEFAULT NULL COMMENT '账户类型:1-个人 2-企业',
`ACCOUNT_CAT` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '账户种类:11-余额户 21-基本户 22-待结算户 23-货款户',
`ACCOUNT_STATUS` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '账户状态:01-正常 02-冻结 03-注销 04-只入 05-只出',
`BALANCE` decimal(16, 2) NULL DEFAULT 0.00 COMMENT '余额',
`AVL_BALANCE` decimal(16, 2) NULL DEFAULT 0.00 COMMENT '可用余额',
`FREEZE_BALANCE` decimal(16, 2) NULL DEFAULT 0.00 COMMENT '冻结余额',
`SIGNTURE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '防篡改签名',
我想把
COMMENT '账户种类:11-余额户 21-基本户 22-待结算户 23-货款户',
变成:
COMMENT '账户种类:',
匹配标准是 : 后有字的全部去掉 但要以:',结尾
|
|