Training Request Form #130

Open
opened 2025-12-22 01:35:11 -06:00 by EagleTrooper · 1 comment
Owner

Some point create a training Request form to move off the Google Form.
It can pull from the "Courses" list to populate which training requests someone wants to pick form

Starting SQL Table

CREATE TABLE `course_requests` (
	`id` INT NOT NULL AUTO_INCREMENT,
	`course_id` INT NOT NULL,
	`requester_id` INT NOT NULL,
	`requested_availablity` TINYTEXT NOT NULL,
	`requested_date` DATETIME NULL,
	`fufilled_by_id` INT NULL DEFAULT NULL,
	`fufilled_date` DATETIME NULL DEFAULT NULL,
	PRIMARY KEY (`id`),
	CONSTRAINT `FK__courses` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
	CONSTRAINT `FK__members` FOREIGN KEY (`requester_id`) REFERENCES `members` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
	CONSTRAINT `FK__members_2` FOREIGN KEY (`fufilled_by_id`) REFERENCES `members` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
	CONSTRAINT `FK4` FOREIGN KEY () REFERENCES `` () ON UPDATE NO ACTION ON DELETE NO ACTION
)
COLLATE='utf8mb4_general_ci'
;

Working to replace this form
https://docs.google.com/spreadsheets/d/1rMXh8fm4V4d_33x8G_42oP9qFX1IM7W3FntiVACEW6Y/edit?gid=444182281#gid=444182281

Some point create a training Request form to move off the Google Form. It can pull from the "Courses" list to populate which training requests someone wants to pick form Starting SQL Table ```sql CREATE TABLE `course_requests` ( `id` INT NOT NULL AUTO_INCREMENT, `course_id` INT NOT NULL, `requester_id` INT NOT NULL, `requested_availablity` TINYTEXT NOT NULL, `requested_date` DATETIME NULL, `fufilled_by_id` INT NULL DEFAULT NULL, `fufilled_date` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`), CONSTRAINT `FK__courses` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `FK__members` FOREIGN KEY (`requester_id`) REFERENCES `members` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `FK__members_2` FOREIGN KEY (`fufilled_by_id`) REFERENCES `members` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `FK4` FOREIGN KEY () REFERENCES `` () ON UPDATE NO ACTION ON DELETE NO ACTION ) COLLATE='utf8mb4_general_ci' ; ``` Working to replace this form https://docs.google.com/spreadsheets/d/1rMXh8fm4V4d_33x8G_42oP9qFX1IM7W3FntiVACEW6Y/edit?gid=444182281#gid=444182281
EagleTrooper added the Kind/Feature
Priority
Low
labels 2025-12-22 01:35:11 -06:00
Ajdj100 added this to the 1.1.0 milestone 2025-12-30 08:22:03 -06:00
Author
Owner

Modified Table a bit. New table create here.

CREATE TABLE `course_requests` (
	`id` INT NOT NULL AUTO_INCREMENT,
	`course_id` INT NULL COMMENT 'What training is requested',
	`requester_id` INT NULL COMMENT 'Who Requetsed the training',
	`requested_availablity` TINYTEXT NULL COMMENT 'Freeform Request Time Frame',
	`aditional_info` TINYTEXT NULL COMMENT 'Aditional info provided by requester',
	`request_status` ENUM('New Request','Awaiting Scheduling','Scheduled','Fulfilled','Did Not Attend','Ignore') NULL DEFAULT NULL COMMENT 'Allow Training Staff to keep track of state of request',
	`requested_date` DATETIME NOT NULL DEFAULT current_timestamp() COMMENT 'Date the Request was put in',
	`fufilled_by_id` INT NULL DEFAULT NULL COMMENT 'Who Fufilled the Request',
	`fufilled_date` DATETIME NULL COMMENT 'What date the request was fufilled',
	`created_at` DATETIME NOT NULL DEFAULT current_timestamp() COMMENT 'Database Value',
	`updated_at` DATETIME NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Database Value',
	`request_notes` TINYTEXT NULL COMMENT 'Notes for the Training Staff to put on the request (Internal)',
	PRIMARY KEY (`id`),
	CONSTRAINT `FK__members` FOREIGN KEY (`requester_id`) REFERENCES `members` (`id`) ON UPDATE CASCADE ON DELETE RESTRICT,
	CONSTRAINT `FK__courses` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON UPDATE CASCADE ON DELETE RESTRICT,
	CONSTRAINT `FK__members_2` FOREIGN KEY (`fufilled_by_id`) REFERENCES `members` (`id`) ON UPDATE CASCADE ON DELETE RESTRICT
)
COMMENT='Contains a list of Course requests that members wish to make.'
COLLATE='utf8mb4_general_ci'
;
Modified Table a bit. New table create here. ```sql CREATE TABLE `course_requests` ( `id` INT NOT NULL AUTO_INCREMENT, `course_id` INT NULL COMMENT 'What training is requested', `requester_id` INT NULL COMMENT 'Who Requetsed the training', `requested_availablity` TINYTEXT NULL COMMENT 'Freeform Request Time Frame', `aditional_info` TINYTEXT NULL COMMENT 'Aditional info provided by requester', `request_status` ENUM('New Request','Awaiting Scheduling','Scheduled','Fulfilled','Did Not Attend','Ignore') NULL DEFAULT NULL COMMENT 'Allow Training Staff to keep track of state of request', `requested_date` DATETIME NOT NULL DEFAULT current_timestamp() COMMENT 'Date the Request was put in', `fufilled_by_id` INT NULL DEFAULT NULL COMMENT 'Who Fufilled the Request', `fufilled_date` DATETIME NULL COMMENT 'What date the request was fufilled', `created_at` DATETIME NOT NULL DEFAULT current_timestamp() COMMENT 'Database Value', `updated_at` DATETIME NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Database Value', `request_notes` TINYTEXT NULL COMMENT 'Notes for the Training Staff to put on the request (Internal)', PRIMARY KEY (`id`), CONSTRAINT `FK__members` FOREIGN KEY (`requester_id`) REFERENCES `members` (`id`) ON UPDATE CASCADE ON DELETE RESTRICT, CONSTRAINT `FK__courses` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON UPDATE CASCADE ON DELETE RESTRICT, CONSTRAINT `FK__members_2` FOREIGN KEY (`fufilled_by_id`) REFERENCES `members` (`id`) ON UPDATE CASCADE ON DELETE RESTRICT ) COMMENT='Contains a list of Course requests that members wish to make.' COLLATE='utf8mb4_general_ci' ; ```
Ajdj100 removed this from the 1.1.0 milestone 2026-01-17 09:29:41 -06:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: 17th-Ranger-Battalion-ORG/milsim-site-v4#130