!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    CCAU_WF2_REF.SDDL        
!
! Purpose:      This SDDL file defines relation CCAU_WF2_REF        
!
! Modification History:
!
!   Date       OPR      Who                    Reason
!----------------------------------------------------------------------
! 19-JAN-96             PHyde          Original Implementaton
! 25-JAN-96             Heller         Researched and documented.
! 31-JUL-96    31905    MARose         Fix syntax so SDDLCOMP will work
! 25-JAN-02    42854    Sontag         Atodgain disc. values are int.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  CCAWF2_TYPE 

!----------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!----------------------------------------------------------------------

   DESCRIPTION   "Relation lists the WFPC2 reference files."

!----------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!----------------------------------------------------------------------

   FIELD  file_type           
       TYPE            C*3
       DESCRIPTION     "Type of reference file.  Possible values and their
                        meanings are:
                          MSK (Mask correction data)
                          A2D (A-to-D correction data)
                          DRK (Dark correction data)
                          FLT (flat field correction data)
                          SHD (shaded shutter correction data)
                          BAS (bias correction data)"
       UNITS
       DISCRETE        "MSK", "A2D", "DRK", "FLT", "SHD", "BAS"
   END_FIELD

   FIELD  mode                
       TYPE            C*4
       DESCRIPTION     "Instrument mode."
       UNITS
       DISCRETE        "FULL", "AREA"
   END_FIELD

   FIELD  clock               
       TYPE            C*3
       DESCRIPTION     "Serial clock status."
       UNITS
       DISCRETE        "ON", "OFF"
   END_FIELD

   FIELD  shutter             
       TYPE            C*1
       DESCRIPTION     "Shutter in place at the beginning of the exposure."
       UNITS
       DISCRETE        "A", "B", " "
   END_FIELD

   FIELD  filter_1            
       TYPE            I*2
       DESCRIPTION     "First filter number."
       UNITS
       RANGE           "0..48"
   END_FIELD

   FIELD  filter_2            
       TYPE            I*2
       DESCRIPTION     "Second filter number."
       DESCRIPTION
       RANGE           "0..48"
   END_FIELD

   FIELD  atodgain            
       TYPE            I*2
       DESCRIPTION     "Analog to Digital Gain (Electrons/DN)"
       UNITS
       DISCRETE        "7", "15"
    END_FIELD

   FIELD  data_file           
       TYPE            C*18
       DESCRIPTION     "Reference file name."
       UNITS
       RANGE
   END_FIELD

   FIELD  qual_file           
       TYPE            C*18
       DESCRIPTION     "Data quality reference file name."
       UNITS
       RANGE
   END_FIELD

   FIELD  load_time           
       TYPE            C*20
       DESCRIPTION     "Time the given record was loaded in the database."
       UNITS
       RANGE
   END_FIELD

   FIELD  use_after           
       TYPE            C*17
       DESCRIPTION     "Observations executed after this 'use_after' date
                        use this tuple in the relation.  The time format
                        is YYYY.DDD:HH:MM:SS"
       UNITS
       RANGE           "1980.001:00:00:00..2020.001:00:00:00"
   END_FIELD

END_RECORD

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!   RELATION DECLARATION
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

RELATION  ccau_wf2_ref

    TYPE            CCAWF2_TYPE

    DESCRIPTION

    SUBSYSTEM_USING "OPUS"

    INDEX  ccau_wf2_ref_1     
        TYPE         clustered
        FIELDS       file_type, mode, use_after
        ATTRIBUTES   ignore_dup_row
    END_INDEX

END_RELATION

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!   INSTANCE DECLARATION
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

INSTANCE  ccau_wf2_ref        

    GLOBAL

    TYPE        CCAWF2_TYPE 

END_INSTANCE