| The combined spectro and photo parameters of an object in SpecObjAll |
| This is a precomputed join between the PhotoObjAll and SpecObjAll tables. The photo attibutes included cover about the same as PhotoTag. The table also includes certain attributes from Tiles. |
| Index Type | Key or Field List |
| primary key | specObjID |
| foreign key | SpecObjAll(specObjID) |
| covering index | objID, sciencePrimary, specClass, z, targetObjid, targetId |
| covering index | targetObjID, sciencePrimary, specClass, z, objid, targetId |
| covering index | targetID, sciencePrimary, specClass, z, objid, targetObjId |