Skip to content

Back-end using Node.js with typescript, using fastify, prisma and zod for an application for participant management on in-person events.

Notifications You must be signed in to change notification settings

phfsouza/pass-in-backend

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

pass.in

The pass.in is an application for participant management in in-person events.

The tool allows the organizer to register an event and open a public registration page.

Registered participants can generate a credential for check-in on the day of the event.

The system will scan the participant's credential to allow entry into the event.

Requirements

Functional Requirements

  • The organizer must be able to register a new event;
  • The organizer must be able to view event data;
  • The organizer must be able to view the list of participants;
  • The participant must be able to register for an event;
  • The participant must be able to view their registration badge;
  • The participant must be able to check-in at the event;

Business Rules

  • The participant can only register for an event once;
  • The participant can only register for events with available slots;
  • The participant can only check-in at an event once;

Non-Functional Requirements

  • Event check-in will be done through a QRCode;

API Documentation (Swagger)

For API documentation, you can run the app and find it in the http://localhost:port/docs

Database

In this application, we will use a relational database (SQL). For development environment, we will proceed with SQLite due to its ease of use.

ERD Diagram

ERD Diagram of the database

Database Structure (SQL)

-- CreateTable
CREATE TABLE "events" (
    "id" TEXT NOT NULL PRIMARY KEY,
    "title" TEXT NOT NULL,
    "details" TEXT,
    "slug" TEXT NOT NULL,
    "maximum_attendees" INTEGER
);

-- CreateTable
CREATE TABLE "attendees" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "name" TEXT NOT NULL,
    "email" TEXT NOT NULL,
    "event_id" TEXT NOT NULL,
    "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "attendees_event_id_fkey" FOREIGN KEY ("event_id") REFERENCES "events" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
);

-- CreateTable
CREATE TABLE "check_ins" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "attendeeId" INTEGER NOT NULL,
    CONSTRAINT "check_ins_attendeeId_fkey" FOREIGN KEY ("attendeeId") REFERENCES "attendees" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
);

-- CreateIndex
CREATE UNIQUE INDEX "events_slug_key" ON "events"("slug");

-- CreateIndex
CREATE UNIQUE INDEX "attendees_event_id_email_key" ON "attendees"("event_id", "email");

-- CreateIndex
CREATE UNIQUE INDEX "check_ins_attendeeId_key" ON "check_ins"("attendeeId");

About

Back-end using Node.js with typescript, using fastify, prisma and zod for an application for participant management on in-person events.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published