Table popler_3.public.percent_cover_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
percent_cover_table_key serial 10  √  nextval('percent_cover_table_percent_cover_table_key_seq'::regclass)
taxa_percent_cover_fkey int4 10  √  null
taxa_table.taxa_table_key percent_cover_table_taxa_percent_cover_fkey_fkey C
site_in_project_percent_cover_fkey int4 10  √  null
site_in_project_table.site_in_project_key percent_cover_table_site_in_project_percent_cover_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
percent_cover_observation numeric 131089  √  null
covariates text 2147483647  √  null
metadata_percent_cover_key int4 10  √  null
structure_type_4 varchar 50  √  null

Table contained 2,232,638 rows at Wed Aug 30 10:19 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
percent_cover_table_key Primary key Asc percent_cover_table_pkey

Close relationships  within of separation: