亿阳信通资源管理系统数据结构详细设计说明书Netpilot4.0_DBD_DRM_线路管理数据库详细

亿阳信通目录1页亿阳信通资源管理系统数据结构详细设计说明书部门：撰写：审核：批准：文档状态：草案亿阳信通文档编号：00001日期：2020年3月22日亿阳信通目录2页文文档档修修改改记记录录版本号日期修改页作者审批人4.22005-6-171-55rongjingfeng亿阳信通目录3页亿阳信通目录4页1范围1.1标识写明本文档的完整标识，其中包括：指定的唯一标识号：文档正式标题：缩略语，包括本文档规定的名词术语以及英文缩写：本文档适用的功能模块说明该文档是关于管线部分数据库结构的说明性文档版本信息：文档存放路径：本文档中灰色标明的部分表名该部分实际被删除序号缩略语说明/定义英文全称中文译名亿阳信通目录5页2引用文档相关文档文档编号文档名称作者/修订者版本号备注光缆网数据模型管道网数据模型杆路网数据模型管线部分数据库表格关系图其它编号文档名称作者/修订者发布日期出版单位备注亿阳信通目录6页3遵循原则3.1设计原则数据库里多数表是组合索引，即以几个字段组合作为索引，这些索引是都是唯一索引。3.2命名规则所有地图表以X_map开头。亿阳信通目录7页4数据库详细设计说明4.1数据表间表格关系图X_guanglan（光缆）X_guanglanduan（光缆段）管线部分数据库表格关系图X_Childkong（子孔）X_GuanDaoduan（管道段）X_Fiber（敷设关系表）X_GuanDao（管道）X_GanLuDuan（杆路段）X_StoneWayPart（标石路由段等）X_GanLu(杆路)X_StoneWay（标石路由等）qianxins（纤芯）X_KeepPoint（光缆预留）X_Connpoint（光接头）X_Pole（电杆）X_Guankong（管孔）X_Stone（标石）X_Inflexion（拐点）X_Well（人井）aSite（站点）X_EnpartboxPort（光分纤箱端子）X_RaywireBoxPort（光交接箱端子）mxODFPort（ODF端子）X_fiber2port（端子纤芯关联表）X_RaywireBox（光交接箱）X_Enpartbox（光分纤箱）X_ServiceDep（维护部门）敷设包含连接到端子连接到端子连接到端子挂墙，引上，直埋架空组成组成组成属于属于属于属于直埋挂墙起止于起止于起止于放置在放置在放置在放置在放置在放置在放置在光接头连接光缆段X_Point（点视图）建立于建立于建立于建立于建立于包含各类点的id,name,kind,jingdu,weidu,Pro,City,County各项信息X_LineId（线视图）包含点的id,name,kind,jingdu,weidu,Pro,City,County各项字段包含各类线的id,Name,kind,pro,city,county各项信息建立于图1管线数据库关系图亿阳信通目录8页4.2数据库表实体关系图x_guandaoPK,U1idU1id1U1id2U2NameshortNameALevelLengthRealwayPictureBeizhuPathProjectNameBuilderFinishTimeEstateNameU2ProU2cityU2CountyKindx_wellPKIdAddrNameOwnerUserNameBuilderFinishTimeServiceTypeCheckTimeServiceDepServicerPhoneWellTypeWellKindSpecModelStructCoverCoverMaterCoverAngerWellHeightNetHeightUpDeepEastWestNorthSouthWellDeepBaseDeepDistance1Distance2BeizhuBelongToNameDirectjingduweiduprocitycountyIsDangerFK1BelongToIdKindx_guankongFK1,I1Id1FK1,I1Id2FK1,I1BelongToIdOwnerUserNameNoStateChildNumDiaStuffBeizhuNoBX_GuandaoduanI1id1I1id2LengthBuilderFinishTimeServiceTypeCheckTimeServiceDepServicerPhoneOwnerUserNameStuffSpecSectionHeightSectionLongTopHeight1TopHeight2Distance1Distance2ADirectionBDirectionPictureBeizhuBPictureFK1BelongToIdx_childkongFK1,I1id1FK1,I1id2FK1,I1BelongToIdOwnerUserNameStateFK1,I1BelongNoI1NoFiberIdFiberNodiaBeizhuFiberId1FiberId2图2管道网数据库实体模型亿阳信通目录9页x_guanglanPK,I1idI1id1I1id2I2NameShortNameLengthPairLengthOwnerUserNameRealWayPictureBeizhuPathProjectNameBuilderFinishTimeEstateNameI2proI2cityI2countyI2Kinddianlantypealevelx_guanglanduanI1id1I1id2FK1,I1BelongToIdaddrLengthQianXinNumBuilderFinishTimeServiceTypeCheckTimeServiceDepServicerPhoneDiaStuffKeeplenformatQianXinPicBeizhuHavePointHavePointPointIdProducerProduceTimeRealwayOwnerUserNamelinepairnumlinetypepathidqianxinscolFK1,I1LineIdFK1,I2,I1SiteId1FK1,I2,I1SiteId2I1QXNoI2SysLineIdI2SysIddirectionMemoTypClientUserLeftConnectIdRightConnectIdSumAttenuate1SumAttenuate2AveAttenuate1AveAttenuate2LeftOdfStrRightODFStrLeftId1LeftId2LeftQxNoRightId1RightId2RightQxNoLeftConnectEquIdRightConnectEquIdx_raywireboxPKIDNameKindBelongtoIDJingduWeiduPictureProCitycountyx_raywireboxportSiteIdRoomIDFK1,I2,I1RayWireBoxIDI2KindI2ModuleRowI2ModuleColI2RowI2ColI1PortNameStateTheOtherPortbhIDx_enpartboxPKIDNameBelongtoIdJingduWeiduKindProCityCountyx_enpartboxportFK1,I1EnpartboxIdKindModuleRowModuleColRowColI1PortNameGuangLanIdGuangLanNameQianxinNoTagStateIDx_fiber2portFK1,I1GuangLanIDFK1,I1GuangLanId1FK1,I1GuangLanId2FK1,I1QianXinNoFK2,FK3BoxIdFK2,FK3KindFK2,FK3PortNamex_keeppointI1IDI1KindkeeplengthI1guanglanIdI1guanglanId1I1guanglanid2x_connpointPKIDNameCPModelCPKindFormatPipeKindBelongToIDboxtypebeizhujingduweiduprocitycountykind图3光缆网数据库实体关系图亿阳信通目录10页x_ganluduanI1Id1I1id2FK1,I1BelongToIdLengthBuilderFinishTimeServiceTypeCheckTimeServiceDepServicerPhoneOwnerUsernameBeizhuLineTypeLineUserLineOwnerx_ganluI1IdI1id1I1id2I2NameShortnameAlevelLengthrealwaypictureBeizhupathprojectNameBuilderFinishTimeEstateNameI2proI2cityI2countykindx_polePKIDAddrNameFaceTypeBuilderFinishTimeServiceTypeCheckTimeServiceDepspecservicerphoneOwnerUserNameTypeTopdiaRingPlyWoodHelpLineTypeHelpLineSpecHelpLineDisHookHaveMarkBeizhuBelongtonamejingduweiduprocitycountyIsDangerFK1BelongToIdKindx_stonePKIDNameAddrBuilderFinishTimeServiceTypeCheckTimeServiceDepservicerphoneBelongtoNamejingduweiduprocitycountyIsDangerBeizhuFK1BelongToIdKindx_stoneWayPartI1id1I1id2FK1,I1belongtoIdLengthBeizhuKindx_inflexionPKidNameAddrBeizhuBelongtoNamejingduweiduprocitycountyBelongtoKindBelongtoIdKindx_stonewayI2IdI2ID1I2Id2I1NameShortNameLengthBeizhuRealWayPicturePathProjectNameBuilderFinishTimeEstateNameI1KindI1proI1cityI1countyalevel图4杆路网数据库实体关系图4.3表结构说明本文档是传输网资源管理系统管线部分数据库结构的说明性文档,包含管线部分所有数据库表字段的详细说明.下图解释管线部分各表格的相互关系:亿阳信通目录11页4.3.1管线各类设施类型号（KIND）站点:100人井102电杆104光交接箱105光接头点108拐点110标石115光分纤箱116管道200光缆204杆路206标石路由207挂墙208引上209光纤连接225光纤2264.3.2管道表X_guandao管道表描述管道具体信息索引名称索引字段唯一性（0-N,1-Y）允许重复键值（0-N,1-Y）guandaoIndexId,id1,id210Name_duct_IndexName,pro,city,county10No字段字段类型长度精度小数位允许空（0-N,1-Y）缺省值字段说明1idINTEGER4管道Id2id1INTEGER4管道起始点Id3id2INTEGER4管道终止点Id4nameVARCHAR(30,0)30空串管道名称5shortnameVARCHAR(14,0)14空串名称所写6alevelSMALLINT2管道级别7lengthINTEGER4长度8realwayBYTEINTABLE管道具体路由9pictureBYTEINTABLE管道具体路由图纸亿阳信通目录12