-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Sep 09, 2025 at 02:29 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `dt_streetvoice`
--

-- --------------------------------------------------------

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE `tbl_admin` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`id`, `user_name`, `email`, `password`, `status`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'admin@admin.com', '$2y$10$8Vu4kTP/ye4Rd6pvg/fJv.6z.SovMJ0B0DtTrvwMrgfsDkroXGRTK', 1, '2023-07-27 04:17:38', '2024-12-03 06:49:34');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_comment`
--

CREATE TABLE `tbl_comment` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `complaint_id` int(11) NOT NULL,
  `comment` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_company`
--

CREATE TABLE `tbl_company` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `country_code` varchar(255) NOT NULL,
  `mobile_number` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `area` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `pincode` varchar(255) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `activity` text NOT NULL,
  `position` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_complaint`
--

CREATE TABLE `tbl_complaint` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `department_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `sub_in_charge_id` int(11) NOT NULL,
  `hashtag_id` varchar(255) NOT NULL,
  `complaint_info` text NOT NULL,
  `complaint_reply` text NOT NULL,
  `address` varchar(255) NOT NULL,
  `area` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `pincode` varchar(255) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `total_like` int(11) NOT NULL,
  `total_dislike` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '1- Open, 2- In Progress,3-Archived, 4- Completed',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_complaint_img`
--

CREATE TABLE `tbl_complaint_img` (
  `id` int(11) UNSIGNED NOT NULL,
  `complaint_id` int(11) NOT NULL,
  `type` int(11) NOT NULL COMMENT '1-Before,2-After',
  `content_type` int(11) NOT NULL COMMENT '1-Image,2-Video,3-Audio',
  `content_url` varchar(255) NOT NULL,
  `thumbnail_image` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_department`
--

CREATE TABLE `tbl_department` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `country_code` varchar(255) NOT NULL,
  `mobile_number` varchar(255) NOT NULL,
  `telephone_number` varchar(255) NOT NULL,
  `department_color` varchar(255) NOT NULL,
  `department_icon` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `area` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `pincode` varchar(255) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '0-Hide,1-Show',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_department_working_time`
--

CREATE TABLE `tbl_department_working_time` (
  `id` int(11) UNSIGNED NOT NULL,
  `department_id` int(11) NOT NULL,
  `week_day` varchar(255) NOT NULL,
  `start_time` varchar(255) NOT NULL,
  `end_time` varchar(255) NOT NULL,
  `status` int(11) NOT NULL COMMENT '0- OFF, 1- ON',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_general_setting`
--

CREATE TABLE `tbl_general_setting` (
  `id` int(11) UNSIGNED NOT NULL,
  `key` text NOT NULL,
  `value` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_general_setting`
--

INSERT INTO `tbl_general_setting` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'app_name', 'DTStreetVoice', '2025-06-05 06:39:01', '2025-08-18 12:10:36'),
(2, 'app_version', '1.0', '2025-06-05 06:39:01', '2025-09-09 12:17:18'),
(3, 'app_logo', '', '2025-06-05 06:39:01', '2025-09-09 12:14:02'),
(4, 'app_description', 'Divinetechs is an IT company specializing in providing technology solutions and services. The company likely focuses on various aspects of IT, such as software development, web and mobile app development, IT consulting, cloud solutions, and possibly more. Divinetechs aims to leverage technology to drive business growth and efficiency for its clients, offering innovative and customized solutions tailored to meet specific business needs.', '2025-06-05 06:39:01', '2025-09-09 12:17:18'),
(5, 'author', 'DivineTechs', '2025-06-05 06:39:01', '2025-06-11 00:41:29'),
(6, 'email', 'support@divinetechs.com', '2025-06-05 06:39:01', '2025-09-09 12:17:18'),
(7, 'contact', '+91917984798190', '2025-06-05 06:39:01', '2025-09-09 12:17:18'),
(8, 'website', 'https://www.divinetechs.com/', '2025-06-05 06:39:01', '2025-09-09 12:17:18'),
(9, 'currency', 'USD', '2025-06-05 06:39:01', '2025-06-12 07:16:32'),
(10, 'currency_code', '$', '2025-06-05 06:39:01', '2025-06-12 07:16:32'),
(11, 'admob_status', '0', '2025-06-05 06:42:24', '2025-08-05 05:09:51'),
(12, 'banner_ad', '0', '2025-06-05 06:42:24', '2025-08-05 05:14:54'),
(13, 'banner_adid', '', '2025-06-05 06:42:24', '2025-08-05 05:14:54'),
(14, 'interstital_ad', '0', '2025-06-05 06:42:24', '2025-08-05 05:14:54'),
(15, 'interstital_adid', '', '2025-06-05 06:42:24', '2025-08-05 05:14:54'),
(16, 'interstital_adclick', '', '2025-06-05 06:42:24', '2025-08-05 05:14:54'),
(17, 'reward_ad', '0', '2025-06-05 06:42:24', '2025-08-05 05:14:54'),
(18, 'reward_adid', '', '2025-06-05 06:42:24', '2025-08-05 05:14:54'),
(19, 'reward_adclick', '', '2025-06-05 06:42:24', '2025-08-05 05:14:54'),
(20, 'ios_banner_ad', '0', '2025-06-05 06:42:24', '2025-08-05 05:15:05'),
(21, 'ios_banner_adid', '', '2025-06-05 06:42:24', '2025-08-05 05:15:05'),
(22, 'ios_interstital_ad', '0', '2025-06-05 06:42:24', '2025-08-05 05:15:05'),
(23, 'ios_interstital_adid', '', '2025-06-05 06:42:24', '2025-08-05 05:15:05'),
(24, 'ios_interstital_adclick', '', '2025-06-05 06:42:24', '2025-08-05 05:15:05'),
(25, 'ios_reward_ad', '0', '2025-06-05 06:42:24', '2025-08-05 05:15:05'),
(26, 'ios_reward_adid', '', '2025-06-05 08:51:43', '2025-08-05 05:15:05'),
(27, 'ios_reward_adclick', '', '2025-06-05 08:51:43', '2025-08-05 05:15:05'),
(28, 'facebook_ads_status', '0', '2025-06-05 08:53:48', '2025-09-09 12:15:02'),
(29, 'fb_native_status', '0', '2025-06-05 08:53:48', '2025-08-05 05:36:28'),
(30, 'fb_native_id', '', '2025-06-05 08:53:48', '2025-08-05 05:36:28'),
(31, 'fb_banner_status', '0', '2025-06-05 08:53:48', '2025-08-05 05:36:28'),
(32, 'fb_banner_id', '', '2025-06-05 08:53:48', '2025-08-05 05:36:28'),
(33, 'fb_interstiatial_status', '0', '2025-06-05 08:53:48', '2025-08-05 05:36:28'),
(34, 'fb_interstiatial_id', '', '2025-06-05 08:53:48', '2025-08-05 05:36:28'),
(35, 'fb_rewardvideo_status', '0', '2025-06-05 08:53:48', '2025-08-05 05:36:28'),
(36, 'fb_rewardvideo_id', '', '2025-06-05 08:53:48', '2025-08-05 05:36:28'),
(37, 'fb_native_full_status', '0', '2025-06-05 08:53:48', '2025-08-05 05:36:28'),
(38, 'fb_native_full_id', '', '2025-06-05 08:53:48', '2025-08-05 05:36:28'),
(39, 'fb_ios_native_status', '0', '2025-06-05 09:00:42', '2025-08-05 05:36:52'),
(40, 'fb_ios_native_id', '', '2025-06-05 09:00:42', '2025-08-05 05:36:52'),
(41, 'fb_ios_banner_status', '0', '2025-06-05 09:00:42', '2025-08-05 05:36:52'),
(42, 'fb_ios_banner_id', '', '2025-06-05 09:00:42', '2025-08-05 05:36:52'),
(43, 'fb_ios_interstiatial_status', '0', '2025-06-05 09:00:42', '2025-08-05 05:36:52'),
(44, 'fb_ios_interstiatial_id', '', '2025-06-05 09:00:42', '2025-08-05 05:36:52'),
(45, 'fb_ios_rewardvideo_status', '0', '2025-06-05 09:00:42', '2025-08-05 05:36:52'),
(46, 'fb_ios_rewardvideo_id', '', '2025-06-05 09:00:42', '2025-08-05 05:36:52'),
(47, 'fb_ios_native_full_status', '0', '2025-06-05 09:00:42', '2025-08-05 05:36:52'),
(48, 'fb_ios_native_full_id', '', '2025-06-05 09:00:42', '2025-08-05 05:36:52'),
(49, 'page_background_color', '#000000', '2025-06-05 09:01:45', '2025-06-05 09:01:45'),
(50, 'page_title_color', '#ffffff', '2025-06-05 09:01:45', '2025-06-05 09:01:45'),
(51, 'panel_login_page_view', '0', '2025-06-05 09:03:13', '2025-08-18 11:54:46'),
(52, 'panel_login_page_bg_image', '', '2025-06-05 09:03:13', '2025-08-18 11:07:12'),
(53, 'panel_login_page_bg_color', '', '2025-06-05 09:03:13', '2025-09-09 12:15:28'),
(54, 'panel_login_page_image', '', '2025-06-05 09:03:13', '2025-09-09 12:15:16'),
(55, 'onesignal_apid', '', '2025-06-05 09:03:13', '2025-08-27 10:15:03'),
(56, 'onesignal_rest_key', '', '2025-06-05 09:03:13', '2025-08-27 10:15:03'),
(57, 'sub_incharge_onesignal_apid', '', '2025-07-14 05:14:02', '2025-09-09 12:15:20'),
(58, 'sub_incharge_onesignal_rest_key', '', '2025-07-14 05:31:09', '2025-09-09 12:15:22'),
(59, 'google_map_api_key', '', '2025-07-14 05:31:09', '2025-09-09 12:15:24'),
(60, 'vap_id_key', '', '2025-07-14 05:31:09', '2025-08-27 10:14:25');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_hashtag`
--

CREATE TABLE `tbl_hashtag` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_used` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '0- Hide, 1- Show',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_in_charge`
--

CREATE TABLE `tbl_in_charge` (
  `id` int(11) UNSIGNED NOT NULL,
  `department_id` int(11) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `country_code` varchar(255) NOT NULL,
  `mobile_number` varchar(255) NOT NULL,
  `country_name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `device_type` int(11) NOT NULL COMMENT '1- Android, 2- iOS',
  `device_token` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_like`
--

CREATE TABLE `tbl_like` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `complaint_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '1-Like,2-DisLike',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_notification`
--

CREATE TABLE `tbl_notification` (
  `id` int(11) UNSIGNED NOT NULL,
  `type` int(11) NOT NULL COMMENT '1- User, 2- Sub In-charge, 3- Admin, \r\n4- In-Charge',
  `recipient_id` int(11) NOT NULL,
  `complaint_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `message` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_notification_configuration`
--

CREATE TABLE `tbl_notification_configuration` (
  `id` int(11) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `send_mail` int(11) NOT NULL,
  `send_notification` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_notification_configuration`
--

INSERT INTO `tbl_notification_configuration` (`id`, `type`, `send_mail`, `send_notification`, `status`, `created_at`, `updated_at`) VALUES
(1, 'login', 0, 0, 1, '2025-08-19 11:10:21', '2025-09-09 12:23:20'),
(2, 'register', 0, 0, 1, '2025-08-19 11:10:21', '2025-09-09 12:23:20'),
(3, 'request-submitted', 0, 0, 1, '2025-08-19 11:10:21', '2025-09-09 12:23:20'),
(4, 'request-assigned', 0, 0, 1, '2025-08-19 11:10:21', '2025-09-09 12:23:20'),
(5, 'request-status-updated', 0, 0, 1, '2025-08-19 11:10:21', '2025-09-09 12:23:20'),
(6, 'service-assigned', 0, 0, 1, '2025-08-19 11:10:21', '2025-09-09 12:23:20'),
(7, 'incharge-transfer', 0, 0, 1, '2025-08-19 11:10:21', '2025-09-09 12:23:20'),
(8, 'sub-incharge-transfer', 0, 0, 1, '2025-08-19 11:10:21', '2025-09-09 12:23:20');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_onboarding_screen`
--

CREATE TABLE `tbl_onboarding_screen` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_page`
--

CREATE TABLE `tbl_page` (
  `id` int(11) UNSIGNED NOT NULL,
  `type` int(11) NOT NULL COMMENT '1-User,2-In-Charge',
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `icon` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '0- Hide, 1- Show',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_page`
--

INSERT INTO `tbl_page` (`id`, `type`, `title`, `description`, `icon`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'About Us', '', '', 1, '2023-04-21 05:09:12', '2025-09-09 12:19:11'),
(2, 1, 'Privacy Policy', '', '', 1, '2023-04-21 05:09:12', '2025-02-11 13:15:32'),
(3, 1, 'Terms & Conditions', '', '', 1, '2023-04-21 05:09:12', '2025-02-11 13:15:34'),
(4, 1, 'Refund Policy', '', '', 1, '2023-04-21 05:09:12', '2025-08-18 10:24:32'),
(5, 2, 'About Us', '', '', 1, '2023-04-21 05:09:12', '2025-09-09 12:19:14'),
(6, 2, 'Privacy Policy', '', '', 1, '2023-04-21 05:09:12', '2025-08-25 12:57:25'),
(7, 2, 'Terms & Conditions', '', '', 1, '2023-04-21 05:09:12', '2025-08-18 10:09:39'),
(8, 2, 'Refund Policy', '', '', 1, '2023-04-21 05:09:12', '2024-11-26 05:20:00');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_read_notification`
--

CREATE TABLE `tbl_read_notification` (
  `id` int(11) UNSIGNED NOT NULL,
  `type` int(11) NOT NULL COMMENT '1- User, 2- Sub In-charge, 3- Admin, 4- In Charge',
  `user_id` int(11) NOT NULL,
  `notification_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_service`
--

CREATE TABLE `tbl_service` (
  `id` int(11) UNSIGNED NOT NULL,
  `department_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_smtp_setting`
--

CREATE TABLE `tbl_smtp_setting` (
  `id` int(11) UNSIGNED NOT NULL,
  `protocol` varchar(255) NOT NULL,
  `host` varchar(255) NOT NULL,
  `port` varchar(255) NOT NULL,
  `user` varchar(255) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `from_name` varchar(255) NOT NULL,
  `from_email` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_smtp_setting`
--

INSERT INTO `tbl_smtp_setting` (`id`, `protocol`, `host`, `port`, `user`, `pass`, `from_name`, `from_email`, `status`, `created_at`, `updated_at`) VALUES
(1, 'smtp123', 'smtp.gmail.com', '587', 'admin@admin.com', 'admin', 'admin', 'admin@admin.com', 0, '2023-08-05 13:27:31', '2025-09-09 12:26:46');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_social_link`
--

CREATE TABLE `tbl_social_link` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `url` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_story`
--

CREATE TABLE `tbl_story` (
  `id` int(11) UNSIGNED NOT NULL,
  `in_charge_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `type` int(11) NOT NULL COMMENT '1-Image,2-Video',
  `story_url` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_sub_in_charge`
--

CREATE TABLE `tbl_sub_in_charge` (
  `id` int(11) UNSIGNED NOT NULL,
  `department_id` int(11) NOT NULL,
  `service_id` varchar(255) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `country_code` varchar(255) NOT NULL,
  `mobile_number` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `bio` text NOT NULL,
  `device_type` int(11) NOT NULL DEFAULT 0 COMMENT '1- Android, 2- iOS',
  `device_token` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '0- Inactive, 1- Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user`
--

CREATE TABLE `tbl_user` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `country_code` varchar(255) NOT NULL,
  `mobile_number` varchar(255) NOT NULL,
  `country_name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `type` int(11) NOT NULL COMMENT '1- OTP, 2- Google, 3- Apple, 4- Normal	',
  `device_type` int(11) NOT NULL DEFAULT 0 COMMENT '1- Android, 2- iOS, 3- Web',
  `device_token` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '0- Inactive, 1- Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user_address`
--

CREATE TABLE `tbl_user_address` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` int(11) NOT NULL DEFAULT 1 COMMENT '1-Home, 2-Work, 3-Other',
  `address` text NOT NULL,
  `area` text NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `pincode` varchar(255) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '0- Hide, 1- Show',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_vacancy`
--

CREATE TABLE `tbl_vacancy` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `position` varchar(255) NOT NULL,
  `salary` varchar(255) NOT NULL,
  `weekly_workload` varchar(255) NOT NULL,
  `work_days` varchar(255) NOT NULL,
  `schedule` varchar(255) NOT NULL,
  `requirements` text NOT NULL,
  `job_description` text NOT NULL,
  `type` int(11) NOT NULL COMMENT '1-In Person,2- Home Office,3- Hybrid',
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '1-Show, 0-Hide',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_comment`
--
ALTER TABLE `tbl_comment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_company`
--
ALTER TABLE `tbl_company`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_complaint`
--
ALTER TABLE `tbl_complaint`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_complaint_img`
--
ALTER TABLE `tbl_complaint_img`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_department`
--
ALTER TABLE `tbl_department`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_department_working_time`
--
ALTER TABLE `tbl_department_working_time`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_general_setting`
--
ALTER TABLE `tbl_general_setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_hashtag`
--
ALTER TABLE `tbl_hashtag`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_in_charge`
--
ALTER TABLE `tbl_in_charge`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_like`
--
ALTER TABLE `tbl_like`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_notification`
--
ALTER TABLE `tbl_notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_notification_configuration`
--
ALTER TABLE `tbl_notification_configuration`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_onboarding_screen`
--
ALTER TABLE `tbl_onboarding_screen`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_page`
--
ALTER TABLE `tbl_page`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_read_notification`
--
ALTER TABLE `tbl_read_notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_service`
--
ALTER TABLE `tbl_service`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_smtp_setting`
--
ALTER TABLE `tbl_smtp_setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_social_link`
--
ALTER TABLE `tbl_social_link`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_story`
--
ALTER TABLE `tbl_story`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sub_in_charge`
--
ALTER TABLE `tbl_sub_in_charge`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_user`
--
ALTER TABLE `tbl_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_user_address`
--
ALTER TABLE `tbl_user_address`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_vacancy`
--
ALTER TABLE `tbl_vacancy`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_comment`
--
ALTER TABLE `tbl_comment`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_company`
--
ALTER TABLE `tbl_company`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_complaint`
--
ALTER TABLE `tbl_complaint`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_complaint_img`
--
ALTER TABLE `tbl_complaint_img`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_department`
--
ALTER TABLE `tbl_department`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_department_working_time`
--
ALTER TABLE `tbl_department_working_time`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_general_setting`
--
ALTER TABLE `tbl_general_setting`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `tbl_hashtag`
--
ALTER TABLE `tbl_hashtag`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_in_charge`
--
ALTER TABLE `tbl_in_charge`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_like`
--
ALTER TABLE `tbl_like`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_notification`
--
ALTER TABLE `tbl_notification`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_notification_configuration`
--
ALTER TABLE `tbl_notification_configuration`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_onboarding_screen`
--
ALTER TABLE `tbl_onboarding_screen`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_page`
--
ALTER TABLE `tbl_page`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `tbl_read_notification`
--
ALTER TABLE `tbl_read_notification`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_service`
--
ALTER TABLE `tbl_service`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_smtp_setting`
--
ALTER TABLE `tbl_smtp_setting`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_social_link`
--
ALTER TABLE `tbl_social_link`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_story`
--
ALTER TABLE `tbl_story`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_sub_in_charge`
--
ALTER TABLE `tbl_sub_in_charge`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_user`
--
ALTER TABLE `tbl_user`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_user_address`
--
ALTER TABLE `tbl_user_address`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_vacancy`
--
ALTER TABLE `tbl_vacancy`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!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 */;
