5.5.75 SatDbTm

The SatDbTm data record contains the basic properties for one satellite in the satellite_tm database table. The fields in the SatDbBeacon data record are 1:1 replicas of the SQL database record. Please refer to the database model description at section Satellite Database how relations between tables are maintained using IDs.

There may be multiple telemetry channel definitions assigned to one satellite. These channels share the same satelliteId. One of these TM channels is the default channel, this and only this channel has the defaultTm flag set true.

Data Model

Key Type Value
tmId Number unique, primary key, auto generated
satelliteId Number ID of the satellite this beacon belongs to
frequency1 Number primary receive frequency, floating point, MHz
frequency2 Number secondary receive frequency, floating point, MHz
polarization1 String this is an enumeration, may be one of "H", "V", "RHCP" or "LHCP"
polarization2 String this is an enumeration, may be one of "H", "V", "RHCP" or "LHCP"
defaultTm Boolean true means "this is the default telemetry channel for this satellite"
comment String free text describing the purpose of this beacon
modified String timestamp, generated by database at creation / modification time