1.5.69 SatDbSatellite

The SatDbSatellite data record contains the basic properties for one satellite in the satellites database table. The fields in the SatDbSatellite 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.

Data Model

Key Type Value
satelliteId Number unique, primary key, auto generated
name String free text, typically the name as given by satellite operator
operatorId Number relation to table satellite-operators
noradNumber Number unique name (world wide standardized), also relation to table norad_tle
intDesignator String unique name (world wide standardized)
orbitPosition Number satellite orbit position in degrees
inclination Number satellite inclination in degrees
alias String free text, can be used by customer to add own name
modified String timestamp, generated by database at creation / modification time