joe_pool_is Posted October 31, 2005 Posted October 31, 2005 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? Quote Avoid Sears Home Improvement
joe_pool_is Posted October 31, 2005 Author Posted October 31, 2005 documentation Attachment 45_SAEj1939-71.PDF has 45 pages extracted from SAEj1939-71.PDF, showing the documentation of some SPNs and PGNs.45_saej1939-71.pdf Quote Avoid Sears Home Improvement
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.