File diff 000000000000 → 72890999e24d
sql/create_forcedsource.sql
Show inline comments
 
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)
 
  )
 
;