123456 |
- 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 (`zbir_bill_id`,`zbir_invoice_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='往来账款发票关联表'
|