`
Forestsai
  • 浏览: 20216 次
  • 性别: Icon_minigender_1
  • 来自: 南京
社区版块
存档分类
最新评论

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
  );

分享到:
评论
发表评论

文章已被作者锁定,不允许评论。

相关推荐

    如何解决informix数据库锁表问题.doc

    输出结果中,我们可以看到被锁的表名为 basetab_mvpn。 五、锁表的释放 锁表的释放可以通过 onstat –u 命令来实现。例如: ``` onstat –u ``` 输出结果中,我们可以看到 owner 为 d656e774 的线程,_address ...

    8-WLAN各类投诉处理方法-v2.pdf

    此外,如果用户状态为“激活”,还需查看RadiusDB中的basetab_0210表,检查stopseason字段,非零值意味着用户被暂停,需要进一步确认并调整。 - 用户登录时出现“1……2……3……4……”的提示,这代表四种常见...

    Oracle数据库的日常使用命令

    - **授予实体权限**:使用`grant select, insert on basetab to imuse01;`命令将表basetab上的SELECT和INSERT权限授予用户imuse01。 - **回收实体权限**:使用`revoke select on basetab from imuse01;`命令从用户...

    数据库设计和开发规范

    例如:`SYS_LOGTAB` 和 `DEV_BASETAB`。建议表名以英文单数形式命名。 #### 五、SQL语句规范 - **大小写规范**:所有SQL关键字、函数等应使用大写,其他部分使用小写。 - **分号终止**:每个SQL语句末尾必须加上...

    react-base-table:react表组件,用于显示具有高性能和灵活性的大型数据集

    React基表 BaseTable是一个React表组件,可显示具有高性能和灵活性的大型数据集 安装 # npm npm install react-base-table --save # yarn yarn add react-base-table 用法 import BaseTable , { Column } ...// BaseTab

Global site tag (gtag.js) - Google Analytics