CREATE TABLE `v2connect_exit_questions` (
	`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
	`question_text` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
	 PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1;
 
CREATE TABLE `v2connect_exit_reasons` (
	`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
	`question_id` BIGINT(20) UNSIGNED NOT NULL,
	`category` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`answer` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `question_id` (`question_id`) USING BTREE,
	CONSTRAINT `v2connect_exit_reasons_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `v2connect_exit_questions` (`id`) ON UPDATE RESTRICT ON DELETE RESTRICT
)

COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;



-- Insert the question into v2connect_exit_questions
INSERT INTO `v2connect_exit_questions` (`id`, `question_text`) 
VALUES (1, 'What motivated your decision to leave the organization?');
 
-- Insert the reasons into v2connect_exit_reasons
INSERT INTO `v2connect_exit_reasons` (`question_id`, `category`, `answer`) 
VALUES 
-- Professional Reasons
(1, 'Professional Reasons', 'Limited career advancement opportunities'),
(1, 'Professional Reasons', 'Lack of skill development or training opportunities'),
(1, 'Professional Reasons', 'Inadequate compensation or benefits'),
(1, 'Professional Reasons', 'Poor performance recognition or rewards'),
(1, 'Professional Reasons', 'Poor management or leadership'),
(1, 'Professional Reasons', 'Misalignment with company culture or values'),
(1, 'Professional Reasons', 'Excessive workload or job stress'),
(1, 'Professional Reasons', 'Unclear job expectations or role ambiguity'),
(1, 'Professional Reasons', 'Lack of work-life balance'),
(1, 'Professional Reasons', 'Inflexible work arrangements (e.g., no remote/hybrid options)'),
(1, 'Professional Reasons', 'Poor team collaboration or internal politics'),
(1, 'Professional Reasons', 'Desire for new challenges or career change'),
(1, 'Professional Reasons', 'Conflict with manager or colleagues'),
(1, 'Professional Reasons', 'Lack of autonomy or decision-making power'),
(1, 'Professional Reasons', 'Concerns about company financial health or stability'),
(1, 'Professional Reasons', 'Job role not aligned with personal skills/interests'),
(1, 'Professional Reasons', 'Slow or delayed internal transfers or promotions'),
(1, 'Professional Reasons', 'Lack of innovation in the company or stagnant environment'),
-- IT/Infrastructure Related
(1, 'IT/Infrastructure Related', 'Inadequate or outdated IT infrastructure/tools'),
(1, 'IT/Infrastructure Related', 'Frequent system downtimes or inefficiencies'),
(1, 'IT/Infrastructure Related', 'Delays in receiving required hardware or software'),
(1, 'IT/Infrastructure Related', 'Lack of IT support or slow response time'),
(1, 'IT/Infrastructure Related', 'Data security or privacy concerns'),
-- HR-Related
(1, 'HR-Related', 'Ineffective or absent employee engagement programs'),
(1, 'HR-Related', 'Inadequate onboarding or orientation experience'),
(1, 'HR-Related', 'Limited or irrelevant training and development programs'),
(1, 'HR-Related', 'Lack of transparency in HR policies'),
(1, 'HR-Related', 'Poor grievance redressal or employee relations'),
(1, 'HR-Related', 'Weak diversity, equity, and inclusion efforts'),
(1, 'HR-Related', 'Unresponsive or ineffective HR support'),
-- Finance/Accounting Related
(1, 'Finance/Accounting Related', 'Delayed reimbursements or salary payments'),
(1, 'Finance/Accounting Related', 'Lack of clarity in compensation structure'),
(1, 'Finance/Accounting Related', 'Inconsistent or unfair bonus/pay raise practices'),
(1, 'Finance/Accounting Related', 'Poor travel or expense management systems'),
-- Personal Reasons
(1, 'Personal Reasons', 'Relocation or moving to a new location'),
(1, 'Personal Reasons', 'Family or caregiving responsibilities'),
(1, 'Personal Reasons', 'Pursuing further education'),
(1, 'Personal Reasons', 'Health or medical reasons'),
(1, 'Personal Reasons', 'Retirement'),
(1, 'Personal Reasons', 'Starting own business or freelancing'),
(1, 'Personal Reasons', 'Career break or sabbatical'),
(1, 'Personal Reasons', 'Spouse/partner’s job relocation'),
(1, 'Personal Reasons', 'Personal burnout or mental health focus'),
-- Other
(1, 'Other', 'Other (please specify)');
 
 
 
 -- Insert the question into v2connect_exit_questions
INSERT INTO `v2connect_exit_questions` (`id`, `question_text`) 
VALUES (2, 'What aspects of working here did you value the most?');
 
-- Insert the reasons into v2connect_exit_reasons

INSERT INTO `v2connect_exit_reasons` (`question_id`, `category`, `answer`) 

VALUES 
-- Positive Organizational Factors
(2, 'Positive Organizational Factors', 'Supportive and approachable leadership'),
(2, 'Positive Organizational Factors', 'Collaborative and respectful team culture'),

(2, 'Positive Organizational Factors', 'Flexible work arrangements (remote, hybrid, flexible hours)'),

(2, 'Positive Organizational Factors', 'Work-life balance and personal time respect'),

(2, 'Positive Organizational Factors', 'Access to skill development and learning programs'),

(2, 'Positive Organizational Factors', 'Employee recognition and appreciation culture'),

(2, 'Positive Organizational Factors', 'Fair and transparent HR policies'),

(2, 'Positive Organizational Factors', 'Organizational mission and values alignment'),

(2, 'Positive Organizational Factors', 'Inclusive and diverse workplace culture'),

(2, 'Positive Organizational Factors', 'Opportunities for internal mobility and promotions'),

(2, 'Positive Organizational Factors', 'Freedom to innovate or share ideas'),

(2, 'Positive Organizational Factors', 'Effective communication from leadership'),

(2, 'Positive Organizational Factors', 'Wellness and mental health support programs'),

(2, 'Positive Organizational Factors', 'Job security and role stability'),

(2, 'Positive Organizational Factors', 'Technology tools that support productivity'),

(2, 'Positive Organizational Factors', 'Responsive and supportive HR and IT teams'),

(2, 'Positive Organizational Factors', 'Structured onboarding process'),

(2, 'Positive Organizational Factors', 'Timely salary and reimbursement processing'),

-- Other

(2, 'Other', 'Other (please specify)');
 
 
-- Insert the question into v2connect_exit_questions

INSERT INTO `v2connect_exit_questions` (`id`, `question_text`) 

VALUES (3, 'What areas of the company or your role did you find most challenging or dissatisfying?');
 
-- Insert the reasons into v2connect_exit_reasons

INSERT INTO `v2connect_exit_reasons` (`question_id`, `category`, `answer`) 

VALUES 

-- Common Workplace Challenges

(3, 'Common Workplace Challenges', 'Limited career growth or unclear path'),

(3, 'Common Workplace Challenges', 'Poor leadership or micromanagement'),

(3, 'Common Workplace Challenges', 'Lack of recognition for efforts'),

(3, 'Common Workplace Challenges', 'Poor team collaboration or workplace politics'),

(3, 'Common Workplace Challenges', 'Unreasonable workload or unrealistic deadlines'),

(3, 'Common Workplace Challenges', 'Ineffective performance feedback or review process'),

(3, 'Common Workplace Challenges', 'Lack of role clarity or constant role changes'),

(3, 'Common Workplace Challenges', 'Work-life imbalance or excessive overtime'),

(3, 'Common Workplace Challenges', 'Poor communication between departments'),

-- IT/Infrastructure Challenges

(3, 'IT/Infrastructure Challenges', 'Outdated systems or slow software'),

(3, 'IT/Infrastructure Challenges', 'Lack of required tools or resources for the job'),

(3, 'IT/Infrastructure Challenges', 'Delays in asset provisioning or replacements'),

(3, 'IT/Infrastructure Challenges', 'Insufficient IT support responsiveness'),

(3, 'IT/Infrastructure Challenges', 'Poor remote work setup or VPN access issues'),

-- HR-Related Issues

(3, 'HR-Related Issues', 'Limited or irrelevant training and development'),

(3, 'HR-Related Issues', 'Ineffective employee engagement initiatives'),

(3, 'HR-Related Issues', 'Lack of action on employee feedback'),

(3, 'HR-Related Issues', 'Poor conflict resolution or grievance handling'),

(3, 'HR-Related Issues', 'Weak DEI (Diversity, Equity, Inclusion) practices'),

(3, 'HR-Related Issues', 'Lack of clarity in HR communication'),

-- Finance/Accounting Issues

(3, 'Finance/Accounting Issues', 'Delayed reimbursement processing'),

(3, 'Finance/Accounting Issues', 'Confusing or inconsistent salary structure'),

(3, 'Finance/Accounting Issues', 'No transparency in bonus/variable pay distribution'),

(3, 'Finance/Accounting Issues', 'Poor support for travel or expense claims'),

-- Other

(3, 'Other', 'Other (please specify)');
 
-- Insert the question into v2connect_exit_questions

INSERT INTO `v2connect_exit_questions` (`id`, `question_text`) 

VALUES (4, 'What is your new employer offering that influenced your decision?');
 
-- Insert the reasons into v2connect_exit_reasons

INSERT INTO `v2connect_exit_reasons` (`question_id`, `category`, `answer`) 

VALUES 

-- Professional Benefits

(4, 'Professional Benefits', 'Higher salary or better total compensation'),

(4, 'Professional Benefits', 'Clear career progression path'),

(4, 'Professional Benefits', 'More engaging or aligned job role'),

(4, 'Professional Benefits', 'Better leadership or team culture'),

(4, 'Professional Benefits', 'Stronger organizational reputation'),

(4, 'Professional Benefits', 'Innovative or cutting-edge work environment'),

(4, 'Professional Benefits', 'Greater autonomy and trust in role'),

(4, 'Professional Benefits', 'Better tools and systems for productivity'),

(4, 'Professional Benefits', 'More modern or user-friendly IT infrastructure'),

(4, 'Professional Benefits', 'Opportunity to lead projects or take ownership'),

(4, 'Professional Benefits', 'Stronger DEI or ethical culture'),

-- HR & Culture-Driven Benefits

(4, 'HR & Culture-Driven Benefits', 'Personalized training and development programs'),

(4, 'HR & Culture-Driven Benefits', 'More frequent recognition and performance feedback'),

(4, 'HR & Culture-Driven Benefits', 'Improved onboarding and support'),

(4, 'HR & Culture-Driven Benefits', 'Stronger mentorship and career coaching'),

(4, 'HR & Culture-Driven Benefits', 'Better wellness and mental health support'),

(4, 'HR & Culture-Driven Benefits', 'More inclusive and diverse workplace culture'),

-- Work-Life/Personal Benefits

(4, 'Work-Life/Personal Benefits', 'Flexible working hours or fully remote options'),

(4, 'Work-Life/Personal Benefits', 'Shorter commute or satellite office availability'),

(4, 'Work-Life/Personal Benefits', 'Supportive of caregiving and family needs'),

(4, 'Work-Life/Personal Benefits', 'Sabbatical or leave flexibility'),

(4, 'Work-Life/Personal Benefits', 'Better health insurance or family coverage'),

-- Finance/Compensation Drivers

(4, 'Finance/Compensation Drivers', 'Timely reimbursements and payroll'),

(4, 'Finance/Compensation Drivers', 'Transparent and fair bonus structure'),

(4, 'Finance/Compensation Drivers', 'Comprehensive benefits (ESOPs, insurance, etc.)'),

(4, 'Finance/Compensation Drivers', 'Relocation or travel support'),

-- Other

(4, 'Other', 'Other (please specify)');