/ home / signgwph / _scc_backups / [ HOME SHELL ]

Name	Size	Permission
app-20260821-221415.tgz	245 KB	-rw-r--r--
app-20260823-prewipe.tgz	334.98 KB	-rw-r--r--
db-20260821-221415.sql	109.81 KB	-rw-r--r--
db-20260823-prewipe.sql	87.71 KB	-rw-r--r--
env-20260821-221415.bak	1.28 KB	-rw-r--r--

Code Editor : db-20260821-221415.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.27-MariaDB, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: signgwph_signalcareercompass
-- ------------------------------------------------------
-- Server version	10.6.27-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `applications`
--

DROP TABLE IF EXISTS `applications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `applications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_posting_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `applicant_name` varchar(255) NOT NULL,
  `applicant_email` varchar(255) NOT NULL,
  `applicant_phone` varchar(255) DEFAULT NULL,
  `applicant_avatar_url` text DEFAULT NULL,
  `applicant_title` varchar(255) DEFAULT NULL,
  `applicant_location` varchar(255) DEFAULT NULL,
  `applicant_summary` text DEFAULT NULL,
  `applicant_skills` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`applicant_skills`)),
  `resume_url` text DEFAULT NULL,
  `resume_file_name` varchar(255) DEFAULT NULL,
  `experience_summary` text DEFAULT NULL,
  `custom_answer` text DEFAULT NULL,
  `custom_answers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`custom_answers`)),
  `company` varchar(255) DEFAULT NULL,
  `status` enum('Submitted','Applied','In Review','Interview Scheduled','Offer Extended','Hired','Rejected') NOT NULL DEFAULT 'Applied',
  `applied_date` date DEFAULT NULL,
  `match_score` int(11) NOT NULL DEFAULT 0,
  `review_notes` text DEFAULT NULL,
  `reviewed_at` timestamp NULL DEFAULT NULL,
  `interview_platform` varchar(255) DEFAULT NULL,
  `interview_link` text DEFAULT NULL,
  `interview_scheduled_at` timestamp NULL DEFAULT NULL,
  `interview_notes` text DEFAULT NULL,
  `selected_at` timestamp NULL DEFAULT NULL,
  `rejected_at` timestamp NULL DEFAULT NULL,
  `hired_at` timestamp NULL DEFAULT NULL,
  `owner_approved` tinyint(1) NOT NULL DEFAULT 0,
  `owner_approved_by` varchar(255) DEFAULT NULL,
  `owner_approved_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `applications_job_posting_id_foreign` (`job_posting_id`),
  KEY `applications_user_id_foreign` (`user_id`),
  KEY `applications_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `applications_job_posting_id_foreign` FOREIGN KEY (`job_posting_id`) REFERENCES `job_postings` (`id`) ON DELETE SET NULL,
  CONSTRAINT `applications_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE SET NULL,
  CONSTRAINT `applications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `applications`
--

LOCK TABLES `applications` WRITE;
/*!40000 ALTER TABLE `applications` DISABLE KEYS */;
/*!40000 ALTER TABLE `applications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` bigint(20) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache_locks`
--

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` bigint(20) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `candidates`
--

DROP TABLE IF EXISTS `candidates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `candidates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `skills` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`skills`)),
  `experience` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`experience`)),
  `education` text DEFAULT NULL,
  `summary` text DEFAULT NULL,
  `about_me` text DEFAULT NULL,
  `avatar` text DEFAULT NULL,
  `expected_salary` varchar(255) DEFAULT NULL,
  `preferred_work_arrangement` varchar(255) DEFAULT NULL,
  `stage` varchar(255) NOT NULL DEFAULT 'applied',
  `hired_organization` varchar(255) DEFAULT NULL,
  `banned` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `candidates_user_id_foreign` (`user_id`),
  CONSTRAINT `candidates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `candidates`
--

LOCK TABLES `candidates` WRITE;
/*!40000 ALTER TABLE `candidates` DISABLE KEYS */;
INSERT INTO `candidates` VALUES (1,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All','applied',NULL,0,'2026-08-17 20:44:03','2026-08-17 20:44:03');
/*!40000 ALTER TABLE `candidates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `conversations`
--

DROP TABLE IF EXISTS `conversations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `conversations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `participant_1_id` bigint(20) unsigned NOT NULL,
  `participant_2_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `avatar_initials` varchar(255) DEFAULT NULL,
  `avatar_color` varchar(255) DEFAULT NULL,
  `avatar_url` text DEFAULT NULL,
  `applicant_name` varchar(255) DEFAULT NULL,
  `applicant_email` varchar(255) DEFAULT NULL,
  `recruiter_name` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `last_message` text DEFAULT NULL,
  `last_message_at` timestamp NULL DEFAULT NULL,
  `unread_count` int(11) NOT NULL DEFAULT 0,
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `conversations_participant_1_id_foreign` (`participant_1_id`),
  KEY `conversations_participant_2_id_foreign` (`participant_2_id`),
  KEY `conversations_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `conversations_participant_1_id_foreign` FOREIGN KEY (`participant_1_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `conversations_participant_2_id_foreign` FOREIGN KEY (`participant_2_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `conversations_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `conversations`
--

LOCK TABLES `conversations` WRITE;
/*!40000 ALTER TABLE `conversations` DISABLE KEYS */;
/*!40000 ALTER TABLE `conversations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `courses`
--

DROP TABLE IF EXISTS `courses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `courses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `provider` varchar(255) DEFAULT NULL,
  `duration` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `skills` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`skills`)),
  `level` varchar(255) NOT NULL DEFAULT 'Beginner',
  `description` text DEFAULT NULL,
  `view_url` varchar(255) DEFAULT NULL,
  `purchase_url` varchar(255) DEFAULT NULL,
  `university_name` varchar(255) DEFAULT NULL,
  `university_url` varchar(255) DEFAULT NULL,
  `promo_banner_url` varchar(255) DEFAULT NULL,
  `video_url` varchar(255) DEFAULT NULL,
  `video_source_type` varchar(255) NOT NULL DEFAULT 'link',
  `is_promoted` tinyint(1) NOT NULL DEFAULT 0,
  `visibility` varchar(255) NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `courses_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `courses_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `courses`
--

LOCK TABLES `courses` WRITE;
/*!40000 ALTER TABLE `courses` DISABLE KEYS */;
/*!40000 ALTER TABLE `courses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `custom_roles`
--

DROP TABLE IF EXISTS `custom_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `custom_roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permissions`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custom_roles_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `custom_roles_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `custom_roles`
--

LOCK TABLES `custom_roles` WRITE;
/*!40000 ALTER TABLE `custom_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `custom_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `departments`
--

DROP TABLE IF EXISTS `departments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `departments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `departments_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `departments_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `departments`
--

LOCK TABLES `departments` WRITE;
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` varchar(255) NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `franchise_documents`
--

DROP TABLE IF EXISTS `franchise_documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `franchise_documents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `franchise_lifecycle_id` bigint(20) unsigned NOT NULL,
  `document_type` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `version` varchar(255) NOT NULL DEFAULT '1.0',
  `signed_at` timestamp NULL DEFAULT NULL,
  `signature_name` varchar(255) DEFAULT NULL,
  `signature_certificate` text DEFAULT NULL,
  `restricted_access` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `franchise_documents_franchise_lifecycle_id_foreign` (`franchise_lifecycle_id`),
  CONSTRAINT `franchise_documents_franchise_lifecycle_id_foreign` FOREIGN KEY (`franchise_lifecycle_id`) REFERENCES `franchise_lifecycles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `franchise_documents`
--

LOCK TABLES `franchise_documents` WRITE;
/*!40000 ALTER TABLE `franchise_documents` DISABLE KEYS */;
/*!40000 ALTER TABLE `franchise_documents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `franchise_lifecycles`
--

DROP TABLE IF EXISTS `franchise_lifecycles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `franchise_lifecycles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `candidate_name` varchar(255) NOT NULL,
  `candidate_email` varchar(255) NOT NULL,
  `candidate_phone` varchar(255) DEFAULT NULL,
  `lead_source` varchar(255) NOT NULL DEFAULT 'Website Intake',
  `phase` int(11) NOT NULL DEFAULT 1,
  `primary_stage` varchar(255) NOT NULL DEFAULT 'LEAD_NEW',
  `secondary_status` varchar(255) DEFAULT NULL,
  `user_label` varchar(255) NOT NULL DEFAULT 'Candidate',
  `canonical_profile` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`canonical_profile`)),
  `milestones` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`milestones`)),
  `intro_call_completed_at` timestamp NULL DEFAULT NULL,
  `portal_invited_at` timestamp NULL DEFAULT NULL,
  `nda_signed_at` timestamp NULL DEFAULT NULL,
  `fdd_delivered_at` timestamp NULL DEFAULT NULL,
  `fdd_receipt_signed_at` timestamp NULL DEFAULT NULL,
  `fdd_review_completed_at` timestamp NULL DEFAULT NULL,
  `application_submitted_at` timestamp NULL DEFAULT NULL,
  `application_accepted_at` timestamp NULL DEFAULT NULL,
  `is_veteran` tinyint(1) NOT NULL DEFAULT 0,
  `veteran_verification_status` varchar(255) NOT NULL DEFAULT 'NOT_SUBMITTED',
  `veteran_verified_at` timestamp NULL DEFAULT NULL,
  `founder_call_completed_at` timestamp NULL DEFAULT NULL,
  `founder_call_outcome` varchar(255) DEFAULT NULL,
  `territory_counties` text DEFAULT NULL,
  `territory_zips` text DEFAULT NULL,
  `territory_approved_by` varchar(255) DEFAULT NULL,
  `territory_approved_at` timestamp NULL DEFAULT NULL,
  `validation_completed_at` timestamp NULL DEFAULT NULL,
  `discovery_day_completed_at` timestamp NULL DEFAULT NULL,
  `agreement_delivered_at` timestamp NULL DEFAULT NULL,
  `agreement_signed_at` timestamp NULL DEFAULT NULL,
  `payment_complete` tinyint(1) NOT NULL DEFAULT 0,
  `promissory_note_signed` tinyint(1) NOT NULL DEFAULT 0,
  `launch_current_week` int(11) NOT NULL DEFAULT 1,
  `approved_dba` varchar(255) DEFAULT NULL,
  `launch_tasks_status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`launch_tasks_status`)),
  `target_launch_date` date DEFAULT NULL,
  `block_reason` varchar(255) DEFAULT NULL,
  `blocked_at` timestamp NULL DEFAULT NULL,
  `assigned_shg_owner_id` bigint(20) unsigned DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `franchise_lifecycles_tenant_id_foreign` (`tenant_id`),
  KEY `franchise_lifecycles_user_id_foreign` (`user_id`),
  KEY `franchise_lifecycles_assigned_shg_owner_id_foreign` (`assigned_shg_owner_id`),
  CONSTRAINT `franchise_lifecycles_assigned_shg_owner_id_foreign` FOREIGN KEY (`assigned_shg_owner_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `franchise_lifecycles_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE SET NULL,
  CONSTRAINT `franchise_lifecycles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `franchise_lifecycles`
--

LOCK TABLES `franchise_lifecycles` WRITE;
/*!40000 ALTER TABLE `franchise_lifecycles` DISABLE KEYS */;
/*!40000 ALTER TABLE `franchise_lifecycles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interview_participants`
--

DROP TABLE IF EXISTS `interview_participants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `interview_participants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `interview_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `role` varchar(50) DEFAULT 'interviewer',
  `status` varchar(50) DEFAULT 'INVITED',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `interview_participants`
--

LOCK TABLES `interview_participants` WRITE;
/*!40000 ALTER TABLE `interview_participants` DISABLE KEYS */;
/*!40000 ALTER TABLE `interview_participants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interviews`
--

DROP TABLE IF EXISTS `interviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `interviews` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `scheduled_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `duration_minutes` int(11) DEFAULT 30,
  `platform` varchar(50) NOT NULL DEFAULT 'ZOOM',
  `status` varchar(50) NOT NULL DEFAULT 'SCHEDULED',
  `interview_type` varchar(50) NOT NULL DEFAULT 'SCREENING',
  `join_url` text DEFAULT NULL,
  `host_url` text DEFAULT NULL,
  `passcode` varchar(50) DEFAULT NULL,
  `external_meeting_id` varchar(255) DEFAULT NULL,
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `created_by_id` bigint(20) unsigned NOT NULL,
  `application_id` bigint(20) unsigned DEFAULT NULL,
  `candidate_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `interviews`
--

LOCK TABLES `interviews` WRITE;
/*!40000 ALTER TABLE `interviews` DISABLE KEYS */;
/*!40000 ALTER TABLE `interviews` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_batches`
--

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_batches`
--

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_postings`
--

DROP TABLE IF EXISTS `job_postings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_postings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `salary` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `requirements` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`requirements`)),
  `status` enum('live','Active','Closed') NOT NULL DEFAULT 'live',
  `views` int(11) NOT NULL DEFAULT 0,
  `applicants_count` int(11) NOT NULL DEFAULT 0,
  `posted_at` date DEFAULT NULL,
  `franchise_logo` text DEFAULT NULL,
  `franchise` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `target_profession` varchar(255) DEFAULT NULL,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `form_requirements` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`form_requirements`)),
  `primary_screening_question` text DEFAULT NULL,
  `custom_questions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`custom_questions`)),
  `evaluation_workflow` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`evaluation_workflow`)),
  `visibility_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`visibility_options`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `job_postings_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `job_postings_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_postings`
--

LOCK TABLES `job_postings` WRITE;
/*!40000 ALTER TABLE `job_postings` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_postings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` smallint(5) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `conversation_id` bigint(20) unsigned NOT NULL,
  `sender_id` bigint(20) unsigned NOT NULL,
  `sender_name` varchar(255) DEFAULT NULL,
  `sender_email` varchar(255) DEFAULT NULL,
  `sender_avatar_url` text DEFAULT NULL,
  `text` text DEFAULT NULL,
  `attachments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attachments`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `messages_conversation_id_foreign` (`conversation_id`),
  KEY `messages_sender_id_foreign` (`sender_id`),
  CONSTRAINT `messages_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `messages_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `messages`
--

LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_08_08_000001_add_role_tenant_to_users_table',1),(5,'2026_08_08_000002_create_tenants_table',1),(6,'2026_08_08_000003_create_job_postings_table',1),(7,'2026_08_08_000004_create_applications_table',1),(8,'2026_08_08_000005_create_candidates_table',1),(9,'2026_08_08_000006_create_onboarding_records_table',1),(10,'2026_08_08_000007_create_training_videos_table',1),(11,'2026_08_08_000008_create_onboarding_checklists_table',1),(12,'2026_08_08_000009_create_courses_table',1),(13,'2026_08_08_000010_create_universities_table',1),(14,'2026_08_08_000011_create_conversations_table',1),(15,'2026_08_08_000012_create_messages_table',1),(16,'2026_08_08_000013_create_social_posts_table',1),(17,'2026_08_08_000014_create_social_comments_table',1),(18,'2026_08_08_000015_create_custom_roles_table',1),(19,'2026_08_08_000016_create_departments_table',1),(20,'2026_08_08_000017_create_franchise_lifecycles_table',1),(21,'2026_08_08_000018_create_notifications_custom_table',1),(22,'2026_08_08_000019_create_settings_table',1),(23,'2026_08_08_000020_create_franchise_documents_table',1),(24,'2026_08_08_000021_add_social_profile_fields_to_users_table',1),(25,'2026_08_08_000022_add_advanced_social_fields_to_social_posts_table',1),(26,'2026_08_08_000023_create_mock_interview_sessions_table',1),(27,'2026_08_09_000001_enhance_courses_training_onboarding',1),(28,'2026_08_09_000002_add_interview_workflow_to_applications_table',1),(29,'2026_08_09_000004_add_assigned_users_to_onboarding_checklists_table',1),(30,'2026_08_09_000005_allow_employee_role_on_users_table',1),(31,'2026_08_09_000006_add_custom_role_id_to_users_table',1),(32,'2026_08_09_000007_add_ban_fields_to_users_table',1),(33,'2026_08_20_000001_add_7phase_multirole_to_onboarding_records_table',2);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mock_interview_sessions`
--

DROP TABLE IF EXISTS `mock_interview_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `mock_interview_sessions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `application_id` bigint(20) unsigned DEFAULT NULL,
  `target_role` varchar(255) NOT NULL,
  `question_type` varchar(255) NOT NULL DEFAULT 'Mixed',
  `job_specification` text DEFAULT NULL,
  `education` text DEFAULT NULL,
  `experience` text DEFAULT NULL,
  `questions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`questions`)),
  `answers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`answers`)),
  `feedback` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`feedback`)),
  `provider` varchar(255) NOT NULL DEFAULT 'local',
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mock_interview_sessions_user_id_foreign` (`user_id`),
  KEY `mock_interview_sessions_application_id_foreign` (`application_id`),
  CONSTRAINT `mock_interview_sessions_application_id_foreign` FOREIGN KEY (`application_id`) REFERENCES `applications` (`id`) ON DELETE SET NULL,
  CONSTRAINT `mock_interview_sessions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mock_interview_sessions`
--

LOCK TABLES `mock_interview_sessions` WRITE;
/*!40000 ALTER TABLE `mock_interview_sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `mock_interview_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notifications_custom`
--

DROP TABLE IF EXISTS `notifications_custom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications_custom` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text DEFAULT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'info',
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_custom_user_id_foreign` (`user_id`),
  CONSTRAINT `notifications_custom_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notifications_custom`
--

LOCK TABLES `notifications_custom` WRITE;
/*!40000 ALTER TABLE `notifications_custom` DISABLE KEYS */;
INSERT INTO `notifications_custom` VALUES (1,1,'Organization suspended','Signal Health Group enterprise dashboard access is suspended.','tenant-suspended',1,'2026-08-17 19:51:23','2026-08-17 19:51:31');
/*!40000 ALTER TABLE `notifications_custom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `onboarding_checklists`
--

DROP TABLE IF EXISTS `onboarding_checklists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `onboarding_checklists` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `assigned_user_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`assigned_user_ids`)),
  `required` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `onboarding_checklists_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `onboarding_checklists_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `onboarding_checklists`
--

LOCK TABLES `onboarding_checklists` WRITE;
/*!40000 ALTER TABLE `onboarding_checklists` DISABLE KEYS */;
/*!40000 ALTER TABLE `onboarding_checklists` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `onboarding_records`
--

DROP TABLE IF EXISTS `onboarding_records`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `onboarding_records` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `employee_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `role_type` varchar(255) NOT NULL DEFAULT 'candidate',
  `joining_date` date DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'Pending',
  `progress` int(11) NOT NULL DEFAULT 0,
  `documents` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`documents`)),
  `video_progress` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`video_progress`)),
  `checklist_progress` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`checklist_progress`)),
  `phases_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`phases_data`)),
  `mentor_name` varchar(255) DEFAULT NULL,
  `mentor_email` varchar(255) DEFAULT NULL,
  `mentor_phone` varchar(255) DEFAULT NULL,
  `e_signatures` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`e_signatures`)),
  `form_submissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`form_submissions`)),
  `approved_by` varchar(255) DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `onboarding_records_user_id_foreign` (`user_id`),
  KEY `onboarding_records_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `onboarding_records_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE SET NULL,
  CONSTRAINT `onboarding_records_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `onboarding_records`
--

LOCK TABLES `onboarding_records` WRITE;
/*!40000 ALTER TABLE `onboarding_records` DISABLE KEYS */;
INSERT INTO `onboarding_records` VALUES (1,10,1,'EMP-5398','Test Candidate','test.candidate@signalhg.com',NULL,NULL,NULL,'candidate',NULL,'Pending',7,NULL,NULL,NULL,'{\"1\":{\"phase_number\":1,\"title\":\"Pre-Arrival Preparation\",\"description\":\"Welcome email, schedule, mentor assignment, and workspace credentials.\",\"icon\":\"fa-envelope-open-text\",\"status\":\"In Progress\",\"tasks\":[{\"id\":\"p1_t1\",\"title\":\"Send welcome packet & onboarding schedule to Test Candidate\",\"completed\":true,\"completed_at\":\"2026-08-20 16:52:51\"},{\"id\":\"p1_t2\",\"title\":\"Assign peer mentor \\/ buddy to navigate initial onboarding\",\"completed\":false},{\"id\":\"p1_t3\",\"title\":\"Prepare workstation, IT login credentials & software permissions\",\"completed\":false},{\"id\":\"p1_t4\",\"title\":\"Issue employee badge \\/ security access pass\",\"completed\":false}],\"documents\":[{\"id\":\"p1_d1\",\"name\":\"Official Welcome Handbook & First Week Roadmap.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"},{\"id\":\"p1_d2\",\"name\":\"Direct Deposit \\/ Payment Authorization Form.pdf\",\"file_path\":\"\",\"type\":\"form\",\"required\":true,\"status\":\"Pending Upload\"}],\"videos\":[{\"id\":\"p1_v1\",\"title\":\"Welcome to Signal Health Group: Mission, Heritage & Culture\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/dQw4w9WgXcQ\",\"duration\":\"5 mins\",\"completed\":true,\"completed_at\":\"2026-08-20 16:56:46\"}],\"form\":{\"id\":\"p1_f1\",\"title\":\"Emergency Contact & IT Equipment Agreement\",\"fields\":[{\"name\":\"emergency_contact_name\",\"label\":\"Emergency Contact Full Name\",\"type\":\"text\",\"required\":true},{\"name\":\"emergency_contact_phone\",\"label\":\"Emergency Contact Phone Number\",\"type\":\"tel\",\"required\":true},{\"name\":\"emergency_contact_relation\",\"label\":\"Relationship\",\"type\":\"text\",\"required\":true},{\"name\":\"laptop_serial_ack\",\"label\":\"I acknowledge receipt of IT equipment & agree to security guidelines\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":true,\"submitted_at\":\"2026-08-21 21:42:11\",\"submission_values\":{\"emergency_name\":\"Jane Doe\",\"emergency_phone\":\"+1 (555) 234-5678\",\"relationship\":\"Spouse\",\"equipment_ack\":\"1\"}}},\"2\":{\"phase_number\":2,\"title\":\"Day 1: Orientation\",\"description\":\"Personal welcome, facility tour, company mission, values & team introductions.\",\"icon\":\"fa-door-open\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p2_t1\",\"title\":\"Personal welcome meeting with department head & facility tour\",\"completed\":false},{\"id\":\"p2_t2\",\"title\":\"Orientation session: Company Mission, Core Values, and Code of Conduct\",\"completed\":false},{\"id\":\"p2_t3\",\"title\":\"Team introductions & introductory 1-on-1 syncs\",\"completed\":false}],\"documents\":[{\"id\":\"p2_d1\",\"name\":\"Company Organization Chart & Team Directory.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":false,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p2_v1\",\"title\":\"Executive Leadership Orientation & Values Walkthrough\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/ScMzIvxBSi4\",\"duration\":\"8 mins\",\"completed\":false}],\"form\":{\"id\":\"p2_f1\",\"title\":\"Day 1 Orientation Acknowledgment Form\",\"fields\":[{\"name\":\"orientation_attended_date\",\"label\":\"Date Orientation Attended\",\"type\":\"date\",\"required\":true},{\"name\":\"facility_safety_tour_done\",\"label\":\"I have completed the facility safety & emergency exit walkthrough\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"3\":{\"phase_number\":3,\"title\":\"Training and Development\",\"description\":\"Software & Electronic Health Record (EHR) mastery, shadowing, and online workshops.\",\"icon\":\"fa-graduation-cap\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p3_t1\",\"title\":\"Complete EHR software simulation & clinical documentation modules\",\"completed\":false},{\"id\":\"p3_t2\",\"title\":\"Participate in 2 days of senior staff shadowing & live workflow reviews\",\"completed\":false},{\"id\":\"p3_t3\",\"title\":\"Complete Continuous Learning Workshop #1\",\"completed\":false}],\"documents\":[{\"id\":\"p3_d1\",\"name\":\"Software User Manual & EHR Quick Reference Guide.pdf\",\"file_path\":\"\",\"type\":\"manual\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p3_v1\",\"title\":\"EHR & Clinical Documentation Workflow Training\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/kJQP7kiw5Fk\",\"duration\":\"12 mins\",\"completed\":false}],\"form\":{\"id\":\"p3_f1\",\"title\":\"Software Competency & Shadowing Sign-Off\",\"fields\":[{\"name\":\"software_certified_by\",\"label\":\"Trainer \\/ Lead Name\",\"type\":\"text\",\"required\":true},{\"name\":\"shadowing_hours_completed\",\"label\":\"Total Shadowing Hours Completed\",\"type\":\"number\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"4\":{\"phase_number\":4,\"title\":\"Compliance and Certification\",\"description\":\"HIPAA compliance, certifications, state licensure verification & compliance sign-offs.\",\"icon\":\"fa-file-shield\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p4_t1\",\"title\":\"Complete mandatory HIPAA Privacy & Patient Confidentiality Training\",\"completed\":false},{\"id\":\"p4_t2\",\"title\":\"Upload copy of current State License \\/ CPR \\/ Certifications\",\"completed\":false},{\"id\":\"p4_t3\",\"title\":\"Sign Corporate Compliance & Anti-Fraud Acknowledgment\",\"completed\":false}],\"documents\":[{\"id\":\"p4_d1\",\"name\":\"State Professional License \\/ Certification Upload\",\"file_path\":\"\",\"type\":\"upload\",\"required\":true,\"status\":\"Pending Upload\"},{\"id\":\"p4_d2\",\"name\":\"HIPAA Compliance Policy & Guidelines.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p4_v1\",\"title\":\"HIPAA Compliance & Protected Health Information (PHI) Security\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/L_LUpnjgPso\",\"duration\":\"10 mins\",\"completed\":false}],\"form\":{\"id\":\"p4_f1\",\"title\":\"HIPAA & Compliance Agreement Sign-Off\",\"fields\":[{\"name\":\"license_number\",\"label\":\"Professional License Number (if applicable)\",\"type\":\"text\",\"required\":false},{\"name\":\"license_expiry\",\"label\":\"License Expiration Date\",\"type\":\"date\",\"required\":false},{\"name\":\"hipaa_pledge\",\"label\":\"I solemnly pledge to safeguard all Protected Health Information (PHI) under federal law\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"5\":{\"phase_number\":5,\"title\":\"Role-Specific Onboarding\",\"description\":\"Job KPIs, performance expectations, feedback schedule & career progression roadmap.\",\"icon\":\"fa-bullseye\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p5_t1\",\"title\":\"Review Employee Job Description, KPIs & 90-Day Goals\",\"completed\":false},{\"id\":\"p5_t2\",\"title\":\"Schedule bi-weekly 1-on-1 check-ins with manager\",\"completed\":false},{\"id\":\"p5_t3\",\"title\":\"Establish individualized Career Advancement Roadmap\",\"completed\":false}],\"documents\":[{\"id\":\"p5_d1\",\"name\":\"Role Specifications & KPI Performance Matrix.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p5_f1\",\"title\":\"Job Expectations & 90-Day Goals Agreement\",\"fields\":[{\"name\":\"primary_goal_1\",\"label\":\"30-Day Key Objective\",\"type\":\"text\",\"required\":true},{\"name\":\"primary_goal_2\",\"label\":\"60-Day Key Objective\",\"type\":\"text\",\"required\":true},{\"name\":\"kpi_acceptance\",\"label\":\"I understand my role KPIs and agree to meet performance benchmarks\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"6\":{\"phase_number\":6,\"title\":\"Benefits and HR Policies\",\"description\":\"Benefits enrollment, health & retirement packages, PTO, dress code & HR Q&A.\",\"icon\":\"fa-hand-holding-heart\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p6_t1\",\"title\":\"Review Employee Benefits Package (Medical, Dental, Vision, 401k)\",\"completed\":false},{\"id\":\"p6_t2\",\"title\":\"Review Attendance, Time Off (PTO), and Dress Code Policies\",\"completed\":false},{\"id\":\"p6_t3\",\"title\":\"Complete HR Q&A session & submit policy acknowledgment\",\"completed\":false}],\"documents\":[{\"id\":\"p6_d1\",\"name\":\"Full Employee Benefits Guide & Plan Summary.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"},{\"id\":\"p6_d2\",\"name\":\"Employee Handbook & HR Policies 2026.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p6_f1\",\"title\":\"HR Policies & Benefits Acknowledgment Sign-Off\",\"fields\":[{\"name\":\"benefit_plan_selection\",\"label\":\"Benefits Plan Selection\",\"type\":\"select\",\"options\":[\"Full Coverage Plan A\",\"Standard Plan B\",\"Waive Coverage \\/ Other Provider\"],\"required\":true},{\"name\":\"policy_handbook_ack\",\"label\":\"I have read and agree to comply with all employee handbook & attendance policies\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"7\":{\"phase_number\":7,\"title\":\"Ongoing Support\",\"description\":\"30\\/60\\/90-day review milestones, feedback loops, stress & work-life balance resources.\",\"icon\":\"fa-comments\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p7_t1\",\"title\":\"Schedule 30-Day Check-in Meeting with HR & Leadership\",\"completed\":false},{\"id\":\"p7_t2\",\"title\":\"Complete 30-Day Onboarding Satisfaction & Feedback Survey\",\"completed\":false},{\"id\":\"p7_t3\",\"title\":\"Access Employee Wellness & Work-Life Balance Assistance Programs\",\"completed\":false}],\"documents\":[{\"id\":\"p7_d1\",\"name\":\"Employee Wellness & Mental Health Support Program.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":false,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p7_f1\",\"title\":\"30-Day Onboarding Feedback & Experience Review\",\"fields\":[{\"name\":\"onboarding_rating\",\"label\":\"Overall Onboarding Experience (1 to 10)\",\"type\":\"number\",\"required\":true},{\"name\":\"feedback_comments\",\"label\":\"What can we improve about your onboarding journey?\",\"type\":\"textarea\",\"required\":false}],\"requires_signature\":false,\"submitted\":false}}}',NULL,NULL,NULL,'{\"p1_f1\":{\"phase\":\"1\",\"form_title\":\"Emergency Contact & IT Equipment Agreement\",\"signed_by\":\"support\",\"email\":\"support@signalhg.com\",\"ip_address\":\"127.0.0.1\",\"user_agent\":\"Symfony\",\"signature_data\":\"TYPED:Test Candidate Legal\",\"signed_at\":\"2026-08-21 21:42:11\"}}','{\"p1_f1\":{\"phase\":\"1\",\"title\":\"Emergency Contact & IT Equipment Agreement\",\"submitted_by\":\"support\",\"email\":\"support@signalhg.com\",\"values\":{\"emergency_name\":\"Jane Doe\",\"emergency_phone\":\"+1 (555) 234-5678\",\"relationship\":\"Spouse\",\"equipment_ack\":\"1\"},\"submitted_at\":\"2026-08-21 21:42:11\"}}',NULL,NULL,NULL,'2026-08-20 14:02:47','2026-08-21 21:42:11'),(2,10,1,'EMP-9886','Test Trainer','test.trainer@signalhg.com',NULL,NULL,NULL,'trainer',NULL,'Pending',2,NULL,NULL,NULL,'{\"1\":{\"phase_number\":1,\"title\":\"Pre-Arrival Preparation\",\"description\":\"Welcome email, schedule, mentor assignment, and workspace credentials.\",\"icon\":\"fa-envelope-open-text\",\"status\":\"In Progress\",\"tasks\":[{\"id\":\"p1_t1\",\"title\":\"Send welcome packet & onboarding schedule to Test Trainer\",\"completed\":true,\"completed_at\":\"2026-08-20 14:02:47\"},{\"id\":\"p1_t2\",\"title\":\"Assign peer mentor \\/ buddy to navigate initial onboarding\",\"completed\":false},{\"id\":\"p1_t3\",\"title\":\"Prepare workstation, IT login credentials & software permissions\",\"completed\":false},{\"id\":\"p1_t4\",\"title\":\"Issue employee badge \\/ security access pass\",\"completed\":false}],\"documents\":[{\"id\":\"p1_d1\",\"name\":\"Official Welcome Handbook & First Week Roadmap.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"},{\"id\":\"p1_d2\",\"name\":\"Direct Deposit \\/ Payment Authorization Form.pdf\",\"file_path\":\"\",\"type\":\"form\",\"required\":true,\"status\":\"Pending Upload\"}],\"videos\":[{\"id\":\"p1_v1\",\"title\":\"Welcome to Signal Health Group: Mission, Heritage & Culture\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/dQw4w9WgXcQ\",\"duration\":\"5 mins\",\"completed\":false}],\"form\":{\"id\":\"p1_f1\",\"title\":\"Emergency Contact & IT Equipment Agreement\",\"fields\":[{\"name\":\"emergency_contact_name\",\"label\":\"Emergency Contact Full Name\",\"type\":\"text\",\"required\":true},{\"name\":\"emergency_contact_phone\",\"label\":\"Emergency Contact Phone Number\",\"type\":\"tel\",\"required\":true},{\"name\":\"emergency_contact_relation\",\"label\":\"Relationship\",\"type\":\"text\",\"required\":true},{\"name\":\"laptop_serial_ack\",\"label\":\"I acknowledge receipt of IT equipment & agree to security guidelines\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"2\":{\"phase_number\":2,\"title\":\"Day 1: Orientation\",\"description\":\"Personal welcome, facility tour, company mission, values & team introductions.\",\"icon\":\"fa-door-open\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p2_t1\",\"title\":\"Personal welcome meeting with department head & facility tour\",\"completed\":false},{\"id\":\"p2_t2\",\"title\":\"Orientation session: Company Mission, Core Values, and Code of Conduct\",\"completed\":false},{\"id\":\"p2_t3\",\"title\":\"Team introductions & introductory 1-on-1 syncs\",\"completed\":false}],\"documents\":[{\"id\":\"p2_d1\",\"name\":\"Company Organization Chart & Team Directory.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":false,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p2_v1\",\"title\":\"Executive Leadership Orientation & Values Walkthrough\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/ScMzIvxBSi4\",\"duration\":\"8 mins\",\"completed\":false}],\"form\":{\"id\":\"p2_f1\",\"title\":\"Day 1 Orientation Acknowledgment Form\",\"fields\":[{\"name\":\"orientation_attended_date\",\"label\":\"Date Orientation Attended\",\"type\":\"date\",\"required\":true},{\"name\":\"facility_safety_tour_done\",\"label\":\"I have completed the facility safety & emergency exit walkthrough\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"3\":{\"phase_number\":3,\"title\":\"Training and Development\",\"description\":\"Software & Electronic Health Record (EHR) mastery, shadowing, and online workshops.\",\"icon\":\"fa-graduation-cap\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p3_t1\",\"title\":\"Complete EHR software simulation & clinical documentation modules\",\"completed\":false},{\"id\":\"p3_t2\",\"title\":\"Participate in 2 days of senior staff shadowing & live workflow reviews\",\"completed\":false},{\"id\":\"p3_t3\",\"title\":\"Complete Continuous Learning Workshop #1\",\"completed\":false}],\"documents\":[{\"id\":\"p3_d1\",\"name\":\"Software User Manual & EHR Quick Reference Guide.pdf\",\"file_path\":\"\",\"type\":\"manual\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p3_v1\",\"title\":\"EHR & Clinical Documentation Workflow Training\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/kJQP7kiw5Fk\",\"duration\":\"12 mins\",\"completed\":false}],\"form\":{\"id\":\"p3_f1\",\"title\":\"Software Competency & Shadowing Sign-Off\",\"fields\":[{\"name\":\"software_certified_by\",\"label\":\"Trainer \\/ Lead Name\",\"type\":\"text\",\"required\":true},{\"name\":\"shadowing_hours_completed\",\"label\":\"Total Shadowing Hours Completed\",\"type\":\"number\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"4\":{\"phase_number\":4,\"title\":\"Compliance and Certification\",\"description\":\"HIPAA compliance, certifications, state licensure verification & compliance sign-offs.\",\"icon\":\"fa-file-shield\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p4_t1\",\"title\":\"Complete mandatory HIPAA Privacy & Patient Confidentiality Training\",\"completed\":false},{\"id\":\"p4_t2\",\"title\":\"Upload copy of current State License \\/ CPR \\/ Certifications\",\"completed\":false},{\"id\":\"p4_t3\",\"title\":\"Sign Corporate Compliance & Anti-Fraud Acknowledgment\",\"completed\":false}],\"documents\":[{\"id\":\"p4_d1\",\"name\":\"State Professional License \\/ Certification Upload\",\"file_path\":\"\",\"type\":\"upload\",\"required\":true,\"status\":\"Pending Upload\"},{\"id\":\"p4_d2\",\"name\":\"HIPAA Compliance Policy & Guidelines.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p4_v1\",\"title\":\"HIPAA Compliance & Protected Health Information (PHI) Security\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/L_LUpnjgPso\",\"duration\":\"10 mins\",\"completed\":false}],\"form\":{\"id\":\"p4_f1\",\"title\":\"HIPAA & Compliance Agreement Sign-Off\",\"fields\":[{\"name\":\"license_number\",\"label\":\"Professional License Number (if applicable)\",\"type\":\"text\",\"required\":false},{\"name\":\"license_expiry\",\"label\":\"License Expiration Date\",\"type\":\"date\",\"required\":false},{\"name\":\"hipaa_pledge\",\"label\":\"I solemnly pledge to safeguard all Protected Health Information (PHI) under federal law\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"5\":{\"phase_number\":5,\"title\":\"Role-Specific Onboarding\",\"description\":\"Job KPIs, performance expectations, feedback schedule & career progression roadmap.\",\"icon\":\"fa-bullseye\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p5_t1\",\"title\":\"Review Master Trainer Job Description, KPIs & 90-Day Goals\",\"completed\":false},{\"id\":\"p5_t2\",\"title\":\"Schedule bi-weekly 1-on-1 check-ins with manager\",\"completed\":false},{\"id\":\"p5_t3\",\"title\":\"Establish individualized Career Advancement Roadmap\",\"completed\":false}],\"documents\":[{\"id\":\"p5_d1\",\"name\":\"Role Specifications & KPI Performance Matrix.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p5_f1\",\"title\":\"Job Expectations & 90-Day Goals Agreement\",\"fields\":[{\"name\":\"primary_goal_1\",\"label\":\"30-Day Key Objective\",\"type\":\"text\",\"required\":true},{\"name\":\"primary_goal_2\",\"label\":\"60-Day Key Objective\",\"type\":\"text\",\"required\":true},{\"name\":\"kpi_acceptance\",\"label\":\"I understand my role KPIs and agree to meet performance benchmarks\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"6\":{\"phase_number\":6,\"title\":\"Benefits and HR Policies\",\"description\":\"Benefits enrollment, health & retirement packages, PTO, dress code & HR Q&A.\",\"icon\":\"fa-hand-holding-heart\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p6_t1\",\"title\":\"Review Employee Benefits Package (Medical, Dental, Vision, 401k)\",\"completed\":false},{\"id\":\"p6_t2\",\"title\":\"Review Attendance, Time Off (PTO), and Dress Code Policies\",\"completed\":false},{\"id\":\"p6_t3\",\"title\":\"Complete HR Q&A session & submit policy acknowledgment\",\"completed\":false}],\"documents\":[{\"id\":\"p6_d1\",\"name\":\"Full Employee Benefits Guide & Plan Summary.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"},{\"id\":\"p6_d2\",\"name\":\"Employee Handbook & HR Policies 2026.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p6_f1\",\"title\":\"HR Policies & Benefits Acknowledgment Sign-Off\",\"fields\":[{\"name\":\"benefit_plan_selection\",\"label\":\"Benefits Plan Selection\",\"type\":\"select\",\"options\":[\"Full Coverage Plan A\",\"Standard Plan B\",\"Waive Coverage \\/ Other Provider\"],\"required\":true},{\"name\":\"policy_handbook_ack\",\"label\":\"I have read and agree to comply with all employee handbook & attendance policies\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"7\":{\"phase_number\":7,\"title\":\"Ongoing Support\",\"description\":\"30\\/60\\/90-day review milestones, feedback loops, stress & work-life balance resources.\",\"icon\":\"fa-comments\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p7_t1\",\"title\":\"Schedule 30-Day Check-in Meeting with HR & Leadership\",\"completed\":false},{\"id\":\"p7_t2\",\"title\":\"Complete 30-Day Onboarding Satisfaction & Feedback Survey\",\"completed\":false},{\"id\":\"p7_t3\",\"title\":\"Access Employee Wellness & Work-Life Balance Assistance Programs\",\"completed\":false}],\"documents\":[{\"id\":\"p7_d1\",\"name\":\"Employee Wellness & Mental Health Support Program.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":false,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p7_f1\",\"title\":\"30-Day Onboarding Feedback & Experience Review\",\"fields\":[{\"name\":\"onboarding_rating\",\"label\":\"Overall Onboarding Experience (1 to 10)\",\"type\":\"number\",\"required\":true},{\"name\":\"feedback_comments\",\"label\":\"What can we improve about your onboarding journey?\",\"type\":\"textarea\",\"required\":false}],\"requires_signature\":false,\"submitted\":false}}}',NULL,NULL,NULL,'[]','[]',NULL,NULL,NULL,'2026-08-20 14:02:47','2026-08-20 14:02:47'),(3,10,1,'EMP-3591','Test Franchise_owner','test.franchise_owner@signalhg.com',NULL,NULL,NULL,'franchise_owner',NULL,'Pending',2,NULL,NULL,NULL,'{\"1\":{\"phase_number\":1,\"title\":\"Pre-Arrival Preparation\",\"description\":\"Welcome email, schedule, mentor assignment, and workspace credentials.\",\"icon\":\"fa-envelope-open-text\",\"status\":\"In Progress\",\"tasks\":[{\"id\":\"p1_t1\",\"title\":\"Send welcome packet & onboarding schedule to Test Franchise_owner\",\"completed\":true,\"completed_at\":\"2026-08-20 14:02:47\"},{\"id\":\"p1_t2\",\"title\":\"Assign peer mentor \\/ buddy to navigate initial onboarding\",\"completed\":false},{\"id\":\"p1_t3\",\"title\":\"Prepare workstation, IT login credentials & software permissions\",\"completed\":false},{\"id\":\"p1_t4\",\"title\":\"Issue employee badge \\/ security access pass\",\"completed\":false}],\"documents\":[{\"id\":\"p1_d1\",\"name\":\"Official Welcome Handbook & First Week Roadmap.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"},{\"id\":\"p1_d2\",\"name\":\"Direct Deposit \\/ Payment Authorization Form.pdf\",\"file_path\":\"\",\"type\":\"form\",\"required\":true,\"status\":\"Pending Upload\"}],\"videos\":[{\"id\":\"p1_v1\",\"title\":\"Welcome to Signal Health Group: Mission, Heritage & Culture\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/dQw4w9WgXcQ\",\"duration\":\"5 mins\",\"completed\":false}],\"form\":{\"id\":\"p1_f1\",\"title\":\"Emergency Contact & IT Equipment Agreement\",\"fields\":[{\"name\":\"emergency_contact_name\",\"label\":\"Emergency Contact Full Name\",\"type\":\"text\",\"required\":true},{\"name\":\"emergency_contact_phone\",\"label\":\"Emergency Contact Phone Number\",\"type\":\"tel\",\"required\":true},{\"name\":\"emergency_contact_relation\",\"label\":\"Relationship\",\"type\":\"text\",\"required\":true},{\"name\":\"laptop_serial_ack\",\"label\":\"I acknowledge receipt of IT equipment & agree to security guidelines\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"2\":{\"phase_number\":2,\"title\":\"Day 1: Orientation\",\"description\":\"Personal welcome, facility tour, company mission, values & team introductions.\",\"icon\":\"fa-door-open\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p2_t1\",\"title\":\"Personal welcome meeting with department head & facility tour\",\"completed\":false},{\"id\":\"p2_t2\",\"title\":\"Orientation session: Company Mission, Core Values, and Code of Conduct\",\"completed\":false},{\"id\":\"p2_t3\",\"title\":\"Team introductions & introductory 1-on-1 syncs\",\"completed\":false}],\"documents\":[{\"id\":\"p2_d1\",\"name\":\"Company Organization Chart & Team Directory.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":false,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p2_v1\",\"title\":\"Executive Leadership Orientation & Values Walkthrough\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/ScMzIvxBSi4\",\"duration\":\"8 mins\",\"completed\":false}],\"form\":{\"id\":\"p2_f1\",\"title\":\"Day 1 Orientation Acknowledgment Form\",\"fields\":[{\"name\":\"orientation_attended_date\",\"label\":\"Date Orientation Attended\",\"type\":\"date\",\"required\":true},{\"name\":\"facility_safety_tour_done\",\"label\":\"I have completed the facility safety & emergency exit walkthrough\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"3\":{\"phase_number\":3,\"title\":\"Training and Development\",\"description\":\"Software & Electronic Health Record (EHR) mastery, shadowing, and online workshops.\",\"icon\":\"fa-graduation-cap\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p3_t1\",\"title\":\"Complete EHR software simulation & clinical documentation modules\",\"completed\":false},{\"id\":\"p3_t2\",\"title\":\"Participate in 2 days of senior staff shadowing & live workflow reviews\",\"completed\":false},{\"id\":\"p3_t3\",\"title\":\"Complete Continuous Learning Workshop #1\",\"completed\":false}],\"documents\":[{\"id\":\"p3_d1\",\"name\":\"Software User Manual & EHR Quick Reference Guide.pdf\",\"file_path\":\"\",\"type\":\"manual\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p3_v1\",\"title\":\"EHR & Clinical Documentation Workflow Training\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/kJQP7kiw5Fk\",\"duration\":\"12 mins\",\"completed\":false}],\"form\":{\"id\":\"p3_f1\",\"title\":\"Software Competency & Shadowing Sign-Off\",\"fields\":[{\"name\":\"software_certified_by\",\"label\":\"Trainer \\/ Lead Name\",\"type\":\"text\",\"required\":true},{\"name\":\"shadowing_hours_completed\",\"label\":\"Total Shadowing Hours Completed\",\"type\":\"number\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"4\":{\"phase_number\":4,\"title\":\"Compliance and Certification\",\"description\":\"HIPAA compliance, certifications, state licensure verification & compliance sign-offs.\",\"icon\":\"fa-file-shield\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p4_t1\",\"title\":\"Complete mandatory HIPAA Privacy & Patient Confidentiality Training\",\"completed\":false},{\"id\":\"p4_t2\",\"title\":\"Upload copy of current State License \\/ CPR \\/ Certifications\",\"completed\":false},{\"id\":\"p4_t3\",\"title\":\"Sign Corporate Compliance & Anti-Fraud Acknowledgment\",\"completed\":false}],\"documents\":[{\"id\":\"p4_d1\",\"name\":\"State Professional License \\/ Certification Upload\",\"file_path\":\"\",\"type\":\"upload\",\"required\":true,\"status\":\"Pending Upload\"},{\"id\":\"p4_d2\",\"name\":\"HIPAA Compliance Policy & Guidelines.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p4_v1\",\"title\":\"HIPAA Compliance & Protected Health Information (PHI) Security\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/L_LUpnjgPso\",\"duration\":\"10 mins\",\"completed\":false}],\"form\":{\"id\":\"p4_f1\",\"title\":\"HIPAA & Compliance Agreement Sign-Off\",\"fields\":[{\"name\":\"license_number\",\"label\":\"Professional License Number (if applicable)\",\"type\":\"text\",\"required\":false},{\"name\":\"license_expiry\",\"label\":\"License Expiration Date\",\"type\":\"date\",\"required\":false},{\"name\":\"hipaa_pledge\",\"label\":\"I solemnly pledge to safeguard all Protected Health Information (PHI) under federal law\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"5\":{\"phase_number\":5,\"title\":\"Role-Specific Onboarding\",\"description\":\"Job KPIs, performance expectations, feedback schedule & career progression roadmap.\",\"icon\":\"fa-bullseye\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p5_t1\",\"title\":\"Review Franchise Owner Job Description, KPIs & 90-Day Goals\",\"completed\":false},{\"id\":\"p5_t2\",\"title\":\"Schedule bi-weekly 1-on-1 check-ins with manager\",\"completed\":false},{\"id\":\"p5_t3\",\"title\":\"Establish individualized Career Advancement Roadmap\",\"completed\":false}],\"documents\":[{\"id\":\"p5_d1\",\"name\":\"Role Specifications & KPI Performance Matrix.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p5_f1\",\"title\":\"Job Expectations & 90-Day Goals Agreement\",\"fields\":[{\"name\":\"primary_goal_1\",\"label\":\"30-Day Key Objective\",\"type\":\"text\",\"required\":true},{\"name\":\"primary_goal_2\",\"label\":\"60-Day Key Objective\",\"type\":\"text\",\"required\":true},{\"name\":\"kpi_acceptance\",\"label\":\"I understand my role KPIs and agree to meet performance benchmarks\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"6\":{\"phase_number\":6,\"title\":\"Benefits and HR Policies\",\"description\":\"Benefits enrollment, health & retirement packages, PTO, dress code & HR Q&A.\",\"icon\":\"fa-hand-holding-heart\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p6_t1\",\"title\":\"Review Employee Benefits Package (Medical, Dental, Vision, 401k)\",\"completed\":false},{\"id\":\"p6_t2\",\"title\":\"Review Attendance, Time Off (PTO), and Dress Code Policies\",\"completed\":false},{\"id\":\"p6_t3\",\"title\":\"Complete HR Q&A session & submit policy acknowledgment\",\"completed\":false}],\"documents\":[{\"id\":\"p6_d1\",\"name\":\"Full Employee Benefits Guide & Plan Summary.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"},{\"id\":\"p6_d2\",\"name\":\"Employee Handbook & HR Policies 2026.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p6_f1\",\"title\":\"HR Policies & Benefits Acknowledgment Sign-Off\",\"fields\":[{\"name\":\"benefit_plan_selection\",\"label\":\"Benefits Plan Selection\",\"type\":\"select\",\"options\":[\"Full Coverage Plan A\",\"Standard Plan B\",\"Waive Coverage \\/ Other Provider\"],\"required\":true},{\"name\":\"policy_handbook_ack\",\"label\":\"I have read and agree to comply with all employee handbook & attendance policies\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"7\":{\"phase_number\":7,\"title\":\"Ongoing Support\",\"description\":\"30\\/60\\/90-day review milestones, feedback loops, stress & work-life balance resources.\",\"icon\":\"fa-comments\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p7_t1\",\"title\":\"Schedule 30-Day Check-in Meeting with HR & Leadership\",\"completed\":false},{\"id\":\"p7_t2\",\"title\":\"Complete 30-Day Onboarding Satisfaction & Feedback Survey\",\"completed\":false},{\"id\":\"p7_t3\",\"title\":\"Access Employee Wellness & Work-Life Balance Assistance Programs\",\"completed\":false}],\"documents\":[{\"id\":\"p7_d1\",\"name\":\"Employee Wellness & Mental Health Support Program.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":false,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p7_f1\",\"title\":\"30-Day Onboarding Feedback & Experience Review\",\"fields\":[{\"name\":\"onboarding_rating\",\"label\":\"Overall Onboarding Experience (1 to 10)\",\"type\":\"number\",\"required\":true},{\"name\":\"feedback_comments\",\"label\":\"What can we improve about your onboarding journey?\",\"type\":\"textarea\",\"required\":false}],\"requires_signature\":false,\"submitted\":false}}}',NULL,NULL,NULL,'[]','[]',NULL,NULL,NULL,'2026-08-20 14:02:47','2026-08-20 14:02:47'),(4,10,1,'EMP-4798','Test Contractor','test.contractor@signalhg.com',NULL,NULL,NULL,'contractor',NULL,'Pending',2,NULL,NULL,NULL,'{\"1\":{\"phase_number\":1,\"title\":\"Pre-Arrival Preparation\",\"description\":\"Welcome email, schedule, mentor assignment, and workspace credentials.\",\"icon\":\"fa-envelope-open-text\",\"status\":\"In Progress\",\"tasks\":[{\"id\":\"p1_t1\",\"title\":\"Send welcome packet & onboarding schedule to Test Contractor\",\"completed\":true,\"completed_at\":\"2026-08-20 14:02:47\"},{\"id\":\"p1_t2\",\"title\":\"Assign peer mentor \\/ buddy to navigate initial onboarding\",\"completed\":false},{\"id\":\"p1_t3\",\"title\":\"Prepare workstation, IT login credentials & software permissions\",\"completed\":false},{\"id\":\"p1_t4\",\"title\":\"Issue employee badge \\/ security access pass\",\"completed\":false}],\"documents\":[{\"id\":\"p1_d1\",\"name\":\"Official Welcome Handbook & First Week Roadmap.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"},{\"id\":\"p1_d2\",\"name\":\"Direct Deposit \\/ Payment Authorization Form.pdf\",\"file_path\":\"\",\"type\":\"form\",\"required\":true,\"status\":\"Pending Upload\"}],\"videos\":[{\"id\":\"p1_v1\",\"title\":\"Welcome to Signal Health Group: Mission, Heritage & Culture\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/dQw4w9WgXcQ\",\"duration\":\"5 mins\",\"completed\":false}],\"form\":{\"id\":\"p1_f1\",\"title\":\"Emergency Contact & IT Equipment Agreement\",\"fields\":[{\"name\":\"emergency_contact_name\",\"label\":\"Emergency Contact Full Name\",\"type\":\"text\",\"required\":true},{\"name\":\"emergency_contact_phone\",\"label\":\"Emergency Contact Phone Number\",\"type\":\"tel\",\"required\":true},{\"name\":\"emergency_contact_relation\",\"label\":\"Relationship\",\"type\":\"text\",\"required\":true},{\"name\":\"laptop_serial_ack\",\"label\":\"I acknowledge receipt of IT equipment & agree to security guidelines\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"2\":{\"phase_number\":2,\"title\":\"Day 1: Orientation\",\"description\":\"Personal welcome, facility tour, company mission, values & team introductions.\",\"icon\":\"fa-door-open\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p2_t1\",\"title\":\"Personal welcome meeting with department head & facility tour\",\"completed\":false},{\"id\":\"p2_t2\",\"title\":\"Orientation session: Company Mission, Core Values, and Code of Conduct\",\"completed\":false},{\"id\":\"p2_t3\",\"title\":\"Team introductions & introductory 1-on-1 syncs\",\"completed\":false}],\"documents\":[{\"id\":\"p2_d1\",\"name\":\"Company Organization Chart & Team Directory.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":false,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p2_v1\",\"title\":\"Executive Leadership Orientation & Values Walkthrough\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/ScMzIvxBSi4\",\"duration\":\"8 mins\",\"completed\":false}],\"form\":{\"id\":\"p2_f1\",\"title\":\"Day 1 Orientation Acknowledgment Form\",\"fields\":[{\"name\":\"orientation_attended_date\",\"label\":\"Date Orientation Attended\",\"type\":\"date\",\"required\":true},{\"name\":\"facility_safety_tour_done\",\"label\":\"I have completed the facility safety & emergency exit walkthrough\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"3\":{\"phase_number\":3,\"title\":\"Training and Development\",\"description\":\"Software & Electronic Health Record (EHR) mastery, shadowing, and online workshops.\",\"icon\":\"fa-graduation-cap\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p3_t1\",\"title\":\"Complete EHR software simulation & clinical documentation modules\",\"completed\":false},{\"id\":\"p3_t2\",\"title\":\"Participate in 2 days of senior staff shadowing & live workflow reviews\",\"completed\":false},{\"id\":\"p3_t3\",\"title\":\"Complete Continuous Learning Workshop #1\",\"completed\":false}],\"documents\":[{\"id\":\"p3_d1\",\"name\":\"Software User Manual & EHR Quick Reference Guide.pdf\",\"file_path\":\"\",\"type\":\"manual\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p3_v1\",\"title\":\"EHR & Clinical Documentation Workflow Training\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/kJQP7kiw5Fk\",\"duration\":\"12 mins\",\"completed\":false}],\"form\":{\"id\":\"p3_f1\",\"title\":\"Software Competency & Shadowing Sign-Off\",\"fields\":[{\"name\":\"software_certified_by\",\"label\":\"Trainer \\/ Lead Name\",\"type\":\"text\",\"required\":true},{\"name\":\"shadowing_hours_completed\",\"label\":\"Total Shadowing Hours Completed\",\"type\":\"number\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"4\":{\"phase_number\":4,\"title\":\"Compliance and Certification\",\"description\":\"HIPAA compliance, certifications, state licensure verification & compliance sign-offs.\",\"icon\":\"fa-file-shield\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p4_t1\",\"title\":\"Complete mandatory HIPAA Privacy & Patient Confidentiality Training\",\"completed\":false},{\"id\":\"p4_t2\",\"title\":\"Upload copy of current State License \\/ CPR \\/ Certifications\",\"completed\":false},{\"id\":\"p4_t3\",\"title\":\"Sign Corporate Compliance & Anti-Fraud Acknowledgment\",\"completed\":false}],\"documents\":[{\"id\":\"p4_d1\",\"name\":\"State Professional License \\/ Certification Upload\",\"file_path\":\"\",\"type\":\"upload\",\"required\":true,\"status\":\"Pending Upload\"},{\"id\":\"p4_d2\",\"name\":\"HIPAA Compliance Policy & Guidelines.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p4_v1\",\"title\":\"HIPAA Compliance & Protected Health Information (PHI) Security\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/L_LUpnjgPso\",\"duration\":\"10 mins\",\"completed\":false}],\"form\":{\"id\":\"p4_f1\",\"title\":\"HIPAA & Compliance Agreement Sign-Off\",\"fields\":[{\"name\":\"license_number\",\"label\":\"Professional License Number (if applicable)\",\"type\":\"text\",\"required\":false},{\"name\":\"license_expiry\",\"label\":\"License Expiration Date\",\"type\":\"date\",\"required\":false},{\"name\":\"hipaa_pledge\",\"label\":\"I solemnly pledge to safeguard all Protected Health Information (PHI) under federal law\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"5\":{\"phase_number\":5,\"title\":\"Role-Specific Onboarding\",\"description\":\"Job KPIs, performance expectations, feedback schedule & career progression roadmap.\",\"icon\":\"fa-bullseye\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p5_t1\",\"title\":\"Review Independent Contractor Job Description, KPIs & 90-Day Goals\",\"completed\":false},{\"id\":\"p5_t2\",\"title\":\"Schedule bi-weekly 1-on-1 check-ins with manager\",\"completed\":false},{\"id\":\"p5_t3\",\"title\":\"Establish individualized Career Advancement Roadmap\",\"completed\":false}],\"documents\":[{\"id\":\"p5_d1\",\"name\":\"Role Specifications & KPI Performance Matrix.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p5_f1\",\"title\":\"Job Expectations & 90-Day Goals Agreement\",\"fields\":[{\"name\":\"primary_goal_1\",\"label\":\"30-Day Key Objective\",\"type\":\"text\",\"required\":true},{\"name\":\"primary_goal_2\",\"label\":\"60-Day Key Objective\",\"type\":\"text\",\"required\":true},{\"name\":\"kpi_acceptance\",\"label\":\"I understand my role KPIs and agree to meet performance benchmarks\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"6\":{\"phase_number\":6,\"title\":\"Benefits and HR Policies\",\"description\":\"Benefits enrollment, health & retirement packages, PTO, dress code & HR Q&A.\",\"icon\":\"fa-hand-holding-heart\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p6_t1\",\"title\":\"Review Employee Benefits Package (Medical, Dental, Vision, 401k)\",\"completed\":false},{\"id\":\"p6_t2\",\"title\":\"Review Attendance, Time Off (PTO), and Dress Code Policies\",\"completed\":false},{\"id\":\"p6_t3\",\"title\":\"Complete HR Q&A session & submit policy acknowledgment\",\"completed\":false}],\"documents\":[{\"id\":\"p6_d1\",\"name\":\"Full Employee Benefits Guide & Plan Summary.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"},{\"id\":\"p6_d2\",\"name\":\"Employee Handbook & HR Policies 2026.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p6_f1\",\"title\":\"HR Policies & Benefits Acknowledgment Sign-Off\",\"fields\":[{\"name\":\"benefit_plan_selection\",\"label\":\"Benefits Plan Selection\",\"type\":\"select\",\"options\":[\"Full Coverage Plan A\",\"Standard Plan B\",\"Waive Coverage \\/ Other Provider\"],\"required\":true},{\"name\":\"policy_handbook_ack\",\"label\":\"I have read and agree to comply with all employee handbook & attendance policies\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"7\":{\"phase_number\":7,\"title\":\"Ongoing Support\",\"description\":\"30\\/60\\/90-day review milestones, feedback loops, stress & work-life balance resources.\",\"icon\":\"fa-comments\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p7_t1\",\"title\":\"Schedule 30-Day Check-in Meeting with HR & Leadership\",\"completed\":false},{\"id\":\"p7_t2\",\"title\":\"Complete 30-Day Onboarding Satisfaction & Feedback Survey\",\"completed\":false},{\"id\":\"p7_t3\",\"title\":\"Access Employee Wellness & Work-Life Balance Assistance Programs\",\"completed\":false}],\"documents\":[{\"id\":\"p7_d1\",\"name\":\"Employee Wellness & Mental Health Support Program.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":false,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p7_f1\",\"title\":\"30-Day Onboarding Feedback & Experience Review\",\"fields\":[{\"name\":\"onboarding_rating\",\"label\":\"Overall Onboarding Experience (1 to 10)\",\"type\":\"number\",\"required\":true},{\"name\":\"feedback_comments\",\"label\":\"What can we improve about your onboarding journey?\",\"type\":\"textarea\",\"required\":false}],\"requires_signature\":false,\"submitted\":false}}}',NULL,NULL,NULL,'[]','[]',NULL,NULL,NULL,'2026-08-20 14:02:47','2026-08-20 14:02:47'),(5,10,1,'EMP-7154','Test Vendor','test.vendor@signalhg.com',NULL,NULL,NULL,'vendor',NULL,'Pending',2,NULL,NULL,NULL,'{\"1\":{\"phase_number\":1,\"title\":\"Pre-Arrival Preparation\",\"description\":\"Welcome email, schedule, mentor assignment, and workspace credentials.\",\"icon\":\"fa-envelope-open-text\",\"status\":\"In Progress\",\"tasks\":[{\"id\":\"p1_t1\",\"title\":\"Send welcome packet & onboarding schedule to Test Vendor\",\"completed\":true,\"completed_at\":\"2026-08-20 14:02:47\"},{\"id\":\"p1_t2\",\"title\":\"Assign peer mentor \\/ buddy to navigate initial onboarding\",\"completed\":false},{\"id\":\"p1_t3\",\"title\":\"Prepare workstation, IT login credentials & software permissions\",\"completed\":false},{\"id\":\"p1_t4\",\"title\":\"Issue employee badge \\/ security access pass\",\"completed\":false}],\"documents\":[{\"id\":\"p1_d1\",\"name\":\"Official Welcome Handbook & First Week Roadmap.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"},{\"id\":\"p1_d2\",\"name\":\"Direct Deposit \\/ Payment Authorization Form.pdf\",\"file_path\":\"\",\"type\":\"form\",\"required\":true,\"status\":\"Pending Upload\"}],\"videos\":[{\"id\":\"p1_v1\",\"title\":\"Welcome to Signal Health Group: Mission, Heritage & Culture\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/dQw4w9WgXcQ\",\"duration\":\"5 mins\",\"completed\":false}],\"form\":{\"id\":\"p1_f1\",\"title\":\"Emergency Contact & IT Equipment Agreement\",\"fields\":[{\"name\":\"emergency_contact_name\",\"label\":\"Emergency Contact Full Name\",\"type\":\"text\",\"required\":true},{\"name\":\"emergency_contact_phone\",\"label\":\"Emergency Contact Phone Number\",\"type\":\"tel\",\"required\":true},{\"name\":\"emergency_contact_relation\",\"label\":\"Relationship\",\"type\":\"text\",\"required\":true},{\"name\":\"laptop_serial_ack\",\"label\":\"I acknowledge receipt of IT equipment & agree to security guidelines\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"2\":{\"phase_number\":2,\"title\":\"Day 1: Orientation\",\"description\":\"Personal welcome, facility tour, company mission, values & team introductions.\",\"icon\":\"fa-door-open\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p2_t1\",\"title\":\"Personal welcome meeting with department head & facility tour\",\"completed\":false},{\"id\":\"p2_t2\",\"title\":\"Orientation session: Company Mission, Core Values, and Code of Conduct\",\"completed\":false},{\"id\":\"p2_t3\",\"title\":\"Team introductions & introductory 1-on-1 syncs\",\"completed\":false}],\"documents\":[{\"id\":\"p2_d1\",\"name\":\"Company Organization Chart & Team Directory.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":false,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p2_v1\",\"title\":\"Executive Leadership Orientation & Values Walkthrough\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/ScMzIvxBSi4\",\"duration\":\"8 mins\",\"completed\":false}],\"form\":{\"id\":\"p2_f1\",\"title\":\"Day 1 Orientation Acknowledgment Form\",\"fields\":[{\"name\":\"orientation_attended_date\",\"label\":\"Date Orientation Attended\",\"type\":\"date\",\"required\":true},{\"name\":\"facility_safety_tour_done\",\"label\":\"I have completed the facility safety & emergency exit walkthrough\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"3\":{\"phase_number\":3,\"title\":\"Training and Development\",\"description\":\"Software & Electronic Health Record (EHR) mastery, shadowing, and online workshops.\",\"icon\":\"fa-graduation-cap\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p3_t1\",\"title\":\"Complete EHR software simulation & clinical documentation modules\",\"completed\":false},{\"id\":\"p3_t2\",\"title\":\"Participate in 2 days of senior staff shadowing & live workflow reviews\",\"completed\":false},{\"id\":\"p3_t3\",\"title\":\"Complete Continuous Learning Workshop #1\",\"completed\":false}],\"documents\":[{\"id\":\"p3_d1\",\"name\":\"Software User Manual & EHR Quick Reference Guide.pdf\",\"file_path\":\"\",\"type\":\"manual\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p3_v1\",\"title\":\"EHR & Clinical Documentation Workflow Training\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/kJQP7kiw5Fk\",\"duration\":\"12 mins\",\"completed\":false}],\"form\":{\"id\":\"p3_f1\",\"title\":\"Software Competency & Shadowing Sign-Off\",\"fields\":[{\"name\":\"software_certified_by\",\"label\":\"Trainer \\/ Lead Name\",\"type\":\"text\",\"required\":true},{\"name\":\"shadowing_hours_completed\",\"label\":\"Total Shadowing Hours Completed\",\"type\":\"number\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"4\":{\"phase_number\":4,\"title\":\"Compliance and Certification\",\"description\":\"HIPAA compliance, certifications, state licensure verification & compliance sign-offs.\",\"icon\":\"fa-file-shield\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p4_t1\",\"title\":\"Complete mandatory HIPAA Privacy & Patient Confidentiality Training\",\"completed\":false},{\"id\":\"p4_t2\",\"title\":\"Upload copy of current State License \\/ CPR \\/ Certifications\",\"completed\":false},{\"id\":\"p4_t3\",\"title\":\"Sign Corporate Compliance & Anti-Fraud Acknowledgment\",\"completed\":false}],\"documents\":[{\"id\":\"p4_d1\",\"name\":\"State Professional License \\/ Certification Upload\",\"file_path\":\"\",\"type\":\"upload\",\"required\":true,\"status\":\"Pending Upload\"},{\"id\":\"p4_d2\",\"name\":\"HIPAA Compliance Policy & Guidelines.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[{\"id\":\"p4_v1\",\"title\":\"HIPAA Compliance & Protected Health Information (PHI) Security\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/L_LUpnjgPso\",\"duration\":\"10 mins\",\"completed\":false}],\"form\":{\"id\":\"p4_f1\",\"title\":\"HIPAA & Compliance Agreement Sign-Off\",\"fields\":[{\"name\":\"license_number\",\"label\":\"Professional License Number (if applicable)\",\"type\":\"text\",\"required\":false},{\"name\":\"license_expiry\",\"label\":\"License Expiration Date\",\"type\":\"date\",\"required\":false},{\"name\":\"hipaa_pledge\",\"label\":\"I solemnly pledge to safeguard all Protected Health Information (PHI) under federal law\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"5\":{\"phase_number\":5,\"title\":\"Role-Specific Onboarding\",\"description\":\"Job KPIs, performance expectations, feedback schedule & career progression roadmap.\",\"icon\":\"fa-bullseye\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p5_t1\",\"title\":\"Review Vendor Partner Job Description, KPIs & 90-Day Goals\",\"completed\":false},{\"id\":\"p5_t2\",\"title\":\"Schedule bi-weekly 1-on-1 check-ins with manager\",\"completed\":false},{\"id\":\"p5_t3\",\"title\":\"Establish individualized Career Advancement Roadmap\",\"completed\":false}],\"documents\":[{\"id\":\"p5_d1\",\"name\":\"Role Specifications & KPI Performance Matrix.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p5_f1\",\"title\":\"Job Expectations & 90-Day Goals Agreement\",\"fields\":[{\"name\":\"primary_goal_1\",\"label\":\"30-Day Key Objective\",\"type\":\"text\",\"required\":true},{\"name\":\"primary_goal_2\",\"label\":\"60-Day Key Objective\",\"type\":\"text\",\"required\":true},{\"name\":\"kpi_acceptance\",\"label\":\"I understand my role KPIs and agree to meet performance benchmarks\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"6\":{\"phase_number\":6,\"title\":\"Benefits and HR Policies\",\"description\":\"Benefits enrollment, health & retirement packages, PTO, dress code & HR Q&A.\",\"icon\":\"fa-hand-holding-heart\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p6_t1\",\"title\":\"Review Employee Benefits Package (Medical, Dental, Vision, 401k)\",\"completed\":false},{\"id\":\"p6_t2\",\"title\":\"Review Attendance, Time Off (PTO), and Dress Code Policies\",\"completed\":false},{\"id\":\"p6_t3\",\"title\":\"Complete HR Q&A session & submit policy acknowledgment\",\"completed\":false}],\"documents\":[{\"id\":\"p6_d1\",\"name\":\"Full Employee Benefits Guide & Plan Summary.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"},{\"id\":\"p6_d2\",\"name\":\"Employee Handbook & HR Policies 2026.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":true,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p6_f1\",\"title\":\"HR Policies & Benefits Acknowledgment Sign-Off\",\"fields\":[{\"name\":\"benefit_plan_selection\",\"label\":\"Benefits Plan Selection\",\"type\":\"select\",\"options\":[\"Full Coverage Plan A\",\"Standard Plan B\",\"Waive Coverage \\/ Other Provider\"],\"required\":true},{\"name\":\"policy_handbook_ack\",\"label\":\"I have read and agree to comply with all employee handbook & attendance policies\",\"type\":\"checkbox\",\"required\":true}],\"requires_signature\":true,\"submitted\":false}},\"7\":{\"phase_number\":7,\"title\":\"Ongoing Support\",\"description\":\"30\\/60\\/90-day review milestones, feedback loops, stress & work-life balance resources.\",\"icon\":\"fa-comments\",\"status\":\"Pending\",\"tasks\":[{\"id\":\"p7_t1\",\"title\":\"Schedule 30-Day Check-in Meeting with HR & Leadership\",\"completed\":false},{\"id\":\"p7_t2\",\"title\":\"Complete 30-Day Onboarding Satisfaction & Feedback Survey\",\"completed\":false},{\"id\":\"p7_t3\",\"title\":\"Access Employee Wellness & Work-Life Balance Assistance Programs\",\"completed\":false}],\"documents\":[{\"id\":\"p7_d1\",\"name\":\"Employee Wellness & Mental Health Support Program.pdf\",\"file_path\":\"\",\"type\":\"guide\",\"required\":false,\"status\":\"Available for Download\"}],\"videos\":[],\"form\":{\"id\":\"p7_f1\",\"title\":\"30-Day Onboarding Feedback & Experience Review\",\"fields\":[{\"name\":\"onboarding_rating\",\"label\":\"Overall Onboarding Experience (1 to 10)\",\"type\":\"number\",\"required\":true},{\"name\":\"feedback_comments\",\"label\":\"What can we improve about your onboarding journey?\",\"type\":\"textarea\",\"required\":false}],\"requires_signature\":false,\"submitted\":false}}}',NULL,NULL,NULL,'[]','[]',NULL,NULL,NULL,'2026-08-20 14:02:47','2026-08-20 14:02:47');
/*!40000 ALTER TABLE `onboarding_records` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_reset_tokens`
--

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('0H214SzoetVJuA6rPKUQ4wTUXrdn2LUt7x6HaiaF',NULL,'43.153.58.28','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','eyJfdG9rZW4iOiJSUFA3cUxHRUgyYVI4d3R4VmRQTkE1cmlkT2QzenVkSGlrY0pnUnRsIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL3d3dy5zaWduYWxjYXJlZXJjb21wYXNzLmlvIiwicm91dGUiOiJsYW5kaW5nIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1787343467),('9vOrG3hGsRHDsSEVogyR4ENGDhXy5RQ7B9tOl137',NULL,'169.58.45.73','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJ4anQ2MTJKS3hUUUpUSUpUMWpVV1ByU0NCcUVrNU1hYUREYXhISHBGIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9zaWduYWxjYXJlZXJjb21wYXNzLmlvIiwicm91dGUiOiJsYW5kaW5nIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1787347124),('aeXNmPVaRMeCr5uWe5KDuWczcfjhttAvsa8W1hLo',NULL,'52.167.144.204','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36','eyJfdG9rZW4iOiJ6M0Q1MmRRTzlzR1FUblhyVWlxVnl4SGZtZGlDalhKQnBDaWhPYk5WIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9zaWduYWxjYXJlZXJjb21wYXNzLmlvIiwicm91dGUiOiJsYW5kaW5nIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1787344168),('bPYvkLFVDFN82QZb2GKzgRd6SS4kaTV0P6d6LQmm',NULL,'34.34.225.253','DomainPublicationMonitor/1.0 (+homepage availability check)','eyJfdG9rZW4iOiJ0M1pGMTJWZUt6TEdCUk1FSVZrTXhvYTdtdVFkTHZEa0NyZ2ExYlFkIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9zaWduYWxjYXJlZXJjb21wYXNzLmlvIiwicm91dGUiOiJsYW5kaW5nIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1787334961),('BweJOOqEjEOxbQONkbE6LZeH8xPqofIyxsZXO8zA',NULL,'43.157.147.3','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','eyJfdG9rZW4iOiJCbmN2aHlIN0ttNTAzQkZmTTVVN1VlT2NqNFJxWXNWaTVwcUVuMk9QIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL3NpZ25hbGNhcmVlcmNvbXBhc3MuaW8iLCJyb3V0ZSI6ImxhbmRpbmcifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1787341310),('C8LdB2OvrvhBLFj8lDcauO7DqC54Ufk1b6kkhJ3x',NULL,'34.96.49.87','DomainPublicationMonitor/1.0 (+homepage availability check)','eyJfdG9rZW4iOiJCalRFcFBmS2x4OWZXWXZxeTJaVnVZWENlVzdudUk4OThJTDBjdVhNIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9zaWduYWxjYXJlZXJjb21wYXNzLmlvIiwicm91dGUiOiJsYW5kaW5nIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1787334727),('hqr3qQRqZgZN0sBCxblpgQvefeWLYANzf5vVKdGJ',NULL,'43.153.71.132','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','eyJfdG9rZW4iOiJvdDJqcWs0TThQT1Bta05GMklGdDVFTXA0WmI5Y1E0SDVvY3lPUGZnIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL3NpZ25hbGNhcmVlcmNvbXBhc3MuaW8iLCJyb3V0ZSI6ImxhbmRpbmcifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1787342999),('HUqitcwGP4dxwfY8kpFKUhO39wz40ryVQwPbPVEo',NULL,'43.153.135.208','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','eyJfdG9rZW4iOiJRclNKMGIyMHdSSGIwTkFUUDB3c2ZoQVFObnY0clNpd0MzM0RDWjAxIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL3d3dy5zaWduYWxjYXJlZXJjb21wYXNzLmlvIiwicm91dGUiOiJsYW5kaW5nIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1787347787),('jiuf7LAT0CrIcPrEX1BnzZ86IRkjHcPoNKIDEEFC',1,'127.0.0.1','Symfony','eyJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MSwiX3Rva2VuIjoidGVmbFJRZkZEVXpnbzBJZ3Q2aTlzdnRCN2pOMHc4OG5HSWtHMjhKeSIsIl9wcmV2aW91cyI6eyJ1cmwiOiJodHRwOlwvXC9sb2NhbGhvc3RcL2VudGVycHJpc2VcL29uYm9hcmRpbmciLCJyb3V0ZSI6ImVudGVycHJpc2Uub25ib2FyZGluZyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19',1787348510),('LkB2PAyUfkQSJ6uY76A3ViKuLTXgNf8ugzScwOMX',1,'127.0.0.1','Symfony','eyJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MSwiX3Rva2VuIjoiTzZtOExJcWpjYWViek4yWFVHVFRNcFc2WnFQcE5ycjI4Mkp1OW5HdyIsIl9wcmV2aW91cyI6eyJ1cmwiOiJodHRwOlwvXC9sb2NhbGhvc3RcL2VudGVycHJpc2VcL29uYm9hcmRpbmciLCJyb3V0ZSI6ImVudGVycHJpc2Uub25ib2FyZGluZyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19',1787348358),('mkbeMMv76mStjRPKVjVUOPhfofbp14xVK6Wa8i8d',10,'127.0.0.1','Symfony','eyJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MTAsIl90b2tlbiI6ImNFcFBXWDZTNG9zaFhHaW5qUThuWnh1dXVZamhseUVvVDY3SVBwOW4iLCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9zZWVrZXJcL29uYm9hcmRpbmdcL2NlcnRpZmljYXRlIiwicm91dGUiOiJzZWVrZXIub25ib2FyZGluZy5jZXJ0aWZpY2F0ZSJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19',1787348556),('RVPNF6MYZLG3QY50PuKPVnhTGIlaeF2P20UU7ZI8',10,'127.0.0.1','Symfony','eyJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MTAsIl90b2tlbiI6InBGOWJuOHRNMTdGWENqUDBLc25XZjN5ZmlQYXNiTEMwSXhTaUVSaFUiLCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9zZWVrZXJcL29uYm9hcmRpbmciLCJyb3V0ZSI6InNlZWtlci5vbmJvYXJkaW5nIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1787348510),('tJSrL229q0D0xo8ABTloFMRIjT0LmRmWDTdkUjtD',10,'157.20.150.11','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJkOEd4TVJRaGFuaVQyUHZwU0hwVFMzMmg5QUtiYzRrWXFiZ3RzT0d5IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9zaWduYWxjYXJlZXJjb21wYXNzLmlvXC9zZWVrZXJcL29uYm9hcmRpbmdcL2NlcnRpZmljYXRlXC81Iiwicm91dGUiOiJzZWVrZXIub25ib2FyZGluZy5jZXJ0aWZpY2F0ZSJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjoxMH0=',1787348920),('uojSiVfMCWLkJqNUYP4UWk4vqeaBUaJ67T9jX2rN',10,'127.0.0.1','Symfony','eyJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MTAsIl90b2tlbiI6IllLWGFFT1Bva0NKTzl6QmZ2UnNjRExoYkNZNWJoNGc5Z2ltWHpCVXMiLCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9zZWVrZXJcL29uYm9hcmRpbmciLCJyb3V0ZSI6InNlZWtlci5vbmJvYXJkaW5nIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1787348358),('Wf44JAN88biiBpYPl5ty8PANxVwtFimuzlOdvYIp',10,'127.0.0.1','Symfony','eyJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MTAsIl90b2tlbiI6InBCV2ZCTk1JNUFvR0Z4VFlLUGp2R0ZQZ2VNUjZPbDIyUmEzUlBOZmUiLCJzdWNjZXNzIjoiRm9ybSAmIExlZ2FsIEUtU2lnbmF0dXJlIGZvciBQaGFzZSAxIHN1Ym1pdHRlZCBhbmQgYXJjaGl2ZWQgaW4gb3JnYW5pemF0aW9uIGRhdGFiYXNlISIsIl9mbGFzaCI6eyJuZXciOltdLCJvbGQiOlsic3VjY2VzcyJdfX0=',1787348531),('WUKA2Qz0bMq0QlQq6kIcDTTg2mqyeJNsvcQPNVKY',NULL,'52.167.144.193','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36','eyJfdG9rZW4iOiJsZDFBVXVMVzAwQkw2U1JicmlQaFRUakN3ckhvNU90NE43SFVSc3VHIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9zaWduYWxjYXJlZXJjb21wYXNzLmlvIiwicm91dGUiOiJsYW5kaW5nIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1787336456),('y2rLIAjFHVTWy0WnNBa8K0zOnZWuXFOpNceJi7d2',10,'157.20.150.11','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJzSTZ2NEtQZDN5MDd0TmwzSWozd3JCbjRoTHBsYk16OHpFOXZ4UHN3IiwidXJsIjp7ImludGVuZGVkIjoiaHR0cHM6XC9cL3NpZ25hbGNhcmVlcmNvbXBhc3MuaW9cL3NlZWtlclwvb25ib2FyZGluZyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sIl9wcmV2aW91cyI6eyJ1cmwiOiJodHRwczpcL1wvc2lnbmFsY2FyZWVyY29tcGFzcy5pb1wvc2Vla2VyXC9vbmJvYXJkaW5nXC9jZXJ0aWZpY2F0ZVwvNSIsInJvdXRlIjoic2Vla2VyLm9uYm9hcmRpbmcuY2VydGlmaWNhdGUifSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjEwfQ==',1787348721);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `social_comments`
--

DROP TABLE IF EXISTS `social_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `social_comments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `social_post_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `text` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `social_comments_social_post_id_foreign` (`social_post_id`),
  KEY `social_comments_user_id_foreign` (`user_id`),
  KEY `social_comments_parent_id_foreign` (`parent_id`),
  CONSTRAINT `social_comments_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `social_comments` (`id`) ON DELETE SET NULL,
  CONSTRAINT `social_comments_social_post_id_foreign` FOREIGN KEY (`social_post_id`) REFERENCES `social_posts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `social_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `social_comments`
--

LOCK TABLES `social_comments` WRITE;
/*!40000 ALTER TABLE `social_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `social_comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `social_posts`
--

DROP TABLE IF EXISTS `social_posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `social_posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `text` text NOT NULL,
  `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`tags`)),
  `media` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`media`)),
  `likes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`likes`)),
  `saved_by` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`saved_by`)),
  `reports` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`reports`)),
  `shares` int(11) NOT NULL DEFAULT 0,
  `author_name` varchar(255) DEFAULT NULL,
  `author_email` varchar(255) DEFAULT NULL,
  `author_type` enum('organization','seeker') NOT NULL DEFAULT 'seeker',
  `organization_name` varchar(255) DEFAULT NULL,
  `visibility` varchar(255) NOT NULL DEFAULT 'public',
  `post_type` varchar(255) NOT NULL DEFAULT 'post',
  `title` varchar(255) DEFAULT NULL,
  `link_url` varchar(255) DEFAULT NULL,
  `link_label` varchar(255) DEFAULT NULL,
  `event_starts_at` timestamp NULL DEFAULT NULL,
  `event_location` varchar(255) DEFAULT NULL,
  `is_promoted` tinyint(1) NOT NULL DEFAULT 0,
  `promoted_until` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `social_posts_user_id_foreign` (`user_id`),
  KEY `social_posts_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `social_posts_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE SET NULL,
  CONSTRAINT `social_posts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `social_posts`
--

LOCK TABLES `social_posts` WRITE;
/*!40000 ALTER TABLE `social_posts` DISABLE KEYS */;
/*!40000 ALTER TABLE `social_posts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tenants`
--

DROP TABLE IF EXISTS `tenants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tenants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `domain` varchar(255) DEFAULT NULL,
  `owner_name` varchar(255) DEFAULT NULL,
  `owner_email` varchar(255) DEFAULT NULL,
  `admin_email` varchar(255) DEFAULT NULL,
  `theme_color` varchar(255) NOT NULL DEFAULT '#0284c7',
  `sidebar_color` varchar(255) NOT NULL DEFAULT '#f1f5f9',
  `logo_url` text DEFAULT NULL,
  `status` enum('Active','Pending','Suspended') NOT NULL DEFAULT 'Pending',
  `license_tier` varchar(255) NOT NULL DEFAULT 'Enterprise',
  `royalty_rate` decimal(5,2) NOT NULL DEFAULT 6.50,
  `monthly_billing` decimal(10,2) NOT NULL DEFAULT 0.00,
  `password` varchar(255) DEFAULT NULL,
  `features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`features`)),
  `company_profile` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`company_profile`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tenants`
--

LOCK TABLES `tenants` WRITE;
/*!40000 ALTER TABLE `tenants` DISABLE KEYS */;
INSERT INTO `tenants` VALUES (1,'Signal Health Group','signalcareercompass.io','Super Administrator','info@signalhg.com','info@signalhg.com','#0284c7','#f1f5f9',NULL,'Active','Enterprise',6.50,0.00,NULL,'{\"Resume Builder\":true,\"Mock Exams\":true,\"University Sync\":true,\"Pathway Predictor\":true,\"Application Screening\":true,\"Meeting Automation\":true}',NULL,'2026-08-15 21:48:55','2026-08-20 14:10:55');
/*!40000 ALTER TABLE `tenants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `training_videos`
--

DROP TABLE IF EXISTS `training_videos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `training_videos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `duration` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `category` varchar(255) NOT NULL DEFAULT 'General',
  `source_type` varchar(255) NOT NULL DEFAULT 'youtube',
  `thumbnail_url` varchar(255) DEFAULT NULL,
  `assigned_departments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`assigned_departments`)),
  `assigned_user_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`assigned_user_ids`)),
  `auto_complete_percent` int(11) NOT NULL DEFAULT 95,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `training_videos_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `training_videos_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `training_videos`
--

LOCK TABLES `training_videos` WRITE;
/*!40000 ALTER TABLE `training_videos` DISABLE KEYS */;
/*!40000 ALTER TABLE `training_videos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `universities`
--

DROP TABLE IF EXISTS `universities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `universities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `logo` text DEFAULT NULL,
  `courses_count` int(11) NOT NULL DEFAULT 0,
  `sync_status` varchar(255) NOT NULL DEFAULT 'Disconnected',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `universities_tenant_id_foreign` (`tenant_id`),
  CONSTRAINT `universities_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `universities`
--

LOCK TABLES `universities` WRITE;
/*!40000 ALTER TABLE `universities` DISABLE KEYS */;
/*!40000 ALTER TABLE `universities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_integrations`
--

DROP TABLE IF EXISTS `user_integrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_integrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `provider` varchar(50) NOT NULL,
  `access_token` text DEFAULT NULL,
  `refresh_token` text DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `account_email` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_provider_unique` (`user_id`,`provider`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_integrations`
--

LOCK TABLES `user_integrations` WRITE;
/*!40000 ALTER TABLE `user_integrations` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_integrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('super-admin','tenant-admin','recruiter','seeker','employee') NOT NULL DEFAULT 'seeker',
  `tenant_id` bigint(20) unsigned DEFAULT NULL,
  `custom_role_id` bigint(20) unsigned DEFAULT NULL,
  `avatar_url` text DEFAULT NULL,
  `banner_url` text DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `headline` varchar(255) DEFAULT NULL,
  `about` text DEFAULT NULL,
  `website_url` varchar(255) DEFAULT NULL,
  `linkedin_url` varchar(255) DEFAULT NULL,
  `portfolio_url` varchar(255) DEFAULT NULL,
  `profile_theme` varchar(255) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `banned_at` timestamp NULL DEFAULT NULL,
  `banned_reason` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_custom_role_id_foreign` (`custom_role_id`),
  CONSTRAINT `users_custom_role_id_foreign` FOREIGN KEY (`custom_role_id`) REFERENCES `custom_roles` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Super Administrator','info@signalhg.com','2026-08-15 21:48:55','$2y$12$FyvhDK550kwt8At/MvavkONq3EFpH56OibL59ljrAe4IJ7VaM.uyu','super-admin',1,NULL,'/brand/logo-Photoroom.png',NULL,NULL,'Platform Owner',NULL,'Signal Career Compass Super Admin','Full platform administrator for Signal Career Compass.',NULL,NULL,NULL,NULL,'20UEVYLEAdjBS02GZYPSiqdsajEO3wUkUChoZD5HPcYTFraZScS5eztiJGQr',NULL,NULL,'2026-08-15 21:48:55','2026-08-17 21:36:49'),(10,'support','support@signalhg.com',NULL,'$2y$12$/kw0Minhb30HOvBp6pFFuO32aIX8UNTjSBIGT7GwZ3vcTy/GCCcaK','seeker',NULL,NULL,NULL,NULL,NULL,'Software Engineer',NULL,'Software Engineer • 3-5 years',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-17 20:44:03','2026-08-17 21:37:15');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-08-21 22:14:27

User Profile – Signal Health Group of Southern Wisconsin

User Profile

[em_profile]

Code Editor : db-20260821-221415.sql

User Profile

Quick Links

Signal Health Group

Useful Links

${this.title}

Code Editor : db-20260821-221415.sql

Quick Links

Signal Health Group

Useful Links