5.6.7 Table Satellite Positions (satellite_positions)

This tables stores an antenna position (Azimuth/Elevation/Polarization) for a given Satellite and a specific Antenna.

Field null Description
position_id no unique, primary key, auto generated
satellite_id no ID of the satellite this position belongs to
azimuth yes antenna azimuth position in degrees
elevation yes antenna elevation position in degrees
polarization yes antenna polarization position in degrees
satellite-colocation yes TODO we need to recap how this field will be used, for now its just free text
target_number yes a target number for this satellite to command at the antenna controller (device specific)
antenna_id no id of antenna, 1:1 relation to antenna table
default no boolean, true meaning this is the default satellite position
modified no automatically created timestamp of last change

Should later provide a dropdown list with the valid antenna (device) names.