CREATE TABLE `res_voucher` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `userid` varchar(50) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `category` varchar(500) DEFAULT NULL,
  `voucher` varchar(500) DEFAULT NULL,
  `vouchermark` varchar(500) DEFAULT NULL COMMENT '备注',
  `dr` varchar(1) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='凭证';