Changes between Initial Version and Version 1 of BillsSAS39ViewNotes

Timestamp:

Sep 1, 2015, 11:59:50 AM (11 years ago)

Author:

bills

Comment:

--

BillsSAS39ViewNotes

@@ +1 @@
+Bill's comments on the SAS 39 views
+
+StackObjectView is a join of three tables:     ObjectThin
+    StackObjectThin
+    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.
+