Документ взят из кэша поисковой машины. Адрес оригинального документа : http://www.stsci.edu/spst/lrpg/aux_docs/schema/LRP-SOGS-Database-Schema.html
Дата изменения: Mon Apr 26 17:29:21 1999
Дата индексирования: Sun Mar 2 09:28:07 2014
Кодировка:
Поисковые слова: phoenix
LRP-Relevant SOGS-Database-Schema

LRPG-Relevant SOGS-Database Schema
This document was originally part of a DBSA technical document, http://grendel.sogs.stsci.edu/apsb/doc/spike/technical-reports/ASSIST-Database-Schema.html but has been trimmed and updated to reflect only the portions of the database that concern the LRPG. The original document (Version V) was missing several tables (lrp_unschedulables & lrp_released_cat) and was not up-to-date in reflecting the contents of some of the other tables (plan_windows_status & lrp_track). In addition, that document implied that the constraint_windows_ver table was in ASSIST, when in actuality it is in SOGS.

ijej 97-02-21.

Table of Contents

3.47. constraint_windows_ver

The constraint_windows_ver table contains the SPSS verified constraint windows

constraint_windows_ver schema

-------------------------------------------------------------------------
Field Name    Field Type  Mandatory   Default
Val  Sources of Information  
                          Field       ue                          
         
sunit_id     varchar      y           NULL         from SPSS               
version_num  varchar      y           NULL         from SPSS               
create_date  varchar      y           NULL         from SPSS               
visit_id     varchar      y           NULL         from SPSS               
prop_id      smallint     y           NULL         from SPSS               
wnd_begin    varchar      y           NULL         from SPSS               
wnd_end      varchar      y           NULL         from SPSS               
-------------------------------------------------------------------------
constraint_windows_ver field description 
------------------------------------------
Field Name   Field Description              
wnd_begin   17 character SOGS format field  
wnd_end     17 character SOGS format field  
------------------------------------------