View Single Post
Old 09-26-2025, 06:10 AM   #10
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,917
Karma: 30277294
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Custom column definitions and values are stored in the metadata database (metadata.db), they cannot be edited directly.

The definitions are stored in a table called custom_columns

Click image for larger version

Name:	custom columns.jpg
Views:	13
Size:	401.3 KB
ID:	218286

The values are stored in 'custom_column_n' tables, where 'n' is the row-id in the custom_columns tables

Click image for larger version

Name:	database structure.jpg
Views:	10
Size:	532.8 KB
ID:	218287

Tag like columns such as your "finished" column would also have a 'books_custom_column_n_links' table to associate specific tag like values to specific books.

You add new values to a tag-like custom column by entering it in a book's metadata, once you've done that for one book, you can apply it to other books.

BR
BetterRed is online now   Reply With Quote