Table zfindb.informix.expression_pattern_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
xpatassay_name varchar 40
expression_experiment2.xpatex_assay_name xpatex2_assay_foregin_key R
xpatassay_comments lvarchar 2048  √  null
xpatassay_display_order int 10
xpatassay_abbrev varchar 30  √  null

Table contained 13 rows at Thu Jun 22 08:42 PDT 2017

Column(s) Type Sort Constraint Name Anomalies
xpatassay_comments + xpatassay_name Must be unique Asc/Asc expression_pattern_assay_primary_key_index  
xpatassay_comments + xpatassay_abbrev Must be unique Asc/Asc xpatassay_abbrev_alternate_key_index These unique columns are also nullable

Close relationships  within of separation: