Table zfindb.public.so_zfin_mapping Generated by
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 Tue Sep 15 16:40 PDT 2020

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: