Table zfindb.public.term_group 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
tg_group_name text 2147483647  √  null
tg_genox_group text 2147483647  √  null
tg_group_pk_id bigserial 19  √  nextval('term_group_tg_group_pk_id_seq'::regclass)
tg_geno_name text 2147483647  √  null
tg_geno_handle text 2147483647  √  null

Table contained 20,333 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name Anomalies
tg_group_pk_id Primary key Asc term_group_primary_key  
tg_geno_handle Performance Asc term_geno_handle_index  
tg_geno_name Performance Asc term_geno_name_index  
tg_genox_group Must be unique Asc tg_genox_zdb_index This unique column is also nullable