/*
MySQL Data Transfer
Source Host: localhost
Source Database: neocp
Target Host: localhost
Target Database: neocp
Date: 11/17/2009 17:50:32
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for ephemerides
-- ----------------------------
DROP TABLE IF EXISTS `ephemerides`;
CREATE TABLE `ephemerides` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'unique internal ID',
  `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'insertion and modification timestamp',
  `designation` varchar(8) DEFAULT NULL COMMENT 'MPC designation or label',
  `year` int(4) DEFAULT NULL COMMENT 'four digit Gregorian calendar year',
  `month` int(2) DEFAULT NULL COMMENT 'Gregorian month',
  `day` int(2) DEFAULT NULL COMMENT 'Gregorian day',
  `hour` float(8,6) unsigned DEFAULT NULL COMMENT 'hour of the day',
  `mjd_datetime` float(13,6) DEFAULT NULL COMMENT 'MJD value of date and time',
  `ra` float(9,6) DEFAULT NULL COMMENT 'rising ascension in degrees',
  `ra_err` float(9,6) DEFAULT NULL COMMENT '+/- uncertainty of RA',
  `dec` float(9,6) DEFAULT NULL COMMENT 'declinaiton in degrees',
  `dec_err` float(9,6) DEFAULT NULL COMMENT '+/- uncertainty of DEC',
  `elong` float(14,6) DEFAULT NULL COMMENT 'elongation',
  `mag_v` float(9,6) DEFAULT NULL COMMENT 'magnitude',
  `mag_v_err` float(9,6) DEFAULT NULL COMMENT '+/- magnitude uncertainty',
  `deg_per_sec` float(12,6) DEFAULT NULL,
  `deg_per_min` float(12,6) DEFAULT NULL,
  `deg_per_day` float(12,6) DEFAULT NULL COMMENT 'velocity that corresponds to MOPS tracklet velocity',
  `velocity_err` float(12,6) DEFAULT NULL COMMENT '+/- uncertainty of velocity',
  `pa` float(9,6) DEFAULT NULL COMMENT 'position angle',
  `pa_err` float(9,6) DEFAULT NULL COMMENT '+/- uncertainty in position angle',
  `azimuth` float(14,6) DEFAULT NULL,
  `altitude` float(14,6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------
