zc_charge_inf.sql 1.4 KB

12345678910111213141516171819202122
  1. CREATE TABLE `zc_charge_inf` (
  2. `zci_id` varchar(64) NOT NULL COMMENT 'ID',
  3. `zci_finance_id` varchar(50) NOT NULL COMMENT '融资编号(zc_finance_record.zfr_id)',
  4. `zci_amount` varchar(20) NOT NULL COMMENT '融资费用',
  5. `zci_status` char(2) NOT NULL COMMENT '状态',
  6. `zci_invoice_status` char(1) NOT NULL COMMENT '发票状态',
  7. `zci_express_no` varchar(50) NOT NULL COMMENT '快递单号',
  8. `zci_profit_spare1` varchar(100) DEFAULT NULL COMMENT '备用字段1',
  9. `zci_profit_spare2` varchar(100) DEFAULT NULL COMMENT '备用字段2',
  10. `zci_profit_spare3` varchar(100) DEFAULT NULL COMMENT '备用字段3',
  11. `zci_profit_spare4` varchar(100) DEFAULT NULL COMMENT '备用字段4',
  12. `zci_profit_spare5` varchar(100) DEFAULT NULL COMMENT '备用字段5',
  13. `zci_profit_spare6` varchar(100) DEFAULT NULL COMMENT '备用字段6',
  14. `zci_profit_spare7` varchar(100) DEFAULT NULL COMMENT '备用字段7',
  15. `zci_profit_spare8` varchar(100) DEFAULT NULL COMMENT '备用字段8',
  16. `zci_profit_spare9` varchar(100) DEFAULT NULL COMMENT '备用字段9',
  17. `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  18. `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  19. `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  20. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  21. PRIMARY KEY (`zci_id`)
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='融资费用表'