火警受理数据表设计文档

目录

一、有效表.......................................................................1

车辆案件关系-表名：CLAJBQGXB...................................................................................................1

电话库-表名：DHK................................................................................................................................1

数据字典-表名：DM_SJZD..................................................................................................................1

数据字典描述-表名：DM_SJZD_MS.................................................................................................2

数据字典主表-表名：DM_SJZDZB....................................................................................................2

路段灭火信息车辆-表名：DZK_CL...................................................................................................3

路段灭火信息-表名：DZK_LDMHXX...............................................................................................3

路段灭火信息修改记录-表名：DZK_LDMHXXXGJL...................................................................5

路段水源信息图-表名：DZK_LDSYXX...........................................................................................5

路段信息-表名：DZK_LDXX.............................................................................................................5

水源方案-表名：DZK_SYFA..............................................................................................................6

水源方案与水源关系-表名：DZK_SYFAYSYGX...........................................................................6

路段水源信息-表名：DZK_SYXX.....................................................................................................6

黑名单表名：EYPB..............................................................................................................................6

110文字转警记录-表名：FIRE_RECEIVE_INFO............................................................................7

案件合并记录-表名：JCJ_AJHBJL.....................................................................................................9

案件合并记录-表名：JCJ_AJLXYUZJLY.......................................................................................10

案件信息表名：JCJ_AJXX.................................................................................................................10

案件状态变动记录-表名：JCJ.AJZTBDJL.....................................................................................16

报警记录-表名：JCJ_BJJL.................................................................................................................17

处警调度-表名：JCJ.CJDD................................................................................................................17

处警记录-表名：JCJ_CJJL.................................................................................................................18

处警信息-表名：JCJ_CJXX................................................................................................................18

车辆作战反馈记录-表名：JCJ_CLZZFKJL.....................................................................................19

调度对象-表名：JCJ_DDDX..............................................................................................................19

调度日志-表名：JCJ_DDRZ..............................................................................................................20

电话报警信息-表名：JCJ_DHBJXX.................................................................................................21

等级调度-表名：JCJ.DJDD..............................................................................................................22

调派器材-表名：JCJ.DPQC..............................................................................................................22

调派药剂-表名：JCJ.DPYJ...............................................................................................................23

调派应急联动单位-表名：JCJ_DPYJDW.......................................................................................24

调派专家-表名：JCJ_DPZJ...............................................................................................................24

接警记录-表名：JCJ_JJJL..................................................................................................................25

接警录音历史-表名：JCJJJLYLS....................................................................................................25

跨区域增援车辆出动单-表名：JCJ_KQYZYCLCDD...................................................................26

跨区域增援装备表名：JCJ_KQYZYZB..........................................................................................26

请求增援-表名：JCJ.QQZY.............................................................................................................27

短信发送-表名：JCJ_SMSSEND......................................................................................................27

视频调度-表名：JCJ.SPDD..............................................................................................................28

文电信息-表名：JCJ_WDXX............................................................................................................28

文书信息-表名：JCJ_WSXX.............................................................................................................29

现场信息-表名：JCJ_XCXX.............................................................................................................30

战斗情况-表名：JCJ_ZDQK.............................................................................................................31

战斗情况-表名：JCJ_ZDQKDY........................................................................................................31

战斗车辆出动编组一表名：JCJ_ZDCLCDBZ（标示车辆第一出动）....................31

作战车辆信息-表名：JCJ_ZZCLXX.................................................................................................32

联勤保障单位-表名：JGXX_LQBZDW..........................................................................................33

消防机构-表名：JGXX_XFJG...........................................................................................................34

应急联动单位-表名：JGXX_YJLDDW...........................................................................................36

装备保障能力-表名：JGXX_ZBBZNL.............................................................................................37

装备外部单位-表名：JGXX_ZBWBDW.........................................................................................38

人员基本信息-表名：RYXX_RYJBXX...........................................................................................39

人员通信录-表名：RYXX_RYTXL..................................................................................................40

社会专家-表名：RYXX_SHZJ..........................................................................................................41

社会专家领域-表名：RYXX_SHZJLY............................................................................................42

专家领域-表名：RYXX_ZJLY..........................................................................................................43

每日值班-表名：SWGL_ZBGL_MRZB..........................................................................................43

值班岗位-表名：SWGL_ZBGL_ZBLX...........................................................................................45

车辆信息-表名：WL_CLXX.............................................................................................................46

车辆状态变动记录-表名：WL_CLXX_CLZTBDJL......................................................................50

器材性能指标-表名：WL_QCXNZB................................................................................................51

装备明细账-表名：WL_ZBMXZ......................................................................................................52

装备器材定义信息-表名：WL.ZBQCDY.......................................................................................54

装备性能指标-表名：WL_ZBXNZB................................................................................................55

区县与操作台对照表-表名：XTB.QXCZT....................................................................................55

辖区与操作台对照表-表名：XTB.XQCZT....................................................................................56

系统操作台表-表名：XTB_XTCZTB...............................................................................................56

系统用户表-表名：XTB_XTYHB.....................................................................................................57

用户与操作台关系-表名：XTB.XTYHYCZTGX.........................................................................57

预案车辆调集-表名：YAGL.CLDJ..................................................................................................57

灭火预案单位一表名：YAGL_MHDW...............................................................................................58

预案分发索引-表名：YAGL.YAFFSY............................................................................................61

预案基本信息-表名：YAGL_YAJBXX...........................................................................................62

无线语音节点-表名：YYXT_WXYYJD.........................................................................................63

表名：ZBGL_FXFJGCL.....................................................................................................................64

气象信息-表名：ZBZB_QXXX.........................................................................................................65

视频监控点-表名：ZBZB_SPJKD....................................................................................................66

特种器材-表名：ZBZB_TZQCDY....................................................................................................68

消防机构毗邻优先级-表名：ZBZB_XFJGPLYXJ..........................................................................68

灾害作战功能-表名：ZBZB_ZHZZGN...........................................................................................69

作战功能-表名：ZBZB_ZZGN.........................................................................................................69

火场安全监控记录-表名：ZHDD_HCAQJKJL...............................................................................70

预案灾害映射表-表名：ZQSL_YAZHYSB.....................................................................................71

车辆状态变动申请表:WL_CLXX_CLZTBDSQB.........................................................................71

案件状态对应表:JCLAJZTDY..........................................................................................................72

案件状态设置表：JCJ_AJZTSZ........................................................................................................72

车辆状态对应表:JCJ_CLZTDY.........................................................................................................73

电台频道表:JCJ_DTPD.......................................................................................................................73

处置对象对应表:JCJ_CZDXDY........................................................................................................74

案件备用方案:JCJ_BYFA...................................................................................................................74

现场反馈下发表：JCJ_XCFKXF......................................................................................................75

车辆功能设置表：JCJ_CLGN...........................................................................................................75

车辆功能对应表:JCJ_CLZZGN.........................................................................................................75

地址标记错误表:JCLDZBJCW.........................................................................................................76

通知表:SWGL_TZ_XFTZ..................................................................................................................76

通知对象:SWGL_TZ_TZZD..............................................................................................................76

通知附件:SWGL_TZ_TZFJ.................................................................................................................77

公共留言表:SWGL_TZ_XFGG.........................................................................................................77

所属区县对应表:XZQYBHDYB.......................................................................................................78

案件类型对应表:AJLXDMDYB.......................................................................................................78

处置对象对应表:CZDXDYB............................................................................................................79

建筑结构对应表:JZJGDYB...............................................................................................................79

烟雾情况对应表:YWQKDYB...........................................................................................................79

系统操作台类型:XTB_XTCZTLXB..................................................................................................79

接处警调派领导:JCLDPLD..............................................................................................................80

数据字典对应表:JCLDMINFO.........................................................................................................80

车辆种类代码表:JCLCLZL................................................................................................................81

数据维护密码表：SJWHMMB..........................................................................................................81

变动字段配置表：JCJ_ALTERFIELD...............................................................................................81

变动信息表：JCJ_ALTERINFO.........................................................................................................81

车辆等级对照表:JCLCLDJDZB......................................................................................................82

调防方案表：JCJ_DFFAB..................................................................................................................82

调防方案表：JCJ_DFFAB..................................................................................................................83

调防方案记录表：JCJ_DFFAJLB.....................................................................................................83

JCJ_DLB................................................................................................................................................83

JCJ_DLZHB..........................................................................................................................................84

金山电话库：JCJ_JSDHK..................................................................................................................84

器材车对应表：JCJ_QCC...................................................................................................................84

用户操作日志表：JCJ_USERLOG....................................................................................................84

H0-119外部指令：JCJ_WBZL.........................................................................................................85

文书模板：JCJ_WSMB.......................................................................................................................85

系统配置表：JCJ_XTPZ.....................................................................................................................86

重点装备对应表：JCJ_ZDZBLX......................................................................................................87

发送短信领导列表：LDLB................................................................................................................87

Results.....................................................................................................................................................87

SJHMB..................................................................................................................................................87

值班岗位大屏显示顺序表SWGL_ZBGL_VIEW..........................................................................88

TJXCZXX............................................................................................................................................88

TEL88

车辆信息实体对象WL_CLDB..........................................................................................................88

记录车辆同步差异：WL_CLXX_SyncLog.....................................................................................91

WL_CLXXFIX......................................................................................................................................92

车辆状态审核页面优先级：XTB_CZTQXB...................................................................................92

XTB_YHQXB.......................................................................................................................................93

ZBZB_QXXX_TMP.............................................................................................................................93

110原始记录表：FIRE_RECEIVE_INFO........................................................................................94

二、已废弃..............................................................................97

已废弃CTI呼入记录-表名：CTI_CALL_IN_INF（DS调度机用的表）...................97

已废弃CTI-表名：CTI_CALL_QUEUE_RELEASE（DS调度机用的表）..................97

已废弃表名：CLZBQC_CLXX.....................................................................................................98

已废弃表名：CLZBQC_CLZBXX................................................................................................99

♦废弃：表名：CLZBQC_CLZTBDJL...........................................................................................99

已废弃表名：CLZBQC_PCJH.....................................................................................................100

中表名：DM_SJZDZB_BZ..................................................................................................100

已废弃表名：DZDW_DLLDXX.................................................................................................101

已废弃表名：DZDW_DLXX.......................................................................................................101

已废弃表名：DZDW_JCLKXX..................................................................................................102

已废弃表名：DZDW_JZWXX....................................................................................................102

已废弃表名：DZDW_XZQX.......................................................................................................103

♦废弃GPS记录-表名：GPS_RECORD....................................................................................103

已废弃案件种类-表名：JCJ.AJZL.............................................................................................104

已废弃表名：JCJ_CDDKQXB....................................................................................................104

表名：JCJ_CLBC_BZ......................................................................................................105

已废弃表名：JCJ_CLBC_BZMX................................................................................................105

三废弃表名：JCJ_CLBC_FA.......................................................................................................105

已废弃表名：JCJ_DTTHJL.........................................................................................................106

已废弃表名：JCJ_DXCSDX.......................................................................................................106

已废弃表名：JCJ_FKDB..............................................................................................................107

已废弃表名：JCJ_HCWS.............................................................................................................108

已废弃表名：JCJ_QQXZ..............................................................................................................108

已废弃表名：JCJ_XSJZHJL........................................................................................................109

已废弃表名：JCJ_ZHSJSB...........................................................................................................109

已废弃表名：QT.TZXX...............................................................................................................110

表名：ROADLAMP路灯杆表.................................................111

已废弃表名：TEMP_XFJG..........................................................................................................111

已废弃车辆编程-表名：ZBZB_CLBC........................................................................................Ill

等级调度-表名：ZBZB_DJDD........................................................................................Ill

已废弃表名：ZBZB_ZBSX..........................................................................................................112

一、7y项.............................................................................112

可选项：表名：SN_DH_PL国道（其它未标示字段未用）.............................113

可选项：表名：SN_DH_PL九级路（其它未标示字段未用）...........................114

可选项：表名：SN_DH_PL其他道路08（其它未标示字段未用）......................116

可选项：表名：SN_DH_PL省道（其它未标示字段未用）.............................117

可选项：表名：SN_DH_PL县道（其它未标示字段未用）..........................H9

可选项：表名：SN_DH_PL乡镇村道06（其它未标示字段未用）...................121

可选项：表名：SN_DH_PL行人道路（其它未标示字段未用）.....................122

火警受理数据表设计文档

一、有效表

车辆案件关系-表名：CLAJBQGXB

允默

标

序小

许

数据类长主认

识

号列名数说明

空

型度键值

位

1AJLXvarchar100是案件类型

2CLZTDMvarchar100是车辆状态代码

3AJZTDMvarchar100是案件状态代码

4YXFSvarchar100是影响方式

5RESERVEvarchar200是未用字段

电话库-表名：DHK

允默

标

序小

许

数据类长主认

识

号列名数说明

空

型度键值

位

1DHHMvarchar500否电话号码

2YHXMvarchar500是用户姓名

3YHDZvarchar2000是用户地址

数据字典-表名：DM_SJZD

允默

标

序小

许

主认

识

号列名数据类型长度数说明

空

键值

位

1IDvarchar320是不

2DM_SJZD_IDvarchar320否数据字典ID

3DMZvarchar80是代码

4DMMCvarchar5000是代码名称

5DMMPYvarchar500是代码名拼音

6FDMIDvarchar320是父代码ID

7ZTAchar10不状态

8MSvarchar2000是描述

9XSXHnueric50是显示序号

10CJSJdatetime83是创建时间

11CJZIDvarchar320是创建者ID

12CZYIDvarchar320是操作员ID

13CZSJdatetime83是操作时间

14SJCdatetime83是时间戳

15CSZTint40是传输状态

16JLZTint40是记录状态

17SJBBnumeric100是数据版本

业务系统部

18YWXTBSIDvarchar1000是

署ID

19JGBHnvarchar500是机构编号

数据字典描述-表名：DM_SJZD_MS

允

标

序小默

数据类主许

识

号列名长度数说明

空认

型键

位值

1IDvarchar320不

2SJZD_IDvachar320是数据字典ID

3TEXT1varchar30000是描述内容1

4TEXT2archar30000是描述内容2

数据字典主表-表名：DM_SJZDZB

允默

标

序小

许

长主认

识

号列名数据类型数说明

空

度键值

位

1IDvarchar320是不

2ZDMCvarchar1000是字典名称

3ZDDMvarchar200是字典代码

4ZDFLvarchar200是字典分类

5YHJBvarchar200是应用级别

6ZTAchar10不状态

7MSvarchar1000是描述

8CJSJdatetime83是创建时间

9CJZIDvarchar320是创建者ID

10GXSJdatetime83是更新时间

11CZYIDvarchar320是操作员ID

12CZSJdatetime83是操作时间

13SJCdatetime83是时间戳

14CSZTint40是传输状态

15JLZTint40是记录状态

16SJBBnumeric100是数据版本

17YWXTBSIDvarchar1000是业务系统部署ID

18SFXFBZchar10是是否消防标准

路段灭火信息车辆-表名：DZK_CL

默

允

标

序小

数据类长主许认

识

号列名数说明

空

型