I have a number of "clients" which re****t with a string
"client_id,client_model,0001001001", when the third part is a binary
string containing client's status. Each client model can have various
status message length and interpretation.
For each of the locations in the status message, stands it's
description and it's "im****tance level".
Example:
For model A:
Bit location: 0 1 2 3
Description: "General alarm" "Error no1" "Error no2" "Unit accessed"
Im****tance: "Critical" "Major" "Minor" "None"
For device B:
Bit location: 0 1 2
Description: "General alarm" "Error no1" "Unit accessed"
Im****tance: "Critical" "Major" "None"
What will be the best way to store this data into the database?
Any help will be appreciated.