智能化图书管理系统

erDiagram BOOKS { bigint book_id PK "图书ID" varchar isbn UK "ISBN号" varchar title "图书标题" varchar author "作者" varchar publisher "出版社" date publish_date "出版日期" varchar category "分类" decimal price "价格" int stock "库存数量" int available "可借数量" text description "图书简介" } READERS { bigint reader_id PK "读者ID" varchar card_number UK "借书证号" varchar name "姓名" varchar phone "手机号" varchar email "邮箱" date register_date "注册日期" enum status "状态" } BORROW_RECORDS { bigint record_id PK "借阅记录ID" bigint book_id FK "图书ID" bigint reader_id FK "读者ID" date borrow_date "借阅日期" date due_date "应还日期" date return_date "实际归还日期" decimal fine_amount "罚款金额" } CATEGORIES { bigint category_id PK "分类ID" varchar name "分类名称" varchar code "分类代码" bigint parent_id FK "父分类ID" } ADMIN_USERS { bigint admin_id PK "管理员ID" varchar username UK "用户名" varchar name "姓名" enum role "角色" timestamp last_login "最后登录" } RESERVATIONS { bigint reservation_id PK "预约ID" bigint book_id FK "图书ID" bigint reader_id FK "读者ID" datetime reserve_date "预约时间" enum status "状态" } BOOKS ||--o{ BORROW_RECORDS : "has" READERS ||--o{ BORROW_RECORDS : "has" BOOKS ||--o{ RESERVATIONS : "has" READERS ||--o{ RESERVATIONS : "has" CATEGORIES ||--o{ BOOKS : "contains" CATEGORIES ||--o{ CATEGORIES : "parent-child"