Table zfindb.public.genotype_component_significance 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
gcs_pk_id bigserial 19  √  nextval('genotype_component_significance_gcs_pk_id_seq'::regclass)
gcs_mrkr_type text 2147483647
gcs_ftr_type text 2147483647
feature_type.ftrtype_name gcs_ftr_type_foreign_key R
gcs_fmrel_type text 2147483647
feature_marker_relationship_type.fmreltype_name gcs_fmrel_type_foreign_key R
gcs_significance int4 10

Table contained 47 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
gcs_pk_id Primary key Asc genotype_component_significance_primary_key
gcs_fmrel_type Performance Asc gcs_fmrel_type_index
gcs_ftr_type Performance Asc gcs_ftr_type_index
gcs_mrkr_type Performance Asc gcs_mrkr_type_index
gcs_mrkr_type + gcs_ftr_type + gcs_fmrel_type + gcs_significance Must be unique Asc/Asc/Asc/Asc gsc_alternate_key_index

Close relationships  within of separation: