Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	WFHST_AVAIL.SDDL
!
! Purpose:      This SDDL file defines the wfhst_avail relation.
!
! Modification History:
!
!   Date       PR      Who                       Reason
! --------   -------   ---   -------------------------------------------------
! 06/22/99   37231     bao   Scheduling FHST Updates Project
! 10/01/01   44572     sss   Added index
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE  C, FORTRAN, SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL
 
RECORD  FHSTAVAIL_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION	"The wfhst_avail relation stores fhst availability data.
		This data, which is provided for each usable fhst, specifies 
		roll ranges at which reference stars are available in the fhst."

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

    FIELD  proposal_id
        TYPE PROPOSAL_ID_TYPE
    END_FIELD
 
 

    FIELD  obset_id
        TYPE OBSET_ID_TYPE
    END_FIELD
 
 

    FIELD  version_num
        TYPE VERSION_NUM_TYPE
    END_FIELD
 
 

    FIELD  fhst_id 
        TYPE            C1
        DESCRIPTION     "This field specifies the identifier of the fhst that
			 the availability roll range data corresponds to."
        DISCRETE        "1", "2", "3"
    END_FIELD
 
 

    FIELD  min_v3_pos_ang
        TYPE            R8
        DESCRIPTION     "This field specifies the lower limit of the union of 
			 the roll ranges for which reference stars are 
			 available in the fhst identified by fhst_id. "
        UNITS           "DEGREES"
    END_FIELD
 


    FIELD  max_v3_pos_ang
        TYPE            R8
        DESCRIPTION     "This field specifies the upper limit of the union of 
			 the roll ranges for which reference stars are 
			 available in the fhst identified by fhst_id. "
        UNITS           "DEGREES"
    END_FIELD
 
 
END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  wfhst_avail
 
    TYPE             FHSTAVAIL_TYPE
 
    DESCRIPTION      "FHST Availability Data Relation"
 
    SUBSYSTEM_USING  "SPSS"

    INDEX  wfhst_avail_1
        TYPE         clustered
        FIELDS       proposal_id, obset_id, version_num
    END_INDEX

END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
 
INSTANCE  wfhst_avail
 
    GLOBAL
 
    TYPE        FHSTAVAIL_TYPE
 
END_INSTANCE

Go to the top.