Table popler_3.public.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
proj_metadata_key serial 10  √  nextval('project_table_proj_metadata_key_seq'::regclass)
site_in_project_table.project_table_fkey site_in_project_table_project_table_fkey_fkey R
lter_project_fkey varchar 10  √  null
lter_table.lterid project_table_lter_project_fkey_fkey R
title text 2147483647  √  null
samplingunits varchar 50  √  null
datatype varchar 50  √  null
structured_type_1 varchar 50  √  null
structured_type_1_units varchar 50  √  null
structured_type_2 varchar 50  √  null
structured_type_2_units varchar 50  √  null
structured_type_3 varchar 50  √  null
structured_type_3_units varchar 50  √  null
studystartyr numeric 131089  √  null
studyendyr numeric 131089  √  null
samplefreq text 2147483647  √  null
studytype varchar 50  √  null
community varchar 50  √  null
spatial_replication_level_1_extent numeric 131089  √  null
spatial_replication_level_1_extent_units varchar 200  √  null
spatial_replication_level_1_label varchar 200  √  null
spatial_replication_level_1_number_of_unique_reps int4 10  √  null
spatial_replication_level_2_extent numeric 131089  √  null
spatial_replication_level_2_extent_units varchar 200  √  null
spatial_replication_level_2_label varchar 200  √  null
spatial_replication_level_2_number_of_unique_reps int4 10  √  null
spatial_replication_level_3_extent numeric 131089  √  null
spatial_replication_level_3_extent_units varchar 200  √  null
spatial_replication_level_3_label varchar 200  √  null
spatial_replication_level_3_number_of_unique_reps int4 10  √  null
spatial_replication_level_4_extent numeric 131089  √  null
spatial_replication_level_4_extent_units varchar 200  √  null
spatial_replication_level_4_label varchar 200  √  null
spatial_replication_level_4_number_of_unique_reps int4 10  √  null
spatial_replication_level_5_extent numeric 131089  √  null
spatial_replication_level_5_extent_units varchar 200  √  null
spatial_replication_level_5_label varchar 200  √  null
spatial_replication_level_5_number_of_unique_reps int4 10  √  null
treatment_type_1 varchar 200  √  null
treatment_type_2 varchar 200  √  null
treatment_type_3 varchar 200  √  null
control_group varchar 200  √  null
derived varchar 200  √  null
authors text 2147483647  √  null
authors_contact varchar 200  √  null
metalink text 2147483647  √  null
knbid varchar 200  √  null
structured_type_4 varchar 50  √  null
structured_type_4_units varchar 50  √  null
duration_years int4 10  √  null

Table contained 209 rows at Wed Aug 30 10:19 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
proj_metadata_key Primary key Asc project_table_pkey

Close relationships  within of separation: