A couple people have asked me about the book tracking base I use, so this is a slightly simplified version of it, with some example data filled in to show how it works.
The main fields I track are Title, Author, Series, Genre, Pages, Status, Rating, Release Date, Read Date, and Notes. I also track protagonist gender/sexuality and type of romance, which I’ll explain in more detail further down. Add, modify, or delete fields as you like.
Tables included are Books, Authors, and Series. Authors and Series only have one view and should be fairly self-explanatory, but Books has a whole bunch of views, as explained below.