Table zfindb.public.so_zfin_mapping 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
szm_pk_id bigserial 19  √  nextval('so_zfin_mapping_szm_pk_id_seq'::regclass)
szm_term_ont_id text 2147483647
term.term_ont_id so_zfin_mapping_term_foreign_key C
szm_object_type text 2147483647
szm_term_name text 2147483647

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

Indexes:
Column(s) Type Sort Constraint Name
szm_pk_id Primary key Asc szm_pk_id_primary_key
szm_term_ont_id Performance Asc so_zfin_mapping_term_fk_index
szm_term_ont_id + szm_object_type Must be unique Asc/Asc szm_alternate_key

Close relationships  within of separation: