Table zfindb.public.tmp_efs_map 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
efs1 int8 19  √  null
efs2 int8 19  √  null
xpat_found bool 1  √  null
xpatres_superterm text 2147483647  √  null
xpatres_subterm text 2147483647  √  null

Table contained 12,580,214 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
efs2 Performance Asc tmp_index
xpatres_superterm Performance Asc tmp_index_x
xpatres_subterm Performance Asc tmp_index_x2