Difference between revisions of "Weather Readings Database Schema"

From Earlham CS Department
Jump to navigation Jump to search
 
Line 1: Line 1:
 +
Does not match new weather system. For archival use only.
 +
 
weather=# \d+ readings
 
weather=# \d+ readings
 
                         Table "public.readings"
 
                         Table "public.readings"

Latest revision as of 12:04, 14 May 2015

Does not match new weather system. For archival use only.

weather=# \d+ readings

                       Table "public.readings"
       Column        |         Type         | Modifiers | Description
---------------------+----------------------+-----------+-------------
 timestamp           | abstime              |           | 
 in_temperature      | double precision     |           | Celsius 
 out_temperature     | double precision     |           | Celsius
 wind_speed          | integer              |           | Meters/Second
 wind_heading        | integer              |           | Degrees
 barometric_pressure | integer              |           | mm Hg
 in_humidity         | integer              |           | Percent
 out_humidity        | integer              |           | Percent
 total_rain          | double precision     |           | Centimeters
 wind_chill          | double precision     |           | Celsius
 dew_point           | double precision     |           | Celsius
 barometric_trend    | character varying(7) |           | NA (text string)
 daily_rain          | double precision     |           | NA, we never collected this value
Indexes:
    "timestam_pkey" UNIQUE, btree ("timestamp")
    "date_idx" btree ("timestamp")
Check constraints:
    "$1" CHECK (in_temperature >= 0:ouble precision AND in_temperature <= 50::
double precision)
    "$10" CHECK (wind_chill >= (- 40:ouble precision) AND wind_chill <= 50:o
uble precision)
    "$2" CHECK (dew_point >= (- 35:ouble precision) AND dew_point <= 50:ouble precision)
    "$3" CHECK (out_temperature >= (- 30:ouble precision) AND out_temperature <= 50:ouble precision)
    "$4" CHECK (wind_speed >= 0 AND wind_speed <= 100)
    "$5" CHECK (wind_heading >= 0 AND wind_heading <= 360)
    "$6" CHECK (barometric_pressure >= 71000 AND barometric_pressure <= 76000)
    "$7" CHECK (in_humidity >= 0 AND in_humidity <= 100)
    "$8" CHECK (out_humidity >= 0 AND out_humidity <= 100)
    "$9" CHECK (total_rain >= 0:ouble precision AND total_rain <= 100:ouble precision)
Has OIDs: yes