Table erigrid.public.communication_interchange Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
comp_id int4 10
component.comp_id communication_interchange_comp_id_fkey C
type varchar 2147483647  √  null The type of the component. Has to be some of the following: {Hub; Switch; Router; Gateway; Media converter; Other}
primary_domain int4 10  √  null
domain.domain_id communication_interchange_primary_domain_fkey R
Foreign key referring to Domain table. If the device interconnects communication links of the same type (e.g. an ethernet switch or a USB hub), the primary domain is the only one that exists. If the device converts between domains (e.g. a webservices to Modbus/RTU gateway), the primary domain will be on the upstream side if an upstream side can be identified (e.g. towards the master in a master-slave system). If the device converts between domains and no upstream side can be identified (e.g. CAN bus extender over Ethernet), primary and secondary can be assigned at random.
secondary_domain int4 10  √  null
domain.domain_id communication_interchange_secondary_domain_fkey R
Foreign key referring to Domain table. Empty if the device interconnects communication links of the same type, otherwise the domain of the upstream link if upstream can be identified (see under primaryDomain), otherwise the domain of the link not entered as primary.

Analyzed at Thu Apr 27 16:49 EEST 2017

Indexes:
Column(s) Type Sort Constraint Name
comp_id Primary key Asc communication_interchange_pkey

Close relationships  within of separation: