Skip to content

Zalake/SmartParking

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Smart Parking

Get the availablity status of parking lots online and save your fuel!

Prerequisites

Software

Hardware

  • Nodemcu v2
  • RFID reader & tags

Installing

Install dependencies using npm install in server directory.

Database Schema

Schema

Triggers for schema

DELIMITER |
CREATE TRIGGER INC 
  AFTER INSERT ON INFO 
    FOR EACH ROW
    BEGIN
    UPDATE STAT 
      SET OCCUPIED_COUNT = OCCUPIED_COUNT + 1
      WHERE PARKINGID = PID;
    END;
|
DELIMITER ;
DELIMITER |
CREATE TRIGGER DEC 
  AFTER UPDATE ON INFO 
    FOR EACH ROW
    BEGIN
    UPDATE STAT 
      SET OCCUPIED_COUNT = OCCUPIED_COUNT - 1
      WHERE PARKINGID = PID;
    END;
|
DELIMITER ;

Screenshot

Screenshot

License

This project is licensed under the MIT License - see the License

About

Park Efficiently!

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages