!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    CCAA_WFC_REF.SDDL        
!
! Purpose:      This SDDL file defines relation CCAA_WFC_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
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  CCAWFC_TYPE 

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

   DESCRIPTION  "Lists the calibration reference files for the WFPC
                 instrument."

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

   FIELD  file_type           
       TYPE            C*3
       DESCRIPTION     "Describes the type of Calibration Reference File."
       UNITS
       RANGE
   END_FIELD

   FIELD  camera              
       TYPE            C*2
       DESCRIPTION     "Camera in use."
       UNITS
       RANGE
   END_FIELD

   FIELD  mode                
       TYPE            C*4
       DESCRIPTION     "Mode of the camera."
       UNITS
       RANGE
   END_FIELD

   FIELD  clock               
       TYPE            C*3
       DESCRIPTION     "Serial setting of the clock."
       UNITS
       RANGE
   END_FIELD

   FIELD  shutter             
       TYPE            C*1
       DESCRIPTION     "Shutter setting of the camera."
       UNITS
       RANGE
   END_FIELD

   FIELD  filter_1            
       TYPE            I*2
       DESCRIPTION     "First filter in position."
       UNITS
       RANGE
   END_FIELD

   FIELD  filter_2            
       TYPE            I*2
       DESCRIPTION     "Second filter in position."
       UNITS
       RANGE
   END_FIELD

   FIELD  data_file           
       TYPE            C*18
       DESCRIPTION     "The Calibration reference file name."
       UNITS
       RANGE
   END_FIELD

   FIELD  qual_file           
       TYPE            C*18
       DESCRIPTION     "The Calibration data quality file name."
       UNITS
       RANGE
   END_FIELD

   FIELD  load_time           
       TYPE            C*20
       DESCRIPTION     "The time the tuple was added to the relation."
       UNITS
       RANGE
   END_FIELD

   FIELD  use_after           
       TYPE            C*17
       DESCRIPTION     "Observations executed after this 'use_after' date
                        use this tuple in the relation."
       UNITS
       RANGE           "1980.001:00:00:00..2020.001:00:00:00"
   END_FIELD

END_RECORD

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

RELATION  ccaa_wfc_ref        

    TYPE            CCAWFC_TYPE 

    DESCRIPTION

    SUBSYSTEM_USING "OPUS"

    INDEX  ccaa_wfc_ref_1      
        TYPE          clustered
        FIELDS        filter_1, filter_2                               
        ATTRIBUTES    ignore_dup_row
    END_INDEX

END_RELATION

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

INSTANCE  ccaa_wfc_ref        

    GLOBAL

    TYPE        CCAWFC_TYPE 

END_INSTANCE