Table erigrid.public.secure_communication 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 secure_communication_comp_id_fkey C
threatDefence text 2147483647  √  null Description of threats for which this security control has been deployed.
version varchar 10  √  null Version of the software of hardware security control.
protocol_type varchar 2147483647  √  null Description of protocol type which is used for communication between two entities in the testbed, e.g. Modbus/TCP, IEC 61850, etc.
component_server int4 10  √  null
component.comp_id secure_communication_component_server_fkey R
First end-point (server) which is involved in data exchange the secure protocol. Foreign key referring to a component in the testbed, e.g. ServerPC (defined in ICT Components).
component_client int4 10  √  null
component.comp_id secure_communication_component_client_fkey R
Second end-point (client) which is involved in data exchange over secure protocol. Foreign key referring to a component in the testbed, e.g. ControlDevice.
secure_protocol varchar 2147483647  √  null Type of the secure protocol used for data exchange. Acceptable values: {SSL; IPsec; VPN; Other}
encryption_scheme text 2147483647  √  null Description of encryption scheme used for exchange of data
authentication varchar 2147483647  √  null Specify whether a secure protocol involves authentication. Acceptable values: {No; Client Authentication; Server Authentication; Mutual Authentication}
authentication_key varchar 2147483647  √  null Description of keys which are used for authentication, e.g. password, digital certificates, etc.

Analyzed at Thu Apr 27 16:49 EEST 2017

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

Close relationships  within of separation: