!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    WAVCAL.SDDL       
!
! Purpose:      This SDDL file defines the relation WAVCAL       
!
! Modification History:
!
!   Date       OPR      Who                    Reason
!----------------------------------------------------------------------
! 02-AUG-96    30320    Ken S.       
! 01-SEP-96    30320    Ken S.	Change relation name to lower case.       
! 31-JAN-97    30320.3  Ken S.	Add association_name to unique index.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  WAVCAL_TYPE 

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

   DESCRIPTION                 "To track wavcal exposures processed by
                                OMSASN command."

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

   FIELD  association_name        
       TYPE            C*9
       DESCRIPTION             "The name given to an association product."
       UNITS
       RANGE
   END_FIELD

   FIELD  member_name           
       TYPE            C*9
       DESCRIPTION             "The name given to a member of an association."
       UNITS
       RANGE
   END_FIELD

END_RECORD

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

RELATION  wavcal

    TYPE            WAVCAL_TYPE

    DESCRIPTION

    SUBSYSTEM_USING "OMS"

    INDEX  wavcal_1
        TYPE         unique, clustered
        FIELDS       association_name, member_name
    END_INDEX
 
END_RELATION

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


INSTANCE  wavcal       

    GLOBAL

    TYPE        WAVCAL_TYPE 

END_INSTANCE