Table zfindb.public.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 bigserial 19  √  nextval('monthly_average_curated_metric_macm_pk_id_seq'::regclass)
macm_date_captured timestamp 29,6  √  now()
macm_average_stay_in_bin_1 int4 10 0
macm_average_stay_in_bin_2 int4 10 0
macm_average_stay_in_bin_3 int4 10 0
macm_average_stay_in_pheno_bin int4 10 0
macm_average_stay_in_xpat_bin int4 10 0
macm_average_stay_in_ortho_bin int4 10 0
macm_paper_in_bin_1_longest text 2147483647  √  null
macm_longest_bin1_number_of_days int4 10 0
macm_paper_in_bin_2_longest text 2147483647  √  null
macm_longest_bin2_number_of_days int4 10 0
macm_paper_in_bin_3_longest text 2147483647  √  null
macm_longest_bin3_number_of_days int4 10 0
macm_paper_in_phenotype_bin_longest text 2147483647  √  null
macm_longest_phenotype_number_of_days int4 10 0
macm_paper_in_expression_bin_longest text 2147483647  √  null
macm_longest_expression_number_of_days int4 10 0
macm_paper_in_ortho_bin_longest text 2147483647  √  null
macm_longest_ortho_number_of_days int4 10 0

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