|
new file 100644
|
|
|
CREATE TABLE %(tabname)s
|
|
|
(deepSourceId BIGINT NOT NULL
|
|
|
,scienceCcdExposureId BIGINT NOT NULL
|
|
|
,psfFlux float DEFAULT NULL
|
|
|
,psfFluxSigma float DEFAULT NULL
|
|
|
,flagBadMeasCentroid BOOLEAN NOT NULL
|
|
|
,flagPixEdge BOOLEAN NOT NULL
|
|
|
,flagPixInterpAny BOOLEAN NOT NULL
|
|
|
,flagPixInterpCen BOOLEAN NOT NULL
|
|
|
,flagPixSaturAny BOOLEAN NOT NULL
|
|
|
,flagPixSaturCen BOOLEAN NOT NULL
|
|
|
,flagBadPsfFlux BOOLEAN NOT NULL
|
|
|
,chunkId INT NOT NULL
|
|
|
,subChunkId INT NOT NULL
|
|
|
-- ,PRIMARY KEY (deepSourceIdscienceCcdExposureId)
|
|
|
)
|
|
|
;
|