= Bill's comments on the SAS 39 views =
[wiki:ippToPspsSAS39BillsNotes 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:BillsSas39PSPSNotes wiki page].

That is the projectionID and skyCellID in StackObjectView do not match the actual stacks that the detections came from - as given by 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.