config_ora.sql

很好用的数据库连接组件

/*==============================================================*/
/* Table: new_centrexinfo                                       */
/*==============================================================*/


create table new_centrexinfo  (
   offinum              CHAR(8)                          not null,
   centrexid            SMALLINT                         not null,
   content              VARCHAR2(32),
   billno               SMALLINT                       default 0  not null,
   starttime            DATE,
   endtime              DATE,
   period               NUMBER(2)                       default 60,
   constraint PK_NEW_CENTREXINFO primary key (offinum, centrexid, billno)
)
/


/*==============================================================*/
/* Table: new_directioninfo                                     */
/*==============================================================*/


create table new_directioninfo  (
   offinum              CHAR(8)                          not null,
   directionid          SMALLINT                         not null,
   billno               SMALLINT                       default 0  not null,
   content              VARCHAR2(32),
   starttime            DATE,
   endtime              DATE,
   period               NUMBER(2)                       default 60,
   constraint PK_NEW_DIRECTIONINFO primary key (offinum, directionid, billno)
)
/


/*==============================================================*/
/* Table: new_jxconfig                                          */
/*==============================================================*/


create table new_jxconfig  (
   offinum              CHAR(8)                          not null,
   jx                   SMALLINT                         not null,
   defaultroute         SMALLINT,
   route1               SMALLINT,
   route2               SMALLINT,
   route3               SMALLINT,
   groupno              SMALLINT,
   content              VARCHAR2(32),
   compid               SMALLINT                       default 0  not null,
   ssf                  VARCHAR2(32),
   spc                  VARCHAR2(32),
   constraint PK_NEW_JXCONFIG primary key (offinum, jx)
)
/

/*==============================================================*/
/* Table: new_jx1config                                         */
/*==============================================================*/


create table new_jx1config  (
   offinum              CHAR(8)                          not null,
   jx                   SMALLINT                         not null,
   nettype              VARCHAR2(32),
   officetype           SMALLINT,
   linktype             VARCHAR2(32),
   areacode             VARCHAR2(32),
   content              VARCHAR2(32),
   compid               SMALLINT                       default 0  not null,
   ssf                  VARCHAR2(32),
   dpc                  VARCHAR2(32),
   connecttype          VARCHAR2(32),
   constraint PK_NEW_JX1CONFIG primary key (offinum, jx)
)
/


/*==============================================================*/
/* Table: new_jxjxinfo                                          */
/*==============================================================*/


create table new_jxjxinfo  (
   offinum              CHAR(8)                          not null,
   jx_r                 INTEGER                          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_JXJXINFO primary key (offinum, jx_r, jx_ch, dest, billno)
)
/


/*==============================================================*/
/* Table: new_jxtkgpinfo                                        */
/*==============================================================*/


create table new_jxtkgpinfo  (
   offinum              CHAR(8)                          not null,
   jx_r                 INTEGER                          not null,
   tkgp                 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_JXTKGPINFO primary key (offinum, jx_r, tkgp, dest, billno)
)
/


/*==============================================================*/
/* Table: new_laninfo                                           */
/*==============================================================*/


create table new_laninfo  (
   lanid                SMALLINT                         not null,
   lanname              VARCHAR2(32),
   xpos                 FLOAT,
   ypos                 FLOAT,
   state                NUMBER(1)                       default 0  not null
         constraint CKC_STATE_NEW_LANI check (state in (0,1)),
   constraint PK_NEW_LANINFO primary key (lanid)
)
/


/*==============================================================*/
/* Table: new_linkconfig                                        */
/*==============================================================*/


create table new_linkconfig  (
   offinum              CHAR(8)                          not null,
   linkid               SMALLINT                         not null,
   jx                   SMALLINT                       default 0  not null,
   groupid              SMALLINT,
   moduleid             SMALLINT,
   linkcode             SMALLINT,
   shelf                SMALLINT,
   sign                 SMALLINT,
   tkgpmodule           SMALLINT,
   tkgpunit             SMALLINT,
   childunit            SMALLINT,
   circleid             SMALLINT,
   content              VARCHAR2(32),
   constraint PK_NEW_LINKCONFIG primary key (offinum, linkid)
)
/


/*==============================================================*/
/* Table: new_linkgroupconfig                                   */
/*==============================================================*/


create table new_linkgroupconfig  (
   offinum              CHAR(8)                          not null,
   groupid              SMALLINT                         not null,
   jx                   SMALLINT                       default 0  not null,
   linknum              SMALLINT,
   checkflag            VARCHAR2(32),
   linktype             VARCHAR2(32),
   content              VARCHAR2(32),
   constraint PK_NEW_LINKGROUPCONFIG primary key (offinum, groupid)
)
/


/*==============================================================*/
/* Table: new_linkinfo                                          */
/*==============================================================*/


create table new_linkinfo  (
   offinum              CHAR(8)                          not null,
   linkid               SMALLINT                         not null,
   compid               SMALLINT                       default 0  not null,
   B_offinum            CHAR(8)                        default '0'  not null,
   billno               SMALLINT                       default 0  not null,
   content              VARCHAR2(32),
   starttime            DATE,
   endtime              DATE,
   period               NUMBER(2)                       default 60,
   constraint PK_NEW_LINKINFO primary key (offinum, linkid, billno)
)
/


/*==============================================================*/
/* Table: new_moduleinfo                                        */
/*==============================================================*/


create table new_moduleinfo  (
   offinum              CHAR(8)                          not null,
   module               CHAR(8)                          not null,
   traffictype          SMALLINT                       default 1  not null
         constraint CKC_TRAFFICTYPE_NEW_MODU check (traffictype in (1,2,3)),
   billno               SMALLINT                       default 0  not null,
   content              VARCHAR2(32),
   starttime            DATE,
   endtime              DATE,
   period               NUMBER(2)                       default 60,
   constraint PK_NEW_MODULEINFO primary key (offinum, module, traffictype, billno)
)
/


/*==============================================================*/
/* Table: new_monitorcodeinfo                                   */
/*==============================================================*/


create table new_monitorcodeinfo  (
   codeid               SMALLINT                         not null,
   lanid                SMALLINT                         not null,
   xpos                 FLOAT                            not null,
   ypos                 FLOAT                            not null,
   codename             VARCHAR2(32),
   flag                 NUMBER(1)                       default 0  not null
         constraint CKC_FLAG_NEWMONIc check (flag in (0,1)),
   content              VARCHAR2(32),
   constraint PK_NEW_MONITORCODEINFO primary key (codeid, lanid),
   constraint FK_NEW_CODE_REFERENCENEWLANI22 foreign key (lanid)
         references new_laninfo (lanid)
)
/


/*==============================================================*/
/* Table: new_monitorlineinfo                                   */
/*==============================================================*/


create table new_monitorlineinfo  (
   lineid               SMALLINT                         not null,
   lanid                SMALLINT                         not null,
   s_codeid             SMALLINT,
   e_codeid             SMALLINT,
   constraint PK_NEW_MONITORLINEINFO primary key (lineid, lanid),
   constraint FK_NEW_MONI_REFERENCENEWLANI24 foreign key (lanid)
         references new_laninfo (lanid)
)
/


/*==============================================================*/
/* Table: new_monitorparaminfo                                  */
/*==============================================================*/


create table new_monitorparaminfo  (
   itemid               SMALLINT                         not null,
   level1               FLOAT,
   level2               FLOAT,
   level3               FLOAT,
   level4               FLOAT,
   flag                 NUMBER(1)                       default 0  not null
         constraint CKC_FLAG_NEWMONIp check (flag in (0,1)),
   state                NUMBER(1)                       default 1  not null
         constraint CKC_STATE_NEW_MONI check (state in (0,1)),
   constraint PK_NEW_MONITORPARAMINFO primary key (itemid)
)
/


/*==============================================================*/
/* Table: new_monitortkgpinfo                                   */
/*==============================================================*/


create table new_monitortkgpinfo  (
   offinum              CHAR(8)                          not null,
   tkgp                 CHAR(16)                         not null,
   lineid               SMALLINT,
   lanid                SMALLINT,
   constraint PK_NEW_MONITORTKGPINFO primary key (offinum, tkgp),
   constraint FK_NEW_MONI_REFERENCE_NEW_MONI foreign key (lineid, lanid)
         references new_monitorlineinfo (lineid, lanid)
)
/


/*==============================================================*/
/* Table: new_no7tkgpinfo                                       */
/*==============================================================*/


create table new_no7tkgpinfo  (
   offinum              CHAR(8)                          not null,
   tkgp                 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_NO7TKGPINFO primary key (offinum, tkgp, billno)
)
/


/*==============================================================*/
/* Table: new_officeconfig                                      */
/*==============================================================*/


create table new_officeconfig  (
   offinum              CHAR(8)                          not null,
   officename           VARCHAR2(32),
   areacode             VARCHAR2(5),
   opc24                VARCHAR2(32),
   netfrtver            VARCHAR2(32),
   port                 INTEGER,
   serverver            VARCHAR2(64),
   mpver                VARCHAR2(32),
   jx                   VARCHAR2(32),
   testcode             VARCHAR2(32),
   countrycode          VARCHAR2(32),
   officecode           VARCHAR2(32),
   tollcode             VARCHAR2(32),
   selectcode           VARCHAR2(32),
   startlong            INTEGER,
   gatewaytype          VARCHAR2(32),
   networktype          VARCHAR2(32),
   officetype           INTEGER,
   signtype             VARCHAR2(32),
   busycode             VARCHAR2(32),
   constraint PK_NEW_OFFICECONFIG primary key (offinum)
)
/


/*==============================================================*/
/* Table: new_reportinfo                                        */
/*==============================================================*/


create table new_reportinfo  (
   reportid             SMALLINT                         not null,
   reportname           VARCHAR2(64)                     not null,
   itemwidth            SMALLINT                       default 0,
   state                NUMBER(1)                       default 1  
         constraint CKC_STATE_NEW_REPO check (state is null or ( state in (1,0) )),
   memo                 VARCHAR2(100),
   constraint PK_NEW_REPORTINFO primary key (reportid)
)
/


/*==============================================================*/
/* Table: new_reportiteminfo                                    */
/*==============================================================*/


create table new_reportiteminfo  (
   reportid             SMALLINT                         not null,
   itemid               SMALLINT                         not null,
   constraint PK_NEW_REPORTITEMINFO primary key (reportid, itemid),
   constraint FK_NEW_REPO_REFERENCE_NEWREPO9 foreign key (reportid)
         references new_reportinfo (reportid)
)
/


/*==============================================================*/
/* Table: new_reportsaveas                                      */
/*==============================================================*/


create table new_reportsaveas  (
   reportid             SMALLINT                         not null,
   flag                 SMALLINT                       default 0  not null
         constraint CKC_FLAG_NEW_REPO check (flag in (0,1)),
   busytime             SMALLINT                       default 0  not null,
   busytime1            SMALLINT                         not null,
   constraint PK_NEW_REPORTSAVEAS primary key (reportid),
   constraint FK_NEW_REPO_REFERENCE_NEWREPe foreign key (reportid)
         references new_reportinfo (reportid)
)
/


/*==============================================================*/
/* Table: new_statiteminfo                                      */
/*==============================================================*/


create table new_statiteminfo  (
   itemid               SMALLINT                         not null,
   itemname             VARCHAR2(40),
   flag                 NUMBER(1)                       default 1  
         constraint CKC_FLAG_NEW_STAT check (flag is null or ( flag in (0,1) )),
   statformula          VARCHAR2(100),
   dispformula          VARCHAR2(20),
   memo                 VARCHAR2(100),
   state                NUMBER(1)                       default 1,
   constraint PK_NEW_STATITEMINFO primary key (itemid)
)
/


/*==============================================================*/
/* Table: new_taskinfo                                          */
/*==============================================================*/


create table new_taskinfo  (
   taskid               SMALLINT                         not null,
   taskname             VARCHAR2(32)                     not null,
   flag                 NUMBER(1)                       default 1  not null
         constraint CKC_FLAG_NEW_TASK check (flag in (1,2,3,4,5)),