Logs_Haynes_GetMaintenanceSystemsV5 Tables

The logs_haynes_getMaintenanceSystemsV5_latest and logs_haynes_getMaintenanceSystemsV5_changelog tables stores the requests and responses of each getMaintenanceSystemsV5` 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.payload	STRING	YES	Payload data passed in the request
payload.countryCode	STRING	YES	Country code
payload.identifierValue	STRING	YES	Identifier used for lookup (e.g., VIN)
payload.includeServiceTimes	BOOL	YES	Whether to include service time details
payload.languageCode	STRING	YES	Language code for the request
payload.lookupType	STRING	YES	Type of lookup being performed
payload.measurementType	STRING	YES	Type of measurement (e.g., km, miles)
payload.repairTypeID	INT64	YES	Repair type ID
payload.vehicleType	STRING	YES	Type of the vehicle
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.GetMaintenanceSystemsV5Result	RECORD	YES	Top-level result object
data.GetMaintenanceSystemsV5Result.TechnicalData	RECORD	YES	Technical data container
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5	RECORD REPEATED	REPEATED	List of maintenance system records
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.id	INTEGER	YES	ID of the maintenance system
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.name	STRING	YES	Name of the maintenance system
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.generalCriteria	RECORD	YES	General criteria container
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.generalCriteria.item	RECORD REPEATED	REPEATED	List of general criteria
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.generalCriteria.item.groupDescription	STRING	YES	Description of the group
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.generalCriteria.item.groupId	INTEGER	YES	Group ID
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.generalCriteria.item.groupCriterias	RECORD REPEATED	REPEATED	List of group criteria
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.generalCriteria.item.groupCriterias.criteriaId	INTEGER	YES	Criteria ID
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.generalCriteria.item.groupCriterias.criteriaLevel	STRING	YES	Level of the criteria
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.generalCriteria.item.groupCriterias.description	STRING	YES	Description of the criteria
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods	RECORD	YES	Maintenance periods container
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods.item	RECORD REPEATED	REPEATED	List of maintenance periods
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods.item.combinable	BOOLEAN	YES	Whether this period is combinable
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods.item.generalCriteria	RECORD	YES	Criteria associated with this period
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods.item.generalCriteria.item	RECORD REPEATED	REPEATED	List of general criteria
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods.item.generalCriteria.item.groupDescription	STRING	YES	Group description
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods.item.generalCriteria.item.groupId	INTEGER	YES	Group ID
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods.item.generalCriteria.item.groupCriterias	RECORD REPEATED	REPEATED	Nested group criteria list
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods.item.generalCriteria.item.groupCriterias.criteriaId	INTEGER	YES	Criteria ID
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods.item.generalCriteria.item.groupCriterias.criteriaLevel	STRING	YES	Criteria level
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.maintenancePeriods.item.generalCriteria.item.groupCriterias.description	STRING	YES	Criteria description
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.times	RECORD	YES	Time-related information
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.times.item	RECORD REPEATED	REPEATED	List of time items
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.times.item.selected	BOOLEAN	YES	Whether the time option is selected
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.times.item.type	STRING	YES	Type of time entry
data.GetMaintenanceSystemsV5Result.TechnicalData.ExtMaintenanceSystemV5.times.item.value	INTEGER	YES	Value for the time entry

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

---