Auction website built with Node, Express and EJS. Built with heavy focus on stored functions/procedures and roles. Two database versions implemented: PostgreSQL and Oracle.
Roles: admins and users.
Admins Features
- create/edit users
- configure global auction parameters
Users Features (Seller/Buyers)
- create/bid/close auctions
- review as seller/buyer
List of Stored Functions:
- getMinBid
- getActiveAuctions
- getAuctionBids
- getSellerHistory
- getBuyerHistory
- getLoginUser
- getAuctionParameters
- getUsers
- getUser
- getActiveCategories
- getActiveSubCategories
- getSubCategories
- getAuctionInfo
- getUserPhones
List of Stored Procedures:
- createUser
- updateUser
- createAuction
- createBid
- createAuctionParameter
- updateSellerReview
- updateBuyerReview
- updateClosedAuctions
- createUserPhone