ldb_airport.sql 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. # 无人机信息表
  2. drop table if exists uav;
  3. CREATE TABLE `uav`
  4. (
  5. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
  6. `object_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '目标唯一编号',
  7. `longitude` DECIMAL(18, 15) NOT NULL COMMENT '目标经度(使用WGS84坐标系)',
  8. `latitude` DECIMAL(18, 15) NOT NULL COMMENT '目标纬度(使用WGS84坐标系)',
  9. `altitude` DECIMAL(8, 3) NOT NULL COMMENT '目标海拔高度(海拔高度(GPS/北斗),单位:米)',
  10. `height` DECIMAL(8, 3) COMMENT '距地高度(距地高度(相对基站安装的地面高度),单位:米)',
  11. `speed` DECIMAL(8, 3) NOT NULL COMMENT '目标速度(单位(m/s))',
  12. `time` timestamp COMMENT '探测时间戳(UTC)(单位:毫秒)',
  13. `location` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '发现地点',
  14. `uav_Model` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '无人机型号',
  15. `uavSN` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '' COMMENT '无人机飞控序列号',
  16. `channel` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '频点',
  17. `device_type` int not null COMMENT '侦测设备类型',
  18. `create_time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  19. `update_time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  20. PRIMARY KEY (`id`) USING BTREE
  21. ) ENGINE = InnoDB
  22. AUTO_INCREMENT = 1
  23. DEFAULT CHARSET = utf8mb3
  24. ROW_FORMAT = DYNAMIC COMMENT ='无人机信息表';
  25. # 无人机设备类型表
  26. drop table if exists uav_device_type;
  27. CREATE TABLE `uav_device_type`
  28. (
  29. `id` int primary key NOT NULL AUTO_INCREMENT COMMENT '主键id',
  30. `device_type` int NOT NULL COMMENT '设备类型',
  31. `device_name` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '设备名称',
  32. `device_type_abbr` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '设备缩写'
  33. ) ENGINE = InnoDB
  34. AUTO_INCREMENT = 1
  35. DEFAULT CHARSET = utf8mb3
  36. ROW_FORMAT = DYNAMIC COMMENT ='无人机设备类型表';
  37. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (0, '5G-A基站', '5ga');
  38. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (1, '雷达设备', 'radar');
  39. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (2, '频谱设备', 'spec');
  40. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (3, '光电设备', 'oe');
  41. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (4, '反制设备', 'cm');
  42. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (5, '诱骗设备', 'dec');
  43. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (6, '干扰设备', 'ifr');
  44. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (7, '指挥车', 'cv');
  45. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (8, '察打一体', 'isrs');
  46. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (9, 'AOA', 'aoa');
  47. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (10, 'TDOA', 'tdoa');
  48. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (11, '协议破解', 'dcd');
  49. INSERT INTO ldb_airport.uav_device_type (device_type, device_name, device_type_abbr) VALUES (102, 'Remote ID设备', 'rid');