joe_pool_is
Well-known member
I am not a database designer, so hopefully someone here can tell me how to set up what I need.
The protocol is called J1939 and is a network protocol for industrial machines.
Individual signals called SPNs carry information about specific parameters (temperature, pressure, rate). Most of these are either 1 or 2 bytes in length, but some are only a couple of bits.
The j1939 protocol sends information in protocol groups called PGNs that group together the SPNs of related items, so the number of SPNs in a PGN varies. Though the PGN groups have similar structures, they vary in length, depending on the SPNs contained in the group.
My database contains a table for the SPNs, but I need a table for the PGNs.
How can I design a flexible PGN table?
The protocol is called J1939 and is a network protocol for industrial machines.
Individual signals called SPNs carry information about specific parameters (temperature, pressure, rate). Most of these are either 1 or 2 bytes in length, but some are only a couple of bits.
The j1939 protocol sends information in protocol groups called PGNs that group together the SPNs of related items, so the number of SPNs in a PGN varies. Though the PGN groups have similar structures, they vary in length, depending on the SPNs contained in the group.
My database contains a table for the SPNs, but I need a table for the PGNs.
How can I design a flexible PGN table?