CREATE TABLE `zc_bill_file_rel` (
  `zbfr_bill_id` varchar(64) NOT NULL COMMENT '往来账款ID(zc_bill_inf.zbi_id)',
  `zbfr_file_id` varchar(64) NOT NULL COMMENT '附件ID(zc_invoice_inf.pfi_file_id)',
  `zbfr_type` char(1) NOT NULL COMMENT '关联附件类型(0:合同附件, 1:物流附件, 2:其他附件)',
  PRIMARY KEY (`zbfr_bill_id`,`zbfr_file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='往来账款发票关联表';
