Table popler_3.public.density_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
density_table_key serial 10  √  nextval('density_table_density_table_key_seq'::regclass)
taxa_density_fkey int4 10  √  null
taxa_table.taxa_table_key density_table_taxa_density_fkey_fkey C
site_in_project_density_fkey int4 10  √  null
site_in_project_table.site_in_project_key density_table_site_in_project_density_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
density_observation numeric 131089  √  null
covariates text 2147483647  √  null
metadata_density_key int4 10  √  null
structure_type_4 varchar 50  √  null

Table contained 270,582 rows at Wed Aug 30 10:19 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
density_table_key Primary key Asc density_table_pkey

Close relationships  within of separation: