photglobal
|
Contains global constants, control variables, and a time stamp.
|
photversions
|
Contains version strings and identifiers in recognition of continuing development of the photometry pipeline. The versions are used to recognize and purge stale data from the other tables.
|
photseries
|
Contains a copy of the series table index from the scanner database for more efficient MySQL queries
|
stars
|
Contains the star index based on either location or GSC2.3.2 reference ID and the GSC2.3.2 magnitude and color.
|
stars1
|
Contains the star index based on either location or Kepler Input Catalog reference ID and the Kepler Input Catalog magnitude and color.
|
stars2
|
Contains the star index based on either location or APASS Catalog reference ID and APASS magnitude and color.
|
photplates
|
Contains a list of all plates processed by the photometry pipeline and global plate parameters, such as the plate scale, mosaic size, and Sextractor THRESHOLD level.
|
spatialbin
|
Contains derived parameters for the nine annular bins for each plate analyzed. These parameters include number of stars analyzed, limiting magnitude, upper limits, colorterm values, and bin rms.
|
localbin
|
Contains derived parameters for the 50x50 grid of local correction bins for each plate analyzed. These parameters include altitude in the sky; plate extinction; local calibration correction, number of stars, and correction rms value; and astrometry error measurements.
|
magnitudes
|
Contains values for each image on the plates. These values include GSC2.3.2 reference ID, plate coordinates, processing flags, magnitude, magnitude error, Heliocentric Julian date, and Sextractor shape parameters. This table is too large for efficient processing by MySQL and now consists of a series of binary files indexed by the gsc_bin_index.
|
starsummary
|
Contains lightcurve statistics such as the number of points, DASCH magnitude and rms, clipped DASCH magnitude and rms, year range, and magnitude ranges. These statistics provide the basis for a search for interesting variable stars.
|
starsummary1
|
Contains statistics of stars in the stars1 table processed with the Kepler Input Catalog instead of the GSC2.3.2 catalog
|
starsummary2
|
Contains statistics of stars in the stars1 table processed with the APASS catalog instead of the GSC2.3.2 catalog
|
calibration
|
Contains the relationship between SExtractor instrumental magnitude and GSC2.3.2 catalog magnitude for each plate and annular bin and the estimated RMS error for this relationship.
|
calibration1
|
Contains the relationship between SExtractor instrumental magnitude and Kepler Input Catalog magnitude for each plate and annular bin and the estimated RMS error for this relationship.
|
calibration2
|
Contains the relationship between SExtractor instrumental magnitude and APASS Catalog magnitude for each plate and annular bin and the estimated RMS error for this relationship.
|