User Tools

Site Tools


code:ga_scheduling

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
code:ga_scheduling [2009/01/16 13:50]
pkubanek
code:ga_scheduling [2009/01/18 11:02]
pkubanek Added description of tickets table
Line 15: Line 15:
 You need to fill **tickets** and **accounts** tables. You need to fill **tickets** and **accounts** tables.
  
-^ Field name ^ Description ^ +**Tickets** table contains those fields: 
-| schedticket_id ​    | integer ​                    ​| ​not null + 
-| tar_id ​            | integer ​                    |  +^ Field name ^ Data type ^ Description ^ 
-| account_id ​        | integer ​                    |  +| schedticket_id ​    | integer ​                    ​| ​unique ID of ticket - primary key  | 
-| obs_num ​           | integer ​                    |  +| tar_id ​            | integer ​                    | ID of target which belongs to the ticket ​
-| sched_from ​        | timestamp without time zone |  +| account_id ​        | integer ​                    | ID of account - can be null if this ticket is out of accounting ​
-| sched_to ​          | timestamp without time zone |  +| obs_num ​           | integer ​                    | Maximal number of observations - scheduler will try to schedule only observations bellow this number ​
-| sched_interval_min | interval ​                   |  +| sched_from ​        | timestamp without time zone | Schedule observation from this time; if null, schedule anytime ​
-| sched_interval_max | interval ​      ​| ​+| sched_to ​          | timestamp without time zone | Schedule observation to this time; if null, schedule anytime ​
 +| sched_interval_min | interval ​                   ​| Minimal interval between observations ​
 +| sched_interval_max | interval ​      | Maximal interval between observations ​|
  
 ===== Using pyrts2 to preview schedules ===== ===== Using pyrts2 to preview schedules =====
code/ga_scheduling.txt · Last modified: 2009/01/18 00:00 (external edit)