ㅇㅇ
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)