Design a scalable data acquisition service to support streaming of time series data of energy consumed by 100s of machines on a factory floor, aggregated every minute. The payload of the messages will be less than 1KB. The data store must store energy consumed by each machine for every minute of operation.

Please draw the architecture of an ingestion system using MQTT for writing this data to a relational database? How would the table/s look like at the Relational DB end?