Table erigrid.public.virtual_server_environment 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 virtual_server_environment_comp_id_fkey C
cpu float4 8,8  √  null cpu capacity of the cluster (Hz)
ram float4 8,8  √  null ram capacity of the cluster (Byte)
hdd float4 8,8  √  null hdd space of the cluster (Byte)
resource_pools bool 1  √  null management of available resources in pools (for a couple of virtual machines)(true or false)
high_availability text 2147483647  √  null Information about failover in case of faulty hosts
access_rights text 2147483647  √  null usergroups, roles and rights management

Analyzed at Thu Apr 27 16:49 EEST 2017

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

Close relationships  within of separation: