Table erigrid.public.research_infrastructure 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
ri_id serial 10  √  nextval('research_infrastructure_ri_id_seq'::regclass)
component.ri_id component_ri_id_fkey R
domain_topology.ri_id domain_topology_ri_id_fkey R
model_file.ri_id model_file_ri_id_fkey C
name varchar 2147483647  √  null Name of the RI
org_id int4 10  √  null
organization.org_id research_infrastructure_org_id_fkey R
Owner of the RI
description_purpose varchar 2147483647  √  null Verbal description of the purpose of the RI
description_setup varchar 2147483647  √  null Verbal description of the physical setup of the RI
voltage_level voltage_type 2147483647  √  null The RI voltage level
security_checks varchar 2147483647  √  null Verbal description of the procedures needed to get access to the research infrastructure. More detailed description will be provided in a separate document outside the database.
external_connectivity varchar 2147483647  √  null Real time connectivity of the RI with other Ris
confidential bool 1  √  null If all RI information is confidential, set as true
author varchar 2147483647  √  null
modified timestamptz 35,6  √  null

Analyzed at Thu Apr 27 16:49 EEST 2017

Indexes:
Column(s) Type Sort Constraint Name
ri_id Primary key Asc research_infrastructure_pkey

Close relationships  within of separation: