This is a website dedicated to seamless school function through the efficient management of school equipment and facilities, used by both students and administrators.
- Create a basic website with the following features:
- A database
- A homepage
- A login or registration page that redirects into homepage
- Create a basic database with the following features:
- A user table with the following:
- Password (not in plain text!)
- Name
- Section (to be approved by admin)
- An equipment table
- A facilities table
- A booking table
- A user table with the following:
- The homepage should have the following features:
- A search bar for equipment, facilities, and people
- A "welcome" with your LRN and the class you're part of
- A "recently booked" section
- When borrowing, it should have the options:
- What to borrow?
- What range of time to borrow? Display calendar here
- Who will borrow? Yourself only by default, add people from same section or other sections (has to be approved by the others, unless it's the whole section and you're the president)
- Who will be concerned? Each facility or equipment has at least one person concerned
- Clone the repository
- Install XAMPP or another equivalent software to use MySQL
- Load the project dependencies with
npm install
- Create a table in MySQL, then in a root
.env
file create aDATABASE_URL
containing the database connection string (more on Prisma docs) - Push+Generate Prisma with
npx prisma migrate
- Run the project with
npm run dev