12 lines
595 B
MySQL
12 lines
595 B
MySQL
|
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;
|