DBD
Tables (5)
BookLibraries
- isbn — CHAR(13)
- library_id — INT
- availability — BOOLEAN
Books
- isbn — CHAR(13)
- book_title — VARCHAR(255) — NOT NULL
- author — VARCHAR(255) — NOT NULL
- publisher — VARCHAR(255) — NOT NULL
- publication_year — INT — NOT NULL
- genre — VARCHAR(50)
- cover_image — VARCHAR(255)
Libraries
- library_id — INTEGER
- library_name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- homepage — VARCHAR(255)
Reviews
- isbn — CHAR(13)
- user_id — VARCHAR(50)
- review_title — VARCHAR(255) — NOT NULL
- body — TEXT — NOT NULL
- rating — INT
- likes — INT
- created_at — DATETIME
Users
- user_id — VARCHAR(50)
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL