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