A dynamic project selection system where students can rank their preferences for different time slots.

• Dynamic Data Management: Timeslots and projects are stored in SQLite database
• Student Interface: Drag-and-drop interface for ranking project preferences
• Admin Panel: Web-based interface for managing timeslots, projects, and viewing responses
• Data Export: CSV export of student responses
• Responsive Design: Works on desktop and mobile devices

├── backend/
│   └── index.ts          # Main backend with API routes and admin panel
├── schueler.html         # Student-facing form (dynamically loads data)
└── README.md            # This file

• Visit the main page to fill out project preferences
• Enter your name and drag projects to rank them for each timeslot
• Submit to save responses to database

• Visit /admin to manage the system
• Add/edit/deactivate timeslots and projects
• View all student responses
• Export responses as CSV

• GET / - Student form
• GET /api/timeslots - Get all active timeslots with projects
• POST /api/responses - Submit student responses

• GET /admin - Admin panel interface
• GET /api/debug/data - View all database data
• GET /api/debug/reset - Reset database (development only)
• POST /api/admin/timeslots - Add new timeslot
• POST /api/admin/projects - Add new project
• PUT /api/admin/timeslots/:id - Update timeslot
• PUT /api/admin/projects/:id - Update project
• DELETE /api/admin/timeslots/:id - Delete timeslot
• DELETE /api/admin/projects/:id - Delete project
• GET /api/admin/export-csv - Export responses as CSV

• id - Primary key
• title - Display title (e.g., "1. Dienstag 9:00-10:30 Uhr")
• time_description - Time description
• order_index - Display order
• active - Whether timeslot is active
• created_at - Creation timestamp

• id - Primary key
• timeslot_id - Foreign key to timeslots
• project_name - Project name
• project_description - Optional description
• active - Whether project is active
• created_at - Creation timestamp

• id - Primary key
• student_name - Student's name
• timeslot_id - Foreign key to timeslots
• first_choice - First preference
• second_choice - Second preference
• third_choice - Third preference
• submitted_at - Submission timestamp

The system initializes with:

• 3 timeslots (Tuesday morning sessions)
• 8 projects (Projekt A through H) for each timeslot

You can customize the system by:

1. Using the admin panel to add/modify timeslots and projects
2. Modifying the CSS in schueler.html for styling changes
3. Updating the database schema in backend/index.ts for additional fields

To reset the database during development:

GET /api/debug/reset

This will drop all tables and recreate them with default data.