!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    PODDANS
!
! Purpose:      This SDDL file defines the PODDANS relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---      ----------------------------------------------
! 07/02/96    28182     Rose     Original implementation
! 02/02/98    34261     WMiller  Increase full_name size to 41
! 08/18/99    39437     MARose   Add indices for dan_seq_no and product_name
! 06/19/02    46030     J.Baum   Add index for full_name
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  PODDANS

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

DESCRIPTION    "This relation preserves critical information from the PACOR/
                DDF Data Availability Notice (DAN) which specifies more
                complete identification information about each POD file
                received sent by the DDF"

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

    FIELD  podname
        TYPE            C23
        DESCRIPTION     "OPUS name of the POD file"
    END_FIELD

    FIELD  dan_seq_no
        TYPE            I4
        DESCRIPTION     "DAN sequence number"
    END_FIELD

    FIELD  product_name
        TYPE            C20
        DESCRIPTION     "DDF name of the product"
    END_FIELD

    FIELD  instance
        TYPE            I2
        DESCRIPTION     "DDF instance of this product"
    END_FIELD

    FIELD  dan_gen
        TYPE            C21
        DESCRIPTION     "DAN generation time"
    END_FIELD

    FIELD  length
        TYPE            I4
        DESCRIPTION     "Number of bytes in the datafile"
    END_FIELD

    FIELD  ddf_num
        TYPE            I2
        DESCRIPTION     "DDF observation id (DCF_NUM)"
    END_FIELD

    FIELD  version
        TYPE      	I2      
        DESCRIPTION	"DDF data version number"
    END_FIELD

    FIELD  full_name
        TYPE            C41
        DESCRIPTION     "Original name of the data file"
    END_FIELD

    FIELD  appended
        TYPE            C17
        DESCRIPTION	"time stamp when this record was appended"
    END_FIELD

END_RECORD

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


RELATION  poddans

    TYPE             PODDANS

    DESCRIPTION      "POD Data Availability Notice information"

    SUBSYSTEM_USING  "OPUS"

    INDEX  poddans_1
        TYPE         nonclustered
        FIELDS       podname
    END_INDEX

    INDEX  poddans_2
        TYPE         nonclustered
        FIELDS       dan_seq_no
    END_INDEX

    INDEX  poddans_3
        TYPE         nonclustered
        FIELDS       product_name
    END_INDEX

    INDEX  poddans_4
        TYPE         nonclustered
        FIELDS       full_name
    END_INDEX

END_RELATION

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


INSTANCE  poddans

    GLOBAL

    TYPE        PODDANS

END_INSTANCE