-- https://www.phpmyadmin.net/
--
-- Хост: 127.0.0.1:3306
-- Час створення: Чрв 09 2025 р., 00:56
-- Версія сервера: 10.8.4-MariaDB
-- Версія PHP: 8.1.9

START TRANSACTION;



--
-- База даних: `Likoadmin_dl`
--

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

--
-- Структура таблиці `crm_customers`
--

CREATE TABLE `crm_customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `name_parent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `past_educational_institution` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `warfare` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pib_another_child_in_liko` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `status_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Структура таблиці `crm_documents`
--

CREATE TABLE `crm_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Структура таблиці `crm_notes`
--

CREATE TABLE `crm_notes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `note` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Структура таблиці `crm_statuses`
--

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

--
-- Дамп даних таблиці `crm_statuses`
--

INSERT INTO `crm_statuses` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Lead', '2023-03-02 03:35:03', '2023-03-02 03:35:03', NULL),
(2, 'Customer', '2023-03-02 03:35:03', '2023-03-02 03:35:03', NULL),
(3, 'Partner', '2023-03-02 03:35:03', '2023-03-02 03:35:03', NULL);

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

--
-- Структура таблиці `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `collection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversions_disk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` bigint(20) UNSIGNED NOT NULL,
  `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manipulations`)),
  `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`custom_properties`)),
  `generated_conversions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`generated_conversions`)),
  `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`responsive_images`)),
  `order_column` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Структура таблиці `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;

--
-- Дамп даних таблиці `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_100000_create_password_resets_table', 1),
(2, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(3, '2025_06_06_000001_create_media_table', 1),
(4, '2025_06_06_000002_create_permissions_table', 1),
(5, '2025_06_06_000003_create_roles_table', 1),
(6, '2025_06_06_000004_create_users_table', 1),
(7, '2025_06_06_000005_create_crm_statuses_table', 1),
(8, '2025_06_06_000006_create_crm_customers_table', 1),
(9, '2025_06_06_000007_create_crm_notes_table', 1),
(10, '2025_06_06_000008_create_crm_documents_table', 1),
(11, '2025_06_06_000009_create_psiholog_anketa_table', 1),
(12, '2025_06_06_000010_create_schstudents_table', 1),
(13, '2025_06_06_000011_create_sch_classes_table', 1),
(14, '2025_06_06_000012_create_sch_teachers_table', 1),
(15, '2025_06_06_000013_create_sch_reports_table', 1),
(16, '2025_06_06_000014_create_sch_subjects_table', 1),
(17, '2025_06_06_000015_create_permission_role_pivot_table', 1),
(18, '2025_06_06_000016_create_role_user_pivot_table', 1),
(19, '2025_06_06_000017_create_sch_class_schstudent_pivot_table', 1),
(20, '2025_06_06_000018_create_sch_subject_sch_teacher_pivot_table', 1),
(21, '2025_06_06_000019_add_relationship_fields_to_crm_customers_table', 1),
(22, '2025_06_06_000020_add_relationship_fields_to_crm_notes_table', 1),
(23, '2025_06_06_000021_add_relationship_fields_to_crm_documents_table', 1),
(24, '2025_06_06_000022_add_relationship_fields_to_psiholog_anketa_table', 1),
(25, '2025_06_06_000023_add_relationship_fields_to_sch_reports_table', 1),
(26, '2025_06_06_000024_add_relationship_fields_to_sch_subjects_table', 1),
(27, '2025_06_08_085653_create_teams_table', 2),
(28, '2025_06_08_094650_add_team_id_to_users_table', 3);

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

--
-- Структура таблиці `permissions`
--

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

--
-- Дамп даних таблиці `permissions`
--

INSERT INTO `permissions` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'user_management_access', NULL, NULL, NULL),
(2, 'permission_create', NULL, NULL, NULL),
(3, 'permission_edit', NULL, NULL, NULL),
(4, 'permission_show', NULL, NULL, NULL),
(5, 'permission_delete', NULL, NULL, NULL),
(6, 'permission_access', NULL, NULL, NULL),
(7, 'role_create', NULL, NULL, NULL),
(8, 'role_edit', NULL, NULL, NULL),
(9, 'role_show', NULL, NULL, NULL),
(10, 'role_delete', NULL, NULL, NULL),
(11, 'role_access', NULL, NULL, NULL),
(12, 'user_create', NULL, NULL, NULL),
(13, 'user_edit', NULL, NULL, NULL),
(14, 'user_show', NULL, NULL, NULL),
(15, 'user_delete', NULL, NULL, NULL),
(16, 'user_access', NULL, NULL, NULL),
(17, 'basic_c_r_m_access', NULL, NULL, NULL),
(18, 'crm_status_create', NULL, NULL, NULL),
(19, 'crm_status_edit', NULL, NULL, NULL),
(20, 'crm_status_show', NULL, NULL, NULL),
(21, 'crm_status_delete', NULL, NULL, NULL),
(22, 'crm_status_access', NULL, NULL, NULL),
(23, 'crm_customer_create', NULL, NULL, NULL),
(24, 'crm_customer_edit', NULL, NULL, NULL),
(25, 'crm_customer_show', NULL, NULL, NULL),
(26, 'crm_customer_delete', NULL, NULL, NULL),
(27, 'crm_customer_access', NULL, NULL, NULL),
(28, 'crm_note_create', NULL, NULL, NULL),
(29, 'crm_note_edit', NULL, NULL, NULL),
(30, 'crm_note_show', NULL, NULL, NULL),
(31, 'crm_note_delete', NULL, NULL, NULL),
(32, 'crm_note_access', NULL, NULL, NULL),
(33, 'crm_document_create', NULL, NULL, NULL),
(34, 'crm_document_edit', NULL, NULL, NULL),
(35, 'crm_document_show', NULL, NULL, NULL),
(36, 'crm_document_delete', NULL, NULL, NULL),
(37, 'crm_document_access', NULL, NULL, NULL),
(38, 'psiholog_anketum_create', NULL, NULL, NULL),
(39, 'psiholog_anketum_edit', NULL, NULL, NULL),
(40, 'psiholog_anketum_show', NULL, NULL, NULL),
(41, 'psiholog_anketum_delete', NULL, NULL, NULL),
(42, 'psiholog_anketum_access', NULL, NULL, NULL),
(43, 'report_access', NULL, NULL, NULL),
(44, 'schstudent_create', NULL, NULL, NULL),
(45, 'schstudent_edit', NULL, NULL, NULL),
(46, 'schstudent_show', NULL, NULL, NULL),
(47, 'schstudent_delete', NULL, NULL, NULL),
(48, 'schstudent_access', NULL, NULL, NULL),
(49, 'sch_class_create', NULL, NULL, NULL),
(50, 'sch_class_edit', NULL, NULL, NULL),
(51, 'sch_class_show', NULL, NULL, NULL),
(52, 'sch_class_delete', NULL, NULL, NULL),
(53, 'sch_class_access', NULL, NULL, NULL),
(54, 'sch_teacher_create', NULL, NULL, NULL),
(55, 'sch_teacher_edit', NULL, NULL, NULL),
(56, 'sch_teacher_show', NULL, NULL, NULL),
(57, 'sch_teacher_delete', NULL, NULL, NULL),
(58, 'sch_teacher_access', NULL, NULL, NULL),
(59, 'sch_report_create', NULL, NULL, NULL),
(60, 'sch_report_edit', NULL, NULL, NULL),
(61, 'sch_report_show', NULL, NULL, NULL),
(62, 'sch_report_delete', NULL, NULL, NULL),
(63, 'sch_report_access', NULL, NULL, NULL),
(64, 'sch_subject_create', NULL, NULL, NULL),
(65, 'sch_subject_edit', NULL, NULL, NULL),
(66, 'sch_subject_show', NULL, NULL, NULL),
(67, 'sch_subject_delete', NULL, NULL, NULL),
(68, 'sch_subject_access', NULL, NULL, NULL),
(69, 'profile_password_edit', NULL, NULL, NULL),
(70, 'sch_class-list_access', '2025-06-08 18:38:01', '2025-06-08 18:38:01', NULL),
(71, 'report_access', '2025-06-08 18:45:38', '2025-06-08 18:45:38', NULL);

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

--
-- Структура таблиці `permission_role`
--

CREATE TABLE `permission_role` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Дамп даних таблиці `permission_role`
--

INSERT INTO `permission_role` (`role_id`, `permission_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(1, 13),
(1, 14),
(1, 15),
(1, 16),
(1, 17),
(1, 18),
(1, 19),
(1, 20),
(1, 21),
(1, 22),
(1, 23),
(1, 24),
(1, 25),
(1, 26),
(1, 27),
(1, 28),
(1, 29),
(1, 30),
(1, 31),
(1, 32),
(1, 33),
(1, 34),
(1, 35),
(1, 36),
(1, 37),
(1, 38),
(1, 39),
(1, 40),
(1, 41),
(1, 42),
(1, 43),
(1, 44),
(1, 45),
(1, 46),
(1, 47),
(1, 48),
(1, 49),
(1, 50),
(1, 51),
(1, 52),
(1, 53),
(1, 54),
(1, 55),
(1, 56),
(1, 57),
(1, 58),
(1, 59),
(1, 60),
(1, 61),
(1, 62),
(1, 63),
(1, 64),
(1, 65),
(1, 66),
(1, 67),
(1, 68),
(1, 69),
(2, 17),
(2, 18),
(2, 19),
(2, 20),
(2, 21),
(2, 22),
(2, 23),
(2, 24),
(2, 25),
(2, 26),
(2, 27),
(2, 28),
(2, 29),
(2, 30),
(2, 31),
(2, 32),
(2, 33),
(2, 34),
(2, 35),
(2, 36),
(2, 37),
(2, 38),
(2, 39),
(2, 40),
(2, 41),
(2, 42),
(2, 43),
(2, 44),
(2, 45),
(2, 46),
(2, 47),
(2, 48),
(2, 49),
(2, 50),
(2, 51),
(2, 52),
(2, 53),
(2, 54),
(2, 55),
(2, 56),
(2, 57),
(2, 58),
(2, 59),
(2, 60),
(2, 61),
(2, 62),
(2, 63),
(2, 64),
(2, 65),
(2, 66),
(2, 67),
(2, 68),
(2, 69),
(3, 69),
(3, 70),
(4, 43),
(4, 44),
(4, 45),
(4, 46),
(4, 47),
(4, 48),
(4, 49),
(4, 50),
(4, 51),
(4, 52),
(4, 53),
(4, 54),
(4, 55),
(4, 56),
(4, 57),
(4, 58),
(4, 59),
(4, 60),
(4, 61),
(4, 62),
(4, 63),
(4, 64),
(4, 65),
(4, 66),
(4, 67),
(4, 68),
(4, 69),
(4, 70),
(3, 71),
(4, 71);

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

--
-- Структура таблиці `psiholog_anketa`
--

CREATE TABLE `psiholog_anketa` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `nebylici` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visual_memory` double(8,2) DEFAULT NULL,
  `reading` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auditory_memory` double(8,2) DEFAULT NULL,
  `fourth_is_redundant` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logical_lines` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `social_readiness` tinyint(1) DEFAULT 0,
  `social_readiness_2` tinyint(1) DEFAULT 0,
  `social_readiness_3` tinyint(1) DEFAULT 0,
  `social_readiness_4` tinyint(1) DEFAULT 0,
  `social_readiness_5` tinyint(1) DEFAULT 0,
  `social_readiness_6` tinyint(1) DEFAULT 0,
  `social_readiness_7` tinyint(1) DEFAULT 0,
  `self_regulation` tinyint(1) DEFAULT 0,
  `self_regulation_2` tinyint(1) DEFAULT 0,
  `self_regulation_3` tinyint(1) DEFAULT 0,
  `self_regulation_4` tinyint(1) DEFAULT 0,
  `self_regulation_5` tinyint(1) DEFAULT 0,
  `self_regulation_6` tinyint(1) DEFAULT 0,
  `self_regulation_7` tinyint(1) DEFAULT 0,
  `self_regulation_8` tinyint(1) DEFAULT 0,
  `self_regulation_9` tinyint(1) DEFAULT 0,
  `motivation_to_study` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `speech_physiology` tinyint(1) DEFAULT 0,
  `speech_physiology_2` tinyint(1) DEFAULT 0,
  `speech_physiology_3` tinyint(1) DEFAULT 0,
  `speech_physiology_4` tinyint(1) DEFAULT 0,
  `speech_physiology_5` tinyint(1) DEFAULT 0,
  `speech_physiology_6` tinyint(1) DEFAULT 0,
  `speech_physiology_7` tinyint(1) DEFAULT 0,
  `speech_physiology_8` tinyint(1) DEFAULT 0,
  `physiology_0` tinyint(1) DEFAULT 0,
  `physiology` tinyint(1) DEFAULT 0,
  `physiology_2` tinyint(1) DEFAULT 0,
  `physiology_3` tinyint(1) DEFAULT 0,
  `physiology_4` tinyint(1) DEFAULT 0,
  `reading_tempo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `way_of_reading` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fish` tinyint(1) DEFAULT 0,
  `fish_2` tinyint(1) DEFAULT 0,
  `fish_3` tinyint(1) DEFAULT 0,
  `fish_4` tinyint(1) DEFAULT 0,
  `copying_figures` tinyint(1) DEFAULT 0,
  `copying_figures_2` tinyint(1) DEFAULT 0,
  `copying_figures_3` tinyint(1) DEFAULT 0,
  `interview` int(11) DEFAULT NULL,
  `conclusion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `behavior` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `name_childe_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name_psyholog_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Структура таблиці `roles`
--

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

--
-- Дамп даних таблиці `roles`
--

INSERT INTO `roles` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Admin', NULL, NULL, NULL),
(2, 'User', NULL, NULL, NULL),
(3, 'teacher', '2025-06-08 18:38:42', '2025-06-08 18:38:42', NULL),
(4, 'head_teacher', '2025-06-08 18:40:35', '2025-06-08 18:40:35', NULL);

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

--
-- Структура таблиці `role_user`
--

CREATE TABLE `role_user` (
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Дамп даних таблиці `role_user`
--

INSERT INTO `role_user` (`user_id`, `role_id`) VALUES
(1, 1),
(17, 2),
(16, 4),
(15, 3),
(14, 3),
(13, 3),
(12, 3),
(11, 3),
(10, 3),
(8, 3),
(9, 3),
(7, 3),
(6, 3),
(5, 3),
(4, 3),
(3, 3),
(2, 3);

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

--
-- Структура таблиці `schstudents`
--

CREATE TABLE `schstudents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_ua` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `userid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schclass_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Дамп даних таблиці `schstudents`
--

INSERT INTO `schstudents` (`id`, `name_ua`, `name_en`, `userid`, `schclass_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Аміріді Сандра Олександрівна', 'Amiridi Sandra Oleksandrivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(2, 'Біндер Васіліса Владиславівна', 'Binder Vasilisa Vladyslavivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(3, 'Богатирьова  Наталія Вячеславівна', 'Bohatyrova  Nataliia Viacheslavivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(4, 'Василик  Вероніка Віталіївна', 'Vasylyk  Veronika Vitaliivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(5, 'Долід  Олександр Станіславович', 'Dolid  Oleksandr Stanislavovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(6, 'Журавель Єлизавета Олександрівна', 'Zhuravel Yelyzaveta Oleksandrivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(7, 'Казанікова Анджеліна Максимівна', 'Kazanikova Andzhelina Maksymivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(8, 'Корж Андрій Артемович', 'Korzh Andrii Artemovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(9, 'Кріпак Володимир Дмитрович', 'Kripak Volodymyr Dmytrovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(10, 'Куницький Сергій Олександрович', 'Kunytskyi Serhii Oleksandrovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(11, 'Маслюков Марк Федорович', 'Masliukov Mark Fedorovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(12, 'Палій  Максим Андрійович', 'Palii  Maksym Andriiovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(13, 'Попович Максим Русланович', 'Popovych Maksym Ruslanovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(14, 'Цівун  Даніела Дмитрівна', 'Tsivun  Daniela Dmytrivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(15, 'Левенко Мелісса Василівна', 'Levenko Melissa Vasylivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(16, 'Алєксєєнко  Анастасія   Олексіївна', 'Alieksieienko  Anastasiia   Oleksiivna', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(17, 'Антонюк    Олександра Антонівна', 'Antoniuk    Oleksandra Antonivna', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(18, 'Волинець    Валерія Ростиславівна', 'Volynets    Valeriia Rostyslavivna', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(19, 'Ворніку    Маркус ', 'Vornicu    Marcus ', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(20, 'Ворніку    Моніка ', 'Vorniku    Monika ', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(21, 'Клюзнер   Олексій Олександрович', 'Kliuzner   Oleksii Oleksandrovych', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(22, 'Нестеренко   Денис Іванович', 'Nesterenko   Denys Ivanovych', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(23, 'Попович    Олексій Русланович', 'Popovych    Oleksii Ruslanovych', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(24, 'Романченко   Лев Павлович', 'Romanchenko   Lev Pavlovych', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(25, 'Руденко  Савва Олексійович', 'Rudenko  Savva Oleksiiovych', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(26, 'Сітак   Аліса Віталіївна', 'Sitak   Alisa Vitaliivna', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(27, 'Скрипка   Златослава Сергіївна', 'Skrypka   Zlatoslava Serhiivna', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(28, 'Урвачов   Марк Євгенович', 'Urvachov   Mark Yevhenovych', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(29, 'Фрадкін   Аарон Артурович', 'Fradkin   Aaron Arturovych', NULL, '2', NULL, '2025-06-08 04:39:03', NULL),
(30, '', '', NULL, '', NULL, '2025-06-06 08:05:50', '2025-06-06 08:05:50'),
(31, 'Бєлоус Меланія Вікторівна', 'Bielous Melaniia Viktorivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(32, 'Бадрудінов   Михайло   Олександрович ', 'Badrudinov   Mykhailo   Oleksandrovych ', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(33, 'Бурлика   Єгор   Євгенович', 'Burlyka   Yehor   Yevhenovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(34, 'Голофаєв Єгор Олегович', 'Holofaiev Yehor Olehovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(35, 'Довбиш  Олександр  Олександрович', 'Dovbysh  Oleksandr  Oleksandrovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(36, 'Єщенко Марія В\'ячеславовна', 'Yeshchenko Mariia Viacheslavovna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(37, 'Казаніков  Максим Максимович', 'Kazanikov  Maksym Maksymovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(38, 'Кшановський   Артем  Віталійович', 'Kshanovskyi   Artem  Vitaliiovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(39, 'Лобода Ольга Сергіївна', 'Loboda Olha Serhiivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(40, 'Махиня Тимофій Владиславович', 'Makhynia Tymofii Vladyslavovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(41, 'Мейта Марія Романівна', 'Meita Mariia Romanivna', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(42, 'Петров Данило Сергійович', 'Petrov Danylo Serhiiovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(43, 'Поїзд  Платон Васильович', 'Poizd  Platon Vasylovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(44, 'Туровський Дмитро Олександрович', 'Turovskyi Dmytro Oleksandrovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(45, 'Штихно Євген  Андрійович', 'Shtykhno Yevhen  Andriiovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(46, 'Штихно Денис Андрійович', 'Shtykhno Denys Andriiovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(47, 'Колодій Віталій Артемович', 'Kolodii Vitalii Artemovych', NULL, '4', NULL, '2025-06-08 04:38:49', NULL),
(48, 'Баласинович Ангеліна Богданівна', 'Balasynovych Anhelina Bohdanivna', NULL, '5', NULL, '2025-06-08 04:38:37', NULL),
(49, 'Гринюк  Анна Віталіївна', 'Hryniuk  Anna Vitaliivna', NULL, '5', NULL, '2025-06-08 04:38:37', NULL),
(50, 'Соловчук  Анастасія Леонідівна', 'Solovchuk  Anastasiia Leonidivna', NULL, '5', NULL, '2025-06-08 04:38:37', NULL),
(51, 'Соловчук  Марія Леонідівна', 'Solovchuk  Mariia Leonidivna', NULL, '5', NULL, '2025-06-08 04:38:37', NULL),
(52, 'Рувінський Беньямін Євгенійович', 'Ruvinskyi Beniamin Yevheniiovych', NULL, '5', NULL, '2025-06-08 04:38:37', NULL),
(53, '', '', NULL, '', NULL, '2025-06-07 12:53:39', '2025-06-07 12:53:39'),
(54, '', '', NULL, '', NULL, '2025-06-07 12:53:39', '2025-06-07 12:53:39'),
(55, '', '', NULL, '', NULL, '2025-06-07 12:53:39', '2025-06-07 12:53:39'),
(56, '', '', NULL, '', NULL, '2025-06-07 12:53:39', '2025-06-07 12:53:39'),
(57, '', '', NULL, '', NULL, '2025-06-07 12:53:39', '2025-06-07 12:53:39'),
(58, '', '', NULL, '', NULL, '2025-06-07 12:53:39', '2025-06-07 12:53:39'),
(59, '', '', NULL, '', NULL, '2025-06-07 12:53:39', '2025-06-07 12:53:39'),
(60, '', '', NULL, '', NULL, '2025-06-07 12:53:39', '2025-06-07 12:53:39'),
(61, 'Бельбас Дарина Владиславівна', 'Belbas Daryna Vladyslavivna', NULL, '6', NULL, '2025-06-08 04:37:52', NULL),
(62, 'Гринюк  Анастасія  Віталіївна ', 'Hryniuk  Anastasiia  Vitaliivna ', NULL, '6', NULL, '2025-06-08 04:37:52', NULL),
(63, 'Жвалюк  Денис Дмитрович', 'Zhvaliuk  Denys Dmytrovych', NULL, '6', NULL, '2025-06-08 04:37:52', NULL),
(64, 'Затірка Іван Сергійович', 'Zatirka Ivan Serhiiovych', NULL, '6', NULL, '2025-06-08 04:37:52', NULL),
(65, 'Кохнович Матвій Тимофійович', 'Kokhnovych Matvii Tymofiiovych', NULL, '6', NULL, '2025-06-08 04:37:52', NULL),
(66, 'Манько  Юлія  Валентинівна', 'Manko  Yuliia  Valentynivna', NULL, '6', NULL, '2025-06-08 04:37:52', NULL),
(67, 'Остапенко  Данііл Денисович', 'Ostapenko  Daniil Denysovych', NULL, '6', NULL, '2025-06-08 04:37:52', NULL),
(68, 'Покорська Софія Анатоліївна', 'Pokorska Sofiia Anatoliivna', NULL, '6', NULL, '2025-06-08 04:37:52', NULL),
(69, 'Соловчук Євген Леонідович ', 'Solovchuk Yevhen Leonidovych ', NULL, '6', NULL, '2025-06-08 04:37:52', NULL),
(70, 'Чурпій Андрій Володимирович', 'Churpii Andrii Volodymyrovych', NULL, '6', NULL, '2025-06-08 04:37:52', NULL),
(71, 'вибула', 'Zozulia Valeriia Yaroslavivna', NULL, '', NULL, '2025-06-07 12:57:20', '2025-06-07 12:57:20'),
(72, 'Баглай  Катерина Юріївна', 'Bahlai  Kateryna Yuriivna', NULL, '7', NULL, '2025-06-08 04:34:54', NULL),
(73, 'Журавльова  Євдокія Юріївна', 'Zhuravlova  Yevdokiia Yuriivna', NULL, '7', NULL, '2025-06-08 04:34:14', NULL),
(74, 'Казанікова Анфіса Максимівна', 'Kazanikova Anfisa Maksymivna', NULL, '7', NULL, '2025-06-08 04:34:14', NULL),
(75, 'Ковальчук  Давід Віталійович', 'Kovalchuk  David Vitaliiovych', NULL, '7', NULL, '2025-06-08 04:34:14', NULL),
(76, 'Кохнович  Єва Тимофіївна', 'Kokhnovych  Yeva Tymofiivna', NULL, '7', NULL, '2025-06-08 04:34:14', NULL),
(77, 'Лічевецький  Ярослав Ігорович', 'Lichevetskyi  Yaroslav Ihorovych', NULL, '7', NULL, '2025-06-08 04:34:14', NULL),
(78, 'Гура Єва Олександрівна', 'Hura Yeva Oleksandrivna', NULL, '7', NULL, '2025-06-08 04:34:14', NULL),
(79, 'Дорогань  Соломія Олексіївна', 'Dorohan  Solomiia Oleksiivna', NULL, '7', NULL, '2025-06-08 04:34:14', NULL),
(80, '', '', NULL, '', NULL, '2025-06-07 13:07:21', '2025-06-07 13:07:21'),
(81, '', '', NULL, '', NULL, '2025-06-07 13:07:22', '2025-06-07 13:07:22'),
(82, '', '', NULL, '', NULL, '2025-06-07 13:07:22', '2025-06-07 13:07:22'),
(83, '', '', NULL, '', NULL, '2025-06-07 13:07:22', '2025-06-07 13:07:22'),
(84, '', '', NULL, '', NULL, '2025-06-07 13:07:22', '2025-06-07 13:07:22'),
(85, '', '', NULL, '', NULL, '2025-06-07 13:07:22', '2025-06-07 13:07:22'),
(86, '', '', NULL, '', NULL, '2025-06-07 13:07:22', '2025-06-07 13:07:22'),
(87, '', '', NULL, '', NULL, '2025-06-07 13:07:22', '2025-06-07 13:07:22'),
(88, '', '', NULL, '', NULL, '2025-06-07 13:07:22', '2025-06-07 13:07:22'),
(89, '', '', NULL, '', NULL, '2025-06-07 13:07:22', '2025-06-07 13:07:22'),
(90, 'Бєлоус Стефанія Вікторівна', 'Bielous Stefaniia Viktorivna', NULL, '8', NULL, '2025-06-08 04:37:19', NULL),
(91, 'Гончаревич  Андрій Сергійович', 'Honcharevych  Andrii Serhiiovych', NULL, '8', NULL, '2025-06-08 04:37:19', NULL),
(92, 'Затірка   Злата  Сергіївна', 'Zatirka   Zlata  Serhiivna', NULL, '8', NULL, '2025-06-08 04:37:19', NULL),
(93, 'Змій Ярослава Юріївна', 'Zmii Yaroslava Yuriivna', NULL, '8', NULL, '2025-06-08 04:37:19', NULL),
(94, 'Румянцев  Марк Романович', 'Rumiantsev  Mark Romanovych', NULL, '8', NULL, '2025-06-08 04:37:19', NULL),
(95, 'Фрадкін Марк Артурович', 'Fradkin Mark Arturovych', NULL, '8', NULL, '2025-06-08 04:37:19', NULL),
(96, 'Рувінська  Наомі Євгеніївна', 'Ruvinska  Naomi Yevheniivna', NULL, '8', NULL, '2025-06-08 04:37:19', NULL),
(97, 'Рувінська  Шейна Євгеніївна', 'Ruvinska  Sheina Yevheniivna', NULL, '8', NULL, '2025-06-08 04:37:19', NULL),
(98, 'Кузьменко Юстина Русланівна', 'Kuzmenko Yustyna Ruslanivna', NULL, '8', NULL, '2025-06-08 04:37:19', NULL),
(99, 'Довбиш Мирослава Олександрівна', 'Dovbysh Myroslava Oleksandrivna', NULL, '8', NULL, '2025-06-08 04:37:19', NULL),
(100, 'Соловйова  Марія Сергіївна', 'Soloviova  Mariia Serhiivna', NULL, '8', NULL, '2025-06-08 04:37:19', NULL);

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

--
-- Структура таблиці `sch_classes`
--

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

--
-- Дамп даних таблиці `sch_classes`
--

INSERT INTO `sch_classes` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '1B', '2025-06-06 05:30:40', '2025-06-07 11:40:03', '2025-06-07 11:40:03'),
(2, '2B', '2025-06-06 05:47:38', '2025-06-06 05:47:38', NULL),
(3, '12', '2025-06-06 07:58:05', '2025-06-06 08:03:13', '2025-06-06 08:03:13'),
(4, '9B', '2025-06-07 12:15:25', '2025-06-07 12:15:25', NULL),
(5, '8B', '2025-06-07 12:54:40', '2025-06-07 12:54:40', NULL),
(6, '6B', '2025-06-07 12:58:14', '2025-06-07 12:58:14', NULL),
(7, '5B', '2025-06-07 13:08:34', '2025-06-07 13:08:34', NULL),
(8, '4B', '2025-06-07 13:09:46', '2025-06-07 13:09:46', NULL);

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

--
-- Структура таблиці `sch_class_schstudent`
--

CREATE TABLE `sch_class_schstudent` (
  `sch_class_id` bigint(20) UNSIGNED NOT NULL,
  `schstudent_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Дамп даних таблиці `sch_class_schstudent`
--

INSERT INTO `sch_class_schstudent` (`sch_class_id`, `schstudent_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 11),
(1, 10),
(1, 12),
(1, 13),
(1, 14),
(1, 15),
(7, 72),
(7, 73),
(7, 74),
(7, 75),
(7, 76),
(7, 77),
(7, 78),
(7, 79),
(8, 90),
(8, 91),
(8, 92),
(8, 93),
(8, 94),
(8, 95),
(8, 96),
(8, 97),
(8, 98),
(8, 99),
(8, 100),
(6, 61),
(6, 62),
(6, 63),
(6, 64),
(6, 65),
(6, 66),
(6, 67),
(6, 68),
(6, 69),
(6, 70),
(5, 48),
(5, 49),
(5, 50),
(5, 51),
(5, 52),
(4, 1),
(4, 2),
(4, 3),
(4, 4),
(4, 5),
(4, 6),
(4, 7),
(4, 8),
(4, 9),
(4, 10),
(4, 11),
(4, 12),
(4, 13),
(4, 14),
(4, 15),
(4, 31),
(4, 32),
(4, 33),
(4, 34),
(4, 35),
(4, 36),
(4, 37),
(4, 38),
(4, 39),
(4, 40),
(4, 41),
(4, 42),
(4, 43),
(4, 44),
(4, 45),
(4, 46),
(4, 47),
(2, 16),
(2, 17),
(2, 18),
(2, 19),
(2, 20),
(2, 21),
(2, 22),
(2, 23),
(2, 24),
(2, 25),
(2, 26),
(2, 27),
(2, 28),
(2, 29);

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

--
-- Структура таблиці `sch_reports`
--

CREATE TABLE `sch_reports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `report` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `report_en` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `schclass_id` bigint(20) UNSIGNED DEFAULT NULL,
  `class_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schstudent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `schteacher_id` bigint(20) UNSIGNED DEFAULT NULL,
  `teacher_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `schsubject_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Дамп даних таблиці `sch_reports`
--

INSERT INTO `sch_reports` (`id`, `report`, `report_en`, `created_at`, `updated_at`, `deleted_at`, `schclass_id`, `class_id`, `schstudent_id`, `schteacher_id`, `teacher_id`, `schsubject_id`) VALUES
(31, 'sadfadsfasdf', NULL, '2025-06-08 16:24:41', '2025-06-08 16:24:41', NULL, NULL, '6', NULL, NULL, '8', NULL),
(33, 'sadfadsfasdf', NULL, '2025-06-08 16:26:10', '2025-06-08 16:26:10', NULL, NULL, '6', NULL, NULL, '8', NULL),
(35, 'sadfadsfasdf', NULL, '2025-06-08 17:07:27', '2025-06-08 17:07:27', NULL, NULL, '6', NULL, NULL, '8', NULL),
(37, 'sadfadsfasdf', NULL, '2025-06-08 17:20:58', '2025-06-08 17:20:58', NULL, NULL, '6', NULL, NULL, '8', NULL),
(38, 'sadfadsfasdf', NULL, '2025-06-08 17:25:44', '2025-06-08 17:25:44', NULL, NULL, '6', NULL, NULL, '8', NULL),
(39, 'sadfadsfasdf', NULL, '2025-06-08 17:25:44', '2025-06-08 18:22:53', '2025-06-08 18:22:53', 6, '6', 61, 22, '8', 21),
(40, 'івфафівафіва', 'sadffsdgsafgafg', '2025-06-08 18:03:23', '2025-06-08 18:03:23', NULL, NULL, '6', NULL, 22, '8', NULL),
(41, 'івфафівафіва', 'sadffsdgsafgafg', '2025-06-08 18:03:23', '2025-06-08 18:06:41', '2025-06-08 18:06:41', 6, '6', 62, 22, '8', 22),
(42, 'віапвіапвіапвап', 'dfsgdfsgdsfgdfggd', '2025-06-08 18:23:05', '2025-06-08 18:23:05', NULL, NULL, '6', NULL, 22, '8', NULL),
(43, 'віапвіапвіапвап', 'dfsgdfsgdsfgdfggd', '2025-06-08 18:23:05', '2025-06-08 18:29:51', '2025-06-08 18:29:51', 6, '6', 61, 22, '8', 22),
(44, '1ввввв', '2dddddd', '2025-06-08 18:24:18', '2025-06-08 18:24:18', NULL, NULL, '6', NULL, 22, '8', NULL),
(45, '1ввввв', '2dddddd', '2025-06-08 18:24:18', '2025-06-08 18:29:58', '2025-06-08 18:29:58', 6, '6', 61, 22, '8', 22),
(46, '3 вапівапвіап', '4dsdsfgsdgdsfgd', '2025-06-08 18:29:31', '2025-06-08 18:30:05', '2025-06-08 18:30:05', 6, '6', 61, 22, '8', 22);

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

--
-- Структура таблиці `sch_subjects`
--

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

--
-- Дамп даних таблиці `sch_subjects`
--

INSERT INTO `sch_subjects` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`, `sch_class_id`) VALUES
(1, 'Cambridge Primary English as a Second Language', '2025-06-06 05:32:51', '2025-06-06 05:32:51', NULL, 1),
(2, 'Cambridge Primary Mathematics', '2025-06-06 05:34:25', '2025-06-06 05:34:25', NULL, 1),
(3, 'Cambridge Primary Science', '2025-06-06 05:34:49', '2025-06-06 05:34:49', NULL, 1),
(4, 'Cambridge Primary Computing', '2025-06-06 05:35:02', '2025-06-06 05:35:02', NULL, 1),
(5, 'Cambridge Primary Global Perspectives', '2025-06-06 05:35:15', '2025-06-06 05:35:15', NULL, 1),
(6, 'Cambridge Primary English as a Second Language', '2025-06-06 05:48:46', '2025-06-06 05:48:46', NULL, 2),
(7, 'Cambridge Primary Mathematics', '2025-06-06 05:49:09', '2025-06-06 05:49:09', NULL, 2),
(8, 'Cambridge Primary Science', '2025-06-06 05:49:33', '2025-06-06 05:49:33', NULL, 2),
(9, 'Cambridge Primary Computing', '2025-06-06 05:49:51', '2025-06-06 05:49:51', NULL, 2),
(10, 'Cambridge Primary Global Perspectives', '2025-06-06 05:50:10', '2025-06-06 05:50:10', NULL, 2),
(11, 'Cambridge Primary English as a Second Language', '2025-06-07 15:11:42', '2025-06-07 15:11:42', NULL, 8),
(12, 'Cambridge Primary Mathematics', '2025-06-07 15:13:26', '2025-06-07 15:13:26', NULL, 8),
(13, 'Cambridge Primary Science', '2025-06-07 15:13:43', '2025-06-07 15:13:43', NULL, 8),
(14, 'Cambridge Primary Computing', '2025-06-07 15:14:00', '2025-06-07 15:14:00', NULL, 8),
(15, 'Cambridge Primary Global Perspectives', '2025-06-07 15:14:19', '2025-06-07 15:14:19', NULL, 8),
(16, 'Cambridge Primary Global Perspectives', '2025-06-07 15:17:33', '2025-06-07 15:17:33', NULL, 7),
(17, 'Cambridge Primary Computing', '2025-06-07 15:17:50', '2025-06-07 15:17:50', NULL, 7),
(18, 'Cambridge Primary Science', '2025-06-07 15:18:04', '2025-06-07 15:18:04', NULL, 7),
(19, 'Cambridge Primary Mathematics', '2025-06-07 15:18:19', '2025-06-07 15:18:19', NULL, 7),
(20, 'Cambridge Primary English as a Second Language', '2025-06-07 15:18:37', '2025-06-07 15:18:37', NULL, 7),
(21, 'Cambridge Lower Secondary  Global Perspectives', '2025-06-07 15:22:04', '2025-06-07 15:22:04', NULL, 6),
(22, 'Cambridge Lower Secondary Computing', '2025-06-07 15:22:23', '2025-06-07 15:22:23', NULL, 6),
(23, 'Cambridge Lower Secondary  Science', '2025-06-07 15:22:42', '2025-06-07 15:22:42', NULL, 6),
(24, 'Cambridge Lower Secondary Mathematics', '2025-06-07 15:23:06', '2025-06-07 15:23:06', NULL, 6),
(25, 'Cambridge Lower Secondary  English as a Second Language', '2025-06-07 15:23:24', '2025-06-07 15:23:24', NULL, 6),
(26, 'Cambridge IGCSE French as a foreign language', '2025-06-07 15:24:06', '2025-06-07 15:24:06', NULL, 5),
(27, 'Cambridge IGCSE German as a foreign language', '2025-06-07 15:24:33', '2025-06-07 15:24:33', NULL, 5),
(28, 'Cambridge IGCSE World Literature', '2025-06-07 15:25:11', '2025-06-07 15:25:11', NULL, 5),
(29, 'Cambridge IGCSE Information and Communication Technology', '2025-06-07 15:25:25', '2025-06-07 15:25:25', NULL, 5),
(30, 'Cambridge IGCSE Global Perspectives', '2025-06-07 15:25:37', '2025-06-07 15:25:37', NULL, 5),
(31, 'Cambridge IGCSE (9-1) Co-ordinated Sciences', '2025-06-07 15:25:52', '2025-06-07 15:25:52', NULL, 5),
(32, 'Cambridge IGCSE (9-1) English as a Second Language (Count-in Speaking)', '2025-06-07 15:26:06', '2025-06-07 15:26:06', NULL, 5),
(33, 'Cambridge IGCSE International Mathematics', '2025-06-07 15:26:19', '2025-06-07 15:26:19', NULL, 5),
(34, 'Cambridge IGCSE French as a foreign language', '2025-06-07 15:27:05', '2025-06-07 15:27:05', NULL, 4),
(35, 'Cambridge IGCSE German as a foreign language', '2025-06-07 15:27:21', '2025-06-07 15:27:21', NULL, 4),
(36, 'Cambridge IGCSE World Literature', '2025-06-07 15:27:33', '2025-06-07 15:27:33', NULL, 4),
(37, 'Cambridge IGCSE Information and Communication Technology', '2025-06-07 15:27:51', '2025-06-07 15:27:51', NULL, 4),
(38, 'Cambridge IGCSE Global Perspectives', '2025-06-07 15:28:03', '2025-06-07 15:28:03', NULL, 4),
(39, 'Cambridge IGCSE (9-1) Co-ordinated Sciences', '2025-06-07 15:28:14', '2025-06-07 15:28:14', NULL, 4),
(40, 'Cambridge IGCSE (9-1) English as a Second Language (Count-in Speaking)', '2025-06-07 15:28:26', '2025-06-07 15:28:26', NULL, 4),
(41, 'Cambridge IGCSE International Mathematics', '2025-06-07 15:28:37', '2025-06-07 15:28:37', NULL, 4);

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

--
-- Структура таблиці `sch_subject_sch_teacher`
--

CREATE TABLE `sch_subject_sch_teacher` (
  `sch_teacher_id` bigint(20) UNSIGNED NOT NULL,
  `sch_subject_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Дамп даних таблиці `sch_subject_sch_teacher`
--

INSERT INTO `sch_subject_sch_teacher` (`sch_teacher_id`, `sch_subject_id`) VALUES
(16, 25),
(30, 21),
(30, 28),
(29, 6),
(28, 12),
(28, 19),
(26, 9),
(26, 14),
(26, 17),
(27, 8),
(27, 13),
(27, 18),
(25, 10),
(23, 15),
(23, 16),
(24, 11),
(22, 22),
(22, 29),
(21, 22),
(21, 29),
(20, 23),
(20, 31),
(19, 32),
(18, 33),
(17, 24);

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

--
-- Структура таблиці `sch_teachers`
--

CREATE TABLE `sch_teachers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_ua` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Дамп даних таблиці `sch_teachers`
--

INSERT INTO `sch_teachers` (`id`, `name_ua`, `name_en`, `user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(16, 'Надія Захарченко', 'Nadiia Zakharchenko', '2', '2025-06-08 07:03:24', '2025-06-08 07:04:29', NULL),
(17, 'Леся Костюченко', 'Lesia Kostiuchenko', '3', '2025-06-08 07:35:14', '2025-06-08 07:56:58', NULL),
(18, 'Галина Анохіна', 'Halyna Anokhina', '4', '2025-06-08 07:35:46', '2025-06-08 07:56:28', NULL),
(19, 'Ірина Бабіченко', 'Iryna Babichenko', '5', '2025-06-08 07:37:52', '2025-06-08 07:55:08', NULL),
(20, 'Ольга Тимчишин', 'Olha Tymchyshyn', '6', '2025-06-08 07:38:55', '2025-06-08 07:53:08', NULL),
(21, 'Ірина Скабенок', 'Iryna Skabenok', '7', '2025-06-08 07:39:42', '2025-06-08 07:52:20', NULL),
(22, 'Юліана Коваленко', 'Yuliana Kovalenko', '8', '2025-06-08 07:40:02', '2025-06-08 07:51:36', NULL),
(23, 'Дар\'я Корнієнко', 'Daria Korniienko', '9', '2025-06-08 07:40:19', '2025-06-08 07:50:12', NULL),
(24, 'Єлизавета Пруженко', 'Yelyzaveta Pruzhenko', '10', '2025-06-08 07:40:56', '2025-06-08 07:50:35', NULL),
(25, 'Ольга Ремешевська', 'Olha Remeshevska', '11', '2025-06-08 07:41:21', '2025-06-08 07:49:14', NULL),
(26, 'Олег Булаарас', 'Oleh Bulaaras', '12', '2025-06-08 07:41:42', '2025-06-08 07:48:02', NULL),
(27, 'Світлана Черненко', 'Svitlana Chernenko', '13', '2025-06-08 07:42:01', '2025-06-08 07:48:48', NULL),
(28, 'Елен Тунда', 'Ellen Tunda', '14', '2025-06-08 07:42:19', '2025-06-08 07:46:56', NULL),
(29, 'Марія Пономаренко', 'Mariia Ponomarenko', '15', '2025-06-08 07:42:34', '2025-06-08 07:46:21', NULL),
(30, 'Нінель Бардакова', 'Ninel Bardakova', '16', '2025-06-08 07:42:45', '2025-06-08 07:45:45', NULL),
(31, 'Testua tteastua', 'Teasten  111 tteasten', '17', '2025-06-08 15:33:49', '2025-06-08 15:33:49', NULL);

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

--
-- Структура таблиці `teams`
--

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

--
-- Індекси збережених таблиць
--

--
-- Індекси таблиці `crm_customers`
--
ALTER TABLE `crm_customers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `crm_customers_name_parent_unique` (`name_parent`),
  ADD KEY `status_fk_8115136` (`status_id`);

--
-- Індекси таблиці `crm_documents`
--
ALTER TABLE `crm_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_fk_8115153` (`customer_id`);

--
-- Індекси таблиці `crm_notes`
--
ALTER TABLE `crm_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_fk_8115147` (`customer_id`);

--
-- Індекси таблиці `crm_statuses`
--
ALTER TABLE `crm_statuses`
  ADD PRIMARY KEY (`id`);

--
-- Індекси таблиці `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_uuid_unique` (`uuid`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  ADD KEY `media_order_column_index` (`order_column`);

--
-- Індекси таблиці `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Індекси таблиці `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Індекси таблиці `permission_role`
--
ALTER TABLE `permission_role`
  ADD KEY `role_id_fk_8115069` (`role_id`),
  ADD KEY `permission_id_fk_8115069` (`permission_id`);

--
-- Індекси таблиці `psiholog_anketa`
--
ALTER TABLE `psiholog_anketa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name_childe_fk_8115362` (`name_childe_id`),
  ADD KEY `name_psyholog_fk_8136088` (`name_psyholog_id`);

--
-- Індекси таблиці `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Індекси таблиці `role_user`
--
ALTER TABLE `role_user`
  ADD KEY `user_id_fk_8115078` (`user_id`),
  ADD KEY `role_id_fk_8115078` (`role_id`);

--
-- Індекси таблиці `schstudents`
--
ALTER TABLE `schstudents`
  ADD PRIMARY KEY (`id`);

--
-- Індекси таблиці `sch_classes`
--
ALTER TABLE `sch_classes`
  ADD PRIMARY KEY (`id`);

--
-- Індекси таблиці `sch_class_schstudent`
--
ALTER TABLE `sch_class_schstudent`
  ADD KEY `sch_class_id_fk_10602843` (`sch_class_id`),
  ADD KEY `schstudent_id_fk_10602843` (`schstudent_id`);

--
-- Індекси таблиці `sch_reports`
--
ALTER TABLE `sch_reports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `schstudent_fk_10602407` (`schstudent_id`),
  ADD KEY `schteacher_fk_10602155` (`schteacher_id`),
  ADD KEY `schsubject_fk_10602408` (`schsubject_id`),
  ADD KEY `schclass_fk_10603089` (`schclass_id`);

--
-- Індекси таблиці `sch_subjects`
--
ALTER TABLE `sch_subjects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sch_class_fk_10602162` (`sch_class_id`);

--
-- Індекси таблиці `sch_subject_sch_teacher`
--
ALTER TABLE `sch_subject_sch_teacher`
  ADD KEY `sch_teacher_id_fk_10602671` (`sch_teacher_id`),
  ADD KEY `sch_subject_id_fk_10602671` (`sch_subject_id`);

--
-- Індекси таблиці `sch_teachers`
--
ALTER TABLE `sch_teachers`
  ADD PRIMARY KEY (`id`);

--
-- Індекси таблиці `teams`
--
ALTER TABLE `teams`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teams_owner_id_foreign` (`owner_id`);

--
-- AUTO_INCREMENT для збережених таблиць
--

--
-- AUTO_INCREMENT для таблиці `crm_customers`
--
ALTER TABLE `crm_customers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблиці `crm_documents`
--
ALTER TABLE `crm_documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблиці `crm_notes`
--
ALTER TABLE `crm_notes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблиці `crm_statuses`
--
ALTER TABLE `crm_statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT для таблиці `media`
--
ALTER TABLE `media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблиці `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT для таблиці `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT для таблиці `psiholog_anketa`
--
ALTER TABLE `psiholog_anketa`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблиці `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT для таблиці `schstudents`
--
ALTER TABLE `schstudents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;

--
-- AUTO_INCREMENT для таблиці `sch_classes`
--
ALTER TABLE `sch_classes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT для таблиці `sch_reports`
--
ALTER TABLE `sch_reports`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT для таблиці `sch_subjects`
--
ALTER TABLE `sch_subjects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT для таблиці `sch_teachers`
--
ALTER TABLE `sch_teachers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT для таблиці `teams`
--
ALTER TABLE `teams`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Обмеження зовнішнього ключа збережених таблиць
--

--
-- Обмеження зовнішнього ключа таблиці `crm_customers`
--
ALTER TABLE `crm_customers`
  ADD CONSTRAINT `status_fk_8115136` FOREIGN KEY (`status_id`) REFERENCES `crm_statuses` (`id`);

--
-- Обмеження зовнішнього ключа таблиці `crm_documents`
--
ALTER TABLE `crm_documents`
  ADD CONSTRAINT `customer_fk_8115153` FOREIGN KEY (`customer_id`) REFERENCES `crm_customers` (`id`);

--
-- Обмеження зовнішнього ключа таблиці `crm_notes`
--
ALTER TABLE `crm_notes`
  ADD CONSTRAINT `customer_fk_8115147` FOREIGN KEY (`customer_id`) REFERENCES `crm_customers` (`id`);

--
-- Обмеження зовнішнього ключа таблиці `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_id_fk_8115069` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_id_fk_8115069` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Обмеження зовнішнього ключа таблиці `psiholog_anketa`
--
ALTER TABLE `psiholog_anketa`
  ADD CONSTRAINT `name_childe_fk_8115362` FOREIGN KEY (`name_childe_id`) REFERENCES `crm_customers` (`id`),
  ADD CONSTRAINT `name_psyholog_fk_8136088` FOREIGN KEY (`name_psyholog_id`) REFERENCES `users` (`id`);

--
-- Обмеження зовнішнього ключа таблиці `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_id_fk_8115078` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_id_fk_8115078` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Обмеження зовнішнього ключа таблиці `sch_class_schstudent`
--
ALTER TABLE `sch_class_schstudent`
  ADD CONSTRAINT `sch_class_id_fk_10602843` FOREIGN KEY (`sch_class_id`) REFERENCES `sch_classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `schstudent_id_fk_10602843` FOREIGN KEY (`schstudent_id`) REFERENCES `schstudents` (`id`) ON DELETE CASCADE;

--
-- Обмеження зовнішнього ключа таблиці `sch_reports`
--
ALTER TABLE `sch_reports`
  ADD CONSTRAINT `schstudent_fk_10602407` FOREIGN KEY (`schstudent_id`) REFERENCES `schstudents` (`id`),
  ADD CONSTRAINT `schsubject_fk_10602408` FOREIGN KEY (`schsubject_id`) REFERENCES `sch_subjects` (`id`),
  ADD CONSTRAINT `schteacher_fk_10602155` FOREIGN KEY (`schteacher_id`) REFERENCES `sch_teachers` (`id`);

--
-- Обмеження зовнішнього ключа таблиці `sch_subjects`
--
ALTER TABLE `sch_subjects`
  ADD CONSTRAINT `sch_class_fk_10602162` FOREIGN KEY (`sch_class_id`) REFERENCES `sch_classes` (`id`);

--
-- Обмеження зовнішнього ключа таблиці `sch_subject_sch_teacher`
--
ALTER TABLE `sch_subject_sch_teacher`
  ADD CONSTRAINT `sch_subject_id_fk_10602671` FOREIGN KEY (`sch_subject_id`) REFERENCES `sch_subjects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sch_teacher_id_fk_10602671` FOREIGN KEY (`sch_teacher_id`) REFERENCES `sch_teachers` (`id`) ON DELETE CASCADE;

--
-- Обмеження зовнішнього ключа таблиці `teams`
--
ALTER TABLE `teams`
  ADD CONSTRAINT `teams_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;

