This is a ticketing platform demo: events happen at venues, and customers buy tickets. Everything is stored in a SQL Server database.
You can view upcoming events and venues, see recent ticket sales, add a new event, sell a ticket (booking), or import a list of events. One screen, one database.
Concerts, games, shows — each at a venue with a date.
| Event | Venue | Date | Status |
|---|
Each event with total tickets sold and revenue (Event ↔ Ticket relationship, aggregated in the API with JOIN + GROUP BY).
| Event | Venue | Date | Tickets sold | Revenue |
|---|
| Customer | Qty | Total |
|---|
Where events take place.
| Name | City | Capacity |
|---|
Ticket sales (event, customer, quantity, total).
| Event | Customer | Qty | Total |
|---|
Paste a JSON list of events (each: venueId 1–3, title, eventDate). Click the button to add them to the database.
—
Data: SQL Server database with tables Venues, Events, Tickets. Node.js API uses T-SQL. Docker runs SQL Server and the API.