!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:    FOFSUB_TABLE.SDDL     
!
! Purpose:      This SDDL file defines the FOFSUB_TABLE relation
!
! Modification History:
!
!   Date       OPR      Who                    Reason
!----------------------------------------------------------------------
! 07/09/98     36119    JSCHULTZ               original
! 12/07/98     37508    Ken S.		Add PNM_name to fofsub table.
! 02/08/99     37507.1  Ken S.		Add sub_create_time to unique index.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE        SQL

RECORD  SUB_TYPE 

!----------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!----------------------------------------------------------------------
!
   DESCRIPTION  "This SDDL file defines the FOFSUB_TABLE relation.  Each record
                 in the relation includes a fof file name, subset file name, 
                 subset file start time, subset file end time, and a subset 
                 file create time.  This table indicates what subset files
                 were generated from what fof files; when the subset files
                 were generated, and the time frame covered by the subset 
                 files."
!  
!----------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!----------------------------------------------------------------------

   FIELD  pnm_name
       TYPE            C*17
       DESCRIPTION     "PNM File Name"
       UNITS
   END_FIELD

   FIELD  fof_name
       TYPE            C*15
       DESCRIPTION     "FOF File Name"
       UNITS
   END_FIELD

   FIELD  sub_name
       TYPE            C*19
       DESCRIPTION     "Subset File Name"
       UNITS
   END_FIELD

   FIELD  sub_start_time
       TYPE            C*22
       DESCRIPTION     "Subset File Start Time in yyyy.ddd:hh:mm:ss.sss"
       UNITS
   END_FIELD

   FIELD  sub_stop_time
       TYPE            C*22
       DESCRIPTION     "Subset File Stop Time in yyyy.ddd:hh:mm:ss.sss"
       UNITS
   END_FIELD

   FIELD  sub_create_time
       TYPE            C*22
       DESCRIPTION     "Subset File Create Time in yyyy.ddd:hh:mm:ss.sss"
       UNITS
   END_FIELD

END_RECORD

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!   RELATION DECLARATION
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

RELATION  fofsub_table

    TYPE            SUB_TYPE

    DESCRIPTION     "A historical account of what Subset Files were generated
                     from what FOF Files and when."

    SUBSYSTEM_USING "OMS"

    INDEX  fofsub_table_1
        TYPE         unique, clustered
        FIELDS       pnm_name, fof_name, sub_name, sub_create_time  
    END_INDEX

    INDEX  fofsub_table_2
        TYPE         nonclustered
        FIELDS       fof_name
    END_INDEX

END_RELATION

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!   INSTANCE DECLARATION
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

INSTANCE  fofsub_table

    GLOBAL

    TYPE        SUB_TYPE

END_INSTANCE