BASETAB_810

-- Create table
create table BASETAB_810
(
  ACCOUNTAMOUNT    NUMBER(38),
  AREASCRFLAG      CHAR(1),
  CHARGEPULSE      NUMBER(38),
  CURRENTAMOUNT    NUMBER(38),
  CURRENTCALL      NUMBER(38),
  CURRENTDISCINDEX NUMBER(38),
  CURRENTDISCOUNT  NUMBER(38),
  CURRENTFEE       NUMBER(38),
  DEPARTCOUNT      NUMBER(38),
  DISCOUNTRATE1    NUMBER(38),
  DISCOUNTRATE2    NUMBER(38),
  DISCOUNTRATE3    NUMBER(38),
  DISCOUNTRATE4    NUMBER(38),
  DISCOUNTRATE5    NUMBER(38),
  DISCOUNTTYPE     CHAR(1),
  DISTRIBUTETYPE   CHAR(1),
  ENDMONTH         CHAR(8),
  ENDWEEKDAY       CHAR(8),
  UPNUMBER         CHAR(32),
  LANGUAGETYPE     CHAR(1),
  LIMITFLAG        CHAR(1),
  MAINMSG          NUMBER(38),
  MAXCALL          NUMBER(38),
  PINNUMBER        CHAR(10),
  REGISTDISCOUNT   NUMBER(38),
  ROUTEFLAG        NUMBER(38),
  STARTDATE        CHAR(8),
  STATISTICSTART   CHAR(8),
  STATISTICSTOP    CHAR(8),
  STOPDATE         CHAR(8),
  SUBSTATE         CHAR(1),
  TOPFEE1          NUMBER(38),
  TOPFEE2          NUMBER(38),
  TOPFEE3          NUMBER(38),
  TOPFEE4          NUMBER(38),
  TOPFEE5          NUMBER(38),
  TOTALFEE         NUMBER(38),
  USERIDENTIFIER   CHAR(28) not null,
  PUBLICUSERID     NUMBER(38),
  USERID           NUMBER(38),
  ROUTESEQUENCE    CHAR(4),
  SCP              NUMBER(38),
  SDP              NUMBER(38),
  DISCOUNTFLAG     CHAR(1),
  GROUPUSERFLAG    CHAR(1),
  REGISTDISCOUNT1  NUMBER(38),
  LIMITSTARTDATE   CHAR(8) default 00000000,
  LIMITSTOPDATE    CHAR(8) default '00000000',
  MANAGERPIN       CHAR(10) default 0,
  PREPINNUMBER     CHAR(10) default 0,
  INURETIME        CHAR(14) default 00000000000000,
  MOBILEAREAFLAG   CHAR(1) default 1,
  WELCOMEMSGFLAG   CHAR(1) default 0,
  WELCOMEMSGID     NUMBER(38) default 0,
  NAVIGATEMENUFLAG CHAR(1) default 0,
  NAVIGATEVOICEID  NUMBER(38) default 0,
  NAVROUTERNUMBER  NUMBER(38) default 0,
  IFWRITECALLINFO  CHAR(2),
  IFWRITEVOICEINFO CHAR(2),
  PLAYDVOICEFLAG   CHAR(2),
  FIXEDAREAFLAG    CHAR(2),
  BAKNUMSTATE      CHAR(2)
)
tablespace FOREST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table
comment on table BASETAB_810
  is '业务用户信息表';
-- Add comments to the columns
comment on column BASETAB_810.ACCOUNTAMOUNT
  is '费用限制上限';
comment on column BASETAB_810.AREASCRFLAG
  is '地区限制标志';
comment on column BASETAB_810.CHARGEPULSE
  is '计费修正值';
comment on column BASETAB_810.CURRENTAMOUNT
  is '当前呼叫费用';
comment on column BASETAB_810.CURRENTCALL
  is '当前呼叫次数';
comment on column BASETAB_810.CURRENTDISCINDEX
  is '当前折扣
索引
';
comment on column BASETAB_810.CURRENTDISCOUNT
  is '当前折扣';
comment on column BASETAB_810.CURRENTFEE
  is '当前费用或当前次数';
comment on column BASETAB_810.DEPARTCOUNT
  is '部门总数';
comment on column BASETAB_810.DISCOUNTRATE1
  is '折扣1';
comment on column BASETAB_810.DISCOUNTRATE2
  is '折扣2';
comment on column BASETAB_810.DISCOUNTRATE3
  is '折扣3';
comment on column BASETAB_810.DISCOUNTRATE4
  is '折扣4';
comment on column BASETAB_810.DISCOUNTRATE5
  is '折扣5';
comment on column BASETAB_810.DISCOUNTTYPE
  is '折扣种类';
comment on column BASETAB_810.DISTRIBUTETYPE
  is '分配方式';
comment on column BASETAB_810.ENDMONTH
  is '系统月月末';
comment on column BASETAB_810.ENDWEEKDAY
  is '系统周周末';
comment on column BASETAB_810.UPNUMBER
  is '业务用户号码';
comment on column BASETAB_810.LANGUAGETYPE
  is '语言种类';
comment on column BASETAB_810.LIMITFLAG
  is '限额方式';
comment on column BASETAB_810.MAINMSG
  is '主消息';
comment on column BASETAB_810.MAXCALL
  is '呼叫次数上限';
comment on column BASETAB_810.PINNUMBER
  is '密码';
comment on column BASETAB_810.REGISTDISCOUNT
  is '市话主叫分摊比例';
comment on column BASETAB_810.ROUTEFLAG
  is '路由选择';
comment on column BASETAB_810.STARTDATE
  is '开始日期';
comment on column BASETAB_810.STATISTICSTART
  is '统计开始日期';
comment on column BASETAB_810.STATISTICSTOP
  is '统计结束日期';
comment on column BASETAB_810.STOPDATE
  is '结束日期';
comment on column BASETAB_810.SUBSTATE
  is '用户状态';
comment on column BASETAB_810.TOPFEE1
  is '折扣的阀门值1';
comment on column BASETAB_810.TOPFEE2
  is '折扣的阀门值2';
comment on column BASETAB_810.TOPFEE3
  is '折扣的阀门值3';
comment on column BASETAB_810.TOPFEE4
  is '折扣的阀门值4';
comment on column BASETAB_810.TOPFEE5
  is '折扣的阀门值5';
comment on column BASETAB_810.TOTALFEE
  is '呼叫总费用';
comment on column BASETAB_810.USERIDENTIFIER
  is '业务用户唯一标识';
comment on column BASETAB_810.PUBLICUSERID
  is '业务用户组号';
comment on column BASETAB_810.USERID
  is '用户编号';
comment on column BASETAB_810.ROUTESEQUENCE
  is '路由选择次序';
comment on column BASETAB_810.SCP
  is 'scp编号';
comment on column BASETAB_810.SDP
  is 'Sdp编号';
comment on column BASETAB_810.DISCOUNTFLAG
  is '折扣类型';
comment on column BASETAB_810.GROUPUSERFLAG
  is '用户类型';
comment on column BASETAB_810.REGISTDISCOUNT1
  is '长话主叫分摊比例';
comment on column BASETAB_810.LIMITSTARTDATE
  is '限额开始日期';
comment on column BASETAB_810.LIMITSTOPDATE
  is '限额结束日期';
comment on column BASETAB_810.MANAGERPIN
  is '管理密码';
comment on column BASETAB_810.PREPINNUMBER
  is '预设密码';
comment on column BASETAB_810.INURETIME
  is '密码生效时间';
comment on column BASETAB_810.MOBILEAREAFLAG
  is '主叫手机区号判断标志';
comment on column BASETAB_810.WELCOMEMSGFLAG
  is '判断业务用户是否开通个性化欢迎词';
comment on column BASETAB_810.WELCOMEMSGID
  is '开通个性化欢迎词语音ID';
comment on column BASETAB_810.NAVIGATEMENUFLAG
  is '判断业务用户是否开通个性化导航菜单';
comment on column BASETAB_810.NAVIGATEVOICEID
  is '开通个性化导航菜单的一级导航菜单语音ID';
comment on column BASETAB_810.NAVROUTERNUMBER
  is '客户开通个性导航菜单默认的路由码';
comment on column BASETAB_810.IFWRITECALLINFO
  is '是否写呼叫统计信息';
comment on column BASETAB_810.IFWRITEVOICEINFO
  is '是否写语音播放统计信息';
comment on column BASETAB_810.PLAYDVOICEFLAG
  is '是否播放前转语音';
comment on column BASETAB_810.FIXEDAREAFLAG
  is '主叫固话区号判断标志';
comment on column BASETAB_810.BAKNUMSTATE
  is '备用号码状态';
-- Create/Recreate primary, unique and foreign key constraints
alter table BASETAB_810
  add constraint PRI_MARY primary key (USERIDENTIFIER)
  using index
  tablespace FOREST_DATA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes
create unique index BASETAB_810_A on BASETAB_810 (UPNUMBER)
  tablespace FOREST_DATA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
create index BUSERIDX on BASETAB_810 (USERID)
  tablespace FOREST_DATA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );