Table zfindb.public.expression_pattern_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
xpatassay_name text 2147483647
expression_experiment2.xpatex_assay_name xpatex2_assay_foregin_key R
xpatassay_comments text 2147483647  √  null
xpatassay_display_order int4 10
xpatassay_abbrev text 2147483647  √  null
xpatassay_mmo_id text 2147483647  √  null

Table contained 13 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
xpatassay_name Primary key Asc expression_pattern_assay_primary_key  
xpatassay_abbrev Must be unique Asc xpatassay_abbrev_alternate_key_index This unique column is also nullable

Close relationships  within of separation: