!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    CONV_DISCRETE2.SDDL
!
! Purpose:      This SDDL file defines the CONV_DISCRETE2 relation.
! The PDB cannot hold numbers larger than 999 for the low or high range.
! In addition, the PDB cannot hold TEXT values greater than 8 characters.
! With this delivery we have the option to have range values which are
! INTEGER*4 and TEXT values which are up to 18 characters (including spaces).
! Since standard FITS string keyword values are limited to 18 characters,
! we thought we should be able to specify conversions which used the whole
! space.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 12/04/96    31745     Rose  Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  CONV_DISCRETE2

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

DESCRIPTION    "This relation specifies the discrete conversions which
		are to be applied to certain telemetry mnemonics.

		In the past PODPS used a wide relation: one which had a
		single tuple for each mnemonic, and 16 groups of fields
		specifying up to 16 conversion ranges.  Not only is this
		a poor design limit on the number of possible ranges, but
		if a mnemonic only used 2 fields (a majority of cases) 
		there would be a significant amount of unused space reserved
		in the database.

		The current design allows a mnemonic to have any number of
		tuples, each one of which only specifies a single conversion
		range.  See OPR.29389.
"
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------

    FIELD  mnemonic
        TYPE            C8
        DESCRIPTION     "The name of the telemetry mnemonic"
    END_FIELD

    FIELD  low_value
        TYPE            I4
        DESCRIPTION     "The low value of the range"
    END_FIELD

    FIELD  high_value
        TYPE            I4
        DESCRIPTION     "The high value of the range"
    END_FIELD

    FIELD text
        TYPE            C18
        DESCRIPTION     "Return this text if the mnemonic value lies between 
			 the low_value and the high_value (inclusive)"
    END_FIELD

END_RECORD

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


RELATION  conv_discrete2

    TYPE             CONV_DISCRETE2

    DESCRIPTION      "Discrete conversion coefficients"

    SUBSYSTEM_USING  "OPUS"

    INDEX  conv_discrete_1
        TYPE         unique, clustered
        FIELDS       mnemonic, low_value
    END_INDEX

END_RELATION

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


INSTANCE  conv_discrete

    GLOBAL

    TYPE        CONV_DISCRETE

END_INSTANCE