CAT contains several catalogs each stored in a separate table in the database. The database currently contains the following catalogs:
- FK6
- TYCHO
- GWAVES (a composite catalog of UCAC2 & UCAC3 limited to declinations observable at DCT)
- UCAC2
- UCAC3
Each catalog contains the following minimum set of information:
...
Column Name | Description |
|---|---|
ID | integer indicating the order in the original query |
Name | if catalog does not contain name, it will be a unique construct depending on the catalog |
Right Ascension |
|
Declination |
|
Epoch |
|
Proper Motion in RA*cos(dec) |
...
mas/yr | |
Proper Motion in Declincation | mas/yr |
Magnitude |
|
Distance | arcsec (from the center for the original query) |
FK6
| Code Block | ||||
|---|---|---|---|---|
| ||||
DROP TABLE IF EXISTS `fk6`;
CREATE TABLE `fk6` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`FK6` int(11) DEFAULT NULL,
`HIP` int(11) DEFAULT NULL,
`Flag` varchar(2) DEFAULT NULL,
`Name` varchar(19) DEFAULT NULL,
`Right_Ascension` double DEFAULT NULL,
`Declination` double DEFAULT NULL,
`pmRA` double DEFAULT NULL,
`pmDE` double DEFAULT NULL,
`TRA` double DEFAULT NULL,
`e_RA` double DEFAULT NULL,
`e_pmRA` double DEFAULT NULL,
`TDE` double DEFAULT NULL,
`e_DE` double DEFAULT NULL,
`e_pmDE` double DEFAULT NULL,
`plx` double DEFAULT NULL,
`e_plx` double DEFAULT NULL,
`f_plx` char(1) DEFAULT NULL,
`RV` double DEFAULT NULL,
`Vmag` float DEFAULT NULL,
`f_Vmag` float DEFAULT NULL,
`Kbin1` int(11) DEFAULT NULL,
`Kbin2` int(11) DEFAULT NULL,
`Kae` int(11) DEFAULT NULL,
`lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4151 DEFAULT CHARSET=latin1;
|
TYCHO
| Code Block | ||||
|---|---|---|---|---|
| ||||
DROP TABLE IF EXISTS `tycho`;
CREATE TABLE `tycho` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`Name` char(16) DEFAULT NULL,
`Right_Ascension` double DEFAULT NULL,
`Declination` double DEFAULT NULL,
`pmRA` double DEFAULT NULL,
`pmDE` double DEFAULT NULL,
`BTmag` float DEFAULT NULL,
`VTmag` float DEFAULT NULL,
`epoch` double DEFAULT NULL,
`lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `starIndex` (`Declination`,`Right_Ascension`)
) ENGINE=MyISAM AUTO_INCREMENT=2448057 DEFAULT CHARSET=latin1;
|
GWAVES
| Code Block | ||||
|---|---|---|---|---|
| ||||
UCAC2
| Code Block | ||||
|---|---|---|---|---|
| ||||
UCAC3
| Code Block | ||||
|---|---|---|---|---|
| ||||
DROP TABLE IF EXISTS `gwaves`;
CREATE TABLE `gwaves` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`Right_Ascension` double NOT NULL,
`Declination` double NOT NULL,
`Magnitude` float NOT NULL,
`EpRAm` double NOT NULL,
`EpDEm` double NOT NULL,
`Proper_Motion_RA` double NOT NULL,
`Proper_Motion_Dec` double NOT NULL,
`M_J` float NOT NULL,
`M_H` float NOT NULL,
`M_Ks` float NOT NULL,
`lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `starIndex` (`Declination`,`Right_Ascension`,`Magnitude`)
) ENGINE=MyISAM AUTO_INCREMENT=49054904 DEFAULT CHARSET=latin1;
|