library

Tables (6)

Book

  • book_id — bigint — Primary key — NOT NULL
  • librarian_id — Foreign key → Librarian.librarian_id — NOT NULL
  • bookshelf_id — Foreign key → Bookshelf.bookshelf_id — NOT NULL
  • title — varchar(100)
  • author — varchar(10)
  • publisher
  • category
  • total_copies
  • remaining_copies

Book_Loan

  • loan_id — Primary key — NOT NULL
  • book_id — Foreign key → Book.book_id — NOT NULL
  • user_id — Foreign key → User.user_id — NOT NULL
  • loan_date
  • return_date

Bookshelf

  • bookshelf_id — Primary key — NOT NULL
  • room_id — Foreign key → Room.room_id — NOT NULL
  • category
  • num_books

Librarian

  • librarian_id — Primary key — NOT NULL
  • room_id — Foreign key → Room.room_id — NOT NULL
  • name — NOT NULL
  • phone — NOT NULL
  • email

Room

  • room_id — Primary key — NOT NULL
  • librarian_id — Foreign key → Librarian.librarian_id — NOT NULL
  • room_name

User

  • user_id — Primary key — NOT NULL
  • name
  • email
  • phone