PV2 schema

Introduction

This is the wiki of the new PV2 schema (mostly for Heather for development purposes). There are 2 parts to this wiki:

• dump stuff from Ken's schema into here ​http://www.ifa.hawaii.edu/faculty/chambers/schema.html

• make it look like (in the end) the following wikis
  • ippToPsps_Stack
  • ippToPsps_Detections
  • ippToPsps_Object
  • ippToPsps_Init
  • ippToPsps_Initialization

Organization

Ken's website has all the tables. ippToPsps only cares about the fundamental ipp tables and some of the metadata ones. This wiki will only describe those tables. IppToPSPS handles things at different stages, so the different tables will be split by different stages (this is the same for the PV1 version of ipptopsps - we have stack tables, detection (ie, single exposure) tables, and object (dvo only) tables

• DVO tables
  • ObjectThin change short object - no fluxes
  • MeanObject extracted Mean properties from current Object table, but expanded to include name mean xApMag. Could be robust from ForcedMeasurement.
  • StackObject extracted Stack properties from current Object table (HAF assumes that we need to load this via stack if information is in cmf files)
  • DiffObject associations of Difference Detections (HAF: is this just dvo tables?) (HAF - we don't calculate DiffObject properties)
  • ForcedMeanObject like MeanObject, but using the Forced Mean Measurements to form the Mean. (HAF - we don't calculate these in dvo)

• detection Tables

• Detection ( ippToPsps_PV2_Detection ) detections found in detrended images

• stack Tables
  • StackDetection change to combine all filters of stack detections in one table because these are forced anyway. Then can take out of Object table.
  • StackApFlx change to combine all filters in one table. change to unconvolved, and convolved up to 6 , 8, 10(?) pixels in all bands
  • StackModelFit change to combine all filters in one table. Models of high signal to noise objects in low density regions. Some new parameters to add.
  • ForcedWarpMeasure forced measurements on each warp in all filters at the position of an object found in a stack. Includes StackApFlx-like table for aps no in object (HAF wonders about this? we don't keep warp catalogs?)

• diff Tables
  • DiffDet difference detections found in difference image = image - template

• wband tables (HAF recommends we wait till we have the PV2 schema in place for the other filters before tackling this)
  • wStackObject w filter measurements of wStackObject (because w only over < 1 pi steradian, non-univorm, and likely to be computed and loaded in psps separately.)
  • wMeanObject w filter measurements of wMeanObject (ditto)
  • wStackApFlx w filter measurements of wStackApFlx do we need this ?
  • w Others.. Det, Diff Det fine for w okay, do we want Stack Model Fit? Should we add w to ForcedMeanObject table (size), do Forced Warp Measurments?