RFID2DB

RFID2DB

Location

deepharbor/code/utilities/RFID2DB

Purpose

This is a stand-alone service that listens for events from the RFID board like this. It uses the uhppoted to listen on door events and record them in the database in the member_access_log table.

The service records every event it gets from the board, including attempts to open the doors using unregistered fobs.

Interaction

This service runs continuously without any interaction from any other service.

Database

The v_member_access_log view is used to map, when possible, the fob event to a member. The view will return the identity information about the member (e.g. first and last name), the timestamp of the event, which door was accessed, and whether that attempt was successful.