Bill's comments on the SAS 39 views

back up to ippToPspsSAS39BillsNotes

StackObjectView is a join of three tables:

ObjectThin StackObjectThin and StackObjectAttributes

Includes all columns from ObjectThin except for batchID. A few (bookkeeping) columns are dropped from StackObjectThin From StackObjectAttributes columns that are duplicates from the thin men are dropped.

Mostly looks fine except for the projectionID skycellId issue that I mentioned in my wiki page That is the projectionID and skyCellID do not match the xStackMetaIDs

I suggest change the view to incude the values from StackObjectThin instead and it would be useful to add StackObjectThin.primaryDetection and StackObjectThin.bestDetection

At a higher level, given the ambiguity do ObjectThin projectionID & skycellID make sense? Perhaps they should be called primaryProjectionID, primarySkyCellID ?

If that change were made to the schema then we could include both in StackObjectView, but I don't see what value that would add.