|
| Table Name | Index Type | Key or Field List |
| apogeeDesign |
primary key | designid |
| apogeeField |
primary key | location_id |
| apogeeObject |
primary key | target_id |
| apogeeObject |
covering index | apogee_id, j, h, k, j_err, h_err, k_err |
| apogeePlate |
primary key | plate_visit_id |
| apogeeStar |
primary key | apstar_id |
| apogeeStar |
covering index | apogee_id |
| apogeeStar |
covering index | htmID |
| apogeeStarAllVisit |
primary key | visit_id, apstar_id |
| apogeeStarVisit |
primary key | visit_id |
| apogeeVisit |
primary key | visit_id |
| apogeeVisit |
covering index | apogee_id |
| apogeeVisit |
covering index | plate, mjd, fiberid |
| aspcapStar |
primary key | aspcap_id |
| aspcapStar |
covering index | apstar_id |
| aspcapStarCovar |
primary key | aspcap_covar_id, aspcap_id |
| AtlasOutline |
primary key | objID |
| AtlasOutline |
foreign key | PhotoObjAll(objID) |
| cannonStar |
primary key | cannon_id |
| DataConstants |
primary key | field, name |
| DataConstants |
covering index | value |
| DBColumns |
primary key | tableName, name |
| DBColumns |
foreign key | DBObjects(name) |
| DBObjects |
primary key | name |
| DBViewCols |
primary key | viewName, name |
| DBViewCols |
foreign key | DBObjects(name) |
| Dependency |
primary key | parent, child |
| detectionIndex |
primary key | thingId, objID |
| detectionIndex |
foreign key | thingIndex(thingID) |
| detectionIndex |
covering index | thingID |
| Diagnostics |
primary key | name |
| emissionLinesPort |
primary key | specObjID |
| Field |
primary key | fieldID |
| Field |
covering index | field, camcol, run, rerun |
| Field |
covering index | run, camcol, field, rerun |
| FieldProfile |
primary key | fieldID, bin, band |
| FieldProfile |
foreign key | Field(fieldID) |
| FileGroupMap |
primary key | tableName |
| FileGroupMap |
foreign key | PartitionMap(fileGroupName) |
| First |
primary key | objID |
| Frame |
primary key | fieldID, zoom |
| Frame |
foreign key | Field(fieldID) |
| Frame |
covering index | field, camcol, run, zoom, rerun |
| Frame |
covering index | htmID, zoom, cx, cy, cz, a, b, c, d, e, f, node, incl |
| galSpecExtra |
primary key | specObjID |
| galSpecIndx |
primary key | specObjID |
| galSpecInfo |
primary key | specObjID |
| galSpecLine |
primary key | specObjID |
| HalfSpace |
primary key | constraintid |
| HalfSpace |
foreign key | Region(regionID) |
| HalfSpace |
covering index | regionID, convexID, x, y, z, c |
| History |
primary key | id |
| IndexMap |
primary key | indexmapid |
| IndexMap |
foreign key | DBObjects(name) |
| Inventory |
primary key | filename, name |
| Inventory |
foreign key | DBObjects(name) |
| LoadHistory |
primary key | loadVersion, tStart |
| mangaDRPall |
primary key | plateIFU |
| mangaDRPall |
foreign key | mangaTarget(mangaID) |
| mangaFirefly |
primary key | plateIFU |
| mangaPipe3D |
primary key | plateIFU |
| mangaTarget |
primary key | mangaID |
| marvelsStar |
primary key | STARNAME, PLATE |
| marvelsVelocityCurveUF1D |
primary key | STARNAME, BEAM, RADECID, FCJD, [LST-OBS] |
| Mask |
primary key | maskID |
| Mask |
covering index | htmID, ra, dec, cx, cy, cz |
| MaskedObject |
primary key | objid, maskid |
| MaskedObject |
foreign key | PhotoObjAll(objID) |
| MaskedObject |
foreign key | Mask(maskID) |
| Neighbors |
primary key | objID, NeighborObjID |
| Neighbors |
foreign key | PhotoObjAll(objID) |
| nsatlas |
primary key | nsaID |
| PartitionMap |
primary key | fileGroupName |
| PhotoObjAll |
primary key | objID |
| PhotoObjAll |
foreign key | Field(fieldID) |
| PhotoObjAll |
covering index | mode, cy, cx, cz, htmID, type, flags, ra, dec, u, g, r, i, z |
| PhotoObjAll |
covering index | htmID, cx, cy, cz, type, mode, flags, ra, dec, u, g, r, i, z |
| PhotoObjAll |
covering index | htmID, run, camcol, field, rerun, type, mode, flags, cx, cy, cz, g, r |
| PhotoObjAll |
covering index | field, run, rerun, camcol, type, mode, flags, rowc, colc, ra, dec, u, g, r, i, z |
| PhotoObjAll |
covering index | fieldID, objID, ra, dec, r, type, flags |
| PhotoObjAll |
covering index | SpecObjID, cx, cy, cz, mode, type, flags, ra, dec, u, g, r, i, z |
| PhotoObjAll |
covering index | cx, cy, cz, htmID, mode, type, flags, ra, dec, u, g, r, i, z |
| PhotoObjAll |
covering index | run, mode, type, flags, u, g, r, i, z, Err_u, Err_g, Err_r, Err_i, Err_z |
| PhotoObjAll |
covering index | run, camcol, rerun, type, mode, flags, ra, dec, fieldID, field, u, g, r, i, z |
| PhotoObjAll |
covering index | run, camcol, field, mode, parentID, q_r, q_g, u_r, u_g, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z |
| PhotoObjAll |
covering index | run, camcol, type, mode, cx, cy, cz |
| PhotoObjAll |
covering index | ra, [dec], type, mode, flags, u, g, r, i, z, psfMag_u, psfMag_g, psfMag_r, psfMag_i, psfMag_z |
| PhotoObjAll |
covering index | b, l, type, mode, flags, u, g, r, i, z, psfMag_u, psfMag_g, psfMag_r, psfMag_i, psfMag_z |
| PhotoObjAll |
covering index | phototag |
| PhotoObjAll |
covering index | parentid, mode, type |
| PhotoObjDR7 |
primary key | dr8objID |
| PhotoObjDR7 |
covering index | dr7objID |
| PhotoPrimaryDR7 |
primary key | dr8objID |
| PhotoProfile |
primary key | objID, bin, band |
| PhotoProfile |
foreign key | PhotoObjAll(objID) |
| Photoz |
primary key | objID |
| Photoz |
foreign key | PhotoObjAll(objID) |
| PhotozErrorMap |
primary key | cellID |
| plate2Target |
primary key | plate2TargetID, plate, objid |
| PlateX |
primary key | plateID |
| PlateX |
covering index | htmID, ra, dec, cx, cy, cz |
| ProfileDefs |
primary key | bin |
| ProperMotions |
primary key | objID |
| ProperMotions |
foreign key | PhotoObjAll(objID) |
| PubHistory |
primary key | name, loadversion |
| qsoVarPTF |
primary key | VAR_OBJID |
| qsoVarStripe |
primary key | VAR_OBJID |
| QueryResults |
primary key | query, time |
| RC3 |
primary key | objID |
| RecentQueries |
primary key | ipAddr, lastQueryTime |
| Region |
primary key | regionId |
| RegionArcs |
primary key | regionId, convexid, arcid |
| RegionArcs |
foreign key | Region(regionID) |
| RegionPatch |
primary key | regionid, convexid, patchid |
| RegionPatch |
foreign key | Region(regionID) |
| RegionPatch |
covering index | htmID, ra, dec, x, y, z, type |
| RMatrix |
primary key | mode, row |
| Rosat |
primary key | objID |
| RunShift |
primary key | run |
| SDSSConstants |
primary key | name |
| sdssEbossFirefly |
primary key | specObjID |
| sdssImagingHalfspaces |
primary key | sdssPolygonID, x, y, z |
| sdssPolygon2Field |
primary key | sdssPolygonID, fieldID |
| sdssPolygons |
primary key | sdssPolygonID |
| sdssTargetParam |
primary key | targetVersion, paramFile, name |
| sdssTileAll |
primary key | tile |
| sdssTileAll |
foreign key | sdssTilingRun(tileRun) |
| sdssTileAll |
covering unique index | tileRun, tile |
| sdssTileAll |
covering index | htmID, racen, deccen, cx, cy, cz |
| sdssTiledTargetAll |
primary key | targetID |
| sdssTiledTargetAll |
covering index | htmID, ra, dec, cx, cy, cz |
| sdssTilingGeometry |
primary key | tilingGeometryID |
| sdssTilingGeometry |
foreign key | sdssTilingRun(tileRun) |
| sdssTilingInfo |
primary key | tileRun, targetID |
| sdssTilingInfo |
foreign key | sdssTilingRun(tileRun) |
| sdssTilingInfo |
covering unique index | targetID, tileRun, collisionGroup |
| sdssTilingInfo |
covering unique index | tileRun, tid, collisionGroup |
| sdssTilingInfo |
covering index | tile, collisionGroup |
| sdssTilingRun |
primary key | tileRun |
| segueTargetAll |
primary key | objID |
| segueTargetAll |
covering index | segue1_target1, segue2_target1 |
| SiteConstants |
primary key | name |
| SiteDiagnostics |
primary key | name |
| SpecDR7 |
primary key | specObjID |
| SpecObjAll |
primary key | specObjID |
| SpecObjAll |
foreign key | PlateX(plateID) |
| SpecObjAll |
covering index | htmID, ra, dec, cx, cy, cz, sciencePrimary |
| SpecObjAll |
covering index | BestObjID, sourceType, sciencePrimary, class, htmID, ra, dec, plate, mjd, fiberid, z, zErr |
| SpecObjAll |
covering index | class, zWarning, z, sciencePrimary, plateId, bestObjID, targetObjId, htmID, ra, dec |
| SpecObjAll |
covering index | targetObjID, sourceType, sciencePrimary, class, htmID, ra, dec |
| SpecObjAll |
covering index | ra, [dec], class, plate, tile, z, zErr, sciencePrimary, plateID, bestObjID |
| SpecObjAll |
covering index | fluxObjID |
| SpecPhotoAll |
primary key | specObjID |
| SpecPhotoAll |
foreign key | SpecObjAll(specObjID) |
| SpecPhotoAll |
covering index | objID, sciencePrimary, class, z, targetObjid |
| SpecPhotoAll |
covering index | targetObjID, sciencePrimary, class, z, objid |
| spiders_quasar |
primary key | name |
| sppLines |
primary key | specObjID |
| sppParams |
primary key | specObjID |
| sppTargets |
primary key | TARGETID |
| stellarMassFSPSGranEarlyDust |
primary key | specObjID |
| stellarMassFSPSGranEarlyNoDust |
primary key | specObjID |
| stellarMassFSPSGranWideDust |
primary key | specObjID |
| stellarMassFSPSGranWideNoDust |
primary key | specObjID |
| stellarMassPassivePort |
primary key | specObjID |
| stellarMassPCAWiscBC03 |
primary key | specObjID |
| stellarMassPCAWiscM11 |
primary key | specObjID |
| stellarMassStarformingPort |
primary key | specObjID |
| StripeDefs |
primary key | stripe |
| Target |
primary key | targetID |
| TargetInfo |
primary key | skyVersion, targetID |
| TargetInfo |
foreign key | Target(targetID) |
| thingIndex |
primary key | thingId |
| thingIndex |
foreign key | sdssPolygons(sdssPolygonID) |
| thingIndex |
covering index | objID |
| TwoMass |
primary key | objID |
| TwoMass |
covering index | ra |
| TwoMass |
covering index | dec |
| TwoMass |
covering index | j |
| TwoMass |
covering index | h |
| TwoMass |
covering index | k |
| TwoMass |
covering index | ccflag |
| TwoMass |
covering index | phqual |
| TwoMassXSC |
primary key | objID |
| USNO |
primary key | objID |
| Versions |
primary key | version |
| WISE_allsky |
primary key | cntr |
| WISE_allsky |
covering index | w1mpro |
| WISE_allsky |
covering index | w2mpro |
| WISE_allsky |
covering index | w3mpro |
| WISE_allsky |
covering index | w4mpro |
| WISE_allsky |
covering index | n_2mass |
| WISE_allsky |
covering index | tmass_key |
| WISE_allsky |
covering index | ra, dec |
| WISE_allsky |
covering index | glat, glon |
| WISE_allsky |
covering index | j_m_2mass |
| WISE_allsky |
covering index | h_m_2mass |
| WISE_allsky |
covering index | k_m_2mass |
| WISE_allsky |
covering index | w1rsemi |
| WISE_allsky |
covering index | blend_ext_flags |
| WISE_allsky |
covering index | w1cc_map |
| WISE_allsky |
covering index | w2cc_map |
| WISE_allsky |
covering index | w3cc_map |
| WISE_allsky |
covering index | w4cc_map |
| WISE_allsky |
covering index | rjce |
| WISE_xmatch |
primary key | sdss_objID, wise_cntr |
| WISE_xmatch |
covering index | wise_cntr |
| wiseForcedTarget |
primary key | objID |
| wiseForcedTarget |
covering index | ra, dec, has_wise_phot, treated_as_pointsource |
| Zone |
primary key | zoneID, ra, objID |
| Zone |
foreign key | PhotoObjAll(objID) |
| zoo2MainPhotoz |
primary key | dr7objid |
| zoo2MainSpecz |
primary key | dr7objid |
| zoo2MainSpecz |
foreign key | PhotoObjAll(objid) |
| zoo2Stripe82Coadd1 |
primary key | stripe82objid |
| zoo2Stripe82Coadd1 |
foreign key | PhotoObjAll(objid) |
| zoo2Stripe82Coadd2 |
primary key | stripe82objid |
| zoo2Stripe82Coadd2 |
foreign key | PhotoObjAll(objid) |
| zoo2Stripe82Normal |
primary key | dr7objid |
| zoo2Stripe82Normal |
foreign key | PhotoObjAll(objid) |
| zooConfidence |
primary key | specObjID |
| zooConfidence |
covering index | objID |
| zooMirrorBias |
primary key | dr7objid |
| zooMirrorBias |
covering index | objID |
| zooMonochromeBias |
primary key | dr7objid |
| zooMonochromeBias |
covering index | objID |
| zooNoSpec |
primary key | dr7objid |
| zooNoSpec |
covering index | objID |
| zooSpec |
primary key | specObjID |
| zooSpec |
covering index | objID |
| zooVotes |
primary key | dr7objid |
| zooVotes |
covering index | objID |
|
