SupportUser_Notes Tables
The leaseCompany_enquiry_serviceUnit_supportUserNotes_latest and leaseCompany_enquiry_serviceUnit_supportUserNotes_changelog tables stores the notes added by the support console user for of all the enquiries.
🔹 Standard Columns​
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
document_name | STRING | YES | Name of the Firestore document |
document_event_id | STRING | YES | Unique ID representing the document event (change ID) |
document_timestamp | TIMESTAMP | YES | Timestamp when the document event occurred |
document_operation | STRING | YES | Type of Firestore operation (e.g., CREATE, UPDATE, DELETE) |
document_id | STRING | YES | ID of the Firestore document |
accountId | STRING | YES | Account identifier related to the document |
serviceUnitId | STRING | YES | Identifier of the service unit |
enquiryId | STRING | YES | Identifier for the enquiry associated with the document |
leaseCompanyId | STRING | YES | Identifier for the lease company related to this record |
🔸 Array Columns​
Array of STRUCT
notes​
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
note | STRING | YES | Text content of the note |
status | STRING | YES | Status associated with the note |
timestamp._seconds | INT64 | YES | Timestamp seconds when the note was added |
timestamp._nanoseconds | INT64 | YES | Timestamp nanoseconds when the note was added |
user.firstname | STRING | YES | first name of the user who added the note |
user.lastname | STRING | YES | last name of the user who added the note |
user.objectID | STRING | YES | objectID of the user who added the note |