JIT
School library system with borrowing rules
Can you create a school library web project, I need the welcome view to be a Login form, and an option to register, in case of an admin Logging in the app sends you to a dashboard that only admins can enter, in case of an Studen logging in the app sends to the public site where the students and admins can enter, the public site is a list of the books avaliable to borrow, the list needs 3 actions, "Details" where the details (like author, year, location in the physical library) are gonna show up, "Borrow" to borrow a book and make it unavaliable to borrow to another students, and "Return" to return that book if you borrowed it and make it avaliable to another students, the max number of borrowed books is 10 per students and you can only borrow it for 2 weeks, if a user have a late book the student cant borrow other books until returned. I need the project to have the following tables: 1. Admins (id, name, email, password, and image) 2. Students (id, name, email, password, image, status) 3. Clasifications (id, name) 4. Books (id, title, author, type, quantity, image and clasification_id as foreign key of Clasification table) and 5. Lends (id, student_id as foreign key of Students and book_id as foreign key of Books, dateAdded, and dateLimit, dateReturn), in case of today date being greater than dateLimit, and no dateReturn existing then the student with that student_id status changes from active to inactive and that student can't borrow other books until all late books are returned, finally I need that the app to delete once a day the records of the table Lends where dateReturn exists.

I'll help you create a school library web project. Let me start by exploring the current directory structure and then build the project step by step.

I'll create a school library web project with React/Node.js and SQLite. Let me start by setting up the project structure:

Write file
Write file
Write file
Write file
Write file
Write file
Write file
Write file
Write file
Write file
Write file
Write file
Write file
Write file
Write file
Updated files
v1