UIUC RENTER
There are many instances where on campus students need to use a certain tool/item for short amounts of time. Rather than buying it outright, Renter allows the users to utilize the resources in their community by renting out items for short term use. This allows our target audience (college students) who most likely have a tight budget to save some money. Users can sort, search, and filter by the items they need, how far away they are, and more. Renter makes it simple and quick to rent/lend while building a supportive community along the way.
Duration
aug 2019 – dec 2019 (4 mo)
Tools
sleek db
cpanel
wordpress
Skills
ux research, prototyping, web design, sql, php, html, css, js
Team
isaac adorno, will bauer, austin bi
Database Design
Data Schema
We have two databases: a mySQL database and a MongoDB database
In our SQL database we included 6 tables:
- Category: name
- Items: cost, description, item_name, photo, Category, Owner
- Loans: rented_date, returned_date, Owner, Renter, User, Item
- Owner: instructions, owner_bio, User
- Rentee: rentee_rating, User
- User: city, full_name, latitude, longitude, password, username, phone_number
In our noSQL database (SleekDB), we stored information about the history of user interactions:
Relations: owner_id, renter_id, item_id, rented_date, returned_date
Our data was populated by us and our friends by creating accounts and adding and loaning items using the site’s CRUD functions.
ER Diagram and Schema
Information Architecture
Poster Proposal
Website Designs
