# Definition of Steps and Dependencies for Jobs running at ISDC

RawFileRsyncedISDC.MainTable: RawFileRsyncedISDC
RawFileRsyncedISDC.Primaries: fNight, fRunID
RawFileRsyncedISDC.Needs: 
RawFileRsyncedISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fRunID)
RawFileRsyncedISDC.SortDirection: ASC

RawFileAvailWue.MainTable: RawFileAvailWue
RawFileAvailWue.Primaries: fNight, fRunID
RawFileAvailWue.Needs: RawFileRsyncedISDC
RawFileAvailWue.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fRunID)
RawFileAvailWue.SortDirection: ASC

#RawFileAvailPhido.MainTable: RawFileAvailPhido
#RawFileAvailPhido.Primaries: fNight, fRunID
#RawFileAvailPhido.Needs: RawFileRsyncedISDC
#RawFileAvailPhido.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fRunID)
#RawFileAvailPhido.SortDirection: ASC

# independent as filled by CheckRawFileAvail.sh
RawFileAvailISDC.MainTable: RawFileAvailISDC
RawFileAvailISDC.Primaries: fNight, fRunID
RawFileAvailISDC.Needs: RawFileRsyncedISDC
RawFileAvailISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fRunID)

AuxFilesAvailISDC.MainTable: AuxFilesAvailISDC
AuxFilesAvailISDC.Primaries: fNight
#AuxFilesAvailISDC.Needs: 
AuxFilesAvailISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight)

DriveFileAvailISDC.MainTable: DriveFileAvailISDC
DriveFileAvailISDC.Primaries: fNight
#DriveFileAvailISDC.Needs: 
DriveFileAvailISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight)

RatesFileAvailISDC.MainTable: RatesFileAvailISDC
RatesFileAvailISDC.Primaries: fNight
#RatesFileAvailISDC.Needs: 
RatesFileAvailISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight)

SequenceFileAvailISDC.MainTable: SequenceFileAvailISDC
SequenceFileAvailISDC.Primaries: fNight, fSequenceID
#SequenceFileAvailISDC.Needs: 
SequenceFileAvailISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)

Callisto.MainTable: Callisto
Callisto.Primaries: fNight, fSequenceID
Callisto.Needs: RawFileAvailISDC SequenceFileAvailISDC
Callisto.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)

Star.MainTable: Star
Star.Primaries: fNight, fSequenceID
Star.Needs: RawFileAvailISDC Callisto DriveFileAvailISDC RatesFileAvailISDC SequenceFileAvailISDC
Star.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)

#Merpp.MainTable: Merpp
#Merpp.Primaries: fNight, fSequenceID
#Merpp.Needs: RawFileAvailISDC Callisto Star
#Merpp.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)