Table popler_3.public.biomass_table 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
biomass_table_key serial 10  √  nextval('biomass_table_biomass_table_key_seq'::regclass)
taxa_biomass_fkey int4 10  √  null
taxa_table.taxa_table_key biomass_table_taxa_biomass_fkey_fkey C
site_in_project_biomass_fkey int4 10  √  null
site_in_project_table.site_in_project_key biomass_table_site_in_project_biomass_fkey_fkey C
year numeric 131089  √  null
month numeric 131089  √  null
day numeric 131089  √  null
spatial_replication_level_1 varchar 50  √  null
spatial_replication_level_2 varchar 50  √  null
spatial_replication_level_3 varchar 50  √  null
spatial_replication_level_4 varchar 50  √  null
spatial_replication_level_5 varchar 50  √  null
treatment_type_1 varchar 200  √  null
treatment_type_2 varchar 200  √  null
treatment_type_3 varchar 200  √  null
structure_type_1 varchar 200  √  null
structure_type_2 varchar 200  √  null
structure_type_3 varchar 200  √  null
biomass_observation numeric 131089  √  null
covariates text 2147483647  √  null
metadata_biomass_key int4 10  √  null
structure_type_4 varchar 50  √  null

Table contained 403,521 rows at Wed Aug 30 10:19 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
biomass_table_key Primary key Asc biomass_table_pkey

Close relationships  within of separation: