Create book db tables - Githubissues

briankoser / kodex-aspnetcore

Koser family site, written in ASP.NET Core MVC

MIT License

1 stars 0 forks source link

Create book db tables #120

Open briankoser opened 5 years ago

briankoser commented 5 years ago

[x] Book (1:M to Post, M:1 to Book_BookTags)
[x] BookReview
[x] BookTag (M:1 to Book_BookTags)
[x] Book_BookTag (linking table between Book and BookTags)
[ ] Book_User (linking table between Book and User)

Book_User_BookUserTag? (better name)

briankoser commented 5 years ago

Tags on books:

genre
series
372 pages
own-paper/used to own paper/own audio/own ebook
hugo nominee
hugo winner
series
short story collection

Tags on book-users will be

to read/read/not reading-not interested/not reading - summary was sufficient/did not finish
best of year published
did not finish {year}/first read {year}/read {year}/new authors read {year}
hundreds
on deck
should-have-been-a-short-story
to-reread
watched-the-movie

Questions

Store {year} tags some other way?
How to store books read by multiple people or eg want to read with kids?