!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    GRAND_MAMA.SDDL
!
! Purpose:      This SDDL file defines the GRAND_MAMA relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---    -------------------------------------------------
! 03/21/97    30219     Rose   Original implementation
! 02/02/98    36087	MARose Change date_added field name to daily_added
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  GRAND_MAMA

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

DESCRIPTION    "This relation is used in OPUS to track when MAMA exposures
		were added to the GRAND_MAMA cumulative history.  The first
		field indicates the name of the exposure.  The second field
		is the date (YYYYMMDD) when the exposure was added to the
		daily history file.  And the third field (YYYYMMDD) is the
		date when the daily history was added to the lifetime history."

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

    FIELD  expname
        TYPE            C9
        DESCRIPTION     "The exposure name (ipppssoot)"
    END_FIELD

    FIELD  detector
        TYPE            C3
        DESCRIPTION     "The detector: NUV or FUV"
    END_FIELD

    FIELD  daily_added
        TYPE            C8
        DESCRIPTION     "The date the exposure was added to the history"
    END_FIELD

    FIELD lifetime_date
        TYPE            C8
        DESCRIPTION     "The date the history was added to the lifetime"
    END_FIELD

END_RECORD

!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------


RELATION  grand_mama

    TYPE             GRAND_MAMA

    DESCRIPTION      "Cumulative MAMA counts"

    SUBSYSTEM_USING  "OPUS"

    INDEX  grand_mama_1
        TYPE         clustered
        FIELDS       expname
    END_INDEX

END_RELATION

!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------


INSTANCE  grand_mama

    GLOBAL

    TYPE        GRAND_MAMA

END_INSTANCE