[[tables_fields:other_tables:temperature]]

Field number Field Name Description Type Length Index
4end_date Date that the breach ended Date
5end_time Time in seconds since midnight that the breach ended Time
1ID Unique ID of this record Alpha Y
6location_ID Alpha
2start_date Date that the breach started Date
3start_time Time in seconds since midnight that the breach started Time
7store_ID Alpha The ID of the store (facility)
8temperature_breach_config_ID The id of the temperature_breach_config record that applied Alpha
Field number Field Name Description Type Length Index
5colour Alpha
6description Alpha
4duration How long (in minutes) out of temperature range before it is considered a breach Long Integer
1ID Alpha Y
2maximum_temperature Maximum acceptable temperature in degrees Celcius Real
3minimum_temperature Minimum acceptable temperature in degrees Celcius Real
Field number Field Name Description Type Length Index
3date Date
1ID Alpha Y
5location_ID Alpha
7store_ID Alpha
2temperature Real Y
6temperature_breach_ID Alpha
4time Time
Field number Field Name Description Type Length Index
3code Alpha
2description Alpha
1ID Alpha Y
5is_active Boolean
4level Long Integer
Field number Field Name Description Type Length Index
3date Date
1ID Alpha Y
5item_line_ID Alpha
2status_ID Alpha
6store_ID Alpha
4time Time
  • Last modified: 2020/05/21 04:45
  • by Craig Drown