-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `qmis_db_4b`
--

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

--
-- Table structure for table `accomplishments`
--

CREATE TABLE `accomplishments` (
  `acc_id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sem` int(10) UNSIGNED DEFAULT '0',
  `sem_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `desc` text COLLATE utf8mb4_unicode_ci,
  `qty` decimal(8,2) UNSIGNED DEFAULT '1.00',
  `effort` int(10) UNSIGNED DEFAULT '5',
  `unplanned` tinyint(3) UNSIGNED DEFAULT '0',
  `u_id` bigint(20) UNSIGNED DEFAULT '0',
  `u_initials` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pt_id` bigint(20) UNSIGNED DEFAULT '0',
  `pt_desc` text COLLATE utf8mb4_unicode_ci,
  `tar_id` bigint(20) UNSIGNED DEFAULT '0',
  `tar_desc` text COLLATE utf8mb4_unicode_ci,
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fo_id` bigint(20) UNSIGNED DEFAULT '0',
  `fo_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `bo_id` bigint(20) UNSIGNED DEFAULT '0',
  `bo_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `accomplishment_files`
--

CREATE TABLE `accomplishment_files` (
  `file_id` bigint(20) UNSIGNED NOT NULL,
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `desc` text COLLATE utf8mb4_unicode_ci,
  `size` bigint(20) UNSIGNED DEFAULT '0',
  `acc_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `apgs`
--

CREATE TABLE `apgs` (
  `apg_id` bigint(20) UNSIGNED NOT NULL,
  `effectivity_date` date DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'PL-IQA-01',
  `custom_code` tinyint(3) UNSIGNED DEFAULT '0',
  `year` int(10) UNSIGNED DEFAULT '0',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sem` int(10) UNSIGNED DEFAULT '0',
  `sem_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type_id` bigint(20) UNSIGNED DEFAULT '5',
  `type_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'AAP',
  `type_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Annual Audit Program',
  `div_id` bigint(20) UNSIGNED DEFAULT '0',
  `div_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'RO',
  `div_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Regional Office',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'PL',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Planning',
  `sec_id` bigint(20) UNSIGNED DEFAULT '0',
  `sec_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '01',
  `sec_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'IQA',
  `subject_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '01',
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Annual Audit Program',
  `series_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `page_count` int(10) UNSIGNED DEFAULT '0',
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_date` datetime DEFAULT NULL,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_date` datetime DEFAULT NULL,
  `revision_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `revision_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_revision_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `revision` bigint(20) UNSIGNED DEFAULT '0',
  `req_id` int(10) UNSIGNED DEFAULT '0',
  `req_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `for_creation` tinyint(3) UNSIGNED DEFAULT '0',
  `for_revision` tinyint(3) UNSIGNED DEFAULT '0',
  `for_deletion` tinyint(3) UNSIGNED DEFAULT '0',
  `reason` text COLLATE utf8mb4_unicode_ci,
  `details` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `status_id` int(10) UNSIGNED DEFAULT '0',
  `status_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `documents` text COLLATE utf8mb4_unicode_ci,
  `file_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `objectives` text COLLATE utf8mb4_unicode_ci,
  `scope` text COLLATE utf8mb4_unicode_ci,
  `scope_table` text COLLATE utf8mb4_unicode_ci,
  `criteria` text COLLATE utf8mb4_unicode_ci,
  `frequency` text COLLATE utf8mb4_unicode_ci,
  `methodology` text COLLATE utf8mb4_unicode_ci,
  `applicable` text COLLATE utf8mb4_unicode_ci,
  `auditors` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `doc_id` bigint(20) UNSIGNED DEFAULT '0',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `rev_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `rev_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `apg_files`
--

CREATE TABLE `apg_files` (
  `file_id` bigint(20) UNSIGNED NOT NULL,
  `file_page_no` int(10) UNSIGNED DEFAULT '0',
  `file_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_size` bigint(20) UNSIGNED DEFAULT '0',
  `file_revision` bigint(20) UNSIGNED DEFAULT '0',
  `file_is_revision` tinyint(3) UNSIGNED DEFAULT '0',
  `page_count` int(10) UNSIGNED DEFAULT '0',
  `doc_id` bigint(20) UNSIGNED DEFAULT '0',
  `apg_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `apg_file_revisions`
--

CREATE TABLE `apg_file_revisions` (
  `file_id` bigint(20) UNSIGNED NOT NULL,
  `file_page_no` int(10) UNSIGNED DEFAULT '0',
  `file_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_size` bigint(20) UNSIGNED DEFAULT '0',
  `file_revision` bigint(20) UNSIGNED DEFAULT '0',
  `page_count` int(10) UNSIGNED DEFAULT '0',
  `doc_id` bigint(20) UNSIGNED DEFAULT '0',
  `apg_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `apns`
--

CREATE TABLE `apns` (
  `apn_id` bigint(20) UNSIGNED NOT NULL,
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `year` int(10) UNSIGNED DEFAULT '0',
  `days` text COLLATE utf8mb4_unicode_ci,
  `dates` text COLLATE utf8mb4_unicode_ci,
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `purpose` text COLLATE utf8mb4_unicode_ci,
  `scope` text COLLATE utf8mb4_unicode_ci,
  `criteria` text COLLATE utf8mb4_unicode_ci,
  `language` text COLLATE utf8mb4_unicode_ci,
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_date` datetime DEFAULT NULL,
  `reviewedby` bigint(20) UNSIGNED DEFAULT '0',
  `reviewedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `reviewedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `reviewedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `reviewedby_date` datetime DEFAULT NULL,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_date` datetime DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `revision` bigint(20) UNSIGNED DEFAULT '0',
  `req_id` int(10) UNSIGNED DEFAULT '0',
  `req_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `status_id` int(10) UNSIGNED DEFAULT '0',
  `status_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `apn_auditors`
--

CREATE TABLE `apn_auditors` (
  `au_id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` text COLLATE utf8mb4_unicode_ci,
  `preparedby_date` datetime DEFAULT NULL,
  `reviewedby` bigint(20) UNSIGNED DEFAULT '0',
  `reviewedby_date` datetime DEFAULT NULL,
  `reviewedby_name` text COLLATE utf8mb4_unicode_ci,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_date` datetime DEFAULT NULL,
  `approvedby_name` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `apn_id` bigint(20) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `apn_auditor_items`
--

CREATE TABLE `apn_auditor_items` (
  `ai_id` bigint(20) UNSIGNED NOT NULL,
  `auditors` text COLLATE utf8mb4_unicode_ci,
  `auditor_ids` text COLLATE utf8mb4_unicode_ci,
  `auditees` text COLLATE utf8mb4_unicode_ci,
  `auditee_ids` text COLLATE utf8mb4_unicode_ci,
  `keycontacts` text COLLATE utf8mb4_unicode_ci,
  `keycontact_ids` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `au_id` bigint(20) UNSIGNED DEFAULT '1',
  `apn_id` bigint(20) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `apn_schedules`
--

CREATE TABLE `apn_schedules` (
  `sd_id` bigint(20) UNSIGNED NOT NULL,
  `date_start` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `area` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `auditors` text COLLATE utf8mb4_unicode_ci,
  `auditor_ids` text COLLATE utf8mb4_unicode_ci,
  `auditees` text COLLATE utf8mb4_unicode_ci,
  `auditee_ids` text COLLATE utf8mb4_unicode_ci,
  `keycontacts` text COLLATE utf8mb4_unicode_ci,
  `keycontact_ids` text COLLATE utf8mb4_unicode_ci,
  `is_audit` tinyint(3) UNSIGNED DEFAULT '0',
  `clauses` text COLLATE utf8mb4_unicode_ci,
  `apn_id` bigint(20) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `observers` text COLLATE utf8mb4_unicode_ci,
  `observer_names` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `apn_schedule_items`
--

CREATE TABLE `apn_schedule_items` (
  `si_id` bigint(20) UNSIGNED NOT NULL,
  `date_start` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `area` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `auditors` text COLLATE utf8mb4_unicode_ci,
  `auditor_ids` text COLLATE utf8mb4_unicode_ci,
  `auditees` text COLLATE utf8mb4_unicode_ci,
  `auditee_ids` text COLLATE utf8mb4_unicode_ci,
  `keycontacts` text COLLATE utf8mb4_unicode_ci,
  `keycontact_ids` text COLLATE utf8mb4_unicode_ci,
  `is_audit` tinyint(3) UNSIGNED DEFAULT '0',
  `sd_id` bigint(20) UNSIGNED DEFAULT '1',
  `apn_id` bigint(20) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ars`
--

CREATE TABLE `ars` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `is_id` bigint(20) UNSIGNED DEFAULT '0',
  `is_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `rt_id` bigint(20) UNSIGNED DEFAULT '0',
  `rt_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `desc` text COLLATE utf8mb4_unicode_ci,
  `findings` text COLLATE utf8mb4_unicode_ci,
  `action` text COLLATE utf8mb4_unicode_ci,
  `preparedby` bigint(20) UNSIGNED DEFAULT NULL,
  `preparedby_name` text COLLATE utf8mb4_unicode_ci,
  `preparedby_date` datetime DEFAULT NULL,
  `acknowledgedby` bigint(20) UNSIGNED DEFAULT NULL,
  `acknowledgedby_name` text COLLATE utf8mb4_unicode_ci,
  `acknowledgedby_date` datetime DEFAULT NULL,
  `closedby` bigint(20) UNSIGNED DEFAULT NULL,
  `closedby_name` text COLLATE utf8mb4_unicode_ci,
  `closedby_date` datetime DEFAULT NULL,
  `notedby` bigint(20) UNSIGNED DEFAULT NULL,
  `notedby_name` text COLLATE utf8mb4_unicode_ci,
  `notedby_date` datetime DEFAULT NULL,
  `status` tinyint(3) UNSIGNED DEFAULT '0',
  `status_name` text COLLATE utf8mb4_unicode_ci,
  `work_quality` tinyint(3) UNSIGNED DEFAULT '0',
  `response_delivery` tinyint(3) UNSIGNED DEFAULT '0',
  `personnel_quality` tinyint(3) UNSIGNED DEFAULT '0',
  `overall` tinyint(3) UNSIGNED DEFAULT '0',
  `comments` text COLLATE utf8mb4_unicode_ci,
  `complaints` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ar_files`
--

CREATE TABLE `ar_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `size` bigint(20) UNSIGNED DEFAULT '0',
  `ar_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ar_types`
--

CREATE TABLE `ar_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `desc` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `audit_questions`
--

CREATE TABLE `audit_questions` (
  `aq_id` bigint(20) UNSIGNED NOT NULL,
  `clause` text COLLATE utf8mb4_unicode_ci,
  `questions` text COLLATE utf8mb4_unicode_ci,
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '''''',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '''''',
  `u_id` bigint(20) UNSIGNED DEFAULT '0',
  `u_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '''''',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `checklists`
--

CREATE TABLE `checklists` (
  `chk_id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` text COLLATE utf8mb4_unicode_ci,
  `preparedby_date` datetime DEFAULT NULL,
  `reviewedby` bigint(20) UNSIGNED DEFAULT '0',
  `reviewedby_date` datetime DEFAULT NULL,
  `reviewedby_name` text COLLATE utf8mb4_unicode_ci,
  `division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `auditors` text COLLATE utf8mb4_unicode_ci,
  `auditees` text COLLATE utf8mb4_unicode_ci,
  `auditor_ids` text COLLATE utf8mb4_unicode_ci,
  `auditee_ids` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `apn_id` bigint(20) UNSIGNED DEFAULT '0',
  `sd_id` bigint(20) UNSIGNED DEFAULT '0',
  `sd_desc` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `filename1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `checklist_items`
--

CREATE TABLE `checklist_items` (
  `chki_id` bigint(20) UNSIGNED NOT NULL,
  `clause` text COLLATE utf8mb4_unicode_ci,
  `desc` text COLLATE utf8mb4_unicode_ci,
  `status_id` tinyint(3) UNSIGNED DEFAULT '0',
  `status_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `status_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `chk_id` bigint(20) UNSIGNED DEFAULT '0',
  `apn_id` bigint(20) UNSIGNED DEFAULT '0',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `has_result` tinyint(3) UNSIGNED DEFAULT '0',
  `findings` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `checklist_statuses`
--

CREATE TABLE `checklist_statuses` (
  `status_id` bigint(20) UNSIGNED NOT NULL,
  `status_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `status_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `checklist_statuses`
--

INSERT INTO `checklist_statuses` (`status_id`, `status_abbr`, `status_name`, `created_at`, `updated_at`) VALUES
(1, 'N', 'Nonconformity', NULL, NULL),
(2, 'O', 'Opportunity for Improvement', NULL, NULL),
(4, 'C', 'Conformity', NULL, NULL),
(8, 'X', 'Not Applicable', NULL, NULL);

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `from` bigint(20) UNSIGNED DEFAULT '0',
  `fromname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `replytomsgid` bigint(20) UNSIGNED DEFAULT '0',
  `replyto` bigint(20) UNSIGNED DEFAULT '0',
  `replytoname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `replytomsg` text COLLATE utf8mb4_unicode_ci,
  `msg` text COLLATE utf8mb4_unicode_ci,
  `table` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `tableid` bigint(20) UNSIGNED DEFAULT '0',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date` datetime DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `readerids` text COLLATE utf8mb4_unicode_ci,
  `readernames` text COLLATE utf8mb4_unicode_ci,
  `readeremails` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `counters`
--

CREATE TABLE `counters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ncs` bigint(20) UNSIGNED DEFAULT '0',
  `ofis` bigint(20) UNSIGNED DEFAULT '0',
  `dateTime` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `pf` bigint(20) UNSIGNED DEFAULT '0',
  `nc_year` bigint(20) UNSIGNED DEFAULT '0',
  `ofi_year` bigint(20) UNSIGNED DEFAULT '0',
  `pf_year` bigint(20) UNSIGNED DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `csm_provinces`
--

CREATE TABLE `csm_provinces` (
  `province_id` bigint(20) UNSIGNED NOT NULL,
  `province_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `csm_provinces`
--

INSERT INTO `csm_provinces` (`province_id`, `province_name`, `created_at`, `updated_at`) VALUES
(1, 'Batangas', '2020-03-22 08:58:14', '2020-03-22 08:58:23'),
(2, 'Cavite', '2020-03-22 08:58:36', '2020-03-22 08:58:36'),
(3, 'Laguna', '2020-03-22 08:58:52', '2020-03-22 08:58:52'),
(4, 'Quezon', '2020-03-22 08:59:11', '2020-03-22 08:59:11'),
(5, 'Rizal', '2020-03-22 08:59:20', '2020-03-22 08:59:20');

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

--
-- Table structure for table `csm_services`
--

CREATE TABLE `csm_services` (
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `service_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `fu_ids` text COLLATE utf8mb4_unicode_ci,
  `fu_names` text COLLATE utf8mb4_unicode_ci,
  `fu_abbrs` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `csm_subjects`
--

CREATE TABLE `csm_subjects` (
  `subject_id` bigint(20) UNSIGNED NOT NULL,
  `subject_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `csm_subjects`
--

INSERT INTO `csm_subjects` (`subject_id`, `subject_name`, `created_at`, `updated_at`) VALUES
(1, 'Alternative Energy', '2020-03-19 08:54:25', '2020-03-22 06:46:12'),
(2, 'Agriculture / Aquaculture', '2020-03-19 08:54:36', '2020-03-22 06:45:54'),
(4, 'Chemical & Labor-Related', '2020-03-22 06:46:23', '2020-03-22 06:46:23'),
(5, 'Disaster Risk Reduction & Management', '2020-03-22 06:46:33', '2020-03-22 06:46:33'),
(6, 'Food & Beverage Processing / Safety', '2020-03-22 06:46:45', '2020-03-22 06:46:45'),
(7, 'Gifts, Decor & Housewares', '2020-03-22 06:46:56', '2020-03-22 06:46:56'),
(8, 'Health & Nutrition', '2020-03-22 06:47:04', '2020-03-22 06:47:04'),
(9, 'Information & Communications Technology', '2020-03-22 06:47:14', '2020-03-22 06:47:14'),
(10, 'Metals & Engineering', '2020-03-22 06:47:25', '2020-03-22 06:47:25'),
(11, 'Research / Thesis / Science Projects', '2020-03-22 06:47:36', '2020-03-22 06:47:36'),
(12, 'Waste Management', '2020-03-22 06:47:46', '2020-03-22 06:47:46');

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

--
-- Table structure for table `cs_files`
--

CREATE TABLE `cs_files` (
  `csf_id` bigint(20) UNSIGNED NOT NULL,
  `csf_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `csf_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cs_id` bigint(20) UNSIGNED DEFAULT '0',
  `csf_remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cs_provinces`
--

CREATE TABLE `cs_provinces` (
  `csp_id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime DEFAULT NULL,
  `month` tinyint(3) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `year` int(10) UNSIGNED DEFAULT '0',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `total` decimal(8,2) UNSIGNED DEFAULT '0.00',
  `ontime` int(10) UNSIGNED DEFAULT '0',
  `firms` int(10) UNSIGNED DEFAULT '0',
  `trainings` int(10) UNSIGNED DEFAULT '0',
  `participants` int(10) UNSIGNED DEFAULT '0',
  `province_id` bigint(20) UNSIGNED DEFAULT '0',
  `province_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `cs_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cs_services`
--

CREATE TABLE `cs_services` (
  `csv_id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime DEFAULT NULL,
  `month` tinyint(3) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `year` int(10) UNSIGNED DEFAULT '0',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `total` decimal(8,2) UNSIGNED DEFAULT '0.00',
  `service_id` bigint(20) UNSIGNED DEFAULT '0',
  `service_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `cs_id` bigint(20) UNSIGNED DEFAULT '0',
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `customers` bigint(20) UNSIGNED DEFAULT '0',
  `fu_ids` text COLLATE utf8mb4_unicode_ci,
  `fu_names` text COLLATE utf8mb4_unicode_ci,
  `fu_abbrs` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cs_subjects`
--

CREATE TABLE `cs_subjects` (
  `css_id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime DEFAULT NULL,
  `month` tinyint(3) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `year` int(10) UNSIGNED DEFAULT '0',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `total` decimal(8,2) UNSIGNED DEFAULT '0.00',
  `subject_id` bigint(20) UNSIGNED DEFAULT '0',
  `subject_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `cs_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `customers` bigint(20) UNSIGNED DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `detections`
--

CREATE TABLE `detections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `detections`
--

INSERT INTO `detections` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Very Easy', NULL, NULL),
(2, 'Easy', NULL, NULL),
(3, 'Moderately Difficult', NULL, NULL),
(4, 'Difficult', NULL, NULL),
(5, 'Very Difficult', NULL, NULL);

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

--
-- Table structure for table `eds`
--

CREATE TABLE `eds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `no` int(10) UNSIGNED DEFAULT '0',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_size` bigint(20) UNSIGNED DEFAULT '0',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `foa_bos`
--

CREATE TABLE `foa_bos` (
  `bo_id` bigint(20) UNSIGNED NOT NULL,
  `no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `category` text COLLATE utf8mb4_unicode_ci,
  `name` text COLLATE utf8mb4_unicode_ci,
  `desc` text COLLATE utf8mb4_unicode_ci,
  `goal` text COLLATE utf8mb4_unicode_ci,
  `outcome` text COLLATE utf8mb4_unicode_ci,
  `active` tinyint(3) UNSIGNED DEFAULT '0',
  `date` date DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `perspective` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `foa_fos`
--

CREATE TABLE `foa_fos` (
  `fo_id` bigint(20) UNSIGNED NOT NULL,
  `no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `desc` text COLLATE utf8mb4_unicode_ci,
  `active` tinyint(3) UNSIGNED DEFAULT '0',
  `date` date DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `bo_id` bigint(20) UNSIGNED DEFAULT '0',
  `bo_name` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `frequencies`
--

CREATE TABLE `frequencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `frequencies`
--

INSERT INTO `frequencies` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Not Likely', NULL, NULL),
(2, 'Low', NULL, NULL),
(3, 'Moderate', NULL, NULL),
(4, 'High', NULL, NULL),
(5, 'Expected', NULL, NULL);

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

--
-- Table structure for table `functional_units`
--

CREATE TABLE `functional_units` (
  `fu_id` bigint(20) UNSIGNED NOT NULL,
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `members` text COLLATE utf8mb4_unicode_ci,
  `member_names` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `functional_units`
--

INSERT INTO `functional_units` (`fu_id`, `fu_abbr`, `fu_name`, `created_at`, `updated_at`, `members`, `member_names`) VALUES
(1, 'MIS', 'Management Information Systems', '2024-02-02 05:56:34', '2024-02-02 05:59:13', '1', 'Admin Is Trator');

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

--
-- Table structure for table `fuws`
--

CREATE TABLE `fuws` (
  `fuw_id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` tinyint(3) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` tinyint(3) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sem` tinyint(3) UNSIGNED DEFAULT '0',
  `sem_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` text COLLATE utf8mb4_unicode_ci,
  `preparedby_date` datetime DEFAULT NULL,
  `reviewedby` bigint(20) UNSIGNED DEFAULT '0',
  `reviewedby_date` datetime DEFAULT NULL,
  `reviewedby_name` text COLLATE utf8mb4_unicode_ci,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_date` datetime DEFAULT NULL,
  `approvedby_name` text COLLATE utf8mb4_unicode_ci,
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `fuw_targets`
--

CREATE TABLE `fuw_targets` (
  `tar_id` bigint(20) UNSIGNED NOT NULL,
  `desc` text COLLATE utf8mb4_unicode_ci,
  `success` text COLLATE utf8mb4_unicode_ci,
  `qty` int(10) UNSIGNED DEFAULT '0',
  `budget` text COLLATE utf8mb4_unicode_ci,
  `resources` text COLLATE utf8mb4_unicode_ci,
  `customers` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `acc_1` int(10) UNSIGNED DEFAULT '0',
  `acc_2` int(10) UNSIGNED DEFAULT '0',
  `acc_3` int(10) UNSIGNED DEFAULT '0',
  `acc_4` int(10) UNSIGNED DEFAULT '0',
  `acc_5` int(10) UNSIGNED DEFAULT '0',
  `acc_6` int(10) UNSIGNED DEFAULT '0',
  `acc_7` int(10) UNSIGNED DEFAULT '0',
  `acc_8` int(10) UNSIGNED DEFAULT '0',
  `acc_9` int(10) UNSIGNED DEFAULT '0',
  `acc_10` int(10) UNSIGNED DEFAULT '0',
  `acc_11` int(10) UNSIGNED DEFAULT '0',
  `acc_12` int(10) UNSIGNED DEFAULT '0',
  `acc_total` int(10) UNSIGNED DEFAULT '0',
  `acc` decimal(8,2) UNSIGNED DEFAULT '0.00',
  `parent` bigint(20) UNSIGNED DEFAULT '0',
  `level` tinyint(3) UNSIGNED DEFAULT '0',
  `is_category` tinyint(3) UNSIGNED DEFAULT '0',
  `date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` tinyint(3) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` tinyint(3) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sem` tinyint(3) UNSIGNED DEFAULT '0',
  `sem_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fuw_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fo_id` bigint(20) UNSIGNED DEFAULT '0',
  `fo_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fo_name` text COLLATE utf8mb4_unicode_ci,
  `bo_id` bigint(20) UNSIGNED DEFAULT '0',
  `bo_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `bo_name` text COLLATE utf8mb4_unicode_ci,
  `staffs` text COLLATE utf8mb4_unicode_ci,
  `staff_ids` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `target_months` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `target_year` int(10) UNSIGNED DEFAULT '2020'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `impacts`
--

CREATE TABLE `impacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `impacts`
--

INSERT INTO `impacts` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Negligible', NULL, NULL),
(2, 'Low', NULL, NULL),
(3, 'Moderate', NULL, NULL),
(4, 'High', NULL, NULL),
(5, 'Extreme', NULL, NULL);

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

--
-- Table structure for table `information_systems`
--

CREATE TABLE `information_systems` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `desc` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqas`
--

CREATE TABLE `iqas` (
  `iqa_id` bigint(20) UNSIGNED NOT NULL,
  `iqa_date_start` datetime DEFAULT NULL,
  `iqa_date_end` datetime DEFAULT NULL,
  `iqa_venue` text COLLATE utf8mb4_unicode_ci,
  `iqa_remarks` text COLLATE utf8mb4_unicode_ci,
  `iqastat_id` bigint(20) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `iqa_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqa_auditees`
--

CREATE TABLE `iqa_auditees` (
  `iqatee_id` bigint(20) UNSIGNED NOT NULL,
  `iqa_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqa_auditors`
--

CREATE TABLE `iqa_auditors` (
  `iqator_id` bigint(20) UNSIGNED NOT NULL,
  `iqa_id` bigint(20) UNSIGNED DEFAULT '0',
  `user_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqa_checklists`
--

CREATE TABLE `iqa_checklists` (
  `iqachk_id` bigint(20) UNSIGNED NOT NULL,
  `iqachk_date` datetime DEFAULT NULL,
  `iqachk_dateprepared` datetime DEFAULT NULL,
  `iqachk_datereviewed` datetime DEFAULT NULL,
  `iqachk_reviewedby` bigint(20) UNSIGNED DEFAULT '0',
  `iqachk_preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `iqa_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `iqachk_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqachk_reviewedby_name` text COLLATE utf8mb4_unicode_ci,
  `iqachk_preparedby_name` text COLLATE utf8mb4_unicode_ci,
  `iqachk_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqachk_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqachk_auditors` text COLLATE utf8mb4_unicode_ci,
  `iqachk_auditees` text COLLATE utf8mb4_unicode_ci,
  `iqachk_auditor_ids` text COLLATE utf8mb4_unicode_ci,
  `iqachk_auditee_ids` text COLLATE utf8mb4_unicode_ci,
  `iqachk_remarks` text COLLATE utf8mb4_unicode_ci,
  `iqachk_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqachk_year` int(10) UNSIGNED DEFAULT '0',
  `iqachk_qtr` int(10) UNSIGNED DEFAULT '0',
  `iqachk_qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqa_checklist_items`
--

CREATE TABLE `iqa_checklist_items` (
  `iqachki_id` bigint(20) UNSIGNED NOT NULL,
  `iqachki_clause` text COLLATE utf8mb4_unicode_ci,
  `iqachki_desc` text COLLATE utf8mb4_unicode_ci,
  `iqachkistat_id` tinyint(3) UNSIGNED DEFAULT '0',
  `iqachki_remarks` text COLLATE utf8mb4_unicode_ci,
  `iqachk_id` bigint(20) UNSIGNED DEFAULT '0',
  `iqa_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `iqachkistat_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqachkistat_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqachki_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqachki_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqa_checklist_item_statuses`
--

CREATE TABLE `iqa_checklist_item_statuses` (
  `iqachkistat_id` bigint(20) UNSIGNED NOT NULL,
  `iqachkistat_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqachkistat_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `iqa_checklist_item_statuses`
--

INSERT INTO `iqa_checklist_item_statuses` (`iqachkistat_id`, `iqachkistat_abbr`, `iqachkistat_name`, `created_at`, `updated_at`) VALUES
(1, 'N', 'Nonconformity', NULL, NULL),
(2, 'O', 'Opportunity for Improvement', NULL, NULL),
(3, 'C', 'Conformity', NULL, NULL),
(4, 'X', 'Not Applicable', NULL, NULL);

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

--
-- Table structure for table `iqa_evidences`
--

CREATE TABLE `iqa_evidences` (
  `iqaevi_id` bigint(20) UNSIGNED NOT NULL,
  `iqaevi_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqaevi_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqaevi_size` bigint(20) UNSIGNED DEFAULT '0',
  `iqa_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqa_ncars`
--

CREATE TABLE `iqa_ncars` (
  `iqanc_id` bigint(20) UNSIGNED NOT NULL,
  `iqanc_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqanc_date` datetime DEFAULT NULL,
  `iqanc_internal` tinyint(3) UNSIGNED DEFAULT '0',
  `nctype_id` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_systems` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_complaints` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_review` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_targets` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_analysis` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_qms` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_legal` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_desc` text COLLATE utf8mb4_unicode_ci,
  `iqanc_acknowledgedby` bigint(20) UNSIGNED DEFAULT '0',
  `iqanc_date_acknowledged` datetime DEFAULT NULL,
  `iqanc_corr` text COLLATE utf8mb4_unicode_ci,
  `iqanc_corr_personreponsible` bigint(20) UNSIGNED DEFAULT '0',
  `iqanc_corr_dateimplemented` datetime DEFAULT NULL,
  `iqanc_cause` text COLLATE utf8mb4_unicode_ci,
  `iqanc_cause_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqanc_cause_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqanc_planned_action` text COLLATE utf8mb4_unicode_ci,
  `iqanc_planned_completiondate` datetime DEFAULT NULL,
  `iqanc_planned_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqanc_planned_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqanc_action1` text COLLATE utf8mb4_unicode_ci,
  `iqanc_action1_effective` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_action1_followupdate` datetime DEFAULT NULL,
  `iqanc_action1_remarks` text COLLATE utf8mb4_unicode_ci,
  `iqanc_action1_approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `iqanc_action1_date_approved` datetime DEFAULT NULL,
  `iqanc_action1_closed` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_action1_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqanc_action1_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqanc_action2` text COLLATE utf8mb4_unicode_ci,
  `iqanc_action2_effective` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_action2_followupdate` datetime DEFAULT NULL,
  `iqanc_action2_remarks` text COLLATE utf8mb4_unicode_ci,
  `iqanc_action2_approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `iqanc_action2_date_approved` datetime DEFAULT NULL,
  `iqanc_action2_closed` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_action2_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqanc_action2_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqanc_action3` text COLLATE utf8mb4_unicode_ci,
  `iqanc_action3_effective` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_action3_followupdate` datetime DEFAULT NULL,
  `iqanc_action3_remarks` text COLLATE utf8mb4_unicode_ci,
  `iqanc_action3_approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `iqanc_action3_date_approved` datetime DEFAULT NULL,
  `iqanc_action3_closed` tinyint(3) UNSIGNED DEFAULT '0',
  `iqanc_action3_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqanc_action3_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqa_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `iqanc_step` int(10) UNSIGNED DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqa_ncar_auditees`
--

CREATE TABLE `iqa_ncar_auditees` (
  `iqanctee_id` bigint(20) UNSIGNED NOT NULL,
  `iqanc_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqa_ncar_auditors`
--

CREATE TABLE `iqa_ncar_auditors` (
  `iqanctor_id` bigint(20) UNSIGNED NOT NULL,
  `iqanc_id` bigint(20) UNSIGNED DEFAULT '0',
  `user_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqa_ofis`
--

CREATE TABLE `iqa_ofis` (
  `iqaofi_id` bigint(20) UNSIGNED NOT NULL,
  `iqaofi_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqaofi_date` datetime DEFAULT NULL,
  `iqaofi_area` text COLLATE utf8mb4_unicode_ci,
  `iqaofi_opportunities` text COLLATE utf8mb4_unicode_ci,
  `iqaofi_acknowledgedby` bigint(20) UNSIGNED DEFAULT '0',
  `iqaofi_acknowledgedby_name` text COLLATE utf8mb4_unicode_ci,
  `iqaofi_date_acknowledged` datetime DEFAULT NULL,
  `iqaofi_implemented` tinyint(3) UNSIGNED DEFAULT '0',
  `iqaofi_ifnotreason` text COLLATE utf8mb4_unicode_ci,
  `iqaofi_reponsibleperson` bigint(20) UNSIGNED DEFAULT '0',
  `iqaofi_reponsibleperson_name` text COLLATE utf8mb4_unicode_ci,
  `iqaofi_completiondate` datetime DEFAULT NULL,
  `iqaofi_effectiveness` text COLLATE utf8mb4_unicode_ci,
  `iqaofi_monitoredby` bigint(20) UNSIGNED DEFAULT '0',
  `iqaofi_monitoredby_name` text COLLATE utf8mb4_unicode_ci,
  `iqaofi_monitoreddate` datetime DEFAULT NULL,
  `iqaofi_notedby` bigint(20) UNSIGNED DEFAULT '0',
  `iqaofi_notedby_name` text COLLATE utf8mb4_unicode_ci,
  `iqaofi_noteddate` datetime DEFAULT NULL,
  `iqaofi_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqaofi_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `iqa_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `iqaofi_status` text COLLATE utf8mb4_unicode_ci,
  `iqaofi_initiator` bigint(20) UNSIGNED DEFAULT '0',
  `iqaofi_initiator_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iqa_statuses`
--

CREATE TABLE `iqa_statuses` (
  `iqastat_id` bigint(20) UNSIGNED NOT NULL,
  `iqastat_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `iqa_statuses`
--

INSERT INTO `iqa_statuses` (`iqastat_id`, `iqastat_name`, `created_at`, `updated_at`) VALUES
(1, 'Scheduled', '2019-12-11 07:23:56', '2019-12-11 07:23:56'),
(2, 'For Reschedule', '2019-12-11 07:23:56', '2019-12-11 07:23:56'),
(3, 'Rescheduled', '2019-12-11 07:23:56', '2019-12-11 07:23:56'),
(4, 'Finished', '2019-12-11 07:23:56', '2019-12-11 07:23:56'),
(5, 'Cancelled', '2019-12-11 07:23:56', '2019-12-11 08:30:41');

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

--
-- Table structure for table `manuals`
--

CREATE TABLE `manuals` (
  `man_id` bigint(20) UNSIGNED NOT NULL,
  `effectivity_date` date DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `custom_code` tinyint(3) UNSIGNED DEFAULT '0',
  `year` int(10) UNSIGNED DEFAULT '0',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type_id` bigint(20) UNSIGNED DEFAULT '0',
  `type_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `div_id` bigint(20) UNSIGNED DEFAULT '0',
  `div_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `div_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sec_id` bigint(20) UNSIGNED DEFAULT '0',
  `sec_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sec_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `subject_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `series_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `page_count` int(10) UNSIGNED DEFAULT '0',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `rev_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `rev_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_date` datetime DEFAULT NULL,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_date` datetime DEFAULT NULL,
  `revision_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `revision_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_revision_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `revision` bigint(20) UNSIGNED DEFAULT '0',
  `req_id` int(10) UNSIGNED DEFAULT '0',
  `req_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `for_creation` tinyint(3) UNSIGNED DEFAULT '0',
  `for_revision` tinyint(3) UNSIGNED DEFAULT '0',
  `for_deletion` tinyint(3) UNSIGNED DEFAULT '0',
  `reason` text COLLATE utf8mb4_unicode_ci,
  `details` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `status_id` int(10) UNSIGNED DEFAULT '0',
  `status_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `documents` text COLLATE utf8mb4_unicode_ci,
  `file_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `doc_id` bigint(20) UNSIGNED DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `manual_divisions`
--

CREATE TABLE `manual_divisions` (
  `div_id` bigint(20) UNSIGNED NOT NULL,
  `div_abbr` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `div_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `manual_files`
--

CREATE TABLE `manual_files` (
  `file_id` bigint(20) UNSIGNED NOT NULL,
  `file_page_no` int(10) UNSIGNED DEFAULT '0',
  `file_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_size` bigint(20) UNSIGNED DEFAULT '0',
  `file_revision` bigint(20) UNSIGNED DEFAULT '0',
  `file_is_revision` tinyint(3) UNSIGNED DEFAULT '0',
  `page_count` int(10) UNSIGNED DEFAULT '0',
  `doc_id` bigint(20) UNSIGNED DEFAULT '0',
  `man_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `manual_file_revisions`
--

CREATE TABLE `manual_file_revisions` (
  `file_id` bigint(20) UNSIGNED NOT NULL,
  `file_page_no` int(10) UNSIGNED DEFAULT '0',
  `file_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_size` bigint(20) UNSIGNED DEFAULT '0',
  `file_revision` bigint(20) UNSIGNED DEFAULT '0',
  `page_count` int(10) UNSIGNED DEFAULT '0',
  `doc_id` bigint(20) UNSIGNED DEFAULT '0',
  `man_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `manual_histories`
--

CREATE TABLE `manual_histories` (
  `his_id` bigint(20) UNSIGNED NOT NULL,
  `effectivity_date` date DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `custom_code` tinyint(3) UNSIGNED DEFAULT '0',
  `year` int(10) UNSIGNED DEFAULT '0',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type_id` bigint(20) UNSIGNED DEFAULT '0',
  `type_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `div_id` bigint(20) UNSIGNED DEFAULT '0',
  `div_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `div_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sec_id` bigint(20) UNSIGNED DEFAULT '0',
  `sec_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sec_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `subject_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `series_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `page_count` int(10) UNSIGNED DEFAULT '0',
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_date` datetime DEFAULT NULL,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_date` datetime DEFAULT NULL,
  `revision_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `revision_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_revision_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `revision` int(10) UNSIGNED DEFAULT '0',
  `for_creation` tinyint(3) UNSIGNED DEFAULT '0',
  `for_revision` tinyint(3) UNSIGNED DEFAULT '0',
  `for_deletion` tinyint(3) UNSIGNED DEFAULT '0',
  `reason` text COLLATE utf8mb4_unicode_ci,
  `details` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `status_id` int(10) UNSIGNED DEFAULT '0',
  `status_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `docuements` text COLLATE utf8mb4_unicode_ci,
  `man_id` bigint(20) UNSIGNED DEFAULT '0',
  `file_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `manual_sections`
--

CREATE TABLE `manual_sections` (
  `sec_id` bigint(20) UNSIGNED NOT NULL,
  `sec_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `sec_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `type_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `manual_types`
--

CREATE TABLE `manual_types` (
  `type_id` bigint(20) UNSIGNED NOT NULL,
  `type_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `manual_types`
--

INSERT INTO `manual_types` (`type_id`, `type_abbr`, `type_name`, `created_at`, `updated_at`) VALUES
(1, 'QM', 'Quality Manual', '2019-11-21 06:49:10', '2019-11-21 06:57:21'),
(2, 'PM', 'Procedures Manual', '2019-11-21 06:49:01', '2020-03-24 06:26:24'),
(3, 'WI', 'Work Instructions Manual', '2019-11-21 06:49:22', '2020-03-24 06:26:36'),
(4, 'FM', 'Forms Manual', '2019-11-21 06:48:46', '2020-03-24 06:26:16'),
(5, 'AX', 'Appendix', '2020-03-23 15:07:01', '2020-03-24 02:34:27');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 2),
(3, '2019_08_19_000000_create_failed_jobs_table', 3),
(4, '2019_11_13_155910_create_functional_units_table', 4),
(5, '2019_11_13_160703_create_rights_table', 5),
(6, '2019_11_13_160730_create_user_logs_table', 6),
(7, '2019_11_19_133605_create_roles_table', 7),
(8, '2019_11_19_134624_create_role_rights_table', 8),
(9, '2019_11_19_135048_create_sites_sections_table', 9),
(10, '2019_11_20_104058_create_user_roles_table', 10),
(17, '2019_11_21_105622_create_manual_types_table', 11),
(23, '2019_11_25_161530_create_manual_divisions_table', 12),
(34, '2019_11_21_120910_create_manual_sections_table', 13),
(40, '2019_12_11_110701_create_iqas_table', 14),
(41, '2019_12_11_112239_create_iqa_statuses_table', 15),
(42, '2019_12_11_150113_create_iqa_auditees_table', 16),
(43, '2019_12_11_150849_create_iqa_auditors_table', 17),
(44, '2019_12_16_151609_create_iqa_ncars_table', 18),
(45, '2019_12_16_151702_create_iqa_evidences_table', 19),
(46, '2019_12_18_103859_create_iqa_ncar_auditors_table', 20),
(47, '2019_12_18_103907_create_iqa_ncar_auditees_table', 21),
(48, '2019_12_18_105643_create_iqa_checklists_table', 22),
(49, '2019_12_18_105659_create_iqa_ofis_table', 23),
(50, '2019_12_18_140349_create_iqa_checklist_items_table', 24),
(51, '2019_12_20_150739_create_ncar_types_table', 25),
(52, '2020_01_09_102730_create_user_settings_table', 26),
(54, '2020_02_16_203606_create_iqa_checklist_item_statuses_table', 27),
(57, '2020_03_19_125155_create_csm_services_table', 28),
(58, '2020_03_19_125212_create_csm_subjects_table', 29),
(63, '2020_03_19_224758_create_mrs_table', 30),
(64, '2020_03_19_225313_create_mr_files_table', 31),
(65, '2020_03_20_120036_create_mr_doc_types_table', 32),
(67, '2020_03_22_145818_create_cs_files_table', 34),
(68, '2020_03_22_145850_create_csm_provinces_table', 35),
(72, '2020_03_22_173034_create_quarters_table', 39),
(106, '2019_11_21_115006_create_manuals_table', 47),
(107, '2019_11_21_143607_create_manual_files_table', 48),
(109, '2020_04_01_103849_create_manual_file_revisions_table', 50),
(118, '2020_04_03_154548_create_apgs_table', 51),
(120, '2020_04_06_163124_create_apg_files_table', 51),
(121, '2020_04_06_163150_create_apg_file_revisions_table', 51),
(122, '2020_04_08_134126_create_apns_table', 52),
(132, '2020_04_27_133008_create_checklist_statuses_table', 58),
(134, '2020_04_27_124322_create_checklist_items_table', 59),
(139, '2020_05_12_163325_create_apn_auditors_table', 61),
(140, '2020_05_13_223851_create_apn_auditor_items_table', 61),
(181, '2020_03_22_145016_create_csfs_table', 62),
(185, '2020_03_22_145910_create_cs_provinces_table', 63),
(186, '2020_03_22_145927_create_cs_subjects_table', 63),
(187, '2020_03_22_145940_create_cs_services_table', 63),
(212, '2020_03_18_142345_create_foa_bos_table', 64),
(213, '2020_03_18_142408_create_foa_fos_table', 64),
(215, '2020_03_18_152459_create_fuw_table', 64),
(218, '2020_06_03_220405_create_semesters_table', 64),
(220, '2020_03_18_142459_create_fuw_targets_table', 65),
(225, '2020_03_18_211323_create_pcd_targets_table', 67),
(226, '2020_06_11_133322_create_pcds_table', 66),
(228, '2020_05_07_134458_create_apn_schedule_items_table', 68),
(229, '2020_06_16_134516_create_accomplishment_files_table', 68),
(230, '2020_04_14_154026_create_ncs_table', 69),
(231, '2020_04_27_124255_create_checklists_table', 69),
(232, '2020_04_27_124336_create_ofis_table', 69),
(233, '2020_04_27_131836_create_pfs_table', 69),
(234, '2020_05_06_132004_create_apn_schedules_table', 70),
(235, '2020_03_18_221323_create_accomplishments_table', 71),
(236, '2020_06_22_122436_alter_cs_subjects_table', 72),
(237, '2020_06_22_122929_alter_cs_services_table', 73),
(238, '2020_06_22_132016_alter_csm_services_table', 74),
(239, '2020_07_15_091350_create_audit_questions_table', 75),
(240, '2020_07_16_094713_create_counters_table', 75),
(241, '2020_08_03_133908_modify_foabos_table', 76),
(242, '2020_09_11_162337_create_notices_table', 77),
(243, '2020_10_05_131926_alter_ncs_table', 77),
(244, '2020_10_05_131946_alter_pfs_table', 77),
(245, '2020_10_05_131959_alter_ofis_table', 77),
(246, '2020_10_05_132051_alter_apn_checklist_items_table', 77),
(247, '2020_10_05_140915_create_comments_table', 77),
(248, '2020_10_10_163100_alter_functional_units_table', 77),
(249, '2020_10_11_180031_alter_apgs_table', 77),
(250, '2020_10_16_130841_alter_foabos_table', 78),
(251, '2020_10_19_093141_alter_ofis_table', 78),
(252, '2020_10_19_093141_alter_ofis_table_effectivity', 79),
(253, '2020_10_21_135025_alter_pfs_table_acknowledgement', 79),
(254, '2020_10_21_145312_alter_counters_table', 79),
(255, '2020_11_19_153801_alter_pfs_add_target_fus', 80),
(256, '2020_11_19_153829_alter_ncs_add_target_fus', 80),
(257, '2020_11_19_153843_alter_ofis_add_target_fus', 80),
(258, '2020_11_25_103635_create_risks_table', 81),
(259, '2020_11_25_103751_create_impacts_table', 81),
(260, '2020_11_25_103806_create_frequencies_table', 81),
(261, '2020_11_25_103819_create_detections_table', 81),
(262, '2020_11_25_104110_create_risk_types_table', 81),
(263, '2020_11_25_170503_create_risk_docs_table', 81),
(264, '2020_11_25_215730_create_prioritizations_table', 81),
(265, '2020_12_01_110752_alter_risk_table', 82),
(266, '2020_12_02_093604_alter_apn_schedule', 82),
(267, '2020_12_04_104606_create_mls_table', 83),
(268, '2020_12_07_134832_create_ml_files_table', 83),
(269, '2020_12_07_135031_create_ml_file_revisions_table', 83),
(270, '2020_12_14_155841_create_eds_table', 83),
(271, '2021_01_11_135314_alter_ofis_for_action', 84),
(272, '2021_01_22_101722_create_risk_treatments_table', 85),
(273, '2021_01_22_113330_create_nc_actions_table', 85),
(274, '2021_01_22_135300_create_nc_planned_actions_table', 85),
(275, '2021_02_04_155841_create_nc_action_files_table', 85),
(276, '2021_02_08_093703_create_information_systems_table', 85),
(277, '2021_02_08_094507_create_ars_table', 85),
(278, '2021_02_08_094546_create_ar_files_table', 85),
(279, '2021_02_08_151233_create_ar_types_table', 85),
(280, '2021_02_09_085712_create_nc_ic_actions_table', 85),
(281, '2021_02_09_085822_create_nc_ic_action_files_table', 85),
(282, '2021_02_10_211827_add_nc_table_marker', 85),
(283, '2021_02_16_114250_alter_nc_action_files', 85),
(284, '2021_02_23_140508_alter_ofis_for_multiple_responsible', 86),
(285, '2021_02_23_152628_create_ofi_files_table', 86),
(286, '2021_02_23_152654_create_ofi_actions_table', 86),
(287, '2021_02_23_152706_create_ofi_action_files_table', 86),
(288, '2021_02_26_154102_alter_nc_planned_action_for_final_audit_results', 86),
(289, '2021_03_03_111615_alter_counters_table_add_year', 86),
(290, '2021_03_08_033406_alter_ofi_actions_multiple_persons', 87),
(291, '2021_03_10_010457_create_pf_files_table', 88),
(300, '2021_07_30_230621_create_seers_table', 89);

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

--
-- Table structure for table `mls`
--

CREATE TABLE `mls` (
  `ml_id` bigint(20) UNSIGNED NOT NULL,
  `effectivity_date` date DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'FM-RO-ML F2',
  `custom_code` tinyint(3) UNSIGNED DEFAULT '0',
  `year` int(10) UNSIGNED DEFAULT '0',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sem` int(10) UNSIGNED DEFAULT '0',
  `sem_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type_id` bigint(20) UNSIGNED DEFAULT '6',
  `type_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'ML',
  `type_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Master List of Quality Records',
  `div_id` bigint(20) UNSIGNED DEFAULT '0',
  `div_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'RO',
  `div_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Regional Office',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sec_id` bigint(20) UNSIGNED DEFAULT '0',
  `sec_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '01',
  `sec_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'ML',
  `subject_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Master List of Quality Records',
  `series_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `page_count` int(10) UNSIGNED DEFAULT '0',
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_date` datetime DEFAULT NULL,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_date` datetime DEFAULT NULL,
  `revision_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `revision_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_revision_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `revision` bigint(20) UNSIGNED DEFAULT '0',
  `req_id` int(10) UNSIGNED DEFAULT '0',
  `req_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `for_creation` tinyint(3) UNSIGNED DEFAULT '0',
  `for_revision` tinyint(3) UNSIGNED DEFAULT '0',
  `for_deletion` tinyint(3) UNSIGNED DEFAULT '0',
  `reason` text COLLATE utf8mb4_unicode_ci,
  `details` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `status_id` int(10) UNSIGNED DEFAULT '0',
  `status_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `documents` text COLLATE utf8mb4_unicode_ci,
  `file_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `doc_id` bigint(20) UNSIGNED DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `objectives` text COLLATE utf8mb4_unicode_ci,
  `scope` text COLLATE utf8mb4_unicode_ci,
  `scope_table` text COLLATE utf8mb4_unicode_ci,
  `criteria` text COLLATE utf8mb4_unicode_ci,
  `frequency` text COLLATE utf8mb4_unicode_ci,
  `methodology` text COLLATE utf8mb4_unicode_ci,
  `applicable` text COLLATE utf8mb4_unicode_ci,
  `auditors` text COLLATE utf8mb4_unicode_ci,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `rev_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `rev_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ml_files`
--

CREATE TABLE `ml_files` (
  `file_id` bigint(20) UNSIGNED NOT NULL,
  `file_page_no` int(10) UNSIGNED DEFAULT '0',
  `file_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_size` bigint(20) UNSIGNED DEFAULT '0',
  `file_revision` bigint(20) UNSIGNED DEFAULT '0',
  `file_is_revision` tinyint(3) UNSIGNED DEFAULT '0',
  `page_count` int(10) UNSIGNED DEFAULT '0',
  `doc_id` bigint(20) UNSIGNED DEFAULT '0',
  `ml_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ml_file_revisions`
--

CREATE TABLE `ml_file_revisions` (
  `file_id` bigint(20) UNSIGNED NOT NULL,
  `file_page_no` int(10) UNSIGNED DEFAULT '0',
  `file_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `file_size` bigint(20) UNSIGNED DEFAULT '0',
  `file_revision` bigint(20) UNSIGNED DEFAULT '0',
  `page_count` int(10) UNSIGNED DEFAULT '0',
  `doc_id` bigint(20) UNSIGNED DEFAULT '0',
  `ml_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `mrs`
--

CREATE TABLE `mrs` (
  `mr_id` bigint(20) UNSIGNED NOT NULL,
  `mr_date` datetime DEFAULT NULL,
  `mr_subject` text COLLATE utf8mb4_unicode_ci,
  `mr_venue` text COLLATE utf8mb4_unicode_ci,
  `mr_remarks` text COLLATE utf8mb4_unicode_ci,
  `mr_lattitude` text COLLATE utf8mb4_unicode_ci,
  `mr_longitude` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `mr_year` int(10) UNSIGNED DEFAULT '0',
  `mr_qtr` int(10) UNSIGNED DEFAULT '0',
  `mr_qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mr_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mr_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `mr_doc_types`
--

CREATE TABLE `mr_doc_types` (
  `mrdt_id` bigint(20) UNSIGNED NOT NULL,
  `mrdt_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mr_doc_types`
--

INSERT INTO `mr_doc_types` (`mrdt_id`, `mrdt_name`, `created_at`, `updated_at`) VALUES
(1, 'Action Sheet', '2020-03-20 05:27:39', '2020-03-20 05:27:39'),
(2, 'Agenda', '2020-03-20 05:27:53', '2020-03-20 05:27:53'),
(3, 'Attendance Sheet', '2020-03-20 05:28:06', '2020-03-20 05:28:06'),
(4, 'Continual Improvement Activities Report', '2020-03-20 05:28:18', '2020-03-20 05:28:18'),
(5, 'Corporate Objective Attainment Report', '2020-03-20 05:28:31', '2020-03-20 05:28:31'),
(6, 'Customer Satisfaction Measurement Report', '2020-03-20 05:28:42', '2020-03-20 05:28:42'),
(7, 'Functional Objectives Attainment Report', '2020-03-20 05:28:54', '2020-03-20 05:28:54'),
(8, 'Memo', '2020-03-20 05:29:03', '2020-03-20 05:29:03'),
(9, 'Minutes of the Management Review', '2020-03-20 05:29:15', '2020-03-20 05:29:15'),
(10, 'Presentation', '2020-03-20 05:29:26', '2020-03-20 05:29:26'),
(11, 'Risk & Opportunities Monitoring Report', '2020-03-20 05:29:37', '2020-03-20 05:29:37'),
(12, 'Minutes of MANCOM', '2020-06-22 03:34:56', '2020-06-22 03:34:56'),
(13, 'Status of Nonconformities', '2021-02-22 06:47:47', '2021-02-22 06:47:47'),
(14, 'Status of Opportunities for Improvement', '2021-02-22 06:48:07', '2021-02-22 06:48:07'),
(15, 'Performance Reports', '2021-02-22 06:48:22', '2021-02-22 06:48:22'),
(16, 'Others', '2021-02-22 06:48:34', '2021-02-22 06:48:34');

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

--
-- Table structure for table `mr_files`
--

CREATE TABLE `mr_files` (
  `mrf_id` bigint(20) UNSIGNED NOT NULL,
  `mrf_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mrf_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mrf_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mrf_remarks` text COLLATE utf8mb4_unicode_ci,
  `mr_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `mrdt_id` bigint(20) UNSIGNED DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ncar_types`
--

CREATE TABLE `ncar_types` (
  `nctype_id` bigint(20) UNSIGNED NOT NULL,
  `nctype_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ncar_types`
--

INSERT INTO `ncar_types` (`nctype_id`, `nctype_name`, `created_at`, `updated_at`) VALUES
(1, 'Minor', NULL, NULL),
(2, 'Major', NULL, NULL);

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

--
-- Table structure for table `ncs`
--

CREATE TABLE `ncs` (
  `nc_id` bigint(20) UNSIGNED NOT NULL,
  `no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type_id` tinyint(3) UNSIGNED DEFAULT '0',
  `type_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `internal` tinyint(3) UNSIGNED DEFAULT '0',
  `systems` tinyint(3) UNSIGNED DEFAULT '0',
  `complaints` tinyint(3) UNSIGNED DEFAULT '0',
  `review` tinyint(3) UNSIGNED DEFAULT '0',
  `targets` tinyint(3) UNSIGNED DEFAULT '0',
  `analysis` tinyint(3) UNSIGNED DEFAULT '0',
  `qms` tinyint(3) UNSIGNED DEFAULT '0',
  `legal` tinyint(3) UNSIGNED DEFAULT '0',
  `origins` text COLLATE utf8mb4_unicode_ci,
  `clauses` text COLLATE utf8mb4_unicode_ci,
  `auditors` text COLLATE utf8mb4_unicode_ci,
  `auditees` text COLLATE utf8mb4_unicode_ci,
  `auditor_ids` text COLLATE utf8mb4_unicode_ci,
  `auditee_ids` text COLLATE utf8mb4_unicode_ci,
  `desc` text COLLATE utf8mb4_unicode_ci,
  `acknowledgedby` bigint(20) UNSIGNED DEFAULT '0',
  `acknowledgedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `acknowledgedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `acknowledgedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `acknowledgedby_date` datetime DEFAULT NULL,
  `corr` text COLLATE utf8mb4_unicode_ci,
  `corr_personreponsible` bigint(20) UNSIGNED DEFAULT '0',
  `corr_personreponsible_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `corr_dateimplemented` datetime DEFAULT NULL,
  `cause` text COLLATE utf8mb4_unicode_ci,
  `cause_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `cause_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `planned_action` text COLLATE utf8mb4_unicode_ci,
  `planned_completiondate` datetime DEFAULT NULL,
  `planned_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `planned_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a1` text COLLATE utf8mb4_unicode_ci,
  `a1_effective` tinyint(3) UNSIGNED DEFAULT '0',
  `a1_closed` tinyint(3) UNSIGNED DEFAULT '0',
  `a1_followupdate` datetime DEFAULT NULL,
  `a1_remarks` text COLLATE utf8mb4_unicode_ci,
  `a1_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a1_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a1_approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `a1_approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a1_approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a1_approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a1_approvedby_date` datetime DEFAULT NULL,
  `a2` text COLLATE utf8mb4_unicode_ci,
  `a2_effective` tinyint(3) UNSIGNED DEFAULT '0',
  `a2_closed` tinyint(3) UNSIGNED DEFAULT '0',
  `a2_followupdate` datetime DEFAULT NULL,
  `a2_remarks` text COLLATE utf8mb4_unicode_ci,
  `a2_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a2_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a2_approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `a2_approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a2_approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a2_approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a2_approvedby_date` datetime DEFAULT NULL,
  `a3` text COLLATE utf8mb4_unicode_ci,
  `a3_effective` tinyint(3) UNSIGNED DEFAULT '0',
  `a3_closed` tinyint(3) UNSIGNED DEFAULT '0',
  `a3_followupdate` datetime DEFAULT NULL,
  `a3_remarks` text COLLATE utf8mb4_unicode_ci,
  `a3_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a3_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a3_approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `a3_approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a3_approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a3_approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a3_approvedby_date` datetime DEFAULT NULL,
  `a4` text COLLATE utf8mb4_unicode_ci,
  `a4_effective` tinyint(3) UNSIGNED DEFAULT '0',
  `a4_closed` tinyint(3) UNSIGNED DEFAULT '0',
  `a4_followupdate` datetime DEFAULT NULL,
  `a4_remarks` text COLLATE utf8mb4_unicode_ci,
  `a4_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a4_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a4_approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `a4_approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a4_approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a4_approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a4_approvedby_date` datetime DEFAULT NULL,
  `a5` text COLLATE utf8mb4_unicode_ci,
  `a5_effective` tinyint(3) UNSIGNED DEFAULT '0',
  `a5_closed` tinyint(3) UNSIGNED DEFAULT '0',
  `a5_followupdate` datetime DEFAULT NULL,
  `a5_remarks` text COLLATE utf8mb4_unicode_ci,
  `a5_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a5_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a5_approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `a5_approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a5_approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a5_approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a5_approvedby_date` datetime DEFAULT NULL,
  `a6` text COLLATE utf8mb4_unicode_ci,
  `a6_effective` tinyint(3) UNSIGNED DEFAULT '0',
  `a6_closed` tinyint(3) UNSIGNED DEFAULT '0',
  `a6_followupdate` datetime DEFAULT NULL,
  `a6_remarks` text COLLATE utf8mb4_unicode_ci,
  `a6_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a6_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a6_approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `a6_approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a6_approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a6_approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `a6_approvedby_date` datetime DEFAULT NULL,
  `apn_id` bigint(20) UNSIGNED DEFAULT '0',
  `sd_id` bigint(20) UNSIGNED DEFAULT '0',
  `sd_desc` text COLLATE utf8mb4_unicode_ci,
  `verifiedon_date` date DEFAULT NULL,
  `closedon_date` date DEFAULT NULL,
  `completion_date` date DEFAULT NULL,
  `status_id` bigint(20) UNSIGNED DEFAULT '0',
  `status_date` date DEFAULT NULL,
  `status_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `chki_id` bigint(20) UNSIGNED DEFAULT '0',
  `sd_auditees` text COLLATE utf8mb4_unicode_ci,
  `sd_auditee_ids` text COLLATE utf8mb4_unicode_ci,
  `converted` tinyint(3) UNSIGNED DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `nc_actions`
--

CREATE TABLE `nc_actions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED DEFAULT '0',
  `nc_id` bigint(20) UNSIGNED DEFAULT '0',
  `apn_id` bigint(20) UNSIGNED DEFAULT '0',
  `action` text COLLATE utf8mb4_unicode_ci,
  `followup_date` datetime DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby` text COLLATE utf8mb4_unicode_ci,
  `preparedby_name` text COLLATE utf8mb4_unicode_ci,
  `preparedby_date` datetime DEFAULT NULL,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_date` datetime DEFAULT NULL,
  `effective` tinyint(3) UNSIGNED DEFAULT '0',
  `closed` tinyint(3) UNSIGNED DEFAULT '0',
  `is_final` tinyint(3) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `nc_action_files`
--

CREATE TABLE `nc_action_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `size` bigint(20) UNSIGNED DEFAULT '0',
  `action_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `side` tinyint(3) UNSIGNED DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `nc_ic_actions`
--

CREATE TABLE `nc_ic_actions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ic_id` bigint(20) UNSIGNED DEFAULT '0',
  `nc_id` bigint(20) UNSIGNED DEFAULT '0',
  `apn_id` bigint(20) UNSIGNED DEFAULT '0',
  `action` text COLLATE utf8mb4_unicode_ci,
  `responsible_ids` text COLLATE utf8mb4_unicode_ci,
  `responsible_names` text COLLATE utf8mb4_unicode_ci,
  `completion_date` datetime DEFAULT NULL,
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_date` datetime DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_date` datetime DEFAULT NULL,
  `followup_date` datetime DEFAULT NULL,
  `effective` tinyint(3) UNSIGNED DEFAULT '0',
  `closed` tinyint(3) UNSIGNED DEFAULT '0',
  `is_final` tinyint(3) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `nc_ic_action_files`
--

CREATE TABLE `nc_ic_action_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `size` bigint(20) UNSIGNED DEFAULT '0',
  `side` tinyint(3) UNSIGNED DEFAULT '0',
  `ica_id` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `nc_planned_actions`
--

CREATE TABLE `nc_planned_actions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nc_id` bigint(20) UNSIGNED DEFAULT '0',
  `apn_id` bigint(20) UNSIGNED DEFAULT '0',
  `action` text COLLATE utf8mb4_unicode_ci,
  `responsible` text COLLATE utf8mb4_unicode_ci,
  `responsible_name` text COLLATE utf8mb4_unicode_ci,
  `followup_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_final` tinyint(3) UNSIGNED DEFAULT '0',
  `status` tinyint(3) UNSIGNED DEFAULT '0',
  `status_name` text COLLATE utf8mb4_unicode_ci,
  `approvedby` int(11) DEFAULT NULL,
  `approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approvedby_division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approvedby_designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approvedby_date` date DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `auditor_fup_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `notices`
--

CREATE TABLE `notices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `showon` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `msg` text COLLATE utf8mb4_unicode_ci,
  `readerids` text COLLATE utf8mb4_unicode_ci,
  `userids` text COLLATE utf8mb4_unicode_ci,
  `unitids` text COLLATE utf8mb4_unicode_ci,
  `readernames` text COLLATE utf8mb4_unicode_ci,
  `usernames` text COLLATE utf8mb4_unicode_ci,
  `unitnames` text COLLATE utf8mb4_unicode_ci,
  `route` text COLLATE utf8mb4_unicode_ci,
  `typeid` int(10) UNSIGNED DEFAULT '0',
  `typename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ofis`
--

CREATE TABLE `ofis` (
  `ofi_id` bigint(20) UNSIGNED NOT NULL,
  `no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `area` text COLLATE utf8mb4_unicode_ci,
  `opportunities` text COLLATE utf8mb4_unicode_ci,
  `acknowledgedby` bigint(20) UNSIGNED DEFAULT '0',
  `acknowledgedby_name` text COLLATE utf8mb4_unicode_ci,
  `acknowledgedby_date` datetime DEFAULT NULL,
  `implemented` tinyint(3) UNSIGNED DEFAULT '0',
  `ifnotreason` text COLLATE utf8mb4_unicode_ci,
  `reponsibleperson` bigint(20) UNSIGNED DEFAULT '0',
  `reponsibleperson_name` text COLLATE utf8mb4_unicode_ci,
  `completiondate` datetime DEFAULT NULL,
  `effectiveness` text COLLATE utf8mb4_unicode_ci,
  `monitoredby` bigint(20) UNSIGNED DEFAULT '0',
  `monitoredby_name` text COLLATE utf8mb4_unicode_ci,
  `monitoredby_date` datetime DEFAULT NULL,
  `notedby` bigint(20) UNSIGNED DEFAULT '0',
  `notedby_name` text COLLATE utf8mb4_unicode_ci,
  `notedby_date` datetime DEFAULT NULL,
  `status_id` int(10) UNSIGNED DEFAULT '0',
  `status` text COLLATE utf8mb4_unicode_ci,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `auditors` text COLLATE utf8mb4_unicode_ci,
  `auditees` text COLLATE utf8mb4_unicode_ci,
  `auditor_ids` text COLLATE utf8mb4_unicode_ci,
  `auditee_ids` text COLLATE utf8mb4_unicode_ci,
  `apn_id` bigint(20) UNSIGNED DEFAULT '0',
  `sd_id` bigint(20) UNSIGNED DEFAULT '0',
  `sd_desc` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `chki_id` bigint(20) UNSIGNED DEFAULT '0',
  `effective` tinyint(3) UNSIGNED DEFAULT '0',
  `sd_auditees` text COLLATE utf8mb4_unicode_ci,
  `sd_auditee_ids` text COLLATE utf8mb4_unicode_ci,
  `action` text COLLATE utf8mb4_unicode_ci,
  `action_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `action_oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `action_date` datetime DEFAULT NULL,
  `responsible_ids` text COLLATE utf8mb4_unicode_ci,
  `responsible_names` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ofi_actions`
--

CREATE TABLE `ofi_actions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ofi_id` bigint(20) UNSIGNED DEFAULT '0',
  `planned_action` text COLLATE utf8mb4_unicode_ci,
  `responsible` text COLLATE utf8mb4_unicode_ci,
  `responsible_name` text COLLATE utf8mb4_unicode_ci,
  `completion_date` datetime DEFAULT NULL,
  `preparedby` text COLLATE utf8mb4_unicode_ci,
  `preparedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_date` datetime DEFAULT NULL,
  `action` text COLLATE utf8mb4_unicode_ci,
  `actionby` bigint(20) UNSIGNED DEFAULT '0',
  `actionby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `actionby_date` datetime DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `approvedby_date` datetime DEFAULT NULL,
  `followup_date` datetime DEFAULT NULL,
  `effective` tinyint(3) UNSIGNED DEFAULT '0',
  `closed` tinyint(3) UNSIGNED DEFAULT '0',
  `is_final` tinyint(3) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ofi_action_files`
--

CREATE TABLE `ofi_action_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `size` bigint(20) UNSIGNED DEFAULT '0',
  `action_id` bigint(20) UNSIGNED DEFAULT '0',
  `ofi_id` bigint(20) UNSIGNED DEFAULT '0',
  `side` tinyint(3) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ofi_files`
--

CREATE TABLE `ofi_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `size` bigint(20) UNSIGNED DEFAULT '0',
  `ofi_id` bigint(20) UNSIGNED DEFAULT '0',
  `side` bigint(20) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pcds`
--

CREATE TABLE `pcds` (
  `pcd_id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` tinyint(3) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` tinyint(3) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sem` tinyint(3) UNSIGNED DEFAULT '0',
  `sem_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` text COLLATE utf8mb4_unicode_ci,
  `preparedby_date` datetime DEFAULT NULL,
  `preparedby_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `reviewedby` bigint(20) UNSIGNED DEFAULT '0',
  `reviewedby_date` datetime DEFAULT NULL,
  `reviewedby_name` text COLLATE utf8mb4_unicode_ci,
  `approvedby` bigint(20) UNSIGNED DEFAULT '0',
  `approvedby_date` datetime DEFAULT NULL,
  `approvedby_name` text COLLATE utf8mb4_unicode_ci,
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pcd_targets`
--

CREATE TABLE `pcd_targets` (
  `pt_id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sem` int(10) UNSIGNED DEFAULT '0',
  `sem_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `no` bigint(20) UNSIGNED DEFAULT '0',
  `parent` bigint(20) UNSIGNED DEFAULT '0',
  `level` tinyint(3) UNSIGNED DEFAULT '0',
  `is_category` tinyint(3) UNSIGNED DEFAULT '0',
  `desc` text COLLATE utf8mb4_unicode_ci,
  `success` text COLLATE utf8mb4_unicode_ci,
  `qty` int(10) UNSIGNED DEFAULT '0',
  `acc` int(10) UNSIGNED DEFAULT '0',
  `acc_desc` text COLLATE utf8mb4_unicode_ci,
  `quantity` int(10) UNSIGNED DEFAULT '0',
  `effort` int(10) UNSIGNED DEFAULT '0',
  `timeliness` int(10) UNSIGNED DEFAULT '0',
  `average` decimal(8,2) UNSIGNED DEFAULT '0.00',
  `u_id` bigint(20) UNSIGNED DEFAULT '0',
  `u_initials` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pcd_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fo_id` bigint(20) UNSIGNED DEFAULT '0',
  `fo_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fo_name` text COLLATE utf8mb4_unicode_ci,
  `bo_id` bigint(20) UNSIGNED DEFAULT '0',
  `bo_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `bo_name` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_fixed` tinyint(3) UNSIGNED DEFAULT '0',
  `target_year` int(10) UNSIGNED DEFAULT '2020',
  `target_month` tinyint(3) UNSIGNED DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pfs`
--

CREATE TABLE `pfs` (
  `pf_id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` text COLLATE utf8mb4_unicode_ci,
  `preparedby_date` datetime DEFAULT NULL,
  `clause` text COLLATE utf8mb4_unicode_ci,
  `area` text COLLATE utf8mb4_unicode_ci,
  `desc` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `auditors` text COLLATE utf8mb4_unicode_ci,
  `auditees` text COLLATE utf8mb4_unicode_ci,
  `auditor_ids` text COLLATE utf8mb4_unicode_ci,
  `auditee_ids` text COLLATE utf8mb4_unicode_ci,
  `apn_id` bigint(20) UNSIGNED DEFAULT '0',
  `sd_id` bigint(20) UNSIGNED DEFAULT '0',
  `sd_desc` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `chki_id` bigint(20) UNSIGNED DEFAULT '0',
  `acknowledgedby` bigint(20) UNSIGNED DEFAULT '0',
  `acknowledgedby_name` text COLLATE utf8mb4_unicode_ci,
  `acknowledgedby_date` datetime DEFAULT NULL,
  `monitoredby` bigint(20) UNSIGNED DEFAULT '0',
  `monitoredby_name` text COLLATE utf8mb4_unicode_ci,
  `monitoredby_date` datetime DEFAULT NULL,
  `notedby` bigint(20) UNSIGNED DEFAULT '0',
  `notedby_name` text COLLATE utf8mb4_unicode_ci,
  `notedby_date` datetime DEFAULT NULL,
  `status_id` int(10) UNSIGNED DEFAULT '0',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `sd_auditees` text COLLATE utf8mb4_unicode_ci,
  `sd_auditee_ids` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pf_files`
--

CREATE TABLE `pf_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `size` bigint(20) UNSIGNED DEFAULT '0',
  `pf_id` bigint(20) UNSIGNED DEFAULT '0',
  `side` tinyint(3) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `prioritizations`
--

CREATE TABLE `prioritizations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `min` int(10) UNSIGNED DEFAULT '0',
  `max` int(10) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prioritizations`
--

INSERT INTO `prioritizations` (`id`, `name`, `min`, `max`, `created_at`, `updated_at`) VALUES
(1, 'Low', 1, 15, NULL, NULL),
(2, 'Moderate', 16, 50, NULL, NULL),
(3, 'High', 51, 125, NULL, NULL);

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

--
-- Table structure for table `quarters`
--

CREATE TABLE `quarters` (
  `qtr_id` bigint(20) UNSIGNED NOT NULL,
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quarters`
--

INSERT INTO `quarters` (`qtr_id`, `qtr_name`, `created_at`, `updated_at`) VALUES
(1, '1st Quarter', NULL, NULL),
(2, '2nd Quarter', NULL, NULL),
(3, '3rd Quarter', NULL, NULL),
(4, '4rth Quarter', NULL, NULL);

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

--
-- Table structure for table `rights`
--

CREATE TABLE `rights` (
  `right_id` bigint(20) UNSIGNED NOT NULL,
  `right_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rights`
--

INSERT INTO `rights` (`right_id`, `right_name`, `created_at`, `updated_at`) VALUES
(1, 'View', NULL, NULL),
(2, 'Add', NULL, NULL),
(3, 'Edit', NULL, NULL),
(4, 'Delete', NULL, NULL);

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

--
-- Table structure for table `risks`
--

CREATE TABLE `risks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `customers` text COLLATE utf8mb4_unicode_ci,
  `services` text COLLATE utf8mb4_unicode_ci,
  `expectations` text COLLATE utf8mb4_unicode_ci,
  `event` text COLLATE utf8mb4_unicode_ci,
  `type_id` bigint(20) UNSIGNED DEFAULT '1',
  `type_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `consequence` text COLLATE utf8mb4_unicode_ci,
  `impact_id` bigint(20) UNSIGNED DEFAULT '0',
  `impact_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `trigger` text COLLATE utf8mb4_unicode_ci,
  `frequency_id` bigint(20) UNSIGNED DEFAULT '0',
  `frequency_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `detection` text COLLATE utf8mb4_unicode_ci,
  `detection_id` bigint(20) UNSIGNED DEFAULT '0',
  `detection_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `total` bigint(20) UNSIGNED DEFAULT '0',
  `prioritization` bigint(20) UNSIGNED DEFAULT '0',
  `prioritization_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `response` text COLLATE utf8mb4_unicode_ci,
  `responsible` bigint(20) UNSIGNED DEFAULT '0',
  `responsible_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `responseby` bigint(20) UNSIGNED DEFAULT '0',
  `responseby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `responseby_date` datetime DEFAULT NULL,
  `completion_date` date DEFAULT NULL,
  `related` text COLLATE utf8mb4_unicode_ci,
  `occurred` tinyint(3) UNSIGNED DEFAULT '0',
  `mon_impact_id` tinyint(3) UNSIGNED DEFAULT '0',
  `mon_impact_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mon_frequency_id` bigint(20) UNSIGNED DEFAULT '0',
  `mon_frequency_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mon_detection_id` bigint(20) UNSIGNED DEFAULT '0',
  `mon_detection_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mon_total` bigint(20) UNSIGNED DEFAULT '0',
  `mon_prioritization` bigint(20) UNSIGNED DEFAULT '0',
  `mon_prioritization_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `monitoredby` bigint(20) UNSIGNED DEFAULT '0',
  `monitoredby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `monitoredby_date` datetime DEFAULT NULL,
  `justification` text COLLATE utf8mb4_unicode_ci,
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_date` datetime DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '1',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `status` int(10) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `fu_ids` text COLLATE utf8mb4_unicode_ci,
  `fu_names` text COLLATE utf8mb4_unicode_ci,
  `strategic` tinyint(3) UNSIGNED DEFAULT '0',
  `mon_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `risk_docs`
--

CREATE TABLE `risk_docs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime DEFAULT NULL,
  `risk_id` bigint(20) UNSIGNED DEFAULT '0',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `oldfilename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `desc` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `risk_treatments`
--

CREATE TABLE `risk_treatments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `risk_id` bigint(20) UNSIGNED DEFAULT '0',
  `response` text COLLATE utf8mb4_unicode_ci,
  `responsible` bigint(20) UNSIGNED DEFAULT '0',
  `responsible_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `responseby` bigint(20) UNSIGNED DEFAULT '0',
  `responseby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `responseby_date` datetime DEFAULT NULL,
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `justification` text COLLATE utf8mb4_unicode_ci,
  `completion_date` date DEFAULT NULL,
  `occurred` tinyint(3) UNSIGNED DEFAULT '0',
  `mon_impact_id` tinyint(3) UNSIGNED DEFAULT '0',
  `mon_impact_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mon_frequency_id` bigint(20) UNSIGNED DEFAULT '0',
  `mon_frequency_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mon_detection_id` bigint(20) UNSIGNED DEFAULT '0',
  `mon_detection_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `mon_total` bigint(20) UNSIGNED DEFAULT '0',
  `mon_prioritization` bigint(20) UNSIGNED DEFAULT '0',
  `mon_prioritization_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `monitoredby` bigint(20) UNSIGNED DEFAULT '0',
  `monitoredby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `monitoredby_date` datetime DEFAULT NULL,
  `preparedby` bigint(20) UNSIGNED DEFAULT '0',
  `preparedby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `preparedby_date` datetime DEFAULT NULL,
  `status` int(10) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `risk_types`
--

CREATE TABLE `risk_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `risk_types`
--

INSERT INTO `risk_types` (`id`, `abbr`, `name`, `created_at`, `updated_at`) VALUES
(1, 'R', 'Risk', NULL, NULL),
(2, 'O', 'Opportunity', NULL, NULL);

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `role_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`role_id`, `role_name`, `created_at`, `updated_at`) VALUES
(1, 'Administrator', NULL, '2019-11-20 07:59:52'),
(2, 'Viewer', NULL, '2019-11-20 08:00:27'),
(5, 'Users', '2019-11-20 07:58:26', '2019-11-20 07:58:26');

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

--
-- Table structure for table `role_rights`
--

CREATE TABLE `role_rights` (
  `rr_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `right_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `sitesection_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_rights`
--

INSERT INTO `role_rights` (`rr_id`, `role_id`, `right_id`, `sitesection_id`, `created_at`, `updated_at`) VALUES
(77, 5, 1, 6, '2019-11-20 07:58:54', '2019-11-20 07:58:54'),
(78, 5, 2, 6, '2019-11-20 07:58:54', '2019-11-20 07:58:54'),
(79, 5, 3, 6, '2019-11-20 07:58:54', '2019-11-20 07:58:54'),
(80, 5, 1, 5, '2019-11-20 07:58:54', '2019-11-20 07:58:54'),
(81, 5, 1, 7, '2019-11-20 07:58:54', '2019-11-20 07:58:54'),
(82, 5, 2, 7, '2019-11-20 07:58:55', '2019-11-20 07:58:55'),
(83, 5, 3, 7, '2019-11-20 07:58:55', '2019-11-20 07:58:55'),
(84, 5, 1, 8, '2019-11-20 07:58:55', '2019-11-20 07:58:55'),
(85, 5, 2, 8, '2019-11-20 07:58:55', '2019-11-20 07:58:55'),
(86, 5, 3, 8, '2019-11-20 07:58:55', '2019-11-20 07:58:55'),
(87, 5, 1, 2, '2019-11-20 07:58:55', '2019-11-20 07:58:55'),
(88, 5, 1, 9, '2019-11-20 07:58:55', '2019-11-20 07:58:55'),
(89, 5, 2, 9, '2019-11-20 07:58:55', '2019-11-20 07:58:55'),
(90, 5, 3, 9, '2019-11-20 07:58:55', '2019-11-20 07:58:55'),
(163, 1, 1, 6, '2019-11-20 07:59:52', '2019-11-20 07:59:52'),
(164, 1, 2, 6, '2019-11-20 07:59:52', '2019-11-20 07:59:52'),
(165, 1, 3, 6, '2019-11-20 07:59:52', '2019-11-20 07:59:52'),
(166, 1, 4, 6, '2019-11-20 07:59:52', '2019-11-20 07:59:52'),
(167, 1, 1, 5, '2019-11-20 07:59:52', '2019-11-20 07:59:52'),
(168, 1, 2, 5, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(169, 1, 3, 5, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(170, 1, 4, 5, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(171, 1, 1, 7, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(172, 1, 2, 7, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(173, 1, 3, 7, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(174, 1, 4, 7, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(175, 1, 1, 8, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(176, 1, 2, 8, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(177, 1, 3, 8, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(178, 1, 4, 8, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(179, 1, 1, 3, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(180, 1, 2, 3, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(181, 1, 3, 3, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(182, 1, 4, 3, '2019-11-20 07:59:53', '2019-11-20 07:59:53'),
(183, 1, 1, 2, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(184, 1, 2, 2, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(185, 1, 3, 2, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(186, 1, 4, 2, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(187, 1, 1, 4, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(188, 1, 2, 4, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(189, 1, 3, 4, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(190, 1, 4, 4, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(191, 1, 1, 1, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(192, 1, 2, 1, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(193, 1, 3, 1, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(194, 1, 4, 1, '2019-11-20 07:59:54', '2019-11-20 07:59:54'),
(195, 1, 1, 9, '2019-11-20 07:59:55', '2019-11-20 07:59:55'),
(196, 1, 2, 9, '2019-11-20 07:59:55', '2019-11-20 07:59:55'),
(197, 1, 3, 9, '2019-11-20 07:59:55', '2019-11-20 07:59:55'),
(198, 1, 4, 9, '2019-11-20 07:59:55', '2019-11-20 07:59:55'),
(216, 2, 1, 9, '2019-11-20 08:00:28', '2019-11-20 08:00:28'),
(217, 2, 1, 6, '2019-11-20 08:00:28', '2019-11-20 08:00:28'),
(218, 2, 1, 5, '2019-11-20 08:00:28', '2019-11-20 08:00:28'),
(219, 2, 1, 7, '2019-11-20 08:00:28', '2019-11-20 08:00:28'),
(220, 2, 1, 8, '2019-11-20 08:00:28', '2019-11-20 08:00:28'),
(221, 2, 1, 2, '2019-11-20 08:00:28', '2019-11-20 08:00:28'),
(222, 2, 1, 9, '2019-11-20 08:00:28', '2019-11-20 08:00:28');

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

--
-- Table structure for table `seers`
--

CREATE TABLE `seers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `table` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `tableid` bigint(20) UNSIGNED DEFAULT '0',
  `names` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `semesters`
--

CREATE TABLE `semesters` (
  `sem_id` bigint(20) UNSIGNED NOT NULL,
  `sem_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `semesters`
--

INSERT INTO `semesters` (`sem_id`, `sem_name`, `created_at`, `updated_at`) VALUES
(1, '1st Semester', NULL, NULL),
(2, '2nd Semester', NULL, NULL);

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

--
-- Table structure for table `site_sections`
--

CREATE TABLE `site_sections` (
  `sitesection_id` bigint(20) UNSIGNED NOT NULL,
  `sitesection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_sections`
--

INSERT INTO `site_sections` (`sitesection_id`, `sitesection_name`, `created_at`, `updated_at`) VALUES
(1, 'Users', NULL, NULL),
(2, 'Roles', NULL, NULL),
(3, 'Rights', NULL, NULL),
(4, 'Site Sections', NULL, NULL),
(5, 'Functional Units', NULL, NULL),
(6, 'Form Manuals', NULL, NULL),
(7, 'Procedure Manuals', NULL, NULL),
(8, 'Quality Manuals', NULL, NULL),
(9, 'Work Instructions', NULL, NULL);

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

--
-- Table structure for table `user_accomplishments`
--

CREATE TABLE `user_accomplishments` (
  `ua_id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qty` int(10) UNSIGNED DEFAULT '0',
  `effort` int(10) UNSIGNED DEFAULT '0',
  `desc` text COLLATE utf8mb4_unicode_ci,
  `u_id` bigint(20) UNSIGNED DEFAULT '0',
  `u_initials` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `ut_id` bigint(20) UNSIGNED DEFAULT '0',
  `tar_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `bo_id` bigint(20) UNSIGNED DEFAULT '0',
  `bo_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_logs`
--

CREATE TABLE `user_logs` (
  `log_id` bigint(20) UNSIGNED NOT NULL,
  `log_date` datetime DEFAULT NULL,
  `log_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `log_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `log_querystring` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `log_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `log_referrer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `user_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `userrole_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` (`userrole_id`, `user_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2024-02-02 05:58:23', '2024-02-02 05:58:23');

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

--
-- Table structure for table `user_settings`
--

CREATE TABLE `user_settings` (
  `uset_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT '0',
  `is_admin` tinyint(3) UNSIGNED DEFAULT '0',
  `is_auditor` tinyint(3) UNSIGNED DEFAULT '0',
  `is_custodian` tinyint(3) UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `div_id` bigint(20) UNSIGNED DEFAULT '0',
  `div_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `is_unithead` tinyint(3) UNSIGNED DEFAULT '0',
  `is_qct` tinyint(3) UNSIGNED DEFAULT '0',
  `is_qctleader` tinyint(3) UNSIGNED DEFAULT '0',
  `is_iaghead` tinyint(3) UNSIGNED DEFAULT '0',
  `is_iagleader` tinyint(3) UNSIGNED DEFAULT '0',
  `is_rd` tinyint(3) UNSIGNED DEFAULT '0',
  `is_ard` tinyint(3) UNSIGNED DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_settings`
--

INSERT INTO `user_settings` (`uset_id`, `user_id`, `is_admin`, `is_auditor`, `is_custodian`, `created_at`, `updated_at`, `div_id`, `div_name`, `is_unithead`, `is_qct`, `is_qctleader`, `is_iaghead`, `is_iagleader`, `is_rd`, `is_ard`) VALUES
(1, 1, 1, 0, 0, '2024-02-02 05:58:23', '2024-02-02 05:58:23', 0, '', 0, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `user_targets`
--

CREATE TABLE `user_targets` (
  `ut_id` bigint(20) UNSIGNED NOT NULL,
  `year` int(10) UNSIGNED DEFAULT '0',
  `month` int(10) UNSIGNED DEFAULT '0',
  `month_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `qtr` int(10) UNSIGNED DEFAULT '0',
  `qtr_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `category` text COLLATE utf8mb4_unicode_ci,
  `desc` text COLLATE utf8mb4_unicode_ci,
  `success` text COLLATE utf8mb4_unicode_ci,
  `qty` int(10) UNSIGNED DEFAULT '0',
  `u_id` bigint(20) UNSIGNED DEFAULT '0',
  `u_initials` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `tar_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_id` bigint(20) UNSIGNED DEFAULT '0',
  `fu_abbr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fu_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fo_id` bigint(20) UNSIGNED DEFAULT '0',
  `fo_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `fo_name` text COLLATE utf8mb4_unicode_ci,
  `bo_id` bigint(20) UNSIGNED DEFAULT '0',
  `bo_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `bo_name` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accomplishments`
--
ALTER TABLE `accomplishments`
  ADD PRIMARY KEY (`acc_id`);

--
-- Indexes for table `accomplishment_files`
--
ALTER TABLE `accomplishment_files`
  ADD PRIMARY KEY (`file_id`);

--
-- Indexes for table `apgs`
--
ALTER TABLE `apgs`
  ADD PRIMARY KEY (`apg_id`);

--
-- Indexes for table `apg_files`
--
ALTER TABLE `apg_files`
  ADD PRIMARY KEY (`file_id`);

--
-- Indexes for table `apg_file_revisions`
--
ALTER TABLE `apg_file_revisions`
  ADD PRIMARY KEY (`file_id`);

--
-- Indexes for table `apns`
--
ALTER TABLE `apns`
  ADD PRIMARY KEY (`apn_id`);

--
-- Indexes for table `apn_auditors`
--
ALTER TABLE `apn_auditors`
  ADD PRIMARY KEY (`au_id`);

--
-- Indexes for table `apn_auditor_items`
--
ALTER TABLE `apn_auditor_items`
  ADD PRIMARY KEY (`ai_id`);

--
-- Indexes for table `apn_schedules`
--
ALTER TABLE `apn_schedules`
  ADD PRIMARY KEY (`sd_id`);

--
-- Indexes for table `apn_schedule_items`
--
ALTER TABLE `apn_schedule_items`
  ADD PRIMARY KEY (`si_id`);

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

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

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

--
-- Indexes for table `audit_questions`
--
ALTER TABLE `audit_questions`
  ADD PRIMARY KEY (`aq_id`);

--
-- Indexes for table `checklists`
--
ALTER TABLE `checklists`
  ADD PRIMARY KEY (`chk_id`);

--
-- Indexes for table `checklist_items`
--
ALTER TABLE `checklist_items`
  ADD PRIMARY KEY (`chki_id`);

--
-- Indexes for table `checklist_statuses`
--
ALTER TABLE `checklist_statuses`
  ADD PRIMARY KEY (`status_id`);

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

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

--
-- Indexes for table `csm_provinces`
--
ALTER TABLE `csm_provinces`
  ADD PRIMARY KEY (`province_id`);

--
-- Indexes for table `csm_services`
--
ALTER TABLE `csm_services`
  ADD PRIMARY KEY (`service_id`);

--
-- Indexes for table `csm_subjects`
--
ALTER TABLE `csm_subjects`
  ADD PRIMARY KEY (`subject_id`);

--
-- Indexes for table `cs_files`
--
ALTER TABLE `cs_files`
  ADD PRIMARY KEY (`csf_id`);

--
-- Indexes for table `cs_provinces`
--
ALTER TABLE `cs_provinces`
  ADD PRIMARY KEY (`csp_id`);

--
-- Indexes for table `cs_services`
--
ALTER TABLE `cs_services`
  ADD PRIMARY KEY (`csv_id`);

--
-- Indexes for table `cs_subjects`
--
ALTER TABLE `cs_subjects`
  ADD PRIMARY KEY (`css_id`);

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

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

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

--
-- Indexes for table `foa_bos`
--
ALTER TABLE `foa_bos`
  ADD PRIMARY KEY (`bo_id`);

--
-- Indexes for table `foa_fos`
--
ALTER TABLE `foa_fos`
  ADD PRIMARY KEY (`fo_id`);

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

--
-- Indexes for table `functional_units`
--
ALTER TABLE `functional_units`
  ADD PRIMARY KEY (`fu_id`),
  ADD UNIQUE KEY `fu_id_UNIQUE` (`fu_id`);

--
-- Indexes for table `fuws`
--
ALTER TABLE `fuws`
  ADD PRIMARY KEY (`fuw_id`);

--
-- Indexes for table `fuw_targets`
--
ALTER TABLE `fuw_targets`
  ADD PRIMARY KEY (`tar_id`);

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

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

--
-- Indexes for table `iqas`
--
ALTER TABLE `iqas`
  ADD PRIMARY KEY (`iqa_id`);

--
-- Indexes for table `iqa_auditees`
--
ALTER TABLE `iqa_auditees`
  ADD PRIMARY KEY (`iqatee_id`);

--
-- Indexes for table `iqa_auditors`
--
ALTER TABLE `iqa_auditors`
  ADD PRIMARY KEY (`iqator_id`);

--
-- Indexes for table `iqa_checklists`
--
ALTER TABLE `iqa_checklists`
  ADD PRIMARY KEY (`iqachk_id`);

--
-- Indexes for table `iqa_checklist_items`
--
ALTER TABLE `iqa_checklist_items`
  ADD PRIMARY KEY (`iqachki_id`);

--
-- Indexes for table `iqa_checklist_item_statuses`
--
ALTER TABLE `iqa_checklist_item_statuses`
  ADD PRIMARY KEY (`iqachkistat_id`);

--
-- Indexes for table `iqa_evidences`
--
ALTER TABLE `iqa_evidences`
  ADD PRIMARY KEY (`iqaevi_id`);

--
-- Indexes for table `iqa_ncars`
--
ALTER TABLE `iqa_ncars`
  ADD PRIMARY KEY (`iqanc_id`);

--
-- Indexes for table `iqa_ncar_auditees`
--
ALTER TABLE `iqa_ncar_auditees`
  ADD PRIMARY KEY (`iqanctee_id`);

--
-- Indexes for table `iqa_ncar_auditors`
--
ALTER TABLE `iqa_ncar_auditors`
  ADD PRIMARY KEY (`iqanctor_id`);

--
-- Indexes for table `iqa_ofis`
--
ALTER TABLE `iqa_ofis`
  ADD PRIMARY KEY (`iqaofi_id`);

--
-- Indexes for table `iqa_statuses`
--
ALTER TABLE `iqa_statuses`
  ADD PRIMARY KEY (`iqastat_id`);

--
-- Indexes for table `manuals`
--
ALTER TABLE `manuals`
  ADD PRIMARY KEY (`man_id`);

--
-- Indexes for table `manual_divisions`
--
ALTER TABLE `manual_divisions`
  ADD PRIMARY KEY (`div_id`),
  ADD UNIQUE KEY `div_id_UNIQUE` (`div_id`);

--
-- Indexes for table `manual_files`
--
ALTER TABLE `manual_files`
  ADD PRIMARY KEY (`file_id`);

--
-- Indexes for table `manual_file_revisions`
--
ALTER TABLE `manual_file_revisions`
  ADD PRIMARY KEY (`file_id`);

--
-- Indexes for table `manual_histories`
--
ALTER TABLE `manual_histories`
  ADD PRIMARY KEY (`his_id`);

--
-- Indexes for table `manual_sections`
--
ALTER TABLE `manual_sections`
  ADD PRIMARY KEY (`sec_id`);

--
-- Indexes for table `manual_types`
--
ALTER TABLE `manual_types`
  ADD PRIMARY KEY (`type_id`);

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

--
-- Indexes for table `mls`
--
ALTER TABLE `mls`
  ADD PRIMARY KEY (`ml_id`);

--
-- Indexes for table `ml_files`
--
ALTER TABLE `ml_files`
  ADD PRIMARY KEY (`file_id`);

--
-- Indexes for table `ml_file_revisions`
--
ALTER TABLE `ml_file_revisions`
  ADD PRIMARY KEY (`file_id`);

--
-- Indexes for table `mrs`
--
ALTER TABLE `mrs`
  ADD PRIMARY KEY (`mr_id`);

--
-- Indexes for table `mr_doc_types`
--
ALTER TABLE `mr_doc_types`
  ADD PRIMARY KEY (`mrdt_id`);

--
-- Indexes for table `mr_files`
--
ALTER TABLE `mr_files`
  ADD PRIMARY KEY (`mrf_id`);

--
-- Indexes for table `ncar_types`
--
ALTER TABLE `ncar_types`
  ADD PRIMARY KEY (`nctype_id`);

--
-- Indexes for table `ncs`
--
ALTER TABLE `ncs`
  ADD PRIMARY KEY (`nc_id`);

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

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

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

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

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

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

--
-- Indexes for table `ofis`
--
ALTER TABLE `ofis`
  ADD PRIMARY KEY (`ofi_id`);

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

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

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

--
-- Indexes for table `pcds`
--
ALTER TABLE `pcds`
  ADD PRIMARY KEY (`pcd_id`);

--
-- Indexes for table `pcd_targets`
--
ALTER TABLE `pcd_targets`
  ADD PRIMARY KEY (`pt_id`);

--
-- Indexes for table `pfs`
--
ALTER TABLE `pfs`
  ADD PRIMARY KEY (`pf_id`);

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

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

--
-- Indexes for table `quarters`
--
ALTER TABLE `quarters`
  ADD PRIMARY KEY (`qtr_id`);

--
-- Indexes for table `rights`
--
ALTER TABLE `rights`
  ADD PRIMARY KEY (`right_id`),
  ADD UNIQUE KEY `right_id_UNIQUE` (`right_id`);

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

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

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

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`role_id`);

--
-- Indexes for table `role_rights`
--
ALTER TABLE `role_rights`
  ADD PRIMARY KEY (`rr_id`);

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

--
-- Indexes for table `semesters`
--
ALTER TABLE `semesters`
  ADD PRIMARY KEY (`sem_id`);

--
-- Indexes for table `site_sections`
--
ALTER TABLE `site_sections`
  ADD PRIMARY KEY (`sitesection_id`),
  ADD UNIQUE KEY `sitesection_id_UNIQUE` (`sitesection_id`);

--
-- Indexes for table `user_accomplishments`
--
ALTER TABLE `user_accomplishments`
  ADD PRIMARY KEY (`ua_id`);

--
-- Indexes for table `user_logs`
--
ALTER TABLE `user_logs`
  ADD PRIMARY KEY (`log_id`),
  ADD UNIQUE KEY `log_id_UNIQUE` (`log_id`);

--
-- Indexes for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`userrole_id`);

--
-- Indexes for table `user_settings`
--
ALTER TABLE `user_settings`
  ADD PRIMARY KEY (`uset_id`);

--
-- Indexes for table `user_targets`
--
ALTER TABLE `user_targets`
  ADD PRIMARY KEY (`ut_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accomplishments`
--
ALTER TABLE `accomplishments`
  MODIFY `acc_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `accomplishment_files`
--
ALTER TABLE `accomplishment_files`
  MODIFY `file_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apgs`
--
ALTER TABLE `apgs`
  MODIFY `apg_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apg_files`
--
ALTER TABLE `apg_files`
  MODIFY `file_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apg_file_revisions`
--
ALTER TABLE `apg_file_revisions`
  MODIFY `file_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apns`
--
ALTER TABLE `apns`
  MODIFY `apn_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apn_auditors`
--
ALTER TABLE `apn_auditors`
  MODIFY `au_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apn_auditor_items`
--
ALTER TABLE `apn_auditor_items`
  MODIFY `ai_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apn_schedules`
--
ALTER TABLE `apn_schedules`
  MODIFY `sd_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apn_schedule_items`
--
ALTER TABLE `apn_schedule_items`
  MODIFY `si_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ars`
--
ALTER TABLE `ars`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ar_files`
--
ALTER TABLE `ar_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ar_types`
--
ALTER TABLE `ar_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `audit_questions`
--
ALTER TABLE `audit_questions`
  MODIFY `aq_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `checklists`
--
ALTER TABLE `checklists`
  MODIFY `chk_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `checklist_items`
--
ALTER TABLE `checklist_items`
  MODIFY `chki_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `checklist_statuses`
--
ALTER TABLE `checklist_statuses`
  MODIFY `status_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `counters`
--
ALTER TABLE `counters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `csm_provinces`
--
ALTER TABLE `csm_provinces`
  MODIFY `province_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `csm_services`
--
ALTER TABLE `csm_services`
  MODIFY `service_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `csm_subjects`
--
ALTER TABLE `csm_subjects`
  MODIFY `subject_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `cs_files`
--
ALTER TABLE `cs_files`
  MODIFY `csf_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cs_provinces`
--
ALTER TABLE `cs_provinces`
  MODIFY `csp_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cs_services`
--
ALTER TABLE `cs_services`
  MODIFY `csv_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cs_subjects`
--
ALTER TABLE `cs_subjects`
  MODIFY `css_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `detections`
--
ALTER TABLE `detections`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `eds`
--
ALTER TABLE `eds`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `foa_bos`
--
ALTER TABLE `foa_bos`
  MODIFY `bo_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `foa_fos`
--
ALTER TABLE `foa_fos`
  MODIFY `fo_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `frequencies`
--
ALTER TABLE `frequencies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `functional_units`
--
ALTER TABLE `functional_units`
  MODIFY `fu_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `fuws`
--
ALTER TABLE `fuws`
  MODIFY `fuw_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fuw_targets`
--
ALTER TABLE `fuw_targets`
  MODIFY `tar_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `impacts`
--
ALTER TABLE `impacts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `information_systems`
--
ALTER TABLE `information_systems`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqas`
--
ALTER TABLE `iqas`
  MODIFY `iqa_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqa_auditees`
--
ALTER TABLE `iqa_auditees`
  MODIFY `iqatee_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqa_auditors`
--
ALTER TABLE `iqa_auditors`
  MODIFY `iqator_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqa_checklists`
--
ALTER TABLE `iqa_checklists`
  MODIFY `iqachk_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqa_checklist_items`
--
ALTER TABLE `iqa_checklist_items`
  MODIFY `iqachki_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqa_checklist_item_statuses`
--
ALTER TABLE `iqa_checklist_item_statuses`
  MODIFY `iqachkistat_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `iqa_evidences`
--
ALTER TABLE `iqa_evidences`
  MODIFY `iqaevi_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqa_ncars`
--
ALTER TABLE `iqa_ncars`
  MODIFY `iqanc_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqa_ncar_auditees`
--
ALTER TABLE `iqa_ncar_auditees`
  MODIFY `iqanctee_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqa_ncar_auditors`
--
ALTER TABLE `iqa_ncar_auditors`
  MODIFY `iqanctor_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqa_ofis`
--
ALTER TABLE `iqa_ofis`
  MODIFY `iqaofi_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iqa_statuses`
--
ALTER TABLE `iqa_statuses`
  MODIFY `iqastat_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `manuals`
--
ALTER TABLE `manuals`
  MODIFY `man_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `manual_divisions`
--
ALTER TABLE `manual_divisions`
  MODIFY `div_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `manual_files`
--
ALTER TABLE `manual_files`
  MODIFY `file_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `manual_file_revisions`
--
ALTER TABLE `manual_file_revisions`
  MODIFY `file_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `manual_histories`
--
ALTER TABLE `manual_histories`
  MODIFY `his_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `manual_sections`
--
ALTER TABLE `manual_sections`
  MODIFY `sec_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `manual_types`
--
ALTER TABLE `manual_types`
  MODIFY `type_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=301;

--
-- AUTO_INCREMENT for table `mls`
--
ALTER TABLE `mls`
  MODIFY `ml_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ml_files`
--
ALTER TABLE `ml_files`
  MODIFY `file_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ml_file_revisions`
--
ALTER TABLE `ml_file_revisions`
  MODIFY `file_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mrs`
--
ALTER TABLE `mrs`
  MODIFY `mr_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mr_doc_types`
--
ALTER TABLE `mr_doc_types`
  MODIFY `mrdt_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `mr_files`
--
ALTER TABLE `mr_files`
  MODIFY `mrf_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ncar_types`
--
ALTER TABLE `ncar_types`
  MODIFY `nctype_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `ncs`
--
ALTER TABLE `ncs`
  MODIFY `nc_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `nc_actions`
--
ALTER TABLE `nc_actions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `nc_action_files`
--
ALTER TABLE `nc_action_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `nc_ic_actions`
--
ALTER TABLE `nc_ic_actions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `nc_ic_action_files`
--
ALTER TABLE `nc_ic_action_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `nc_planned_actions`
--
ALTER TABLE `nc_planned_actions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notices`
--
ALTER TABLE `notices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ofis`
--
ALTER TABLE `ofis`
  MODIFY `ofi_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ofi_actions`
--
ALTER TABLE `ofi_actions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ofi_action_files`
--
ALTER TABLE `ofi_action_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ofi_files`
--
ALTER TABLE `ofi_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pcds`
--
ALTER TABLE `pcds`
  MODIFY `pcd_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pcd_targets`
--
ALTER TABLE `pcd_targets`
  MODIFY `pt_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pfs`
--
ALTER TABLE `pfs`
  MODIFY `pf_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pf_files`
--
ALTER TABLE `pf_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `prioritizations`
--
ALTER TABLE `prioritizations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `quarters`
--
ALTER TABLE `quarters`
  MODIFY `qtr_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `rights`
--
ALTER TABLE `rights`
  MODIFY `right_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `risks`
--
ALTER TABLE `risks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `risk_docs`
--
ALTER TABLE `risk_docs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `risk_treatments`
--
ALTER TABLE `risk_treatments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `risk_types`
--
ALTER TABLE `risk_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `role_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `role_rights`
--
ALTER TABLE `role_rights`
  MODIFY `rr_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=223;

--
-- AUTO_INCREMENT for table `seers`
--
ALTER TABLE `seers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `semesters`
--
ALTER TABLE `semesters`
  MODIFY `sem_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `site_sections`
--
ALTER TABLE `site_sections`
  MODIFY `sitesection_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `user_accomplishments`
--
ALTER TABLE `user_accomplishments`
  MODIFY `ua_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_logs`
--
ALTER TABLE `user_logs`
  MODIFY `log_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_roles`
--
ALTER TABLE `user_roles`
  MODIFY `userrole_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `user_settings`
--
ALTER TABLE `user_settings`
  MODIFY `uset_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `user_targets`
--
ALTER TABLE `user_targets`
  MODIFY `ut_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

