Difference between revisions of "HTP Database Table Structure"
From Poland Lab Wiki
(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...") |
(No difference)
|
Revision as of 16:49, 3 May 2016
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. |