gd.sql

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

    maxextents 121
    pctincrease 0
  );
  
create table TGD_KPMODE
(
  VCFILENAME VARCHAR2(30) not null,
  LCONTENT   LONG RAW,
  LENGTH     NUMBER(10) default 0 not null,
  HGZL       NUMBER
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 110K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create unique index PK_GD_KPMODE on TGD_KPMODE (VCFILENAME)
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
  
create table TGD_KPXM
(
  ID     NUMBER(10) not null,
  EBIAOM CHAR(20),
  CBIAOM CHAR(20),
  XMMC   CHAR(20),
  LX     CHAR(1),
  BMMC   CHAR(20) not null,
  ZSCD   NUMBER(5),
  XSCD   NUMBER(5),
  XT     NUMBER(5),
  BB     NUMBER(5),
  KXG    NUMBER(5),
  CXXM   CHAR(3)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 40K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_KPYS
(
  YSMC  CHAR(20) not null,
  WJMXH NUMBER(5),
  HGZL  NUMBER(5)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_LINK
(
  VCLINKNAME   VARCHAR2(30) not null,
  VCRELATION   VARCHAR2(10),
  VCLEFT       VARCHAR2(30),
  VCCHINAME1   CHAR(20),
  VCTABLENAME1 CHAR(20),
  VCITEMCHI1   CHAR(20),
  VCITEMENG1   VARCHAR2(20) not null,
  VCCOMPARE    VARCHAR2(20) not null,
  VCCHINAME2   CHAR(20),
  VCTABLENAME2 CHAR(20),
  VCITEMCHI2   CHAR(20),
  VCITEMENG2   CHAR(20),
  VCRIGHT      VARCHAR2(10),
  VCUSE        CHAR(10),
  IORDERNUM    VARCHAR2(8) not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_OPTION
(
  DZ       CHAR(2),
  QYYF     CHAR(7),
  GDDZKM   CHAR(30),
  ZJDZKM   CHAR(30),
  NOYMJZ   CHAR(2),
  LJZD     CHAR(2),
  WCDZYW   CHAR(2),
  GDRZKM   CHAR(30),
  ZJRZKM   CHAR(30),
  ZYZJFF   CHAR(30),
  FPZQ     CHAR(6),
  TZZJ     CHAR(2),
  SCKP     CHAR(4),
  JTZJ     CHAR(1),
  JZZBDZKM CHAR(30),
  JZZBRZKM CHAR(30)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_ORIGINCHANGED
(
  KPBH      CHAR(25) not null,
  DJH       VARCHAR2(10) not null,
  BDQZJLYDM CHAR(10),
  BDQZJLYMC CHAR(40),
  BDHZJLYDM CHAR(10),
  BDHZJLYMC CHAR(40),
  BDRQ      CHAR(10),
  JSR       VARCHAR2(10),
  BDYY      VARCHAR2(40),
  BDQZY     CHAR(40)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_OTHERMODE
(
  VCFILENAME CHAR(20) not null,
  LCONTENT   LONG RAW,
  LENGTH     NUMBER(10),
  TCHINAME   CHAR(20)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
  
alter table TGD_OTHERMODE
  add constraint PK_TGD_OTHERMODE primary key (VCFILENAME)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );

create table TGD_OTHERXM
(
  ID       NUMBER(10) not null,
  TENGNAME CHAR(20) not null,
  TCHINAME CHAR(20),
  XMMC     CHAR(20),
  LX       CHAR(1),
  BMMC     CHAR(20) not null,
  ZSCD     NUMBER(5),
  XSCD     NUMBER(5),
  KPUSED   CHAR(1)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_PLZD<<YEAR>>
(
  ID     NUMBER(10) not null,
  DJH    CHAR(10) not null,
  JLBH   NUMBER(5),
  KJQJ   NUMBER(5),
  YW     CHAR(2),
  DJLX   CHAR(28),
  KMDM   VARCHAR2(40),
  FX     CHAR(2),
  JE     NUMBER(15,2),
  ZDBZ   CHAR(4),
  PZZL   CHAR(4),
  PZKJQJ NUMBER(5)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 430K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_QUERYSET
(
  VCQUERYNAME VARCHAR2(30) not null,
  VCRELATION  VARCHAR2(10),
  VCLEFT      VARCHAR2(30),
  VCCHINAME   CHAR(20),
  VCTABLENAME CHAR(20),
  VCITEMCHI   CHAR(20),
  VCITEMENG   VARCHAR2(20) not null,
  VCCOMPARE   VARCHAR2(10) not null,
  VCVALUES    VARCHAR2(20),
  VCRIGHT     VARCHAR2(10),
  IORDERNUM   VARCHAR2(8) not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_SYZK
(
  DM     CHAR(4) not null,
  SYZKMC CHAR(20),
  SFJTZJ NUMBER(5)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_XFFF
(
  BH   CHAR(2),
  MC   CHAR(20),
  JSFF CHAR(40),
  USED CHAR(1)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_YEARADJUSTGS
(
  TZRQ    CHAR(10) not null,
  ZCLBBH  CHAR(10) not null,
  ZCLBMC  CHAR(30),
  TZQZJGS VARCHAR2(20),
  TZHZJGS VARCHAR2(20),
  JSR     VARCHAR2(20),
  TZYY    VARCHAR2(50)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_YSXM
(
  YSMC CHAR(20) not null,
  XMMC CHAR(20) not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );