complexType "sg_network_connectTYPE"
Namespace:
Content:
complex, 16 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 16 attributes and 1 element
Used:
XML Representation Summary
<...
    network_db_site
 = 
xsd:hexBinary
    network_db_id
 = 
xsd:unsignedInt
    network_id
 = 
xsd:unsignedInt
    segment_site
 = 
xsd:hexBinary
    segment_id
 = 
xsd:unsignedInt
    output_sg_site
 = 
xsd:hexBinary
    output_sg_id
 = 
xsd:unsignedInt
    ordering_seq
 = 
xsd:unsignedInt
    net_conn_type_db_site
 = 
xsd:hexBinary
    net_conn_type_db_id
 = 
xsd:unsignedInt
    net_conn_type_code
 = 
xsd:unsignedInt
    gmt_stream_config
 = 
xsd:dateTime
    gmt_last_updated
 = 
xsd:dateTime
    last_upd_db_site
 = 
xsd:hexBinary
    last_upd_db_id
 = 
xsd:unsignedInt
    rstat_type_code
 = 
xsd:unsignedShort
    >
   
Content: 
lcinfo?
</...>
Content Elements (1):
lcinfo (type lcinfo)
Known Usage Locations
Annotation
Segment Network Connection Entity:
The Segment Network table contains the connectivity relationships between segments, and allows segments to be associated in ordered input-output flow chains (i.e., process flowcharts) or sequenced parent-child relationships.
XML Source (w/o annotations (17))
<xsd:complexType name="sg_network_connectTYPE">
<xsd:sequence>
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>
</xsd:sequence>
<xsd:attribute name="network_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="network_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="network_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="segment_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="segment_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="output_sg_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="output_sg_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="ordering_seq" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="net_conn_type_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="net_conn_type_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="net_conn_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="gmt_stream_config" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="gmt_last_updated" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="last_upd_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="last_upd_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="rstat_type_code" type="xsd:unsignedShort" use="optional"/>
</xsd:complexType>
Attribute Detail (defined in this component only; 16/16)
network_db_site
Type:
Use:
required
Foreign key reference to Network.network_db_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="network_db_site" type="site_codeSimpleType" use="required"/>

network_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Network.network_db_id, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="network_db_id" type="xsd:unsignedInt" use="required"/>

network_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Network.network_id, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="network_id" type="xsd:unsignedInt" use="required"/>

segment_site
Type:
Use:
required
Connection source parent segment where the connection begins or from whence it flows. Foreign key reference to Segment.segment_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="segment_site" type="site_codeSimpleType" use="required"/>

segment_id
Type:
xsd:unsignedInt, predefined
Use:
required
Connection source parent segment where the connection begins or from whence it flows. Foreign key reference to Segment.segment_id, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="segment_id" type="xsd:unsignedInt" use="required"/>

output_sg_site
Type:
Use:
required
Connection sink child segment where the connection ends or to where it flows. Foreign key reference to Segment.segment_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="output_sg_site" type="site_codeSimpleType" use="required"/>

output_sg_id
Type:
xsd:unsignedInt, predefined
Use:
required
Connection sink child segment where the connection ends or to where it flows. Foreign key reference to Segment.segment_id, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="output_sg_id" type="xsd:unsignedInt" use="required"/>

ordering_seq
Type:
xsd:unsignedInt, predefined
Use:
required
Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="ordering_seq" type="xsd:unsignedInt" use="required"/>

net_conn_type_db_site
Type:
Use:
optional
Foreign key reference to Network_Conn_Type.net_conn_type_db_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="net_conn_type_db_site" type="site_codeSimpleType" use="optional"/>

net_conn_type_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Network_Conn_Type.net_conn_type_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="net_conn_type_db_id" type="xsd:unsignedInt" use="optional"/>

net_conn_type_code
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Network_Conn_Type.net_conn_type_code
XML Source (w/o annotations (1))
<xsd:attribute name="net_conn_type_code" type="xsd:unsignedInt" use="optional"/>

gmt_stream_config
Type:
Use:
optional
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="gmt_stream_config" type="dateTimeWithoutTimezone" use="optional"/>

gmt_last_updated
Type:
Use:
optional
UTC/GMT timestamp for the last change to this record
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="gmt_last_updated" type="dateTimeWithoutTimezone" use="optional"/>

last_upd_db_site
Type:
Use:
optional
Foreign key reference to Site_Database.db_site which identifies the database creating/updating/soft deleting this entry
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="last_upd_db_site" type="site_codeSimpleType" use="optional"/>

last_upd_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Site_Database.db_id which identifies the database creating/updating/soft deleting this entry
XML Source (w/o annotations (1))
<xsd:attribute name="last_upd_db_id" type="xsd:unsignedInt" use="optional"/>

rstat_type_code
Type:
xsd:unsignedShort, predefined
Use:
optional
Foreign key reference to Row_Status_Type.rstat_type_cod which determines the status of this entry
XML Source (w/o annotations (1))
<xsd:attribute name="rstat_type_code" type="xsd:unsignedShort" use="optional"/>
Content Element Detail (defined in this component only; 1/1)
lcinfo
Type:
lcinfo, complex content
XML Source
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>

XML schema documentation generated with DocFlex/XML 1.7.2b using DocFlex/XML | XSDDoc 2.1.0b template set