Table zfindb.informix.monthly_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
mcm_pk_id serial8 19  √ 
mcm_pub_arrival_date_month varchar 10
mcm_pub_arrival_date_year varchar 10
mcm_number_in_bin_1 int 10 0
mcm_number_in_bin_2 int 10 0
mcm_number_in_bin_3 int 10 0
mcm_number_in_phenotype_bin int 10 0
mcm_number_in_expression_bin int 10 0
mcm_number_in_ortho_bin int 10 0
mcm_number_archived_this_month int 10 0
mcm_number_closed_unread_this_month int 10 0
mcm_number_closed_curated_this_month int 10 0
mcm_date_captured datetime year to second 19 current

Table contained 4,543 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
mcm_pk_id Must be unique Asc monthly_curated_metric_pk_index