Difference between revisions of "HTP Database Table Structure"

From Poland Lab Wiki
Jump to: navigation, search
(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...")
 
(Blanked the page)
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
{|class="wikitable"
+
 
−
|+Table Name: phemu_htp
+
−
!style="text-align:center;"|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.<br />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.<br /> Note that this may be null if the observation was taken in a position not over a plot.
+
−
|}
+

Latest revision as of 16:24, 12 May 2016

Retrieved from "https://wiki.wheatgenetics.k-state.edu/index.php?title=HTP_Database_Table_Structure&oldid=555"