12345系統(tǒng)和三臺合一對接方案

1、12345系統(tǒng)和三臺合一對接方案三臺合一提供110接警單和110反饋單(表結(jié)構(gòu)如下)，12345系統(tǒng)提供12345 系統(tǒng)中事件表和反饋表。情報中心通過邊界同步四張表。業(yè)務(wù)流程如下一、三臺合一系統(tǒng)發(fā)送警情到12345系統(tǒng)(1)三臺合一系統(tǒng)將警情信息寫入公安網(wǎng) T_12345ZJB表(2)情報中心通過邊界將公安網(wǎng) T_12345ZjBh同步至IJ政務(wù)外網(wǎng)T_12345ZJB 表12345系統(tǒng)獲取政務(wù)外網(wǎng)T_12345ZJBg中數(shù)據(jù)，將clbz字段置1。12345系統(tǒng)將反饋信息寫入直務(wù)外網(wǎng)t_xtgafk。情報中心通過邊界將政務(wù)外網(wǎng)t_xtgafk數(shù)據(jù)同步到公安網(wǎng)t_xtgafk 表中三臺合一系統(tǒng)獲

2、取公安網(wǎng)t_xtgafk表中數(shù)據(jù)，將rch0字段置1.二、12345系統(tǒng)發(fā)送警情到三臺合一系統(tǒng)12345系統(tǒng)將事件信息寫入政務(wù)外網(wǎng)t_xtgadj表(2)情報中心通過邊界政務(wù)外網(wǎng)將t_xtgadj表同步到公安網(wǎng)t_xtgadj表(3)三臺合一系統(tǒng)獲取公安網(wǎng)t_xtgadj表中數(shù)據(jù)，將rch0字段置1。(4)三臺合一系統(tǒng)將反饋信息寫入公安網(wǎng) T_12345FKD(5)情報中心通過邊界將公安網(wǎng)T_12345FKE據(jù)同步到政務(wù)外網(wǎng)T_12345FKDg中(6) 12345系統(tǒng)獲取政務(wù)外網(wǎng)T_12345FKDfe中數(shù)據(jù)，將clbz字段置1.表結(jié)構(gòu)1、T_12345FKD表create table T_

3、12345FKD (sjdbhVARCHAR2(40) notnull,cjdbhVARCHAR2(40) notnull,zldbhVARCHAR2(40) notnull,fkdbhVARCHAR2(40) notnull,fksjDATE,fkdwdmVARCHAR2(12),fkdwmcVARCHAR2(80),fkr fknrclbz gxsj )VARCHAR2(100),VARCHAR2(4000), NUMBER(2) default 0, DATE;commenton table T_12345FKDis12345反饋單;commenton column T_12345FKD

4、.sjdbhis事件單號; 一commenton column T_12345FKD.cjdbhis處警單號; 一commenton column T_12345FKD.zldbhis指令單號; 一commenton column T_12345FKD.fkdbhis反饋單號;commenton column T_12345FKD.fksjis反饋時間；commenton column T_12345FKD.fkdwdmis反饋單位代碼;commenton column T_12345FKD.fkdwmcis反饋單位名稱;一commenton column T_12345FKD.fkris反饋

5、人；commenton column T_12345FKD.fknris反饋內(nèi)容； 一commenton column T_12345FKD.clbzis處理標(biāo)志0未處理1已處理;commenton column T_12345FKD.gxsjis更新時間；create index IDX_12345 on T_12345FKD (GXSJ);alter table T_12345FKDadd constraint PK_12345FKD primary key (FKDBH);2、T_12345ZJB表create table T_12345ZJB (sjdbhVARCHAR2(40) no

6、t null,bjrVARCHAR2(100),bjrxbNUMBER(1),lxdhVARCHAR2(20),lxdzVARCHAR2(200),VARCHAR2(200),VARCHAR2(4000),VARCHAR2(12),VARCHAR2(12),DATE,VARCHAR2(40),VARCHAR2(40),DATE default sysdate, NUMBER(2) default 0, VARCHAR2(80),VARCHAR2(80)table T_12345ZJB上報12345系統(tǒng)案事件中問表;T_12345ZJB.sjdbhsfdz sjxq aydm xqdwdm sc

7、bjsj cjdbh zldbh gxsj clbzaymc xqdwmc) ;comment on iscomment on columnis 事件單號;comment on columnis 報警人； comment on columnis 報警人性別1 comment on columnis 聯(lián)系電話； comment on columnis 聯(lián)系地址;comment on columnis 事發(fā)地址;comment on columnis 報警內(nèi)容； comment on columnis 案由代碼； comment on columnis 轄區(qū)單位代碼 comment on colu

8、mnis 報警時間； comment on columnis 處警單號; comment on columnis 指令單號;comment on columnis 更新時間； comment on columnT_12345ZJB.bjrT_12345ZJB.bjrxb 男0女； T_12345ZJB.lxdhT_12345ZJB.lxdzT_12345ZJB.sfdzT_12345ZJB.sjxqT_12345ZJB.aydmT_12345ZJB.xqdwdmI ;T_12345ZJB.scbjsjT_12345ZJB.cjdbhT_12345ZJB.zldbhT_12345ZJB.gxsj

9、T_12345ZJB.clbzis 處理標(biāo)志0未處理1已處理;comment on column T_12345ZJB.aymcis 案由名稱；comment on column T_12345ZJB.xqdwmcis ,轄區(qū)單位名稱;create index IDX_12345ZJB on T_12345ZJB (GXSJ);alter table T_12345ZJBadd constraint PK_12345ZJB primary key (SJDBH);3、T_XTGADJ1create table T_XTGADJ(code VARCHAR2(100) not null, apdt

10、 DATE,apph VARCHAR2(100) not null, apnm VARCHAR2(100), sexu NUMBER(1), ctad VARCHAR2(200), evad VARCHAR2(200), evif VARCHAR2(4000), evex DATE,dept VARCHAR2(100), evtp VARCHAR2(100), evbp VARCHAR2(100), stat NUMBER(1),memo VARCHAR2(1000),rch0 VARCHAR2(255), rch1 VARCHAR2(255), rch2 VARCHAR2(255), rch

11、3 VARCHAR2(255), rch4 VARCHAR2(255), rch5 VARCHAR2(255), rch6 VARCHAR2(255), rch7 VARCHAR2(255), munm VARCHAR2(40), mtmp DATE)tablespace DSDB_DEFAULT_DATA pctfree 10 initrans 1maxtrans 255 storage (initial 16next 8 minextents 1 maxextents unlimited )；-Add comments to the columns comment on column T_

12、XTGADJ.code is 事件編號;一comment on column T_XTGADJ.apdt is 申訴時間；comment on column T_XTGADJ.apph is 申訴號碼；comment on column T_XTGADJ.apnm is 申訴人；comment on column T_XTGADJ.memo is 備注；comment on column T_XTGADJ.rch0 is 保留字符串0;comment on column T_XTGADJ.rch1 is 保留字符串1;comment on column T_XTGADJ.rch2 is 保留字

13、符串2;comment on column T_XTGADJ.rch3 is 保留字符串3;comment on column T_XTGADJ.rch4 is 保留字符串4;comment on column T_XTGADJ.rch5 is 保留字符串5;comment on column T_XTGADJ.rch6 is 保留字符串6;comment on column T_XTGADJ.rch7 is 保留字符串7;T_XTGAF展create table T_XTGAFK (t_xtgadj_code VARCHAR2(100) not null, evfbVARCHAR2(4000

14、) not null,codeVARCHAR2(100) not null,deptVARCHAR2(100),operVARCHAR2(100),fbdtDATE,statNUMBER(1),memo VARCHAR2(1000),rch0VARCHAR2(255),rchlVARCHAR2(255),rch2VARCHAR2(255),rch3VARCHAR2(255),rch4VARCHAR2(255),rch5VARCHAR2(255),rch6VARCHAR2(255),rch7VARCHAR2(255),munmVARCHAR2(100),mtmpDATE) tablespace

15、DSDB_DEFAULT_DATApctfree 10 initrans 1 maxtrans 255 storage ( initial 16 next 8 minextents 1 maxextents unlimited);-Add comments to the columnscomment on column T_XTGAFK.t_xtgadj_code is 事件編碼;comment on column T_XTGAFK.evfbis 反饋信息；comment on column T_XTGAFK.code is 編碼；comment on column T_XTGAFK.dept is 反饋單位;comment on column T_XTGAFK.oper is 反饋人； 一comment on column T_XTGAFK.memo is 備注；comment on column T_XTGAFK.rch0is 保留字符串0;comment on column T_XTGAFK.rch1is 保留字符串1;comment on column T_XTGAFK.rch2