Table zfindb.public.marker_go_term_evidence 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
mrkrgoev_zdb_id text 2147483647
inference_group_member.infgrmem_mrkrgoev_zdb_id ifgrmem_mrkrgoev_zdb_id_foreign_key_odc C
marker_go_term_annotation_extension_group.mgtaeg_mrkrgoev_zdb_id mgtaeg_fk_odc C
noctua_model_annotation.nma_mrkrgoev_zdb_id nma_mrkrgoev_fk_odc C
tmp_go.mrkrgoev_zdb_id Implied Constraint R
tmp_go1.mrkrgoev_zdb_id Implied Constraint R
zdb_active_data.zactvd_zdb_id marker_go_term_evidence_zdb_active_data_id_foreign_key C
mrkrgoev_mrkr_zdb_id text 2147483647
marker.mrkr_zdb_id mrkrgoev_mrkr_zdb_id_foreign_key C
mrkrgoev_source_zdb_id text 2147483647
zdb_active_source.zactvs_zdb_id mrkrgoev_source_zdb_id_foreign_key C
mrkrgoev_evidence_code text 2147483647
mrkrgoev_notes text 2147483647  √  null
mrkrgoev_date_entered timestamp 29,6  √  now()
mrkrgoev_date_modified timestamp 29,6  √  now()
mrkrgoev_contributed_by text 2147483647  √  null
person.zdb_id mrkrgoev_contributed_by_fk R
mrkrgoev_modified_by text 2147483647  √  null
person.zdb_id mrkrgoev_modified_by_fk R
mrkrgoev_gflag_name text 2147483647  √  null
go_flag.gflag_name mrkrgoev_gflag_name_foreign_key R
mrkrgoev_term_zdb_id text 2147483647
term.term_zdb_id mrkrgoev_term_zdb_id_foreign_key C
mrkrgoev_annotation_organization int8 19
marker_go_term_evidence_annotation_organization.mrkrgoevas_pk_id mrkrgoev_annotation_organization_foreign_key R
mrkrgoev_annotation_organization_created_by text 2147483647 'ZFIN'::text
mrkrgoev_external_load_date timestamp 29,6  √  null
mrkrgoev_protein_dblink_zdb_id text 2147483647  √  null
db_link.dblink_zdb_id mrkrgoev_protein_dblink_id_fk_odc C
mrkrgoev_relation_term_zdb_id text 2147483647  √  null
term.term_zdb_id mrkrgoev_relation_term_zdb_id_fk_odc R
mrkrgoev_relation_qualifier text 2147483647  √  null
mrkrgoev_tag_submit_format text 2147483647  √  null

Table contained 306,026 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
mrkrgoev_zdb_id Primary key Asc marker_go_term_evidence_primary_key
mrkrgoev_mrkr_zdb_id Performance Asc marker_go_term_evidence_marker_foreign_key_index
mrkrgoev_source_zdb_id Performance Asc marker_go_term_evidence_source_foreign_key_index
mrkrgoev_annotation_organization Performance Asc mrkrgoev_annotation_org_fk_index
mrkrgoev_contributed_by Performance Asc mrkrgoev_contributed_by_fk_index
mrkrgoev_evidence_code Performance Asc mrkrgoev_evidence_code_index
mrkrgoev_gflag_name Performance Asc mrkrgoev_gflag_name
mrkrgoev_modified_by Performance Asc mrkrgoev_modified_by_fk_index
mrkrgoev_protein_dblink_zdb_id Performance Asc mrkrgoev_protein_dblink_id_index
mrkrgoev_term_zdb_id Performance Asc mrkrgoev_term_zdb_id_fk_index

Close relationships  within of separation: