CREATE TABLE ap_invoice_plant_inventory_rel( API_INVOICE_ID varchar(20) NOT NULL COMMENT '发票id', API_DATE varchar(50) NOT NULL COMMENT '搜索日期', API_CONTRACT_ID varchar(50) NOT NULL COMMENT '合同id', PRIMARY KEY (API_INVOICE_ID,API_DATE,API_CONTRACT_ID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='发票厂区库存结算单关系表';