Network Pipe Definition

the network pipe definition defines pipes in the network the unique constraint on network pipe definition is sourcenetworkid + sourceid + date upstreamsourceid and downstreamsourceid need to define joints , which are virtual objects without dedicated headers care must be taken to define them consistently here to maintain the integrity of the network and enable joint constraints to be applied variable data type unit of measure is nullable? default value description sourcenetworkid string no source id of network header docid\ irxj rg5leh701vw2okjl sourceid string no source id for the pipe definition this sourceid enables upsert functionality from client source systems of record date datetimeoffset no date at which the pipe becomes part of the network datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 upstreamsourceid string no source id of the upstream node downstreamsourceid string no source id of the downstream node enabled bool no whether the pipe should participate in the network (false would be the equivalent of a mask in gap) length list\<double> ft no list of lengths making up the pipe segments all pipe property lists must be the same length trueverticaldepth list\<double> ft no list of true vertical depths making up the pipe segments all pipe property lists must be the same length innerdiameter list\<double> in no list of inner diamters making up the pipe segments all pipe property lists must be the same length roughness list\<double> in no list of roughnesses making up the pipe segments all pipe property lists must be the same length