|
Changing the structure of any calibre table can, and often does, break something. A trivial example: anyone who does a "select *" will have a broken query.
You can add tables that link back to calibre ids without breaking anything. However, the linkage might break if calibre changes the id of something, which can happen. For example, merging tags will delete some ids. Changing case can change ids.
You can probably get something to work, but I suspect it will be fragile.
Some people use links in notes to open other applications where they keep their structured data. Others use structured HTML that applications can parse and grab the info they want.
|