create table EMPRECENTFUNC
(
  ERFID      VARCHAR(20) not null,
  ERFACCNTID VARCHAR(15) not null,
  ERFFUNCID  VARCHAR(10) not null
)
go

create table ERPFUNCMETHOD
(
  EFMFID         VARCHAR(10) not null,
  EFMMID         CHAR(1) not null,
  EFMNAME        VARCHAR(20) not null,
  EFMMETHOD      VARCHAR(40) not null,
  EFMUPPICT      VARCHAR(80) null,
  EFMDNPICT      VARCHAR(80) null,
  EFMCHECK       CHAR(1) default 'N' not null,
  EFMVISIBLE     CHAR(1) default 'Y' not null,
  EFMHINT        VARCHAR(40) null,
  EFMMICOHELP    VARCHAR(80) null,
  EFMTBITEMINDEX NUMERIC default 1,
  EFMTBITEMORDER NUMERIC default 0,
  EFMTBITEMSPACE NUMERIC default 0,
  constraint PK_ERPFUNCMETHOD primary key (EFMFID,EFMMID)
)
go

create table ERPFUNCTION
(
  EFID          VARCHAR(10) not null,
  EFNAME        VARCHAR(40) not null,
  EFCLASS       NUMERIC default 1 not null,
  EFLASTFLAG    CHAR(1) default 'N' not null,
  EFPCID        VARCHAR(10) not null,
  EFUPPICT      VARCHAR(80) null,
  EFDNPICT      VARCHAR(80) null,
  EFCHECK       CHAR(1) default 'N' not null,
  EFVISIBLE     CHAR(1) default 'N' not null,
  EFHINT        VARCHAR(40) null,
  EFMICROHELP   VARCHAR(80) null,
  EFRUNHOW      CHAR(1) default 'S' not null,
  EFRUNWHAT     VARCHAR(40) null,
  EFRUNPARA     VARCHAR(40) null,
  EFISLOG       CHAR(1) default 'N' not null,
  EFTBITEMINDEX NUMERIC default 1,
  EFTBITEMORDER NUMERIC default 0,
  EFTBITEMSPACE NUMERIC default 0,
  constraint PK_ERPFUNCTION primary key (EFID)
)
go

create table OPERACCNT
(
  OAID       VARCHAR(15) not null,
  OAPWD      VARCHAR(10) null,
  OAPWDTYPE  CHAR(1) null,
  OAPWDQUST  VARCHAR(20) null,
  OAPWDANSW  VARCHAR(20) null,
  OAISLOGIN  CHAR(1) not null,
  OAMAXDATE  DATETIME not null,
  OAGH       VARCHAR(8) null,
  OANAME     VARCHAR(60) null,
  OADEPT     VARCHAR(20) null,
  OAIDNO     VARCHAR(20) null,
  OAEMAIL    VARCHAR(40) null,
  OAROLE     CHAR(2) null,
  OAACCNTID  VARCHAR(8) default '00',
  OAOPERTYPE VARCHAR(4) null,
  constraint PK_OPERACCNT primary key (OAID)
)
go

create table OPERGROUPFUNC
(
  OGFID  VARCHAR(8) not null,
  OGFGID VARCHAR(8) not null,
  OGFMID VARCHAR(8) not null,
  OGFFID VARCHAR(8) not null,
  constraint PK_OPERGROUPFUNC primary key (OGFFID,OGFGID,OGFID)
)
go

create table OPERGROUPMOD
(
  OGMID    VARCHAR(8) not null,
  OGMNAME  VARCHAR(40) null,
  OGMPID   VARCHAR(8) not null,
  OGMGID   VARCHAR(8) not null,
  OGMMID   VARCHAR(8) not null,
  OGMCLASS NUMERIC default 1 not null,
  OGMFLAG  CHAR(1) default 'N' not null,
  constraint PK_OGMID primary key (OGMID,OGMPID,OGMGID)
)
go

create table OPERLOG
(
  OLSEQNO       VARCHAR(8) not null,
  OLOPERID      VARCHAR(8) not null,
  OLWORKSTATION VARCHAR(60) null,
  OLDATETIME    DATETIME NULL,
  OLFUNCID      VARCHAR(8) null,
  OLDESC        VARCHAR(800) null,
  constraint PK_OPERLOG primary key (OLSEQNO)
)
go

create table OPERRFMETHOD
(
  ORFMRID   CHAR(2) not null,
  ORFMFID   VARCHAR(10) not null,
  ORFMETHOD CHAR(1) not null,
  constraint PK_OPERRFMETHOD primary key (ORFMRID,ORFMFID,ORFMETHOD)
)
go

create table OPERROLE
(
  ORID     CHAR(2) not null,
  ORNAME   VARCHAR(20) not null,
  ORGID    CHAR(2) not null,
  ORTRANGE NUMERIC default 10000000 not null,
  ORDRANGE CHAR(1) default 'Y' not null,
  constraint PK_OPERROLE primary key (ORID)
)
go

create table OPERROLEFUNC
(
  ORFRID CHAR(2) not null,
  ORFFID VARCHAR(10) not null,
  constraint PK_OPERROLEFUNC primary key (ORFRID,ORFFID)
)
go

create table OPERTYPEDWOBJECT
(
  OTDOBID    VARCHAR(3) not null,
  OTDOTID    VARCHAR(4) not null,
  OTDOOBJECT VARCHAR(36) not null,
  OTDOMEMO   VARCHAR(100)
)
go

create table SYSBANK
(
  SBKID      VARCHAR(2) not null,
  SBKNAME    VARCHAR(40) not null,
  SBKADDRESS VARCHAR(40) null,
  SBKTEL     VARCHAR(12) null,
  SBKACNTNO  VARCHAR(2) not null,
  constraint PK_SYSBANK primary key (SBKID,SBKACNTNO)
)
go

create table SYSCHARLIST
(
  SCLTYPE  VARCHAR(40) not null,
  SCLID    VARCHAR(15) not null,
  SCLVALUE VARCHAR(30) null,
  SCLWIDTH NUMERIC(2) null,
  SCLGROUP VARCHAR(4) not null,
  constraint PK_SYSCHARLIST primary key (SCLTYPE,SCLID,SCLGROUP)
)
go

create table SYSERRORLOG
(
  SELSEQNO        VARCHAR(8) not null,
  SELAPPNAME      VARCHAR(100) null,
  SELDATETIME     DATETIME NULL,
  SELWORKSTATION  VARCHAR(60) null,
  SELOPERID       VARCHAR(8) null,
  SELERRCODE      VARCHAR(8) null,
  SELERRTEXT      VARCHAR(255) null,
  SELERRWHERE     VARCHAR(100) null,
  SELERREVENT     VARCHAR(100) null,
  SELERROBJECT    VARCHAR(100) null,
  SELERRLINE      VARCHAR(4) null,
  SELSQLERRCODE   VARCHAR(8) null,
  SELSQLDBERRCODE VARCHAR(8) null,
  SELSQLERRTEXT   VARCHAR(255) null,
  SELSERVERNAME   VARCHAR(60) null,
  SELDATABASE     VARCHAR(60) null,
  SELTRANSLATION  VARCHAR(255) null,
  SELSQLTRANS     VARCHAR(255) null,
  constraint PK_SYSERRORLOG primary key (SELSEQNO)
)
go

create table SYSFILETYPE
(
  SFID    CHAR(2) not null,
  SFNAME  CHAR(3) not null,
  SFDESC  VARCHAR(80) null,
  SFCOUNT NUMERIC null,
  SFICO   VARCHAR(100) default 'ico\unkown.ico' not null,
  constraint PK_SYSFILETYPE primary key (SFID,SFNAME)
)
go

create table SYSLIBOBJECT
(
  SLOID      VARCHAR(5) not null,
  SLOLIBNAME VARCHAR(255) not null,
  SLONAME    VARCHAR(255) not null,
  SLOLASTMOD VARCHAR(32) null,
  SLOCOMMENT VARCHAR(255) null,
  SLOTYPE    VARCHAR(32) null,
  constraint PK_SYSLIBOBJECT primary key (SLOID)
)
go

create table SYSLIBRARY
(
  SLID     CHAR(2) not null,
  SLFILE   VARCHAR(255) not null,
  SLDESC   VARCHAR(60) null,
  SLSTATUS CHAR(1) default 'Y' not null,
  SLNEW    CHAR(1) null,
  constraint PK_SYSLIBRARY primary key (SLID)
)
go

create table SYSMANAFRAME
(
  SMFCODE   VARCHAR(20) not null,
  SMFNAME   VARCHAR(40) not null,
  SMFCLASS  NUMERIC default 1 not null,
  SMFGCODE  VARCHAR(20) null,
  SMFPCODE  VARCHAR(20) default '0' not null,
  SMFISLAST CHAR(1) default 'N' not null,
  SMFSTATUS CHAR(1) default 'Y' not null,
  SMFMEMO   VARCHAR(200) null,
  constraint PK_SYSMANAFRAME primary key (SMFCODE)
)
go

create table SYSMANAPARA
(
  SMPID     VARCHAR(6) not null,
  SMPPID    VARCHAR(6) not null,
  SMPPDESC  VARCHAR(40) null,
  SMPPVALUE VARCHAR(100) null,
  SMPPTYPE  CHAR(1)
)
go

create table SYSPARA
(
  SPID       CHAR(4) not null,
  SPTYPE     CHAR(2) not null,
  SPTYPEDESC VARCHAR(16) not null,
  SPDESC     VARCHAR(80) not null,
  SPDESCDESC VARCHAR(80) null,
  SPEDITABLE VARCHAR(1) default 'N',
  constraint PK_SYSPARA primary key (SPID)
)
go

create table SYSPRINTCONFIG
(
  SPCID     VARCHAR(10) not null,
  SPCNAME   VARCHAR(50) null,
  SPCCONFIG VARCHAR(300) null,
  SPCCNAME  VARCHAR(50) null,
  constraint PK_SYSPRINTCONFIG primary key (SPCID)
)
go

create table SYSPROCEDURERUNLOG
(
  SPRLID          VARCHAR(10) not null,
  SPRLBEGDATE     DATETIME NULL,
  SPRLENDDATE     DATETIME not null,
  SPRLSPNAME      VARCHAR(60) not null,
  SPRLOKFLAG      CHAR(1) default 'N' not null,
  SPRLERRMSG      VARCHAR(255) null,
  SPRLOTHMSG      VARCHAR(255) null,
  SPRLIP          VARCHAR(20) not null,
  SPRLOSUSER      VARCHAR(25) null,
  SPRLMACHINE     VARCHAR(25) null,
  SPRLSESSIONUSER VARCHAR(25) null,
  constraint PK_SYS_PROCEDURE_RUNLOG primary key (SPRLID)
)
go

create table SYSSEQLIST
(
  SSLTBLNAME VARCHAR(60) not null,
  SSLSEQNAME VARCHAR(60) not null,
  SSLPREFIX  VARCHAR(10) null,
  SSLWIDTH   NUMERIC(2) not null,
  SSLCNAME   VARCHAR(60) null,
  SSLSTARTNO NUMERIC(10) null,
  constraint PK_SYSSEQLIST primary key (SSLTBLNAME)
)
go

create table SYSWORKSTATION
(
  SWID      VARCHAR(5) not null,
  SWNAME    VARCHAR(40) null,
  SWIP      VARCHAR(15) null,
  SWSTATUS  CHAR(1) default 'N',
  SWUPDATED CHAR(1) default 'N',
  SWONLINE  CHAR(1) default 'N',
  SWOPERID  VARCHAR(15) null,
  constraint PK_SYSWORKSTION primary key (SWID)
)
GO