<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF68'>
/****************************************************************************/
/* GF68 ( ﾘｿｰｽ計画ﾜｰｸ )                                                     */
/*                                                                          */
/* Created : 2017/07/31 15:49:05                                            */
/****************************************************************************/
<EXEC_SQL>
CREATE TABLE GF68 (
   RESOURCE_ID  INTEGER                                                                                                                                             
 , SEQ          INTEGER             DEFAULT 0   NOT NULL                                                                                                            
 , DYSTART      VARCHAR (  14 )                                                                                                                                     
 , DYDELAY      DOUBLE                                                                                                                                              
 , DURATION     DOUBLE                                                                                                                                              
 , PRJCODE      VARCHAR (  30 )                                                                                                                                     
 , TASK_ID      INTEGER                                                                                                                                             
 , COMPLETE     INTEGER                                                                                                                                             
 , FGTASK       VARCHAR (   1 )                                                                                                                                     
 , VAL1         VARCHAR ( 100 )                                                                                                                                     
 , VAL2         VARCHAR ( 100 )                                                                                                                                     
 , VAL3         VARCHAR ( 100 )                                                                                                                                     
 , VAL4         VARCHAR ( 100 )                                                                                                                                     
 , VAL5         VARCHAR ( 100 )                                                                                                                                     
 , UNIQ         BIGINT                          NOT NULL     generated always as identity (start with 1, increment by 1),constraint GF68 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>
