Table zfindb.public.condition_data_type 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
cdt_zdb_id text 2147483647
experiment_condition_restricted.ecr_cdt_zdb_id experiment_condition_restricted_cdt_foreign_key R
zdb_active_data.zactvd_zdb_id condition_data_type_zdb_active_data_foreign_key C
cdt_name text 2147483647
cdt_group text 2147483647
condition.condition_group condition_data_type_cdt_group_foreign_key C
cdt_significance int4 10

Table contained 65 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
cdt_zdb_id Primary key Asc condition_data_type_primary_key
cdt_name + cdt_group Must be unique Asc/Asc condition_data_type_alternate_key_index
cdt_group Performance Asc condition_data_type_group_foreign_key_index

Close relationships  within of separation: