disposal_site.sql
8.24 KB
INSERT INTO `disposal_site` (`id`, `name`, `certificate_number`, `address`, `engineering_property`, `site_type`, `local_area`, `operating_area`, `trash_type`, `construction_unit`, `construction_unit_person`, `construction_unit_person_phone`, `validity_begin_date`, `validity_end_date`, `square_measure`, `surplus_square_measure`, `car_washing_facilities`, `exit_road_condition`, `lighting_facility`, `video_surveillance_facility`, `preparer`, `absorb_source`, `credit_status`, `handling_advice`, `electronic_fence`, `term_range`, `approval_document`, `approval_data`, `scene_photo`, `car_washing_facilities_image`, `safety_assessment_report`, `environmental_approval`, `authorization`, `other_information`, `company_ids`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `qr_code`, `audit_status`) VALUES (2, '去问驱蚊器为', '12311111111123', '测试测试测试123', '消纳（回填）场', '消纳（回填）场所', '天心区', '外环区域', '3,4', '测试测试测试123', '测试测试测试', '13111111111', '2023-11-01', '2023-12-02', '12', NULL, '钢架洗车平台', '未硬化', '无', '有', '测试测试测试123', NULL, '正常', '测试测试测试123', '112.984622,28.195581;112.983332,28.194043;112.988058,28.194578', '未超期', '/profile/upload/1700789566067/2.doc', '/profile/upload/1700789570928/1.doc', '/profile/upload/1700789572530/微信图片_20230612163108.png', '/profile/upload/1700724219168/1.doc', '/profile/upload/1700724219170/亚索灵魂莲华.jpg', '/profile/upload/1700724219173/4.doc', '/profile/upload/1700724219175/微信图片_20230612163108.png', '/profile/upload/1700724219177/冰川.jpg', NULL, 0, '2023-11-23 15:23:39', 'abc', '2023-11-24 15:22:02', 'abc', NULL, '新增审核中');
INSERT INTO `disposal_site` (`id`, `name`, `certificate_number`, `address`, `engineering_property`, `site_type`, `local_area`, `operating_area`, `trash_type`, `construction_unit`, `construction_unit_person`, `construction_unit_person_phone`, `validity_begin_date`, `validity_end_date`, `square_measure`, `surplus_square_measure`, `car_washing_facilities`, `exit_road_condition`, `lighting_facility`, `video_surveillance_facility`, `preparer`, `absorb_source`, `credit_status`, `handling_advice`, `electronic_fence`, `term_range`, `approval_document`, `approval_data`, `scene_photo`, `car_washing_facilities_image`, `safety_assessment_report`, `environmental_approval`, `authorization`, `other_information`, `company_ids`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `qr_code`, `audit_status`) VALUES (3, 'QFQWFQWFQ', 'ASD123213AAA', 'AAAA', '房建市政工程', '建筑垃圾资源化处置场', '芙蓉区', '中心区域', '1,5,4', '123123123213AAAA', '123123123123AA', '13333333333', '2023-11-24', '2023-11-30', '111A', NULL, '钢架洗车平台、过水槽', '未硬化', '无', '无', '123123AAAA', NULL, '正常', '312132132AAA', '113.181594,27.853221;113.18155,27.85335;113.181404,27.853246', '未超期', '/profile/upload/1700791776798/烦烦烦.pdf;/profile/upload/1700792396052/冰川.jpg', '/profile/upload/1700792396057/微信图片_20230612163108.png;/profile/upload/1700791776805/1.doc', '/profile/upload/1700789572530/微信图片_20230612163108.png;/profile/upload/1700791776809/烦烦烦.pdf;/profile/upload/1700792396059/1.doc', '/profile/upload/1700724219168/1.doc;/profile/upload/1700791776813/微信图片_20230612163108.png', '/profile/upload/1700724219170/亚索灵魂莲华.jpg;/profile/upload/1700791776815/冰川.jpg;/profile/upload/1700792396063/1.doc', '/profile/upload/1700724219173/4.doc;/profile/upload/1700791776824/雪山.jpeg;/profile/upload/1700792396065/1.doc', '/profile/upload/1700724219175/微信图片_20230612163108.png;/profile/upload/1700791776829/亚索灵魂莲华.jpg;/profile/upload/1700792396067/1.doc', '/profile/upload/1700724219177/冰川.jpg;/profile/upload/1700791776832/雪山.jpeg;/profile/upload/1700791776834/山.jpeg;/profile/upload/1700792396069/1.doc', NULL, 0, '2023-11-24 10:09:37', 'abc', '2023-11-24 15:32:48', 'abc', NULL, '新增审核中');
INSERT INTO `disposal_site` (`id`, `name`, `certificate_number`, `address`, `engineering_property`, `site_type`, `local_area`, `operating_area`, `trash_type`, `construction_unit`, `construction_unit_person`, `construction_unit_person_phone`, `validity_begin_date`, `validity_end_date`, `square_measure`, `surplus_square_measure`, `car_washing_facilities`, `exit_road_condition`, `lighting_facility`, `video_surveillance_facility`, `preparer`, `absorb_source`, `credit_status`, `handling_advice`, `electronic_fence`, `term_range`, `approval_document`, `approval_data`, `scene_photo`, `car_washing_facilities_image`, `safety_assessment_report`, `environmental_approval`, `authorization`, `other_information`, `company_ids`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `qr_code`, `audit_status`) VALUES (4, '垃圾1方法', '风飒飒东风 ', '12恶法士大夫', '平场工程', '建筑垃圾资源化处置场', '开福区', '外环区域', '2,3,5', '啊士大夫', '啊手动阀手动阀', '13111111111', '2023-11-30', '2023-12-01', '123', NULL, '钢架洗车平台、过水槽', '未硬化', '不适用', '有', '飞洒地方', NULL, '正常', '阿斯顿发射点发射点', '113.189595,27.987464;113.192275,27.989502;113.199583,27.988517;113.199147,27.984962;113.193903,27.984566', '未超期', '/profile/upload/1701074805739/雪山.jpeg', '/profile/upload/1701074805742/烦烦烦.pdf', '/profile/upload/1701074805746/2.doc', '', '', '', '', '', NULL, 0, '2023-11-27 16:46:46', 'abc', '2023-11-27 16:50:20', 'abc', NULL, '新增审核中');
INSERT INTO `disposal_site` (`id`, `name`, `certificate_number`, `address`, `engineering_property`, `site_type`, `local_area`, `operating_area`, `trash_type`, `construction_unit`, `construction_unit_person`, `construction_unit_person_phone`, `validity_begin_date`, `validity_end_date`, `square_measure`, `surplus_square_measure`, `car_washing_facilities`, `exit_road_condition`, `lighting_facility`, `video_surveillance_facility`, `preparer`, `absorb_source`, `credit_status`, `handling_advice`, `electronic_fence`, `term_range`, `approval_document`, `approval_data`, `scene_photo`, `car_washing_facilities_image`, `safety_assessment_report`, `environmental_approval`, `authorization`, `other_information`, `company_ids`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `qr_code`, `audit_status`) VALUES (5, '阿斯顿发射点', '发生的', '啊手动阀', '交通工程', '建筑垃圾资源化处置场', '天心区', '外环区域', '4,3', '爱的色放', '12312', '13111111111', '2023-12-21', '2024-01-03', '123', NULL, '钢架洗车平台、过水槽', '硬化', '无', '无', '123123', NULL, '正常', '123123123123', '113.068441,27.791877;113.068774,27.791816;113.069199,27.792615;113.072075,27.792595;113.071908,27.788863;113.067599,27.788906;113.067325,27.793184;113.068357,27.793231', '未超期', '/profile/upload/1701411924652/亚索灵魂莲华.jpg', '', '', '', '', '', '', '', NULL, 0, '2023-12-01 14:25:24', 'abc', NULL, NULL, NULL, '新增审核中');
INSERT INTO `disposal_site` (`id`, `name`, `certificate_number`, `address`, `engineering_property`, `site_type`, `local_area`, `operating_area`, `trash_type`, `construction_unit`, `construction_unit_person`, `construction_unit_person_phone`, `validity_begin_date`, `validity_end_date`, `square_measure`, `surplus_square_measure`, `car_washing_facilities`, `exit_road_condition`, `lighting_facility`, `video_surveillance_facility`, `preparer`, `absorb_source`, `credit_status`, `handling_advice`, `electronic_fence`, `term_range`, `approval_document`, `approval_data`, `scene_photo`, `car_washing_facilities_image`, `safety_assessment_report`, `environmental_approval`, `authorization`, `other_information`, `company_ids`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `qr_code`, `audit_status`) VALUES (6, '撒打发', '阿萨23 123', '123123123123123', NULL, '盾构土环保处置场', '天心区', '核心区域', '3,4', '123123', '123123', '13111111111', '2023-12-22', '2023-12-22', '123', NULL, '钢架洗车平台', '未硬化', '无', '不适用', '123', NULL, '正常', '123', '113.019175,28.199489;113.020549,28.167411;113.036342,28.184359', '未超期', '', '', '', '', '', '', '', '', NULL, 0, '2023-12-01 14:27:04', 'abc', NULL, NULL, NULL, '新增审核中');