popler_3.public contains 283 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
alembic_version	version_num	varchar	32
biomass_table	biomass_observation	numeric	131089	√		null
biomass_table	biomass_table_key	serial	10		√	nextval('biomass_table_biomass_table_key_seq'::regclass)
biomass_table	covariates	text	2147483647	√		null
biomass_table	day	numeric	131089	√		null
biomass_table	metadata_biomass_key	int4	10	√		null
biomass_table	month	numeric	131089	√		null
biomass_table	site_in_project_biomass_fkey	int4	10	√		null
biomass_table	spatial_replication_level_1	varchar	50	√		null
biomass_table	spatial_replication_level_2	varchar	50	√		null
biomass_table	spatial_replication_level_3	varchar	50	√		null
biomass_table	spatial_replication_level_4	varchar	50	√		null
biomass_table	spatial_replication_level_5	varchar	50	√		null
biomass_table	structure_type_1	varchar	200	√		null
biomass_table	structure_type_2	varchar	200	√		null
biomass_table	structure_type_3	varchar	200	√		null
biomass_table	structure_type_4	varchar	50	√		null
biomass_table	taxa_biomass_fkey	int4	10	√		null
biomass_table	treatment_type_1	varchar	200	√		null
biomass_table	treatment_type_2	varchar	200	√		null
biomass_table	treatment_type_3	varchar	200	√		null
biomass_table	year	numeric	131089	√		null
climate_raw_table	authors_	varchar	200	√		null
climate_raw_table	authors_contact_	varchar	200	√		null
climate_raw_table	avecondmeasure	varchar	50	√		null
climate_raw_table	avecondobs	numeric	131089	√		null
climate_raw_table	avelightmeasure	varchar	50	√		null
climate_raw_table	avelightobs	numeric	131089	√		null
climate_raw_table	avephmeasure	varchar	50	√		null
climate_raw_table	avephobs	numeric	131089	√		null
climate_raw_table	aveprecipmeasure	varchar	50	√		null
climate_raw_table	aveprecipobs	numeric	131089	√		null
climate_raw_table	avetempmeasure	varchar	50	√		null
climate_raw_table	avetempobs	numeric	131089	√		null
climate_raw_table	aveturbiditymeasure	varchar	50	√		null
climate_raw_table	aveturbidityobs	numeric	131089	√		null
climate_raw_table	avewatertempmeasure	varchar	50	√		null
climate_raw_table	avewatertempobs	numeric	131089	√		null
climate_raw_table	avewindmeasure	varchar	50	√		null
climate_raw_table	avewindobs	numeric	131089	√		null
climate_raw_table	covariates	text	2147483647	√		null
climate_raw_table	day	numeric	131089	√		null
climate_raw_table	knbid_	varchar	200	√		null
climate_raw_table	maxcondmeasure	varchar	50	√		null
climate_raw_table	maxcondobs	numeric	131089	√		null
climate_raw_table	maxlightmeasure	numeric	131089	√		null
climate_raw_table	maxlightobs	numeric	131089	√		null
climate_raw_table	maxphmeasure	numeric	131089	√		null
climate_raw_table	maxphobs	numeric	131089	√		null
climate_raw_table	maxprecipmeasure	numeric	131089	√		null
climate_raw_table	maxprecipobs	numeric	131089	√		null
climate_raw_table	maxtempmeasure	varchar	50	√		null
climate_raw_table	maxtempobs	numeric	131089	√		null
climate_raw_table	maxturbiditymeasure	varchar	50	√		null
climate_raw_table	maxturbidityobs	numeric	131089	√		null
climate_raw_table	maxwatertempmeasure	varchar	50	√		null
climate_raw_table	maxwatertempobs	numeric	131089	√		null
climate_raw_table	maxwindmeasure	numeric	131089	√		null
climate_raw_table	maxwindobs	numeric	131089	√		null
climate_raw_table	metalink_	varchar	200	√		null
climate_raw_table	metarecordid_	serial	10		√	nextval('climate_raw_table_metarecordid__seq'::regclass)
climate_raw_table	mincondmeasure	varchar	50	√		null
climate_raw_table	mincondobs	numeric	131089	√		null
climate_raw_table	minlightmeasure	varchar	50	√		null
climate_raw_table	minlightobs	numeric	131089	√		null
climate_raw_table	minphmeasure	varchar	50	√		null
climate_raw_table	minphobs	numeric	131089	√		null
climate_raw_table	minprecipmeasure	varchar	50	√		null
climate_raw_table	minprecipobs	numeric	131089	√		null
climate_raw_table	mintempmeasure	varchar	50	√		null
climate_raw_table	mintempobs	numeric	131089	√		null
climate_raw_table	minturbiditymeasure	varchar	50	√		null
climate_raw_table	minturbidityobs	numeric	131089	√		null
climate_raw_table	minwatertempmeasure	varchar	50	√		null
climate_raw_table	minwatertempobs	numeric	131089	√		null
climate_raw_table	minwindmeasure	varchar	50	√		null
climate_raw_table	minwindobs	numeric	131089	√		null
climate_raw_table	month	numeric	131089	√		null
climate_raw_table	stationid	varchar	200	√		null
climate_raw_table	title	text	2147483647	√		null
climate_raw_table	year	numeric	131089	√		null
climate_station_table	descript	text	2147483647	√		null
climate_station_table	lat_climate	numeric	131089	√		null
climate_station_table	lng_climate	numeric	131089	√		null
climate_station_table	lterid	varchar	10	√		null
climate_station_table	stationid	varchar	200
count_table	count_observation	numeric	131089	√		null
count_table	count_table_key	serial	10		√	nextval('count_table_count_table_key_seq'::regclass)
count_table	covariates	text	2147483647	√		null
count_table	day	numeric	131089	√		null
count_table	metadata_count_key	int4	10	√		null
count_table	month	numeric	131089	√		null
count_table	site_in_project_count_fkey	int4	10	√		null
count_table	spatial_replication_level_1	varchar	50	√		null
count_table	spatial_replication_level_2	varchar	50	√		null
count_table	spatial_replication_level_3	varchar	50	√		null
count_table	spatial_replication_level_4	varchar	50	√		null
count_table	spatial_replication_level_5	varchar	50	√		null
count_table	structure_type_1	varchar	200	√		null
count_table	structure_type_2	varchar	200	√		null
count_table	structure_type_3	varchar	200	√		null
count_table	structure_type_4	varchar	50	√		null
count_table	taxa_count_fkey	int4	10	√		null
count_table	treatment_type_1	varchar	200	√		null
count_table	treatment_type_2	varchar	200	√		null
count_table	treatment_type_3	varchar	200	√		null
count_table	year	numeric	131089	√		null
density_table	covariates	text	2147483647	√		null
density_table	day	numeric	131089	√		null
density_table	density_observation	numeric	131089	√		null
density_table	density_table_key	serial	10		√	nextval('density_table_density_table_key_seq'::regclass)
density_table	metadata_density_key	int4	10	√		null
density_table	month	numeric	131089	√		null
density_table	site_in_project_density_fkey	int4	10	√		null
density_table	spatial_replication_level_1	varchar	50	√		null
density_table	spatial_replication_level_2	varchar	50	√		null
density_table	spatial_replication_level_3	varchar	50	√		null
density_table	spatial_replication_level_4	varchar	50	√		null
density_table	spatial_replication_level_5	varchar	50	√		null
density_table	structure_type_1	varchar	200	√		null
density_table	structure_type_2	varchar	200	√		null
density_table	structure_type_3	varchar	200	√		null
density_table	structure_type_4	varchar	50	√		null
density_table	taxa_density_fkey	int4	10	√		null
density_table	treatment_type_1	varchar	200	√		null
density_table	treatment_type_2	varchar	200	√		null
density_table	treatment_type_3	varchar	200	√		null
density_table	year	numeric	131089	√		null
individual_table	covariates	text	2147483647	√		null
individual_table	day	numeric	131089	√		null
individual_table	individual_observation	numeric	131089	√		null
individual_table	individual_table_key	serial	10		√	nextval('individual_table_individual_table_key_seq'::regclass)
individual_table	metadata_individual_key	int4	10	√		null
individual_table	month	numeric	131089	√		null
individual_table	site_in_project_individual_fkey	int4	10	√		null
individual_table	spatial_replication_level_1	varchar	50	√		null
individual_table	spatial_replication_level_2	varchar	50	√		null
individual_table	spatial_replication_level_3	varchar	50	√		null
individual_table	spatial_replication_level_4	varchar	50	√		null
individual_table	spatial_replication_level_5	varchar	50	√		null
individual_table	structure_type_1	varchar	200	√		null
individual_table	structure_type_2	varchar	200	√		null
individual_table	structure_type_3	varchar	200	√		null
individual_table	structure_type_4	varchar	50	√		null
individual_table	taxa_individual_fkey	int4	10	√		null
individual_table	treatment_type_1	varchar	200	√		null
individual_table	treatment_type_2	varchar	200	√		null
individual_table	treatment_type_3	varchar	200	√		null
individual_table	year	numeric	131089	√		null
lter_table	alt_contact_email	varchar	200	√		null
lter_table	current_contact_email	varchar	200	√		null
lter_table	current_principle_investigator	varchar	200	√		null
lter_table	currently_funded	varchar	50	√		null
lter_table	homepage	varchar	200	√		null
lter_table	lat_lter	numeric	131089	√		null
lter_table	lng_lter	numeric	131089	√		null
lter_table	lter_name	text	2147483647	√		null
lter_table	lterid	varchar	10
percent_cover_table	covariates	text	2147483647	√		null
percent_cover_table	day	numeric	131089	√		null
percent_cover_table	metadata_percent_cover_key	int4	10	√		null
percent_cover_table	month	numeric	131089	√		null
percent_cover_table	percent_cover_observation	numeric	131089	√		null
percent_cover_table	percent_cover_table_key	serial	10		√	nextval('percent_cover_table_percent_cover_table_key_seq'::regclass)
percent_cover_table	site_in_project_percent_cover_fkey	int4	10	√		null
percent_cover_table	spatial_replication_level_1	varchar	50	√		null
percent_cover_table	spatial_replication_level_2	varchar	50	√		null
percent_cover_table	spatial_replication_level_3	varchar	50	√		null
percent_cover_table	spatial_replication_level_4	varchar	50	√		null
percent_cover_table	spatial_replication_level_5	varchar	50	√		null
percent_cover_table	structure_type_1	varchar	200	√		null
percent_cover_table	structure_type_2	varchar	200	√		null
percent_cover_table	structure_type_3	varchar	200	√		null
percent_cover_table	structure_type_4	varchar	50	√		null
percent_cover_table	taxa_percent_cover_fkey	int4	10	√		null
percent_cover_table	treatment_type_1	varchar	200	√		null
percent_cover_table	treatment_type_2	varchar	200	√		null
percent_cover_table	treatment_type_3	varchar	200	√		null
percent_cover_table	year	numeric	131089	√		null
project_table	authors	text	2147483647	√		null
project_table	authors_contact	varchar	200	√		null
project_table	community	varchar	50	√		null
project_table	control_group	varchar	200	√		null
project_table	datatype	varchar	50	√		null
project_table	derived	varchar	200	√		null
project_table	duration_years	int4	10	√		null
project_table	knbid	varchar	200	√		null
project_table	lter_project_fkey	varchar	10	√		null
project_table	metalink	text	2147483647	√		null
project_table	proj_metadata_key	serial	10		√	nextval('project_table_proj_metadata_key_seq'::regclass)
project_table	samplefreq	text	2147483647	√		null
project_table	samplingunits	varchar	50	√		null
project_table	spatial_replication_level_1_extent	numeric	131089	√		null
project_table	spatial_replication_level_1_extent_units	varchar	200	√		null
project_table	spatial_replication_level_1_label	varchar	200	√		null
project_table	spatial_replication_level_1_number_of_unique_reps	int4	10	√		null
project_table	spatial_replication_level_2_extent	numeric	131089	√		null
project_table	spatial_replication_level_2_extent_units	varchar	200	√		null
project_table	spatial_replication_level_2_label	varchar	200	√		null
project_table	spatial_replication_level_2_number_of_unique_reps	int4	10	√		null
project_table	spatial_replication_level_3_extent	numeric	131089	√		null
project_table	spatial_replication_level_3_extent_units	varchar	200	√		null
project_table	spatial_replication_level_3_label	varchar	200	√		null
project_table	spatial_replication_level_3_number_of_unique_reps	int4	10	√		null
project_table	spatial_replication_level_4_extent	numeric	131089	√		null
project_table	spatial_replication_level_4_extent_units	varchar	200	√		null
project_table	spatial_replication_level_4_label	varchar	200	√		null
project_table	spatial_replication_level_4_number_of_unique_reps	int4	10	√		null
project_table	spatial_replication_level_5_extent	numeric	131089	√		null
project_table	spatial_replication_level_5_extent_units	varchar	200	√		null
project_table	spatial_replication_level_5_label	varchar	200	√		null
project_table	spatial_replication_level_5_number_of_unique_reps	int4	10	√		null
project_table	structured_type_1	varchar	50	√		null
project_table	structured_type_1_units	varchar	50	√		null
project_table	structured_type_2	varchar	50	√		null
project_table	structured_type_2_units	varchar	50	√		null
project_table	structured_type_3	varchar	50	√		null
project_table	structured_type_3_units	varchar	50	√		null
project_table	structured_type_4	varchar	50	√		null
project_table	structured_type_4_units	varchar	50	√		null
project_table	studyendyr	numeric	131089	√		null
project_table	studystartyr	numeric	131089	√		null
project_table	studytype	varchar	50	√		null
project_table	title	text	2147483647	√		null
project_table	treatment_type_1	varchar	200	√		null
project_table	treatment_type_2	varchar	200	√		null
project_table	treatment_type_3	varchar	200	√		null
site_in_project_table	project_table_fkey	int4	10	√		null
site_in_project_table	site_in_project_key	serial	10		√	nextval('site_in_project_table_site_in_project_key_seq'::regclass)
site_in_project_table	siteendyr	numeric	131089	√		null
site_in_project_table	sitestartyr	numeric	131089	√		null
site_in_project_table	study_site_table_fkey	varchar	200	√		null
site_in_project_table	totalobs	numeric	131089	√		null
site_in_project_table	uniquetaxaunits	numeric	131089	√		null
study_site_table	descript	text	2147483647	√		null
study_site_table	lat_study_site	numeric	131089	√		null
study_site_table	lng_study_site	numeric	131089	√		null
study_site_table	lter_table_fkey	varchar	10	√		null
study_site_table	study_site_key	varchar	200
taxa_accepted_table	authority	varchar	100	√		null
taxa_accepted_table	clss_accepted	varchar	100	√		null
taxa_accepted_table	common_name_accepted	varchar	100	√		null
taxa_accepted_table	division_accepted	varchar	100	√		null
taxa_accepted_table	family_accepted	varchar	100	√		null
taxa_accepted_table	genus_accepted	varchar	100	√		null
taxa_accepted_table	infrakingdom_accepted	varchar	100	√		null
taxa_accepted_table	kingdom_accepted	varchar	100	√		null
taxa_accepted_table	ordr_accepted	varchar	100	√		null
taxa_accepted_table	phylum_accepted	varchar	100	√		null
taxa_accepted_table	species_accepted	varchar	100	√		null
taxa_accepted_table	sppcode	varchar	100	√		null
taxa_accepted_table	subclass_accepted	varchar	100	√		null
taxa_accepted_table	subdivision_accepted	varchar	100	√		null
taxa_accepted_table	subkingdom_accepted	varchar	100	√		null
taxa_accepted_table	subphylum_accepted	varchar	100	√		null
taxa_accepted_table	superdivision_accepted	varchar	100	√		null
taxa_accepted_table	superphylum_accepted	varchar	100	√		null
taxa_accepted_table	taxa_accepted_db	varchar	100	√		null
taxa_accepted_table	taxa_accepted_db_id	varchar	100	√		null
taxa_accepted_table	taxa_accepted_db_url	text	2147483647	√		null
taxa_accepted_table	taxa_accepted_table_key	serial	10		√	nextval('taxa_accepted_table_taxa_accepted_table_key_seq'::regclass)
taxa_accepted_table	taxa_original_fkey	int4	10	√		null
taxa_table	authority	varchar	100	√		null
taxa_table	clss	varchar	100	√		null
taxa_table	common_name	varchar	100	√		null
taxa_table	division	varchar	100	√		null
taxa_table	family	varchar	100	√		null
taxa_table	genus	varchar	100	√		null
taxa_table	infrakingdom	varchar	100	√		null
taxa_table	kingdom	varchar	100	√		null
taxa_table	metadata_taxa_key	int4	10	√		null
taxa_table	ordr	varchar	100	√		null
taxa_table	phylum	varchar	100	√		null
taxa_table	site_in_project_taxa_key	int4	10	√		null
taxa_table	species	varchar	100	√		null
taxa_table	sppcode	varchar	100	√		null
taxa_table	subclass	varchar	100	√		null
taxa_table	subdivision	varchar	100	√		null
taxa_table	subkingdom	varchar	100	√		null
taxa_table	subphylum	varchar	100	√		null
taxa_table	superdivision	varchar	100	√		null
taxa_table	superphylum	varchar	100	√		null
taxa_table	taxa_table_key	serial	10		√	nextval('taxa_table_taxa_table_key_seq'::regclass)