Changes between Version 3 and Version 4 of BillsSAS39ViewNotes

Timestamp:

Sep 1, 2015, 12:03:13 PM (11 years ago)

Author:

bills

Comment:

--

BillsSAS39ViewNotes

@@ -3 +3 @@
 !StackObjectView is a join of three tables:     
     !ObjectThin
-    !StackObjectThin
+    !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.
+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
@@ -14 +14 @@
 
 I suggest change the view to incude the values from StackObjectThin instead  
-and it would be useful to add StackObjectThin.primaryDetection and StackObjectThin.bestDetection
+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?
+At a higher level, given the ambiguity do !ObjectThin projectionID & skycellID make sense?
 Perhaps they should be called primaryProjectionID, primarySkyCellID ?