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 [2022/05/04 01:56] – [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|The ID of the store (facility) | + | |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 | ||