NRAO Home  >  Green Bank  |  Wiki Topic:    GB > Software > PlanOfRecordC72006 > SchedulingSoftware > DBaseDocs

Changes | Index | Contents | Search | Statistics | Go

DB Table Examples DBase and MySQL:

• TableDoc.txt: DBase table structures
• propmysql.sql: SQL script for creating some the DBase tables. Resulting tables have been created under the database name "pas" on the MySQL server leo. Use phpmyadmin to access the MySQL database directly.

Vprog table field descriptions for the Pas mysql database

• pcode: The project code
• pdate: I don't think we care if this is the input or submission date.
• project: This is an ordering of the sessions (not just an internal priority) for each session in the project. "a" comes before "b".
• bands: The receiver bands required. A session may require multiple receivers. In this case the receiver designations are concatenated togther. An example of this would be "KU", specifying that the K and Ku receivers are required. Most of the band designations are self explanatory except for the 2 listed below:
  • U = Ku band
  • 8 = ?
• backends: The backend(s) required for the session. The designations are the same ones used in the resource page. TBD list them here
• mult: The number of times this session should be run.
• daysep: The required days between when each of the instances of this session should be run. This is only valid if the "mult" field is greater than 1. For example if mult=2 and daysep=2, then there must be 2 days between each scheduled instance of this session. Sometimes this is an exact number, sometimes not.
• hours: The hours to be observed in an instance of this session . Units are in Radians
• lst: The center LST for this session.
• leeway: The amount of play in the lst field. The edges of the session must remain in the bounds of the leeway and LST, e.g., lst = 4, leeway = 3, and hours = 2 implies a session could be as early as 1 to 3 or as late as 5 to 7. The units are radiams.
• dayreq: Fixed time (or fixed window, since the session may be able to run in different telescope period for the given day?)
• delay: The required days between different sessions (not instances of sessions). Sometimes this is an exact number, sometimes not. This is only valid for Projects with more than 1 session. The order of the session is specified in the project field.
• delayafterkey: ?
• outermult: Repeats the seesion AND the mult this many times. So if a session has mult=2 and a outermult = 3. The session would run 2 times with the session parameters and then this would be repeated 3 times with the outer* parameters (listed below).
• outerdaysep: The required days between when each of the Outer repeats (see outermult above) of this session. This is only valid if the "outermult" field is greater than 1. I am not sure if this is a minimum, maximum or exact value. I suspect minimum TBD ask
• dyncode: designates how this session should be scheduled. L = low frequency, F = Fixed, P = ?, H = high frequency, S= schedule per the band of the receiver required. Currently anything X band or higher is scheduled as high frequency.
• schedularnote: This seems to contain what the dynamic scheduling team calls "time between".

DBase Table Documentation

• DBaseDoc.vsd: Contains table diagrams.

-- MikeMcCarty - 02 Nov 2006

Attachment:	Action:	Size:	Date:	Who:	Comment:
TableDoc.txt	action	85369	17 Oct 2006 - 17:44	MikeMcCarty
propmysql.sql	action	91042	17 Oct 2006 - 17:45	MikeMcCarty
DBaseDoc.vsd	action	320512	24 Oct 2006 - 18:38	MikeMcCarty