📄 config_ora.sql
字号:
reducetaskid SMALLINT default 0 not null,
taskdesc VARCHAR2(64),
state NUMBER(1) default 1
constraint CKC_STATE_NEW_TASK check (state is null or ( state in (1,0) )),
constraint PK_NEW_TASKINFO primary key (taskid)
)
/
/*==============================================================*/
/* Table: new_tkgp_task */
/*==============================================================*/
create table new_tkgp_task (
taskid SMALLINT not null,
offinum CHAR(8) not null,
tkgp CHAR(16) not null,
constraint PK_NEW_TKGP_TASK primary key (taskid, offinum, tkgp),
constraint FK_NEW_TASK_REFERENCE_NEWTASK1 foreign key (taskid)
references new_taskinfo (taskid)
)
/
/*==============================================================*/
/* Table: new_tkgpconfig */
/*==============================================================*/
create table new_tkgpconfig (
offinum CHAR(8) not null,
tkgp CHAR(16) not null,
tkgptype NUMBER(1) default 0 not null
constraint CKC_TKGPTYPE_NEW_TKGP check (tkgptype in (0,1,2,3)),
jx SMALLINT default 0 not null,
content VARCHAR2(32),
signtype VARCHAR2(32),
insignflag VARCHAR2(32),
outsignflag VARCHAR2(32),
inmemflag VARCHAR2(32),
outmemflag VARCHAR2(32),
ncit SMALLINT,
constraint PK_NEW_TKGPCONFIG primary key (offinum, tkgp)
)
/
/*==============================================================*/
/* Table: new_tkgpdest_task */
/*==============================================================*/
create table new_tkgpdest_task (
taskid SMALLINT not null,
offinum CHAR(8) not null,
tkgp CHAR(16) not null,
dest CHAR(16) not null,
constraint PK_NEW_TKGPDEST_TASK primary key (taskid, offinum, tkgp, dest),
constraint FK_NEW_TASK_REFERENCE_NEWTASK2 foreign key (taskid)
references new_taskinfo (taskid)
)
/
/*==============================================================*/
/* Table: new_tkgpdestinfo */
/*==============================================================*/
create table new_tkgpdestinfo (
offinum CHAR(8) not null,
tkgp CHAR(16) not null,
dest CHAR(16) not null,
content VARCHAR2(32),
billno SMALLINT default 0 not null,
starttime DATE,
endtime DATE,
period NUMBER(2) default 60,
tkgptype NUMBER(1) default 0 not null
constraint CKC_TKGPTYPE_NEW_TKGPD check (tkgptype in (0,1,2,3)),
constraint PK_NEW_TKGPDESTINFO primary key (offinum, tkgp, dest, billno)
)
/
/*==============================================================*/
/* Table: new_tkgpjxinfo */
/*==============================================================*/
create table new_tkgpjxinfo (
offinum CHAR(8) not null,
tkgp CHAR(16) not null,
jx_ch INTEGER not null,
dest CHAR(16) default 'A' not null,
content VARCHAR2(32),
starttime DATE,
endtime DATE,
billno SMALLINT default 0 not null,
period NUMBER(2) default 60,
constraint PK_NEW_TKGPJXINFO primary key (offinum, tkgp, jx_ch, dest, billno)
)
/
/*==============================================================*/
/* Table: new_tkgptkgpinfo */
/*==============================================================*/
create table new_tkgptkgpinfo (
offinum CHAR(8) not null,
tkgp_r CHAR(16) not null,
tkgp_ch CHAR(16) not null,
dest CHAR(16) default 'A' not null,
content VARCHAR2(32),
starttime DATE,
endtime DATE,
billno SMALLINT default 0 not null,
period NUMBER(2) default 60,
constraint PK_NEW_TKGPTKGPINFO primary key (offinum, tkgp_r, tkgp_ch, dest, billno)
)
/
/*==============================================================*/
/* Table: new_trafficalarm */
/*==============================================================*/
create table new_trafficalarm (
offinum CHAR(8) not null,
tkgp CHAR(16) not null,
tkgptype NUMBER(1) default 1 not null
constraint CKC_TKGPTYPE_NEW_TRAF check (tkgptype in (1,2,3)),
itemid SMALLINT not null,
m_date DATE not null,
almlevel NUMBER(1),
itemvalue FLOAT,
ctime DATE,
constraint PK_NEW_TRAFFICALARM primary key (offinum, tkgp, tkgptype, itemid, m_date),
constraint FK_NEW_TRAF_REFERENCENEWMONI21 foreign key (itemid)
references new_monitorparaminfo (itemid)
)
/
/*==============================================================*/
/* Table: new_trafficalarm_cpu */
/*==============================================================*/
create table new_trafficalarm_cpu (
offinum CHAR(8) not null,
cpu_name CHAR(10) not null,
itemid SMALLINT not null,
m_date DATE not null,
almlevel NUMBER(1),
itemvalue FLOAT,
ctime DATE,
constraint PK_NEW_TRAFFICALARM_CPU primary key (itemid, offinum, cpu_name, m_date),
constraint FK_NEW_TRAF_REFERENCENEWMONI23 foreign key (itemid)
references new_monitorparaminfo (itemid)
)
/
/*==============================================================*/
/* Table: new_usergroupinfo */
/*==============================================================*/
create table new_usergroupinfo (
offinum CHAR(8) not null,
pbxid SMALLINT not null,
content VARCHAR2(32),
billno SMALLINT default 0 not null,
starttime DATE,
endtime DATE,
period NUMBER(2) default 60,
constraint PK_NEW_USERGROUPINFO primary key (offinum, pbxid, billno)
)
/
/*==============================================================*/
/* Table: new_userlog */
/*==============================================================*/
create table new_userlog (
logdate DATE not null,
station CHAR(15) not null,
syscode CHAR(4),
usercode CHAR(6) not null,
operation LONG,
constraint PK_NEW_USERLOG primary key (logdate, station, usercode)
)
/
/*==============================================================*/
/* Table: new_userunitinfo */
/*==============================================================*/
create table new_userunitinfo (
offinum CHAR(8) not null,
subunit CHAR(16) not null,
content VARCHAR2(32),
billno SMALLINT default 0 not null,
starttime DATE,
endtime DATE,
period NUMBER(2) default 60,
constraint PK_NEW_USERUNITINFO primary key (offinum, subunit, billno)
)
/
/*==============================================================*/
/* Table: offistatus */
/*==============================================================*/
create table offistatus (
offinum CHAR(8) not null,
lanid SMALLINT,
cname VARCHAR(16),
tandom CHAR(1),
exch_class CHAR(4),
ip_address VARCHAR(20),
alarmport SMALLINT default 6688 not null,
trafficport SMALLINT default 8866 not null,
tserverport SMALLINT default 8888 not null,
spc_mode VARCHAR(6),
softversion VARCHAR(20),
hardversion VARCHAR(20),
person VARCHAR(20),
phone VARCHAR(16),
fax VARCHAR(16),
email VARCHAR(30),
billflag NUMBER(1) default 1 not null
constraint CKC_BILLFLAG_OFFISTAT check (billflag in (1,0)),
dispatchid SMALLINT,
dispatch1id SMALLINT,
state NUMBER(1) default 1 not null
constraint CKC_STATE_OFFISTAT check (state in (1,0)),
constraint PK_OFFISTATUS primary key (offinum)
)
/
/*==============================================================*/
/* Table: routes_table */
/*==============================================================*/
create table routes_table (
offinum CHAR(8) not null,
tkgp CHAR(16) not null,
content VARCHAR2(32),
compid SMALLINT default 0 not null,
B_offinum CHAR(8) default '0' not null,
billno SMALLINT default 0 not null,
starttime DATE,
endtime DATE,
period NUMBER(2) default 60,
tkgptype NUMBER(1) default 0 not null
constraint CKC_TKGPTYPE_ROUTES_T check (tkgptype in (0,1,2,3)),
build_attr NUMBER(1) default 1 not null
constraint CKC_BUILD_ATTR_ROUTES_T check (build_attr in (1,2,3)),
constraint PK_ROUTES_TABLE primary key (tkgp, offinum, billno)
)
/
/*==============================================================*/
/* Table: subsys */
/*==============================================================*/
create table subsys (
syscode CHAR(4) not null,
sysname VARCHAR2(60),
syslevel NUMBER(1),
isavail NUMBER(1),
isdept NUMBER(1),
constraint PK_SUBSYS primary key (syscode)
)
/
/*==============================================================*/
/* Table: sysparam */
/*==============================================================*/
create table sysparam (
section CHAR(8) not null,
type CHAR(8) not null,
value CHAR(10),
tag CHAR(1),
constraint PK_SYSPARAM primary key (section, type)
)
/
/*==============================================================*/
/* Table: ta21 */
/*==============================================================*/
create table ta21 (
offinum CHAR(8) not null,
jx_r INTEGER not null,
jx_ch INTEGER not null,
dest CHAR(16) default 'A' not null,
ncit_r INTEGER,
ncit_ch INTEGER,
ncct_r FLOAT,
ncct_ch FLOAT,
pegs INTEGER,
seiz_r INTEGER,
seiz_ch INTEGER,
succ INTEGER,
answ INTEGER,
cbsy INTEGER,
serl_r FLOAT,
serl_ch FLOAT,
rerl FLOAT,
noansw INTEGER,
opblock INTEGER,
localbusy INTEGER,
tollbusy INTEGER,
overflow INTEGER,
vacant INTEGER,
termcall INTEGER,
termansw INTEGER,
transcall INTEGER,
transansw INTEGER,
reselect INTEGER,
allbusy SMALLINT,
allbusytime INTEGER,
locerr INTEGER,
nores INTEGER,
sysfault INTEGER,
item_no SMALLINT not null,
period NUMBER(2),
time DATE not null,
constraint PK_TA21 primary key (offinum, jx_r, jx_ch, dest, item_no, time)
)
/
/*==============================================================*/
/* Table: ta22 */
/*==============================================================*/
create table ta22 (
offinum CHAR(8) not null,
jx_r INTEGER not null,
tkgp CHAR(16) not null,
dest CHAR(16) default 'A' not null,
ncit_r INTEGER,
ncit_ch INTEGER,
ncct_r FLOAT,
ncct_ch FLOAT,
pegs INTEGER,
seiz_r INTEGER,
seiz_ch INTEGER,
succ INTEGER,
answ INTEGER,
cbsy INTEGER,
serl_r FLOAT,
serl_ch FLOAT,
rerl FLOAT,
noansw INTEGER,
opblock INTEGER,
localbusy INTEGER,
tollbusy INTEGER,
overflow INTEGER,
vacant INTEGER,
termcall INTEGER,
termansw INTEGER,
transcall INTEGER,
transansw INTEGER,
reselect INTEGER,
allbusy SMALLINT,
allbusytime INTEGER,
locerr INTEGER,
nores INTEGER,
sysfault INTEGER,
item_no SMALLINT not null,
period NUMBER(2),
time DATE not null,
constraint PK_TA22 primary key (offinum, jx_r, tkgp, dest, item_no, time)
)
/
/*==============================================================*/
/* Table: ta23 */
/*==============================================================*/
create table ta23 (
offinum CHAR(8) not null,
tkgp CHAR(16) not null,
jx_ch INTEGER not null,
dest CHAR(16) default 'A' not null,
ncit_r INTEGER,
ncit_ch INTEGER,
ncct_r FLOAT,
ncct_ch FLOAT,
pegs INTEGER,
seiz_r INTEGER,
seiz_ch INTEGER,
succ INTEGER,
answ INTEGER,
cbsy ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -