Table Name | Index Type | Key or Field List |
AtlasOutline | primary key | objID |
AtlasOutline | foreign key | PhotoObjAll(objID) |
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 | 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 |
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) |
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 | 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) |
PhotozRF | primary key | objID |
PhotozRF | foreign key | PhotoObjAll(objID) |
PhotozRFTemplateCoeff | primary key | objID, templateID |
PhotozTemplateCoeff | primary key | objID, templateID |
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 |
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 |
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) |
sdssTilingGeometry | foreign key | StripeDefs(stripe) |
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 |
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 |
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 |
sppLines | primary key | specObjID |
sppParams | primary key | specObjID |
stellarMassPassivePort | primary key | specObjID |
stellarMassPCAWisc | 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 |
TwoMassXSC | primary key | objID |
USNO | primary key | objID |
Versions | primary key | version |
Zone | primary key | zoneID, ra, objID |
Zone | foreign key | PhotoObjAll(objID) |