ra.sql

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

create table TRA_ADDRESS
(
  ID            NUMBER not null,
  COMPANYCODE   VARCHAR2(10) not null,
  COMPANYNAME   VARCHAR2(40) not null,
  CODE          VARCHAR2(10),
  ACCEPTADDRESS VARCHAR2(100) not null,
  USERNAME      VARCHAR2(20),
  PASSWORD      VARCHAR2(20),
  LINKMAN       VARCHAR2(15),
  TELEPHONE     VARCHAR2(80),
  FAX           VARCHAR2(20),
  ZIP           VARCHAR2(6),
  ADDRESS       VARCHAR2(100)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
comment on column TRA_ADDRESS.ID
  is '编号';
comment on column TRA_ADDRESS.COMPANYCODE
  is '统一单位编号';
comment on column TRA_ADDRESS.COMPANYNAME
  is '统一单位名称';
comment on column TRA_ADDRESS.CODE
  is '本地单位编号';
comment on column TRA_ADDRESS.ACCEPTADDRESS
  is '接收地址';
comment on column TRA_ADDRESS.USERNAME
  is '接收用户名';
comment on column TRA_ADDRESS.PASSWORD
  is '接收密码';
comment on column TRA_ADDRESS.LINKMAN
  is '联系人';
comment on column TRA_ADDRESS.TELEPHONE
  is '联系电话';
comment on column TRA_ADDRESS.FAX
  is '传真';
comment on column TRA_ADDRESS.ZIP
  is '邮编';
comment on column TRA_ADDRESS.ADDRESS
  is '地址';
alter table TRA_ADDRESS
  add constraint PK_RA_ADDRESS primary key (ID)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
create table TRA_NATIVESETTING
(
  ID            NUMBER not null,
  SUBSYSID      VARCHAR2(2) not null,
  TRANSMODE     VARCHAR2(20) not null,
  NATIVEADDRESS VARCHAR2(100) not null,
  USERNAME      VARCHAR2(20),
  PASSWORD      VARCHAR2(20),
  FLAG          NUMBER default 0
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
comment on column TRA_NATIVESETTING.ID
  is '编号';
comment on column TRA_NATIVESETTING.SUBSYSID
  is '子系统编号';
comment on column TRA_NATIVESETTING.TRANSMODE
  is '传送方式';
comment on column TRA_NATIVESETTING.NATIVEADDRESS
  is '本地地址';
comment on column TRA_NATIVESETTING.USERNAME
  is '用户名';
comment on column TRA_NATIVESETTING.PASSWORD
  is '密码';
comment on column TRA_NATIVESETTING.FLAG
  is '优先标志';
alter table TRA_NATIVESETTING
  add constraint PK_RA_NATIVESETTING primary key (ID)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
create table TRA_TRANSSETTING
(
  ID            NUMBER not null,
  SUBSYSID      VARCHAR2(2) not null,
  TITLE         VARCHAR2(100) not null,
  ACCEPTCOMPANY VARCHAR2(200) not null,
  CONTENT       VARCHAR2(3500),
  FLAG          NUMBER default 0 not null,
  LASTSENDDATE  DATE
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
comment on column TRA_TRANSSETTING.ID
  is '编号';
comment on column TRA_TRANSSETTING.SUBSYSID
  is '子系统代号';
comment on column TRA_TRANSSETTING.TITLE
  is '标题';
comment on column TRA_TRANSSETTING.ACCEPTCOMPANY
  is '接收单位';
comment on column TRA_TRANSSETTING.CONTENT
  is '传送内容';
comment on column TRA_TRANSSETTING.FLAG
  is '标志';
comment on column TRA_TRANSSETTING.LASTSENDDATE
  is '最后发送日期';
alter table TRA_TRANSSETTING
  add constraint PK_RA_TRANSSETTING primary key (ID)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );