Logs_Haynes_GetRepairtimeNodesV3 Tables

The logs_haynes_getRepairtimeNodesV3_latest and logs_haynes_getRepairtimeNodesV3_changelog tables stores the requests and responses of each getRepairtimeNodesV3 haynes pro API call made, including errors and api timestamps.

---

🔹 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
apiCallTimeInMilliSeconds	INT64	YES	Time taken to complete the API call in milliseconds
context	STRING	YES	Context of the log (e.g., module or feature name)
level	STRING	YES	Log level
year	STRING	YES	year of the API call
month	STRING	YES	month of the API call
day	STRING	YES	day of the API call
documentId	STRING	YES	unique document id in firebase

---

🔸 Struct Columns

request

Column Name	Data Type	Nullable	Description
message	STRING	YES	Description of the request
payload.countryCode	STRING	YES	Country code
payload.identifierValue	STRING	YES	Identifier value
payload.languageCode	STRING	YES	Language code
payload.lookupType	STRING	YES	Look up type
payload.nodeIds	STRING REPEATED	YES	node Ids
payload.repairtimeTypeId	INTEGER	YES	Look up type
timestamp	INT64	YES	Timestamp of the request (in Unix time)

response

Column Name	Data Type	Nullable	Description
message	STRING	YES	Response message
timestamp	INT64	YES	Timestamp of the response (in Unix time)
data.GetRepairtimeNodesV3Result	RECORD	YES	Contains repair time node data
data.GetRepairtimeNodesV3Result.TechnicalData	RECORD	YES	Technical information for repair time nodes
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3	RECORD REPEATED	YES	List of extended repair time node entries
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.awNumber	STRING	YES	AW number (assembly work number)
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.description	STRING	YES	Description of the repair time node
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.genarts	STRING	YES	Genarts (possibly generic article info)
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.hasInfoGroups	BOOLEAN	YES	Whether the node contains information groups
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.hasSubnodes	BOOLEAN	YES	Indicates if the node has subnodes
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.id	STRING	YES	Unique identifier for the node
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.jobType	STRING	YES	Type of job represented by the node
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.order	INTEGER	YES	Order or sequence of the node
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.status	RECORD	YES	Status information for the node
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.status.statusCode	INTEGER	YES	Status code representing the node state
data.GetRepairtimeNodesV3Result.TechnicalData.ExtRepairtimeNodeV3.value	INTEGER	YES	Value associated with the node

timestamp

Column Name	Data Type	Nullable	Description
seconds	INT64	YES	Seconds since Unix epoch
nanoseconds	INT64	YES	Nanoseconds part of the timestamp

error

Column Name	Data Type	Nullable	Description
data	STRING	YES	Additional error data
message	STRING	YES	Error message
name	STRING	YES	Name/type of the error
stack	STRING	YES	Stack trace of the error
timestamp	TIMESTAMP	YES	Timestamp when the error occurred

---