date_sys_dict.sql 5.9 KB

1234567891011121314151617181920212223
  1. #应用参数
  2. #融信类型
  3. insert into `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('272','融信类型','zfi_create_type','0','admin','2021-08-23 16:09:43','',NULL,NULL);
  4. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('608','0','供应商申请','0','zfi_create_type',NULL,NULL,'N','0','admin','2021-08-23 16:10:25','',NULL,NULL);
  5. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('609','1','核心开立','1','zfi_create_type',NULL,NULL,'N','0','admin','2021-08-23 16:10:37','',NULL,NULL);
  6. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('610','2','供应商开立','2','zfi_create_type',NULL,NULL,'N','0','admin','2021-08-23 16:10:57','',NULL,NULL);
  7. #资金方类型
  8. insert into `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('246','资金方类型','sys_smi_type','0','admin','2021-08-18 15:39:16','',NULL,NULL);
  9. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('522','0','国有银行','00','sys_smi_type',NULL,NULL,'N','0','admin','2021-08-18 15:55:38','',NULL,NULL);
  10. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('523','1','股份制银行','01','sys_smi_type',NULL,NULL,'N','0','admin','2021-08-18 15:55:59','',NULL,NULL);
  11. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('524','2','城商行','02','sys_smi_type',NULL,NULL,'N','0','admin','2021-08-18 15:56:14','',NULL,NULL);
  12. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('525','3','保理机构','03','sys_smi_type',NULL,NULL,'N','0','admin','2021-08-18 15:56:31','',NULL,NULL);
  13. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('526','4','证券公司','04','sys_smi_type',NULL,NULL,'N','0','admin','2021-08-18 15:56:48','',NULL,NULL);
  14. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('527','5','信托投资公司','05','sys_smi_type',NULL,NULL,'N','0','admin','2021-08-18 15:57:18','',NULL,NULL);
  15. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('528','6','基金管理公司','06','sys_smi_type',NULL,NULL,'N','0','admin','2021-08-18 15:57:40','',NULL,NULL);
  16. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('529','7','地方资产交易所','07','sys_smi_type',NULL,NULL,'N','0','admin','2021-08-18 15:58:09','',NULL,NULL);
  17. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('530','8','小贷公司','08','sys_smi_type',NULL,NULL,'N','0','admin','2021-08-18 15:58:30','',NULL,NULL);
  18. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('531','9','城投公司','09','sys_smi_type',NULL,NULL,'N','0','admin','2021-08-18 15:58:57','',NULL,NULL);
  19. #合作协议签署
  20. insert into `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('247','合作协议签署','sys_agreement_type','0','admin','2021-08-18 16:04:24','',NULL,NULL);
  21. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('532','0','已签署','00','sys_agreement_type',NULL,NULL,'N','0','admin','2021-08-18 16:09:45','',NULL,NULL);
  22. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('533','1','无需签署','01','sys_agreement_type',NULL,NULL,'N','0','admin','2021-08-18 16:11:44','',NULL,NULL);
  23. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('534','2','未签署','02','sys_agreement_type',NULL,NULL,'N','0','admin','2021-08-18 16:11:58','',NULL,NULL);