CNSi DL ERD
CNSi Data Base ERD (Draft)
Tables (9)
A2GQ (dl_a2gq)
- Sequence_Number (seq) — uint16_t — Foreign key → CNSi DownLink Data.Sequence_Number
- DonwLink_Type (dl_type) — INT(11) — Foreign key → CNSi DownLink Data.DonwLink_Type
- CNSi_id (cnsi_id) — char[10]
- TimeStamp (time_unix_usec) — uint64_t
- TimeBoot (time_boot_ms) — uint32_t
- System_time (sys_time) — char[15]
- System_id (sys_id) — char[10]
- Latitude (latitude) — float
- Longitude (longitude) — float
- GNSS_Lock (gps_lock) — float
- Alt (alt) — float
- Alt_relative (alt_rel) — float
- Heading (heading) — float
- 5G_PCID (nr5g_pcid) — int
- 5G_RSRP (nr5g_rsrp) — int
- 5G_RSRQ (nr5g_rsrq) — int
- Band (band) — int
- BW (bw) — int
- Ri (ri) — int
- Cqi (cqi) — int
- UL_t_put (ul_t_put) — int
- DL_t_put (dl_t_put) — int
- PCELL (pcell) — int
- BABD (babd) — int
- RSRP (rsrp) — int
- RSRQ (rsrq) — int
- RSSI (rssi) — int
- SINR (sinr) — int
- PCI (pci) — int
- TX_Power (tx_power) — int
ATTD (dl_attd)
- Sequence_Number (seq) — uint16_t — Foreign key → CNSi DownLink Data.Sequence_Number
- DonwLink_Type (dl_type) — INT(11) — Foreign key → CNSi DownLink Data.DonwLink_Type
- CNSi_id (cnsi_id) — char[10]
- TimeStamp (time_unix_usec) — uint64_t
- TimeBoot (time_boot_ms) — uint32_t
- Roll (roll) — float
- Pitch (pitch) — float
- Yaw (yaw) — float
- RollSpeed (rollspeed) — float
- PitchSpeed (pitchspeed) — float
- YawSpeed (yawspeed) — yaw
CNSi DownLink Data (cnsi_downlink)
- Sequence_Number (seq) — uint16_t — Primary key
- DonwLink_Type (dl_type) — INT(11) — Primary key
- Receive_time (receive_time) — INT(11) — NOT NULL
- CNSi _id (cnsi_id) — char[10]
HOME (dl_home)
- Sequence_Number (seq) — uint16_t — Foreign key → CNSi DownLink Data.Sequence_Number
- DonwLink_Type (dl_type) — INT(11) — Foreign key → CNSi DownLink Data.DonwLink_Type
- CNSi_id (cnsi_id) — char[10]
- TimeStamp (time_unix_usec) — uint64_t
- TimeBoot (time_boot_ms) — uint32_t
- Latitude (latitude) — int32_t
- Longitude (longitude) — int32_t
- Altitude (altitude) — int32_t
- X (x) — float
- Y (y) — float
- Z (z) — float
- Q (q) — float[4]
- Approach_x (approach_x) — float
- Approach_y (approach_y) — float
- Approach_z (approach_z) — float
IMUD (dl_imud)
- Sequence_Number (seq) — uint16_t — Foreign key → CNSi DownLink Data.Sequence_Number
- DonwLink_Type (dl_type) — INT(11) — Foreign key → CNSi DownLink Data.DonwLink_Type
- CNSi_id (cnsi_id) — char[10]
- TimeStamp (time_unix_usec) — uint64_t
- TimeBoot (time_boot_ms) — uint32_t
- X_acc (xacc) — float
- Y_acc (yacc) — float
- Z_acc (zacc) — float
- X_gyro (xgyro) — float
- Y_gyro (ygyro) — float
- Z_gyro (zgyro) — float
- X_mag (xmag) — float
- Y_mag (ymag) — float
- Z_mag (Zmag) — float
- ABS_press (abs_pressure) — float
- Diff_press (diff_pressure) — float
- Pressure_alt (pressure_alt) — float
- Temp (temperature) — float
- Fields_update (fields_updated) — uint16_t
- ID (id) — uint8_t
INFO (dl_info)
- Sequence_Number (seq) — uint16_t — Foreign key → CNSi DownLink Data.Sequence_Number
- DonwLink_Type (dl_type) — INT(11) — Foreign key → CNSi DownLink Data.DonwLink_Type
- CNSi_id (cnsi_id) — char[10]
- TimeStamp (time_unix_usec) — uint64_t
- TimeBoot (time_boot_ms) — uint32_t
- Sensor_present (onboard_control _sensors_present) — uint32_t
- Sensor_enabled (onboard_control_sensors_enabled) — uint32_t
- Sensors_health (onboard_control_sensors_health) — uint32_t
- Load (load) — int8_t
- Voltage (voltage_battery) — uint16_t
- Batter_Percent (current_battery) — uint16_t
- Drop rate (drop_rate_comm) — uint16_t
- Error (errors_comm) — uint16_t
- Error_count1 (error_count1) — uint16_t
- Error_count2 (error_count2) — uint16_t
- Error_count3 (error_count3) — uint16_t
- Error_count4 (error_count4) — uint16_t
PSD1 (dl_psd1)
- Sequence_Number (seq) — uint16_t — Foreign key → CNSi DownLink Data.Sequence_Number
- DonwLink_Type (dl_type) — INT(11) — Foreign key → CNSi DownLink Data.DonwLink_Type
- CNSi_id (cnsi_id) — char[10]
- TimeStamp (time_unix_usec) — uint64_t
- TimeBoot (time_boot_ms) — uint32_t
- GPS Fix Type (fix_type) — uint8_t
- Latitude (lat) — int32_t
- Longitude (lon) — int32_t
- Altitude (alt) — int32_t
- HDOP (eph) — uint16_t
- VDOP (epv) — uint16_t
- Velocity (vel) — uint16_t
- COG (cog) — uint16_t
- Sat_Count (Satellites_visible) — uint8_t
- Altitude (alt_ellipsoid) — int32_t
- H_ACC (h_acc) — uint32_t
- V_ACC (v_acc) — uint32_t
- VEL_ACC (vel_acc) — uint32_t
- HDG_ACC (hdg_acc) — uint32_t
- YAW (yaw) — uint16_t
- Airspeed (airspeed) — float
- Groundspeed (groundspeed) — float
- Heading (heading) — int16_t
- Alt_VFR (alt_vfr) — float
- Climb (climb) — float
PSD2 (dl_psd2)
- Sequence_Number (seq) — uint16_t — Foreign key → CNSi DownLink Data.Sequence_Number
- DonwLink_Type (dl_type) — INT(11) — Foreign key → CNSi DownLink Data.DonwLink_Type
- CNSi_id (cnsi_id) — char[10]
- TimeStamp (time_unix_usec) — uint64_t
- TimeBoot (time_boot_ms) — uint32_t
- Latitude (lat)
- Longitude (lon) — int32_t
- Altitude (alt) — int32_t
- Relative_Alt (relative_alt) — int32_t
- VX (vx) — int16_t
- VY (vy) — int16_t
- VZ (vz) — int16_t
- Heading (hdg) — uint16_t
- AirSpeed (airspeed) — float
- GroundSpeed (groundspeed) — float
- Heading_Compass (heading) — int16_t
- VRF_Alt (alt_vfr) — float
- Climbe Rate (climb) — float
VIBD (dl_vibd)
- Sequence_Number (seq) — uint16_t — Foreign key → CNSi DownLink Data.Sequence_Number
- DonwLink_Type (dl_type) — INT(11) — Foreign key → CNSi DownLink Data.DonwLink_Type
- CNSi_id (cnsi_id) — char[10]
- TimeStamp (time_unix_usec) — uint64_t
- TimeBoot (time_boot_ms) — uint32_t
- VIB_X (vibration_x) — float
- VIB_Y (vibration_y) — float
- VIB_Z (vibration_z) — float
- Clip_0 (clipping_0) — uint32_t
- Clip_1 (clipping_1) — uint32_t
- Clip_2 (clipping_2) — uint32_t