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