SchemaSpy - Table zfindb.public.genotype_component

Generated by
SchemaSpy

Legend:

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

√

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

gcs_fmrel_type_foreign_key R

gcs_significance

int4

Table contained 580 rows at Wed Sep 15 00:41 PDT 2021

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