DROP TABLE IF EXISTS `qy_fpxx`;
CREATE TABLE `qy_fpxx`
(
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `qy_id` varchar(50)  default NULL  COMMENT '企业id',
    `month`   date COMMENT '月份',
    `total_fp` int DEFAULT NULL COMMENT '总票数',
    `total_je` float DEFAULT NULL COMMENT '总金额',
    `is_xx` varchar(50) DEFAULT NULL COMMENT '是否销项（0：进项，1：销项）',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 103 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '企业发票信息' ROW_FORMAT = Dynamic;