Table erigrid.public.server_pc 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 server_pc_comp_id_fkey C
is_virtual bool 1  √  null information if server is hardware or virtual (true or false)
cpu float4 8,8  √  null cpu capacity (Hz)
ram float4 8,8  √  null size of ram (Byte)
hdd float4 8,8  √  null hard drive space (Byte)
os varchar 2147483647  √  null operating system
software text 2147483647  √  null installed software
ip varchar 2147483647  √  null ip parameters
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 server_pc_pkey

Close relationships  within of separation: