Table zfindb.public.expression_pattern_infrastructure 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
xpatinf_zdb_id text 2147483647
zdb_active_data.zactvd_zdb_id xpatinf_active_data_foreign_key C
xpatinf_curator_zdb_id text 2147483647
zdb_submitters.zdb_id xpatinf_curator_foreign_key R
xpatinf_pub_zdb_id text 2147483647
publication.zdb_id xpatinf_pub_foreign_key R
xpatinf_date timestamp 29,6 now()
xpatinf_superterm_zdb_id text 2147483647
term.term_zdb_id xpatinf_superterm_zdb_id_foreign_key R
xpatinf_subterm_zdb_id text 2147483647  √  null
term.term_zdb_id xpatinf_subterm_zdb_id_foreign_key R
xpatinf_quality_term_zdb_id text 2147483647  √  null
xpatinf_expression_found bool 1  √  true
xpatinf_tag text 2147483647  √  null

Table contained 2,278 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
xpatinf_zdb_id Primary key Asc xpatinf_primary_key
xpatinf_curator_zdb_id Performance Asc xpatinf_curator_zdb_id_foreign_key_index
xpatinf_pub_zdb_id Performance Asc xpatinf_pub_zdb_id_foreign_key_index
xpatinf_subterm_zdb_id Performance Asc xpatinf_subterm_zdb_id_foreign_key_index
xpatinf_superterm_zdb_id Performance Asc xpatinf_superterm_zdb_id_foreign_key_index

Close relationships  within of separation: