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