| Keep track of why a Target was assigned to a Tile |
| This table is designed to be searched both ways - one can find the Targets assigned to a Tile or one can find all the Tiles a Target has been assigned to (objects can be assigned to more than one tile if they are QA objects). Information comes from plPlugMapP files, but only OBJECT hole info is stored. HoleObj can be used to find other holetypes that made it to a Plate. |
| Index Type | Key or Field List |
| primary key | targetID, tile |
| foreign key | TileAll(tile) |
| covering unique index | tile, targetID |
| covering index | htmID, ra, dec, cx, cy, cz, objtype |
| covering unique index | objType, targetID, tile |