Table zfindb.public.feature_assay Generated by
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 70,597 rows at Tue Sep 15 16:40 PDT 2020

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: