Project

General

Profile

Feature #732

基础数据整理

Added by xiangyang li almost 4 years ago. Updated over 3 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Target version:
Start date:
08/25/2020
Due date:
09/23/2020
% Done:

100%

Estimated time:
32.00 h
Spent time:
Defect version:

Description

基础数据整理,提供基础数据作为标准,由研发部负责更新:
SYS_TABLEINFO
SYS_FIELDINFO
TB0001_SRVPARA
TB0005_SRVPROC
TB0010_RDBTABINFO
TB0011_RDBCOLINFO
TB0021_TABLES
TB0022_FIELDS
TB0023_TYPE
TB0024_SKEY
TB0025_SFIELD
TB0030_GLOBALFILE
TB1000_AOJ
TB1002_BAYAREA
TB1003_APPSYS
TB1010_APPSYS

TB2013_COMMDEVICE
TB4005_MEASTYPEDEF (*)
TB4050_SYSTEMINFO
TB4401_HISDATADEF


Files

基础表注意事项.docx (577 KB) 基础表注意事项.docx jiwei shi, 09/29/2020 02:47 PM

Related issues

Related to ISCS需求及问题 - Feature #726: ISCS3.0 # SEMASTER.SYS_FIELDINFO.txt 表需要维护Resolved08/21/2020

Actions
Related to ISCS需求及问题 - Bug #854: SEMASTER.SYS_FIELDINFO数据字典PA的配置错误Resolved09/23/2020

Actions

History

#1

Updated by xiangyang li almost 4 years ago

  • Target version set to 3.0.2
#2

Updated by xiangyang li almost 4 years ago

  • Description updated (diff)
#3

Updated by xiangyang li almost 4 years ago

  • Description updated (diff)
#4

Updated by xiangyang li almost 4 years ago

  • Description updated (diff)
  • Assignee set to jiwei shi
#5

Updated by xiangyang li almost 4 years ago

  • Related to Feature #726: ISCS3.0 # SEMASTER.SYS_FIELDINFO.txt 表需要维护 added
#6

Updated by jiwei shi almost 4 years ago

  • Due date set to 09/14/2020
  • Estimated time set to 32.00 h
#7

Updated by jiwei shi almost 4 years ago

  • Status changed from New to In Progress
#8

Updated by jiwei shi almost 4 years ago

  • Due date changed from 09/14/2020 to 09/23/2020

预估下周三完成

#9

Updated by xiangyang li almost 4 years ago

  • Related to Bug #854: SEMASTER.SYS_FIELDINFO数据字典PA的配置错误 added
#10

Updated by jiwei shi almost 4 years ago

  • File 基础表注意事项.docx added
  • % Done changed from 0 to 90

需要注意的表:
TB1000_AOJ(权限区域表):南昌、15、9号线合并版本,其中15号线没有id为20的环控复示、21防淹门、22隧道感温光纤,这三个南昌有,而9号线没有id为21和22的条目;
TB1002_BAYAREA(间隔区域表):南昌和15号线合并版本,南昌线路此表比15号线多了区域号为16~18,24~28,58的条目,51~57的条目两条线区域描述不同;而跟9号线差别比较大
TB1003_APPSYS(专业系统表):以15号线此表为基准和南昌线路合并版本,15号线和南昌线路区别就是15号线的字段系统代码是以0开始的编号,而南昌的以非零开始的编码,这两条线的此表数据跟9号线在字段设备类型上有冲突
TB1010_APPSYS(子系统表): 15号线和南昌也有冲突

#11

Updated by jiwei shi almost 4 years ago

  • File 基础表注意事项.docx added
#12

Updated by jiwei shi almost 4 years ago

  • File deleted (基础表注意事项.docx)
#13

Updated by jiwei shi almost 4 years ago

#14

Updated by jiwei shi almost 4 years ago

  • File deleted (基础表注意事项.docx)
#15

Updated by jiwei shi over 3 years ago

  • Status changed from Resolved to Feedback
#16

Updated by jiwei shi over 3 years ago

  • Status changed from Feedback to Resolved

SEMODEL.TB1002_BAYAREA间隔区域表增加CCTV区域

#17

Updated by jiwei shi over 3 years ago

  • Status changed from Resolved to Feedback
#18

Updated by jiwei shi over 3 years ago

  • Status changed from Feedback to Resolved

清除实时库表信息字典中无效表,清除实时库列信息字典中的无效列;

Also available in: Atom PDF