CREATE TABLE `www34` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`invoiceHead` varchar(255) COLLATE utf8_slovenian_ci NOT NULL COMMENT '发票抬头',
`invoiceCode` varchar(255) COLLATE utf8_slovenian_ci NOT NULL COMMENT '纳税人识别号',
`userld` int(10) NOT NULL COMMENT '用户id',
`dataFlag` tinyint(4) NOT NULL DEFAULT '1' COMMENT '数据有效标记(1:有效-1:无效)',
`create Time` datetime NOT NULL COMMENT '数据创建时间',
`invoice Type` tinyint(4) DEFAULT '0' COMMENT '发票类型(1:专票0:普票)',
`invoiceAddr` varchar(300) COLLATE utf8_slovenian_ci DEFAULT NULL COMMENT '专票注册地址',
`invoicePhoneNumber` varchar(100) COLLATE utf8_slovenian_ci DEFAULT NULL COMMENT '专票注册电话',
`invoiceBankName` varchar(100) COLLATE utf8_slovenian_ci DEFAULT NULL COMMENT '专票开户银行',
`invoiceBankNo` varchar(100) COLLATE utf8_slovenian_ci DEFAULT NULL COMMENT '专票银行卡号',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci COMMENT='王雨玲 发票表';
mysql发票表
最新推荐文章于 2024-06-03 18:36:55 发布