The Request table

The Request table is the main table that holds information about the requested observation. The column headings are:

• RequestID - autoincrement integer primary key
• ObserverID - key of person requesting -must be specified
• Name - user useful label about the request
• ObsTime - time (in seconds) needed for observation -optional
• Count - number of repeat requests (default:1)
• NumberDone - number of times request successfully observed (default:0)
• Timestamp - when the request was received (automatically entered)
• Priority - how important bigger is better (default: 0)
• Twilight - maximum altitude of sun for observation (default:-12.0)
• Airmass - maximum airmass for observation (default:3.0)
• UTStart - Universal time to start observation (default:NULL)
• SunStart - used to schedule tasks at specific sun altitude in degrees (default:NULL)
• MoonDistance - moon avoidance angle in degrees (default: 30 degrees)
• MoonPhase - maximum moon phase angle 1.0-full (default: 1.0)
• Earliest - earliest DateTime the observation can start (default: NULL)
• Latest - latest DateTime the observation can start (default: NULL)
• Interval*** - interval in hours to repeat observation (default: NULL)

Note: If the count field is set to NULL, it has the action of a never ending request going once per night. A Cascade delete has been placed on this table to the target file so if the request is deleted, the associated targets are also deleted. Also, he SunStart altitude is not corrected for the elevation of the observatory.