!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    CGG5_DEEPREL.SDDL
!
! Purpose:      This SDDL file defines the CGG5_DEEPREL relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---     -----------------------------------------------
! 06/26/96    28179     Rose    Original implementation
! 01/25/02    42854     Sontag  Added field 'fieldtype' to cgg5_deeprel.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD	DEEPREL_TYPE

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

DESCRIPTION    "This relation is used in OPUS to define which fields are
		used as the keyword and value fields for each deep relation.

		A shallow relation has a single tuple for a particular
		exposure, and usually contains a large number of fields.
		Every time the requirements change for such a relation,
		a new instrument is defined, or a new keyword is needed,
		the relation itself has to change.  Take for example the
		relation qelogsheet.

		A deep relation has, in addition to the key fields which
		are used to join with other relations, only two fields:
		one which specifies the name of the variable, and a second
		which specifies the value of that variable for the particular
		observation.  An example of such a deep relation is qesiparm."

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


    FIELD  relation
        TYPE            C31
	DESCRIPTION	"The name of the relation in the database. 
			 eg: qesiparm"
    END_FIELD

    FIELD  namefield
        TYPE            C31
	DESCRIPTION	"The name of the field in that relation which
			 contains the variable name.  eg: si_par_name"
    END_FIELD

    FIELD  valfield
        TYPE            C31
	DESCRIPTION	"The name of the field in that relation which
			 contains the value of the variable. eg: si_par_value"
    END_FIELD

    FIELD  fieldtype
        TYPE            C31
        DESCRIPTION     "The type of the field in that relation specified
                         by the value of valfield.  Valid values
                         are: int, float, double, string."
        DISCRETE        "int", "float", "double", "string"
    END_FIELD

END_RECORD


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


RELATION  cgg5_deeprel

    TYPE             DEEPREL_TYPE

    DESCRIPTION      "Deep relation fields"

    SUBSYSTEM_USING  "OPUS"

    INDEX  cgg5_deeprel_1
        TYPE         unique, clustered
        FIELDS       relation
    END_INDEX

END_RELATION

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


INSTANCE  cgg5_deeprel

    GLOBAL

    TYPE        DEEPREL_TYPE

END_INSTANCE