Table zfindb.public.marker_go_term_annotation_extension 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
mgtae_pk_id bigserial 19  √  nextval('marker_go_term_annotation_extension_mgtae_pk_id_seq'::regclass)
mgtae_relationship_term_zdb_id text 2147483647
term.term_zdb_id mgtae_relationship_term_zdb_id_fk_odc C
mgtae_identifier_term_zdb_id text 2147483647  √  null
mgtae_extension_group_id int8 19
marker_go_term_annotation_extension_group.mgtaeg_annotation_extension_group_id mgtae_extension_group_id_fk_odc C
mgtae_term_text text 2147483647  √  null
mgtae_dblink_zdb_id text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
mgtae_pk_id Primary key Asc marker_go_term_annotation_extension_pk
mgtae_identifier_term_zdb_id Performance Asc mgrae_iterm_zdb_id_fk_index
mgtae_relationship_term_zdb_id Performance Asc mgrae_rterm_zdb_id_fk_index
mgtae_extension_group_id Performance Asc mgtae_extension_group_id_index

Close relationships  within of separation: