Table popler_3.public.site_in_project_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
site_in_project_key serial 10  √  nextval('site_in_project_table_site_in_project_key_seq'::regclass)
biomass_table.site_in_project_biomass_fkey biomass_table_site_in_project_biomass_fkey_fkey C
count_table.site_in_project_count_fkey count_table_site_in_project_count_fkey_fkey C
density_table.site_in_project_density_fkey density_table_site_in_project_density_fkey_fkey C
individual_table.site_in_project_individual_fkey individual_table_site_in_project_individual_fkey_fkey C
percent_cover_table.site_in_project_percent_cover_fkey percent_cover_table_site_in_project_percent_cover_fkey_fkey C
taxa_table.site_in_project_taxa_key taxa_table_site_in_project_taxa_key_fkey C
study_site_table_fkey varchar 200  √  null
study_site_table.study_site_key site_in_project_table_study_site_table_fkey_fkey R
project_table_fkey int4 10  √  null
project_table.proj_metadata_key site_in_project_table_project_table_fkey_fkey R
sitestartyr numeric 131089  √  null
siteendyr numeric 131089  √  null
totalobs numeric 131089  √  null
uniquetaxaunits numeric 131089  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
site_in_project_key Primary key Asc site_in_project_table_pkey

Close relationships  within of separation: