Enquiry_ChatMessages Tables

The accounts_serviceUnitEnquiry_chatMessages_changelog and accounts_serviceUnitEnquiry_chatMessages_latest tables stores the messages sent by supplier and customers for of all the enquiries.

---

🔹 Standard Columns

Column Name	Data Type	Nullable	Description
document_name	STRING	YES	Name of the document
document_event_id	STRING	YES	Event ID associated with the change
document_timestamp	TIMESTAMP	YES	Time of the document change
document_operation	STRING	YES	Operation performed (INSERT/UPDATE/...)
document_id	STRING	YES	ID of the document
messageCountFromLease	INT64	YES	Count of messages from lease
accountId	STRING	YES	Account identifier
serviceUnitId	STRING	YES	Service unit identifier
enquiryId	STRING	YES	Enquiry identifier

---

🔸 Array Columns

Array of STRUCT

messages

Column Name	Data Type	Nullable	Description
enquiryStatus	STRING	YES	Status of the enquiry
id	STRING	YES	Unique message ID
markedAsReadBy.firstname	STRING	YES	First name of the person who read
markedAsReadBy.lastname	STRING	YES	Last name of the person who read
markedAsReadBy.objectID	STRING	YES	Object ID of the person who read
markedAsReadBy.timestamp._seconds	INT64	YES	Timestamp (seconds)
markedAsReadBy.timestamp._nanoseconds	INT64	YES	Timestamp (nanoseconds)
message	STRING	YES	Actual message content
messageFrom	STRING	YES	Sender of the message
messageTo	STRING	YES	Receiver of the message
myMessage	BOOL	YES	Whether it's user's message
timestamp._seconds	INT64	YES	Message timestamp (seconds)
timestamp._nanoseconds	INT64	YES	Message timestamp (nanoseconds)
user.company	STRING	YES	Company of the user
user.contact.email	STRING	YES	Email of the user's contact
user.firstname	STRING	YES	First name of the user
user.lastname	STRING	YES	Last name of the user
user.objectID	STRING	YES	Object ID of the user
code	STRING	YES	Optional message code