<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF74'>
/****************************************************************************/
/* GF74 ( QUERY状態ﾃｰﾌﾞﾙ )                                                  */
/*                                                                          */
/* Created : 2017/07/31 15:49:05                                            */
/****************************************************************************/
<EXEC_SQL>
CREATE TABLE GF74 (
   SYSTEM_ID    VARCHAR (   10 )                    NOT NULL                                                                                                            
 , TBLSYU       VARCHAR (    1 )                    NOT NULL                                                                                                            
 , ADDRESS      VARCHAR (  256 )                                                                                                                                        
 , FILENAME     VARCHAR (   60 )                                                                                                                                        
 , FILEPATH     VARCHAR (  256 )                                                                                                                                        
 , MODIFIED     VARCHAR (   14 )                                                                                                                                        
 , TAGNAME      VARCHAR (   30 )                                                                                                                                        
 , CLMS         VARCHAR ( 4000 )                                                                                                                                        
 , TABLEID      VARCHAR (   50 )                                                                                                                                        
 , DBID         VARCHAR (   20 )                                                                                                                                        
 , FGOMIT       VARCHAR (    1 )        DEFAULT '0' NOT NULL                                                                                                            
 , JSP_SCOPE    VARCHAR (   20 )                                                                                                                                        
 , SQL_TEXT     CLOB                                                                                                                                                    
 , SQL_TYPE     VARCHAR (   30 )                                                                                                                                        
 , TABLE_NAMES  VARCHAR ( 4000 )                                                                                                                                        
 , UNIQ         BIGINT                              NOT NULL     generated always as identity (start with 1, increment by 1),constraint GF74 primary key(UNIQ)          
 , FGJ          VARCHAR (    1 )        DEFAULT '1' NOT NULL                                                                                                            
 , DYSET        VARCHAR (   14 )                                                                                                                                        
 , PGSET        VARCHAR (   10 )                                                                                                                                        
 , PGPSET       VARCHAR (   10 )                                                                                                                                        
 , USRSET       VARCHAR (   10 )                                                                                                                                        
 , DYUPD        VARCHAR (   14 )                                                                                                                                        
 , PGUPD        VARCHAR (   10 )                                                                                                                                        
 , PGPUPD       VARCHAR (   10 )                                                                                                                                        
 , USRUPD       VARCHAR (   10 )                                                                                                                                        
)
</EXEC_SQL>


</ROWSET>
