!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    ASN_PRODUCT_LINK.SDDL
!
! Purpose:      This SDDL file defines the ASN_PRODUCT_LINK relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 05/14/99   39260      Baum  Original implementation
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

LANGUAGE        SQL

RECORD  ASN_LNK_TYPE

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

DESCRIPTION       "This relation is used for all products for an OPUS
                   association. It identifies the exposures contained in
                   each product. It can also be accessed to find the products
                   association with any exposure. The other relations used to
                   describe OPUS associationa are ASN_ASSOCIATION and 
                   ASN_MEMBERS " 

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


    FIELD  program_id
        TYPE		C3

        DESCRIPTION "When a proposal is accepted into the PMDB by SPSS it must
                    be assigned a unique 3 character base 36 program identifier.
                    This is done by the PMDB/ACCEPT_PROP command.  This program
                    identifier is tagged as 'program_id' in most PMDB relations.
                    Is is used for identification of proposals by spacecraft
                    and OPUS software. It is also used in the OPUS and DADS
                    rootname for all archived science data files.
                    Because of flight design software, program_id must be
                    three characters."
    END_FIELD


    FIELD  asn_obset_id
        TYPE		C2

        DESCRIPTION "Association observation set identifier. 

                    An observation set is identified by a 2 character base 36
                    string.  This field,  typically called 'obset_id', will
                    often contribute to the index on relation together with a
                    proposal_id, version_num, and possibly other fields.

                    OBSET is an abbreviation for observation set."
    END_FIELD

    FIELD member_num
        TYPE         C3
        UNITS	     "BASE_36"
        DESCRIPTION  "Member number (in asn_members) of the product: it is the
                     association number (two characters) plus the product_id."
    END_FIELD

 
    FIELD  obset_id
        TYPE		C2

        DESCRIPTION "Exposure observation set identifier. 

                    An observation set is identified by a 2 character base 36
                    string.  This field,  typically called 'obset_id', will
                    often contribute to the index on relation together with a
                    proposal_id, version_num, and possibly other fields.

                    OBSET is an abbreviation for observation set."
    END_FIELD

    FIELD ob_number
        TYPE         C2
        UNITS	     "BASE_36"
        DESCRIPTION  "Observations are numbered sequentially throughout
                     an observation set and are assigned by SMS/Gen.
                     An ob_number is _NOT_ the same as an obset_ID.
                     This field can be joined to member_num for 
                     exposure records in asn_members."
    END_FIELD
END_RECORD


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


RELATION  asn_product_link

    TYPE             ASN_LNK_TYPE

    DESCRIPTION      "Association Members Relation"

    SUBSYSTEM_USING  "OPUS", "DADS"

    INDEX  asn_product_link_1
        TYPE         unique, clustered
        FIELDS       program_id, asn_obset_id, member_num, obset_id,
                     ob_number
    END_INDEX

    INDEX  asn_product_link_2
        TYPE         nonclustered
        FIELDS       program_id, obset_id, ob_number
    END_INDEX

END_RELATION