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
