Turtle Sense/Database design
Jump to navigation
Jump to search
- field_name (data example)
Table: REPORTS
This table contains the header information of each report.
- Report_ID (sequentially numbered) key index
- File_name (2014-06-20_AA0014_r-005-03)
- Days_active (005)
- Report_number (03)
- Comm_ ID (C-AA0002)
- Nest_ID
- Start_date_time (2014/06/24 19:45:27)
- Report_date_time (2014/06/24 20:45:29)
- Secs_per_record (000F)
- Number_of_records (00F0)
- Battery_level (023B)
Table:NEST
- Nest_ID
- Installed (2014-06-20)
- Sensor_ID (AA0014)
- Nest_longitude (12226.3671W)
- Nest_latitude (3746.3183N)
- Status
- Parameters_ID
Table: RECORDS
- Record_ID
- Report_ID
- Nest_ID
- Record_number
- Date_time
- Temperature_hex
- X_hex
- Y_hex
- Z_hex
- Readings
- Maximum
- Bin_A
- Bin_B
- Bin_C
- Bin_D
- Bin_E
- Bin_F
- Bin_G
- Bin_H
- Bin_I
- Bin_J
- Bin_00
- Bin_01
- Bin_02
- Bin_03
- Bin_04
- Bin_05
- Bin_06
- Bin_07
- Bin_08
- Bin_09
- Bin_10
- Bin_11
- Bin_12
- Bin_13
- Bin_14
- Bin_15
- Bin_16
- Bin_17
- Bin_18
- Bin_19
- Bin_20
- Bin_21
- Bin_22
- Bin_23
- Bin_24
- Bin_25
- Missing
- Energy