Enquiry_Event_Response_Time Tables

The enquiry_event_response_time_changelog and enquiry_event_response_time_latest tables stores the data of all events that happened during an enquiry, including details of the event and their respective timestamps.

---

🔹 Standard Columns

Column Name	Data Type	Nullable	Description
document_name	STRING	YES	Name of the Firestore document
document_event_id	STRING	YES	Unique identifier for the document event
document_timestamp	TIMESTAMP	YES	Timestamp when the document event occurred
document_operation	STRING	YES	Type of operation (create, update, delete)
document_id	STRING	YES	Unique ID of the Firestore document
accountId	STRING	YES	Associated account ID
serviceUnitId	STRING	YES	Identifier for the service unit
enquiryId	STRING	YES	Identifier for the enquiry
NEW_label	STRING	YES	Label associated with NEW status
BID_COMPLETED_label	STRING	YES	Label for BID_COMPLETED status
BID_ACCEPTED_label	STRING	YES	Label for BID_ACCEPTED status
NO_SHOW_label	STRING	YES	Label for NO_SHOW status
CANCELLED_label	STRING	YES	Label for CANCELLED status
CHECK_IN_COMPLETE_label	STRING	YES	Label for CHECK_IN_COMPLETE status
REQUESTED_label	STRING	YES	Label for REQUESTED status
Enquiry Ownership taken_label	STRING	YES	Label for ownership taken status
ON_HOLD_label	STRING	YES	Label for ON_HOLD status
AUTHORISED_label	STRING	YES	Label for AUTHORISED status
DECLINED_label	STRING	YES	Label for DECLINED status
REASSIGNED_label	STRING	YES	Label for REASSIGNED status
BEING_WORKED_ON_label	STRING	YES	Label for BEING_WORKED_ON status
QUALITY_CHECKED_label	STRING	YES	Label for QUALITY_CHECKED status
READY_FOR_COLLECTION_label	STRING	YES	Label for READY_FOR_COLLECTION status
UNSCHEDULED_DELAY_label	STRING	YES	Label for UNSCHEDULED_DELAY status
Released Job Ownership_label	STRING	YES	Label for released ownership status
COMPLETED_label	STRING	YES	Label for COMPLETED status
INVOICE_GENERATED_label	STRING	YES	Label for INVOICE_GENERATED status
PARTIALLY_AUTHORISED_label	STRING	YES	Label for PARTIALLY_AUTHORISED status

---

🔸 Struct Columns

Column Name	Data Type	Nullable	Description
NEW_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when status changed to NEW
BID_COMPLETED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when bid was completed
BID_ACCEPTED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when bid was accepted
NO_SHOW_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when user was marked as no-show
CANCELLED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when enquiry/job was cancelled
CHECK_IN_COMPLETE_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when check-in was completed
REQUESTED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when service/enquiry was requested
Enquiry Ownership taken_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when enquiry ownership was taken
ON_HOLD_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when the process was put on hold
AUTHORISED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when authorised
DECLINED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when the request was declined
REASSIGNED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when job/enquiry was reassigned
BEING_WORKED_ON_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when job/enquiry started being worked on
QUALITY_CHECKED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when quality check was done
READY_FOR_COLLECTION_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when job was marked ready for collection
UNSCHEDULED_DELAY_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when an unscheduled delay occurred
Released Job Ownership_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when job ownership was released
COMPLETED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when the job was completed
INVOICE_GENERATED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when the invoice was generated
PARTIALLY_AUTHORISED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Timestamp when partial authorisation was given
Initial_ON_HOLD_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Initial timestamp when job was put on hold
Initial_AUTHORISED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Initial timestamp when job was authorised
Initial_PARTIALLY_AUTHORISED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Initial timestamp for partial authorisation
Initial_DECLINED_Timestamp	STRUCT _seconds INT64, _nanoseconds INT64	YES	Initial timestamp when job was declined