Indices
DR4 Help
 Archive Intro
 Table Descriptions
 Schema Browser
 Glossary
 Algorithms
 Introduction to SQL
 Sample SQL Queries
 Query Limits
 How To
 FAQ
 API
 Download
 SkyServer Sites
 SkyServer Traffic Page
 Web Browsers
 Site News
 Contact Help Desk

Table NameIndex TypeKey or Field List
Algorithm primary key[key]
BestTarget2Sector primary keyobjid, regionID
BestTarget2Sector foreign keyPhotoObjAll(objID)
BestTarget2Sector foreign keySector(regionID)
BestTarget2Sector covering unique indexregionID, objid
Chunk primary keychunkID
Chunk foreign keyStripeDefs(stripe)
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
Diagnostics primary keyname
ELRedShift primary keyelRedShiftID
ELRedshift foreign keySpecObjAll(specObjID)
ELRedShift covering unique indexspecObjID, elRedShiftID
Field primary keyfieldID
Field foreign keySegment(segmentID)
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
First foreign keyPhotoObjAll(objID)
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
Glossary primary key[key]
HalfSpace primary keyconstraintid
HalfSpace foreign keyRegion(regionID)
HalfSpace covering indexregionID, convexID, x, y, z, c
History primary keyid
HoleObj primary keyHoleID
HoleObj foreign keyPlateX(plateID)
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)
Match primary keyobjID1, objID2
Match foreign keyPhotoObjAll(objID)
Match foreign keyMatchHead(objid)
Match covering indexmatchHead
MatchHead primary keyobjID
MatchHead foreign keyPhotoObjAll(objID)
Neighbors primary keyobjID, NeighborObjID
Neighbors foreign keyPhotoObjAll(objID)
ObjMask primary keyobjID
ObjMask foreign keyPhotoObjAll(objID)
PartitionMap primary keyfileGroupName
PhotoAuxAll primary keyobjID
PhotoAuxAll foreign keyPhotoObjAll(objID)
PhotoAuxAll covering indexmode, l, b, raErr, decErr, raDecCorr
PhotoAuxAll covering indexl, b, objID, mode
PhotoAuxAll covering indexb, l, objID, mode
PhotoObjAll primary keyobjID
PhotoObjAll foreign keyField(fieldID)
PhotoObjAll covering indexmode, cy, cx, cz, htmID, type, flags, status, ra, dec, u, g, r, i, z, rho
PhotoObjAll covering indexhtmID, cx, cy, cz, type, mode, flags, status, ra, dec, u, g, r, i, z, rho
PhotoObjAll covering indexhtmID, run, camcol, field, rerun, type, mode, flags, status, cx, cy, cz, g, r, rho
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, status, flags
PhotoObjAll covering indexSpecObjID, cx, cy, cz, mode, type, flags, status, ra, dec, u, g, r, i, z, rho
PhotoObjAll covering indexcx, cy, cz, htmID, mode, type, flags, status, ra, dec, u, g, r, i, z, rho
PhotoObjAll covering indexrun, mode, type, status, flags, u, g, r, i, z, Err_u, Err_g, Err_r, Err_i, Err_z
PhotoObjAll covering indexrun, camcol, rerun, type, mode, status, 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, isoA_r, isoB_r, 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, primTarget
PhotoProfile primary keyobjID, bin, band
PhotoProfile foreign keyPhotoObjAll(objID)
PhotoTag primary keyobjID
PhotoTag foreign keyPhotoObjAll(objID)
PhotoTag foreign keyField(fieldID)
PhotoTag covering indexmode, cy, cx, cz, htmID, type, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size]
PhotoTag covering indexhtmID, cx, cy, cz, type, mode, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size]
PhotoTag covering indexfield, run, rerun, camcol, type, mode, flags, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z
PhotoTag covering indexfieldID, objID, ra, [dec], modelMag_r, type, status, flags
PhotoTag covering indexSpecObjID, cx, cy, cz, mode, type, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size]
PhotoTag covering indexcx, cy, cz, htmID, mode, type, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size]
PhotoTag covering indexrun, mode, type, status, flags, modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, modelMagErr_u, modelMagErr_g, modelMagErr_r, modelMagErr_i, modelMagErr_z
PhotoTag covering indexrun, camcol, field, rerun, type, mode, status, flags, ra, [dec], fieldID, modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z
PhotoTag covering indexra, [dec], type, mode, flags, modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, psfMag_u, psfMag_g, psfMag_r, psfMag_i, psfMag_z, primTarget
Photoz primary keyobjID, rank, pId
Photoz foreign keyPhotoObjAll(objID)
PlateX primary keyplateID
PlateX foreign keyTileAll(tile)
PlateX covering indexhtmID, ra, dec, cx, cy, cz
ProfileDefs primary keybin
PubHistory primary keyname, loadversion
QsoCatalogAll primary keyzone, ra, SpecObjID, bestObjID, targetObjID
QsoConcordance primary keyzone, ra, dec, specObjID, bestObjID, targetObjID
QuasarCatalog primary keySpecObjID
QuasarCatalog foreign keySpecObjAll(specObjID)
QueryResults primary keyquery, time
RC3 primary keyobjID
RecentQueries primary keyipAddr, lastQueryTime
Region primary keyregionId
Region2Box primary keyregionType, id, boxID
Region2Box foreign keyRegion(regionID)
RegionArcs primary keyregionId, convexid, arcid
RegionArcs foreign keyRegion(regionID)
RegionConvex primary keyregionid, convexid, patch
RegionConvex foreign keyRegion(regionID)
RMatrix primary keymode, row
Rosat primary keyobjID
Rosat foreign keyPhotoObjAll(objID)
RunQA primary keyfieldID
RunQA foreign keyField(fieldID)
RunShift primary keyrun
SDSSConstants primary keyname
Sector primary keyregionId
Sector foreign keyRegion(regionID)
Sector2Tile primary keyregionId, tile
Sector2Tile foreign keyRegion(regionID)
Sector2Tile foreign keyTileAll(tile)
Sector2Tile covering indextile
Segment primary keysegmentID
Segment foreign keyChunk(chunkId)
Segment foreign keyStripeDefs(stripe)
SiteConstants primary keyname
SiteDiagnostics primary keyname
SpecLineAll primary keyspecLineID
SpecLineAll foreign keySpecObjAll(specObjID)
SpecLineAll covering unique indexspecobjID, specLineID
SpecLineIndex primary keyspecLineIndexID
SpecLineIndex foreign keySpecObjAll(specObjID)
SpecLineIndex covering unique indexspecobjID, speclineindexID
SpecObjAll primary keyspecObjID
SpecObjAll foreign keyPlateX(plateID)
SpecObjAll covering indexhtmID, ra, dec, cx, cy, cz, sciencePrimary
SpecObjAll covering indexBestObjID, objType, objTypeName, sciencePrimary, specClass, htmID, ra, dec, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z
SpecObjAll covering indexspecClass, zStatus, zWarning, z, sciencePrimary, primTarget, secTarget, plateId, bestObjID, targetObjId, htmID, ra, dec
SpecObjAll covering indextargetObjID, objType, objTypeName, sciencePrimary, specClass, htmID, ra, dec, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z
SpecObjAll covering indexra, [dec], specClass, plate, tile, z, zErr, zConf, fiberMag_r, primTarget, sciencePrimary, plateID, bestObjID
SpecPhotoAll primary keyspecObjID
SpecPhotoAll foreign keySpecObjAll(specObjID)
SpecPhotoAll covering indexobjID, sciencePrimary, specClass, z, targetObjid, targetId
SpecPhotoAll covering indextargetObjID, sciencePrimary, specClass, z, objid, targetId
SpecPhotoAll covering indextargetID, sciencePrimary, specClass, z, objid, targetObjId
Stetson primary keyname
Stetson covering indexobjID
Stetson covering indexRA, objID
Stetson covering indexDEC, objID
StripeDefs primary keystripe
TableDesc primary key[key]
Target primary keytargetID
Target covering indexbestobjID, regionID, specobjid
Target covering indexspecobjID, regionID, bestobjID
Target covering indexregionID, bestobjid, specobjid
Target covering indexhtmID, ra, dec, cx, cy, cz
TargetInfo primary keyskyVersion, targetID
TargetInfo foreign keyTarget(targetID)
TargetInfo covering indextargetobjID, primTarget, secTarget, priority
TargetInfo covering unique indextargetID, skyversion, targetobjID
TargetParam primary keytargetVersion, name
TileAll primary keytile
TileAll foreign keyTilingRun(tileRun)
TileAll covering unique indextileRun, tile
TileAll covering indexhtmID, racen, deccen, cx, cy, cz
TiledTargetAll primary keytargetID, tile
TiledTargetAll foreign keyTileAll(tile)
TiledTargetAll covering unique indextile, targetID
TiledTargetAll covering indexhtmID, ra, dec, cx, cy, cz, objtype
TiledTargetAll covering unique indexobjType, targetID, tile
TilingGeometry primary keytilingGeometryID
TilingGeometry foreign keyTilingRun(tileRun)
TilingGeometry foreign keyStripeDefs(stripe)
TilingInfo primary keytileRun, targetID
TilingInfo foreign keyTilingRun(tileRun)
TilingInfo covering unique indextargetID, tileRun, collisionGroupID
TilingInfo covering unique indextileRun, collisionGroupID, targetID
TilingInfo covering indextile, collisionGroupID
TilingNote primary keytilingNoteID
TilingNote foreign keyTilingRun(tileRun)
TilingRun primary keytileRun
USNO primary keyobjID
USNO foreign keyPhotoObjAll(objID)
USNOB primary keyobjID
USNOB foreign keyPhotoObjAll(objID)
Versions primary keyversion
XCRedshift primary keyxcRedshiftID
XCRedshift foreign keySpecObjAll(specObjID)
XCRedshift covering unique indexspecObjID, xcRedShiftID
Zone primary keyzoneID, ra, objID
Zone foreign keyPhotoObjAll(objID)