Table zfindb.public.feature_assay 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
featassay_feature_zdb_id text 2147483647
feature.feature_zdb_id featassay_feature_zdb_id_fk C
featassay_mutagen text 2147483647
featassay_mutagee text 2147483647
featassay_pk_id bigserial 19  √  nextval('feature_assay_featassay_pk_id_seq'::regclass)

Table contained 72,071 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
featassay_pk_id Primary key Asc feature_assay_primary_key
featassay_feature_zdb_id + featassay_mutagen + featassay_mutagee Must be unique Asc/Asc/Asc feature_assay_alternate_key_index
featassay_feature_zdb_id Must be unique Asc feature_assay_feature_key_index
featassay_mutagee Performance Asc feature_assay_mutagee_foreign_key_index
featassay_mutagen Performance Asc feature_assay_mutagen_foreign_key_index

Close relationships  within of separation: