Maria,
Can an alert correspond to more than one object?
Probably not. Then you don't need a new table only and objectID in the
Alert table
That would work if the answer is 'no', especially given
that the Alert table will be compact. (Can someone remind
me how many alerts we expect per night? Assuming 10,
the Alert table will be growing 3,000 rows/year,
that is nothing.)
We should then keep the bit in the Object table
indicating whether there was an alert for given Object
(as Tim suggested)
thanks,
Jacek
_______________________________________________
LSST-data mailing list
[email protected]
http://www.lsstmail.org/mailman/listinfo/lsst-data