Zentrum für Sport, Gesundheit und Wohlbefinden

Kurse, Workshops & Freizeiten

WS Test, Workshop

Mo., 23.12.24
|
12:00 - 13:00
|
Halle 3 KLüüü
|
Kaiserslautern
|
Dieser Kurstermin wurde abgesagt.
ab 10.00€
Gebucht: 1 / 3
1
2

TEST, Sportprogramm

Mo., 23.12.24
|
12:09 - 13:22
|
Geb01 R019 KL
|
Kaiserslautern
Gebucht: 0 / 12
0
12

TEST, Sportprogramm

Mo., 23.12.24
|
12:09 - 13:22
|
Geb01 R019 KL
|
Kaiserslautern
Gebucht: 0 / 12
0
12

WS Test, Workshop

Mo., 23.12.24
|
12:00 - 13:00
|
Halle 3 KLüüü
|
Kaiserslautern
|
Dieser Kurstermin wurde abgesagt.
ab 10.00€
Gebucht: 1 / 3
1
2
HTTP Request
method 
GET
scheme 
https
host 
zsgwapp-dev.rz.rptu.de
port 
443
base 
/
path 
courses/overview
query 
tab=camp_
language 
de
Routing Result
path 
courses/overview
route 
courses/overview
handler 
course.get_overview
name 
course.overview
options 
GET
controller 
App\Controllers\CourseController
method 
get_overview
parameters
HTTP Response
class 
RHRK\Framework\Responses\ViewResponse
status code 
200
data length 
96391
view 
course/overview.twig
 
Set-Cookie: PHPSESSID=sqmgtcmjbm4m2g0l0v16lgt2o2; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Execution Times
middleware before 
  121.32 ms
controller method 
   14.39 ms
middleware after 
    0.05 ms
view rendering 
   99.82 ms
total 
  261.18 ms
 
array(34) {
  ["REDIRECT_HTTPS"] string(2) "on"
  ["REDIRECT_STATUS"] string(3) "200"
  ["HTTPS"] string(2) "on"
  ["HTTP_HOST"] string(22) "zsgwapp-dev.rz.rptu.de"
  ["HTTP_X_FORWARDED_PROTO"] string(5) "https"
  ["HTTP_CONNECTION"] string(5) "close"
  ["HTTP_ACCEPT"] string(3) "*/*"
  ["HTTP_USER_AGENT"] string(103) "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ["HTTP_ACCEPT_ENCODING"] string(23) "gzip, br, zstd, deflate"
  ["PATH"] string(60) "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  ["SERVER_SIGNATURE"] string(84) "<address>Apache/2.4.62 (Debian) Server at zsgwapp-dev.rz.rptu.de Port 443</address>
"
  ["SERVER_SOFTWARE"] string(22) "Apache/2.4.62 (Debian)"
  ["SERVER_NAME"] string(22) "zsgwapp-dev.rz.rptu.de"
  ["SERVER_ADDR"] string(37) "2001:638:208:ef61:2405:94ff:fe38:cbd5"
  ["SERVER_PORT"] string(3) "443"
  ["REMOTE_ADDR"] string(11) "3.15.240.65"
  ["DOCUMENT_ROOT"] string(10) "/srv/empty"
  ["REQUEST_SCHEME"] string(5) "https"
  ["CONTEXT_PREFIX"] string(1) "/"
  ["CONTEXT_DOCUMENT_ROOT"] string(35) "/srv/www/www-zsgwapp-dev/data/http/"
  ["SERVER_ADMIN"] string(17) "www-adm@uni-kl.de"
  ["SCRIPT_FILENAME"] string(44) "/srv/www/www-zsgwapp-dev/data/http/index.php"
  ["REMOTE_PORT"] string(5) "53702"
  ["REDIRECT_URL"] string(17) "/courses/overview"
  ["REDIRECT_QUERY_STRING"] string(9) "tab=camp_"
  ["GATEWAY_INTERFACE"] string(7) "CGI/1.1"
  ["SERVER_PROTOCOL"] string(8) "HTTP/1.1"
  ["REQUEST_METHOD"] string(3) "GET"
  ["QUERY_STRING"] string(9) "tab=camp_"
  ["REQUEST_URI"] string(27) "/courses/overview?tab=camp_"
  ["SCRIPT_NAME"] string(10) "/index.php"
  ["PHP_SELF"] string(10) "/index.php"
  ["REQUEST_TIME_FLOAT"] float(1734632338.940801)
  ["REQUEST_TIME"] int(1734632338)
}

array(1) {
  ["tab"] string(5) "camp_"
}

array(0) {}

array(0) {}

array(0) {}
Global Middleware 9 
RHRK\Framework\Middleware\ErrorHandler
 
    0.01 ms
 
    0.00 ms
 
RHRK\Framework\Middleware\OutputBuffer
 
    0.00 ms
 
    0.01 ms
 
RHRK\Framework\Middleware\ExecuteProviders
 
  108.42 ms
 
    0.00 ms
 
RHRK\Framework\Middleware\Maintenance
 
    0.01 ms
 
    0.00 ms
 
RHRK\Framework\Middleware\SanitizeInput
 
    0.01 ms
 
    0.00 ms
 
RHRK\Framework\Middleware\Validation
 
    0.01 ms
 
    0.00 ms
 
RHRK\Framework\Middleware\Routing
 
    4.66 ms
 
    0.00 ms
 
App\Middleware\DatabaseInitialisation
 
    2.95 ms
 
    0.00 ms
 
App\Middleware\RequiredApproval
 
    0.01 ms
 
    0.00 ms
Route Middleware 0
Normal Providers 10 
App\Providers\DatabaseProvider
 
   22.16 ms
 
App\Providers\AuthProvider
 
    1.10 ms
 
App\Providers\FormProvider
 
    3.23 ms
 
App\Providers\LogProvider
 
    0.36 ms
 
App\Providers\TwigProvider
 
   12.20 ms
 
App\Providers\ValidatorProvider
 
    0.36 ms
 
App\Providers\LanguageProvider
 
    0.90 ms
 
App\Providers\TemplateToolProvider
 
   59.01 ms
 
App\Providers\MailProvider
 
    2.93 ms
 
App\Providers\SanitizeProvider
 
    1.25 ms
Deferred Providers 0
Before Twig 68 
CREATE TABLE IF NOT EXISTS `log` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NULL,
    `level` VARCHAR(50) NOT NULL,
    `message` TEXT NOT NULL,
    `data` TEXT NULL,
    `method` VARCHAR(50) NULL,
    `url` TEXT NULL,
    `file` TEXT NULL,
    `line` INT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.34 ms
 
CREATE TABLE IF NOT EXISTS `images` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `type` VARCHAR(100) NOT NULL,
    `name` VARCHAR(100) NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.25 ms
 
CREATE TABLE IF NOT EXISTS `user_codes` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `code_type_id` BIGINT UNSIGNED NOT NULL,
    `code` VARCHAR(255) NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.15 ms
 
CREATE TABLE IF NOT EXISTS `statuses` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `name` VARCHAR(255) NOT NULL UNIQUE,
    `name_de` VARCHAR(100) NOT NULL,
    `name_en` VARCHAR(100) NOT NULL,
    `verification_type` VARCHAR(50) NOT NULL,
    `visibility` VARCHAR(50) NOT NULL,
    `info_de` TEXT NULL,
    `info_en` TEXT NULL,
    `document_de` VARCHAR(255) NULL,
    `document_en` VARCHAR(255) NULL,
    `notes` TEXT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL,
    `deleted_at` TIMESTAMP NULL
);
 
    0.16 ms
 
CREATE TABLE IF NOT EXISTS `users_statuses` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `status_id` BIGINT UNSIGNED NOT NULL,
    `status_verified` BOOLEAN NULL,
    `verification_expiration` DATE NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.19 ms
 
CREATE TABLE IF NOT EXISTS `code_types` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `name` VARCHAR(100) NOT NULL UNIQUE,
    `description` VARCHAR(255) NULL,
    `expires_after` VARCHAR(50) NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.18 ms
 
CREATE TABLE IF NOT EXISTS `verification_documents` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_status_id` BIGINT UNSIGNED NOT NULL,
    `display_name` VARCHAR(255) NOT NULL,
    `type` VARCHAR(100) NOT NULL,
    `name` VARCHAR(100) NOT NULL,
    `status` VARCHAR(50) NOT NULL,
    `comment` TEXT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.15 ms
 
CREATE TABLE IF NOT EXISTS `consent_forms` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `display_name` VARCHAR(255) NOT NULL,
    `type` VARCHAR(100) NOT NULL,
    `name` VARCHAR(100) NOT NULL,
    `status` VARCHAR(50) NOT NULL,
    `comment` TEXT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.13 ms
 
CREATE TABLE IF NOT EXISTS `price_cats` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `name` VARCHAR(100) NOT NULL UNIQUE,
    `name_de` VARCHAR(100) NOT NULL,
    `name_en` VARCHAR(100) NOT NULL,
    `description` TEXT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL,
    `deleted_at` TIMESTAMP NULL
);
 
    0.15 ms
 
CREATE TABLE IF NOT EXISTS `status_price_cats` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `status_id` BIGINT UNSIGNED NOT NULL UNIQUE,
    `price_cat_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.12 ms
 
CREATE TABLE IF NOT EXISTS `cards` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `name_de` VARCHAR(100) NOT NULL,
    `name_en` VARCHAR(100) NOT NULL,
    `exclude_guests` BOOLEAN NOT NULL,
    `description_de` TEXT NULL,
    `description_en` TEXT NULL,
    `min_duration` VARCHAR(50) NULL,
    `min_age` INT NULL,
    `max_age` INT NULL,
    `subscription` BOOLEAN NOT NULL,
    `require_group` BIGINT(20) NULL,
    `usable` INT NULL,
    `dead_time` INT NULL,
    `creates_qr` INT NOT NULL,
    `amount_limit` INT NULL,
    `active` BOOLEAN NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL,
    `deleted_at` TIMESTAMP NULL
);
 
    0.11 ms
 
CREATE TABLE IF NOT EXISTS `card_groups` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `name_de` VARCHAR(100) NOT NULL,
    `name_en` VARCHAR(100) NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.37 ms
 
CREATE TABLE IF NOT EXISTS `card_group_memberships` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `card_group_id` BIGINT UNSIGNED NOT NULL,
    `card_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.54 ms
 
CREATE TABLE IF NOT EXISTS `card_bookings` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `card_id` BIGINT UNSIGNED NOT NULL,
    `valid_from` DATE NULL,
    `valid_until` DATE NULL,
    `sub_cancelled_at` DATE NULL,
    `usable` INT NULL,
    `purchase_id` BIGINT UNSIGNED NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL,
    `deleted_at` TIMESTAMP NULL
);
 
    0.14 ms
 
CREATE TABLE IF NOT EXISTS `tags` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `name_de` VARCHAR(100) NOT NULL,
    `name_en` VARCHAR(100) NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.11 ms
 
CREATE TABLE IF NOT EXISTS `places` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `name_de` VARCHAR(100) NOT NULL,
    `name_en` VARCHAR(100) NOT NULL,
    `description` TEXT NULL,
    `capacity` INT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.47 ms
 
CREATE TABLE IF NOT EXISTS `course_cards` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `course_id` BIGINT UNSIGNED NOT NULL,
    `card_group_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.16 ms
 
CREATE TABLE IF NOT EXISTS `course_tags` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `tag_id` BIGINT UNSIGNED NOT NULL,
    `course_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.13 ms
 
CREATE TABLE IF NOT EXISTS `course_statuses` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `status_id` BIGINT UNSIGNED NOT NULL,
    `course_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.46 ms
 
CREATE TABLE IF NOT EXISTS `course_dates` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `course_id` BIGINT UNSIGNED NOT NULL,
    `start` DATETIME NOT NULL,
    `end` DATETIME NOT NULL,
    `place_id` BIGINT UNSIGNED NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL,
    `deleted_at` TIMESTAMP NULL
);
 
    0.11 ms
 
CREATE TABLE IF NOT EXISTS `course_date_instructors` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `course_date_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.15 ms
 
CREATE TABLE IF NOT EXISTS `course_bookings` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `course_date_id` BIGINT UNSIGNED NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `status` VARCHAR(100) NULL,
    `purchase_id` BIGINT UNSIGNED NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL,
    `deleted_at` TIMESTAMP NULL
);
 
    0.11 ms
 
CREATE TABLE IF NOT EXISTS `course_options` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `course_id` BIGINT UNSIGNED NOT NULL,
    `type` VARCHAR(50) NOT NULL,
    `prompt_de` TEXT NOT NULL,
    `prompt_en` TEXT NOT NULL,
    `options_de` TEXT NULL,
    `options_en` TEXT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
    0.10 ms
 
CREATE TABLE IF NOT EXISTS `products` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `course_id` BIGINT UNSIGNED NULL,
    `card_id` BIGINT UNSIGNED NULL,
    `kostenstelle` VARCHAR(7) NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `product_prices` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `product_id` BIGINT UNSIGNED NULL,
    `price_cat_id` BIGINT UNSIGNED NOT NULL,
    `taxrate` NUMERIC(15,2) NOT NULL,
    `amount` NUMERIC(15,2) NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `course_booking_options` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `course_booking_id` BIGINT UNSIGNED NOT NULL,
    `course_option_id` BIGINT UNSIGNED NOT NULL,
    `response` TEXT NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `purchases` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `product_price_id` BIGINT UNSIGNED NOT NULL,
    `payment_state` VARCHAR(13) NOT NULL,
    `refund_state` VARCHAR(20) NOT NULL,
    `payment_method` VARCHAR(255) NOT NULL,
    `cancelled_at` DATETIME NULL,
    `note` TEXT NULL,
    `suggested_refund` NUMERIC(15,2) NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `refunds` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `purchase_id` BIGINT UNSIGNED NOT NULL,
    `amount` NUMERIC(15,2) NOT NULL,
    `release_date` DATE NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `users` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `account` VARCHAR(50) NULL,
    `email` VARCHAR(100) NULL,
    `password` VARCHAR(100) NULL,
    `is_guest_account` BOOLEAN NOT NULL,
    `first_name` VARCHAR(100) NULL,
    `last_name` VARCHAR(100) NULL,
    `street` VARCHAR(255) NULL,
    `post_code` VARCHAR(50) NULL,
    `city` VARCHAR(100) NULL,
    `gender` SET("MALE", "FEMALE", "OTHER") NULL,
    `birthday` DATE NULL,
    `phone` VARCHAR(50) NULL,
    `language` VARCHAR(10) NULL,
    `recovery_email` VARCHAR(100) NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL,
    `deleted_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `children_parents` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `parent_id` BIGINT UNSIGNED NOT NULL,
    `child_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `courses` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `template_name` VARCHAR(100) NULL,
    `type` VARCHAR(50) NOT NULL,
    `name_de` VARCHAR(255) NOT NULL,
    `name_en` VARCHAR(255) NOT NULL,
    `min_age` INT NULL,
    `max_age` INT NULL,
    `allowed_genders` VARCHAR(10) NULL,
    `max_participants` INT NULL,
    `visible_from` DATETIME NULL,
    `visible_until` DATETIME NULL,
    `bookable_from` DATETIME NULL,
    `bookable_until` DATETIME NULL,
    `info_de` TEXT NULL,
    `info_en` TEXT NULL,
    `book_text_de` TEXT NULL,
    `book_text_en` TEXT NULL,
    `default_mail_sender_id` BIGINT UNSIGNED NULL,
    `level` VARCHAR(100) NULL,
    `campus` VARCHAR(100) NULL,
    `active` BOOLEAN NOT NULL,
    `registration_type` VARCHAR(50) NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL,
    `deleted_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `email_addresses` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `address` VARCHAR(100) NOT NULL,
    `description` TEXT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `booking_qr_codes` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `booking_id` BIGINT UNSIGNED NOT NULL,
    `hash` VARCHAR(64) NOT NULL,
    `parent_ticket` BOOLEAN NOT NULL,
    `last_used` DATETIME NULL,
    `rand_number` INT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `facilities` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `name_de` VARCHAR(255) NOT NULL,
    `name_en` VARCHAR(255) NOT NULL,
    `max_capacity` INT NOT NULL,
    `description_de` TEXT NULL,
    `description_en` TEXT NULL,
    `explanation_de` TEXT NULL,
    `explanation_en` TEXT NULL,
    `campus` VARCHAR(50) NOT NULL,
    `opening_start` TIME NOT NULL,
    `opening_end` TIME NOT NULL,
    `weekly_quota` INT NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL,
    `deleted_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `timeslots` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `facility_id` BIGINT UNSIGNED NOT NULL,
    `start` DATETIME NOT NULL,
    `capacity` INT NOT NULL,
    `closed` BOOLEAN NOT NULL,
    `comment` TEXT NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `reservations` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `timeslot_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `quotas` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `facility_id` BIGINT UNSIGNED NOT NULL,
    `week` VARCHAR(7) NOT NULL,
    `quota` INT NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `checkins` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `facility_id` BIGINT UNSIGNED NOT NULL,
    `start_time` DATETIME NOT NULL,
    `end_time` DATETIME NOT NULL,
    `parent` BOOLEAN NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `facility_card_groups` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `facility_id` BIGINT UNSIGNED NOT NULL,
    `card_group_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `required_approvals` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `name_de` VARCHAR(255) NOT NULL,
    `name_en` VARCHAR(255) NOT NULL,
    `text_de` TEXT NOT NULL,
    `text_en` TEXT NOT NULL,
    `link_de` VARCHAR(255) NOT NULL,
    `link_en` VARCHAR(255) NOT NULL,
    `accept_text_de` TEXT NOT NULL,
    `accept_text_en` TEXT NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `user_approvals` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `required_approval_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `muttizettels` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `parent_id` BIGINT UNSIGNED NOT NULL,
    `child_id` BIGINT UNSIGNED NOT NULL,
    `parent_phone` VARCHAR(255) NOT NULL,
    `child_phone` VARCHAR(255) NULL,
    `first_name` VARCHAR(255) NULL,
    `last_name` VARCHAR(255) NULL,
    `birthday` DATE NULL,
    `street` VARCHAR(255) NULL,
    `post_code` VARCHAR(255) NULL,
    `city` VARCHAR(255) NULL,
    `phone` VARCHAR(255) NULL,
    `valid_until` DATE NULL,
    `no_supervision` BOOLEAN NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL,
    `deleted_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `admin_qr_codes` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `card_id` BIGINT UNSIGNED NOT NULL,
    `hash` VARCHAR(64) NOT NULL,
    `usable` INT NULL,
    `valid_from` DATETIME NULL,
    `valid_until` DATETIME NULL,
    `user_id` BIGINT UNSIGNED NULL,
    `needs_activation` BOOLEAN NOT NULL,
    `comment` VARCHAR(255) NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `favourites` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `course_id` BIGINT UNSIGNED NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
CREATE TABLE IF NOT EXISTS `parent_requests` (
    `id` SERIAL PRIMARY KEY NOT NULL,
    `requester_id` BIGINT UNSIGNED NOT NULL,
    `requested_id` BIGINT UNSIGNED NOT NULL,
    `child_id` BIGINT UNSIGNED NOT NULL,
    `status` VARCHAR(50) NOT NULL,
    `created_at` TIMESTAMP NULL,
    `updated_at` TIMESTAMP NULL
);
 
     --- ms
 
SELECT * FROM `courses` WHERE template_name is null AND deleted_at IS NULL
 
     --- ms
 
SELECT * FROM `course_dates` WHERE course_id IN (2,6,7,8,9,10) AND deleted_at IS NULL
 
     --- ms
 
SELECT * FROM `course_tags` WHERE course_id IN (2,6,7,8,9,10)
 
     --- ms
 
SELECT * FROM `tags` WHERE id IN (9,15,20,24)
 
     --- ms
 
SELECT * FROM `course_statuses` WHERE course_id IN (2,6,7,8,9,10)
 
     --- ms
 
SELECT * FROM `statuses` WHERE id IN (1,2,3,4,5,6,8,9,10,12,13,11) AND deleted_at IS NULL
 
     --- ms
 
SELECT * FROM `course_cards` WHERE course_id IN (2,6,7,8,9,10)
 
     --- ms
 
SELECT * FROM `card_groups` WHERE id IN (1,2,3)
 
     --- ms
 
SELECT * FROM `statuses` WHERE deleted_at IS NULL
 
     --- ms
 
SELECT * FROM `tags`
 
     --- ms
 
SELECT * FROM `card_groups`
 
     --- ms
 
SELECT * FROM `products` WHERE course_id = 8
 
     --- ms
 
SELECT * FROM `product_prices` WHERE product_id = 300
 
     --- ms
 
SELECT * FROM `products` WHERE course_id = 7
 
     --- ms
 
SELECT * FROM `products` WHERE course_id = 10
 
     --- ms
 
SELECT * FROM `product_prices` WHERE product_id = 301
 
     --- ms
 
SELECT * FROM `products` WHERE course_id = 2
 
     --- ms
 
SELECT * FROM `products` WHERE course_id = 6
 
     --- ms
 
SELECT * FROM `product_prices` WHERE product_id = 299
 
     --- ms
 
SELECT * FROM `products` WHERE course_id = 9
 
     --- ms
 
SELECT * FROM `products` WHERE course_id = 7
 
     --- ms
 
SELECT * FROM `products` WHERE course_id = 2
 
     --- ms
 
SELECT * FROM `products` WHERE course_id = 9
 
     --- ms
During Twig 0

Deprecated: Return type of cklamm\ORM\Model::jsonSerialize() should either be compatible with JsonSerializable::jsonSerialize(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /srv/www/www-zsgwapp-dev/data/include/zsgw/vendor/rhrk-webdev/orm/src/Model.php on line 86

Deprecated: Return type of RHRK\Form\Element::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /srv/www/www-zsgwapp-dev/data/include/zsgw/vendor/rhrk-webdev/form/src/Element.php on line 45

Deprecated: Return type of RHRK\Form\Element::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /srv/www/www-zsgwapp-dev/data/include/zsgw/vendor/rhrk-webdev/form/src/Element.php on line 66

Deprecated: Return type of RHRK\Form\Element::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /srv/www/www-zsgwapp-dev/data/include/zsgw/vendor/rhrk-webdev/form/src/Element.php on line 76

Deprecated: Return type of RHRK\Sanitize\Sanitize::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /srv/www/www-zsgwapp-dev/data/include/zsgw/vendor/rhrk-webdev/sanitize/src/Sanitize.php on line 29

Deprecated: RHRK\Sanitize\Sanitize implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /srv/www/www-zsgwapp-dev/data/include/zsgw/vendor/rhrk-webdev/sanitize/src/Sanitize.php on line 11

Deprecated: Return type of cklamm\ORM\Collection::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /srv/www/www-zsgwapp-dev/data/include/zsgw/vendor/rhrk-webdev/orm/src/Collection.php on line 34

Deprecated: Constant FILTER_SANITIZE_STRIPPED is deprecated in /srv/www/www-zsgwapp-dev/data/include/zsgw/vendor/rhrk-webdev/sanitize/src/Sanitize.php on line 265