<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF73'>
/****************************************************************************/
/* GF73 ( 使用ｶﾗﾑ状態ﾃｰﾌﾞﾙ )                                                */
/*                                                                          */
/* Created : 2017/07/31 15:49:05                                            */
/****************************************************************************/
<EXEC_SQL>
CREATE TABLE GF73 (
   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 )                                                                                                                                        
 , FORM_TYPE    VARCHAR (   20 )                                                                                                                                        
 , FORM_NAME    VARCHAR (  500 )                                                                                                                                        
 , FORM_VAL     VARCHAR ( 1000 )                                                                                                                                        
 , DEFAULT_VAL  VARCHAR (  100 )                                                                                                                                        
 , LBLCD        VARCHAR (   60 )                                                                                                                                        
 , MSGCD        VARCHAR (   20 )                                                                                                                                        
 , MUST         VARCHAR (   20 )                                                                                                                                        
 , VIEW_SIZE    VARCHAR (   20 )                                                                                                                                        
 , MAX_SIZE     VARCHAR (   20 )                                                                                                                                        
 , CODE_CLM     VARCHAR (   30 )                                                                                                                                        
 , READONLY     VARCHAR (   20 )                                                                                                                                        
 , DISABLED     VARCHAR (   20 )                                                                                                                                        
 , ROLES        VARCHAR (  500 )                                                                                                                                        
 , TEXT_DATA    CLOB                                                                                                                                                    
 , FGOMIT       VARCHAR (    1 )        DEFAULT '0' NOT NULL                                                                                                            
 , UNIQ         BIGINT                              NOT NULL     generated always as identity (start with 1, increment by 1),constraint GF73 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>
