1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
| /*
| Navicat MySQL Data Transfer
|
| Source Server : 本地
| Source Server Version : 80300
| Source Host : localhost:3306
| Source Database : forest_management
|
| Target Server Type : MYSQL
| Target Server Version : 80300
| File Encoding : 65001
|
| Date: 2024-07-12 10:28:22
| */
|
| SET FOREIGN_KEY_CHECKS=0;
|
| -- ----------------------------
| -- Table structure for inventories_supplies
| -- ----------------------------
| DROP TABLE IF EXISTS `inventories_supplies`;
| CREATE TABLE `inventories_supplies` (
| `id` bigint NOT NULL,
| `materials_id` bigint DEFAULT NULL COMMENT '仓库id',
| `pdr_id` bigint DEFAULT NULL COMMENT '盘点人id',
| `pd_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '盘点时间',
| `pdr_name` varchar(255) DEFAULT NULL COMMENT '盘点人名称',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| PRIMARY KEY (`id`)
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='物资盘点';
|
| -- ----------------------------
| -- Records of inventories_supplies
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for inventories_supplies_info
| -- ----------------------------
| DROP TABLE IF EXISTS `inventories_supplies_info`;
| CREATE TABLE `inventories_supplies_info` (
| `id` bigint NOT NULL,
| `supplies_id` bigint DEFAULT NULL COMMENT '盘点数据id',
| `rk_id` bigint DEFAULT NULL COMMENT '入库id',
| `supplies_num` bigint DEFAULT '0' COMMENT ' 盘点数量',
| `zk_num` bigint DEFAULT '0' COMMENT '在库数量',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `type` int DEFAULT '1' COMMENT '是否匹配 1已匹配，2未匹配',
| PRIMARY KEY (`id`)
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='物资盘点明细';
|
| -- ----------------------------
| -- Records of inventories_supplies_info
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for management_goods_materials
| -- ----------------------------
| DROP TABLE IF EXISTS `management_goods_materials`;
| CREATE TABLE `management_goods_materials` (
| `id` bigint NOT NULL,
| `repertory_sum` bigint DEFAULT '0' COMMENT '库存总数',
| `repertory_zhai` bigint DEFAULT '0' COMMENT '在库存的',
| `repertory_chu` bigint DEFAULT '0' COMMENT '出库存的',
| `repertory_yishi` bigint DEFAULT '0' COMMENT '遗失库存的',
| `check_num` bigint DEFAULT '0' COMMENT '盘点数量',
| `management_id` bigint DEFAULT NULL COMMENT '仓库ID',
| `goods_materials_id` bigint DEFAULT NULL COMMENT '物资id',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `repertory` bigint DEFAULT '0' COMMENT '预警库存',
| PRIMARY KEY (`id`)
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='仓库到物资的中间表';
|
| -- ----------------------------
| -- Records of management_goods_materials
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_audit
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_audit`;
| CREATE TABLE `sl_audit` (
| `id` bigint NOT NULL,
| `rk_id` int DEFAULT NULL COMMENT '入库管理id',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `state` int DEFAULT NULL COMMENT '1 待管理员审核，2 待主管审核，3 待主任审核，4 已通过，5 已拒绝',
| `type` int DEFAULT NULL COMMENT '1 入库审核，2 出库审核，3 是转移审核',
| `cause` varchar(0) DEFAULT NULL COMMENT '拒绝原因',
| `shenh_id` varchar(0) DEFAULT NULL COMMENT '当前审核人审核人id',
| `sys_id` bigint DEFAULT NULL COMMENT '发起id',
| `management_id` bigint DEFAULT NULL COMMENT '仓库id',
| `zymanagement_id` bigint DEFAULT NULL COMMENT '被转移仓库id',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='审核记录';
|
| -- ----------------------------
| -- Records of sl_audit
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_audit_record
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_audit_record`;
| CREATE TABLE `sl_audit_record` (
| `id` bigint NOT NULL,
| `audit_id` bigint DEFAULT NULL COMMENT '审核记录的',
| `shenh_id` varchar(0) DEFAULT NULL COMMENT '审核人id',
| `type` int DEFAULT NULL COMMENT '1 是管理员审核，2 主管审核，3 是主任审核',
| `state` int DEFAULT NULL COMMENT '1 待审核，2 是通过，3 是拒绝',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `shenh_name` varchar(255) DEFAULT NULL COMMENT '审核人名称',
| `shenh_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '审核时间',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='审核管理';
|
| -- ----------------------------
| -- Records of sl_audit_record
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_equipment
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_equipment`;
| CREATE TABLE `sl_equipment` (
| `id` bigint NOT NULL,
| `equipment_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备名称',
| `equipment_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备编号',
| `type` int DEFAULT NULL COMMENT '1 屏幕设备，2 扫描设备',
| `management_id` bigint DEFAULT NULL COMMENT '仓库ID',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='设备管理';
|
| -- ----------------------------
| -- Records of sl_equipment
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_goods_materials
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_goods_materials`;
| CREATE TABLE `sl_goods_materials` (
| `id` bigint NOT NULL,
| `goods_materials_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
| `is_consume` int DEFAULT NULL COMMENT '1 是非消耗，2是消耗 ',
| `repertory` int DEFAULT NULL COMMENT '预警库存',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='物资管理';
|
| -- ----------------------------
| -- Records of sl_goods_materials
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_goods_shelf
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_goods_shelf`;
| CREATE TABLE `sl_goods_shelf` (
| `id` bigint NOT NULL,
| `goods_shelf_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '货架名称',
| `store_management_id` int DEFAULT NULL COMMENT '仓库id',
| `is_store_management` int DEFAULT '1' COMMENT '是否放 1否，2 是',
| `img_id` int DEFAULT NULL COMMENT '图片id',
| `zb_x` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '仓库在图片坐标X轴',
| `zb_y` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '仓库在图片坐标y轴',
| `store_management_number` int DEFAULT NULL COMMENT '仓库层数 1代表一层，2代表两层，3代表三层',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='货架表';
|
| -- ----------------------------
| -- Records of sl_goods_shelf
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_region
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_region`;
| CREATE TABLE `sl_region` (
| `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
| `name` varchar(100) DEFAULT NULL COMMENT '城市名称',
| `code` varchar(100) DEFAULT NULL COMMENT 'code',
| `citycode` varchar(100) DEFAULT NULL COMMENT '城市code',
| `parent_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '父级ID',
| `english` varchar(200) DEFAULT NULL COMMENT '英文名称',
| `level` int DEFAULT NULL COMMENT '等级',
| `hierarchy` varchar(255) DEFAULT NULL COMMENT '层级',
| `all_name` varchar(255) DEFAULT NULL COMMENT '区域全称',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB AUTO_INCREMENT=9483 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='省市区三级联动';
|
| -- ----------------------------
| -- Records of sl_region
| -- ----------------------------
| INSERT INTO `sl_region` VALUES ('9006', '青海省', '630000000000', '630000000000', '0', null, '1', null, '青海省');
| INSERT INTO `sl_region` VALUES ('9007', '西宁市', '630100000000', '630100000000', '630000000000', null, '2', null, '青海省西宁市');
| INSERT INTO `sl_region` VALUES ('9008', '海东市', '630200000000', '630200000000', '630000000000', null, '2', null, '青海省海东市');
| INSERT INTO `sl_region` VALUES ('9009', '海北藏族自治州', '632200000000', '632200000000', '630000000000', null, '2', null, '青海省海北藏族自治州');
| INSERT INTO `sl_region` VALUES ('9010', '黄南藏族自治州', '632300000000', '632300000000', '630000000000', null, '2', null, '青海省黄南藏族自治州');
| INSERT INTO `sl_region` VALUES ('9011', '海南藏族自治州', '632500000000', '632500000000', '630000000000', null, '2', null, '青海省海南藏族自治州');
| INSERT INTO `sl_region` VALUES ('9012', '果洛藏族自治州', '632600000000', '632600000000', '630000000000', null, '2', null, '青海省果洛藏族自治州');
| INSERT INTO `sl_region` VALUES ('9013', '玉树藏族自治州', '632700000000', '632700000000', '630000000000', null, '2', null, '青海省玉树藏族自治州');
| INSERT INTO `sl_region` VALUES ('9014', '海西蒙古族藏族自治州', '632800000000', '632800000000', '630000000000', null, '2', null, '青海省海西蒙古族藏族自治州');
| INSERT INTO `sl_region` VALUES ('9015', '市辖区', '630101000000', '630101000000', '630100000000', null, '3', null, '青海省西宁市市辖区');
| INSERT INTO `sl_region` VALUES ('9016', '城东区', '630102000000', '630102000000', '630100000000', null, '3', null, '青海省西宁市城东区');
| INSERT INTO `sl_region` VALUES ('9017', '城中区', '630103000000', '630103000000', '630100000000', null, '3', null, '青海省西宁市城中区');
| INSERT INTO `sl_region` VALUES ('9018', '城西区', '630104000000', '630104000000', '630100000000', null, '3', null, '青海省西宁市城西区');
| INSERT INTO `sl_region` VALUES ('9019', '城北区', '630105000000', '630105000000', '630100000000', null, '3', null, '青海省西宁市城北区');
| INSERT INTO `sl_region` VALUES ('9020', '湟中区', '630106000000', '630106000000', '630100000000', null, '3', null, '青海省西宁市湟中区');
| INSERT INTO `sl_region` VALUES ('9021', '大通回族土族自治县', '630121000000', '630121000000', '630100000000', null, '3', null, '青海省西宁市大通回族土族自治县');
| INSERT INTO `sl_region` VALUES ('9022', '湟源县', '630123000000', '630123000000', '630100000000', null, '3', null, '青海省西宁市湟源县');
| INSERT INTO `sl_region` VALUES ('9023', '乐都区', '630202000000', '630202000000', '630200000000', null, '3', null, '青海省海东市乐都区');
| INSERT INTO `sl_region` VALUES ('9024', '平安区', '630203000000', '630203000000', '630200000000', null, '3', null, '青海省海东市平安区');
| INSERT INTO `sl_region` VALUES ('9025', '民和回族土族自治县', '630222000000', '630222000000', '630200000000', null, '3', null, '青海省海东市民和回族土族自治县');
| INSERT INTO `sl_region` VALUES ('9026', '互助土族自治县', '630223000000', '630223000000', '630200000000', null, '3', null, '青海省海东市互助土族自治县');
| INSERT INTO `sl_region` VALUES ('9027', '化隆回族自治县', '630224000000', '630224000000', '630200000000', null, '3', null, '青海省海东市化隆回族自治县');
| INSERT INTO `sl_region` VALUES ('9028', '循化撒拉族自治县', '630225000000', '630225000000', '630200000000', null, '3', null, '青海省海东市循化撒拉族自治县');
| INSERT INTO `sl_region` VALUES ('9029', '门源回族自治县', '632221000000', '632221000000', '632200000000', null, '3', null, '青海省海北藏族自治州门源回族自治县');
| INSERT INTO `sl_region` VALUES ('9030', '祁连县', '632222000000', '632222000000', '632200000000', null, '3', null, '青海省海北藏族自治州祁连县');
| INSERT INTO `sl_region` VALUES ('9031', '海晏县', '632223000000', '632223000000', '632200000000', null, '3', null, '青海省海北藏族自治州海晏县');
| INSERT INTO `sl_region` VALUES ('9032', '刚察县', '632224000000', '632224000000', '632200000000', null, '3', null, '青海省海北藏族自治州刚察县');
| INSERT INTO `sl_region` VALUES ('9033', '同仁市', '632301000000', '632301000000', '632300000000', null, '3', null, '青海省黄南藏族自治州同仁市');
| INSERT INTO `sl_region` VALUES ('9034', '尖扎县', '632322000000', '632322000000', '632300000000', null, '3', null, '青海省黄南藏族自治州尖扎县');
| INSERT INTO `sl_region` VALUES ('9035', '泽库县', '632323000000', '632323000000', '632300000000', null, '3', null, '青海省黄南藏族自治州泽库县');
| INSERT INTO `sl_region` VALUES ('9036', '河南蒙古族自治县', '632324000000', '632324000000', '632300000000', null, '3', null, '青海省黄南藏族自治州河南蒙古族自治县');
| INSERT INTO `sl_region` VALUES ('9037', '共和县', '632521000000', '632521000000', '632500000000', null, '3', null, '青海省海南藏族自治州共和县');
| INSERT INTO `sl_region` VALUES ('9038', '同德县', '632522000000', '632522000000', '632500000000', null, '3', null, '青海省海南藏族自治州同德县');
| INSERT INTO `sl_region` VALUES ('9039', '贵德县', '632523000000', '632523000000', '632500000000', null, '3', null, '青海省海南藏族自治州贵德县');
| INSERT INTO `sl_region` VALUES ('9040', '兴海县', '632524000000', '632524000000', '632500000000', null, '3', null, '青海省海南藏族自治州兴海县');
| INSERT INTO `sl_region` VALUES ('9041', '贵南县', '632525000000', '632525000000', '632500000000', null, '3', null, '青海省海南藏族自治州贵南县');
| INSERT INTO `sl_region` VALUES ('9042', '玛沁县', '632621000000', '632621000000', '632600000000', null, '3', null, '青海省果洛藏族自治州玛沁县');
| INSERT INTO `sl_region` VALUES ('9043', '班玛县', '632622000000', '632622000000', '632600000000', null, '3', null, '青海省果洛藏族自治州班玛县');
| INSERT INTO `sl_region` VALUES ('9044', '甘德县', '632623000000', '632623000000', '632600000000', null, '3', null, '青海省果洛藏族自治州甘德县');
| INSERT INTO `sl_region` VALUES ('9045', '达日县', '632624000000', '632624000000', '632600000000', null, '3', null, '青海省果洛藏族自治州达日县');
| INSERT INTO `sl_region` VALUES ('9046', '久治县', '632625000000', '632625000000', '632600000000', null, '3', null, '青海省果洛藏族自治州久治县');
| INSERT INTO `sl_region` VALUES ('9047', '玛多县', '632626000000', '632626000000', '632600000000', null, '3', null, '青海省果洛藏族自治州玛多县');
| INSERT INTO `sl_region` VALUES ('9048', '玉树市', '632701000000', '632701000000', '632700000000', null, '3', null, '青海省玉树藏族自治州玉树市');
| INSERT INTO `sl_region` VALUES ('9049', '杂多县', '632722000000', '632722000000', '632700000000', null, '3', null, '青海省玉树藏族自治州杂多县');
| INSERT INTO `sl_region` VALUES ('9050', '称多县', '632723000000', '632723000000', '632700000000', null, '3', null, '青海省玉树藏族自治州称多县');
| INSERT INTO `sl_region` VALUES ('9051', '治多县', '632724000000', '632724000000', '632700000000', null, '3', null, '青海省玉树藏族自治州治多县');
| INSERT INTO `sl_region` VALUES ('9052', '囊谦县', '632725000000', '632725000000', '632700000000', null, '3', null, '青海省玉树藏族自治州囊谦县');
| INSERT INTO `sl_region` VALUES ('9053', '曲麻莱县', '632726000000', '632726000000', '632700000000', null, '3', null, '青海省玉树藏族自治州曲麻莱县');
| INSERT INTO `sl_region` VALUES ('9054', '格尔木市', '632801000000', '632801000000', '632800000000', null, '3', null, '青海省海西蒙古族藏族自治州格尔木市');
| INSERT INTO `sl_region` VALUES ('9055', '德令哈市', '632802000000', '632802000000', '632800000000', null, '3', null, '青海省海西蒙古族藏族自治州德令哈市');
| INSERT INTO `sl_region` VALUES ('9056', '茫崖市', '632803000000', '632803000000', '632800000000', null, '3', null, '青海省海西蒙古族藏族自治州茫崖市');
| INSERT INTO `sl_region` VALUES ('9057', '乌兰县', '632821000000', '632821000000', '632800000000', null, '3', null, '青海省海西蒙古族藏族自治州乌兰县');
| INSERT INTO `sl_region` VALUES ('9058', '都兰县', '632822000000', '632822000000', '632800000000', null, '3', null, '青海省海西蒙古族藏族自治州都兰县');
| INSERT INTO `sl_region` VALUES ('9059', '天峻县', '632823000000', '632823000000', '632800000000', null, '3', null, '青海省海西蒙古族藏族自治州天峻县');
| INSERT INTO `sl_region` VALUES ('9060', '大柴旦行政委员会', '632857000000', '632857000000', '632800000000', null, '3', null, '青海省海西蒙古族藏族自治州大柴旦行政委员会');
| INSERT INTO `sl_region` VALUES ('9061', '东关大街街道', '630102001000', '630102001000', '630102000000', null, '4', null, '青海省西宁市城东区东关大街街道');
| INSERT INTO `sl_region` VALUES ('9062', '清真巷街道', '630102002000', '630102002000', '630102000000', null, '4', null, '青海省西宁市城东区清真巷街道');
| INSERT INTO `sl_region` VALUES ('9063', '大众街街道', '630102003000', '630102003000', '630102000000', null, '4', null, '青海省西宁市城东区大众街街道');
| INSERT INTO `sl_region` VALUES ('9064', '周家泉街道', '630102004000', '630102004000', '630102000000', null, '4', null, '青海省西宁市城东区周家泉街道');
| INSERT INTO `sl_region` VALUES ('9065', '火车站街道', '630102005000', '630102005000', '630102000000', null, '4', null, '青海省西宁市城东区火车站街道');
| INSERT INTO `sl_region` VALUES ('9066', '八一路街道', '630102006000', '630102006000', '630102000000', null, '4', null, '青海省西宁市城东区八一路街道');
| INSERT INTO `sl_region` VALUES ('9067', '林家崖街道', '630102007000', '630102007000', '630102000000', null, '4', null, '青海省西宁市城东区林家崖街道');
| INSERT INTO `sl_region` VALUES ('9068', '乐家湾镇', '630102100000', '630102100000', '630102000000', null, '4', null, '青海省西宁市城东区乐家湾镇');
| INSERT INTO `sl_region` VALUES ('9069', '韵家口镇', '630102101000', '630102101000', '630102000000', null, '4', null, '青海省西宁市城东区韵家口镇');
| INSERT INTO `sl_region` VALUES ('9070', '东川工业园', '630102400000', '630102400000', '630102000000', null, '4', null, '青海省西宁市城东区东川工业园');
| INSERT INTO `sl_region` VALUES ('9071', '人民街街道', '630103001000', '630103001000', '630103000000', null, '4', null, '青海省西宁市城中区人民街街道');
| INSERT INTO `sl_region` VALUES ('9072', '南滩街道', '630103002000', '630103002000', '630103000000', null, '4', null, '青海省西宁市城中区南滩街道');
| INSERT INTO `sl_region` VALUES ('9073', '仓门街街道', '630103003000', '630103003000', '630103000000', null, '4', null, '青海省西宁市城中区仓门街街道');
| INSERT INTO `sl_region` VALUES ('9074', '礼让街街道', '630103004000', '630103004000', '630103000000', null, '4', null, '青海省西宁市城中区礼让街街道');
| INSERT INTO `sl_region` VALUES ('9075', '饮马街街道', '630103005000', '630103005000', '630103000000', null, '4', null, '青海省西宁市城中区饮马街街道');
| INSERT INTO `sl_region` VALUES ('9076', '南川东路街道', '630103006000', '630103006000', '630103000000', null, '4', null, '青海省西宁市城中区南川东路街道');
| INSERT INTO `sl_region` VALUES ('9077', '南川西路街道', '630103007000', '630103007000', '630103000000', null, '4', null, '青海省西宁市城中区南川西路街道');
| INSERT INTO `sl_region` VALUES ('9078', '总寨镇', '630103100000', '630103100000', '630103000000', null, '4', null, '青海省西宁市城中区总寨镇');
| INSERT INTO `sl_region` VALUES ('9079', '南川工业园', '630103400000', '630103400000', '630103000000', null, '4', null, '青海省西宁市城中区南川工业园');
| INSERT INTO `sl_region` VALUES ('9080', '西关大街街道', '630104001000', '630104001000', '630104000000', null, '4', null, '青海省西宁市城西区西关大街街道');
| INSERT INTO `sl_region` VALUES ('9081', '古城台街道', '630104002000', '630104002000', '630104000000', null, '4', null, '青海省西宁市城西区古城台街道');
| INSERT INTO `sl_region` VALUES ('9082', '虎台街道', '630104003000', '630104003000', '630104000000', null, '4', null, '青海省西宁市城西区虎台街道');
| INSERT INTO `sl_region` VALUES ('9083', '胜利路街道', '630104004000', '630104004000', '630104000000', null, '4', null, '青海省西宁市城西区胜利路街道');
| INSERT INTO `sl_region` VALUES ('9084', '兴海路街道', '630104005000', '630104005000', '630104000000', null, '4', null, '青海省西宁市城西区兴海路街道');
| INSERT INTO `sl_region` VALUES ('9085', '文汇路街道', '630104006000', '630104006000', '630104000000', null, '4', null, '青海省西宁市城西区文汇路街道');
| INSERT INTO `sl_region` VALUES ('9086', '通海路街道', '630104007000', '630104007000', '630104000000', null, '4', null, '青海省西宁市城西区通海路街道');
| INSERT INTO `sl_region` VALUES ('9087', '彭家寨镇', '630104100000', '630104100000', '630104000000', null, '4', null, '青海省西宁市城西区彭家寨镇');
| INSERT INTO `sl_region` VALUES ('9088', '朝阳街道', '630105001000', '630105001000', '630105000000', null, '4', null, '青海省西宁市城北区朝阳街道');
| INSERT INTO `sl_region` VALUES ('9089', '小桥大街街道', '630105002000', '630105002000', '630105000000', null, '4', null, '青海省西宁市城北区小桥大街街道');
| INSERT INTO `sl_region` VALUES ('9090', '马坊街道', '630105003000', '630105003000', '630105000000', null, '4', null, '青海省西宁市城北区马坊街道');
| INSERT INTO `sl_region` VALUES ('9091', '火车西站街道', '630105004000', '630105004000', '630105000000', null, '4', null, '青海省西宁市城北区火车西站街道');
| INSERT INTO `sl_region` VALUES ('9092', '大堡子镇', '630105100000', '630105100000', '630105000000', null, '4', null, '青海省西宁市城北区大堡子镇');
| INSERT INTO `sl_region` VALUES ('9093', '廿里铺镇', '630105101000', '630105101000', '630105000000', null, '4', null, '青海省西宁市城北区廿里铺镇');
| INSERT INTO `sl_region` VALUES ('9094', '生物科技产业园', '630105400000', '630105400000', '630105000000', null, '4', null, '青海省西宁市城北区生物科技产业园');
| INSERT INTO `sl_region` VALUES ('9095', '康川街道', '630106001000', '630106001000', '630106000000', null, '4', null, '青海省西宁市湟中区康川街道');
| INSERT INTO `sl_region` VALUES ('9096', '田家寨镇', '630106100000', '630106100000', '630106000000', null, '4', null, '青海省西宁市湟中区田家寨镇');
| INSERT INTO `sl_region` VALUES ('9097', '上新庄镇', '630106101000', '630106101000', '630106000000', null, '4', null, '青海省西宁市湟中区上新庄镇');
| INSERT INTO `sl_region` VALUES ('9098', '鲁沙尔镇', '630106102000', '630106102000', '630106000000', null, '4', null, '青海省西宁市湟中区鲁沙尔镇');
| INSERT INTO `sl_region` VALUES ('9099', '甘河滩镇', '630106103000', '630106103000', '630106000000', null, '4', null, '青海省西宁市湟中区甘河滩镇');
| INSERT INTO `sl_region` VALUES ('9100', '共和镇', '630106104000', '630106104000', '630106000000', null, '4', null, '青海省西宁市湟中区共和镇');
| INSERT INTO `sl_region` VALUES ('9101', '多巴镇', '630106105000', '630106105000', '630106000000', null, '4', null, '青海省西宁市湟中区多巴镇');
| INSERT INTO `sl_region` VALUES ('9102', '拦隆口镇', '630106106000', '630106106000', '630106000000', null, '4', null, '青海省西宁市湟中区拦隆口镇');
| INSERT INTO `sl_region` VALUES ('9103', '上五庄镇', '630106107000', '630106107000', '630106000000', null, '4', null, '青海省西宁市湟中区上五庄镇');
| INSERT INTO `sl_region` VALUES ('9104', '李家山镇', '630106108000', '630106108000', '630106000000', null, '4', null, '青海省西宁市湟中区李家山镇');
| INSERT INTO `sl_region` VALUES ('9105', '西堡镇', '630106109000', '630106109000', '630106000000', null, '4', null, '青海省西宁市湟中区西堡镇');
| INSERT INTO `sl_region` VALUES ('9106', '群加藏族乡', '630106200000', '630106200000', '630106000000', null, '4', null, '青海省西宁市湟中区群加藏族乡');
| INSERT INTO `sl_region` VALUES ('9107', '土门关乡', '630106201000', '630106201000', '630106000000', null, '4', null, '青海省西宁市湟中区土门关乡');
| INSERT INTO `sl_region` VALUES ('9108', '汉东回族乡', '630106202000', '630106202000', '630106000000', null, '4', null, '青海省西宁市湟中区汉东回族乡');
| INSERT INTO `sl_region` VALUES ('9109', '大才回族乡', '630106203000', '630106203000', '630106000000', null, '4', null, '青海省西宁市湟中区大才回族乡');
| INSERT INTO `sl_region` VALUES ('9110', '海子沟乡', '630106204000', '630106204000', '630106000000', null, '4', null, '青海省西宁市湟中区海子沟乡');
| INSERT INTO `sl_region` VALUES ('9111', '甘河工业园', '630106400000', '630106400000', '630106000000', null, '4', null, '青海省西宁市湟中区甘河工业园');
| INSERT INTO `sl_region` VALUES ('9112', '桥头镇', '630121100000', '630121100000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县桥头镇');
| INSERT INTO `sl_region` VALUES ('9113', '城关镇', '630121101000', '630121101000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县城关镇');
| INSERT INTO `sl_region` VALUES ('9114', '塔尔镇', '630121102000', '630121102000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县塔尔镇');
| INSERT INTO `sl_region` VALUES ('9115', '东峡镇', '630121103000', '630121103000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县东峡镇');
| INSERT INTO `sl_region` VALUES ('9116', '黄家寨镇', '630121104000', '630121104000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县黄家寨镇');
| INSERT INTO `sl_region` VALUES ('9117', '长宁镇', '630121105000', '630121105000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县长宁镇');
| INSERT INTO `sl_region` VALUES ('9118', '景阳镇', '630121106000', '630121106000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县景阳镇');
| INSERT INTO `sl_region` VALUES ('9119', '多林镇', '630121107000', '630121107000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县多林镇');
| INSERT INTO `sl_region` VALUES ('9120', '新庄镇', '630121108000', '630121108000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县新庄镇');
| INSERT INTO `sl_region` VALUES ('9121', '青林乡', '630121200000', '630121200000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县青林乡');
| INSERT INTO `sl_region` VALUES ('9122', '青山乡', '630121201000', '630121201000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县青山乡');
| INSERT INTO `sl_region` VALUES ('9123', '逊让乡', '630121202000', '630121202000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县逊让乡');
| INSERT INTO `sl_region` VALUES ('9124', '极乐乡', '630121203000', '630121203000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县极乐乡');
| INSERT INTO `sl_region` VALUES ('9125', '石山乡', '630121204000', '630121204000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县石山乡');
| INSERT INTO `sl_region` VALUES ('9126', '宝库乡', '630121205000', '630121205000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县宝库乡');
| INSERT INTO `sl_region` VALUES ('9127', '斜沟乡', '630121206000', '630121206000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县斜沟乡');
| INSERT INTO `sl_region` VALUES ('9128', '良教乡', '630121207000', '630121207000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县良教乡');
| INSERT INTO `sl_region` VALUES ('9129', '向化藏族乡', '630121208000', '630121208000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县向化藏族乡');
| INSERT INTO `sl_region` VALUES ('9130', '桦林乡', '630121209000', '630121209000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县桦林乡');
| INSERT INTO `sl_region` VALUES ('9131', '朔北藏族乡', '630121210000', '630121210000', '630121000000', null, '4', null, '青海省西宁市大通回族土族自治县朔北藏族乡');
| INSERT INTO `sl_region` VALUES ('9132', '城关镇', '630123100000', '630123100000', '630123000000', null, '4', null, '青海省西宁市湟源县城关镇');
| INSERT INTO `sl_region` VALUES ('9133', '大华镇', '630123101000', '630123101000', '630123000000', null, '4', null, '青海省西宁市湟源县大华镇');
| INSERT INTO `sl_region` VALUES ('9134', '东峡乡', '630123200000', '630123200000', '630123000000', null, '4', null, '青海省西宁市湟源县东峡乡');
| INSERT INTO `sl_region` VALUES ('9135', '日月藏族乡', '630123201000', '630123201000', '630123000000', null, '4', null, '青海省西宁市湟源县日月藏族乡');
| INSERT INTO `sl_region` VALUES ('9136', '和平乡', '630123202000', '630123202000', '630123000000', null, '4', null, '青海省西宁市湟源县和平乡');
| INSERT INTO `sl_region` VALUES ('9137', '波航乡', '630123203000', '630123203000', '630123000000', null, '4', null, '青海省西宁市湟源县波航乡');
| INSERT INTO `sl_region` VALUES ('9138', '申中乡', '630123204000', '630123204000', '630123000000', null, '4', null, '青海省西宁市湟源县申中乡');
| INSERT INTO `sl_region` VALUES ('9139', '巴燕乡', '630123205000', '630123205000', '630123000000', null, '4', null, '青海省西宁市湟源县巴燕乡');
| INSERT INTO `sl_region` VALUES ('9140', '寺寨乡', '630123206000', '630123206000', '630123000000', null, '4', null, '青海省西宁市湟源县寺寨乡');
| INSERT INTO `sl_region` VALUES ('9141', '碾伯镇', '630202100000', '630202100000', '630202000000', null, '4', null, '青海省海东市乐都区碾伯镇');
| INSERT INTO `sl_region` VALUES ('9142', '雨润镇', '630202101000', '630202101000', '630202000000', null, '4', null, '青海省海东市乐都区雨润镇');
| INSERT INTO `sl_region` VALUES ('9143', '寿乐镇', '630202102000', '630202102000', '630202000000', null, '4', null, '青海省海东市乐都区寿乐镇');
| INSERT INTO `sl_region` VALUES ('9144', '高庙镇', '630202103000', '630202103000', '630202000000', null, '4', null, '青海省海东市乐都区高庙镇');
| INSERT INTO `sl_region` VALUES ('9145', '洪水镇', '630202104000', '630202104000', '630202000000', null, '4', null, '青海省海东市乐都区洪水镇');
| INSERT INTO `sl_region` VALUES ('9146', '高店镇', '630202105000', '630202105000', '630202000000', null, '4', null, '青海省海东市乐都区高店镇');
| INSERT INTO `sl_region` VALUES ('9147', '瞿昙镇', '630202106000', '630202106000', '630202000000', null, '4', null, '青海省海东市乐都区瞿昙镇');
| INSERT INTO `sl_region` VALUES ('9148', '共和乡', '630202200000', '630202200000', '630202000000', null, '4', null, '青海省海东市乐都区共和乡');
| INSERT INTO `sl_region` VALUES ('9149', '中岭乡', '630202201000', '630202201000', '630202000000', null, '4', null, '青海省海东市乐都区中岭乡');
| INSERT INTO `sl_region` VALUES ('9150', '李家乡', '630202202000', '630202202000', '630202000000', null, '4', null, '青海省海东市乐都区李家乡');
| INSERT INTO `sl_region` VALUES ('9151', '下营乡', '630202203000', '630202203000', '630202000000', null, '4', null, '青海省海东市乐都区下营乡');
| INSERT INTO `sl_region` VALUES ('9152', '芦花乡', '630202204000', '630202204000', '630202000000', null, '4', null, '青海省海东市乐都区芦花乡');
| INSERT INTO `sl_region` VALUES ('9153', '马营乡', '630202205000', '630202205000', '630202000000', null, '4', null, '青海省海东市乐都区马营乡');
| INSERT INTO `sl_region` VALUES ('9154', '马厂乡', '630202206000', '630202206000', '630202000000', null, '4', null, '青海省海东市乐都区马厂乡');
| INSERT INTO `sl_region` VALUES ('9155', '蒲台乡', '630202207000', '630202207000', '630202000000', null, '4', null, '青海省海东市乐都区蒲台乡');
| INSERT INTO `sl_region` VALUES ('9156', '中坝乡', '630202208000', '630202208000', '630202000000', null, '4', null, '青海省海东市乐都区中坝乡');
| INSERT INTO `sl_region` VALUES ('9157', '峰堆乡', '630202209000', '630202209000', '630202000000', null, '4', null, '青海省海东市乐都区峰堆乡');
| INSERT INTO `sl_region` VALUES ('9158', '城台乡', '630202210000', '630202210000', '630202000000', null, '4', null, '青海省海东市乐都区城台乡');
| INSERT INTO `sl_region` VALUES ('9159', '达拉乡', '630202211000', '630202211000', '630202000000', null, '4', null, '青海省海东市乐都区达拉乡');
| INSERT INTO `sl_region` VALUES ('9160', '海东工业园区乐都工业园', '630202400000', '630202400000', '630202000000', null, '4', null, '青海省海东市乐都区海东工业园区乐都工业园');
| INSERT INTO `sl_region` VALUES ('9161', '平安镇', '630203100000', '630203100000', '630203000000', null, '4', null, '青海省海东市平安区平安镇');
| INSERT INTO `sl_region` VALUES ('9162', '小峡镇', '630203101000', '630203101000', '630203000000', null, '4', null, '青海省海东市平安区小峡镇');
| INSERT INTO `sl_region` VALUES ('9163', '三合镇', '630203102000', '630203102000', '630203000000', null, '4', null, '青海省海东市平安区三合镇');
| INSERT INTO `sl_region` VALUES ('9164', '洪水泉乡', '630203200000', '630203200000', '630203000000', null, '4', null, '青海省海东市平安区洪水泉乡');
| INSERT INTO `sl_region` VALUES ('9165', '石灰窑乡', '630203201000', '630203201000', '630203000000', null, '4', null, '青海省海东市平安区石灰窑乡');
| INSERT INTO `sl_region` VALUES ('9166', '古城乡', '630203202000', '630203202000', '630203000000', null, '4', null, '青海省海东市平安区古城乡');
| INSERT INTO `sl_region` VALUES ('9167', '沙沟乡', '630203203000', '630203203000', '630203000000', null, '4', null, '青海省海东市平安区沙沟乡');
| INSERT INTO `sl_region` VALUES ('9168', '巴藏沟乡', '630203204000', '630203204000', '630203000000', null, '4', null, '青海省海东市平安区巴藏沟乡');
| INSERT INTO `sl_region` VALUES ('9169', '曹家堡临空综合经济园平安园区', '630203400000', '630203400000', '630203000000', null, '4', null, '青海省海东市平安区曹家堡临空综合经济园平安园区');
| INSERT INTO `sl_region` VALUES ('9170', '川口镇', '630222100000', '630222100000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县川口镇');
| INSERT INTO `sl_region` VALUES ('9171', '古鄯镇', '630222101000', '630222101000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县古鄯镇');
| INSERT INTO `sl_region` VALUES ('9172', '马营镇', '630222102000', '630222102000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县马营镇');
| INSERT INTO `sl_region` VALUES ('9173', '官亭镇', '630222103000', '630222103000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县官亭镇');
| INSERT INTO `sl_region` VALUES ('9174', '巴州镇', '630222104000', '630222104000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县巴州镇');
| INSERT INTO `sl_region` VALUES ('9175', '满坪镇', '630222105000', '630222105000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县满坪镇');
| INSERT INTO `sl_region` VALUES ('9176', '李二堡镇', '630222106000', '630222106000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县李二堡镇');
| INSERT INTO `sl_region` VALUES ('9177', '峡门镇', '630222107000', '630222107000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县峡门镇');
| INSERT INTO `sl_region` VALUES ('9178', '马场垣乡', '630222200000', '630222200000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县马场垣乡');
| INSERT INTO `sl_region` VALUES ('9179', '北山乡', '630222201000', '630222201000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县北山乡');
| INSERT INTO `sl_region` VALUES ('9180', '松树乡', '630222202000', '630222202000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县松树乡');
| INSERT INTO `sl_region` VALUES ('9181', '西沟乡', '630222203000', '630222203000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县西沟乡');
| INSERT INTO `sl_region` VALUES ('9182', '总堡乡', '630222204000', '630222204000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县总堡乡');
| INSERT INTO `sl_region` VALUES ('9183', '隆治乡', '630222205000', '630222205000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县隆治乡');
| INSERT INTO `sl_region` VALUES ('9184', '大庄乡', '630222206000', '630222206000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县大庄乡');
| INSERT INTO `sl_region` VALUES ('9185', '转导乡', '630222207000', '630222207000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县转导乡');
| INSERT INTO `sl_region` VALUES ('9186', '前河乡', '630222208000', '630222208000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县前河乡');
| INSERT INTO `sl_region` VALUES ('9187', '甘沟乡', '630222209000', '630222209000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县甘沟乡');
| INSERT INTO `sl_region` VALUES ('9188', '中川乡', '630222210000', '630222210000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县中川乡');
| INSERT INTO `sl_region` VALUES ('9189', '杏儿乡', '630222211000', '630222211000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县杏儿乡');
| INSERT INTO `sl_region` VALUES ('9190', '核桃庄乡', '630222212000', '630222212000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县核桃庄乡');
| INSERT INTO `sl_region` VALUES ('9191', '新民乡', '630222213000', '630222213000', '630222000000', null, '4', null, '青海省海东市民和回族土族自治县新民乡');
| INSERT INTO `sl_region` VALUES ('9192', '威远镇', '630223100000', '630223100000', '630223000000', null, '4', null, '青海省海东市互助土族自治县威远镇');
| INSERT INTO `sl_region` VALUES ('9193', '丹麻镇', '630223101000', '630223101000', '630223000000', null, '4', null, '青海省海东市互助土族自治县丹麻镇');
| INSERT INTO `sl_region` VALUES ('9194', '高寨镇', '630223102000', '630223102000', '630223000000', null, '4', null, '青海省海东市互助土族自治县高寨镇');
| INSERT INTO `sl_region` VALUES ('9195', '南门峡镇', '630223103000', '630223103000', '630223000000', null, '4', null, '青海省海东市互助土族自治县南门峡镇');
| INSERT INTO `sl_region` VALUES ('9196', '加定镇', '630223104000', '630223104000', '630223000000', null, '4', null, '青海省海东市互助土族自治县加定镇');
| INSERT INTO `sl_region` VALUES ('9197', '塘川镇', '630223105000', '630223105000', '630223000000', null, '4', null, '青海省海东市互助土族自治县塘川镇');
| INSERT INTO `sl_region` VALUES ('9198', '五十镇', '630223106000', '630223106000', '630223000000', null, '4', null, '青海省海东市互助土族自治县五十镇');
| INSERT INTO `sl_region` VALUES ('9199', '五峰镇', '630223107000', '630223107000', '630223000000', null, '4', null, '青海省海东市互助土族自治县五峰镇');
| INSERT INTO `sl_region` VALUES ('9200', '台子乡', '630223200000', '630223200000', '630223000000', null, '4', null, '青海省海东市互助土族自治县台子乡');
| INSERT INTO `sl_region` VALUES ('9201', '西山乡', '630223201000', '630223201000', '630223000000', null, '4', null, '青海省海东市互助土族自治县西山乡');
| INSERT INTO `sl_region` VALUES ('9202', '红崖子沟乡', '630223202000', '630223202000', '630223000000', null, '4', null, '青海省海东市互助土族自治县红崖子沟乡');
| INSERT INTO `sl_region` VALUES ('9203', '巴扎藏族乡', '630223203000', '630223203000', '630223000000', null, '4', null, '青海省海东市互助土族自治县巴扎藏族乡');
| INSERT INTO `sl_region` VALUES ('9204', '哈拉直沟乡', '630223204000', '630223204000', '630223000000', null, '4', null, '青海省海东市互助土族自治县哈拉直沟乡');
| INSERT INTO `sl_region` VALUES ('9205', '松多藏族乡', '630223205000', '630223205000', '630223000000', null, '4', null, '青海省海东市互助土族自治县松多藏族乡');
| INSERT INTO `sl_region` VALUES ('9206', '东山乡', '630223206000', '630223206000', '630223000000', null, '4', null, '青海省海东市互助土族自治县东山乡');
| INSERT INTO `sl_region` VALUES ('9207', '东和乡', '630223207000', '630223207000', '630223000000', null, '4', null, '青海省海东市互助土族自治县东和乡');
| INSERT INTO `sl_region` VALUES ('9208', '东沟乡', '630223208000', '630223208000', '630223000000', null, '4', null, '青海省海东市互助土族自治县东沟乡');
| INSERT INTO `sl_region` VALUES ('9209', '林川乡', '630223209000', '630223209000', '630223000000', null, '4', null, '青海省海东市互助土族自治县林川乡');
| INSERT INTO `sl_region` VALUES ('9210', '蔡家堡乡', '630223210000', '630223210000', '630223000000', null, '4', null, '青海省海东市互助土族自治县蔡家堡乡');
| INSERT INTO `sl_region` VALUES ('9211', '曹家堡临空综合经济园互助园区', '630223400000', '630223400000', '630223000000', null, '4', null, '青海省海东市互助土族自治县曹家堡临空综合经济园互助园区');
| INSERT INTO `sl_region` VALUES ('9212', '巴燕镇', '630224100000', '630224100000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县巴燕镇');
| INSERT INTO `sl_region` VALUES ('9213', '群科镇', '630224101000', '630224101000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县群科镇');
| INSERT INTO `sl_region` VALUES ('9214', '牙什尕镇', '630224102000', '630224102000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县牙什尕镇');
| INSERT INTO `sl_region` VALUES ('9215', '甘都镇', '630224103000', '630224103000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县甘都镇');
| INSERT INTO `sl_region` VALUES ('9216', '扎巴镇', '630224104000', '630224104000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县扎巴镇');
| INSERT INTO `sl_region` VALUES ('9217', '昂思多镇', '630224105000', '630224105000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县昂思多镇');
| INSERT INTO `sl_region` VALUES ('9218', '雄先藏族乡', '630224200000', '630224200000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县雄先藏族乡');
| INSERT INTO `sl_region` VALUES ('9219', '初麻乡', '630224201000', '630224201000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县初麻乡');
| INSERT INTO `sl_region` VALUES ('9220', '查甫藏族乡', '630224202000', '630224202000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县查甫藏族乡');
| INSERT INTO `sl_region` VALUES ('9221', '塔加藏族乡', '630224203000', '630224203000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县塔加藏族乡');
| INSERT INTO `sl_region` VALUES ('9222', '金源藏族乡', '630224204000', '630224204000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县金源藏族乡');
| INSERT INTO `sl_region` VALUES ('9223', '二塘乡', '630224205000', '630224205000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县二塘乡');
| INSERT INTO `sl_region` VALUES ('9224', '谢家滩乡', '630224206000', '630224206000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县谢家滩乡');
| INSERT INTO `sl_region` VALUES ('9225', '德恒隆乡', '630224207000', '630224207000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县德恒隆乡');
| INSERT INTO `sl_region` VALUES ('9226', '沙连堡乡', '630224208000', '630224208000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县沙连堡乡');
| INSERT INTO `sl_region` VALUES ('9227', '阿什奴乡', '630224209000', '630224209000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县阿什奴乡');
| INSERT INTO `sl_region` VALUES ('9228', '石大仓乡', '630224210000', '630224210000', '630224000000', null, '4', null, '青海省海东市化隆回族自治县石大仓乡');
| INSERT INTO `sl_region` VALUES ('9229', '积石镇', '630225100000', '630225100000', '630225000000', null, '4', null, '青海省海东市循化撒拉族自治县积石镇');
| INSERT INTO `sl_region` VALUES ('9230', '白庄镇', '630225101000', '630225101000', '630225000000', null, '4', null, '青海省海东市循化撒拉族自治县白庄镇');
| INSERT INTO `sl_region` VALUES ('9231', '街子镇', '630225102000', '630225102000', '630225000000', null, '4', null, '青海省海东市循化撒拉族自治县街子镇');
| INSERT INTO `sl_region` VALUES ('9232', '道帏藏族乡', '630225200000', '630225200000', '630225000000', null, '4', null, '青海省海东市循化撒拉族自治县道帏藏族乡');
| INSERT INTO `sl_region` VALUES ('9233', '清水乡', '630225201000', '630225201000', '630225000000', null, '4', null, '青海省海东市循化撒拉族自治县清水乡');
| INSERT INTO `sl_region` VALUES ('9234', '岗察藏族乡', '630225202000', '630225202000', '630225000000', null, '4', null, '青海省海东市循化撒拉族自治县岗察藏族乡');
| INSERT INTO `sl_region` VALUES ('9235', '查汗都斯乡', '630225203000', '630225203000', '630225000000', null, '4', null, '青海省海东市循化撒拉族自治县查汗都斯乡');
| INSERT INTO `sl_region` VALUES ('9236', '文都藏族乡', '630225204000', '630225204000', '630225000000', null, '4', null, '青海省海东市循化撒拉族自治县文都藏族乡');
| INSERT INTO `sl_region` VALUES ('9237', '尕楞藏族乡', '630225205000', '630225205000', '630225000000', null, '4', null, '青海省海东市循化撒拉族自治县尕楞藏族乡');
| INSERT INTO `sl_region` VALUES ('9238', '浩门镇', '632221100000', '632221100000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县浩门镇');
| INSERT INTO `sl_region` VALUES ('9239', '青石咀镇', '632221101000', '632221101000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县青石咀镇');
| INSERT INTO `sl_region` VALUES ('9240', '泉口镇', '632221102000', '632221102000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县泉口镇');
| INSERT INTO `sl_region` VALUES ('9241', '东川镇', '632221103000', '632221103000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县东川镇');
| INSERT INTO `sl_region` VALUES ('9242', '北山乡', '632221200000', '632221200000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县北山乡');
| INSERT INTO `sl_region` VALUES ('9243', '麻莲乡', '632221201000', '632221201000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县麻莲乡');
| INSERT INTO `sl_region` VALUES ('9244', '西滩乡', '632221202000', '632221202000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县西滩乡');
| INSERT INTO `sl_region` VALUES ('9245', '阴田乡', '632221203000', '632221203000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县阴田乡');
| INSERT INTO `sl_region` VALUES ('9246', '仙米乡', '632221204000', '632221204000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县仙米乡');
| INSERT INTO `sl_region` VALUES ('9247', '珠固乡', '632221205000', '632221205000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县珠固乡');
| INSERT INTO `sl_region` VALUES ('9248', '苏吉滩乡', '632221206000', '632221206000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县苏吉滩乡');
| INSERT INTO `sl_region` VALUES ('9249', '皇城蒙古族乡', '632221207000', '632221207000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县皇城蒙古族乡');
| INSERT INTO `sl_region` VALUES ('9250', '门源监狱', '632221400000', '632221400000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县门源监狱');
| INSERT INTO `sl_region` VALUES ('9251', '门源种马场', '632221401000', '632221401000', '632221000000', null, '4', null, '青海省海北藏族自治州门源回族自治县门源种马场');
| INSERT INTO `sl_region` VALUES ('9252', '八宝镇', '632222100000', '632222100000', '632222000000', null, '4', null, '青海省海北藏族自治州祁连县八宝镇');
| INSERT INTO `sl_region` VALUES ('9253', '峨堡镇', '632222101000', '632222101000', '632222000000', null, '4', null, '青海省海北藏族自治州祁连县峨堡镇');
| INSERT INTO `sl_region` VALUES ('9254', '默勒镇', '632222102000', '632222102000', '632222000000', null, '4', null, '青海省海北藏族自治州祁连县默勒镇');
| INSERT INTO `sl_region` VALUES ('9255', '扎麻什乡', '632222200000', '632222200000', '632222000000', null, '4', null, '青海省海北藏族自治州祁连县扎麻什乡');
| INSERT INTO `sl_region` VALUES ('9256', '阿柔乡', '632222201000', '632222201000', '632222000000', null, '4', null, '青海省海北藏族自治州祁连县阿柔乡');
| INSERT INTO `sl_region` VALUES ('9257', '野牛沟乡', '632222202000', '632222202000', '632222000000', null, '4', null, '青海省海北藏族自治州祁连县野牛沟乡');
| INSERT INTO `sl_region` VALUES ('9258', '央隆乡', '632222203000', '632222203000', '632222000000', null, '4', null, '青海省海北藏族自治州祁连县央隆乡');
| INSERT INTO `sl_region` VALUES ('9259', '三角城镇', '632223100000', '632223100000', '632223000000', null, '4', null, '青海省海北藏族自治州海晏县三角城镇');
| INSERT INTO `sl_region` VALUES ('9260', '西海镇', '632223101000', '632223101000', '632223000000', null, '4', null, '青海省海北藏族自治州海晏县西海镇');
| INSERT INTO `sl_region` VALUES ('9261', '金滩乡', '632223200000', '632223200000', '632223000000', null, '4', null, '青海省海北藏族自治州海晏县金滩乡');
| INSERT INTO `sl_region` VALUES ('9262', '哈勒景蒙古族乡', '632223201000', '632223201000', '632223000000', null, '4', null, '青海省海北藏族自治州海晏县哈勒景蒙古族乡');
| INSERT INTO `sl_region` VALUES ('9263', '青海湖乡', '632223202000', '632223202000', '632223000000', null, '4', null, '青海省海北藏族自治州海晏县青海湖乡');
| INSERT INTO `sl_region` VALUES ('9264', '甘子河乡', '632223203000', '632223203000', '632223000000', null, '4', null, '青海省海北藏族自治州海晏县甘子河乡');
| INSERT INTO `sl_region` VALUES ('9265', '沙柳河镇', '632224100000', '632224100000', '632224000000', null, '4', null, '青海省海北藏族自治州刚察县沙柳河镇');
| INSERT INTO `sl_region` VALUES ('9266', '哈尔盖镇', '632224101000', '632224101000', '632224000000', null, '4', null, '青海省海北藏族自治州刚察县哈尔盖镇');
| INSERT INTO `sl_region` VALUES ('9267', '伊克乌兰乡', '632224200000', '632224200000', '632224000000', null, '4', null, '青海省海北藏族自治州刚察县伊克乌兰乡');
| INSERT INTO `sl_region` VALUES ('9268', '泉吉乡', '632224201000', '632224201000', '632224000000', null, '4', null, '青海省海北藏族自治州刚察县泉吉乡');
| INSERT INTO `sl_region` VALUES ('9269', '吉尔孟乡', '632224202000', '632224202000', '632224000000', null, '4', null, '青海省海北藏族自治州刚察县吉尔孟乡');
| INSERT INTO `sl_region` VALUES ('9270', '隆务镇', '632301100000', '632301100000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市隆务镇');
| INSERT INTO `sl_region` VALUES ('9271', '保安镇', '632301101000', '632301101000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市保安镇');
| INSERT INTO `sl_region` VALUES ('9272', '多哇镇', '632301102000', '632301102000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市多哇镇');
| INSERT INTO `sl_region` VALUES ('9273', '兰采乡', '632301200000', '632301200000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市兰采乡');
| INSERT INTO `sl_region` VALUES ('9274', '双朋西乡', '632301201000', '632301201000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市双朋西乡');
| INSERT INTO `sl_region` VALUES ('9275', '扎毛乡', '632301202000', '632301202000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市扎毛乡');
| INSERT INTO `sl_region` VALUES ('9276', '黄乃亥乡', '632301203000', '632301203000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市黄乃亥乡');
| INSERT INTO `sl_region` VALUES ('9277', '曲库乎乡', '632301204000', '632301204000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市曲库乎乡');
| INSERT INTO `sl_region` VALUES ('9278', '年都乎乡', '632301205000', '632301205000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市年都乎乡');
| INSERT INTO `sl_region` VALUES ('9279', '瓜什则乡', '632301206000', '632301206000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市瓜什则乡');
| INSERT INTO `sl_region` VALUES ('9280', '加吾乡', '632301207000', '632301207000', '632301000000', null, '4', null, '青海省黄南藏族自治州同仁市加吾乡');
| INSERT INTO `sl_region` VALUES ('9281', '马克堂镇', '632322100000', '632322100000', '632322000000', null, '4', null, '青海省黄南藏族自治州尖扎县马克堂镇');
| INSERT INTO `sl_region` VALUES ('9282', '康扬镇', '632322101000', '632322101000', '632322000000', null, '4', null, '青海省黄南藏族自治州尖扎县康扬镇');
| INSERT INTO `sl_region` VALUES ('9283', '坎布拉镇', '632322102000', '632322102000', '632322000000', null, '4', null, '青海省黄南藏族自治州尖扎县坎布拉镇');
| INSERT INTO `sl_region` VALUES ('9284', '贾加乡', '632322200000', '632322200000', '632322000000', null, '4', null, '青海省黄南藏族自治州尖扎县贾加乡');
| INSERT INTO `sl_region` VALUES ('9285', '措周乡', '632322201000', '632322201000', '632322000000', null, '4', null, '青海省黄南藏族自治州尖扎县措周乡');
| INSERT INTO `sl_region` VALUES ('9286', '昂拉乡', '632322202000', '632322202000', '632322000000', null, '4', null, '青海省黄南藏族自治州尖扎县昂拉乡');
| INSERT INTO `sl_region` VALUES ('9287', '能科乡', '632322203000', '632322203000', '632322000000', null, '4', null, '青海省黄南藏族自治州尖扎县能科乡');
| INSERT INTO `sl_region` VALUES ('9288', '当顺乡', '632322204000', '632322204000', '632322000000', null, '4', null, '青海省黄南藏族自治州尖扎县当顺乡');
| INSERT INTO `sl_region` VALUES ('9289', '尖扎滩乡', '632322205000', '632322205000', '632322000000', null, '4', null, '青海省黄南藏族自治州尖扎县尖扎滩乡');
| INSERT INTO `sl_region` VALUES ('9290', '泽曲镇', '632323100000', '632323100000', '632323000000', null, '4', null, '青海省黄南藏族自治州泽库县泽曲镇');
| INSERT INTO `sl_region` VALUES ('9291', '麦秀镇', '632323101000', '632323101000', '632323000000', null, '4', null, '青海省黄南藏族自治州泽库县麦秀镇');
| INSERT INTO `sl_region` VALUES ('9292', '和日镇', '632323102000', '632323102000', '632323000000', null, '4', null, '青海省黄南藏族自治州泽库县和日镇');
| INSERT INTO `sl_region` VALUES ('9293', '宁秀镇', '632323103000', '632323103000', '632323000000', null, '4', null, '青海省黄南藏族自治州泽库县宁秀镇');
| INSERT INTO `sl_region` VALUES ('9294', '王加乡', '632323202000', '632323202000', '632323000000', null, '4', null, '青海省黄南藏族自治州泽库县王加乡');
| INSERT INTO `sl_region` VALUES ('9295', '西卜沙乡', '632323203000', '632323203000', '632323000000', null, '4', null, '青海省黄南藏族自治州泽库县西卜沙乡');
| INSERT INTO `sl_region` VALUES ('9296', '多禾茂乡', '632323204000', '632323204000', '632323000000', null, '4', null, '青海省黄南藏族自治州泽库县多禾茂乡');
| INSERT INTO `sl_region` VALUES ('9297', '优干宁镇', '632324100000', '632324100000', '632324000000', null, '4', null, '青海省黄南藏族自治州河南蒙古族自治县优干宁镇');
| INSERT INTO `sl_region` VALUES ('9298', '宁木特镇', '632324101000', '632324101000', '632324000000', null, '4', null, '青海省黄南藏族自治州河南蒙古族自治县宁木特镇');
| INSERT INTO `sl_region` VALUES ('9299', '多松乡', '632324201000', '632324201000', '632324000000', null, '4', null, '青海省黄南藏族自治州河南蒙古族自治县多松乡');
| INSERT INTO `sl_region` VALUES ('9300', '赛尔龙乡', '632324202000', '632324202000', '632324000000', null, '4', null, '青海省黄南藏族自治州河南蒙古族自治县赛尔龙乡');
| INSERT INTO `sl_region` VALUES ('9301', '柯生乡', '632324203000', '632324203000', '632324000000', null, '4', null, '青海省黄南藏族自治州河南蒙古族自治县柯生乡');
| INSERT INTO `sl_region` VALUES ('9302', '托叶玛乡', '632324204000', '632324204000', '632324000000', null, '4', null, '青海省黄南藏族自治州河南蒙古族自治县托叶玛乡');
| INSERT INTO `sl_region` VALUES ('9303', '恰卜恰镇', '632521100000', '632521100000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县恰卜恰镇');
| INSERT INTO `sl_region` VALUES ('9304', '倒淌河镇', '632521101000', '632521101000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县倒淌河镇');
| INSERT INTO `sl_region` VALUES ('9305', '龙羊峡镇', '632521102000', '632521102000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县龙羊峡镇');
| INSERT INTO `sl_region` VALUES ('9306', '塘格木镇', '632521103000', '632521103000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县塘格木镇');
| INSERT INTO `sl_region` VALUES ('9307', '黑马河镇', '632521104000', '632521104000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县黑马河镇');
| INSERT INTO `sl_region` VALUES ('9308', '石乃亥镇', '632521105000', '632521105000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县石乃亥镇');
| INSERT INTO `sl_region` VALUES ('9309', '江西沟镇', '632521106000', '632521106000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县江西沟镇');
| INSERT INTO `sl_region` VALUES ('9310', '沙珠玉乡', '632521202000', '632521202000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县沙珠玉乡');
| INSERT INTO `sl_region` VALUES ('9311', '铁盖乡', '632521203000', '632521203000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县铁盖乡');
| INSERT INTO `sl_region` VALUES ('9312', '廿地乡', '632521204000', '632521204000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县廿地乡');
| INSERT INTO `sl_region` VALUES ('9313', '切吉乡', '632521205000', '632521205000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县切吉乡');
| INSERT INTO `sl_region` VALUES ('9314', '海南州绿色产业发展园区管理区委员会', '632521400000', '632521400000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县海南州绿色产业发展园区管理区委员会');
| INSERT INTO `sl_region` VALUES ('9315', '巴卡台农场', '632521402000', '632521402000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县巴卡台农场');
| INSERT INTO `sl_region` VALUES ('9316', '安置农场', '632521403000', '632521403000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县安置农场');
| INSERT INTO `sl_region` VALUES ('9317', '铁卜加草改站', '632521404000', '632521404000', '632521000000', null, '4', null, '青海省海南藏族自治州共和县铁卜加草改站');
| INSERT INTO `sl_region` VALUES ('9318', '尕巴松多镇', '632522100000', '632522100000', '632522000000', null, '4', null, '青海省海南藏族自治州同德县尕巴松多镇');
| INSERT INTO `sl_region` VALUES ('9319', '唐谷镇', '632522101000', '632522101000', '632522000000', null, '4', null, '青海省海南藏族自治州同德县唐谷镇');
| INSERT INTO `sl_region` VALUES ('9320', '巴沟乡', '632522200000', '632522200000', '632522000000', null, '4', null, '青海省海南藏族自治州同德县巴沟乡');
| INSERT INTO `sl_region` VALUES ('9321', '秀麻乡', '632522201000', '632522201000', '632522000000', null, '4', null, '青海省海南藏族自治州同德县秀麻乡');
| INSERT INTO `sl_region` VALUES ('9322', '河北乡', '632522202000', '632522202000', '632522000000', null, '4', null, '青海省海南藏族自治州同德县河北乡');
| INSERT INTO `sl_region` VALUES ('9323', '省牧草良种繁殖场', '632522400000', '632522400000', '632522000000', null, '4', null, '青海省海南藏族自治州同德县省牧草良种繁殖场');
| INSERT INTO `sl_region` VALUES ('9324', '河阴镇', '632523100000', '632523100000', '632523000000', null, '4', null, '青海省海南藏族自治州贵德县河阴镇');
| INSERT INTO `sl_region` VALUES ('9325', '河西镇', '632523101000', '632523101000', '632523000000', null, '4', null, '青海省海南藏族自治州贵德县河西镇');
| INSERT INTO `sl_region` VALUES ('9326', '拉西瓦镇', '632523102000', '632523102000', '632523000000', null, '4', null, '青海省海南藏族自治州贵德县拉西瓦镇');
| INSERT INTO `sl_region` VALUES ('9327', '常牧镇', '632523103000', '632523103000', '632523000000', null, '4', null, '青海省海南藏族自治州贵德县常牧镇');
| INSERT INTO `sl_region` VALUES ('9328', '河东乡', '632523200000', '632523200000', '632523000000', null, '4', null, '青海省海南藏族自治州贵德县河东乡');
| INSERT INTO `sl_region` VALUES ('9329', '新街回族乡', '632523201000', '632523201000', '632523000000', null, '4', null, '青海省海南藏族自治州贵德县新街回族乡');
| INSERT INTO `sl_region` VALUES ('9330', '尕让乡', '632523202000', '632523202000', '632523000000', null, '4', null, '青海省海南藏族自治州贵德县尕让乡');
| INSERT INTO `sl_region` VALUES ('9331', '子科滩镇', '632524100000', '632524100000', '632524000000', null, '4', null, '青海省海南藏族自治州兴海县子科滩镇');
| INSERT INTO `sl_region` VALUES ('9332', '河卡镇', '632524101000', '632524101000', '632524000000', null, '4', null, '青海省海南藏族自治州兴海县河卡镇');
| INSERT INTO `sl_region` VALUES ('9333', '曲什安镇', '632524102000', '632524102000', '632524000000', null, '4', null, '青海省海南藏族自治州兴海县曲什安镇');
| INSERT INTO `sl_region` VALUES ('9334', '温泉乡', '632524200000', '632524200000', '632524000000', null, '4', null, '青海省海南藏族自治州兴海县温泉乡');
| INSERT INTO `sl_region` VALUES ('9335', '龙藏乡', '632524201000', '632524201000', '632524000000', null, '4', null, '青海省海南藏族自治州兴海县龙藏乡');
| INSERT INTO `sl_region` VALUES ('9336', '中铁乡', '632524202000', '632524202000', '632524000000', null, '4', null, '青海省海南藏族自治州兴海县中铁乡');
| INSERT INTO `sl_region` VALUES ('9337', '唐乃亥乡', '632524203000', '632524203000', '632524000000', null, '4', null, '青海省海南藏族自治州兴海县唐乃亥乡');
| INSERT INTO `sl_region` VALUES ('9338', '茫曲镇', '632525100000', '632525100000', '632525000000', null, '4', null, '青海省海南藏族自治州贵南县茫曲镇');
| INSERT INTO `sl_region` VALUES ('9339', '过马营镇', '632525101000', '632525101000', '632525000000', null, '4', null, '青海省海南藏族自治州贵南县过马营镇');
| INSERT INTO `sl_region` VALUES ('9340', '森多镇', '632525102000', '632525102000', '632525000000', null, '4', null, '青海省海南藏族自治州贵南县森多镇');
| INSERT INTO `sl_region` VALUES ('9341', '沙沟乡', '632525200000', '632525200000', '632525000000', null, '4', null, '青海省海南藏族自治州贵南县沙沟乡');
| INSERT INTO `sl_region` VALUES ('9342', '茫拉乡', '632525202000', '632525202000', '632525000000', null, '4', null, '青海省海南藏族自治州贵南县茫拉乡');
| INSERT INTO `sl_region` VALUES ('9343', '塔秀乡', '632525203000', '632525203000', '632525000000', null, '4', null, '青海省海南藏族自治州贵南县塔秀乡');
| INSERT INTO `sl_region` VALUES ('9344', '大武镇', '632621100000', '632621100000', '632621000000', null, '4', null, '青海省果洛藏族自治州玛沁县大武镇');
| INSERT INTO `sl_region` VALUES ('9345', '拉加镇', '632621101000', '632621101000', '632621000000', null, '4', null, '青海省果洛藏族自治州玛沁县拉加镇');
| INSERT INTO `sl_region` VALUES ('9346', '大武乡', '632621200000', '632621200000', '632621000000', null, '4', null, '青海省果洛藏族自治州玛沁县大武乡');
| INSERT INTO `sl_region` VALUES ('9347', '东倾沟乡', '632621201000', '632621201000', '632621000000', null, '4', null, '青海省果洛藏族自治州玛沁县东倾沟乡');
| INSERT INTO `sl_region` VALUES ('9348', '雪山乡', '632621202000', '632621202000', '632621000000', null, '4', null, '青海省果洛藏族自治州玛沁县雪山乡');
| INSERT INTO `sl_region` VALUES ('9349', '下大武乡', '632621203000', '632621203000', '632621000000', null, '4', null, '青海省果洛藏族自治州玛沁县下大武乡');
| INSERT INTO `sl_region` VALUES ('9350', '优云乡', '632621204000', '632621204000', '632621000000', null, '4', null, '青海省果洛藏族自治州玛沁县优云乡');
| INSERT INTO `sl_region` VALUES ('9351', '当洛乡', '632621205000', '632621205000', '632621000000', null, '4', null, '青海省果洛藏族自治州玛沁县当洛乡');
| INSERT INTO `sl_region` VALUES ('9352', '赛来塘镇', '632622100000', '632622100000', '632622000000', null, '4', null, '青海省果洛藏族自治州班玛县赛来塘镇');
| INSERT INTO `sl_region` VALUES ('9353', '多贡麻乡', '632622200000', '632622200000', '632622000000', null, '4', null, '青海省果洛藏族自治州班玛县多贡麻乡');
| INSERT INTO `sl_region` VALUES ('9354', '马可河乡', '632622201000', '632622201000', '632622000000', null, '4', null, '青海省果洛藏族自治州班玛县马可河乡');
| INSERT INTO `sl_region` VALUES ('9355', '吉卡乡', '632622202000', '632622202000', '632622000000', null, '4', null, '青海省果洛藏族自治州班玛县吉卡乡');
| INSERT INTO `sl_region` VALUES ('9356', '达卡乡', '632622203000', '632622203000', '632622000000', null, '4', null, '青海省果洛藏族自治州班玛县达卡乡');
| INSERT INTO `sl_region` VALUES ('9357', '知钦乡', '632622204000', '632622204000', '632622000000', null, '4', null, '青海省果洛藏族自治州班玛县知钦乡');
| INSERT INTO `sl_region` VALUES ('9358', '江日堂乡', '632622205000', '632622205000', '632622000000', null, '4', null, '青海省果洛藏族自治州班玛县江日堂乡');
| INSERT INTO `sl_region` VALUES ('9359', '亚尔堂乡', '632622206000', '632622206000', '632622000000', null, '4', null, '青海省果洛藏族自治州班玛县亚尔堂乡');
| INSERT INTO `sl_region` VALUES ('9360', '灯塔乡', '632622207000', '632622207000', '632622000000', null, '4', null, '青海省果洛藏族自治州班玛县灯塔乡');
| INSERT INTO `sl_region` VALUES ('9361', '柯曲镇', '632623100000', '632623100000', '632623000000', null, '4', null, '青海省果洛藏族自治州甘德县柯曲镇');
| INSERT INTO `sl_region` VALUES ('9362', '上贡麻乡', '632623200000', '632623200000', '632623000000', null, '4', null, '青海省果洛藏族自治州甘德县上贡麻乡');
| INSERT INTO `sl_region` VALUES ('9363', '下贡麻乡', '632623201000', '632623201000', '632623000000', null, '4', null, '青海省果洛藏族自治州甘德县下贡麻乡');
| INSERT INTO `sl_region` VALUES ('9364', '岗龙乡', '632623202000', '632623202000', '632623000000', null, '4', null, '青海省果洛藏族自治州甘德县岗龙乡');
| INSERT INTO `sl_region` VALUES ('9365', '青珍乡', '632623203000', '632623203000', '632623000000', null, '4', null, '青海省果洛藏族自治州甘德县青珍乡');
| INSERT INTO `sl_region` VALUES ('9366', '江千乡', '632623204000', '632623204000', '632623000000', null, '4', null, '青海省果洛藏族自治州甘德县江千乡');
| INSERT INTO `sl_region` VALUES ('9367', '下藏科乡', '632623205000', '632623205000', '632623000000', null, '4', null, '青海省果洛藏族自治州甘德县下藏科乡');
| INSERT INTO `sl_region` VALUES ('9368', '吉迈镇', '632624100000', '632624100000', '632624000000', null, '4', null, '青海省果洛藏族自治州达日县吉迈镇');
| INSERT INTO `sl_region` VALUES ('9369', '满掌乡', '632624200000', '632624200000', '632624000000', null, '4', null, '青海省果洛藏族自治州达日县满掌乡');
| INSERT INTO `sl_region` VALUES ('9370', '德昂乡', '632624201000', '632624201000', '632624000000', null, '4', null, '青海省果洛藏族自治州达日县德昂乡');
| INSERT INTO `sl_region` VALUES ('9371', '窝赛乡', '632624202000', '632624202000', '632624000000', null, '4', null, '青海省果洛藏族自治州达日县窝赛乡');
| INSERT INTO `sl_region` VALUES ('9372', '莫坝乡', '632624203000', '632624203000', '632624000000', null, '4', null, '青海省果洛藏族自治州达日县莫坝乡');
| INSERT INTO `sl_region` VALUES ('9373', '上红科乡', '632624204000', '632624204000', '632624000000', null, '4', null, '青海省果洛藏族自治州达日县上红科乡');
| INSERT INTO `sl_region` VALUES ('9374', '下红科乡', '632624205000', '632624205000', '632624000000', null, '4', null, '青海省果洛藏族自治州达日县下红科乡');
| INSERT INTO `sl_region` VALUES ('9375', '建设乡', '632624206000', '632624206000', '632624000000', null, '4', null, '青海省果洛藏族自治州达日县建设乡');
| INSERT INTO `sl_region` VALUES ('9376', '桑日麻乡', '632624207000', '632624207000', '632624000000', null, '4', null, '青海省果洛藏族自治州达日县桑日麻乡');
| INSERT INTO `sl_region` VALUES ('9377', '特合土乡', '632624208000', '632624208000', '632624000000', null, '4', null, '青海省果洛藏族自治州达日县特合土乡');
| INSERT INTO `sl_region` VALUES ('9378', '智青松多镇', '632625100000', '632625100000', '632625000000', null, '4', null, '青海省果洛藏族自治州久治县智青松多镇');
| INSERT INTO `sl_region` VALUES ('9379', '门堂乡', '632625200000', '632625200000', '632625000000', null, '4', null, '青海省果洛藏族自治州久治县门堂乡');
| INSERT INTO `sl_region` VALUES ('9380', '哇赛乡', '632625201000', '632625201000', '632625000000', null, '4', null, '青海省果洛藏族自治州久治县哇赛乡');
| INSERT INTO `sl_region` VALUES ('9381', '索呼日麻乡', '632625202000', '632625202000', '632625000000', null, '4', null, '青海省果洛藏族自治州久治县索呼日麻乡');
| INSERT INTO `sl_region` VALUES ('9382', '白玉乡', '632625203000', '632625203000', '632625000000', null, '4', null, '青海省果洛藏族自治州久治县白玉乡');
| INSERT INTO `sl_region` VALUES ('9383', '哇尔依乡', '632625204000', '632625204000', '632625000000', null, '4', null, '青海省果洛藏族自治州久治县哇尔依乡');
| INSERT INTO `sl_region` VALUES ('9384', '玛查理镇', '632626100000', '632626100000', '632626000000', null, '4', null, '青海省果洛藏族自治州玛多县玛查理镇');
| INSERT INTO `sl_region` VALUES ('9385', '花石峡镇', '632626101000', '632626101000', '632626000000', null, '4', null, '青海省果洛藏族自治州玛多县花石峡镇');
| INSERT INTO `sl_region` VALUES ('9386', '黄河乡', '632626200000', '632626200000', '632626000000', null, '4', null, '青海省果洛藏族自治州玛多县黄河乡');
| INSERT INTO `sl_region` VALUES ('9387', '扎陵湖乡', '632626201000', '632626201000', '632626000000', null, '4', null, '青海省果洛藏族自治州玛多县扎陵湖乡');
| INSERT INTO `sl_region` VALUES ('9388', '结古街道', '632701001000', '632701001000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市结古街道');
| INSERT INTO `sl_region` VALUES ('9389', '扎西科街道', '632701002000', '632701002000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市扎西科街道');
| INSERT INTO `sl_region` VALUES ('9390', '西杭街道', '632701003000', '632701003000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市西杭街道');
| INSERT INTO `sl_region` VALUES ('9391', '新寨街道', '632701004000', '632701004000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市新寨街道');
| INSERT INTO `sl_region` VALUES ('9392', '隆宝镇', '632701101000', '632701101000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市隆宝镇');
| INSERT INTO `sl_region` VALUES ('9393', '下拉秀镇', '632701102000', '632701102000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市下拉秀镇');
| INSERT INTO `sl_region` VALUES ('9394', '仲达乡', '632701200000', '632701200000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市仲达乡');
| INSERT INTO `sl_region` VALUES ('9395', '巴塘乡', '632701201000', '632701201000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市巴塘乡');
| INSERT INTO `sl_region` VALUES ('9396', '小苏莽乡', '632701202000', '632701202000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市小苏莽乡');
| INSERT INTO `sl_region` VALUES ('9397', '上拉秀乡', '632701203000', '632701203000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市上拉秀乡');
| INSERT INTO `sl_region` VALUES ('9398', '安冲乡', '632701205000', '632701205000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市安冲乡');
| INSERT INTO `sl_region` VALUES ('9399', '哈秀乡', '632701400000', '632701400000', '632701000000', null, '4', null, '青海省玉树藏族自治州玉树市哈秀乡');
| INSERT INTO `sl_region` VALUES ('9400', '萨呼腾镇', '632722100000', '632722100000', '632722000000', null, '4', null, '青海省玉树藏族自治州杂多县萨呼腾镇');
| INSERT INTO `sl_region` VALUES ('9401', '昂赛乡', '632722200000', '632722200000', '632722000000', null, '4', null, '青海省玉树藏族自治州杂多县昂赛乡');
| INSERT INTO `sl_region` VALUES ('9402', '结多乡', '632722201000', '632722201000', '632722000000', null, '4', null, '青海省玉树藏族自治州杂多县结多乡');
| INSERT INTO `sl_region` VALUES ('9403', '阿多乡', '632722202000', '632722202000', '632722000000', null, '4', null, '青海省玉树藏族自治州杂多县阿多乡');
| INSERT INTO `sl_region` VALUES ('9404', '苏鲁乡', '632722203000', '632722203000', '632722000000', null, '4', null, '青海省玉树藏族自治州杂多县苏鲁乡');
| INSERT INTO `sl_region` VALUES ('9405', '查旦乡', '632722204000', '632722204000', '632722000000', null, '4', null, '青海省玉树藏族自治州杂多县查旦乡');
| INSERT INTO `sl_region` VALUES ('9406', '莫云乡', '632722205000', '632722205000', '632722000000', null, '4', null, '青海省玉树藏族自治州杂多县莫云乡');
| INSERT INTO `sl_region` VALUES ('9407', '扎青乡', '632722206000', '632722206000', '632722000000', null, '4', null, '青海省玉树藏族自治州杂多县扎青乡');
| INSERT INTO `sl_region` VALUES ('9408', '称文镇', '632723100000', '632723100000', '632723000000', null, '4', null, '青海省玉树藏族自治州称多县称文镇');
| INSERT INTO `sl_region` VALUES ('9409', '歇武镇', '632723101000', '632723101000', '632723000000', null, '4', null, '青海省玉树藏族自治州称多县歇武镇');
| INSERT INTO `sl_region` VALUES ('9410', '扎朵镇', '632723102000', '632723102000', '632723000000', null, '4', null, '青海省玉树藏族自治州称多县扎朵镇');
| INSERT INTO `sl_region` VALUES ('9411', '清水河镇', '632723103000', '632723103000', '632723000000', null, '4', null, '青海省玉树藏族自治州称多县清水河镇');
| INSERT INTO `sl_region` VALUES ('9412', '珍秦镇', '632723104000', '632723104000', '632723000000', null, '4', null, '青海省玉树藏族自治州称多县珍秦镇');
| INSERT INTO `sl_region` VALUES ('9413', '尕朵乡', '632723200000', '632723200000', '632723000000', null, '4', null, '青海省玉树藏族自治州称多县尕朵乡');
| INSERT INTO `sl_region` VALUES ('9414', '拉布乡', '632723201000', '632723201000', '632723000000', null, '4', null, '青海省玉树藏族自治州称多县拉布乡');
| INSERT INTO `sl_region` VALUES ('9415', '加吉博洛格镇', '632724100000', '632724100000', '632724000000', null, '4', null, '青海省玉树藏族自治州治多县加吉博洛格镇');
| INSERT INTO `sl_region` VALUES ('9416', '索加乡', '632724200000', '632724200000', '632724000000', null, '4', null, '青海省玉树藏族自治州治多县索加乡');
| INSERT INTO `sl_region` VALUES ('9417', '扎河乡', '632724201000', '632724201000', '632724000000', null, '4', null, '青海省玉树藏族自治州治多县扎河乡');
| INSERT INTO `sl_region` VALUES ('9418', '多彩乡', '632724202000', '632724202000', '632724000000', null, '4', null, '青海省玉树藏族自治州治多县多彩乡');
| INSERT INTO `sl_region` VALUES ('9419', '治渠乡', '632724203000', '632724203000', '632724000000', null, '4', null, '青海省玉树藏族自治州治多县治渠乡');
| INSERT INTO `sl_region` VALUES ('9420', '立新乡', '632724204000', '632724204000', '632724000000', null, '4', null, '青海省玉树藏族自治州治多县立新乡');
| INSERT INTO `sl_region` VALUES ('9421', '香达镇', '632725100000', '632725100000', '632725000000', null, '4', null, '青海省玉树藏族自治州囊谦县香达镇');
| INSERT INTO `sl_region` VALUES ('9422', '白扎乡', '632725200000', '632725200000', '632725000000', null, '4', null, '青海省玉树藏族自治州囊谦县白扎乡');
| INSERT INTO `sl_region` VALUES ('9423', '吉曲乡', '632725201000', '632725201000', '632725000000', null, '4', null, '青海省玉树藏族自治州囊谦县吉曲乡');
| INSERT INTO `sl_region` VALUES ('9424', '娘拉乡', '632725202000', '632725202000', '632725000000', null, '4', null, '青海省玉树藏族自治州囊谦县娘拉乡');
| INSERT INTO `sl_region` VALUES ('9425', '毛庄乡', '632725203000', '632725203000', '632725000000', null, '4', null, '青海省玉树藏族自治州囊谦县毛庄乡');
| INSERT INTO `sl_region` VALUES ('9426', '觉拉乡', '632725204000', '632725204000', '632725000000', null, '4', null, '青海省玉树藏族自治州囊谦县觉拉乡');
| INSERT INTO `sl_region` VALUES ('9427', '东坝乡', '632725205000', '632725205000', '632725000000', null, '4', null, '青海省玉树藏族自治州囊谦县东坝乡');
| INSERT INTO `sl_region` VALUES ('9428', '尕羊乡', '632725206000', '632725206000', '632725000000', null, '4', null, '青海省玉树藏族自治州囊谦县尕羊乡');
| INSERT INTO `sl_region` VALUES ('9429', '吉尼赛乡', '632725207000', '632725207000', '632725000000', null, '4', null, '青海省玉树藏族自治州囊谦县吉尼赛乡');
| INSERT INTO `sl_region` VALUES ('9430', '着晓乡', '632725208000', '632725208000', '632725000000', null, '4', null, '青海省玉树藏族自治州囊谦县着晓乡');
| INSERT INTO `sl_region` VALUES ('9431', '约改镇', '632726100000', '632726100000', '632726000000', null, '4', null, '青海省玉树藏族自治州曲麻莱县约改镇');
| INSERT INTO `sl_region` VALUES ('9432', '巴干乡', '632726200000', '632726200000', '632726000000', null, '4', null, '青海省玉树藏族自治州曲麻莱县巴干乡');
| INSERT INTO `sl_region` VALUES ('9433', '秋智乡', '632726201000', '632726201000', '632726000000', null, '4', null, '青海省玉树藏族自治州曲麻莱县秋智乡');
| INSERT INTO `sl_region` VALUES ('9434', '叶格乡', '632726202000', '632726202000', '632726000000', null, '4', null, '青海省玉树藏族自治州曲麻莱县叶格乡');
| INSERT INTO `sl_region` VALUES ('9435', '麻多乡', '632726203000', '632726203000', '632726000000', null, '4', null, '青海省玉树藏族自治州曲麻莱县麻多乡');
| INSERT INTO `sl_region` VALUES ('9436', '曲麻河乡', '632726204000', '632726204000', '632726000000', null, '4', null, '青海省玉树藏族自治州曲麻莱县曲麻河乡');
| INSERT INTO `sl_region` VALUES ('9437', '昆仑路街道', '632801001000', '632801001000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市昆仑路街道');
| INSERT INTO `sl_region` VALUES ('9438', '黄河路街道', '632801002000', '632801002000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市黄河路街道');
| INSERT INTO `sl_region` VALUES ('9439', '金峰路街道', '632801003000', '632801003000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市金峰路街道');
| INSERT INTO `sl_region` VALUES ('9440', '河西街道', '632801004000', '632801004000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市河西街道');
| INSERT INTO `sl_region` VALUES ('9441', '西藏路街道', '632801005000', '632801005000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市西藏路街道');
| INSERT INTO `sl_region` VALUES ('9442', '郭勒木德镇', '632801100000', '632801100000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市郭勒木德镇');
| INSERT INTO `sl_region` VALUES ('9443', '唐古拉镇', '632801101000', '632801101000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市唐古拉镇');
| INSERT INTO `sl_region` VALUES ('9444', '大格勒乡', '632801200000', '632801200000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市大格勒乡');
| INSERT INTO `sl_region` VALUES ('9445', '乌图美仁乡', '632801201000', '632801201000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市乌图美仁乡');
| INSERT INTO `sl_region` VALUES ('9446', '察尔汗工行委', '632801400000', '632801400000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市察尔汗工行委');
| INSERT INTO `sl_region` VALUES ('9447', '格尔木农垦有限公司', '632801401000', '632801401000', '632801000000', null, '4', null, '青海省海西蒙古族藏族自治州格尔木市格尔木农垦有限公司');
| INSERT INTO `sl_region` VALUES ('9448', '河西街道', '632802001000', '632802001000', '632802000000', null, '4', null, '青海省海西蒙古族藏族自治州德令哈市河西街道');
| INSERT INTO `sl_region` VALUES ('9449', '河东街道', '632802002000', '632802002000', '632802000000', null, '4', null, '青海省海西蒙古族藏族自治州德令哈市河东街道');
| INSERT INTO `sl_region` VALUES ('9450', '火车站街道', '632802003000', '632802003000', '632802000000', null, '4', null, '青海省海西蒙古族藏族自治州德令哈市火车站街道');
| INSERT INTO `sl_region` VALUES ('9451', '尕海镇', '632802100000', '632802100000', '632802000000', null, '4', null, '青海省海西蒙古族藏族自治州德令哈市尕海镇');
| INSERT INTO `sl_region` VALUES ('9452', '怀头他拉镇', '632802101000', '632802101000', '632802000000', null, '4', null, '青海省海西蒙古族藏族自治州德令哈市怀头他拉镇');
| INSERT INTO `sl_region` VALUES ('9453', '柯鲁柯镇', '632802102000', '632802102000', '632802000000', null, '4', null, '青海省海西蒙古族藏族自治州德令哈市柯鲁柯镇');
| INSERT INTO `sl_region` VALUES ('9454', '蓄集乡', '632802200000', '632802200000', '632802000000', null, '4', null, '青海省海西蒙古族藏族自治州德令哈市蓄集乡');
| INSERT INTO `sl_region` VALUES ('9455', '花土沟镇', '632803100000', '632803100000', '632803000000', null, '4', null, '青海省海西蒙古族藏族自治州茫崖市花土沟镇');
| INSERT INTO `sl_region` VALUES ('9456', '茫崖镇', '632803101000', '632803101000', '632803000000', null, '4', null, '青海省海西蒙古族藏族自治州茫崖市茫崖镇');
| INSERT INTO `sl_region` VALUES ('9457', '冷湖镇', '632803102000', '632803102000', '632803000000', null, '4', null, '青海省海西蒙古族藏族自治州茫崖市冷湖镇');
| INSERT INTO `sl_region` VALUES ('9458', '希里沟镇', '632821100000', '632821100000', '632821000000', null, '4', null, '青海省海西蒙古族藏族自治州乌兰县希里沟镇');
| INSERT INTO `sl_region` VALUES ('9459', '茶卡镇', '632821101000', '632821101000', '632821000000', null, '4', null, '青海省海西蒙古族藏族自治州乌兰县茶卡镇');
| INSERT INTO `sl_region` VALUES ('9460', '柯柯镇', '632821102000', '632821102000', '632821000000', null, '4', null, '青海省海西蒙古族藏族自治州乌兰县柯柯镇');
| INSERT INTO `sl_region` VALUES ('9461', '铜普镇', '632821103000', '632821103000', '632821000000', null, '4', null, '青海省海西蒙古族藏族自治州乌兰县铜普镇');
| INSERT INTO `sl_region` VALUES ('9462', '海西州莫河畜牧场', '632821500000', '632821500000', '632821000000', null, '4', null, '青海省海西蒙古族藏族自治州乌兰县海西州莫河畜牧场');
| INSERT INTO `sl_region` VALUES ('9463', '察汉乌苏镇', '632822100000', '632822100000', '632822000000', null, '4', null, '青海省海西蒙古族藏族自治州都兰县察汉乌苏镇');
| INSERT INTO `sl_region` VALUES ('9464', '香日德镇', '632822101000', '632822101000', '632822000000', null, '4', null, '青海省海西蒙古族藏族自治州都兰县香日德镇');
| INSERT INTO `sl_region` VALUES ('9465', '夏日哈镇', '632822102000', '632822102000', '632822000000', null, '4', null, '青海省海西蒙古族藏族自治州都兰县夏日哈镇');
| INSERT INTO `sl_region` VALUES ('9466', '宗加镇', '632822103000', '632822103000', '632822000000', null, '4', null, '青海省海西蒙古族藏族自治州都兰县宗加镇');
| INSERT INTO `sl_region` VALUES ('9467', '热水乡', '632822200000', '632822200000', '632822000000', null, '4', null, '青海省海西蒙古族藏族自治州都兰县热水乡');
| INSERT INTO `sl_region` VALUES ('9468', '香加乡', '632822201000', '632822201000', '632822000000', null, '4', null, '青海省海西蒙古族藏族自治州都兰县香加乡');
| INSERT INTO `sl_region` VALUES ('9469', '沟里乡', '632822202000', '632822202000', '632822000000', null, '4', null, '青海省海西蒙古族藏族自治州都兰县沟里乡');
| INSERT INTO `sl_region` VALUES ('9470', '巴隆乡', '632822203000', '632822203000', '632822000000', null, '4', null, '青海省海西蒙古族藏族自治州都兰县巴隆乡');
| INSERT INTO `sl_region` VALUES ('9471', '新源镇', '632823100000', '632823100000', '632823000000', null, '4', null, '青海省海西蒙古族藏族自治州天峻县新源镇');
| INSERT INTO `sl_region` VALUES ('9472', '木里镇', '632823101000', '632823101000', '632823000000', null, '4', null, '青海省海西蒙古族藏族自治州天峻县木里镇');
| INSERT INTO `sl_region` VALUES ('9473', '江河镇', '632823102000', '632823102000', '632823000000', null, '4', null, '青海省海西蒙古族藏族自治州天峻县江河镇');
| INSERT INTO `sl_region` VALUES ('9474', '快尔玛乡', '632823200000', '632823200000', '632823000000', null, '4', null, '青海省海西蒙古族藏族自治州天峻县快尔玛乡');
| INSERT INTO `sl_region` VALUES ('9475', '舟群乡', '632823201000', '632823201000', '632823000000', null, '4', null, '青海省海西蒙古族藏族自治州天峻县舟群乡');
| INSERT INTO `sl_region` VALUES ('9476', '织合玛乡', '632823202000', '632823202000', '632823000000', null, '4', null, '青海省海西蒙古族藏族自治州天峻县织合玛乡');
| INSERT INTO `sl_region` VALUES ('9477', '苏里乡', '632823203000', '632823203000', '632823000000', null, '4', null, '青海省海西蒙古族藏族自治州天峻县苏里乡');
| INSERT INTO `sl_region` VALUES ('9478', '生格乡', '632823204000', '632823204000', '632823000000', null, '4', null, '青海省海西蒙古族藏族自治州天峻县生格乡');
| INSERT INTO `sl_region` VALUES ('9479', '阳康乡', '632823205000', '632823205000', '632823000000', null, '4', null, '青海省海西蒙古族藏族自治州天峻县阳康乡');
| INSERT INTO `sl_region` VALUES ('9480', '龙门乡', '632823206000', '632823206000', '632823000000', null, '4', null, '青海省海西蒙古族藏族自治州天峻县龙门乡');
| INSERT INTO `sl_region` VALUES ('9481', '柴旦镇', '632857100000', '632857100000', '632857000000', null, '4', null, '青海省海西蒙古族藏族自治州大柴旦行政委员会柴旦镇');
| INSERT INTO `sl_region` VALUES ('9482', '锡铁山镇', '632857101000', '632857101000', '632857000000', null, '4', null, '青海省海西蒙古族藏族自治州大柴旦行政委员会锡铁山镇');
|
| -- ----------------------------
| -- Table structure for sl_store_management
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_store_management`;
| CREATE TABLE `sl_store_management` (
| `id` bigint NOT NULL,
| `store_management_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '仓库名称',
| `store_management_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '仓库编号',
| `store_management_number` int DEFAULT NULL COMMENT '仓库层数 1代表一层，2代表两层，3代表三层',
| `store_management_grade` int DEFAULT NULL COMMENT '仓库等级 1省级，2市州级，3市县级，5乡镇级，6 经营单位',
| `store_management_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所在市',
| `store_management_county` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所在县',
| `store_management_village` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所在乡',
| `director_id` bigint DEFAULT NULL COMMENT '主任id-仓库管理员选择的',
| `competent_id` bigint DEFAULT NULL COMMENT '主管id-仓库管理员选择的',
| `administrator_id` bigint DEFAULT NULL COMMENT '主管id',
| `store_management_adder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '仓库地址',
| `store_management_explain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '仓库说明',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所属省名称',
| `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所属省code',
| `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '城市名称',
| `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '城市code',
| `county_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所属区县名称',
| `county_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所属区县code',
| `town_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所属街道名称',
| `town_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所属街道code',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='仓库管理';
|
| -- ----------------------------
| -- Records of sl_store_management
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_store_management_img
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_store_management_img`;
| CREATE TABLE `sl_store_management_img` (
| `id` bigint NOT NULL,
| `img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '图片路径',
| `store_management_number` int DEFAULT NULL COMMENT '仓库层数 1代表一层，2代表两层，3代表三层',
| `store_management_id` bigint DEFAULT NULL COMMENT '仓库id',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='仓库对应平面图';
|
| -- ----------------------------
| -- Records of sl_store_management_img
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_volume_production_ck
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_volume_production_ck`;
| CREATE TABLE `sl_volume_production_ck` (
| `id` bigint NOT NULL,
| `materials_id` bigint DEFAULT NULL COMMENT '物资id',
| `rk_id` bigint DEFAULT NULL COMMENT '入库id',
| `ck_num` int DEFAULT NULL COMMENT '出库数量',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `supplier_id` bigint DEFAULT NULL COMMENT '供应商id',
| `attachment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '附件',
| `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用途',
| `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
| `state` int DEFAULT NULL COMMENT '1.待审核，2 已拒绝，3 审核通过',
| `guih_num` int DEFAULT NULL COMMENT '归还数量',
| `type` int DEFAULT NULL COMMENT '是否匹配 1未匹配，已匹配',
| `ck_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '出库时间',
| `gh_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '归还时间',
| `attachment_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '附件路径',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='发起出库';
|
| -- ----------------------------
| -- Records of sl_volume_production_ck
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_volume_production_ckgl
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_volume_production_ckgl`;
| CREATE TABLE `sl_volume_production_ckgl` (
| `id` bigint NOT NULL,
| `sys_id` bigint DEFAULT NULL COMMENT '发起人ID',
| `management_id` bigint DEFAULT NULL COMMENT '仓库ID',
| `starti_time` datetime DEFAULT NULL COMMENT '发起时间',
| `end_time` datetime DEFAULT NULL COMMENT '结束时间',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `present_state` int DEFAULT NULL COMMENT '1.待审核，2 已拒绝，3 审核通过',
| `audit_status` int DEFAULT NULL COMMENT '1 待管理员审核，2 待主管审核，3 待主任审核，4 已通过，5 已拒绝',
| `reasons_refusal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '拒绝理由',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='仓库出库管理';
|
| -- ----------------------------
| -- Records of sl_volume_production_ckgl
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_volume_production_rk
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_volume_production_rk`;
| CREATE TABLE `sl_volume_production_rk` (
| `id` bigint NOT NULL,
| `materials_id` bigint DEFAULT NULL COMMENT '物资id',
| `rk_num` bigint DEFAULT NULL COMMENT '入库数量',
| `rk_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '入库型号',
| `rk_pice` decimal(10,0) DEFAULT NULL COMMENT '入库价格',
| `store_management_number` bigint DEFAULT NULL COMMENT '仓库层数 1代表一层，2代表两层，3代表三层',
| `shelf_id` bigint DEFAULT NULL COMMENT '货架id',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `erwm_num` int DEFAULT NULL COMMENT '二维码数量',
| `volume_production_rkgl_id` bigint DEFAULT NULL COMMENT '入管理主表id',
| `management_id` bigint DEFAULT NULL COMMENT '仓库ID',
| `rk_number` varchar(255) DEFAULT NULL COMMENT '入库编号',
| `repertory_zhai` bigint DEFAULT NULL COMMENT '在库存的',
| `smerwm_num` int DEFAULT '0' COMMENT '扫描二维码数量',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='发起入库管理';
|
| -- ----------------------------
| -- Records of sl_volume_production_rk
| -- ----------------------------
| INSERT INTO `sl_volume_production_rk` VALUES ('1', '1', '1', '1', '1', '1', '1', '0', '', '2024-06-28 15:36:50', '', '2024-06-28 15:36:54', '1', '1', null, null, null, null);
| INSERT INTO `sl_volume_production_rk` VALUES ('2', '2', '1', '1', '1', '1', '1', '0', '', '2024-06-28 15:37:27', '', '2024-06-28 15:37:30', '2', '1', null, null, null, null);
|
| -- ----------------------------
| -- Table structure for sl_volume_production_rkgl
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_volume_production_rkgl`;
| CREATE TABLE `sl_volume_production_rkgl` (
| `id` bigint NOT NULL,
| `sys_id` bigint DEFAULT NULL COMMENT '发起人ID',
| `management_id` bigint DEFAULT NULL COMMENT '仓库ID',
| `starti_time` datetime DEFAULT NULL COMMENT '发起时间',
| `end_time` datetime DEFAULT NULL COMMENT '结束时间',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `present_state` int DEFAULT NULL COMMENT '1.待审核，2 已拒绝，3 审核通过',
| `audit_status` int DEFAULT NULL COMMENT '1 待管理员审核，2 待主管审核，3 待主任审核，4 已通过，5 已拒绝',
| `supplier_id` bigint DEFAULT NULL COMMENT '供应商id',
| `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '来源',
| `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
| `attachment_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '附件路径',
| `authorization` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审批单',
| `reasons_refusal` varchar(255) DEFAULT NULL COMMENT '拒绝理由',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='入库管理';
|
| -- ----------------------------
| -- Records of sl_volume_production_rkgl
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_volume_production_zy
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_volume_production_zy`;
| CREATE TABLE `sl_volume_production_zy` (
| `id` bigint NOT NULL,
| `materials_id` bigint DEFAULT NULL COMMENT '物资id',
| `rk_id` bigint DEFAULT NULL COMMENT '入库数量',
| `zy_num` int DEFAULT NULL COMMENT '转移数量',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `supplier_id` bigint DEFAULT NULL COMMENT '供应商id',
| `attachment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '附件',
| `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用途',
| `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
| `state` int DEFAULT NULL COMMENT '1.待审核，2 已拒绝，3 审核通过',
| `guih_num` int DEFAULT NULL COMMENT '归还数量',
| `type` int DEFAULT NULL COMMENT '是否匹配 1未匹配，已匹配',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='发起转移';
|
| -- ----------------------------
| -- Records of sl_volume_production_zy
| -- ----------------------------
|
| -- ----------------------------
| -- Table structure for sl_volume_production_zygl
| -- ----------------------------
| DROP TABLE IF EXISTS `sl_volume_production_zygl`;
| CREATE TABLE `sl_volume_production_zygl` (
| `id` bigint NOT NULL,
| `sys_id` bigint DEFAULT NULL COMMENT '发起人ID',
| `management_id` bigint DEFAULT NULL COMMENT '转移仓库ID',
| `starti_time` datetime DEFAULT NULL COMMENT '发起时间',
| `end_time` datetime DEFAULT NULL COMMENT '结束时间',
| `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
| `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
| `update_time` datetime DEFAULT NULL COMMENT '更新时间',
| `present_state` int DEFAULT NULL COMMENT '1.待审核，2 已拒绝，3 审核通过',
| `audit_status` int DEFAULT NULL COMMENT '1 待管理员审核，2 待主管审核，3 待主任审核，4 已通过，5 已拒绝',
| `bmanagement_id` bigint DEFAULT NULL COMMENT '被转移仓库ID',
| `reasons_refusal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '拒绝理由',
| PRIMARY KEY (`id`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='转移管理';
|
| -- ----------------------------
| -- Records of sl_volume_production_zygl
| -- ----------------------------
|
|
