Library Management System

Tables (6)

Book (Untitled)

  • book_id (Key) — int — Primary key — NOT NULL
  • title (Field) — string
  • author (Field2) — string
  • publisher (Field3) — string
  • total_copies (Field4) — int
  • remaining_copies (Field5) — int
  • bookshelf_id (Key2) — int — Foreign key → BookShelf.bookshelf_id — NOT NULL
  • librarian_id (Key3) — int — Foreign key → Librarian.librarian_id — NOT NULL

BookShelf (Untitled6)

  • bookshelf_id (Key) — int — Primary key — NOT NULL
  • category (Field) — stirng
  • num_books (Field2) — int
  • room_id (Key2) — int — Foreign key → Room.room_id — NOT NULL

Book_Loan (Untitled4)

  • loan_id (Key) — int — Primary key — NOT NULL
  • loan_date (Field) — Date
  • return_date (Field2) — Date
  • book_id (Key2) — int — Foreign key → Book.book_id — NOT NULL
  • user_id (Key3) — int — Foreign key → User.user_id — NOT NULL

Librarian (Untitled2)

  • librarian_id (Key) — int — Primary key — NOT NULL
  • name (Field) — string
  • phone (Field2) — string
  • email (Field3) — string
  • room_id (Key2) — int — Foreign key → Room.room_id — NOT NULL

Room (Untitled5)

  • room_id (Key) — int — Primary key — NOT NULL
  • room_name (Field) — string
  • librarian_id (Key2) — int — Foreign key → Librarian.librarian_id — NOT NULL

User (Untitled3)

  • user_id (Key) — int — Primary key — NOT NULL
  • name (Field) — string
  • email (Field2) — string
  • phone (Field3) — string