82 lines
2.7 KiB
Markdown
82 lines
2.7 KiB
Markdown
# Project Name
|
|
|
|
## Description
|
|
|
|
This project is a webpage that simplifies management of parentsday at our school.
|
|
|
|
## Installation
|
|
|
|
To install this project, follow these steps:
|
|
|
|
1. TODO
|
|
|
|
## Setup
|
|
|
|
to insert teachers use:
|
|
|
|
```sql
|
|
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:
|
|
|
|
```sql
|
|
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:
|
|
|
|
```sql
|
|
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:
|
|
|
|
1. ...
|
|
2. ...
|
|
3. ...
|
|
|
|
## Contributing
|
|
|
|
If you would like to contribute to this project, please follow these guidelines:
|
|
|
|
1. Fork the repository.
|
|
2. Create a new branch.
|
|
3. ...
|
|
4. Submit a pull request.
|
|
|
|
## License
|
|
|
|
This project is licensed under the [MIT License](LICENSE).
|
|
|
|
## Contact
|
|
|
|
For any questions or inquiries, please contact us at [franz.dietrich@uhlandshoehe.de](mailto:franz.dietrich@uhlandshoehe.de).
|