-- 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
);
分享到:
相关推荐
输出结果中,我们可以看到被锁的表名为 basetab_mvpn。 五、锁表的释放 锁表的释放可以通过 onstat –u 命令来实现。例如: ``` onstat –u ``` 输出结果中,我们可以看到 owner 为 d656e774 的线程,_address ...
此外,如果用户状态为“激活”,还需查看RadiusDB中的basetab_0210表,检查stopseason字段,非零值意味着用户被暂停,需要进一步确认并调整。 - 用户登录时出现“1……2……3……4……”的提示,这代表四种常见...
- **授予实体权限**:使用`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基表 BaseTable是一个React表组件,可显示具有高性能和灵活性的大型数据集 安装 # npm npm install react-base-table --save # yarn yarn add react-base-table 用法 import BaseTable , { Column } ...// BaseTab