Indices

Table NameIndex TypeKey or Field List
astromDR9 primary keyobjID
AtlasOutline primary keyobjID
AtlasOutline foreign keyPhotoObjAll(objID)
DataConstants primary keyfield, name
DataConstants covering indexvalue
DBColumns primary keytableName, name
DBColumns foreign keyDBObjects(name)
DBObjects primary keyname
DBViewCols primary keyviewName, name
DBViewCols foreign keyDBObjects(name)
Dependency primary keyparent, child
detectionIndex primary keyobjID
detectionIndex foreign keythingIndex(thingID)
detectionIndex covering indexthingID
Diagnostics primary keyname
Field primary keyfieldID
Field covering indexfield, camcol, run, rerun
Field covering indexrun, camcol, field, rerun
FieldProfile primary keyfieldID, bin, band
FieldProfile foreign keyField(fieldID)
FileGroupMap primary keytableName
FileGroupMap foreign keyPartitionMap(fileGroupName)
First primary keyobjID
Frame primary keyfieldID, zoom
Frame foreign keyField(fieldID)
Frame covering indexfield, camcol, run, zoom, rerun
Frame covering indexhtmID, zoom, cx, cy, cz, a, b, c, d, e, f, node, incl
galSpecExtra primary keyspecObjID
galSpecIndx primary keyspecObjID
galSpecInfo primary keyspecObjID
galSpecLine primary keyspecObjID
HalfSpace primary keyconstraintid
HalfSpace foreign keyRegion(regionID)
HalfSpace covering indexregionID, convexID, x, y, z, c
History primary keyid
IndexMap primary keyindexmapid
IndexMap foreign keyDBObjects(name)
Inventory primary keyfilename, name
Inventory foreign keyDBObjects(name)
LoadHistory primary keyloadVersion, tStart
Mask primary keymaskID
Mask covering indexhtmID, ra, dec, cx, cy, cz
MaskedObject primary keyobjid, maskid
MaskedObject foreign keyPhotoObjAll(objID)
MaskedObject foreign keyMask(maskID)
Neighbors primary keyobjID, NeighborObjID
Neighbors foreign keyPhotoObjAll(objID)
PartitionMap primary keyfileGroupName
PhotoObjAll primary keyobjID
PhotoObjAll foreign keyField(fieldID)
PhotoObjAll covering indexmode, cy, cx, cz, htmID, type, flags, ra, dec, u, g, r, i, z
PhotoObjAll covering indexhtmID, cx, cy, cz, type, mode, flags, ra, dec, u, g, r, i, z
PhotoObjAll covering indexhtmID, run, camcol, field, rerun, type, mode, flags, cx, cy, cz, g, r
PhotoObjAll covering indexfield, run, rerun, camcol, type, mode, flags, rowc, colc, ra, dec, u, g, r, i, z
PhotoObjAll covering indexfieldID, objID, ra, dec, r, type, flags
PhotoObjAll covering indexSpecObjID, cx, cy, cz, mode, type, flags, ra, dec, u, g, r, i, z
PhotoObjAll covering indexcx, cy, cz, htmID, mode, type, flags, ra, dec, u, g, r, i, z
PhotoObjAll covering indexrun, mode, type, flags, u, g, r, i, z, Err_u, Err_g, Err_r, Err_i, Err_z
PhotoObjAll covering indexrun, camcol, rerun, type, mode, flags, ra, dec, fieldID, field, u, g, r, i, z
PhotoObjAll covering indexrun, camcol, field, mode, parentID, q_r, q_g, u_r, u_g, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z
PhotoObjAll covering indexrun, camcol, type, mode, cx, cy, cz
PhotoObjAll covering indexra, [dec], type, mode, flags, u, g, r, i, z, psfMag_u, psfMag_g, psfMag_r, psfMag_i, psfMag_z
PhotoObjAll covering indexphototag
PhotoObjAll covering indexparentid, mode, type
PhotoObjDR7 primary keydr8objID
PhotoPrimaryDR7 primary keydr8objID
PhotoProfile primary keyobjID, bin, band
PhotoProfile foreign keyPhotoObjAll(objID)
Photoz primary keyobjID
Photoz foreign keyPhotoObjAll(objID)
PhotozRF primary keyobjID
PhotozRF foreign keyPhotoObjAll(objID)
PhotozRFTemplateCoeff primary keyobjID, templateID
PhotozTemplateCoeff primary keyobjID, templateID
PlateX primary keyplateID
PlateX covering indexhtmID, ra, dec, cx, cy, cz
ProfileDefs primary keybin
ProperMotions primary keyobjID
ProperMotions foreign keyPhotoObjAll(objID)
ProperMotionsDR9 primary keyobjID
PubHistory primary keyname, loadversion
QueryResults primary keyquery, time
RC3 primary keyobjID
RecentQueries primary keyipAddr, lastQueryTime
Region primary keyregionId
RegionArcs primary keyregionId, convexid, arcid
RegionArcs foreign keyRegion(regionID)
RegionPatch primary keyregionid, convexid, patchid
RegionPatch foreign keyRegion(regionID)
RegionPatch covering indexhtmID, ra, dec, x, y, z, type
RMatrix primary keymode, row
Rosat primary keyobjID
RunShift primary keyrun
SDSSConstants primary keyname
sdssImagingHalfspaces primary keysdssPolygonID, x, y, z
sdssPolygon2Field primary keysdssPolygonID, fieldID
sdssPolygons primary keysdssPolygonID
sdssTargetParam primary keytargetVersion, paramFile, name
sdssTileAll primary keytile
sdssTileAll foreign keysdssTilingRun(tileRun)
sdssTileAll covering unique indextileRun, tile
sdssTileAll covering indexhtmID, racen, deccen, cx, cy, cz
sdssTiledTargetAll primary keytargetID
sdssTiledTargetAll covering indexhtmID, ra, dec, cx, cy, cz
sdssTilingGeometry foreign keysdssTilingRun(tileRun)
sdssTilingGeometry foreign keyStripeDefs(stripe)
sdssTilingInfo primary keytileRun, targetID
sdssTilingInfo foreign keysdssTilingRun(tileRun)
sdssTilingInfo covering unique indextargetID, tileRun, collisionGroup
sdssTilingInfo covering unique indextileRun, tid, collisionGroup
sdssTilingInfo covering indextile, collisionGroup
sdssTilingRun primary keytileRun
segueTargetAll primary keyobjID
segueTargetAll covering indexsegue1_target1, segue2_target1
SiteConstants primary keyname
SiteDiagnostics primary keyname
SpecDR7 primary keyspecObjID
SpecObjAll primary keyspecObjID
SpecObjAll foreign keyPlateX(plateID)
SpecObjAll covering indexhtmID, ra, dec, cx, cy, cz, sciencePrimary
SpecObjAll covering indexBestObjID, objType, sciencePrimary, class, htmID, ra, dec
SpecObjAll covering indexclass, zWarning, z, sciencePrimary, plateId, bestObjID, targetObjId, htmID, ra, dec
SpecObjAll covering indextargetObjID, objType, sciencePrimary, class, htmID, ra, dec
SpecObjAll covering indexra, [dec], class, plate, tile, z, zErr, sciencePrimary, plateID, bestObjID
SpecPhotoAll primary keyspecObjID
SpecPhotoAll foreign keySpecObjAll(specObjID)
SpecPhotoAll covering indexobjID, sciencePrimary, class, z, targetObjid
SpecPhotoAll covering indextargetObjID, sciencePrimary, class, z, objid
sppLines primary keyspecObjID
sppParams primary keyspecObjID
StripeDefs primary keystripe
Target primary keytargetID
TargetInfo primary keyskyVersion, targetID
TargetInfo foreign keyTarget(targetID)
thingIndex primary keythingId
thingIndex foreign keysdssPolygons(sdssPolygonID)
thingIndex covering indexobjID
TwoMass primary keyobjID
TwoMassXSC primary keyobjID
USNO primary keyobjID
Versions primary keyversion
Zone primary keyzoneID, ra, objID
Zone foreign keyPhotoObjAll(objID)