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
Table: PARAMTETERS
- THRESH_ACT
- THRESH_INACT
- TIME_INACT
- MAXRUN
- SLOWBIN
- BINSEC
the following are all one byte fields
- THRESH_ACT_L
- THRESH_ACT_H
- TIME_ACT
- THRESH_INACT_L
- THRESH_INACT_H
- TIME_INACT_L
- TIME_INACT_H
- ACT_INACT_CTL
- FIFO_CONTRO
- FIFO_SAMPLES
- INTMAP1
- INTMAP2
- FILTER_CTL
- POWER_CTL
- SLEEP_INTERVALS
- READ_SPEED
- SLOWBIN_LO
- SLOWBIN_HI
- MAXRUN1
- MAXRUN2
- MAXRUN3
- MAXRUN4H
- MAX_RECORDS_LO
- MAX_RECORDS_HI
- CALIBRATE_TEMP
- REPORT_HEADINGS
- BINSEC_LO
- BINSEC_HI
- SLOW_DAYS
- SLOWBIN_LO
- SLOWBIN_HI
- SPARE_1
- SPARE_2
- SPARE_3
- SPARE_4
- SPARE_5
- SPARE_6
- SPARE_7
- SPARE_8
- SPARE_9