121 lines
16 KiB
SQL
121 lines
16 KiB
SQL
-- QAUP 业务基础数据
|
||
SET session_replication_role = replica;
|
||
--
|
||
-- PostgreSQL database dump
|
||
--
|
||
|
||
-- Dumped from database version 17.5 (Homebrew)
|
||
-- Dumped by pg_dump version 17.5 (Homebrew)
|
||
|
||
SET statement_timeout = 0;
|
||
SET lock_timeout = 0;
|
||
SET idle_in_transaction_session_timeout = 0;
|
||
SET transaction_timeout = 0;
|
||
SET client_encoding = 'UTF8';
|
||
SET standard_conforming_strings = on;
|
||
SELECT pg_catalog.set_config('search_path', '', false);
|
||
SET check_function_bodies = false;
|
||
SET xmloption = content;
|
||
SET client_min_messages = warning;
|
||
SET row_security = off;
|
||
|
||
--
|
||
-- Data for Name: airport_areas; Type: TABLE DATA; Schema: public; Owner:
|
||
SET SESSION AUTHORIZATION DEFAULT;
|
||
|
||
ALTER TABLE public.airport_areas DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.airport_areas VALUES (4, 'APRON_01', '停机坪区域01', 'APRON', '0103000020E6100000010000000500000085EB51B81E055E40560E2DB29D2F42401283C0CAA1055E40560E2DB29D2F42401283C0CAA1055E40022B8716D92E424085EB51B81E055E40022B8716D92E424085EB51B81E055E40560E2DB29D2F4240', '主要停机坪区域，覆盖无人车和航空器活动区域，包含route.md中所有测试路线', NULL, NULL, true, 8, NULL, 'AIRCRAFT_OPERATIONS', NULL, '2025-07-12 10:49:48.828993', '2025-07-12 10:49:48.828993', 0);
|
||
INSERT INTO public.airport_areas VALUES (5, 'TAXIWAY_ALPHA', '滑行道Alpha', 'TAXIWAY', '0103000020E610000001000000050000006891ED7C3F055E408FC2F5285C2F42402FDD240681055E408FC2F5285C2F42402FDD240681055E40C976BE9F1A2F42406891ED7C3F055E40C976BE9F1A2F42406891ED7C3F055E408FC2F5285C2F4240', '主要滑行道，连接停机坪和跑道', NULL, NULL, true, 7, NULL, 'AIRCRAFT_OPERATIONS', NULL, '2025-07-12 10:49:48.829562', '2025-07-12 10:49:48.829562', 0);
|
||
INSERT INTO public.airport_areas VALUES (1, 'UV_TEST_AREA_A', '无人车A测试区域', 'UNMANNED_VEHICLE_ZONE', '0103000020E610000001000000050000000C62E1F36D055E4011429BFFB42E4240E89C6DAF78055E400D35CF72D72E42407C50E0FB62055E40ED915C11F12E42403776FAAF5C055E401C76B36ECC2E42400C62E1F36D055E4011429BFFB42E4240', '无人车A运行测试区域，包含起点和终点的矩形区域', NULL, NULL, true, 5, NULL, 'UNMANNED_VEHICLE_OPERATIONS', NULL, '2025-07-12 10:49:48.826007', '2025-07-12 10:50:41.816828', 0);
|
||
INSERT INTO public.airport_areas VALUES (2, 'UV_TEST_AREA_B', '无人车B测试区域', 'UNMANNED_VEHICLE_ZONE', '0103000020E610000001000000070000002048279588055E40590F73545B2F424060D388A08E055E40ECA60720712F42405316FB3D73055E407823697B8F2F4240034599D277055E40CECE705F742F42406E4C62F772055E40A4B436CC692F42404073645A7F055E40F649299C572F42402048279588055E40590F73545B2F4240', '无人车B运行测试区域，包含起点和终点的矩形区域', NULL, NULL, true, 5, NULL, 'UNMANNED_VEHICLE_OPERATIONS', NULL, '2025-07-12 10:49:48.826788', '2025-07-12 10:49:48.826788', 0);
|
||
|
||
|
||
ALTER TABLE public.airport_areas ENABLE TRIGGER ALL;
|
||
|
||
--
|
||
-- Data for Name: spatial_rules; Type: TABLE DATA; Schema: public; Owner:
|
||
ALTER TABLE public.spatial_rules DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.spatial_rules VALUES ('GEOFENCE_UV_AREA_A_ACCESS', '无人车A区域准入控制', '限制无人车A测试区域的访问权限', 'ACCESS_CONTROL', 'ACTIVE', 1, 'AREA', 'UV_TEST_AREA_A', '{"accessControl": {"requiresPermission": true, "allowedOperationModes": ["AUTONOMOUS", "MANUAL"]}, "physicalLimits": {"maxSpeed": 20.0}, "safetyRequirements": {"minBatteryLevel": 30}}', 'WARNING', '进入无人车A测试区域需要授权', NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-12 10:49:48.827433', '2025-07-12 10:49:48.827433', 'system', NULL, 0, NULL);
|
||
INSERT INTO public.spatial_rules VALUES ('GEOFENCE_UV_AREA_B_ACCESS', '无人车B区域准入控制', '限制无人车B测试区域的访问权限', 'ACCESS_CONTROL', 'ACTIVE', 1, 'AREA', 'UV_TEST_AREA_B', '{"accessControl": {"requiresPermission": true, "allowedOperationModes": ["AUTONOMOUS", "MANUAL"]}, "physicalLimits": {"maxSpeed": 20.0}, "safetyRequirements": {"minBatteryLevel": 30}}', 'WARNING', '进入无人车B测试区域需要授权', NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-12 10:49:48.827913', '2025-07-12 10:49:48.827913', 'system', NULL, 0, NULL);
|
||
INSERT INTO public.spatial_rules VALUES ('SPEED_LIMIT_APRON', '停机坪限速规则', '停机坪区域内所有车辆的限速控制规则', 'SPEED_LIMIT', 'ACTIVE', 1, 'AREA', 'APRON_01', '{"unit": "kmh", "maxSpeed": 15.0, "strictMode": true, "warningThreshold": 0.8}', 'WARNING', '停机坪内超速行驶', NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-12 10:49:48.82917', '2025-07-12 10:49:48.82917', 'system', NULL, 0, NULL);
|
||
INSERT INTO public.spatial_rules VALUES ('SPEED_LIMIT_TAXIWAY', '滑行道限速规则', '滑行道区域内的限速控制', 'SPEED_LIMIT', 'ACTIVE', 2, 'AREA', 'TAXIWAY_ALPHA', '{"unit": "kmh", "maxSpeed": 25.0, "warningThreshold": 0.9}', 'WARNING', '滑行道内超速行驶', NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-12 10:49:48.82978', '2025-07-12 10:49:48.82978', 'system', NULL, 0, NULL);
|
||
|
||
|
||
ALTER TABLE public.spatial_rules ENABLE TRIGGER ALL;
|
||
|
||
--
|
||
-- Data for Name: spatial_rule_vehicle_types; Type: TABLE DATA; Schema: public; Owner:
|
||
ALTER TABLE public.spatial_rule_vehicle_types DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('GEOFENCE_UV_AREA_A_ACCESS', 'UNMANNED_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('GEOFENCE_UV_AREA_B_ACCESS', 'UNMANNED_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_APRON', 'UNMANNED_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_APRON', 'AIRCRAFT');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_APRON', 'SPECIAL_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_APRON', 'NORMAL_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_TAXIWAY', 'UNMANNED_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_TAXIWAY', 'AIRCRAFT');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_TAXIWAY', 'SPECIAL_VEHICLE');
|
||
|
||
|
||
ALTER TABLE public.spatial_rule_vehicle_types ENABLE TRIGGER ALL;
|
||
|
||
--
|
||
-- Data for Name: sys_vehicle_type; Type: TABLE DATA; Schema: public; Owner:
|
||
ALTER TABLE public.sys_vehicle_type DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.sys_vehicle_type VALUES (1, 'UV', 'UNMANNED_VEHICLE', '无人车', 'Unmanned Vehicle', 1, NULL, '无人车', false, 1, true, '自动驾驶无人车辆', '{"category": "UNMANNED", "maxSpeed": 30, "autonomous": true, "requiresPermission": true}', NULL, '2025-07-13 11:25:17.226345', NULL, '2025-07-13 11:25:17.226345', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (2, 'SP', 'SPECIAL_VEHICLE', '特勤车', 'Special Vehicle', 1, NULL, '特勤车', false, 2, true, '具有特殊权限的车辆', '{"category": "SPECIAL", "priority": "HIGH", "accessAllAreas": true, "hasSpecialPrivileges": true}', NULL, '2025-07-13 11:25:17.226345', NULL, '2025-07-13 11:25:17.226345', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (3, 'NM', 'NORMAL_VEHICLE', '普通车', 'Normal Vehicle', 1, NULL, '普通车', false, 3, true, '一般机场运营车辆', '{"category": "NORMAL", "maxSpeed": 40, "priority": "NORMAL"}', NULL, '2025-07-13 11:25:17.226345', NULL, '2025-07-13 11:25:17.226345', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (4, 'UV.PT', 'PATROL_VEHICLE', '巡逻车', 'Patrol Vehicle', 2, 'UV', '无人车/巡逻车', true, 1, true, '自主巡逻无人车', '{"sensors": ["CAMERA", "RADAR"], "maxSpeed": 25, "patrolRange": 5000}', NULL, '2025-07-13 11:25:17.229016', NULL, '2025-07-13 11:25:17.229016', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (5, 'UV.DL', 'DELIVERY_VEHICLE', '配送车', 'Delivery Vehicle', 2, 'UV', '无人车/配送车', true, 2, true, '自主配送无人车', '{"maxSpeed": 30, "cargoCapacity": 500}', NULL, '2025-07-13 11:25:17.229016', NULL, '2025-07-13 11:25:17.229016', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (6, 'UV.IN', 'INSPECTION_VEHICLE', '检查车', 'Inspection Vehicle', 2, 'UV', '无人车/检查车', true, 3, true, '自主检查无人车', '{"sensors": ["CAMERA", "LIDAR", "THERMAL"], "maxSpeed": 20}', NULL, '2025-07-13 11:25:17.229016', NULL, '2025-07-13 11:25:17.229016', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (7, 'UV.SH', 'SHUTTLE_VEHICLE', '接驳车', 'Shuttle Vehicle', 2, 'UV', '无人车/接驳车', true, 4, true, '无人接驳车', '{"maxSpeed": 35, "passengerCapacity": 8}', NULL, '2025-07-13 11:25:17.229016', NULL, '2025-07-13 11:25:17.229016', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (8, 'UV.BD', 'BIRD_DETERRENT', '驱鸟车', 'Bird Deterrent Vehicle', 2, 'UV', '无人车/驱鸟车', true, 5, true, '自动驱鸟无人车', '{"maxSpeed": 25, "soundSystem": true}', NULL, '2025-07-13 11:25:17.229016', NULL, '2025-07-13 11:25:17.229016', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (9, 'SP.FT', 'FIRE_TRUCK', '消防车', 'Fire Truck', 2, 'SP', '特勤车/消防车', true, 1, true, '机场消防车', '{"maxSpeed": 60, "priority": "CRITICAL", "accessAllAreas": true, "emergencyVehicle": true}', NULL, '2025-07-13 11:25:17.229389', NULL, '2025-07-13 11:25:17.229389', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (10, 'SP.PC', 'POLICE_CAR', '警车', 'Police Car', 2, 'SP', '特勤车/警车', true, 2, true, '机场警车', '{"maxSpeed": 80, "priority": "HIGH", "accessAllAreas": true, "emergencyVehicle": true}', NULL, '2025-07-13 11:25:17.229389', NULL, '2025-07-13 11:25:17.229389', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (11, 'SP.AM', 'AMBULANCE', '救护车', 'Ambulance', 2, 'SP', '特勤车/救护车', true, 3, true, '机场救护车', '{"maxSpeed": 70, "priority": "CRITICAL", "emergencyVehicle": true}', NULL, '2025-07-13 11:25:17.229389', NULL, '2025-07-13 11:25:17.229389', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (12, 'SP.FM', 'FOLLOW_ME_CAR', '引导车', 'Follow Me Car', 2, 'SP', '特勤车/引导车', true, 4, true, '飞机引导车', '{"maxSpeed": 50, "priority": "HIGH", "followMode": true}', NULL, '2025-07-13 11:25:17.229389', NULL, '2025-07-13 11:25:17.229389', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (13, 'SP.SC', 'SECURITY_CAR', '安保车', 'Security Car', 2, 'SP', '特勤车/安保车', true, 5, true, '机场安保车辆', '{"maxSpeed": 60, "priority": "HIGH", "patrolVehicle": true}', NULL, '2025-07-13 11:25:17.229389', NULL, '2025-07-13 11:25:17.229389', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (14, 'NM.BG', 'BAGGAGE_CART', '行李车', 'Baggage Cart', 2, 'NM', '普通车/行李车', true, 1, true, '行李运输车', '{"maxSpeed": 25, "cargoType": "BAGGAGE"}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (15, 'NM.CL', 'CLEANING_VEHICLE', '清洁车', 'Cleaning Vehicle', 2, 'NM', '普通车/清洁车', true, 2, true, '机场清洁车', '{"maxSpeed": 20, "equipmentType": "CLEANING"}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (16, 'NM.CT', 'CATERING_TRUCK', '餐车', 'Catering Truck', 2, 'NM', '普通车/餐车', true, 3, true, '航空餐饮车', '{"maxSpeed": 25, "cargoType": "CATERING"}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (17, 'NM.TG', 'TUG_VEHICLE', '拖车', 'Tug Vehicle', 2, 'NM', '普通车/拖车', true, 4, true, '飞机拖车', '{"maxSpeed": 15, "towingCapacity": true}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (18, 'NM.FL', 'FUEL_TRUCK', '加油车', 'Fuel Truck', 2, 'NM', '普通车/加油车', true, 5, true, '燃料补给车', '{"maxSpeed": 20, "fuelCapacity": true, "hazardousMaterial": true}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (19, 'NM.MT', 'MAINTENANCE_VEHICLE', '维护车', 'Maintenance Vehicle', 2, 'NM', '普通车/维护车', true, 6, true, '设备维护车', '{"maxSpeed": 30, "equipmentType": "MAINTENANCE"}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (20, 'NM.TR', 'TRANSPORT_TRUCK', '运输车', 'Transport Truck', 2, 'NM', '普通车/运输车', true, 7, true, '货物运输车', '{"maxSpeed": 40, "cargoCapacity": 5000}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
|
||
|
||
ALTER TABLE public.sys_vehicle_type ENABLE TRIGGER ALL;
|
||
|
||
--
|
||
-- Data for Name: transport_routes; Type: TABLE DATA; Schema: public; Owner:
|
||
ALTER TABLE public.transport_routes DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.transport_routes VALUES (3, '特勤车鲁B123路径', 'SPECIAL_VEHICLE', '鲁B123特勤车的预定路径', '0102000020E610000002000000FB1EF5D72B055E4080EECB99ED2E4240B24AE9995E055E40E5B9BE0F072F4240', 30, 30, NULL, NULL, 'ACTIVE', false, NULL, NULL, '2025-07-11 17:56:56.179577+08', '2025-07-11 17:56:56.179577+08');
|
||
INSERT INTO public.transport_routes VALUES (4, '普通车鲁B234路径', 'UNMANNED_VEHICLE', '鲁B234普通车的预定路径', '0102000020E61000000200000007D2C5A695055E402313F06B242F4240B24AE9995E055E40E5B9BE0F072F4240', 30, 30, NULL, NULL, 'ACTIVE', false, NULL, NULL, '2025-07-11 17:56:56.179577+08', '2025-07-11 17:56:56.179577+08');
|
||
INSERT INTO public.transport_routes VALUES (5, '无人车鲁B567路径', 'UNMANNED_VEHICLE', '鲁B567无人车的预定路径', '0102000020E61000000200000089B48D3F51055E4023BBD232522F424005C24EB16A055E404AEEB089CC2E4240', 25, 25, NULL, NULL, 'ACTIVE', false, NULL, NULL, '2025-07-11 17:56:56.179577+08', '2025-07-11 17:56:56.179577+08');
|
||
INSERT INTO public.transport_routes VALUES (6, '无人车鲁B579路径', 'UNMANNED_VEHICLE', '鲁B579无人车的预定路径', '0102000020E61000000200000063B9A5D590055E404E2B85402E2F4240B6F63E5585055E407BD80B056C2F4240', 25, 25, NULL, NULL, 'ACTIVE', false, NULL, NULL, '2025-07-11 17:56:56.179577+08', '2025-07-11 17:56:56.179577+08');
|
||
INSERT INTO public.transport_routes VALUES (8, 'FLIGHT_CA3456_OUT', 'AIRCRAFT', '航空器路由 - 类型: OUT, 状态: COMPLETE, 路径: 138,L4,F1, 包含 31 个路径段, 总坐标点: 18', '0102000020E610000012000000ADF29129C75083417F9D95A0CCB74E419458A0C5C15083414885D130B9B74E4145473A77C1508341C08B4B63B7B74E411D4CF732C15083417E26D760B4B74E4178F8E8E3C0508341A0C9E344ADB74E414F1F55CCC0508341DDE2E2BCA4B74E41202D20DBC0508341D6B46B999FB74E41FADDB866C1508341A2CDC31284B74E419D0AA66AC1508341AA36A0DE7EB74E41C3F1A45AC15083410FDD70157BB74E412DF5813BC15083411B378EAF77B74E41804A5C0FC1508341B84440E874B74E412DDB8FC5C05083419ACE537C72B74E419946E687C05083418621CFCA71B74E4169747749C05083412DB6B01E72B74E41FFCA47F6BB508341D59E293581B74E411A2C3C87BB508341A591857C81B74E413AF00AF6AE5083419B5550A241B74E41', 50, 30, NULL, NULL, 'ACTIVE', false, 'DataCollectorService', 'DataCollectorService', '2025-07-24 19:03:23.383926+08', '2025-07-31 17:29:46.597627+08');
|
||
INSERT INTO public.transport_routes VALUES (7, 'FLIGHT_CA3456_IN', 'AIRCRAFT', '航空器路由 - 类型: IN, 状态: COMPLETE, 路径: F1,L4,138, 包含 31 个路径段, 总坐标点: 18', '0102000020E610000012000000ADF29129C75083417F9D95A0CCB74E419458A0C5C15083414885D130B9B74E4145473A77C1508341C08B4B63B7B74E411D4CF732C15083417E26D760B4B74E4178F8E8E3C0508341A0C9E344ADB74E414F1F55CCC0508341DDE2E2BCA4B74E41202D20DBC0508341D6B46B999FB74E41FADDB866C1508341A2CDC31284B74E419D0AA66AC1508341AA36A0DE7EB74E41C3F1A45AC15083410FDD70157BB74E412DF5813BC15083411B378EAF77B74E41804A5C0FC1508341B84440E874B74E412DDB8FC5C05083419ACE537C72B74E419946E687C05083418621CFCA71B74E4169747749C05083412DB6B01E72B74E41FFCA47F6BB508341D59E293581B74E411A2C3C87BB508341A591857C81B74E413AF00AF6AE5083419B5550A241B74E41', 50, 30, NULL, NULL, 'ACTIVE', false, 'DataCollectorService', 'DataCollectorService', '2025-07-24 19:02:48.474886+08', '2025-07-31 17:29:56.608121+08');
|
||
|
||
|
||
ALTER TABLE public.transport_routes ENABLE TRIGGER ALL;
|
||
-- Name: airport_areas_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
|
||
SELECT pg_catalog.setval('public.airport_areas_id_seq', 5, true);
|
||
|
||
-- Name: sys_vehicle_type_new_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
|
||
SELECT pg_catalog.setval('public.sys_vehicle_type_new_id_seq', 20, true);
|
||
|
||
-- Name: transport_routes_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
|
||
SELECT pg_catalog.setval('public.transport_routes_id_seq', 8, true);
|
||
|
||
|
||
--
|
||
-- PostgreSQL database dump complete
|
||
--
|
||
|
||
SET session_replication_role = DEFAULT;
|