HTP Database Table Structure

From Poland Lab Wiki
Revision as of 16:49, 3 May 2016 by Mlucas (Talk | contribs) (Created page with "{|class="wikitable" |+Table Name: phemu_htp !style="text-align:center;"|column !data type !constraints !description |- |record_id||integer||Unique sequential integer||A sequen...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Table Name: phemu_htp
column data type constraints description
record_id integer Unique sequential integer A sequential number generated when record is inserted. Used as a synthetic primary key.
run_id text NOT NULL An ID used to identify a data collection run.
Format: <platform>_<start_date>_<start_time>_<end_date>_<end_time>
plot_id char(10) The name of the plot that the sensor observation is associated with.
Note that this may be null if the observation was taken in a position not over a plot.