Table zfindb.public.xpat_results_generated 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
xrg_pk_id int8 19
xrg_zdb_id text 2147483647
xrg_xedg_id int8 19
xrg_xedg_zdb_id text 2147483647
xrg_start_stg_zdb_id text 2147483647
xrg_end_stg_zdb_id text 2147483647
xrg_expression_found bool 1 true
xrg_comments text 2147483647  √  null
xrg_suggested_anatomy_item text 2147483647  √  null
xrg_superterm_zdb_id text 2147483647
xrg_subterm_zdb_id text 2147483647  √  null

Table contained 308,425 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
xrg_end_stg_zdb_id Performance Asc xrg_end_stg_foreign_key_index
xrg_start_stg_zdb_id Performance Asc xrg_start_stg_foreign_key_index
xrg_subterm_zdb_id Performance Asc xrg_subterm_foreign_key_index
xrg_suggested_anatomy_item Performance Asc xrg_suggested_anatomy_foreign_key_index
xrg_superterm_zdb_id Performance Asc xrg_superterm_foreign_key_index
xrg_xedg_id Performance Asc xrg_xedg_foreign_key_index