Schema

Column Name	Data Type	Description
fridge_log_id	integer	Primary key for the fridge log table.
organisation	varchar	An organisation is synonymous with a pharmacy and is also known as the RXid.
is_deleted	boolean	Whether this record should be considered deleted. Data deleted at source has non-key columns set to null while primary keys are retained.
pharmacy_name	varchar	The name of the pharmacy.
date_added	timestamp	Fridge log creation date.
location_name	varchar	The name of the location.
minimum_temperature	numeric	The minimum temperature threshold for the fridge.
maximum_temperature	numeric	The maximum temperature threshold for the fridge.
notes	varchar	Additional notes about the fridge log entry.
branch_identifier	varchar	Branch identifier assigned by head office for data exchange workflows.
national_practice_code	varchar	Pharmacy NacsCode used to identify the pharmacy when the user logs in.
row_id	varchar	Unique hash generated based on column values, used to identify data changes.
last_updated_date	date	Date that this record was last updated by the orchestration process.