Table zfindb.public.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 bigserial 19  √  nextval('monthly_curated_metric_mcm_pk_id_seq'::regclass)
mcm_pub_arrival_date_month text 2147483647
mcm_pub_arrival_date_year text 2147483647
mcm_number_in_bin_1 int4 10 0
mcm_number_in_bin_2 int4 10 0
mcm_number_in_bin_3 int4 10 0
mcm_number_in_phenotype_bin int4 10 0
mcm_number_in_expression_bin int4 10 0
mcm_number_in_ortho_bin int4 10 0
mcm_number_archived_this_month int4 10 0
mcm_number_closed_unread_this_month int4 10 0
mcm_number_closed_curated_this_month int4 10 0
mcm_date_captured timestamp 29,6 now()

Table contained 12,472 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
mcm_pk_id Primary key Asc monthly_curated_metric_primary_key