xt.sql

一个用VB写的财务软件源码

create table TCON_DAITEM
(
  CITMSYSCODING  CHAR(2) not null,
  CITMDACODING   VARCHAR2(8) not null,
  VCITMDACAPTION VARCHAR2(30),
  VCITMDANAME    VARCHAR2(30),
  CITMDAEDITION  CHAR(6),
  VCITMSYNOSIS   VARCHAR2(50),
  DITMREMOVE     DATE
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_ACCOUNT
(
  ACCOUNTID         VARCHAR2(4) not null,
  ACCOUNTNAME       VARCHAR2(20) not null,
  BEGINYEAR         CHAR(4) not null,
  BEGINMONTH        CHAR(2) not null,
  MASTER            VARCHAR2(8),
  CURRENCYNAME      VARCHAR2(10),
  ENTERNAME         VARCHAR2(60) not null,
  TELCODE           VARCHAR2(20),
  ADDRESS           VARCHAR2(80),
  ZIP               CHAR(6),
  EMAIL             VARCHAR2(40),
  TAXNO             VARCHAR2(20),
  LAW               VARCHAR2(20),
  ECONOMYPROPERTY   VARCHAR2(10),
  ENTERTYPE         VARCHAR2(10),
  TRADEID           NUMBER not null,
  VOUCHERPRINTMODE  VARCHAR2(8) not null,
  VOUCHERNUMBERMODE NUMBER default -1,
  SUBJECTONFRONT    NUMBER default 0,
  SEPARATECHAR      VARCHAR2(1) default 0,
  SEPARATESUBJECT   VARCHAR2(1) default 0               /*在定长情况下 ：0为不分隔,1代表分隔 */
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
alter table TSYS_ACCOUNT
  add constraint PK_SYS_ACCOUNT primary key (ACCOUNTID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_AUTH
(
  AUTHID       VARCHAR2(20) not null,
  AUTHNAME     VARCHAR2(40),
  AUTHMENUNAME VARCHAR2(60),
  BEND         NUMBER default 0              /*是否明细权限*/
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 16K
    minextents 1
    maxextents 121
    pctincrease 50
  );
alter table TSYS_AUTH
  add constraint PK_SYS_AUTH primary key (AUTHID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 16K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_MANAGE
(
  ID            NUMBER not null,
  COMPUTERNAME  VARCHAR2(100),
  SUBSYSID      VARCHAR2(2) not null,
  USERID        VARCHAR2(4) not null,
  ACCOUNTID     VARCHAR2(4) not null,
  ACCOUNTYEAR   CHAR(4),
  LOGINDATETIME DATE not null,
  RUNSTATE      VARCHAR2(8) default '正常',
  QUITDATETIME  DATE
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 124K
    minextents 1
    maxextents 121
    pctincrease 50
  );
alter table TSYS_MANAGE
  add constraint PK_SYS_MANGE primary key (ID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 36K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create index IK_SYS_MANAGE on TSYS_MANAGE (SUBSYSID,USERID,ACCOUNTID,ACCOUNTYEAR)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 124K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_MUTEXINFO
(
  SUBSYSID          CHAR(2) not null,
  AUTHMENUNAME      VARCHAR2(50) not null,
  MUTEXSUBSYSID     CHAR(2) not null,
  MUTEXAUTHMENUNAME VARCHAR2(50) not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 16K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create unique index PK_SYS_MUTEXINFO on TSYS_MUTEXINFO (SUBSYSID,AUTHMENUNAME,MUTEXSUBSYSID,MUTEXAUTHMENUNAME)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 16K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_MUTEXOBJECTINFO
(
  SUBSYSID            CHAR(2) not null,
  AUTHMENUNAME        VARCHAR2(50) not null,
  OBJECTMENUNAME      VARCHAR2(50) not null,
  MUTEXSUBSYSID       CHAR(2) not null,
  MUTEXAUTHMENUNAME   VARCHAR2(50) not null,
  MUTEXOBJECTMENUNAME VARCHAR2(50) not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create unique index PK_SYS_MUTEXOBJECTINFO on TSYS_MUTEXOBJECTINFO (SUBSYSID,AUTHMENUNAME,OBJECTMENUNAME,MUTEXSUBSYSID,MUTEXAUTHMENUNAME,MUTEXOBJECTMENUNAME)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_MUTEXOBJECTSTATUS
(
  IID            NUMBER not null,
  SUBSYSID       CHAR(2) not null,
  ACCOUNTID      VARCHAR2(4) not null,
  AUTHMENUNAME   VARCHAR2(50) not null,
  OBJECTMENUNAME VARCHAR2(50) not null,
  OBJECTSTATUS   VARCHAR2(30),
  OBJECTVALUE    VARCHAR2(200) not null,
  IP             VARCHAR2(15) not null,
  COMPUTERNAME   VARCHAR2(20),
  USERID         VARCHAR2(6)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
alter table TSYS_MUTEXOBJECTSTATUS
  add constraint PK_SYS_MUTEXOBJECTSTATUS primary key (IID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_MUTEXSTATUS
(
  IID          NUMBER not null,
  SUBSYSID     CHAR(2) not null,
  ACCOUNTID    VARCHAR2(4) not null,
  AUTHMENUNAME VARCHAR2(50) not null,
  IP           VARCHAR2(15) not null,
  COMPUTERNAME VARCHAR2(20) not null,
  USERID       VARCHAR2(6)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
alter table TSYS_MUTEXSTATUS
  add constraint PK_SYS_MUTEXSTATUS primary key (IID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_NAVIGATEMUSTER
(
  MODULEID            NUMBER,
  MODULECAPTION       VARCHAR2(30),
  BARID               NUMBER not null,
  BARCAPTION          VARCHAR2(30) not null,
  SUBMENUID           VARCHAR2(10) not null,
  SUBMENUCAPTION      VARCHAR2(30) not null,
  SUBMENUICONFILENAME VARCHAR2(50) not null,
  SUBMENUPROGRAMID    VARCHAR2(50) not null,
  ISVISIBLE           NUMBER default -1
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 20M
    next 20M
    minextents 1
    maxextents unlimited
    pctincrease 50
  );
alter table TSYS_NAVIGATEMUSTER
  add constraint PK_SYS_NAVIGATE primary key (MODULECAPTION,SUBMENUID);
create table TSYS_PERIOD
(
  ACCOUNTID VARCHAR2(4) not null,
  YEAR      CHAR(4) not null,
  PERIODID  NUMBER not null,
  FROMDATE  DATE not null,
  TODATE    DATE not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create unique index PK_SYS_PERIOD on TSYS_PERIOD (ACCOUNTID,YEAR,PERIODID)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_PZTYPE
(
  TYPEID   NUMBER not null,
  SIGNID   NUMBER not null,
  SIGN     CHAR(2) not null,
  SIGNTEXT VARCHAR2(40)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create unique index PK_SYS_PZTYPE on TSYS_PZTYPE (TYPEID,SIGNID)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_REGISTER
(
  VCCUSTOMERNAME VARCHAR2(50) not null,
  VCAUTHORIZENO  VARCHAR2(40) not null,
  VCSERIALNUMBER VARCHAR2(50) not null,
  DTUPDATE       DATE not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_SUBSYS
(
  SUBSYSID   VARCHAR2(2) not null,
  SUBSYSNAME VARCHAR2(20)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
alter table TSYS_SUBSYS
  add constraint PK_SYS_SUBSYS primary key (SUBSYSID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_SUBSYSUSED
(
  ACCOUNTID  VARCHAR2(4) not null,
  SUBSYSID   VARCHAR2(2) not null,
  BEGINYEAR  CHAR(4) not null,
  BEGINMONTH NUMBER not null,
  MODIYEAR   CHAR(4),
  MODIMONTH  NUMBER
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create unique index PK_SYS_SUBSYSUSED on TSYS_SUBSYSUSED (ACCOUNTID,SUBSYSID)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_TRADE
(
  ID      NUMBER not null,
  NAME    VARCHAR2(40),
  NAMEENG VARCHAR2(80)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
alter table TSYS_TRADE
  add constraint PK_SYS_TRADE primary key (ID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_TRADECODE
(
  TRADEID      NUMBER not null,
  CLASSNAME    VARCHAR2(20),
  CLASSNAMEENG VARCHAR2(40),
  KMDM         VARCHAR2(40) not null,
  KMMC         VARCHAR2(255),
  KMMCENG      VARCHAR2(80),
  KMJC         NUMBER not null,
  YEFX         CHAR(4) not null,
  ISENDKM      NUMBER default 0           /*是否末级科目*/
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 54K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create unique index PK_SYS_TRADECODE on TSYS_TRADECODE (TRADEID,KMDM)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 24K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_TRADECODECLASS
(
  TRADEID      NUMBER not null,
  CLASSSERIAL  NUMBER not null,
  CLASSNAME    VARCHAR2(20),
  CLASSNAMEENG VARCHAR2(40),
  YEFX         CHAR(4) not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create unique index PK_SYS_TRADECODECLASS on TSYS_TRADECODECLASS (TRADEID,CLASSSERIAL)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_USER
(
  USERID   VARCHAR2(4) not null,
  USERNAME VARCHAR2(8),
  PASSWORD VARCHAR2(20),
  TITYPE   NUMBER not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
alter table TSYS_USER
  add constraint PK_SYS_USER primary key (USERID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create table TSYS_USERAUTH
(
  ACCOUNTID VARCHAR2(4) not null,
  USERID    VARCHAR2(4) not null,
  AUTHID    VARCHAR2(20) not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 36K
    minextents 1
    maxextents 121
    pctincrease 50
  );
create unique index PK_SYS_USERAUTH on TSYS_USERAUTH (ACCOUNTID,USERID,AUTHID)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 82K
    minextents 1
    maxextents 121
    pctincrease 50
  );
 
 /* 以下两个表用于授权和站点控制  yigang 2003-08-27 */ 
 CREATE TABLE tSys_StationInfo 
    (SystemID  CHAR(40) not null,
     Pcid  CHAR(40) not null, 
     PcName  CHAR(100) ,
     LoginDate CHAR(8) not null 
    );
 ALTER TABLE tSys_StationInfo 
   ADD constraint YKCWSYSDB_KEY primary key (SystemID,Pcid);
 
 CREATE TABLE TSYS_SYSTEM 
    (SERIALNUMBER VARCHAR2(30) ,
     Enterprise VARCHAR2(100),
     LICENCE VARCHAR2(20),
     DBVAR VARCHAR2(10)
    );