Hello @neal-chambers
Regarding your below query
m having a hard time understanding how attributes are created and stored in the db.
Check the below link for the reference of how to create attributes in Bagisto
https://docs.bagisto.com/2.3.0/attribute/
And data save inside the attributes table with the below columns as shown in the image below
attributes_table.png
Warm Regards
Team Bagisto