ㅇㅇ

Tables (6)

book

  • book_id — INT
  • title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • publisher — VARCHAR(120) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • librarian_id — INT — Foreign key → librarian.librarian_id — NOT NULL
  • bookshelf_id — INT — Foreign key → bookshelf.bookshelf_id
  • total_copies — INT — NOT NULL
  • remaining_copies — INT — NOT NULL

book_loan

  • loan_id — INT
  • book_id — INT — Foreign key → book.book_id — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • loan_date — DATE — NOT NULL
  • return_date — DATE

bookshelf

  • bookshelf_id — INT
  • room_id — INT — Foreign key → room.room_id — NOT NULL
  • shelf_number — INT — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • num_books — INT — NOT NULL

librarian

  • librarian_id — INT
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(120) — NOT NULL
  • work_room_id — INT — Foreign key → room.room_id — NOT NULL

room

  • room_id — INT
  • room_name — VARCHAR(100) — NOT NULL
  • manager_librarian_id — INT — Foreign key → librarian.librarian_id

user

  • user_id — INT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(120) — NOT NULL
  • phone — VARCHAR(20)