How to organize the database

advertisements

I want to make a website where I start writing books. I want to build a function to add a chapter to a book.

I already made the database and the possibility to create a book. But I don't know how to organise the database. I want to be able to add chapters to a book. How can I do this in MySQL?


You can add a table named chapter with columns:

id INT 11 PK AI
number INT 11
title VARCHAR(255)
text TEXT
book_id INT 11

Book_id will be a foreign key from your book table. This way you can make new chapters for the books you want, the books_id indicates which book it's from, the title well that's obvious, text also obvious and the number would be the chapter number.