
if exists (select 1
            from  sysindexes
           where  id    = object_id('ST_REPCACHE')
            and   name  = 'repcachekey'
            and   indid > 0
            and   indid < 255)
   drop index ST_REPCACHE.repcachekey
go


if exists (select 1
            from  sysindexes
           where  id    = object_id('ST_SRCACHE')
            and   name  = 'srCacheKey'
            and   indid > 0
            and   indid < 255)
   drop index ST_SRCACHE.srCacheKey
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CATEGORY')
            and   type = 'U')
   drop table ST_CATEGORY
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CHECKFUNC')
            and   type = 'U')
   drop table ST_CHECKFUNC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_COLINFO')
            and   type = 'U')
   drop table ST_COLINFO
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CRCOLGRP')
            and   type = 'U')
   drop table ST_CRCOLGRP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CRCOLSUMHD')
            and   type = 'U')
   drop table ST_CRCOLSUMHD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CRFIELD')
            and   type = 'U')
   drop table ST_CRFIELD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CRGRP')
            and   type = 'U')
   drop table ST_CRGRP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CRGRPDT')
            and   type = 'U')
   drop table ST_CRGRPDT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CRGRPSUM')
            and   type = 'U')
   drop table ST_CRGRPSUM
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CRGRPSUMFIELD')
            and   type = 'U')
   drop table ST_CRGRPSUMFIELD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CROSSREP')
            and   type = 'U')
   drop table ST_CROSSREP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CRSUM')
            and   type = 'U')
   drop table ST_CRSUM
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_CRSUMFIELD')
            and   type = 'U')
   drop table ST_CRSUMFIELD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DBOPRESMAP')
            and   type = 'U')
   drop table ST_DBOPRESMAP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DBRES')
            and   type = 'U')
   drop table ST_DBRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DELEXPOP')
            and   type = 'U')
   drop table ST_DELEXPOP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DELLINKOP')
            and   type = 'U')
   drop table ST_DELLINKOP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DELRES')
            and   type = 'U')
   drop table ST_DELRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DELSVRCHECK')
            and   type = 'U')
   drop table ST_DELSVRCHECK
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DEPT')
            and   type = 'U')
   drop table ST_DEPT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DIC')
            and   type = 'U')
   drop table ST_DIC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DICGRP')
            and   type = 'U')
   drop table ST_DICGRP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DYNADICRES')
            and   type = 'U')
   drop table ST_DYNADICRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_DYNADICSUBRES')
            and   type = 'U')
   drop table ST_DYNADICSUBRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_EJBINFO')
            and   type = 'U')
   drop table ST_EJBINFO
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_ERRLOG')
            and   type = 'U')
   drop table ST_ERRLOG
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_FORMDT')
            and   type = 'U')
   drop table ST_FORMDT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_FORMELEM')
            and   type = 'U')
   drop table ST_FORMELEM
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_FORMFUNC')
            and   type = 'U')
   drop table ST_FORMFUNC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_FORMJSCSS')
            and   type = 'U')
   drop table ST_FORMJSCSS
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_FORMJSEVENT')
            and   type = 'U')
   drop table ST_FORMJSEVENT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_FORMRES')
            and   type = 'U')
   drop table ST_FORMRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_FORMTABPAGE')
            and   type = 'U')
   drop table ST_FORMTABPAGE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_FRAME')
            and   type = 'U')
   drop table ST_FRAME
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_FRAMESET')
            and   type = 'U')
   drop table ST_FRAMESET
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_INSCOLINFO')
            and   type = 'U')
   drop table ST_INSCOLINFO
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_INSDT')
            and   type = 'U')
   drop table ST_INSDT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_INSEXPOP')
            and   type = 'U')
   drop table ST_INSEXPOP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_INSFUNC')
            and   type = 'U')
   drop table ST_INSFUNC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_INSJSCSS')
            and   type = 'U')
   drop table ST_INSJSCSS
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_INSJSEVENT')
            and   type = 'U')
   drop table ST_INSJSEVENT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_INSLINKOP')
            and   type = 'U')
   drop table ST_INSLINKOP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_INSRES')
            and   type = 'U')
   drop table ST_INSRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_INSSVRCHECK')
            and   type = 'U')
   drop table ST_INSSVRCHECK
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_INSTABPAGE')
            and   type = 'U')
   drop table ST_INSTABPAGE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_LOGONLOG')
            and   type = 'U')
   drop table ST_LOGONLOG
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MDBOPDT')
            and   type = 'U')
   drop table ST_MDBOPDT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MDBOPFUNC')
            and   type = 'U')
   drop table ST_MDBOPFUNC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MDBOPJSCSS')
            and   type = 'U')
   drop table ST_MDBOPJSCSS
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MDBOPJSEVENT')
            and   type = 'U')
   drop table ST_MDBOPJSEVENT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MDBOPRES')
            and   type = 'U')
   drop table ST_MDBOPRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MDBOPSUBRES')
            and   type = 'U')
   drop table ST_MDBOPSUBRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MODULE')
            and   type = 'U')
   drop table ST_MODULE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MVCACTION')
            and   type = 'U')
   drop table ST_MVCACTION
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MVCCHECK')
            and   type = 'U')
   drop table ST_MVCCHECK
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MVCEXPOP')
            and   type = 'U')
   drop table ST_MVCEXPOP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MVCGURL')
            and   type = 'U')
   drop table ST_MVCGURL
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MVCMODEL')
            and   type = 'U')
   drop table ST_MVCMODEL
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MVCOPCTRL')
            and   type = 'U')
   drop table ST_MVCOPCTRL
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MVCRST')
            and   type = 'U')
   drop table ST_MVCRST
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_MVCURL')
            and   type = 'U')
   drop table ST_MVCURL
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_PERMISSION')
            and   type = 'U')
   drop table ST_PERMISSION
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_QUICKMOD')
            and   type = 'U')
   drop table ST_QUICKMOD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REFDICRES')
            and   type = 'U')
   drop table ST_REFDICRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REGION')
            and   type = 'U')
   drop table ST_REGION
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPAPPLY')
            and   type = 'U')
   drop table ST_REPAPPLY
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPCACHE')
            and   type = 'U')
   drop table ST_REPCACHE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPCHART')
            and   type = 'U')
   drop table ST_REPCHART
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPCHARTAXIS')
            and   type = 'U')
   drop table ST_REPCHARTAXIS
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPCHECK')
            and   type = 'U')
   drop table ST_REPCHECK
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPCHECKITEM')
            and   type = 'U')
   drop table ST_REPCHECKITEM
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPCND')
            and   type = 'U')
   drop table ST_REPCND
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPCNDREM')
            and   type = 'U')
   drop table ST_REPCNDREM
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPCNDSVRCHECK')
            and   type = 'U')
   drop table ST_REPCNDSVRCHECK
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPDT')
            and   type = 'U')
   drop table ST_REPDT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPEXP')
            and   type = 'U')
   drop table ST_REPEXP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPEXPORTTPL')
            and   type = 'U')
   drop table ST_REPEXPORTTPL
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPFIELD')
            and   type = 'U')
   drop table ST_REPFIELD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPFUNC')
            and   type = 'U')
   drop table ST_REPFUNC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPGRIDHD')
            and   type = 'U')
   drop table ST_REPGRIDHD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPGRIDHDFIELD')
            and   type = 'U')
   drop table ST_REPGRIDHDFIELD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPGRP')
            and   type = 'U')
   drop table ST_REPGRP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPGRPDT')
            and   type = 'U')
   drop table ST_REPGRPDT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPGRPSUM')
            and   type = 'U')
   drop table ST_REPGRPSUM
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPGRPSUMFIELD')
            and   type = 'U')
   drop table ST_REPGRPSUMFIELD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPHDFT')
            and   type = 'U')
   drop table ST_REPHDFT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPJSCSS')
            and   type = 'U')
   drop table ST_REPJSCSS
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPJSEVENT')
            and   type = 'U')
   drop table ST_REPJSEVENT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPORT')
            and   type = 'U')
   drop table ST_REPORT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPPRT')
            and   type = 'U')
   drop table ST_REPPRT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPSCHEDULE')
            and   type = 'U')
   drop table ST_REPSCHEDULE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPSUM')
            and   type = 'U')
   drop table ST_REPSUM
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPSUMFIELD')
            and   type = 'U')
   drop table ST_REPSUMFIELD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPTREE')
            and   type = 'U')
   drop table ST_REPTREE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPTREEEXTNODE')
            and   type = 'U')
   drop table ST_REPTREEEXTNODE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_REPUNITFUNC')
            and   type = 'U')
   drop table ST_REPUNITFUNC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_RGPARAM')
            and   type = 'U')
   drop table ST_RGPARAM
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_ROLE')
            and   type = 'U')
   drop table ST_ROLE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_ROLEPERMISSION')
            and   type = 'U')
   drop table ST_ROLEPERMISSION
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SEQUENCE')
            and   type = 'U')
   drop table ST_SEQUENCE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SFNODE')
            and   type = 'U')
   drop table ST_SFNODE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SIMPLEFLOW')
            and   type = 'U')
   drop table ST_SIMPLEFLOW
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SQLLOG')
            and   type = 'U')
   drop table ST_SQLLOG
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SQLLOGSET')
            and   type = 'U')
   drop table ST_SQLLOGSET
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SRBODYCELL')
            and   type = 'U')
   drop table ST_SRBODYCELL
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SRCACHE')
            and   type = 'U')
   drop table ST_SRCACHE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SRCOLUMN')
            and   type = 'U')
   drop table ST_SRCOLUMN
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SRGRIDHD')
            and   type = 'U')
   drop table ST_SRGRIDHD
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SRGRIDHDCOL')
            and   type = 'U')
   drop table ST_SRGRIDHDCOL
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SRHDFT')
            and   type = 'U')
   drop table ST_SRHDFT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SRROW')
            and   type = 'U')
   drop table ST_SRROW
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_STRDIC')
            and   type = 'U')
   drop table ST_STRDIC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_STRDICGRP')
            and   type = 'U')
   drop table ST_STRDICGRP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SUBREP')
            and   type = 'U')
   drop table ST_SUBREP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SUBSEQ')
            and   type = 'U')
   drop table ST_SUBSEQ
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SUBSYS')
            and   type = 'U')
   drop table ST_SUBSYS
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SUMMARYREP')
            and   type = 'U')
   drop table ST_SUMMARYREP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SYSPARAM')
            and   type = 'U')
   drop table ST_SYSPARAM
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_SYSUSER')
            and   type = 'U')
   drop table ST_SYSUSER
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_TABFUNC')
            and   type = 'U')
   drop table ST_TABFUNC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_TABJSCSS')
            and   type = 'U')
   drop table ST_TABJSCSS
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_TABPAGE')
            and   type = 'U')
   drop table ST_TABPAGE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_TABRES')
            and   type = 'U')
   drop table ST_TABRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_TBLINFO')
            and   type = 'U')
   drop table ST_TBLINFO
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPDCOLINFO')
            and   type = 'U')
   drop table ST_UPDCOLINFO
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPDDT')
            and   type = 'U')
   drop table ST_UPDDT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPDEXPOP')
            and   type = 'U')
   drop table ST_UPDEXPOP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPDFUNC')
            and   type = 'U')
   drop table ST_UPDFUNC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPDJSCSS')
            and   type = 'U')
   drop table ST_UPDJSCSS
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPDJSEVENT')
            and   type = 'U')
   drop table ST_UPDJSEVENT
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPDLINKOP')
            and   type = 'U')
   drop table ST_UPDLINKOP
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPDRES')
            and   type = 'U')
   drop table ST_UPDRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPDSVRCHECK')
            and   type = 'U')
   drop table ST_UPDSVRCHECK
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPDTABPAGE')
            and   type = 'U')
   drop table ST_UPDTABPAGE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_UPLOADRES')
            and   type = 'U')
   drop table ST_UPLOADRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_URLRES')
            and   type = 'U')
   drop table ST_URLRES
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_USEREXPFUNC')
            and   type = 'U')
   drop table ST_USEREXPFUNC
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_USERROLE')
            and   type = 'U')
   drop table ST_USERROLE
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_USERSUBSYS')
            and   type = 'U')
   drop table ST_USERSUBSYS
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_WGUSER')
            and   type = 'U')
   drop table ST_WGUSER
go


if exists (select 1
            from  sysobjects
           where  id = object_id('ST_WORKGROUP')
            and   type = 'U')
   drop table ST_WORKGROUP
go


/*==============================================================*/
/* Table: ST_CATEGORY                                           */
/*==============================================================*/
create table ST_CATEGORY (
CATID                decimal(6)           not null,
SUPERCAT             decimal(6)           not null,
CATTITLE             varchar(60)          not null,
DISPNO               decimal(6)           not null,
ISTOPMENU            decimal(4)           not null,
CLOSEICON            varchar(100)         null,
OPENICON             varchar(100)         null,
REMARK               varchar(100)         null,
constraint PK_ST_CATEGORY primary key  (CATID)
)
go


/*==============================================================*/
/* Table: ST_CHECKFUNC                                          */
/*==============================================================*/
create table ST_CHECKFUNC (
SUBSYS               varchar(12)          not null,
FUNCNAME             varchar(30)          not null,
FUNCDESC             varchar(80)          not null,
REMARK               varchar(255)         null,
constraint PK_ST_CHECKFUNC primary key  (SUBSYS, FUNCNAME)
)
go


/*==============================================================*/
/* Table: ST_COLINFO                                            */
/*==============================================================*/
create table ST_COLINFO (
SUBSYS               varchar(12)          not null,
TBLNAME              varchar(40)          not null,
COLNAME              varchar(40)          not null,
DISPNO               decimal(4)           not null,
COLDESC              varchar(100)         not null,
JTYPE                decimal(4)           not null,
ISPKEY               decimal(4)           not null,
ISNULLABLE           decimal(4)           not null,
DICKIND              decimal(4)           not null,
DICSUBSYS            varchar(12)          null,
DICSUBKIND           decimal(6)           null,
DICGRPID             varchar(40)          null,
VALDICCOL            decimal(4)           null,
POPDICURL            varchar(500)         null,
INSVALEXP            varchar(255)         null,
DISPFORMAT           varchar(30)          null,
TAGTYPE              decimal(4)           not null,
COLSIZE              decimal(10)          not null,
DECDIGITS            decimal(4)           null,
MINLEN               decimal(4)           null,
MAXVAL               decimal              null,
MINVAL               decimal              null,
CHECKFUNC            varchar(30)          null,
DISPLEN              decimal(4)           not null,
ROWSIZE              decimal(4)           null,
TAGSTYLE             varchar(255)         null,
COLINFO              varchar(255)         null,
constraint PK_ST_COLINFO primary key  (SUBSYS, TBLNAME, COLNAME)
)
go


/*==============================================================*/
/* Table: ST_CRCOLGRP                                           */
/*==============================================================*/
create table ST_CRCOLGRP (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
GRPLEVEL             decimal(4)           not null,
GRPCRFIELDS          varchar(100)         not null,
SUMCRFIELDS          varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_CRCOLGRP primary key  (SUBSYS, REPID, GRPLEVEL)
)
go


/*==============================================================*/
/* Table: ST_CRCOLSUMHD                                         */
/*==============================================================*/
create table ST_CRCOLSUMHD (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
SUMCRFIELDID         varchar(40)          not null,
COLCRFIELDID         varchar(40)          not null,
HEADEXP              varchar(100)         not null,
ISHMERGE             decimal(4)           not null,
ISVMERGE             decimal(4)           not null,
TDSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_CRCOLSUMHD primary key  (SUBSYS, REPID, SUMCRFIELDID, COLCRFIELDID)
)
go


/*==============================================================*/
/* Table: ST_CRFIELD                                            */
/*==============================================================*/
create table ST_CRFIELD (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
CRFIELDID            varchar(40)          not null,
CRFIELDTYPE          decimal(4)           not null,
CRFIELDNO            decimal(4)           not null,
JTYPE                decimal(4)           not null,
HEADEXP              varchar(100)         null,
DATAEXP              varchar(255)         not null,
DISPEXP              varchar(255)         null,
DISPFORMAT           varchar(30)          null,
ISHDHMERGE           decimal(4)           not null,
ISVMERGE             decimal(4)           not null,
ISHMERGE             decimal(4)           not null,
ISEDIT               decimal(4)           not null,
DISPLEN              decimal(4)           null,
ISTAGVALUE           decimal(4)           not null,
SUMDISPPOS           decimal(4)           not null,
ISONEIGNSUM          decimal(4)           not null,
LINKTARGET           varchar(20)          null,
LINKURL              varchar(500)         null,
PARAMCRFIELDS        varchar(100)         null,
QUERYINFO            varchar(255)         null,
HEADTDSTYLE          varchar(255)         null,
DATATDSTYLE          varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_CRFIELD primary key  (SUBSYS, REPID, CRFIELDID)
)
go


/*==============================================================*/
/* Table: ST_CRGRP                                              */
/*==============================================================*/
create table ST_CRGRP (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
GRPLEVEL             decimal(4)           not null,
GRPCRFIELDS          varchar(100)         not null,
ISBREAK              decimal(4)           not null,
ISNEWPAGE            decimal(4)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_CRGRP primary key  (SUBSYS, REPID, GRPLEVEL)
)
go


/*==============================================================*/
/* Table: ST_CRGRPDT                                            */
/*==============================================================*/
create table ST_CRGRPDT (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
GRPLEVEL             decimal(4)           not null,
DTTYPE               decimal(4)           not null,
DTCONT               text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_CRGRPDT primary key  (SUBSYS, REPID, GRPLEVEL, DTTYPE)
)
go


/*==============================================================*/
/* Table: ST_CRGRPSUM                                           */
/*==============================================================*/
create table ST_CRGRPSUM (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
GRPLEVEL             decimal(4)           not null,
SUMID                varchar(20)          not null,
DISPNO               decimal(4)           not null,
DISPPOS              decimal(4)           not null,
ISONEIGN             decimal(4)           not null,
TRSTYLE              varchar(255)         null,
SUMDESC              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_CRGRPSUM primary key  (SUBSYS, REPID, GRPLEVEL, SUMID)
)
go


/*==============================================================*/
/* Table: ST_CRGRPSUMFIELD                                      */
/*==============================================================*/
create table ST_CRGRPSUMFIELD (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
GRPLEVEL             decimal(4)           not null,
SUMID                varchar(20)          not null,
CRFIELDID            varchar(40)          not null,
SUMEXP               varchar(255)         not null,
DISPFORMAT           varchar(30)          null,
ISMERGEBLK           decimal(4)           not null,
TDSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_CRGRPSUMFIELD primary key  (SUBSYS, REPID, GRPLEVEL, SUMID, CRFIELDID)
)
go


/*==============================================================*/
/* Table: ST_CROSSREP                                           */
/*==============================================================*/
create table ST_CROSSREP (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
ISSORTED             decimal(4)           not null,
ISSHOWCOLHD          decimal(4)           not null,
ROWHDEXP             varchar(255)         null,
SORTCRFIELDS         varchar(255)         null,
TBLSTYLE             varchar(255)         null,
COLHDTRSTYLE         varchar(255)         null,
HDTRSTYLE            varchar(255)         null,
DATATRSTYLE          varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_CROSSREP primary key  (SUBSYS, REPID)
)
go


/*==============================================================*/
/* Table: ST_CRSUM                                              */
/*==============================================================*/
create table ST_CRSUM (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
SUMID                varchar(20)          not null,
DISPNO               decimal(4)           not null,
DISPPOS              decimal(4)           not null,
ISONEIGN             decimal(4)           not null,
TRSTYLE              varchar(255)         null,
SUMDESC              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_CRSUM primary key  (SUBSYS, REPID, SUMID)
)
go


/*==============================================================*/
/* Table: ST_CRSUMFIELD                                         */
/*==============================================================*/
create table ST_CRSUMFIELD (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
SUMID                varchar(20)          not null,
CRFIELDID            varchar(40)          not null,
SUMEXP               varchar(255)         not null,
DISPFORMAT           varchar(30)          null,
ISMERGEBLK           decimal(4)           not null,
TDSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_CRSUMFIELD primary key  (SUBSYS, REPID, SUMID, CRFIELDID)
)
go


/*==============================================================*/
/* Table: ST_DBOPRESMAP                                         */
/*==============================================================*/
create table ST_DBOPRESMAP (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
DBOPTYPE             decimal(4)           not null,
RESID                varchar(20)          not null,
REMARK               varchar(255)         null,
constraint PK_ST_DBOPRESMAP primary key  (SUBSYS, REPID, DBOPTYPE)
)
go


/*==============================================================*/
/* Table: ST_DBRES                                              */
/*==============================================================*/
create table ST_DBRES (
DBRESID              varchar(12)          not null,
DBRESDESC            varchar(40)          not null,
DBTYPE               decimal(4)           not null,
READENC              varchar(40)          null,
WRITEENC             varchar(40)          null,
CONNTYPE             decimal(4)           not null,
FACTORY              varchar(100)         null,
PROVIDER             varchar(100)         null,
URLPKGS              varchar(100)         null,
JNDIOPTIONS          varchar(255)         null,
DSJNDI               varchar(50)          null,
DRIVER               varchar(50)          null,
DBURL                varchar(100)         null,
DBUSER               varchar(20)          null,
PASSWD               varchar(100)         null,
CONNLISTENER         varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_DBRES primary key  (DBRESID)
)
go


/*==============================================================*/
/* Table: ST_DELEXPOP                                           */
/*==============================================================*/
create table ST_DELEXPOP (
SUBSYS               varchar(12)          not null,
DELETEID             varchar(20)          not null,
EXECNO               decimal(4)           not null,
EXECPOS              decimal(4)           not null,
EXECCND              varchar(255)         null,
EXPCONT              varchar(255)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_DELEXPOP primary key  (SUBSYS, DELETEID, EXECNO)
)
go


/*==============================================================*/
/* Table: ST_DELLINKOP                                          */
/*==============================================================*/
create table ST_DELLINKOP (
SUBSYS               varchar(12)          not null,
DELETEID             varchar(20)          not null,
EXECNO               decimal(4)           not null,
EXECPOS              decimal(4)           not null,
EXECCND              varchar(500)         null,
TARGETSUBSYS         varchar(12)          null,
SCRIPTTYPE           decimal(4)           not null,
SCRIPTCONT           varchar(2000)        not null,
PARAMEXPS            varchar(1000)        null,
REMARK               varchar(255)         null,
constraint PK_ST_DELLINKOP primary key  (SUBSYS, DELETEID, EXECNO)
)
go


/*==============================================================*/
/* Table: ST_DELRES                                             */
/*==============================================================*/
create table ST_DELRES (
SUBSYS               varchar(12)          not null,
DELETEID             varchar(20)          not null,
DELTYPE              decimal(4)           not null,
RESDESC              varchar(100)         not null,
RESOBJ               varchar(100)         not null,
ISACTRL              decimal(4)           not null,
PERMISSIONID         decimal(6)           null,
ISCHKRST             decimal(4)           not null,
NEXTURL              varchar(500)         null,
APPENDCND            varchar(255)         null,
DELHANDLER           varchar(100)         null,
BUSICLASSTYPE        decimal(4)           null,
BUSICLASS            varchar(100)         null,
BUSIMETHOD           varchar(255)         null,
BUSIPARAMS           varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_DELRES primary key  (SUBSYS, DELETEID)
)
go


/*==============================================================*/
/* Table: ST_DELSVRCHECK                                        */
/*==============================================================*/
create table ST_DELSVRCHECK (
SUBSYS               varchar(12)          not null,
DELETEID             varchar(20)          not null,
CHECKNO              decimal(4)           not null,
CHECKEXP             varchar(255)         not null,
ERRINFO              varchar(255)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_DELSVRCHECK primary key  (SUBSYS, DELETEID, CHECKNO)
)
go


/*==============================================================*/
/* Table: ST_DEPT                                               */
/*==============================================================*/
create table ST_DEPT (
RGID                 varchar(30)          not null,
DEPTID               varchar(30)          not null,
DEPTNAME             varchar(40)          not null,
DEPTLEVEL            decimal(4)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_DEPT primary key  (DEPTID)
)
go


/*==============================================================*/
/* Table: ST_DIC                                                */
/*==============================================================*/
create table ST_DIC (
SUBSYS               varchar(12)          not null,
DICGRPID             decimal(4)           not null,
DICID                decimal(4)           not null,
DICDESC              varchar(100)         not null,
REMARK               varchar(100)         null,
constraint PK_ST_DIC primary key  (SUBSYS, DICGRPID, DICID)
)
go


/*==============================================================*/
/* Table: ST_DICGRP                                             */
/*==============================================================*/
create table ST_DICGRP (
SUBSYS               varchar(12)          not null,
DICGRPID             decimal(4)           not null,
ISSYSDIC             decimal(4)           not null,
DDDESCTYPE           decimal(4)           not null,
GRPDESC              varchar(100)         null,
REMARK               varchar(100)         null,
constraint PK_ST_DICGRP primary key  (SUBSYS, DICGRPID)
)
go


/*==============================================================*/
/* Table: ST_DYNADICRES                                         */
/*==============================================================*/
create table ST_DYNADICRES (
SUBSYS               varchar(12)          not null,
DICSUBKIND           decimal(6)           not null,
SUBKINDDESC          varchar(40)          not null,
REMARK               varchar(255)         null,
constraint PK_ST_DYNADICRES primary key  (SUBSYS, DICSUBKIND)
)
go


/*==============================================================*/
/* Table: ST_DYNADICSUBRES                                      */
/*==============================================================*/
create table ST_DYNADICSUBRES (
SUBSYS               varchar(12)          not null,
DICSUBKIND           decimal(6)           not null,
SUBDICNO             decimal(4)           not null,
SUBDICDESC           varchar(40)          not null,
DRSUBSYS             varchar(12)          null,
DRREPID              decimal(6)           not null,
REMARK               varchar(100)         null,
constraint PK_ST_DYNADICSUBRES primary key  (SUBSYS, DICSUBKIND, SUBDICNO)
)
go


/*==============================================================*/
/* Table: ST_EJBINFO                                            */
/*==============================================================*/
create table ST_EJBINFO (
SUBSYS               varchar(12)          not null,
REMOTE               varchar(100)         not null,
HOME                 varchar(100)         not null,
BEAN                 varchar(100)         not null,
EJBJNDI              varchar(100)         not null,
FACTORY              varchar(100)         null,
PROVIDER             varchar(100)         null,
URLPKGS              varchar(100)         null,
JNDIOPTIONS          varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_EJBINFO primary key  (REMOTE)
)
go


/*==============================================================*/
/* Table: ST_ERRLOG                                             */
/*==============================================================*/
create table ST_ERRLOG (
LOGID                decimal(14)          not null,
USERID               varchar(20)          null,
ERRTIME              datetime             null,
ERRTYPE              varchar(100)         null,
ERRINFO              varchar(255)         null,
DETAIL               text                 null,
constraint PK_ST_ERRLOG primary key  (LOGID)
)
go


/*==============================================================*/
/* Table: ST_FORMDT                                             */
/*==============================================================*/
create table ST_FORMDT (
SUBSYS               varchar(12)          not null,
FORMID               decimal(5)           not null,
DTTYPE               decimal(4)           not null,
DTCONT               text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_FORMDT primary key  (SUBSYS, FORMID, DTTYPE)
)
go


/*==============================================================*/
/* Table: ST_FORMELEM                                           */
/*==============================================================*/
create table ST_FORMELEM (
SUBSYS               varchar(12)          not null,
FORMID               decimal(5)           not null,
ELEMTAGNAME          varchar(40)          not null,
DISPNO               decimal(4)           not null,
ELEMDESC             varchar(40)          not null,
ELEMTAGID            varchar(40)          null,
JTYPE                decimal(4)           not null,
ISNULLABLE           decimal(4)           not null,
DICKIND              decimal(4)           not null,
DICSUBSYS            varchar(12)          null,
DICSUBKIND           decimal(6)           null,
DICGRPID             varchar(30)          null,
VALDICCOL            decimal(4)           null,
DISPFORMAT           varchar(30)          null,
TAGTYPE              decimal(4)           not null,
ISDISPONLY           decimal(4)           not null,
DISPLEN              decimal(4)           not null,
ROWSIZE              decimal(4)           null,
MAXLEN               decimal(6)           null,
MINLEN               decimal(6)           null,
MAXVAL               decimal              null,
MINVAL               decimal              null,
CHECKFUNC            varchar(30)          null,
POPDICURL            varchar(500)         null,
TAGSTYLE             varchar(255)         null,
INITVALEXPS          varchar(255)         null,
JSEVENT              varchar(255)         null,
ELEMINFO             varchar(255)         null,
constraint PK_ST_FORMELEM primary key  (SUBSYS, FORMID, ELEMTAGNAME)
)
go


/*==============================================================*/
/* Table: ST_FORMFUNC                                           */
/*==============================================================*/
create table ST_FORMFUNC (
SUBSYS               varchar(12)          not null,
FORMID               decimal(5)           not null,
FUNCID               varchar(30)          not null,
DISPNAME             varchar(30)          not null,
DISPNO               decimal(4)           not null,
DISPPOS              decimal(4)           not null,
FUNCTYPE             decimal(4)           not null,
FUNCURL              varchar(500)         null,
TARGET               varchar(30)          null,
LINKPID              decimal(6)           null,
DISPCND              varchar(255)         null,
QUERYINFO            varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_FORMFUNC primary key  (SUBSYS, FORMID, FUNCID)
)
go


/*==============================================================*/
/* Table: ST_FORMJSCSS                                          */
/*==============================================================*/
create table ST_FORMJSCSS (
SUBSYS               varchar(12)          not null,
FORMID               decimal(5)           not null,
JSCSSNO              decimal(2)           not null,
JSCSS                varchar(2000)        not null,
REMARK               varchar(255)         null,
constraint PK_ST_FORMJSCSS primary key  (SUBSYS, FORMID, JSCSSNO)
)
go


/*==============================================================*/
/* Table: ST_FORMJSEVENT                                        */
/*==============================================================*/
create table ST_FORMJSEVENT (
SUBSYS               varchar(12)          not null,
FORMID               decimal(5)           not null,
EVENTTYPE            decimal(4)           not null,
JSFUNC               varchar(100)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_FORMJSEVENT primary key  (SUBSYS, FORMID, EVENTTYPE)
)
go


/*==============================================================*/
/* Table: ST_FORMRES                                            */
/*==============================================================*/
create table ST_FORMRES (
SUBSYS               varchar(12)          not null,
FORMID               decimal(5)           not null,
FORMTAGNAME          varchar(30)          not null,
FORMDESC             varchar(50)          not null,
ISACTRL              decimal(4)           not null,
PERMISSIONID         decimal(6)           null,
ISSYSFMENU           decimal(4)           not null,
FORMTAGID            varchar(30)          null,
FORMMETHOD           decimal(4)           not null,
FORMTYPE             decimal(4)           not null,
FORMACTION           varchar(255)         not null,
FORMTARGET           varchar(30)          null,
ISBATCH              decimal(4)           not null,
PUBELEMS             varchar(255)         null,
ARRAYFMT             varchar(2000)        null,
DISPSTYLE            varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_FORMRES primary key  (SUBSYS, FORMID)
)
go


/*==============================================================*/
/* Table: ST_FORMTABPAGE                                        */
/*==============================================================*/
create table ST_FORMTABPAGE (
SUBSYS               varchar(12)          not null,
FORMID               decimal(5)           not null,
PAGENO               decimal(2)           not null,
PAGETITLE            varchar(40)          not null,
ARRAYFMT             varchar(500)         null,
PAGEDT               text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_FORMTABPAGE primary key  (SUBSYS, FORMID, PAGENO)
)
go


/*==============================================================*/
/* Table: ST_FRAME                                              */
/*==============================================================*/
create table ST_FRAME (
SUBSYS               varchar(12)          not null,
FRAMESETID           decimal(5)           not null,
FRAMEID              varchar(20)          not null,
DISPNO               decimal(5)           not null,
FRAMEDESC            varchar(50)          not null,
TAGID                varchar(20)          null,
TAGNAME              varchar(20)          not null,
FRAMEURL             varchar(255)         null,
ISBORDER             decimal(5)           null,
ISRESIZE             decimal(5)           not null,
ISREDUCE             decimal(5)           not null,
MINSIZE              decimal(3)           null,
SCROLLTYPE           decimal(5)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_FRAME primary key  (SUBSYS, FRAMESETID, FRAMEID)
)
go


/*==============================================================*/
/* Table: ST_FRAMESET                                           */
/*==============================================================*/
create table ST_FRAMESET (
SUBSYS               varchar(12)          not null,
FRAMESETID           decimal(5)           not null,
FRAMESETDESC         varchar(50)          not null,
TAGID                varchar(20)          null,
DISPTYPE             decimal(5)           not null,
ROWSCOLS             varchar(40)          not null,
REMARK               varchar(255)         null,
constraint PK_ST_FRAMESET primary key  (SUBSYS, FRAMESETID)
)
go


/*==============================================================*/
/* Table: ST_INSCOLINFO                                         */
/*==============================================================*/
create table ST_INSCOLINFO (
SUBSYS               varchar(12)          not null,
INSERTID             varchar(20)          not null,
COLNAME              varchar(40)          not null,
COLDESC              varchar(40)          null,
ISNULLABLE           decimal(4)           null,
TAGTYPE              decimal(4)           null,
DISPFORMAT           varchar(100)         null,
DISPLEN              decimal(8)           null,
ROWSIZE              decimal(4)           null,
CHECKFUNC            varchar(30)          null,
POPDICURL            varchar(500)         null,
TAGSTYLE             varchar(255)         null,
INITEXP              varchar(500)         null,
SAVEEXP              varchar(500)         null,
JSEVENT              varchar(255)         null,
constraint PK_ST_INSCOLINFO primary key  (SUBSYS, INSERTID, COLNAME)
)
go


/*==============================================================*/
/* Table: ST_INSDT                                              */
/*==============================================================*/
create table ST_INSDT (
SUBSYS               varchar(12)          not null,
INSERTID             varchar(20)          not null,
DTTYPE               decimal(4)           not null,
DTCONT               text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_INSDT primary key  (SUBSYS, INSERTID, DTTYPE)
)
go


/*==============================================================*/
/* Table: ST_INSEXPOP                                           */
/*==============================================================*/
create table ST_INSEXPOP (
SUBSYS               varchar(12)          not null,
INSERTID             varchar(20)          not null,
EXECNO               decimal(4)           not null,
EXECPOS              decimal(4)           not null,
EXECCND              varchar(255)         null,
EXPCONT              varchar(255)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_INSEXPOP primary key  (SUBSYS, INSERTID, EXECNO)
)
go


/*==============================================================*/
/* Table: ST_INSFUNC                                            */
/*==============================================================*/
create table ST_INSFUNC (
SUBSYS               varchar(12)          not null,
INSERTID             varchar(20)          not null,
FUNCID               varchar(20)          not null,
DISPNAME             varchar(100)         not null,
DISPNO               decimal(2)           null,
DISPPOS              decimal(4)           not null,
FUNCTYPE             decimal(4)           not null,
FUNCURL              varchar(500)         null,
URLCOLS              varchar(255)         null,
TARGET               varchar(30)          null,
LINKPID              decimal(6)           null,
DISPCND              varchar(255)         null,
QUERYINFO            varchar(255)         null,
FUNCINFO             varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_INSFUNC primary key  (SUBSYS, INSERTID, FUNCID)
)
go


/*==============================================================*/
/* Table: ST_INSJSCSS                                           */
/*==============================================================*/
create table ST_INSJSCSS (
SUBSYS               varchar(12)          not null,
INSERTID             varchar(20)          not null,
JSCSSNO              decimal(4)           not null,
JSCSS                varchar(2000)        not null,
REMARK               varchar(255)         null,
constraint PK_ST_INSJSCSS primary key  (SUBSYS, INSERTID, JSCSSNO)
)
go


/*==============================================================*/
/* Table: ST_INSJSEVENT                                         */
/*==============================================================*/
create table ST_INSJSEVENT (
SUBSYS               varchar(12)          not null,
INSERTID             varchar(20)          not null,
EVENTTYPE            decimal(4)           not null,
JSFUNC               varchar(100)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_INSJSEVENT primary key  (SUBSYS, INSERTID, EVENTTYPE)
)
go


/*==============================================================*/
/* Table: ST_INSLINKOP                                          */
/*==============================================================*/
create table ST_INSLINKOP (
SUBSYS               varchar(12)          not null,
INSERTID             varchar(20)          not null,
EXECNO               decimal(4)           not null,
EXECPOS              decimal(4)           not null,
EXECCND              varchar(500)         null,
TARGETSUBSYS         varchar(12)          null,
SCRIPTTYPE           decimal(4)           not null,
SCRIPTCONT           varchar(2000)        not null,
PARAMEXPS            varchar(1000)        null,
REMARK               varchar(255)         null,
constraint PK_ST_INSLINKOP primary key  (SUBSYS, INSERTID, EXECNO)
)
go


/*==============================================================*/
/* Table: ST_INSRES                                             */
/*==============================================================*/
create table ST_INSRES (
SUBSYS               varchar(12)          not null,
INSERTID             varchar(20)          not null,
INSTYPE              decimal(4)           not null,
RESDESC              varchar(100)         not null,
RESOBJ               varchar(100)         not null,
ISACTRL              decimal(4)           not null,
PERMISSIONID         decimal(6)           null,
ISSYSFMENU           decimal(4)           not null,
FORMACTION           varchar(255)         null,
NEXTURL              varchar(500)         null,
BFILTERCND           varchar(255)         null,
INSCOLS              varchar(2000)        null,
NOINSCOLS            varchar(255)         null,
DISPCOLS             varchar(255)         null,
PUBCOLS              varchar(255)         null,
ARRAYFMT             varchar(2000)        null,
TAGPROVIDER          varchar(100)         null,
INSHANDLER           varchar(100)         null,
BUSICLASSTYPE        decimal(4)           null,
BUSICLASS            varchar(100)         null,
BUSIMETHOD           varchar(50)          null,
REMARK               varchar(255)         null,
constraint PK_ST_INSRES primary key  (SUBSYS, INSERTID)
)
go


/*==============================================================*/
/* Table: ST_INSSVRCHECK                                        */
/*==============================================================*/
create table ST_INSSVRCHECK (
SUBSYS               varchar(12)          not null,
INSERTID             varchar(20)          not null,
CHECKNO              decimal(4)           not null,
CHECKEXP             varchar(255)         not null,
ERRINFO              varchar(255)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_INSSVRCHECK primary key  (SUBSYS, INSERTID, CHECKNO)
)
go


/*==============================================================*/
/* Table: ST_INSTABPAGE                                         */
/*==============================================================*/
create table ST_INSTABPAGE (
SUBSYS               varchar(12)          not null,
INSERTID             varchar(20)          not null,
PAGENO               decimal(4)           not null,
PAGETITLE            varchar(40)          not null,
ARRAYFMT             varchar(500)         null,
PAGEDT               text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_INSTABPAGE primary key  (SUBSYS, INSERTID, PAGENO)
)
go


/*==============================================================*/
/* Table: ST_LOGONLOG                                           */
/*==============================================================*/
create table ST_LOGONLOG (
USERID               varchar(20)          not null,
LOGONTIME            datetime             not null,
LOGOUTTIME           datetime             null,
SESSIONID            varchar(100)         not null,
ISONLINE             decimal(4)           not null,
IPDRESS              varchar(20)          null,
HOSTNAME             varchar(20)          null,
constraint PK_ST_LOGONLOG primary key  (USERID, LOGONTIME)
)
go


/*==============================================================*/
/* Table: ST_MDBOPDT                                            */
/*==============================================================*/
create table ST_MDBOPDT (
SUBSYS               varchar(12)          not null,
MDBOPID              varchar(20)          not null,
DTTYPE               decimal(4)           not null,
DTCONT               text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_MDBOPDT primary key  (SUBSYS, MDBOPID, DTTYPE)
)
go


/*==============================================================*/
/* Table: ST_MDBOPFUNC                                          */
/*==============================================================*/
create table ST_MDBOPFUNC (
SUBSYS               varchar(12)          not null,
MDBOPID              varchar(20)          not null,
FUNCID               varchar(20)          not null,
DISPNAME             varchar(100)         not null,
DISPNO               decimal(2)           null,
DISPPOS              decimal(4)           not null,
FUNCTYPE             decimal(4)           not null,
FUNCURL              varchar(500)         null,
URLPARAMS            varchar(255)         null,
TARGET               varchar(30)          null,
LINKPID              decimal(6)           null,
DISPCND              varchar(255)         null,
QUERYINFO            varchar(255)         null,
FUNCINFO             varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_MDBOPFUNC primary key  (SUBSYS, MDBOPID, FUNCID)
)
go


/*==============================================================*/
/* Table: ST_MDBOPJSCSS                                         */
/*==============================================================*/
create table ST_MDBOPJSCSS (
SUBSYS               varchar(12)          not null,
MDBOPID              varchar(20)          not null,
JSCSSNO              decimal(4)           not null,
JSCSS                varchar(2000)        not null,
REMARK               varchar(255)         null,
constraint PK_ST_MDBOPJSCSS primary key  (SUBSYS, MDBOPID, JSCSSNO)
)
go


/*==============================================================*/
/* Table: ST_MDBOPJSEVENT                                       */
/*==============================================================*/
create table ST_MDBOPJSEVENT (
SUBSYS               varchar(12)          not null,
MDBOPID              varchar(20)          not null,
EVENTTYPE            decimal(4)           not null,
JSFUNC               varchar(100)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_MDBOPJSEVENT primary key  (SUBSYS, MDBOPID, EVENTTYPE)
)
go


/*==============================================================*/
/* Table: ST_MDBOPRES                                           */
/*==============================================================*/
create table ST_MDBOPRES (
SUBSYS               varchar(12)          not null,
MDBOPID              varchar(20)          not null,
RESDESC              varchar(50)          not null,
ISACTRL              decimal(4)           not null,
PERMISSIONID         decimal(6)           null,
ISSYSFMENU           decimal(4)           not null,
FORMACTION           varchar(255)         null,
NEXTURL              varchar(500)         null,
ARRAYFMT             varchar(255)         null,
BUSICLASSTYPE        decimal(4)           null,
BUSICLASS            varchar(255)         null,
BUSIMETHOD           varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_MDBOPRES primary key  (SUBSYS, MDBOPID)
)
go


/*==============================================================*/
/* Table: ST_MDBOPSUBRES                                        */
/*==============================================================*/
create table ST_MDBOPSUBRES (
SUBSYS               varchar(12)          not null,
MDBOPID              varchar(20)          not null,
SUBRESID             varchar(20)          not null,
SUBRESDESC           varchar(40)          not null,
EXECNO               decimal(4)           not null,
DBOPTYPE             decimal(4)           not null,
DBOPSUBSYS           varchar(12)          not null,
DBOPRESID            varchar(20)          not null,
COLVALEXPS           varchar(255)         null,
PARAMEXPS            varchar(255)         null,
IGNJSCSS             decimal(4)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_MDBOPSUBRES primary key  (SUBSYS, MDBOPID, SUBRESID)
)
go


/*==============================================================*/
/* Table: ST_MODULE                                             */
/*==============================================================*/
create table ST_MODULE (
SUBSYS               varchar(12)          not null,
MODID                decimal(6)           not null,
CATID                decimal(6)           not null,
MODTITLE             varchar(40)          not null,
DISPNO               decimal(4)           null,
LINKPID              decimal(6)           null,
MODURL               varchar(200)         not null,
TARGET               varchar(20)          null,
ISOUTACCESS          decimal(4)           not null,
ISHIDE               decimal(4)           not null,
MODICON              varchar(100)         null,
REMARK               varchar(100)         null,
constraint PK_ST_MODULE primary key  (SUBSYS, MODID)
)
go


/*==============================================================*/
/* Table: ST_MVCACTION                                          */
/*==============================================================*/
create table ST_MVCACTION (
SUBSYS               varchar(12)          not null,
ACTID                varchar(40)          not null,
ACTDESC              varchar(100)         not null,
ISCACHE              decimal(4)           not null,
ACTCLASS             varchar(200)         null,
ISACTRL              decimal(4)           not null,
PERMISSIONID         decimal(4)           null,
ISAUTOBACK           decimal(4)           not null,
URLPATHID            varchar(40)          null,
ISREDIRECT           decimal(4)           null,
URLPATH              varchar(500)         null,
URLDESC              varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_MVCACTION primary key  (SUBSYS, ACTID)
)
go


/*==============================================================*/
/* Table: ST_MVCCHECK                                           */
/*==============================================================*/
create table ST_MVCCHECK (
SUBSYS               varchar(12)          not null,
ACTID                varchar(40)          not null,
CTRLID               varchar(20)          not null,
EXECNO               decimal(4)           not null,
EXECPOS              decimal(4)           not null,
CHECKEXP             varchar(255)         not null,
ERRINFO              varchar(255)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_MVCCHECK primary key  (SUBSYS, ACTID, CTRLID, EXECNO)
)
go


/*==============================================================*/
/* Table: ST_MVCEXPOP                                           */
/*==============================================================*/
create table ST_MVCEXPOP (
SUBSYS               varchar(12)          not null,
ACTID                varchar(40)          not null,
CTRLID               varchar(20)          not null,
EXECNO               decimal(4)           not null,
EXECCND              varchar(255)         null,
EXPCONT              varchar(500)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_MVCEXPOP primary key  (SUBSYS, ACTID, CTRLID, EXECNO)
)
go


/*==============================================================*/
/* Table: ST_MVCGURL                                            */
/*==============================================================*/
create table ST_MVCGURL (
SUBSYS               varchar(12)          not null,
URLPATHID            varchar(40)          not null,
ISREDIRECT           decimal(4)           not null,
URLPATH              varchar(255)         not null,
URLDESC              varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_MVCGURL primary key  (SUBSYS, URLPATHID)
)
go


/*==============================================================*/
/* Table: ST_MVCMODEL                                           */
/*==============================================================*/
create table ST_MVCMODEL (
SUBSYS               varchar(12)          not null,
ACTID                varchar(40)          not null,
CTRLID               varchar(20)          not null,
EXECNO               decimal(4)           not null,
EXECCND              varchar(500)         null,
TARGETSUBSYS         varchar(12)          null,
SCRIPTTYPE           decimal(4)           not null,
SCRIPTCONT           varchar(2000)        not null,
PARAMEXPS            varchar(1000)        null,
RSTATTR              varchar(40)          null,
REMARK               varchar(255)         null,
constraint PK_ST_MVCMODEL primary key  (SUBSYS, ACTID, CTRLID, EXECNO)
)
go


/*==============================================================*/
/* Table: ST_MVCOPCTRL                                          */
/*==============================================================*/
create table ST_MVCOPCTRL (
SUBSYS               varchar(12)          not null,
ACTID                varchar(40)          not null,
CTRLID               varchar(20)          not null,
CTRLNO               decimal(4)           not null,
CTRLDESC             varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_MVCOPCTRL primary key  (SUBSYS, ACTID, CTRLID)
)
go


/*==============================================================*/
/* Table: ST_MVCRST                                             */
/*==============================================================*/
create table ST_MVCRST (
SUBSYS               varchar(12)          not null,
ACTID                varchar(40)          not null,
CTRLID               varchar(20)          not null,
EXECNO               decimal(4)           not null,
RETURNCND            varchar(255)         null,
URLPATHID            varchar(20)          null,
RETURNMSG            varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_MVCRST primary key  (SUBSYS, ACTID, CTRLID, EXECNO)
)
go


/*==============================================================*/
/* Table: ST_MVCURL                                             */
/*==============================================================*/
create table ST_MVCURL (
SUBSYS               varchar(12)          not null,
ACTID                varchar(40)          not null,
URLPATHID            varchar(40)          not null,
ISREDIRECT           decimal(4)           not null,
URLPATH              varchar(255)         not null,
URLDESC              varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_MVCURL primary key  (SUBSYS, ACTID, URLPATHID)
)
go


/*==============================================================*/
/* Table: ST_PERMISSION                                         */
/*==============================================================*/
create table ST_PERMISSION (
SUBSYS               varchar(12)          not null,
PERMISSIONID         decimal(6)           not null,
PERMISSIONDESC       varchar(100)         not null,
PERMISSIONTYPE       decimal(4)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_PERMISSION primary key  (SUBSYS, PERMISSIONID)
)
go


/*==============================================================*/
/* Table: ST_QUICKMOD                                           */
/*==============================================================*/
create table ST_QUICKMOD (
USERID               varchar(20)          not null,
SUBSYS               varchar(12)          not null,
MODID                decimal(6)           not null,
DISPNO               decimal(4)           null,
constraint PK_ST_QUICKMOD primary key  (USERID, SUBSYS, MODID)
)
go


/*==============================================================*/
/* Table: ST_REFDICRES                                          */
/*==============================================================*/
create table ST_REFDICRES (
SUBSYS               varchar(12)          not null,
DICSUBKIND           decimal(4)           not null,
SUBKINDDESC          varchar(40)          not null,
ISBIGTBL             decimal(4)           not null,
TBLNAME              varchar(40)          not null,
DICGRPCOL            varchar(40)          null,
DICGRPCOLTYPE        decimal(4)           not null,
DICIDCOL             varchar(40)          not null,
DICIDCOLTYPE         decimal(4)           not null,
DICDESCCOL           varchar(40)          not null,
BINDCOLS             varchar(100)         null,
DISPAPPENDCND        varchar(255)         null,
SELAPPENDCND         varchar(255)         null,
DISPTYPE             decimal(4)           not null,
DDDESCTYPE           decimal(4)           not null,
POPDICURL            varchar(500)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REFDICRES primary key  (SUBSYS, DICSUBKIND)
)
go


/*==============================================================*/
/* Table: ST_REGION                                             */
/*==============================================================*/
create table ST_REGION (
RGID                 varchar(30)          not null,
RGNAME               varchar(40)          not null,
RGLEVEL              decimal(4)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_REGION primary key  (RGID)
)
go


/*==============================================================*/
/* Table: ST_REPAPPLY                                           */
/*==============================================================*/
create table ST_REPAPPLY (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
APPLYOR              varchar(20)          not null,
APPLYTIME            datetime             not null,
APPLYTYPE            decimal(4)           not null,
ISCHECKED            decimal(4)           not null,
CHECKRST             decimal(4)           null,
CHECKER              varchar(20)          null,
CHECKTIME            datetime             null,
FEEDBACK             varchar(255)         null,
constraint PK_ST_REPAPPLY primary key  (SUBSYS, REPID, APPLYTIME)
)
go


/*==============================================================*/
/* Table: ST_REPCACHE                                           */
/*==============================================================*/
create table ST_REPCACHE (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
CACHETIME            decimal(13)          not null,
CREATOR              varchar(20)          not null,
CACHESOURCE          decimal(4)           not null,
CNDVALUES            varchar(1000)        null,
DATASRCFLAG          varchar(2000)        null,
STARTROW             decimal(8)           not null,
PERROWS              decimal(8)           not null,
TOTALROWS            decimal(8)           not null,
RSTROWS              decimal(8)           not null,
RESULTSET            image                null,
REMARK               varchar(255)         null,
constraint PK_ST_REPCACHE primary key  (SUBSYS, REPID, CACHETIME)
)
go


/*==============================================================*/
/* Index: repcachekey                                           */
/*==============================================================*/
create   index repcachekey on ST_REPCACHE (
SUBSYS,
REPID,
CNDVALUES,
DATASRCFLAG
)
go


/*==============================================================*/
/* Table: ST_REPCHART                                           */
/*==============================================================*/
create table ST_REPCHART (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
CHARTNO              decimal(4)           not null,
CHARTDESC            varchar(40)          not null,
ISSHOWDATA           decimal(4)           not null,
DATAPOS              decimal(4)           null,
CHARTTYPE            decimal(4)           not null,
ORIENTATION          decimal(4)           not null,
TITLE                varchar(100)         null,
SUBTITLEEXP          varchar(255)         null,
CATTITLE             varchar(100)         null,
DATATITLE            varchar(100)         null,
WIDTH                decimal(4)           not null,
HEIGHT               decimal(4)           not null,
SERIESFIELD          varchar(40)          null,
CATFIELD             varchar(40)          not null,
DATA1EXP             varchar(255)         not null,
DATA2EXP             varchar(255)         null,
DATA3EXP             varchar(255)         null,
DATA4EXP             varchar(255)         null,
DATA5EXP             varchar(255)         null,
LISTENER             varchar(100)         null,
PIEMAXCAT            decimal(2)           null,
BGCOLOR              varchar(20)          null,
TIMEPERIOD           decimal(4)           null,
SCALEMIN             decimal(10,4)        null,
SCALEMAX             decimal(10,4)        null,
ISCHARTDATA          decimal(4)           not null,
DATAFMT              varchar(40)          null,
ISDATAFLAG           decimal(4)           not null,
ISMAP                decimal(4)           not null,
MAPTARGET            varchar(20)          null,
MAPURL               varchar(500)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPCHART primary key  (SUBSYS, REPID, CHARTNO)
)
go


/*==============================================================*/
/* Table: ST_REPCHARTAXIS                                       */
/*==============================================================*/
create table ST_REPCHARTAXIS (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
CHARTNO              decimal(4)           not null,
AXISNO               decimal(4)           not null,
SUBCHARTS            varchar(20)          not null,
AXISPOS              decimal(4)           not null,
SCALEMIN             decimal(10,4)        null,
SCALEMAX             decimal(10,4)        null,
AXISTITLE            varchar(40)          null,
REMARK               varchar(255)         null,
constraint PK_ST_REPCHARTAXIS primary key  (SUBSYS, REPID, CHARTNO, AXISNO)
)
go


/*==============================================================*/
/* Table: ST_REPCHECK                                           */
/*==============================================================*/
create table ST_REPCHECK (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
CHECKID              varchar(20)          not null,
CHECKDESC            varchar(40)          not null,
RSTFILE              varchar(255)         null,
RSTHD                varchar(500)         null,
RSTFT                varchar(500)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPCHECK primary key  (SUBSYS, REPID, CHECKID)
)
go


/*==============================================================*/
/* Table: ST_REPCHECKITEM                                       */
/*==============================================================*/
create table ST_REPCHECKITEM (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
CHECKID              varchar(20)          not null,
ITEMNO               decimal(2)           not null,
CHECKRATE            decimal(4)           not null,
CHECKEXP             varchar(500)         not null,
PASSINFO             varchar(500)         null,
ERRINFO              varchar(500)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_REPCHECKITEM primary key  (SUBSYS, REPID, CHECKID, ITEMNO)
)
go


/*==============================================================*/
/* Table: ST_REPCND                                             */
/*==============================================================*/
create table ST_REPCND (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
CNDID                varchar(40)          not null,
CNDNO                decimal(2)           not null,
CNDNAME              varchar(100)         not null,
CNDTYPE              decimal(4)           not null,
DISPNAME             varchar(100)         not null,
TAGTYPE              decimal(4)           not null,
DISPLEN              decimal(4)           null,
MAXCNDLEN            decimal(8)           null,
MINVAL               decimal(8)           null,
MAXVAL               decimal(8)           null,
CHECKFUNC            varchar(30)          null,
DISPFORMAT           varchar(30)          null,
INITVALEXP           varchar(500)         null,
CNDVALEXP            varchar(500)         null,
JTYPE                decimal(4)           not null,
DICKIND              decimal(4)           not null,
DICSUBSYS            varchar(12)          null,
DICSUBKIND           decimal(4)           null,
DICGRPID             varchar(40)          null,
VALDICCOL            decimal(4)           null,
POPDICURL            varchar(500)         null,
ISMUSTSEL            decimal(4)           not null,
ISNULLABLE           decimal(4)           not null,
ISHIDE               decimal(4)           not null,
LINKCNDS             varchar(100)         null,
JSEVENT              varchar(255)         null,
TAGSTYLE             varchar(255)         null,
CNDINFO              varchar(100)         null,
REMARK               varchar(100)         null,
constraint PK_ST_REPCND primary key  (SUBSYS, REPID, CNDID)
)
go


/*==============================================================*/
/* Table: ST_REPCNDREM                                          */
/*==============================================================*/
create table ST_REPCNDREM (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
USERID               varchar(40)          not null,
SELCNDIDS            varchar(255)         null,
CNDVALUES            varchar(500)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPCNDREM primary key  (SUBSYS, REPID, USERID)
)
go


/*==============================================================*/
/* Table: ST_REPCNDSVRCHECK                                     */
/*==============================================================*/
create table ST_REPCNDSVRCHECK (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
CHECKNO              decimal(4)           not null,
CHECKEXP             varchar(500)         not null,
ERRINFO              varchar(255)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_REPCNDSVRCHECK primary key  (SUBSYS, REPID, CHECKNO)
)
go


/*==============================================================*/
/* Table: ST_REPDT                                              */
/*==============================================================*/
create table ST_REPDT (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
DTTYPE               decimal(4)           not null,
DTCONT               text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_REPDT primary key  (SUBSYS, REPID, DTTYPE)
)
go


/*==============================================================*/
/* Table: ST_REPEXP                                             */
/*==============================================================*/
create table ST_REPEXP (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
EXPID                varchar(20)          not null,
EXPDESC              varchar(60)          not null,
EXPTYPE              decimal(4)           not null,
EXPCONT              varchar(500)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_REPEXP primary key  (SUBSYS, REPID, EXPID)
)
go


/*==============================================================*/
/* Table: ST_REPEXPORTTPL                                       */
/*==============================================================*/
create table ST_REPEXPORTTPL (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
TPLID                varchar(20)          not null,
TPLDESC              varchar(40)          not null,
TPLTYPE              decimal(4)           not null,
FILENAME             varchar(255)         null,
TPLCONT              text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_REPEXPORTTPL primary key  (SUBSYS, REPID, TPLID)
)
go


/*==============================================================*/
/* Table: ST_REPFIELD                                           */
/*==============================================================*/
create table ST_REPFIELD (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
FIELDID              varchar(40)          not null,
FIELDNO              decimal(3)           not null,
TBLNAME              varchar(100)         null,
COLNAME              varchar(100)         not null,
DISPNAME             varchar(100)         not null,
DISPTYPE             decimal(4)           not null,
DISPFORMAT           varchar(30)          null,
JTYPE                decimal(4)           not null,
DICKIND              decimal(4)           not null,
DICSUBSYS            varchar(12)          null,
DICSUBKIND           decimal(4)           null,
DICGRPID             varchar(40)          null,
DICBINDFIELDS        varchar(100)         null,
POPDICURL            varchar(500)         null,
ISEDIT               decimal(4)           not null,
DISPLEN              decimal(4)           null,
ISTAGVALUE           decimal(4)           not null,
ISHDHMERGE           decimal(4)           not null,
ISHMERGE             decimal(4)           not null,
ISVMERGE             decimal(4)           not null,
ISPRINT              decimal(4)           not null,
ISHIDE               decimal(4)           not null,
LINKTARGET           varchar(40)          null,
LINKURL              varchar(500)         null,
PARAMFIELDS          varchar(100)         null,
QUERYINFO            varchar(255)         null,
FIRSTEXP             varchar(500)         null,
SECONDEXP            varchar(255)         null,
DISPEXP              varchar(255)         null,
ISACCESSEXP          varchar(255)         null,
LHDEXP               varchar(255)         null,
DHDEXP               varchar(255)         null,
LHDTDSTYLE           varchar(255)         null,
DHDTDSTYLE           varchar(255)         null,
LTDSTYLE             varchar(255)         null,
DTDSTYLE             varchar(255)         null,
REMARK               varchar(100)         null,
constraint PK_ST_REPFIELD primary key  (SUBSYS, REPID, FIELDID)
)
go


/*==============================================================*/
/* Table: ST_REPFUNC                                            */
/*==============================================================*/
create table ST_REPFUNC (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
FUNCID               varchar(40)          not null,
DISPNAME             varchar(100)         not null,
DISPNO               decimal(4)           not null,
DISPPOS              decimal(4)           not null,
DISPTYPE             decimal(4)           not null,
FUNCTYPE             decimal(4)           not null,
FUNCURL              varchar(500)         null,
URLPARAMS            varchar(100)         null,
TARGET               varchar(30)          null,
ISALWAYSSHOW         decimal(4)           not null,
LINKPID              decimal(6)           null,
DISPCND              varchar(255)         null,
QUERYINFO            varchar(255)         null,
FUNCINFO             varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPFUNC primary key  (SUBSYS, REPID, FUNCID)
)
go


/*==============================================================*/
/* Table: ST_REPGRIDHD                                          */
/*==============================================================*/
create table ST_REPGRIDHD (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
HDROWID              decimal(2)           not null,
ROWNO                decimal(2)           not null,
TRSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPGRIDHD primary key  (SUBSYS, REPID, HDROWID)
)
go


/*==============================================================*/
/* Table: ST_REPGRIDHDFIELD                                     */
/*==============================================================*/
create table ST_REPGRIDHDFIELD (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
HDROWID              decimal(2)           not null,
FIELDID              varchar(40)          not null,
HDEXP                varchar(40)          not null,
ISHMERGE             decimal(4)           not null,
ISVMERGE             decimal(4)           not null,
TDSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPGRIDHDFIELD primary key  (SUBSYS, REPID, HDROWID, FIELDID)
)
go


/*==============================================================*/
/* Table: ST_REPGRP                                             */
/*==============================================================*/
create table ST_REPGRP (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
GRPLEVEL             decimal(4)           not null,
GRPFIELDS            varchar(100)         not null,
ISBREAK              decimal(4)           not null,
ISNEWPAGE            decimal(4)           not null,
ISNEWPAGENO          decimal(4)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_REPGRP primary key  (SUBSYS, REPID, GRPLEVEL)
)
go


/*==============================================================*/
/* Table: ST_REPGRPDT                                           */
/*==============================================================*/
create table ST_REPGRPDT (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
GRPLEVEL             decimal(4)           not null,
DTTYPE               decimal(4)           not null,
DTCONT               text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_REPGRPDT primary key  (SUBSYS, REPID, GRPLEVEL, DTTYPE)
)
go


/*==============================================================*/
/* Table: ST_REPGRPSUM                                          */
/*==============================================================*/
create table ST_REPGRPSUM (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
GRPLEVEL             decimal(2)           not null,
SUMID                varchar(20)          not null,
DISPNO               decimal(2)           not null,
DISPPOS              decimal(4)           not null,
ISONEIGN             decimal(4)           not null,
ISMERGEBLK           decimal(4)           not null,
TRSTYLE              varchar(255)         null,
SUMDESC              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPGRPSUM primary key  (SUBSYS, REPID, GRPLEVEL, SUMID)
)
go


/*==============================================================*/
/* Table: ST_REPGRPSUMFIELD                                     */
/*==============================================================*/
create table ST_REPGRPSUMFIELD (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
GRPLEVEL             decimal(4)           not null,
SUMID                varchar(20)          not null,
FIELDID              varchar(40)          not null,
SUMEXP               varchar(255)         null,
DISPFORMAT           varchar(30)          null,
ISMERGEBLK           decimal(4)           not null,
TDSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPGRPSUMFIELD primary key  (SUBSYS, REPID, GRPLEVEL, SUMID, FIELDID)
)
go


/*==============================================================*/
/* Table: ST_REPHDFT                                            */
/*==============================================================*/
create table ST_REPHDFT (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
HDFTTYPE             decimal(4)           not null,
DISPNO               decimal(4)           not null,
TRSTYLE              varchar(255)         null,
CONT1                varchar(255)         null,
TDSTYLE1             varchar(255)         null,
CONT2                varchar(255)         null,
TDSTYLE2             varchar(255)         null,
CONT3                varchar(255)         null,
TDSTYLE3             varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPHDFT primary key  (SUBSYS, REPID, HDFTTYPE, DISPNO)
)
go


/*==============================================================*/
/* Table: ST_REPJSCSS                                           */
/*==============================================================*/
create table ST_REPJSCSS (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
JSCSSNO              decimal(4)           not null,
ISINIT               decimal(4)           not null,
JSCSS                varchar(2000)        not null,
REMARK               varchar(255)         null,
constraint PK_ST_REPJSCSS primary key  (SUBSYS, REPID, JSCSSNO)
)
go


/*==============================================================*/
/* Table: ST_REPJSEVENT                                         */
/*==============================================================*/
create table ST_REPJSEVENT (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
EVENTTYPE            decimal(4)           not null,
ISINIT               decimal(4)           not null,
JSFUNC               varchar(255)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_REPJSEVENT primary key  (SUBSYS, REPID, EVENTTYPE)
)
go


/*==============================================================*/
/* Table: ST_REPORT                                             */
/*==============================================================*/
create table ST_REPORT (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
REPDESC              varchar(100)         not null,
REPSTATUS            decimal(4)           not null,
CREATOR              varchar(20)          not null,
CREATETIME           datetime             not null,
DATASRCTYPE          decimal(4)           not null,
DATASRC              varchar(4000)        not null,
ISACTRL              decimal(4)           not null,
PERMISSIONID         decimal(6)           null,
DISPTYPE             decimal(4)           not null,
PERROWS              decimal(4)           not null,
ISAGRNOCND           decimal(4)           not null,
APPLYTYPE            decimal(4)           not null,
ISSYSFMENU           decimal(4)           not null,
ISCOLHD              decimal(4)           not null,
ISMAXWIDTH           decimal(4)           not null,
ISMAXLASTCOL         decimal(4)           not null,
ISEDIT               decimal(4)           not null,
LSTMODEL             decimal(4)           not null,
ISREMCND             decimal(4)           not null,
ISREALTIME           decimal(4)           not null,
ISAUTOCACHE          decimal(4)           not null,
REPLISTENER          varchar(100)         null,
CNDFMT               varchar(1000)        null,
LISTFMT              varchar(1000)        null,
DETAILFMT            varchar(2000)        null,
LTBSTYLE             varchar(255)         null,
DTBSTYLE             varchar(255)         null,
LHDTRSTYLE           varchar(255)         null,
LTRSTYLE             varchar(255)         null,
DTRSTYLE             varchar(255)         null,
DCOLWIDTHS           varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPORT primary key  (SUBSYS, REPID)
)
go


/*==============================================================*/
/* Table: ST_REPPRT                                             */
/*==============================================================*/
create table ST_REPPRT (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
LEFTMG               decimal(6,2)         null,
RIGHTMG              decimal(6,2)         null,
TOPMG                decimal(6,2)         null,
BOTTOMMG             decimal(6,2)         null,
PAPERORT             decimal(4)           not null,
HEADER               varchar(100)         null,
FOOTER               varchar(100)         null,
DEFAULTPRT           varchar(50)          null,
DEFAULTPAGE          varchar(50)          null,
PAGEWIDTH            decimal(6,2)         null,
PAGEHEIGHT           decimal(6,2)         null,
PRTZOOM              decimal(3,2)         not null,
ISPAGEDL             decimal(4)           not null,
ISPRTDL              decimal(4)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_REPPRT primary key  (SUBSYS, REPID)
)
go


/*==============================================================*/
/* Table: ST_REPSCHEDULE                                        */
/*==============================================================*/
create table ST_REPSCHEDULE (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
TASKID               varchar(20)          not null,
TASKDESC             varchar(50)          not null,
ISVALID              decimal(4)           not null,
TASKTYPE             decimal(4)           not null,
TASKTARGET           varchar(500)         null,
USERIDS              varchar(500)         null,
REPCNDS              varchar(1000)        null,
LOOPRULE             varchar(100)         null,
ROWLIMIT             decimal(6)           null,
ISREALTIME           decimal(4)           not null,
EXECPERIOD           decimal(4)           not null,
PERIODINTERVAL       decimal(2)           not null,
CRONEXP              varchar(100)         null,
STARTDATE            datetime             not null,
ENDDATE              datetime             null,
LASTDATE             datetime             null,
LASTSTATUS           decimal(4)           null,
LASTERR              varchar(500)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPSCHEDULE primary key  (SUBSYS, REPID, TASKID)
)
go


/*==============================================================*/
/* Table: ST_REPSUM                                             */
/*==============================================================*/
create table ST_REPSUM (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
SUMID                varchar(20)          not null,
DISPNO               decimal(4)           not null,
DISPPOS              decimal(4)           not null,
ISONEIGN             decimal(4)           not null,
ISMERGEBLK           decimal(4)           not null,
SUMTYPE              decimal(4)           not null,
TRSTYLE              varchar(255)         null,
SUMDESC              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPSUM primary key  (SUBSYS, REPID, SUMID)
)
go


/*==============================================================*/
/* Table: ST_REPSUMFIELD                                        */
/*==============================================================*/
create table ST_REPSUMFIELD (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
SUMID                varchar(20)          not null,
FIELDID              varchar(40)          not null,
SUMEXP               varchar(255)         null,
DISPFORMAT           varchar(30)          null,
ISMERGEBLK           decimal(4)           not null,
TDSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPSUMFIELD primary key  (SUBSYS, REPID, SUMID, FIELDID)
)
go


/*==============================================================*/
/* Table: ST_REPTREE                                            */
/*==============================================================*/
create table ST_REPTREE (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
TREENO               decimal(2)           not null,
TREEDESC             varchar(40)          not null,
ROOTNODEEXP          varchar(100)         not null,
ROOTSRC              decimal(4)           not null,
NODEFIELD            varchar(40)          not null,
DISPFIELD            varchar(40)          null,
EXPENDTYPE           decimal(4)           not null,
SUPERFIELD           varchar(40)          null,
ISLASTSHOWITEM       decimal(4)           not null,
ISOPENFIRST          decimal(4)           not null,
ISFILTERBLK          decimal(4)           not null,
EXTPOS               decimal(4)           not null,
ISINITEXT            decimal(4)           not null,
ISOPENREFRESH        decimal(4)           not null,
OPENICONFIELD        varchar(40)          null,
CLOSEICONFIELD       varchar(40)          null,
ITEMICONFIELD        varchar(40)          null,
OPENICON             varchar(100)         null,
CLOSEICON            varchar(100)         null,
ITEMICON             varchar(100)         null,
NODESTYLE            varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPTREE primary key  (SUBSYS, REPID, TREENO)
)
go


/*==============================================================*/
/* Table: ST_REPTREEEXTNODE                                     */
/*==============================================================*/
create table ST_REPTREEEXTNODE (
SUBSYS               varchar(20)          not null,
REPID                decimal(5)           not null,
TREENO               decimal(2)           not null,
EXTNO                decimal(2)           not null,
SRRESID              varchar(20)          not null,
ISSHOWROOT           decimal(4)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_REPTREEEXTNODE primary key  (SUBSYS, REPID, TREENO, EXTNO)
)
go


/*==============================================================*/
/* Table: ST_REPUNITFUNC                                        */
/*==============================================================*/
create table ST_REPUNITFUNC (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
FUNCID               varchar(40)          not null,
DISPNAME             varchar(30)          not null,
DISPNO               decimal(4)           not null,
FUNCURL              varchar(500)         not null,
URLFIELDS            varchar(100)         null,
TARGET               varchar(30)          null,
LINKPID              decimal(6)           null,
DISPCND              varchar(255)         null,
QUERYINFO            varchar(255)         null,
FUNCINFO             varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_REPUNITFUNC primary key  (SUBSYS, REPID, FUNCID)
)
go


/*==============================================================*/
/* Table: ST_RGPARAM                                            */
/*==============================================================*/
create table ST_RGPARAM (
RGID                 varchar(40)          not null,
PARAMNAME            varchar(40)          not null,
PARAMVAL             varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_RGPARAM primary key  (RGID, PARAMNAME)
)
go


/*==============================================================*/
/* Table: ST_ROLE                                               */
/*==============================================================*/
create table ST_ROLE (
SUBSYS               varchar(12)          not null,
ROLEID               decimal(6)           not null,
ROLEDESC             varchar(100)         not null,
ISOUTACCESS          decimal(4)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_ROLE primary key  (SUBSYS, ROLEID)
)
go


/*==============================================================*/
/* Table: ST_ROLEPERMISSION                                     */
/*==============================================================*/
create table ST_ROLEPERMISSION (
SUBSYS               varchar(12)          not null,
ROLEID               decimal(6)           not null,
PERMISSIONID         decimal(6)           not null,
constraint PK_ST_ROLEPERMISSION primary key  (SUBSYS, ROLEID, PERMISSIONID)
)
go


/*==============================================================*/
/* Table: ST_SEQUENCE                                           */
/*==============================================================*/
create table ST_SEQUENCE (
SUBSYS               varchar(12)          not null,
SEQID                varchar(20)          not null,
SEQDESC              varchar(100)         not null,
CURVAL               decimal(14)          not null,
STEPLEN              decimal(4)           null,
SEQTYPE              decimal(4)           not null,
ISFOURYEAR           decimal(4)           not null,
BASESIZE             decimal(2)           null,
REMARK               varchar(100)         null,
constraint PK_ST_SEQUENCE primary key  (SUBSYS, SEQID)
)
go


/*==============================================================*/
/* Table: ST_SFNODE                                             */
/*==============================================================*/
create table ST_SFNODE (
SUBSYS               varchar(12)          not null,
SFID                 decimal(5)           not null,
NODEID               varchar(10)          not null,
NODENO               decimal(2)           not null,
NODEDESC             varchar(40)          not null,
OPERATORS            varchar(100)         not null,
EXECCND              varchar(500)         null,
REMARK               varchar(255)         null,
constraint PK_ST_SFNODE primary key  (SUBSYS, SFID, NODEID)
)
go


/*==============================================================*/
/* Table: ST_SIMPLEFLOW                                         */
/*==============================================================*/
create table ST_SIMPLEFLOW (
SUBSYS               varchar(12)          not null,
SFID                 decimal(5)           not null,
SFDESC               varchar(40)          not null,
REMARK               varchar(255)         null,
constraint PK_ST_SIMPLEFLOW primary key  (SUBSYS, SFID)
)
go


/*==============================================================*/
/* Table: ST_SQLLOG                                             */
/*==============================================================*/
create table ST_SQLLOG (
LOGID                decimal(14)          not null,
USERID               varchar(20)          not null,
LOGDATE              datetime             not null,
SUBSYS               varchar(12)          not null,
TBLNAME              varchar(50)          not null,
SQLTYPE              decimal(4)           not null,
KEYCOLTYPE           varchar(40)          null,
KEYVALS              varchar(200)         null,
LOGSQL               varchar(2000)        not null,
UPDCONT              text                 null,
constraint PK_ST_SQLLOG primary key  (LOGID)
)
go


/*==============================================================*/
/* Table: ST_SQLLOGSET                                          */
/*==============================================================*/
create table ST_SQLLOGSET (
SUBSYS               varchar(12)          not null,
TBLNAME              varchar(20)          not null,
KEYCOLS              varchar(100)         not null,
KEYCOLTYPE           varchar(40)          not null,
ISLOG                decimal(4)           not null,
REMARK               varchar(255)         null,
constraint PK_ST_SQLLOGSET primary key  (SUBSYS, TBLNAME)
)
go


/*==============================================================*/
/* Table: ST_SRBODYCELL                                         */
/*==============================================================*/
create table ST_SRBODYCELL (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
SRROWID              varchar(20)          not null,
SRCOLID              varchar(20)          not null,
VALEXP               varchar(500)         null,
REMARK               varchar(255)         null,
constraint PK_ST_SRBODYCELL primary key  (SUBSYS, REPID, SRROWID, SRCOLID)
)
go


/*==============================================================*/
/* Table: ST_SRCACHE                                            */
/*==============================================================*/
create table ST_SRCACHE (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
CACHETIME            decimal(13)          not null,
CREATOR              varchar(20)          not null,
CHECKER              varchar(20)          not null,
DATAUNIT             decimal(4)           not null,
CNDVALUES            varchar(1000)        null,
DATASRCFLAG          varchar(2000)        null,
CACHEDATA            image                null,
REMARK               varchar(255)         null,
constraint PK_ST_SRCACHE primary key  (SUBSYS, REPID, CACHETIME)
)
go


/*==============================================================*/
/* Index: srCacheKey                                            */
/*==============================================================*/
create   index srCacheKey on ST_SRCACHE (
SUBSYS,
REPID,
DATAUNIT,
CNDVALUES,
DATASRCFLAG
)
go


/*==============================================================*/
/* Table: ST_SRCOLUMN                                           */
/*==============================================================*/
create table ST_SRCOLUMN (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
SRCOLID              varchar(20)          not null,
SRCOLNO              decimal(2)           not null,
DISPNAME             varchar(100)         not null,
COLTYPE              decimal(4)           not null,
JTYPE                decimal(4)           not null,
DATAUNIT             decimal(4)           not null,
FRACTION             decimal(2)           null,
ISADDUP              decimal(4)           not null,
COLVALEXP            varchar(255)         null,
DISPFORMAT           varchar(30)          null,
ISVMERGE             decimal(4)           not null,
COLWIDTH             varchar(20)          not null,
HDTDSTYLE            varchar(255)         null,
TDSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_SRCOLUMN primary key  (SUBSYS, REPID, SRCOLID)
)
go


/*==============================================================*/
/* Table: ST_SRGRIDHD                                           */
/*==============================================================*/
create table ST_SRGRIDHD (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
HDROWID              decimal(2)           not null,
ROWNO                decimal(2)           not null,
TRSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_SRGRIDHD primary key  (SUBSYS, REPID, HDROWID)
)
go


/*==============================================================*/
/* Table: ST_SRGRIDHDCOL                                        */
/*==============================================================*/
create table ST_SRGRIDHDCOL (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
HDROWID              decimal(2)           not null,
SRCOLID              varchar(20)          not null,
HDEXP                varchar(50)          not null,
ISHMERGE             decimal(4)           not null,
ISVMERGE             decimal(4)           not null,
TDSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_SRGRIDHDCOL primary key  (SUBSYS, REPID, HDROWID, SRCOLID)
)
go


/*==============================================================*/
/* Table: ST_SRHDFT                                             */
/*==============================================================*/
create table ST_SRHDFT (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
HDFTTYPE             decimal(4)           not null,
DISPNO               decimal(2)           not null,
TRSTYLE              varchar(255)         null,
CONT1                varchar(255)         null,
TDSTYLE1             varchar(255)         null,
CONT2                varchar(255)         null,
TDSTYLE2             varchar(255)         null,
CONT3                varchar(255)         null,
TDSTYLE3             varchar(255)         null,
REAMRK               varchar(255)         null,
constraint PK_ST_SRHDFT primary key  (SUBSYS, REPID, DISPNO, HDFTTYPE)
)
go


/*==============================================================*/
/* Table: ST_SRROW                                              */
/*==============================================================*/
create table ST_SRROW (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
SRROWID              varchar(20)          not null,
SRROWNO              decimal(3)           not null,
ITEMDESC             varchar(100)         not null,
ITEMGRADE            decimal(2)           not null,
ROWVALEXP            varchar(255)         null,
ROWHEIGHT            varchar(20)          null,
TRSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_SRROW primary key  (SUBSYS, REPID, SRROWID)
)
go


/*==============================================================*/
/* Table: ST_STRDIC                                             */
/*==============================================================*/
create table ST_STRDIC (
SUBSYS               varchar(12)          not null,
DICGRPID             decimal(4)           not null,
DICID                varchar(40)          not null,
DICDESC              varchar(100)         not null,
REMARK               varchar(100)         null,
constraint PK_ST_STRDIC primary key  (SUBSYS, DICGRPID, DICID)
)
go


/*==============================================================*/
/* Table: ST_STRDICGRP                                          */
/*==============================================================*/
create table ST_STRDICGRP (
SUBSYS               varchar(12)          not null,
DICGRPID             decimal(4)           not null,
ISSYSDIC             decimal(4)           not null,
DDDESCTYPE           decimal(4)           not null,
GRPDESC              varchar(100)         null,
REMARK               varchar(100)         null,
constraint PK_ST_STRDICTYPE primary key  (SUBSYS, DICGRPID)
)
go


/*==============================================================*/
/* Table: ST_SUBREP                                             */
/*==============================================================*/
create table ST_SUBREP (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
SRRESID              varchar(20)          not null,
SRRESDESC            varchar(40)          not null,
SRSUBSYS             varchar(12)          not null,
SRREPID              decimal(5)           not null,
CNDSOURCE            decimal(4)           not null,
SELCNDS              varchar(255)         null,
MAPCNDS              varchar(255)         null,
RSTFILTERCND         varchar(255)         null,
DISPTYPE             decimal(4)           null,
NRPARAMS             varchar(255)         null,
ERPARAMS             varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_SUBREP primary key  (SUBSYS, REPID, SRRESID)
)
go


/*==============================================================*/
/* Table: ST_SUBSEQ                                             */
/*==============================================================*/
create table ST_SUBSEQ (
SUBSYS               varchar(12)          not null,
SEQID                varchar(20)          not null,
SUBSEQID             varchar(50)          not null,
CURVAL               decimal(14)          not null,
REMARK               varchar(100)         null,
constraint PK_ST_SUBSEQ primary key  (SUBSYS, SEQID, SUBSEQID)
)
go


/*==============================================================*/
/* Table: ST_SUBSYS                                             */
/*==============================================================*/
create table ST_SUBSYS (
SUBSYS               varchar(12)          not null,
SYSDESC              varchar(100)         not null,
DBRESID              varchar(12)          not null,
TESTDBRESID          varchar(12)          null,
COLINFOSUBSYS        varchar(12)          null,
REMARK               varchar(255)         null,
constraint PK_ST_SUBSYS primary key  (SUBSYS)
)
go


/*==============================================================*/
/* Table: ST_SUMMARYREP                                         */
/*==============================================================*/
create table ST_SUMMARYREP (
SUBSYS               varchar(12)          not null,
REPID                decimal(5)           not null,
PERIODTYPE           decimal(4)           not null,
PERIODCNDIDS         varchar(100)         null,
LASTBORDER           decimal(4)           not null,
ISEDIT               decimal(4)           not null,
ISEDITACTRL          decimal(4)           not null,
EDITPID              decimal(5)           null,
ISAUTOCACHE          decimal(4)           not null,
ISAUTOBALENCE        decimal(4)           not null,
DEFDATAUNIT          decimal(4)           not null,
FRACTION             decimal(4)           null,
ISFIXEDSIZE          decimal(4)           null,
ROWHDCOLSPAN         decimal(2)           not null,
ROWHDEXP             varchar(255)         null,
TBLSTYLE             varchar(255)         null,
HDTRSTYLE            varchar(255)         null,
TRSTYLE              varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_SUMMARYREP primary key  (SUBSYS, REPID)
)
go


/*==============================================================*/
/* Table: ST_SYSPARAM                                           */
/*==============================================================*/
create table ST_SYSPARAM (
SUBSYS               varchar(12)          not null,
PARAMNAME            varchar(30)          not null,
PARAMVALUE           varchar(255)         null,
ISCACHE              decimal(4)           not null,
PARAMDESC            varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_SYSPARAM primary key  (SUBSYS, PARAMNAME)
)
go


/*==============================================================*/
/* Table: ST_SYSUSER                                            */
/*==============================================================*/
create table ST_SYSUSER (
USERID               varchar(20)          not null,
PASSWD               varchar(80)          null,
USERNAME             varchar(20)          not null,
REGION               varchar(30)          not null,
GRADE                decimal(4)           not null,
DEPT                 varchar(30)          not null,
POST                 decimal(4)           not null,
USERTYPE             decimal(4)           not null,
DISPNO               decimal(4)           null,
USERSTAT             decimal(4)           not null,
IPDRESS              varchar(20)          null,
ISBINDIP             decimal(4)           not null,
EMAIL                varchar(40)          null,
MOBILE               varchar(20)          null,
REMARK               varchar(255)         null,
constraint PK_ST_SYSUSER primary key  (USERID)
)
go


/*==============================================================*/
/* Table: ST_TABFUNC                                            */
/*==============================================================*/
create table ST_TABFUNC (
SUBSYS               varchar(12)          not null,
TABID                decimal(5)           not null,
FUNCID               varchar(30)          not null,
DISPNAME             varchar(30)          not null,
DISPNO               decimal(4)           not null,
DISPPOS              decimal(4)           not null,
FUNCTYPE             decimal(4)           not null,
FUNCURL              varchar(500)         null,
TARGET               varchar(30)          null,
LINKPID              decimal(6)           null,
DISPCND              varchar(255)         null,
QUERYINFO            varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_TABFUNC primary key  (SUBSYS, TABID, FUNCID)
)
go


/*==============================================================*/
/* Table: ST_TABJSCSS                                           */
/*==============================================================*/
create table ST_TABJSCSS (
SUBSYS               varchar(12)          not null,
TABID                decimal(5)           not null,
JSCSSNO              decimal(2)           not null,
JSCSS                varchar(2000)        not null,
REMARK               varchar(255)         null,
constraint PK_ST_TABJSCSS primary key  (SUBSYS, TABID, JSCSSNO)
)
go


/*==============================================================*/
/* Table: ST_TABPAGE                                            */
/*==============================================================*/
create table ST_TABPAGE (
SUBSYS               varchar(12)          not null,
TABID                decimal(5)           not null,
TABPAGEID            varchar(20)          not null,
PAGETITLE            varchar(40)          not null,
DISPNO               decimal(2)           not null,
LINKPID              decimal(6)           null,
PAGEURL              varchar(500)         not null,
JSEVENT              varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_TABPAGE primary key  (SUBSYS, TABID, TABPAGEID)
)
go


/*==============================================================*/
/* Table: ST_TABRES                                             */
/*==============================================================*/
create table ST_TABRES (
SUBSYS               varchar(12)          not null,
TABID                decimal(5)           not null,
TABDESC              varchar(100)         not null,
ISACTRL              decimal(4)           not null,
PERMISSIONID         decimal(6)           null,
ISSHOWTITLE          decimal(4)           not null,
ROWPAGES             decimal(2)           null,
TABPOS               decimal(4)           not null,
ROWFUNCS             decimal(2)           null,
REMARK               varchar(255)         null,
constraint PK_ST_TABRES primary key  (SUBSYS, TABID)
)
go


/*==============================================================*/
/* Table: ST_TBLINFO                                            */
/*==============================================================*/
create table ST_TBLINFO (
SUBSYS               varchar(12)          not null,
TBLNAME              varchar(40)          not null,
TBLDESC              varchar(100)         null,
REMARK               varchar(100)         null,
constraint PK_ST_TBLINFO primary key  (SUBSYS, TBLNAME)
)
go


/*==============================================================*/
/* Table: ST_UPDCOLINFO                                         */
/*==============================================================*/
create table ST_UPDCOLINFO (
SUBSYS               varchar(12)          not null,
UPDATEID             varchar(20)          not null,
COLNAME              varchar(40)          not null,
COLDESC              varchar(40)          null,
ISNULLABLE           decimal(4)           null,
TAGTYPE              decimal(4)           null,
DISPFORMAT           varchar(30)          null,
DISPLEN              decimal(8)           null,
ROWSIZE              decimal(4)           null,
CHECKFUNC            varchar(30)          null,
POPDICURL            varchar(500)         null,
TAGSTYLE             varchar(255)         null,
ISALWAYSSAVE         decimal(4)           not null,
DISPEXP              varchar(500)         null,
SAVEEXP              varchar(500)         null,
JSEVENT              varchar(255)         null,
constraint PK_ST_UPDCOLINFO primary key  (SUBSYS, UPDATEID, COLNAME)
)
go


/*==============================================================*/
/* Table: ST_UPDDT                                              */
/*==============================================================*/
create table ST_UPDDT (
SUBSYS               varchar(12)          not null,
UPDATEID             varchar(20)          not null,
DTTYPE               decimal(4)           not null,
DTCONT               text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_UPDDT primary key  (SUBSYS, UPDATEID, DTTYPE)
)
go


/*==============================================================*/
/* Table: ST_UPDEXPOP                                           */
/*==============================================================*/
create table ST_UPDEXPOP (
SUBSYS               varchar(12)          not null,
UPDATEID             varchar(20)          not null,
EXECNO               decimal(4)           not null,
EXECPOS              decimal(4)           not null,
EXECCND              varchar(255)         null,
EXPCONT              varchar(255)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_UPDEXPOP primary key  (SUBSYS, UPDATEID, EXECNO)
)
go


/*==============================================================*/
/* Table: ST_UPDFUNC                                            */
/*==============================================================*/
create table ST_UPDFUNC (
SUBSYS               varchar(12)          not null,
UPDATEID             varchar(20)          not null,
FUNCID               varchar(20)          not null,
DISPNAME             varchar(100)         not null,
DISPNO               decimal(2)           null,
DISPPOS              decimal(4)           not null,
FUNCTYPE             decimal(4)           not null,
FUNCURL              varchar(500)         null,
URLCOLS              varchar(255)         null,
TARGET               varchar(30)          null,
LINKPID              decimal(6)           null,
DISPCND              varchar(255)         null,
QUERYINFO            varchar(255)         null,
FUNCINFO             varchar(100)         null,
REMARK               varchar(255)         null,
constraint PK_ST_UPDFUNC primary key  (SUBSYS, UPDATEID, FUNCID)
)
go


/*==============================================================*/
/* Table: ST_UPDJSCSS                                           */
/*==============================================================*/
create table ST_UPDJSCSS (
SUBSYS               varchar(12)          not null,
UPDATEID             varchar(20)          not null,
JSCSSNO              decimal(4)           not null,
JSCSS                varchar(2000)        not null,
REMARK               varchar(255)         null,
constraint PK_ST_UPDJSCSS primary key  (SUBSYS, UPDATEID, JSCSSNO)
)
go


/*==============================================================*/
/* Table: ST_UPDJSEVENT                                         */
/*==============================================================*/
create table ST_UPDJSEVENT (
SUBSYS               varchar(12)          not null,
UPDATEID             varchar(20)          not null,
EVENTTYPE            decimal(4)           not null,
JSFUNC               varchar(100)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_UPDJSEVENT primary key  (SUBSYS, UPDATEID, EVENTTYPE)
)
go


/*==============================================================*/
/* Table: ST_UPDLINKOP                                          */
/*==============================================================*/
create table ST_UPDLINKOP (
SUBSYS               varchar(12)          not null,
UPDATEID             varchar(20)          not null,
EXECNO               decimal(4)           not null,
EXECPOS              decimal(4)           not null,
EXECCND              varchar(500)         null,
TARGETSUBSYS         varchar(12)          null,
SCRIPTTYPE           decimal(4)           not null,
SCRIPTCONT           varchar(2000)        not null,
PARAMEXPS            varchar(1000)        null,
REMARK               varchar(255)         null,
constraint PK_ST_UPDLINKOP primary key  (SUBSYS, UPDATEID, EXECNO)
)
go


/*==============================================================*/
/* Table: ST_UPDRES                                             */
/*==============================================================*/
create table ST_UPDRES (
SUBSYS               varchar(12)          not null,
UPDATEID             varchar(20)          not null,
UPDTYPE              decimal(4)           not null,
RESDESC              varchar(100)         not null,
RESOBJ               varchar(100)         not null,
ISACTRL              decimal(4)           not null,
PERMISSIONID         decimal(6)           null,
ISCHKRST             decimal(4)           not null,
ISSYSFMENU           decimal(4)           not null,
FORMACTION           varchar(255)         null,
NEXTURL              varchar(500)         null,
APPENDCND            varchar(255)         null,
BCNDCOLS             varchar(100)         null,
BORDERCOLS           varchar(100)         null,
UPDCOLS              varchar(2000)        null,
NOUPDCOLS            varchar(255)         null,
DISPCOLS             varchar(255)         null,
ARRAYFMT             varchar(2000)        null,
TAGPROVIDER          varchar(100)         null,
UPDHANDLER           varchar(100)         null,
DATACLASSTYPE        decimal(4)           null,
DATACLASS            varchar(100)         null,
DATAMETHOD           varchar(100)         null,
DATAPARAMS           varchar(100)         null,
BUSICLASSTYPE        decimal(4)           null,
BUSICLASS            varchar(100)         null,
BUSIMETHOD           varchar(50)          null,
REMARK               varchar(255)         null,
constraint PK_ST_UPDRES primary key  (SUBSYS, UPDATEID)
)
go


/*==============================================================*/
/* Table: ST_UPDSVRCHECK                                        */
/*==============================================================*/
create table ST_UPDSVRCHECK (
SUBSYS               varchar(12)          not null,
UPDATEID             varchar(20)          not null,
CHECKNO              decimal(4)           not null,
CHECKEXP             varchar(255)         not null,
ERRINFO              varchar(255)         not null,
REMARK               varchar(255)         null,
constraint PK_ST_UPDSVRCHECK primary key  (SUBSYS, UPDATEID, CHECKNO)
)
go


/*==============================================================*/
/* Table: ST_UPDTABPAGE                                         */
/*==============================================================*/
create table ST_UPDTABPAGE (
SUBSYS               varchar(12)          not null,
UPDATEID             varchar(20)          not null,
PAGENO               decimal(4)           not null,
PAGETITLE            varchar(40)          not null,
ARRAYFMT             varchar(500)         null,
PAGEDT               text                 null,
REMARK               varchar(255)         null,
constraint PK_ST_UPDTABPAGE primary key  (SUBSYS, UPDATEID, PAGENO)
)
go


/*==============================================================*/
/* Table: ST_UPLOADRES                                          */
/*==============================================================*/
create table ST_UPLOADRES (
SUBSYS               varchar(12)          not null,
UPLOADID             varchar(20)          not null,
UPLOADDESC           varchar(100)         not null,
TBLNAME              varchar(40)          not null,
COLNAME              varchar(40)          not null,
COLTYPE              decimal(4)           not null,
ALLOWFTYPE           varchar(40)          null,
DENYFTYPE            varchar(40)          null,
FILEMAXSIZE          decimal(10)          null,
ISUPDACTRL           decimal(4)           not null,
UPDPID               decimal(6)           null,
ISREADACTRL          decimal(4)           not null,
READPID              decimal(6)           null,
APPENDCND            varchar(255)         null,
REMARK               varchar(255)         null,
constraint PK_ST_UPLOADRES primary key  (SUBSYS, UPLOADID)
)
go


/*==============================================================*/
/* Table: ST_URLRES                                             */
/*==============================================================*/
create table ST_URLRES (
SUBSYS               varchar(12)          not null,
URLTYPE              decimal(4)           not null,
URL                  varchar(255)         not null,
REMARK               varchar(100)         null,
constraint PK_ST_URLRES primary key  (SUBSYS, URLTYPE, URL)
)
go


/*==============================================================*/
/* Table: ST_USEREXPFUNC                                        */
/*==============================================================*/
create table ST_USEREXPFUNC (
SUBSYS               varchar(12)          not null,
FUNCNAME             varchar(30)          not null,
MAPMETHOD            varchar(100)         not null,
FUNCTYPE             decimal(4)           not null,
FUNCDESC             varchar(255)         null,
constraint PK_ST_USEREXPFUNC primary key  (SUBSYS, FUNCNAME)
)
go


/*==============================================================*/
/* Table: ST_USERROLE                                           */
/*==============================================================*/
create table ST_USERROLE (
SUBSYS               varchar(12)          not null,
ROLEID               decimal(6)           not null,
USERID               varchar(20)          not null,
constraint PK_ST_USERROLE primary key  (USERID, SUBSYS, ROLEID)
)
go


/*==============================================================*/
/* Table: ST_USERSUBSYS                                         */
/*==============================================================*/
create table ST_USERSUBSYS (
SUBSYS               varchar(12)          not null,
USERID               varchar(20)          not null,
OPTYPE               decimal(4)           not null,
constraint PK_ST_USERSUBSYS primary key  (SUBSYS, USERID, OPTYPE)
)
go


/*==============================================================*/
/* Table: ST_WGUSER                                             */
/*==============================================================*/
create table ST_WGUSER (
WGID                 decimal(6)           not null,
USERID               varchar(20)          not null,
constraint PK_ST_WGUSER primary key  (WGID, USERID)
)
go


/*==============================================================*/
/* Table: ST_WORKGROUP                                          */
/*==============================================================*/
create table ST_WORKGROUP (
RGID                 varchar(30)          not null,
WGID                 decimal(6)           not null,
WGNAME               varchar(40)          not null,
DISPNO               decimal(4)           null,
REMARK               varchar(255)         null,
constraint PK_ST_WORKGROUP primary key  (WGID)
)
go


