Database schema includes "books" table (title, author, ISBN, quantity) and "members" table (name, email, membership_id).PASS
docs/schema.sql:
CREATE TABLE book (
id INTEGER NOT NULL,
title VARCHAR(255) NOT NULL,
author VARCHAR(255) NOT NULL,
isbn VARCHAR(13) NOT NULL UNIQUE,
total_copies INTEGER DEFAULT 0,
-- ... other columns ...
PRIMARY KEY (id)
);
CREATE TABLE user (
id INTEGER NOT NULL,
full_name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL UNIQUE,
-- ... other columns ...
PRIMARY KEY (id)
);
The `book` table includes `title`, `author`, `isbn`, and `total_copies` (quantity). The `user` table (representing members) includes `full_name` (name) and `email`. The primary key `id` serves as the `membership_id`.docs/schema.sql