crebugs-bagbagbugbug-assignment2
Tables (6)
Book
- book id (book_id) — INTEGER — Primary key — NOT NULL
- title — STRING
- author — STRING
- publisher — STRING
- category — STRING
- total copies (total_copies) — INTEGER
- remaining copies (remaining_copies) — INTEGER
- Key (bookshelf_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
Librarian
- librarian id (librarian_id) — INTEGER — Primary key — NOT NULL
- name — STRING
- phone — STRING
- email — STRING
Untitled (Room)
- Key (room_id) — INTEGER — Primary key — NOT NULL
- Field (room_name) — STRING
- librarian id (librarian_id) — INTEGER — Foreign key → Librarian.librarian id — NOT NULL
Untitled (BookShelf)
- Key (bookshelf_id) — INTEGER — Primary key — NOT NULL
- Field (category) — STRING
- Field (num_books) — INTEGER
- Key (room_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
Untitled4 (BookLoan)
- Key (loan_id) — INTEGER — Primary key — NOT NULL
- Field (loan_date) — DATETIME
- Field (return_date) — DATETIME
- book id (book_id) — INTEGER — Foreign key → Book.book id — NOT NULL
- user id (user_id) — INTEGER — Foreign key → User.user id — NOT NULL
User
- user id (user_id) — INTEGER — Primary key — NOT NULL
- Field (name) — STRING
- Field (email) — STRING
- Field (phone) — STRING