You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
sdny-jxpt/db/v5.0.0.0/dxhy_detail_create.sql

82 lines
4.2 KiB

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_dx_customs_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_dx_customs_detail`;
CREATE TABLE `t_dx_customs_detail` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`customs_code` varchar(255) DEFAULT NULL COMMENT '缴款书号码',
`taxno` varchar(255) DEFAULT NULL COMMENT '税号信息',
`goods_name` varchar(255) DEFAULT NULL COMMENT '获取名称',
`num` varchar(50) DEFAULT NULL COMMENT '数量',
`detail_amount` varchar(50) DEFAULT NULL COMMENT '完税价格',
`unit` varchar(50) DEFAULT NULL COMMENT '单位',
`tax_rate` varchar(20) DEFAULT NULL COMMENT '税率',
`tax_amount` varchar(20) DEFAULT NULL COMMENT '税款金额',
`data_sources` varchar(255) DEFAULT NULL COMMENT '数据来源',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='海关缴款书明细';
-- ----------------------------
-- Table structure for t_dx_record_invoice_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_dx_record_invoice_detail`;
CREATE TABLE `t_dx_record_invoice_detail` (
`id` bigint(30) NOT NULL,
`uuid` varchar(30) NOT NULL COMMENT '唯一标识(发票代码+发票号码)',
`invoice_code` varchar(20) DEFAULT NULL COMMENT '发票代码',
`invoice_no` varchar(10) DEFAULT NULL COMMENT '发票号码',
`detail_no` varchar(20) DEFAULT NULL COMMENT '明细序号',
`goods_name` varchar(255) DEFAULT NULL COMMENT '货物或应税劳务名称',
`model` varchar(80) DEFAULT NULL COMMENT '规格型号',
`unit` varchar(50) DEFAULT NULL COMMENT '单位',
`num` varchar(50) DEFAULT NULL COMMENT '数量',
`unit_price` varchar(50) DEFAULT NULL COMMENT '单价',
`detail_amount` varchar(20) DEFAULT NULL COMMENT '金额',
`tax_rate` varchar(20) DEFAULT NULL COMMENT '税率',
`tax_amount` varchar(20) DEFAULT NULL COMMENT '税额',
`cph` varchar(50) DEFAULT NULL COMMENT '车牌号',
`lx` varchar(32) DEFAULT NULL COMMENT '类型',
`txrqq` varchar(32) DEFAULT NULL COMMENT '通行日期起',
`txrqz` varchar(32) DEFAULT NULL COMMENT '通行日期止',
`goods_num` varchar(50) DEFAULT NULL COMMENT '商品编码',
`is_discount` varchar(10) DEFAULT NULL COMMENT '是否折扣行',
PRIMARY KEY (`id`) USING BTREE,
KEY `unique` (`invoice_code`,`invoice_no`) USING BTREE,
KEY `uuid` (`uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='底账明细表';
-- ----------------------------
-- Table structure for t_dx_record_invoice_detail_sales
-- ----------------------------
DROP TABLE IF EXISTS `t_dx_record_invoice_detail_sales`;
CREATE TABLE `t_dx_record_invoice_detail_sales` (
`id` bigint(30) NOT NULL AUTO_INCREMENT,
`uuid` varchar(30) NOT NULL COMMENT '唯一标识(发票代码+发票号码)',
`invoice_code` varchar(20) DEFAULT NULL COMMENT '发票代码',
`invoice_no` varchar(10) DEFAULT NULL COMMENT '发票号码',
`detail_no` varchar(20) DEFAULT NULL COMMENT '明细序号',
`goods_name` varchar(255) DEFAULT NULL COMMENT '货物或应税劳务名称',
`model` varchar(80) DEFAULT NULL COMMENT '规格型号',
`unit` varchar(50) DEFAULT NULL COMMENT '单位',
`num` varchar(50) DEFAULT NULL COMMENT '数量',
`unit_price` varchar(50) DEFAULT NULL COMMENT '单价',
`detail_amount` varchar(20) DEFAULT NULL COMMENT '金额',
`tax_rate` varchar(20) DEFAULT NULL COMMENT '税率',
`tax_amount` varchar(20) DEFAULT NULL COMMENT '税额',
`cph` varchar(50) DEFAULT NULL COMMENT '车牌号',
`lx` varchar(32) DEFAULT NULL COMMENT '类型',
`txrqq` varchar(32) DEFAULT NULL COMMENT '通行日期起',
`txrqz` varchar(32) DEFAULT NULL COMMENT '通行日期止',
`goods_num` varchar(50) DEFAULT NULL COMMENT '商品编码',
`is_discount` varchar(10) DEFAULT NULL,
`incentive_flag` varchar(100) DEFAULT NULL COMMENT '优惠政策标识',
`zero_taxrate_flag` varchar(20) DEFAULT NULL COMMENT '零税率标识',
`added_tax_special` varchar(20) DEFAULT NULL COMMENT '增值税特殊管理',
PRIMARY KEY (`id`) USING BTREE,
KEY `unique` (`invoice_code`,`invoice_no`) USING BTREE,
KEY `uuid` (`uuid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1455386695937372163 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='底账明细表-销项';