tables_fields:other_tables:temperature

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
tables_fields:other_tables:temperature [2020/05/18 05:13] – Craig Drowntables_fields:other_tables:temperature [2022/06/08 17:00] (current) – [temperature_breach] Adrian Boone
Line 4: Line 4:
 ==== temperature_breach  ==== ==== temperature_breach  ====
 ^ Field number  ^  Field Name  ^   Description ^ Type  ^  Length  ^  Index ^ ^ Field number  ^  Field Name  ^   Description ^ Type  ^  Length  ^  Index ^
-|4|end_date|     |   Date  |  |  | +|4|end_date| Date that the breach ended     |   Date  |  |  | 
-|5|end_time|     |   Time  |  |  | +|5|end_time| Time in seconds since midnight that the breach ended    |   Time  |  |  | 
-|1|ID|     |   Alpha  |  |  Y  | +|1|ID| Unique ID of this record    |   Alpha  |  |  Y  | 
-|6|location_ID|     |   Alpha  |  |  | +|6|location_ID| The ID of the location in the store where the breach occurred    |   Alpha  |  |  | 
-|2|start_date|     |   Date  |  |  | +|2|start_date| Date that the breach started    |   Date  |  |  | 
-|3|start_time|     |   Time  |  |  | +|3|start_time| Time in seconds since midnight that the breach started     |   Time  |  |  | 
-|7|store_ID|     |   Alpha  |  |  | +|7|store_ID|The ID of the store (facility) where the breach occurred     |   Alpha  | |  | 
-|8|temperature_breach_config_ID|     |   Alpha  |  |  |+|8|temperature_breach_config_ID| The ID of the temperature_breach_config record that applied     |   Alpha  |  |  |
  
 ==== temperature_breach_config  ==== ==== temperature_breach_config  ====
Line 17: Line 17:
 |5|colour|     |   Alpha  |  |  | |5|colour|     |   Alpha  |  |  |
 |6|description|     |   Alpha  |  |  | |6|description|     |   Alpha  |  |  |
-|4|duration|     |   Long Integer  |  |  |+|4|duration| How long (in minutes) out of temperature range before it is considered a breach    |   Long Integer  |  |  |
 |1|ID|     |   Alpha  |  |  Y  | |1|ID|     |   Alpha  |  |  Y  |
-|2|maximum_temperature|     |   Real  |  |  | +|2|maximum_temperature| Maximum breach temperature in degrees Celsius    |   Real  |  |  | 
-|3|minimum_temperature|     |   Real  |  |  |+|3|minimum_temperature| Minimum breach temperature in degrees Celsius     |   Real  |  |  |
  
 ==== temperature_log  ==== ==== temperature_log  ====
Line 50: Line 50:
  
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2020/05/18 05:13
  • by Craig Drown