!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    QPKEYWORDS.SDDL
!
! Purpose:      This SDDL file defines the qpkeywords relation.
!
! Modification History:
!
!   Date       PR      Who                       Reason
! --------   -------   ---   -------------------------------------------------
! 11/28/94   27329     EGB   Original implementation
! 07/02/97   34363     MRB   Extend keyword field
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE C, FORTRAN, SQL

INCLUDE ZSPSS_USER_TYPES.SDDL
 
RECORD QPKEY_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION       "This relation is used to associate keywords with a
		       a proposal. A given proposal may have multiple sets
		       of keywords specified.  A keyword is text that 
		       identifies a proposal at an abstract level.  Some sample
		       keywords include:

				INNER PLANETS
				CALIBRATION
				ASTROMETRY
				COOL STARS
				INTERSTELLAR MEDIUM
				HOT STARS AND STELLAR CORPSES, 
				QUASAR ABSORPTION LINES,
				YOUNG STARS AND CIRCUMSTELLAR MATERIAL "
 
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
    FIELD  proposal_id
        TYPE            PROPOSAL_ID_TYPE
    END_FIELD
 
    FIELD  keyword
        TYPE            C40
        DESCRIPTION     "This field contains a keyword associated to this 
		         proposal by the proposer (or possibly a Program 
			 Coordinator)."
    END_FIELD
 
END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  qpkeywords
 
    TYPE             QPKEY_TYPE
 
    DESCRIPTION      "Proposal Keyword Relation"
 
    SUBSYSTEM_USING  "SPSS", "TRANS"
 
    INDEX  qpkeywords_1
        TYPE         unique, clustered
        FIELDS       proposal_id, keyword
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE  qpkeywords
 
    GLOBAL
 
    TYPE        QPKEY_TYPE
 
END_INSTANCE