Table popler_3.public.climate_raw_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
metarecordid_ serial 10  √  nextval('climate_raw_table_metarecordid__seq'::regclass)
title text 2147483647  √  null
stationid varchar 200  √  null
climate_station_table.stationid climate_raw_table_stationid_fkey C
year numeric 131089  √  null
month numeric 131089  √  null
day numeric 131089  √  null
avetempobs numeric 131089  √  null
avetempmeasure varchar 50  √  null
mintempobs numeric 131089  √  null
mintempmeasure varchar 50  √  null
maxtempobs numeric 131089  √  null
maxtempmeasure varchar 50  √  null
aveprecipobs numeric 131089  √  null
aveprecipmeasure varchar 50  √  null
minprecipobs numeric 131089  √  null
minprecipmeasure varchar 50  √  null
maxprecipobs numeric 131089  √  null
maxprecipmeasure numeric 131089  √  null
avewindobs numeric 131089  √  null
avewindmeasure varchar 50  √  null
minwindobs numeric 131089  √  null
minwindmeasure varchar 50  √  null
maxwindobs numeric 131089  √  null
maxwindmeasure numeric 131089  √  null
avelightobs numeric 131089  √  null
avelightmeasure varchar 50  √  null
minlightobs numeric 131089  √  null
minlightmeasure varchar 50  √  null
maxlightobs numeric 131089  √  null
maxlightmeasure numeric 131089  √  null
avewatertempobs numeric 131089  √  null
avewatertempmeasure varchar 50  √  null
minwatertempobs numeric 131089  √  null
minwatertempmeasure varchar 50  √  null
maxwatertempobs numeric 131089  √  null
maxwatertempmeasure varchar 50  √  null
avephobs numeric 131089  √  null
avephmeasure varchar 50  √  null
minphobs numeric 131089  √  null
minphmeasure varchar 50  √  null
maxphobs numeric 131089  √  null
maxphmeasure numeric 131089  √  null
avecondobs numeric 131089  √  null
avecondmeasure varchar 50  √  null
mincondobs numeric 131089  √  null
mincondmeasure varchar 50  √  null
maxcondobs numeric 131089  √  null
maxcondmeasure varchar 50  √  null
aveturbidityobs numeric 131089  √  null
aveturbiditymeasure varchar 50  √  null
minturbidityobs numeric 131089  √  null
minturbiditymeasure varchar 50  √  null
maxturbidityobs numeric 131089  √  null
maxturbiditymeasure varchar 50  √  null
covariates text 2147483647  √  null
knbid_ varchar 200  √  null
metalink_ varchar 200  √  null
authors_ varchar 200  √  null
authors_contact_ varchar 200  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
metarecordid_ Primary key Asc climate_raw_table_pkey

Close relationships  within of separation: