Table zfindb.public.feature_marker_relationship_type 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
fmreltype_name text 2147483647
feature_marker_relationship.fmrel_type fmrel_type_foreign_key R
genotype_component_significance.gcs_fmrel_type gcs_fmrel_type_foreign_key R
fmreltype_ftr_type_group text 2147483647
feature_type_group.ftrgrp_name fmreltype_ftr_type_group_ftr_foreign_key R
fmreltype_mrkr_type_group text 2147483647
marker_type_group.mtgrp_name fmreltype_ftr_type_group_mrkr_foreign_key R
fmreltype_1_to_2_comments text 2147483647  √  null
fmreltype_2_to_1_comments text 2147483647  √  null
fmreltype_produces_affected_marker bool 1 false

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

Indexes:
Column(s) Type Sort Constraint Name
fmreltype_name Primary key Asc feature_marker_relationship_type_primary_key
fmreltype_ftr_type_group Performance Asc feature_marker_relationship_type_ftr_group_index
fmreltype_mrkr_type_group Performance Asc feature_marker_relationship_type_mrkr_group_index

Close relationships  within of separation: