Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
tables_fields:other_tables:temperature [2020/05/21 04:45] – [temperature_breach] Craig Drown | tables_fields:other_tables:temperature [2022/06/08 17:00] (current) – [temperature_breach] Adrian Boone | ||
---|---|---|---|
Line 7: | Line 7: | ||
|5|end_time| Time in seconds since midnight that the breach ended | | |5|end_time| Time in seconds since midnight that the breach ended | | ||
|1|ID| Unique ID of this record | |1|ID| Unique ID of this record | ||
- | |6|location_ID| | + | |6|location_ID| |
|2|start_date| Date that the breach started | |2|start_date| Date that the breach started | ||
|3|start_time| Time in seconds since midnight that the breach started | |3|start_time| Time in seconds since midnight that the breach started | ||
- | |7|store_ID| | + | |7|store_ID|The ID of the store (facility) |
- | |8|temperature_breach_config_ID| The id of the temperature_breach_config record that applied | + | |8|temperature_breach_config_ID| The ID of the temperature_breach_config record that applied |
==== temperature_breach_config | ==== temperature_breach_config | ||
Line 19: | Line 19: | ||
|4|duration| How long (in minutes) out of temperature range before it is considered a breach | |4|duration| How long (in minutes) out of temperature range before it is considered a breach | ||
|1|ID| | |1|ID| | ||
- | |2|maximum_temperature| Maximum | + | |2|maximum_temperature| Maximum |
- | |3|minimum_temperature| Minimum | + | |3|minimum_temperature| Minimum |
==== temperature_log | ==== temperature_log | ||
Line 50: | Line 50: | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||