Table zfindb.informix.monthly_average_curated_metric 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
macm_pk_id serial8 19  √ 
macm_date_captured datetime year to second 19 current
macm_average_stay_in_bin_1 int 10 0
macm_average_stay_in_bin_2 int 10 0
macm_average_stay_in_bin_3 int 10 0
macm_average_stay_in_pheno_bin int 10 0
macm_average_stay_in_xpat_bin int 10 0
macm_average_stay_in_ortho_bin int 10 0
macm_paper_in_bin_1_longest varchar 50  √  null
macm_longest_bin1_number_of_days int 10 0
macm_paper_in_bin_2_longest varchar 50  √  null
macm_longest_bin2_number_of_days int 10 0
macm_paper_in_bin_3_longest varchar 50  √  null
macm_longest_bin3_number_of_days int 10 0
macm_paper_in_phenotype_bin_longest varchar 50  √  null
macm_longest_phenotype_number_of_days int 10 0
macm_paper_in_expression_bin_longest varchar 50  √  null
macm_longest_expression_number_of_days int 10 0
macm_paper_in_ortho_bin_longest varchar 50  √  null
macm_longest_ortho_number_of_days int 10 0

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