Project Name
Description
This project is a webpage that simplifies management of parentsday at our school.
Installation
To install this project, follow these steps:
- TODO
Setup
to insert teachers use:
insert into teachers (ansprache, last_name, subject_id) values ('Frau', 'Bücher', 2);
insert into teachers (ansprache, last_name, subject_id) values ('Frau', 'Klemm', 2);
insert into teachers (ansprache, last_name, subject_id) values ('Frau', 'Vietzen/Pfab', 2);
insert into teachers (ansprache, last_name, subject_id) values ('Frau', 'Bärtle', 2);
insert into teachers (ansprache, last_name, subject_id) values ('Frau', 'Wörner', 2);
to make a teacher available in the current year:
insert into teacher_dates values (1,3);
insert into teacher_dates values (2,3);
insert into teacher_dates values (3,3);
insert into teacher_dates values (4,3);
insert into teacher_dates values (5,3);
insert into teacher_dates values (7,3);
insert into teacher_dates values (12,3);
insert into teacher_dates values (8,3);
insert into teacher_dates values (9,3);
insert into teacher_dates values (10,3);
insert into teacher_dates values (11,3);
insert into teacher_dates values (13,3);
insert into teacher_dates values (14,3);
insert into teacher_dates values (15,3);
insert into teacher_dates values (16,3);
to generate slots use:
insert into appointment_slots (start_time, end_time, date_id) values ('2023-02-28 14:00:00', '2023-02-28 14:15:00', 3);
insert into appointment_slots (start_time, end_time, date_id) values ('2023-02-28 14:15:00', '2023-02-28 14:30:00', 3);
insert into appointment_slots (start_time, end_time, date_id) values ('2023-02-28 14:30:00', '2023-02-28 14:45:00', 3);
insert into appointment_slots (start_time, end_time, date_id) values ('2023-02-28 14:45:00', '2023-02-28 15:00:00', 3);
insert into appointment_slots (start_time, end_time, date_id) values ('2023-02-28 15:15:00', '2023-02-28 15:30:00', 3);
insert into appointment_slots (start_time, end_time, date_id) values ('2023-02-28 15:30:00', '2023-02-28 15:45:00', 3);
insert into appointment_slots (start_time, end_time, date_id) values ('2023-02-28 15:45:00', '2023-02-28 16:00:00', 3);
insert into appointment_slots (start_time, end_time, date_id) values ('2023-02-28 16:00:00', '2023-02-28 16:15:00', 3);
Usage
To use this project, follow these steps:
- ...
- ...
- ...
Contributing
If you would like to contribute to this project, please follow these guidelines:
- Fork the repository.
- Create a new branch.
- ...
- Submit a pull request.
License
This project is licensed under the MIT License.
Contact
For any questions or inquiries, please contact us at franz.dietrich@uhlandshoehe.de.