zc_bill_file_rel.sql 428 B

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