Table erigrid.public.access_controls 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 access_controls_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.
type_of_access_control varchar 2147483647  √  null The type of access control which are being used in the system or on the specific component. Acceptable values: {Access Control List; Role-based access control (RBAC); Rule-based access control (RAC); Physical access; Other}
identification_used varchar 2147483647  √  null Description of identifications used to authenticate the user to the access control system, e.g. user names/passwords, digital certificates, ID cards, personal card, etc.
reference_component int4 10  √  null
component.comp_id access_controls_reference_component_fkey R
A components which implement access controls can be referenced, e.g. a firewall component.

Analyzed at Thu Apr 27 16:49 EEST 2017

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

Close relationships  within of separation: