|
new file 100644
|
|
|
CREATE TABLE %(tabname)s
|
|
|
(deepSourceId BIGINT NOT NULL
|
|
|
,ra double NOT NULL
|
|
|
,decl double NOT NULL
|
|
|
,raVar double DEFAULT NULL
|
|
|
,declVar double DEFAULT NULL
|
|
|
,radeclCov double DEFAULT NULL
|
|
|
,chunkId INT NOT NULL
|
|
|
,subChunkId INT NOT NULL
|
|
|
,u_psfFlux double DEFAULT NULL
|
|
|
,u_psfFluxSigma double DEFAULT NULL
|
|
|
,u_apFlux double DEFAULT NULL
|
|
|
,u_apFluxSigma double DEFAULT NULL
|
|
|
,u_modelFlux double DEFAULT NULL
|
|
|
,u_modelFluxSigma double DEFAULT NULL
|
|
|
,u_instFlux double DEFAULT NULL
|
|
|
,u_instFluxSigma double DEFAULT NULL
|
|
|
,u_apCorrection double DEFAULT NULL
|
|
|
,u_apCorrectionSigma double DEFAULT NULL
|
|
|
,u_shapeIx double DEFAULT NULL
|
|
|
,u_shapeIy double DEFAULT NULL
|
|
|
,u_shapeIxVar double DEFAULT NULL
|
|
|
,u_shapeIyVar double DEFAULT NULL
|
|
|
,u_shapeIxIyCov double DEFAULT NULL
|
|
|
,u_shapeIxx double DEFAULT NULL
|
|
|
,u_shapeIyy double DEFAULT NULL
|
|
|
,u_shapeIxy double DEFAULT NULL
|
|
|
,u_shapeIxxVar double DEFAULT NULL
|
|
|
,u_shapeIyyVar double DEFAULT NULL
|
|
|
,u_shapeIxyVar double DEFAULT NULL
|
|
|
,u_shapeIxxIyyCov double DEFAULT NULL
|
|
|
,u_shapeIxxIxyCov double DEFAULT NULL
|
|
|
,u_shapeIyyIxyCov double DEFAULT NULL
|
|
|
,u_extendedness double DEFAULT NULL
|
|
|
,u_flagNegative BOOLEAN DEFAULT NULL
|
|
|
,u_flagBadMeasCentroid BOOLEAN DEFAULT NULL
|
|
|
,u_flagPixEdge BOOLEAN DEFAULT NULL
|
|
|
,u_flagPixInterpAny BOOLEAN DEFAULT NULL
|
|
|
,u_flagPixInterpCen BOOLEAN DEFAULT NULL
|
|
|
,u_flagPixSaturAny BOOLEAN DEFAULT NULL
|
|
|
,u_flagPixSaturCen BOOLEAN DEFAULT NULL
|
|
|
,u_flagBadPsfFlux BOOLEAN DEFAULT NULL
|
|
|
,u_flagBadApFlux BOOLEAN DEFAULT NULL
|
|
|
,u_flagBadModelFlux BOOLEAN DEFAULT NULL
|
|
|
,u_flagBadInstFlux BOOLEAN DEFAULT NULL
|
|
|
,u_flagBadCentroid BOOLEAN DEFAULT NULL
|
|
|
,u_flagBadShape BOOLEAN DEFAULT NULL
|
|
|
,g_psfFlux double DEFAULT NULL
|
|
|
,g_psfFluxSigma double DEFAULT NULL
|
|
|
,g_apFlux double DEFAULT NULL
|
|
|
,g_apFluxSigma double DEFAULT NULL
|
|
|
,g_modelFlux double DEFAULT NULL
|
|
|
,g_modelFluxSigma double DEFAULT NULL
|
|
|
,g_instFlux double DEFAULT NULL
|
|
|
,g_instFluxSigma double DEFAULT NULL
|
|
|
,g_apCorrection double DEFAULT NULL
|
|
|
,g_apCorrectionSigma double DEFAULT NULL
|
|
|
,g_shapeIx double DEFAULT NULL
|
|
|
,g_shapeIy double DEFAULT NULL
|
|
|
,g_shapeIxVar double DEFAULT NULL
|
|
|
,g_shapeIyVar double DEFAULT NULL
|
|
|
,g_shapeIxIyCov double DEFAULT NULL
|
|
|
,g_shapeIxx double DEFAULT NULL
|
|
|
,g_shapeIyy double DEFAULT NULL
|
|
|
,g_shapeIxy double DEFAULT NULL
|
|
|
,g_shapeIxxVar double DEFAULT NULL
|
|
|
,g_shapeIyyVar double DEFAULT NULL
|
|
|
,g_shapeIxyVar double DEFAULT NULL
|
|
|
,g_shapeIxxIyyCov double DEFAULT NULL
|
|
|
,g_shapeIxxIxyCov double DEFAULT NULL
|
|
|
,g_shapeIyyIxyCov double DEFAULT NULL
|
|
|
,g_extendedness double DEFAULT NULL
|
|
|
,g_flagNegative BOOLEAN DEFAULT NULL
|
|
|
,g_flagBadMeasCentroid BOOLEAN DEFAULT NULL
|
|
|
,g_flagPixEdge BOOLEAN DEFAULT NULL
|
|
|
,g_flagPixInterpAny BOOLEAN DEFAULT NULL
|
|
|
,g_flagPixInterpCen BOOLEAN DEFAULT NULL
|
|
|
,g_flagPixSaturAny BOOLEAN DEFAULT NULL
|
|
|
,g_flagPixSaturCen BOOLEAN DEFAULT NULL
|
|
|
,g_flagBadPsfFlux BOOLEAN DEFAULT NULL
|
|
|
,g_flagBadApFlux BOOLEAN DEFAULT NULL
|
|
|
,g_flagBadModelFlux BOOLEAN DEFAULT NULL
|
|
|
,g_flagBadInstFlux BOOLEAN DEFAULT NULL
|
|
|
,g_flagBadCentroid BOOLEAN DEFAULT NULL
|
|
|
,g_flagBadShape BOOLEAN DEFAULT NULL
|
|
|
,r_psfFlux double DEFAULT NULL
|
|
|
,r_psfFluxSigma double DEFAULT NULL
|
|
|
,r_apFlux double DEFAULT NULL
|
|
|
,r_apFluxSigma double DEFAULT NULL
|
|
|
,r_modelFlux double DEFAULT NULL
|
|
|
,r_modelFluxSigma double DEFAULT NULL
|
|
|
,r_instFlux double DEFAULT NULL
|
|
|
,r_instFluxSigma double DEFAULT NULL
|
|
|
,r_apCorrection double DEFAULT NULL
|
|
|
,r_apCorrectionSigma double DEFAULT NULL
|
|
|
,r_shapeIx double DEFAULT NULL
|
|
|
,r_shapeIy double DEFAULT NULL
|
|
|
,r_shapeIxVar double DEFAULT NULL
|
|
|
,r_shapeIyVar double DEFAULT NULL
|
|
|
,r_shapeIxIyCov double DEFAULT NULL
|
|
|
,r_shapeIxx double DEFAULT NULL
|
|
|
,r_shapeIyy double DEFAULT NULL
|
|
|
,r_shapeIxy double DEFAULT NULL
|
|
|
,r_shapeIxxVar double DEFAULT NULL
|
|
|
,r_shapeIyyVar double DEFAULT NULL
|
|
|
,r_shapeIxyVar double DEFAULT NULL
|
|
|
,r_shapeIxxIyyCov double DEFAULT NULL
|
|
|
,r_shapeIxxIxyCov double DEFAULT NULL
|
|
|
,r_shapeIyyIxyCov double DEFAULT NULL
|
|
|
,r_extendedness double DEFAULT NULL
|
|
|
,r_flagNegative BOOLEAN DEFAULT NULL
|
|
|
,r_flagBadMeasCentroid BOOLEAN DEFAULT NULL
|
|
|
,r_flagPixEdge BOOLEAN DEFAULT NULL
|
|
|
,r_flagPixInterpAny BOOLEAN DEFAULT NULL
|
|
|
,r_flagPixInterpCen BOOLEAN DEFAULT NULL
|
|
|
,r_flagPixSaturAny BOOLEAN DEFAULT NULL
|
|
|
,r_flagPixSaturCen BOOLEAN DEFAULT NULL
|
|
|
,r_flagBadPsfFlux BOOLEAN DEFAULT NULL
|
|
|
,r_flagBadApFlux BOOLEAN DEFAULT NULL
|
|
|
,r_flagBadModelFlux BOOLEAN DEFAULT NULL
|
|
|
,r_flagBadInstFlux BOOLEAN DEFAULT NULL
|
|
|
,r_flagBadCentroid BOOLEAN DEFAULT NULL
|
|
|
,r_flagBadShape BOOLEAN DEFAULT NULL
|
|
|
,i_psfFlux double DEFAULT NULL
|
|
|
,i_psfFluxSigma double DEFAULT NULL
|
|
|
,i_apFlux double DEFAULT NULL
|
|
|
,i_apFluxSigma double DEFAULT NULL
|
|
|
,i_modelFlux double DEFAULT NULL
|
|
|
,i_modelFluxSigma double DEFAULT NULL
|
|
|
,i_instFlux double DEFAULT NULL
|
|
|
,i_instFluxSigma double DEFAULT NULL
|
|
|
,i_apCorrection double DEFAULT NULL
|
|
|
,i_apCorrectionSigma double DEFAULT NULL
|
|
|
,i_shapeIx double DEFAULT NULL
|
|
|
,i_shapeIy double DEFAULT NULL
|
|
|
,i_shapeIxVar double DEFAULT NULL
|
|
|
,i_shapeIyVar double DEFAULT NULL
|
|
|
,i_shapeIxIyCov double DEFAULT NULL
|
|
|
,i_shapeIxx double DEFAULT NULL
|
|
|
,i_shapeIyy double DEFAULT NULL
|
|
|
,i_shapeIxy double DEFAULT NULL
|
|
|
,i_shapeIxxVar double DEFAULT NULL
|
|
|
,i_shapeIyyVar double DEFAULT NULL
|
|
|
,i_shapeIxyVar double DEFAULT NULL
|
|
|
,i_shapeIxxIyyCov double DEFAULT NULL
|
|
|
,i_shapeIxxIxyCov double DEFAULT NULL
|
|
|
,i_shapeIyyIxyCov double DEFAULT NULL
|
|
|
,i_extendedness double DEFAULT NULL
|
|
|
,i_flagNegative BOOLEAN DEFAULT NULL
|
|
|
,i_flagBadMeasCentroid BOOLEAN DEFAULT NULL
|
|
|
,i_flagPixEdge BOOLEAN DEFAULT NULL
|
|
|
,i_flagPixInterpAny BOOLEAN DEFAULT NULL
|
|
|
,i_flagPixInterpCen BOOLEAN DEFAULT NULL
|
|
|
,i_flagPixSaturAny BOOLEAN DEFAULT NULL
|
|
|
,i_flagPixSaturCen BOOLEAN DEFAULT NULL
|
|
|
,i_flagBadPsfFlux BOOLEAN DEFAULT NULL
|
|
|
,i_flagBadApFlux BOOLEAN DEFAULT NULL
|
|
|
,i_flagBadModelFlux BOOLEAN DEFAULT NULL
|
|
|
,i_flagBadInstFlux BOOLEAN DEFAULT NULL
|
|
|
,i_flagBadCentroid BOOLEAN DEFAULT NULL
|
|
|
,i_flagBadShape BOOLEAN DEFAULT NULL
|
|
|
,z_psfFlux double DEFAULT NULL
|
|
|
,z_psfFluxSigma double DEFAULT NULL
|
|
|
,z_apFlux double DEFAULT NULL
|
|
|
,z_apFluxSigma double DEFAULT NULL
|
|
|
,z_modelFlux double DEFAULT NULL
|
|
|
,z_modelFluxSigma double DEFAULT NULL
|
|
|
,z_instFlux double DEFAULT NULL
|
|
|
,z_instFluxSigma double DEFAULT NULL
|
|
|
,z_apCorrection double DEFAULT NULL
|
|
|
,z_apCorrectionSigma double DEFAULT NULL
|
|
|
,z_shapeIx double DEFAULT NULL
|
|
|
,z_shapeIy double DEFAULT NULL
|
|
|
,z_shapeIxVar double DEFAULT NULL
|
|
|
,z_shapeIyVar double DEFAULT NULL
|
|
|
,z_shapeIxIyCov double DEFAULT NULL
|
|
|
,z_shapeIxx double DEFAULT NULL
|
|
|
,z_shapeIyy double DEFAULT NULL
|
|
|
,z_shapeIxy double DEFAULT NULL
|
|
|
,z_shapeIxxVar double DEFAULT NULL
|
|
|
,z_shapeIyyVar double DEFAULT NULL
|
|
|
,z_shapeIxyVar double DEFAULT NULL
|
|
|
,z_shapeIxxIyyCov double DEFAULT NULL
|
|
|
,z_shapeIxxIxyCov double DEFAULT NULL
|
|
|
,z_shapeIyyIxyCov double DEFAULT NULL
|
|
|
,z_extendedness double DEFAULT NULL
|
|
|
,z_flagNegative BOOLEAN DEFAULT NULL
|
|
|
,z_flagBadMeasCentroid BOOLEAN DEFAULT NULL
|
|
|
,z_flagPixEdge BOOLEAN DEFAULT NULL
|
|
|
,z_flagPixInterpAny BOOLEAN DEFAULT NULL
|
|
|
,z_flagPixInterpCen BOOLEAN DEFAULT NULL
|
|
|
,z_flagPixSaturAny BOOLEAN DEFAULT NULL
|
|
|
,z_flagPixSaturCen BOOLEAN DEFAULT NULL
|
|
|
,z_flagBadPsfFlux BOOLEAN DEFAULT NULL
|
|
|
,z_flagBadApFlux BOOLEAN DEFAULT NULL
|
|
|
,z_flagBadModelFlux BOOLEAN DEFAULT NULL
|
|
|
,z_flagBadInstFlux BOOLEAN DEFAULT NULL
|
|
|
,z_flagBadCentroid BOOLEAN DEFAULT NULL
|
|
|
,z_flagBadShape BOOLEAN DEFAULT NULL
|
|
|
,y_psfFlux double DEFAULT NULL
|
|
|
,y_psfFluxSigma double DEFAULT NULL
|
|
|
,y_apFlux double DEFAULT NULL
|
|
|
,y_apFluxSigma double DEFAULT NULL
|
|
|
,y_modelFlux double DEFAULT NULL
|
|
|
,y_modelFluxSigma double DEFAULT NULL
|
|
|
,y_instFlux double DEFAULT NULL
|
|
|
,y_instFluxSigma double DEFAULT NULL
|
|
|
,y_apCorrection double DEFAULT NULL
|
|
|
,y_apCorrectionSigma double DEFAULT NULL
|
|
|
,y_shapeIx double DEFAULT NULL
|
|
|
,y_shapeIy double DEFAULT NULL
|
|
|
,y_shapeIxVar double DEFAULT NULL
|
|
|
,y_shapeIyVar double DEFAULT NULL
|
|
|
,y_shapeIxIyCov double DEFAULT NULL
|
|
|
,y_shapeIxx double DEFAULT NULL
|
|
|
,y_shapeIyy double DEFAULT NULL
|
|
|
,y_shapeIxy double DEFAULT NULL
|
|
|
,y_shapeIxxVar double DEFAULT NULL
|
|
|
,y_shapeIyyVar double DEFAULT NULL
|
|
|
,y_shapeIxyVar double DEFAULT NULL
|
|
|
,y_shapeIxxIyyCov double DEFAULT NULL
|
|
|
,y_shapeIxxIxyCov double DEFAULT NULL
|
|
|
,y_shapeIyyIxyCov double DEFAULT NULL
|
|
|
,y_extendedness double DEFAULT NULL
|
|
|
,y_flagNegative BOOLEAN DEFAULT NULL
|
|
|
,y_flagBadMeasCentroid BOOLEAN DEFAULT NULL
|
|
|
,y_flagPixEdge BOOLEAN DEFAULT NULL
|
|
|
,y_flagPixInterpAny BOOLEAN DEFAULT NULL
|
|
|
,y_flagPixInterpCen BOOLEAN DEFAULT NULL
|
|
|
,y_flagPixSaturAny BOOLEAN DEFAULT NULL
|
|
|
,y_flagPixSaturCen BOOLEAN DEFAULT NULL
|
|
|
,y_flagBadPsfFlux BOOLEAN DEFAULT NULL
|
|
|
,y_flagBadApFlux BOOLEAN DEFAULT NULL
|
|
|
,y_flagBadModelFlux BOOLEAN DEFAULT NULL
|
|
|
,y_flagBadInstFlux BOOLEAN DEFAULT NULL
|
|
|
,y_flagBadCentroid BOOLEAN DEFAULT NULL
|
|
|
,y_flagBadShape BOOLEAN DEFAULT NULL
|
|
|
-- ,PRIMARY KEY (deepSourceId)
|
|
|
)
|
|
|
;
|
|
|
|