table weapons
wid primary key not null
wname
notes

table stores
sid primary key not null
sname
notes

table weapon_inventory
iid primary key not null
sid
wid
qty