USERS

-----------------------------------

id (PK)

email

full_name

avatar_url

role

created_at

BOOKS

-----------------------------------

id (PK)

isbn

title

author

category_id (FK)

cover_url

description

total_copies

available_copies

published_year

BORROW_RECORDS

-----------------------------------

id (PK)

user_id (FK)

book_id (FK)

borrow_date

due_date

return_date

status

created_at