Versions Compared

Old Version 6

changes.mady.by.user Cathy Petry

Saved on

compared with

New Version Current

changes.mady.by.user Cathy Petry

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Following table shows the columns of the Field table. This table stores the entire visible sky as field centers. The values of fields are pre-calculated and stored in this table during the installation of the Opsim. For a different tesellation of the sky the user can delete the rows are insert a new set of fields to visit for their simulation. ::

	+----------+------------------+------+-----+---------+----------------+
	| Field    | Type             | Null | Key | Default | Extra          |
	+----------+------------------+------+-----+---------+----------------+
	| fieldID  | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
	| fieldFov | double           | NO   | MUL | NULL    |                |
	| fieldRA  | double           | NO   |     | NULL    |                |
	| fieldDec | double           | NO   |     | NULL    |                |
	| fieldGL  | double           | NO   |     | NULL    |                |
	| fieldGB  | double           | NO   |     | NULL    |                |
	| fieldEL  | double           | NO   |     | NULL    |                |
	| fieldEB  | double           | NO   |     | NULL    |                |
	+----------+------------------+------+-----+---------+----------------+

Output Tables

...

Config

This is the new description,

Following table shows the columns of the SessionConfig table. This istable thekeeps driver tabletrack of anthe OpSimvarious run.parameters Aused newto table entry is created for every OpSim run and is stored in this table. All output tables have a foreign key relationship with this table and output data is identified primarily using the sessionID column of this tabledrive the OpSim. Configuration file parameters are kept in this table. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field             | Type             | Null | Key | Default | Extra          |
	+-------------------+------------------+------+-----+---------+----------------+
	| sessionID configID          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
	| sessionUser moduleName        | varchar(8064)      | NO   | MUL    | NULL    |                |
	| sessionHostparamIndex        | varcharint(8011)          | NO   |     | NULL    |                |
	| paramName     sessionDate | datetime  | varchar(64)      | NO   |     | NULL    |                |
	| versionparamValue        | varchar(2064)      | YESNO   |     | NULL    |                |
	| runComment comment           | varchar(200512)     | YES  |     | NULL    |                |
	+-------------+------------------+------+-----| Session_sessionID | int(10) unsigned | NO   | MUL | NULL    |                |
	| nonPropID         | int(10)          | YES  |     | NULL    |                |
	+-------------------+------------------+------+-----+---------+----------------+

Config_File

This is the new description,

Following table shows the columns of the Config_File table. This table keeps trackthe ofraw data of the variousconfiguration parametersfiles used to drive the OpSim. Configuration file parameters are kept in this table. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field             | Type             | Null | Key | Default | Extra          |
	+-------------------+------------------+------+-----+---------+----------------+
	| config_fileID   configID  | int(11)       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
	| filename  moduleName        | varchar(6445)      | NO   |     | NULL    |                |
	| paramIndexdata              | int(11) blob             | NO   |     | NULL    |                |
	| paramName         Session_sessionID | varcharint(6410) unsigned     | NO   |    MUL | NULL    |                |
	| paramValue        | varchar(64)      | NO   |     | NULL    |                |
	| comment           | varchar(512)     | YES  |+-------------------+------------------+------+-----+---------+----------------+

Log

This is the new description,

Following table shows the columns of the Log table. This table keeps the code level log statements. These log entries are used to find errors, warnings and used for debugging purposes. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field             | NULLType    |         |     Null  |
	| Session_sessionID Key | int(10) unsignedDefault | NOExtra   | MUL | NULL    |                |
	| nonPropID         | int(10)          | YES  |     | NULL    |                |
	+--
	+--------------------+------------------+------+-----+---------+----------------+

Proposal

This is the new description,

Following table shows the columns of the Proposal table. This table keeps track of the various proposals that were used to drive the OpSim. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field
	| logID             | int(10)          | NO   | PRI | NULL    | auto_increment |
	| log_name          | varchar(64)  | Type   | NO   |     | |NULL Null | Key | Default | Extra          |
	   |
	| log_value         | varchar(512)     | NO   |     | NULL    |                |
	| Session_sessionID | int(10) unsigned | NO   | MUL | NULL    |                |
	+-------------------+------------------+------+-----+---------+----------------+
	| propID            | int(10) unsigned

Missed History

This is the new description,

Following table shows the columns of the MissedHistory table. This table keeps track of the Missed Observations for an OpSim run and for a field. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field         | NO   | PRI | NULL    | auto_increment |
	| propConf          | varchar(255)     | NO   |     | NULL    |                |
	| propName          | varchar(80)      | NO   |     | NULLType    |         | Null |  Key   |
	| objectID         Default | bigint(20) Extra      | NO   |     | NULL
	+-------------------+------------------+------+-----+---------+----------------+
	| missedHistID      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
	| objectHostSession_sessionID | int(10) unsigned | NO   | varchar(80)PRI | NULL    | NO   |     | NULL    |   |
	| filter            |
	| Session_sessionID | int(10) unsigned varchar(8)       | NO   | MUL | NULL    |                |
	+-------------------+------------------+------+-----+---------+----------------+

Config_File

This is the new description,

Following table shows the columns of the Config_File table. This table keeps the raw data of the configuration files used to drive the OpSim. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field    | expDate           | int(10) unsigned | NO   |     | NULL    |         | Type      |
	| expMJD      | Null | Key | Default | double Extra          |
	+-------------------+------------------+------+-----+---------+----------------+
	| config_fileID  NO   |     | int(11)NULL     |     | NO   | PRI | NULL    | auto_increment |
	| night   filename          | varcharint(4510)     unsigned | NO   |     | NULL    |                |
	| lst data              | blob  double           | NO   |     | NULL    |                |
	| SessionField_sessionIDfieldID  |   | int(10) unsigned | NO   | MUL | NULL    |                |
	+-------------------+------------------+------+-----+---------+----------------+

...

ObsHistory

This is the new description,

Following table shows the columns of the LogObsHistory table. This table keeps thetrack codeof levelthe logObservations statements.that Thesewere logtaken entriesby arethe usedtelescope tofor findan errors,OpSim warningsrun and used for debugging purposesfield. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field             | Type             | Null | Key | Default | Extra          |
	+-------------------+------------------+------+-----+---------+----------------+
	| logIDobsHistID             | int(10) unsigned | NO   |   PRI | NO NULL  | PRI | NULL    | auto_increment |
	| logSession_namesessionID | int(10) unsigned | NO   | PRI | NULL varchar(64)   |   | NO   |
	| filter    | NULL    |   | varchar(8)       | NO   | MUL | NULL    |       |
	| expDate  log_value         | varcharint(51210) unsigned | NO   |     | NO NULL    |       |
	| expMJD            | NULL  double           | NO   |     | NULL    |       |
	| Session_sessionIDnight             | int(10) unsigned | NO   | MUL    | NULL    |       |
	| visitTime         |
	+-------------------+------------------+------+-----+---------+----------------+

Missed History

This is the new description,

Following table shows the columns of the MissedHistory table. This table keeps track of the Missed Observations for an OpSim run and for a field. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field             | Type   double           | NO   |     | NULL    |       |
	| visitExpTime      | double           | NO   |     | NULL    |       |
	| finRank           | Null double           | KeyNO | Default | Extra     | NULL    |
	+-------------------+------------------+------+-----+---------+----------------+
	| missedHistID       |
	| |finSeeing int(10) unsigned | NO   | PRI | NULLdouble    | auto_increment |
	| Session_sessionID | int(10) unsigned | NO   |    PRI | NULL    |       |
	| transparency      | double |
	| filter            | varchar(8)   NO    | NO   | MUL | NULL    |       |
	| airmass        |
	| expDate  | double        | int(10) unsigned | NO   |     | NULL    |                |
	| expMJDvSkyBright            | double           | NO   |     | NULL    |                |
	| nightfiltSkyBright     | double       |  int(10) unsigned | NO   |     | NULL    |       |
	| rotSkyPos         |
	| lstdouble           | NO   |  double   | NULL    |   | NO   |
	| lst     |  NULL    |    | double           |
	| Field_fieldIDNO   |  | int(10) unsigned | NULL NO   | MUL | NULL    |
	| alt               |
	+-------------------+------------------+------+-----+---------+----------------+

ObsHistory

This is the new description,

Following table shows the columns of the ObsHistory table. This table keeps track of the Observations that were taken by the telescope for an OpSim run and field. ::

	+-------------------+------------------+------+-----+---------+-------+
	| Field double           | NO   |     | NULL    |       |
	| az                | Typedouble           | NO   |    Null | NULL   Key | Default    | Extra |
	+-------------------+------------------+------+-----+---------+-------+
	| obsHistID| dist2Moon         | double           | NO int(10) unsigned | NO   | PRI | NULL    |       |
	| Session_sessionID | int(10) unsignedsolarElong        | double           | NO   |    PRI | NULL    |       |
	| filtermoonRA            | varchar(8) double           | NO   |    MUL | NULL    |       |
	| expDatemoonDec           | int(10)double unsigned | NO   |     | NO   |     | NULL    |       |
	| expMJD moonAlt           | double           | NO   |     | NULL    |       |
	| night moonAZ            | double        | int(10) unsigned | NO   |     | NULL    |       |
	| visitTimemoonPhase         | double           | NO   |     | NULL    |       |
	| visitExpTimesunAlt            | double           | NO   |     | NULL    |       |
	| sunAZ  finRank           | double           | NO   |     | NULL    |       |
	| finSeeingphaseAngle         | double           | NO   |     | NULL    |       |
	| transparencyrScatter          | double           | NO   |     | NULL    |       |
	| airmass   mieScatter        | double           | NO   |     | NULL    |       |
	| moonIllum vSkyBright        | double           | NO   |     | NULL    |       |
	| moonBright filtSkyBright       | double           | NO   |     | NULL    |       |
	| rotSkyPosdarkBright         | double           | NO   |     | NULL    |       |
	| lstrawSeeing               | double           | NO   |     | NULL    |       |
	| altwind               | double           | NO   |     | NULL    |       |
	| az      humidity          | double           | NO   |     | NULL    |       |
	| dist2Moon   Field_fieldID      | double          int(10) unsigned | NO   |    MUL | NULL    |       |
	| solarElong        | double           | NO   |     | NULL    |       |
	| moonRA+-------------------+------------------+------+-----+---------+-------+

ObsHistory_Proposal

This is the new description,

Following table shows the columns of the ObsHistory_Proposal table. This is a many-to-many relationship table that keeps track of which observations fulfilled which proposals and vice-versa for an OpSim run. ::

	+------------------------------+------------------+------+-----+---------+----------------+
	| Field            | double           | NOType   |     | NULL    | Null |     |
	| moonDec          Key | Default | doubleExtra           | NO   |     | NULL    ||
	+------------------------------+------------------+------+-----+---------+----------------+
	| obsHistory_propID            |
	| moonAlt int(10)          | doubleNO   | PRI |  NULL    | NO   auto_increment |
	| Proposal_propID    | NULL    |       |
	| moonAZint(10) unsigned | NO    |     | doubleNULL    |       | NO   |     |
	| NULLpropRank    |       |
	| moonPhase         | double           | NO   |     | NULL    |       |
	| sunAlt        |
	| ObsHistory_obsHistID   | double     |     int(10) unsigned | NO   | MUL    | NULL    |       |
	| sunAZ        |
	|     | double           ObsHistory_Session_sessionID | int(10) unsigned | NO   |     | NULL    |       |
	| phaseAngle        |
	+------------------------------+------------------+------+-----+---------+----------------+

Proposal

This is the new description,

Following table shows the columns of the Proposal table. This table keeps track of the various proposals that were used to drive the OpSim. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field double           | NO   |     | NULL    |       |
	| rScatter          | double      | Type    | NO   |     | NULL  Null  |       |
	| mieScatter       Key | Default | double Extra          | NO   |
	+-------------------+------------------+------+-----+---------+----------------+
	| propID       | NULL    | int(10) unsigned | NO   |
	| moonIllum PRI | NULL    | auto_increment |
	| propConf    | double     | varchar(255)     | NO   |     | NULL    |       |
	| moonBright        |
	| double propName          | NO varchar(80)  |     | NULL NO   |       |
	| darkBright   NULL      | double           | NO   |     
	| NULL objectID   |       |
	| rawSeeing bigint(20)        | doubleNO   |     |  NULL | NO   |     | NULL    |       |
	| wind      objectHost        | doublevarchar(80)           | NO   |     | NULL    |       |
	| humidity          | double           | NO   |     | NULL    |       |
	| Field_fieldID    Session_sessionID | int(10) unsigned | NO   | MUL | NULL    |        |        |
	+-------------------+------------------+------+-----+---------+----------------+

...

Proposal_

...

Field

This is the new description,

Following table shows the columns of the ObsHistoryProposal_ProposalField table. This is a many-to-many relationship table that keeps track of which fields were observationsrequested fulfilledfor which proposals and vice-versa for an OpSim run. ::

	+------------------------------+------------------+------+-----+---------+----------------+
	| Field                        | Type             | Null | Key | Default | Extra          |
	+------------------------------+------------------+------+-----+---------+----------------+
	| obsHistory_propID            proposal_field_id | int(10)          | NO   | PRI | NULL    | auto_increment |
	| Proposal_propID              Session_sessionID | int(10) unsigned | NO   |    MUL | NULL    |                |
	| propRankProposal_propID   | int(10) unsigned | NO   | MUL | NULL    |    | double           | NO   |     | NULL    |                |

	| ObsHistoryField_obsHistIDfieldID         | int(10) unsigned | NO   | MUL | NULL    |                |
	| ObsHistory_Session_sessionID | int(10) unsigned | NO   |     | NULL    |                |
	+------------------------------+------------------+------+-----+---------+----------------+

...

SeqHistory

This is the new description,

Following table shows the columns of the Proposal_FieldSeqHistory table. This istable a many-to-many relationship table that keeps trackkeeps track of the heirarchical information of whichthe fieldsvarious weresequences requested for which proposals a proposal, for a field for an OpSim run. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field             | Type             | Null | Key | Default | Extra          |
	+-------------------+------------------+------+-----+---------+----------------+
	| proposal_field_id | int(10)sequenceID        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
	| Session_sessionID startDate         | int(10) unsigned | NO   |    MUL | NULL    |                |
	| Proposal_propID expDate           | int(10) unsigned | NO   |   MUL  | NULL    |                |
	| Field_fieldID seqnNum           | int(10) unsigned | NO   |    MUL | NULL    |                |
	+-------------------+------------------+------+-----+---------+----------------+

SeqHistory

This is the new description,

Following table shows the columns of the SeqHistory table. This table keeps track of the heirarchical information of the various sequences requested for a proposal, for a field for an OpSim run. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field             | Type| completion        | double           | NO   |     | NULL    |                |
	| reqEvents         | int(10) unsigned | NO   |     | NULL    |                | Null | Key | Default | Extra 
	| actualEvents      | int(10) unsigned | NO   |     | NULL    |     |
	+-------------------+------------------+------+-----+---------+----------------+
	| sequenceID        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
	| startDateendStatus         | int(10) unsigned | NO   |     | NULL    |                |
	| expDateparent_sequenceID    | int(10)       | int(10) unsigned | NO   |     | NULL    |                |
	| seqnNumField_fieldID           | int(10) unsigned | NO   |    MUL | NULL    |                |
	| completion    Session_sessionID | int(10) unsigned | NO   | MUL | NULL    | double               | NO   |
	| Proposal_propID   | int(10) unsigned | NO   | MUL | NULL    |                 |
	| reqEvents|
	+-------------------+------------------+------+-----+---------+----------------+

SeqHistory_MissedHistory

This is the new description,

Following table shows the columns of the SeqHistory_MissedHistory table. This is a many-to-many relationship table that keeps track of which observations were missed for a sequence and for an OpSim run. ::

	+---------------------------------+------------------+------+-----+---------+----------------+
	| Field          | int(10) unsigned | NO   |     | NULL    | Type             | Null |
	| actualEvents     Key | int(10) unsigned Default | NOExtra   |     | NULL    |                |
	| endStatus|
	+---------------------------------+------------------+------+-----+---------+----------------+
	| seqhistory_missedHistID         | int(10) unsigned | NO   |     | NULLNO    | PRI | NULL             | auto_increment |
	| parentSeqHistory_sequenceID  | int(10)        | int(10) unsigned | NO   | MUL    | NULL    |                |
	| FieldMissedHistory_fieldIDmissedHistID      | int(10) unsigned | NO   | MUL | NULL    |                |
	| MissedHistory_Session_sessionID | int(10) unsigned | NO   | MUL | NULL    |                |
	| Proposal_propID   | int(10) unsigned | NO   | MUL | NULL    |                |
	+---------------------------------+------------------+------+-----+---------+----------------+

SeqHistory_

...

ObsHistory

This is the new description,

Following table shows the columns of the SeqHistory_MissedHistoryObsHistory table. This is a many-to-many relationship table that keeps track of which observations were missedachieved for a sequence and for an OpSim run. ::

	+---------------------------------+------------------+------+-----+---------+----------------+
	| Field                           | Type             | Null | Key | Default | Extra          |
	+---------------------------------+------------------+------+-----+---------+----------------+
	| seqhistory_missedHistIDobsHistID         | int(10)          | NO   | PRI | NULL    | auto_increment |
	| SeqHistory_sequenceID           | int(10) unsigned | NO   | MUL | NULL    |                |
	| MissedHistory_missedHistIDObsHistory_obsHistID         | int(10) unsigned | NO   | MUL | NULL    |                |
	| MissedHistoryObsHistory_Session_sessionID | int(10) unsigned | NO   |     | NULL    |                |
	+---------------------------------+------------------+------+-----+---------+----------------+

...

Session

This is the new description,

Following table shows the columns of the SeqHistory_ObsHistorySession table. This is the driver table of an OpSim run. A new table entry is created for every OpSim run and is stored in this table. All output tables have a many-to-many foreign key relationship with this table thatand keeps trackoutput ofdata observationsis achievedidentified forprimarily ausing sequencethe andsessionID forcolumn anof OpSimthis runtable. ::

	+------------------------------+------------------+------+-----+---------+----------------+
	| Field                        | Type             | Null | Key | Default | Extra          |
	+------------------------------+------------------+------+-----+---------+----------------+
	| seqhistory_obsHistID| sessionID   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
	| sessionUser | varchar(80)      | NO   | MUL | NULL    | int(10)                   |
	| sessionHost | varchar(80)      | NO   | PRI    | NULL    | auto_increment               |
	| SeqHistory_sequenceIDsessionDate | datetime      | int(10) unsigned | NO   | MUL    | NULL    |                |
	| ObsHistory_obsHistIDversion     | varchar(20)      | int(10)YES unsigned | NO   | MUL | NULL    |                |
	| runComment ObsHistory_Session_sessionID | intvarchar(10200)    unsigned | NO YES  |     | NULL    |                |
	+-------------  |
	+-----------------+------------------+------+-----+---------+----------------+

...

SlewActivities

This is the new description,

Following table shows the columns of the TimeHistorySlewActivities table. This table keeps track of the various different time events that occurslew activities for a night for an OpSim runslew. ::

	+--------------------+------------------+------+-----+---------+----------------+
	| Field              | Type             | Null | Key | Default | Extra          |
	+--------------------+------------------+------+-----+---------+----------------+
	| timeHistID        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
	| date              | int(10) unsigned | NO   |	| slewActivityID      | NULL  bigint(20)  | NO   | PRI | NULL        | auto_increment |
	| mjd    activity           | double           varchar(16) | NO   |     | NULL    |                |
	| actDelay night          | double  |  int(10) unsigned | NO   |     | NULL    |                |
	| event      inCriticalPath       | intvarchar(1016) unsigned | NO   |  MUL   | NULL    |                |
	| SessionSlewHistory_sessionIDslewID | intbigint(1020) unsigned | NO   | MUL | NULL    |                |
	+--------------------+------------------+------+-----+---------+----------------+

...

Following table shows the columns of the SlewHistory table. This table is a one-to-one relationship table between the SlewHistory table and the ObsHistory table. It keeps track of the Slew associated with each Observation for an Opsim run. ::

	+------------------------------+------------------+------+-----+---------+----------------+
	| Field                        | Type             | Null | Key | Default | Extra          |
	+------------------------------+------------------+------+-----+---------+----------------+
	| slewID                       | bigint(20)       | NO   | PRI | NULL    | auto_increment |
	| slewCount                    | bigint(20)       | NO   |     | NULL    |                |
	| startDate                    | double           | NO   |     | NULL    |                |
	| endDate                      | double           | NO   |     | NULL    |                |
	| slewTime                     | double           | NO   |     | NULL    |                |
	| slewDist                     | double           | NO   |     | NULL    |                |
	| ObsHistory_obsHistID         | int(10) unsigned | NO   | MUL | NULL    |                |
	| ObsHistory_Session_sessionID | int(10) unsigned | NO   |     | NULL    |                |
	+------------------------------+------------------+------+-----+---------+----------------+

...

SlewMaxSpeeds

This is the new description,

Following table shows the columns of the SlewActivities SlewMaxSpeeds table. This table is a one-to-one relationship table between the SlewHistory table and the SlewMaxSpeeds table. This table keeps track of the various slew activitiesspeeds of the instrument for a slew. ::

	+--------------------+-------------+------+-----+---------+----------------+
	| Field              | Type        | Null | Key | Default | Extra          |
	+--------------------+-------------+------+-----+---------+----------------+
	| slewActivityIDslewMaxSpeedID     | bigint(20)  | NO   | PRI | NULL    | auto_increment |
	| activitydomAltSpd          | double   | varchar(16) | NO   |     | NULL    |                |
	| actDelaydomAzSpd           | double      | NO   |     | NULL    |                |
	| inCriticalPath telAltSpd          | varchar(16)double     | NO   |     | NULL    |                |
	| SlewHistory_slewID | bigint(20) telAzSpd           | double     | NO   | MUL    | NULL    |                |
	+--------------------+-------------+------+-----+---------+----------------+

SlewMaxSpeeds

This is the new description,

Following table shows the columns of the SlewMaxSpeeds table. This table is a one-to-one relationship table between the SlewHistory table and the SlewMaxSpeeds table. This table keeps of the various speeds of the instrument for a slew. ::
| rotSpd             | double     | NO   |     | NULL    |                |
	| SlewHistory_slewID | bigint(20) | NO   | MUL | NULL    |                |
	+--------------------+------------+------+-----+---------+----------------+

SlewState

This is the new description,

Following table shows the columns of the SlewState table. This table keeps track of the initial and the final slew states and the various instrument parameters for a slew. ::

	| Field              | Type       | Null | Key | Default | Extra          |
	+--------------------+-------------+------+-----+---------+----------------+
	| slewMaxSpeedID     | bigint(20) | NO   | PRI | NULL    | auto_increment |
	| domAltSpd | Field         | double     | NOType   |     | NULLNull |  Key | Default | Extra             |
	| domAzSpd           | double     | NO   |     | NULL+--------------------+-------------+------+-----+---------+----------------+
	| slewIniStatID      | bigint(20)  | NO   | PRI | NULL    | auto_increment |
	| telAltSpdslewStateDate          | double      | NO   |     | NULL    |                |
	| tra     telAzSpd           | double      | NO   |     | NULL    |                |
	| tdec  rotSpd             | double      | NO   |     | NULL    |                |
	| SlewHistory_slewIDtracking           | bigintvarchar(2016) | NO   |    MUL | NULL    |                |
	+--------------------+------------+------+-----+---------+----------------+

SlewState

This is the new description,

Following table shows the columns of the SlewState table. This table keeps track of the initial and the final slew states and the various instrument parameters for a slew. ::

	+--------------------+-------------+------+-----+---------+----------------+
	| Field| alt                | double      | NO   |     | NULL    |                |
	| az                 | double Type     | NO   | Null    | KeyNULL    |   Default  | Extra          |
	+--------------------+-------------+------+-----+---------+----------------+
	| slewIniStatID pa                 | bigint(20) double      | NO   |    PRI | NULL    | auto_increment                |
	| slewStateDate domAlt             | double      | NO   |     | NULL    |                |
	| tra  domAz              | double      | NO   |     | NULL    |                |
	| tdec  telAlt             | double      | NO   |     | NULL    |                |
	| telAz   tracking           | varchar(16)double      | NO   |     | NULL    |                |
	| altrotTelPos          | double      | NO   |     | NULL    |                |
	| filter         | double   | varchar(8)  | NO   |     | NULL    |                |
	| azstate                 | doubleint(10)      | NO   |     | NULL    |                |
	| pa | SlewHistory_slewID | bigint(20)  | NO   | MUL | NULL    |                | double      | NO   |     | NULL    |                |
	| domAlt
	+--------------------+-------------+------+-----+---------+----------------+

TimeHistory

This is the new description,

Following table shows the columns of the TimeHistory table. This table keeps track of the various different time events that occur for a night for an OpSim run. ::

	+-------------------+------------------+------+-----+---------+----------------+
	| Field             | doubleType      | NO   |   | Null | NULLKey |  Default |      Extra          |
	| domAz              | double      | NO   |+-------------------+------------------+------+-----+---------+----------------+
	| timeHistID        | NULL   int(10) unsigned | NO   | PRI | NULL        | auto_increment |
	| date telAlt             | doubleint(10) unsigned     | NO   |     | NULL    |                |
	| mjd telAz              | double      | NO   |     | NULL    |                |
	| rotTelPos          | double      | NO   |     | NULL    |                |
	| filternight             | varcharint(810) unsigned | NO   |     | NULL    |                |
	| state event             | int(10)    unsigned | NO   |    MUL | NULL    |                |
	| SlewHistorySession_slewIDsessionID | bigintint(2010) unsigned | NO   | MUL | NULL    |                |
	+-------------------+-----+-------------+------+-----+---------+----------------+