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