/*
 Navicat Premium Data Transfer

 Source Server         : Localhost
 Source Server Type    : MySQL
 Source Server Version : 100427
 Source Host           : localhost:3306
 Source Schema         : siadu

 Target Server Type    : MySQL
 Target Server Version : 100427
 File Encoding         : 65001

 Date: 15/05/2023 18:12:41
*/


-- ----------------------------
-- Table structure for siadu_item_types
-- ----------------------------
CREATE TABLE `siadu_item_types`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_item_types
-- ----------------------------
INSERT INTO `siadu_item_types` VALUES (1, 'Tipe 1', '2023-04-10 07:14:37', '2023-04-10 07:14:37', NULL);
INSERT INTO `siadu_item_types` VALUES (2, 'Tipe 2', '2023-04-10 07:14:44', '2023-04-10 07:15:03', NULL);
INSERT INTO `siadu_item_types` VALUES (3, 'Tipe 3', '2023-04-10 07:15:11', '2023-04-10 07:15:15', '2023-04-10 07:15:15');
INSERT INTO `siadu_item_types` VALUES (4, 'bahaya', '2023-05-03 10:38:20', '2023-05-03 10:38:20', NULL);

-- ----------------------------
-- Table structure for siadu_items
-- ----------------------------
CREATE TABLE `siadu_items`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `item_type_id` int(11) NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `unit_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `volume_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `volume_per_unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_items
-- ----------------------------
INSERT INTO `siadu_items` VALUES (1, 'BAHAN1', 1, 'Bahan 1', 'Kotak', 'Lembar', '500', '2023-04-10 07:41:37', '2023-05-10 04:14:46', NULL);
INSERT INTO `siadu_items` VALUES (2, 'BAHAN2', 1, 'Bahan 2', NULL, NULL, NULL, '2023-04-10 07:43:18', '2023-04-10 07:44:13', '2023-04-10 07:44:13');
INSERT INTO `siadu_items` VALUES (3, '1511', 2, 'Bahan 2', 'Botol', 'ml', '100', '2023-04-18 06:58:15', '2023-05-10 06:53:48', NULL);

-- ----------------------------
-- Table structure for siadu_labs
-- ----------------------------
CREATE TABLE `siadu_labs`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `unit_id` int(11) NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_labs
-- ----------------------------
INSERT INTO `siadu_labs` VALUES (1, 'Laboratorium Biokimia', 2, '2023-04-06 05:58:29', '2023-04-06 05:58:55', NULL);
INSERT INTO `siadu_labs` VALUES (2, 'Laboratorium Umum', 1, '2023-04-06 05:58:45', '2023-04-06 05:59:05', '2023-04-06 05:59:05');

-- ----------------------------
-- Table structure for siadu_menus
-- ----------------------------
CREATE TABLE `siadu_menus`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sort` int(11) NULL DEFAULT NULL,
  `category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `keyword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `only_prodi` int(11) NOT NULL,
  `has_view` int(11) NOT NULL,
  `has_add` int(11) NOT NULL,
  `has_edit` int(11) NOT NULL,
  `has_delete` int(11) NOT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  `updated_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 116 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_menus
-- ----------------------------
INSERT INTO `siadu_menus` VALUES (1, 1, 'Master data', 'Unit', 'Unit', 0, 1, 1, 1, 1, '2022-12-09 06:24:37', '2023-05-03 11:13:08', NULL);
INSERT INTO `siadu_menus` VALUES (2, 2, 'Master data', 'Laboratorium', 'Laboratorium', 1, 1, 1, 1, 1, '2022-11-28 04:55:17', '2023-05-03 11:13:16', NULL);
INSERT INTO `siadu_menus` VALUES (3, 3, 'Master data', 'Bahan', 'Bahan', 0, 1, 1, 1, 1, '2022-11-28 04:55:17', '2023-05-03 11:51:55', NULL);
INSERT INTO `siadu_menus` VALUES (4, 4, 'Master data', 'Jenis Bahan', 'Jenis Bahan', 0, 1, 1, 1, 1, '2022-11-28 04:55:17', '2023-05-03 11:13:21', NULL);
INSERT INTO `siadu_menus` VALUES (5, 5, 'Master data', 'Alat', 'Alat', 0, 1, 1, 1, 1, '2022-12-02 11:58:43', '2023-05-03 11:13:23', NULL);
INSERT INTO `siadu_menus` VALUES (6, 6, 'Master data', 'Jenis Alat', 'Jenis Alat', 0, 1, 1, 1, 1, '2022-11-28 04:55:17', '2023-05-03 11:13:25', NULL);
INSERT INTO `siadu_menus` VALUES (7, 7, 'Bahan', 'Bahan Unit', 'Bahan Unit', 1, 1, 1, 1, 1, '2022-11-28 05:00:58', '2023-05-03 11:13:29', NULL);
INSERT INTO `siadu_menus` VALUES (8, 9, 'Bahan', 'Stok Masuk', 'Stok Masuk', 1, 1, 1, 0, 0, '2022-11-28 05:00:58', '2023-05-03 11:13:31', NULL);
INSERT INTO `siadu_menus` VALUES (9, 10, 'Bahan', 'Stok Keluar', 'Stok Keluar', 1, 1, 1, 0, 0, '2022-11-28 05:00:58', '2023-05-03 11:13:33', NULL);
INSERT INTO `siadu_menus` VALUES (10, 11, 'Alat', 'Alat Unit', 'Alat Unit', 1, 1, 1, 1, 1, '2022-11-28 05:00:58', '2023-05-03 11:13:36', NULL);
INSERT INTO `siadu_menus` VALUES (11, 12, 'Akun', 'Role', 'Role', 0, 1, 1, 1, 1, '2022-11-28 05:00:58', '2023-05-03 11:13:38', NULL);
INSERT INTO `siadu_menus` VALUES (12, 13, 'Akun', 'Admin', 'Admin', 1, 1, 1, 1, 1, '2022-11-28 05:07:25', '2023-05-03 11:13:42', NULL);
INSERT INTO `siadu_menus` VALUES (13, 14, 'Akun', 'Mahasiswa', 'Mahasiswa', 1, 1, 1, 1, 1, '2022-11-28 05:07:25', '2023-05-03 11:13:44', NULL);
INSERT INTO `siadu_menus` VALUES (14, 8, 'Akun', 'Umum', 'Umum', 1, 1, 1, 1, 1, '2023-01-10 06:15:51', '2023-05-03 11:13:46', NULL);
INSERT INTO `siadu_menus` VALUES (115, NULL, 'Master data', 'Semester', 'Semester', 0, 1, 1, 1, 1, '2023-05-08 10:47:49', '2023-05-08 10:48:37', NULL);

-- ----------------------------
-- Table structure for siadu_role_permissions
-- ----------------------------
CREATE TABLE `siadu_role_permissions`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  `view_access` int(11) NOT NULL,
  `add_access` int(11) NOT NULL,
  `edit_access` int(11) NOT NULL,
  `delete_access` int(11) NOT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  `updated_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 912 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_role_permissions
-- ----------------------------
INSERT INTO `siadu_role_permissions` VALUES (869, 43, 1, 0, 0, 0, 0, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (870, 43, 2, 1, 1, 1, 1, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (871, 43, 3, 0, 0, 0, 0, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (872, 43, 4, 0, 0, 0, 0, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (873, 43, 5, 0, 0, 0, 0, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (874, 43, 6, 0, 0, 0, 0, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (875, 43, 7, 1, 1, 1, 1, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (876, 43, 14, 1, 1, 1, 1, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (877, 43, 8, 1, 1, 0, 0, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (878, 43, 9, 1, 1, 0, 0, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (879, 43, 10, 1, 1, 1, 1, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (880, 43, 11, 0, 0, 0, 0, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (881, 43, 12, 1, 1, 1, 1, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (882, 43, 13, 1, 1, 1, 1, '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_role_permissions` VALUES (883, 1, 1, 1, 1, 1, 1, '2023-04-28 09:18:32', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (884, 1, 2, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (885, 1, 3, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (886, 1, 4, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (887, 1, 5, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (888, 1, 6, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (889, 1, 7, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (890, 1, 14, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (891, 1, 8, 1, 1, 0, 0, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (892, 1, 9, 1, 1, 0, 0, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (893, 1, 10, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (894, 1, 11, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (895, 1, 12, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (896, 1, 13, 1, 1, 1, 1, '2023-04-28 09:18:33', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_role_permissions` VALUES (897, 45, 1, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (898, 45, 2, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (899, 45, 3, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (900, 45, 4, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (901, 45, 5, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (902, 45, 6, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (903, 45, 7, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (904, 45, 14, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (905, 45, 8, 1, 1, 0, 0, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (906, 45, 9, 1, 1, 0, 0, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (907, 45, 10, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (908, 45, 11, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (909, 45, 12, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (910, 45, 13, 1, 1, 1, 1, '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);
INSERT INTO `siadu_role_permissions` VALUES (911, 1, 115, 1, 1, 1, 1, '2023-05-08 06:48:36', '2023-05-08 06:48:36', NULL);

-- ----------------------------
-- Table structure for siadu_roles
-- ----------------------------
CREATE TABLE `siadu_roles`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_id` int(11) NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  `updated_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_roles
-- ----------------------------
INSERT INTO `siadu_roles` VALUES (1, NULL, 'Super admin', '2022-12-01 21:57:05', '2023-05-08 06:48:36', NULL);
INSERT INTO `siadu_roles` VALUES (2, 1, 'Admin farmasi', '2022-12-03 18:20:53', '2023-04-28 09:54:45', '2023-04-28 09:54:45');
INSERT INTO `siadu_roles` VALUES (43, 14, 'Admin Lab Terpadu', '2023-04-28 03:43:25', '2023-05-04 10:35:57', NULL);
INSERT INTO `siadu_roles` VALUES (45, NULL, 'Contoh', '2023-05-05 03:35:52', '2023-05-05 03:35:52', NULL);

-- ----------------------------
-- Table structure for siadu_semesters
-- ----------------------------
CREATE TABLE `siadu_semesters`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `semester` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tahun_ajaran` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `status` int(1) NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_semesters
-- ----------------------------
INSERT INTO `siadu_semesters` VALUES (1, 'Genap', '2022/2023', 1, '2023-05-08 06:51:43', '2023-05-08 08:00:42', NULL);

-- ----------------------------
-- Table structure for siadu_tool_types
-- ----------------------------
CREATE TABLE `siadu_tool_types`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_tool_types
-- ----------------------------
INSERT INTO `siadu_tool_types` VALUES (1, 'Kaca', '2023-04-13 04:44:29', '2023-04-13 04:44:29', NULL);
INSERT INTO `siadu_tool_types` VALUES (2, 'Non-Kaca', '2023-04-13 04:44:37', '2023-04-13 04:44:37', NULL);
INSERT INTO `siadu_tool_types` VALUES (3, 'Rapuh Sekali', '2023-04-13 04:44:42', '2023-04-13 04:44:53', '2023-04-13 04:44:53');

-- ----------------------------
-- Table structure for siadu_tools
-- ----------------------------
CREATE TABLE `siadu_tools`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tool_type_id` int(11) NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_tools
-- ----------------------------
INSERT INTO `siadu_tools` VALUES (1, 'Alat 1', 2, '2023-04-13 07:13:16', '2023-04-13 07:15:37', NULL);
INSERT INTO `siadu_tools` VALUES (2, 'Alat 2', 2, '2023-04-13 07:15:47', '2023-04-13 07:15:51', NULL);

-- ----------------------------
-- Table structure for siadu_unit_item_stock_in
-- ----------------------------
CREATE TABLE `siadu_unit_item_stock_in`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_id` int(11) NULL DEFAULT NULL,
  `semester_id` int(11) NULL DEFAULT NULL,
  `is_approved` int(1) NULL DEFAULT NULL,
  `is_received` int(1) NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_unit_item_stock_in
-- ----------------------------
INSERT INTO `siadu_unit_item_stock_in` VALUES (3, 14, 1, NULL, NULL, '2023-04-26 05:00:00', '2023-04-26 05:00:00', NULL);
INSERT INTO `siadu_unit_item_stock_in` VALUES (4, 14, 1, NULL, NULL, '2023-04-26 07:58:43', '2023-04-26 07:58:43', NULL);
INSERT INTO `siadu_unit_item_stock_in` VALUES (5, 14, 1, NULL, NULL, '2023-04-26 08:00:16', '2023-04-26 08:00:16', NULL);
INSERT INTO `siadu_unit_item_stock_in` VALUES (6, 14, 1, 1, 1, '2023-04-26 08:00:46', '2023-05-10 08:17:03', NULL);
INSERT INTO `siadu_unit_item_stock_in` VALUES (7, 14, 1, 1, 1, '2023-05-03 10:52:16', '2023-05-10 01:28:05', NULL);
INSERT INTO `siadu_unit_item_stock_in` VALUES (8, 14, 1, 1, 1, '2023-05-09 05:26:01', '2023-05-09 09:48:11', NULL);
INSERT INTO `siadu_unit_item_stock_in` VALUES (9, 14, 1, NULL, NULL, '2023-05-10 09:45:43', '2023-05-10 09:45:43', NULL);
INSERT INTO `siadu_unit_item_stock_in` VALUES (10, 14, 1, 1, 1, '2023-05-10 09:59:04', '2023-05-15 15:21:27', NULL);
INSERT INTO `siadu_unit_item_stock_in` VALUES (11, 14, 1, 1, 1, '2023-05-11 04:22:38', '2023-05-12 10:07:53', NULL);

-- ----------------------------
-- Table structure for siadu_unit_item_stock_in_details
-- ----------------------------
CREATE TABLE `siadu_unit_item_stock_in_details`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_item_id` int(11) NULL DEFAULT NULL,
  `unit_item_stock_in_id` int(11) NULL DEFAULT NULL,
  `requested` int(11) NULL DEFAULT NULL,
  `approved` int(11) NULL DEFAULT NULL,
  `received` int(11) NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_unit_item_stock_in_details
-- ----------------------------
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (1, 3, 3, 5, NULL, NULL, '2023-04-26 05:00:00', '2023-04-26 05:00:00', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (2, 4, 3, 6, NULL, NULL, '2023-04-26 05:00:00', '2023-04-26 05:00:00', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (3, 3, 4, 10, NULL, NULL, '2023-04-26 07:58:43', '2023-04-26 07:58:43', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (4, 4, 5, 6, NULL, NULL, '2023-04-26 08:00:16', '2023-04-26 08:00:16', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (5, 3, 6, 3, 3, 3, '2023-04-26 08:00:46', '2023-05-10 08:17:03', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (6, 3, 7, 10, 4, 2, '2023-05-03 10:52:16', '2023-05-10 01:28:05', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (7, 4, 7, 5, 2, 2, '2023-05-03 10:52:16', '2023-05-10 01:28:05', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (8, 3, 8, 2, 2, 1, '2023-05-09 05:26:01', '2023-05-09 09:48:11', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (9, 4, 8, 3, 3, 2, '2023-05-09 05:26:01', '2023-05-09 09:48:11', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (10, 4, 9, 10, NULL, NULL, '2023-05-10 09:45:43', '2023-05-10 09:45:43', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (11, 3, 9, 5, NULL, NULL, '2023-05-10 09:45:43', '2023-05-10 09:45:43', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (12, 4, 10, 7, 2, 2, '2023-05-10 09:59:04', '2023-05-15 15:21:18', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (14, 4, 11, 2, 2, 2, '2023-05-11 04:22:38', '2023-05-12 10:05:36', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (15, 3, 11, 3, 3, 3, '2023-05-11 04:22:38', '2023-05-12 10:07:53', NULL);
INSERT INTO `siadu_unit_item_stock_in_details` VALUES (19, 3, 10, 2, 2, 2, '2023-05-15 14:53:07', '2023-05-15 15:21:27', NULL);

-- ----------------------------
-- Table structure for siadu_unit_item_stock_out
-- ----------------------------
CREATE TABLE `siadu_unit_item_stock_out`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_id` int(11) NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_unit_item_stock_out
-- ----------------------------
INSERT INTO `siadu_unit_item_stock_out` VALUES (7, 14, '2023-04-26 09:54:11', '2023-04-26 09:54:11', NULL);
INSERT INTO `siadu_unit_item_stock_out` VALUES (8, 14, '2023-05-10 10:25:23', '2023-05-10 10:25:23', NULL);

-- ----------------------------
-- Table structure for siadu_unit_item_stock_out_details
-- ----------------------------
CREATE TABLE `siadu_unit_item_stock_out_details`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_item_id` int(11) NULL DEFAULT NULL,
  `unit_item_stock_out_id` int(11) NULL DEFAULT NULL,
  `total` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_unit_item_stock_out_details
-- ----------------------------
INSERT INTO `siadu_unit_item_stock_out_details` VALUES (6, 3, 7, '2', '2023-04-26 09:54:11', '2023-04-26 09:54:11', NULL);
INSERT INTO `siadu_unit_item_stock_out_details` VALUES (7, 4, 8, '1', '2023-05-10 10:25:23', '2023-05-10 10:25:23', NULL);
INSERT INTO `siadu_unit_item_stock_out_details` VALUES (8, 3, 8, '100', '2023-05-10 10:25:23', '2023-05-10 10:25:23', NULL);

-- ----------------------------
-- Table structure for siadu_unit_items
-- ----------------------------
CREATE TABLE `siadu_unit_items`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_id` int(11) NULL DEFAULT NULL,
  `item_id` int(11) NULL DEFAULT NULL,
  `stock` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `unit_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_unit_items
-- ----------------------------
INSERT INTO `siadu_unit_items` VALUES (1, 1, 1, '0', NULL, '2023-04-11 08:11:21', '2023-04-11 08:12:43', NULL);
INSERT INTO `siadu_unit_items` VALUES (2, 13, 1, '0', NULL, '2023-04-11 08:11:37', '2023-04-11 08:11:37', NULL);
INSERT INTO `siadu_unit_items` VALUES (3, 14, 1, '3929', NULL, '2023-04-17 04:11:25', '2023-05-15 15:21:27', NULL);
INSERT INTO `siadu_unit_items` VALUES (4, 14, 3, '420', NULL, '2023-04-18 06:58:31', '2023-05-15 15:21:18', NULL);

-- ----------------------------
-- Table structure for siadu_unit_tool_detail_conditions
-- ----------------------------
CREATE TABLE `siadu_unit_tool_detail_conditions`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_unit_tool_detail_conditions
-- ----------------------------
INSERT INTO `siadu_unit_tool_detail_conditions` VALUES (1, 'Bagus', '2023-04-14 16:43:25', '2023-04-14 16:43:25', NULL);
INSERT INTO `siadu_unit_tool_detail_conditions` VALUES (2, 'Rusak Ringan', '2023-04-14 16:43:25', '2023-04-14 16:43:25', NULL);
INSERT INTO `siadu_unit_tool_detail_conditions` VALUES (3, 'Rusak Berat', '2023-04-14 16:43:25', '2023-04-14 16:43:25', NULL);

-- ----------------------------
-- Table structure for siadu_unit_tool_details
-- ----------------------------
CREATE TABLE `siadu_unit_tool_details`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_tool_id` int(11) NULL DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `condition` int(1) NULL DEFAULT NULL,
  `year` year NULL DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_unit_tool_details
-- ----------------------------
INSERT INTO `siadu_unit_tool_details` VALUES (1, 2, 'B001', 3, 2023, 'bagus aja', '2023-04-14 09:41:09', '2023-04-14 09:54:35', NULL);
INSERT INTO `siadu_unit_tool_details` VALUES (2, 2, 'B002', 1, 2022, NULL, '2023-04-17 06:19:22', '2023-04-17 06:19:22', NULL);
INSERT INTO `siadu_unit_tool_details` VALUES (3, 2, 'B003', 1, 2023, NULL, '2023-04-17 06:19:41', '2023-04-17 06:19:41', NULL);

-- ----------------------------
-- Table structure for siadu_unit_tools
-- ----------------------------
CREATE TABLE `siadu_unit_tools`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_id` int(11) NULL DEFAULT NULL,
  `tool_id` int(11) NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_unit_tools
-- ----------------------------
INSERT INTO `siadu_unit_tools` VALUES (1, 1, 1, '2023-04-13 08:02:52', '2023-04-13 08:02:52', NULL);
INSERT INTO `siadu_unit_tools` VALUES (2, 14, 2, '2023-04-13 08:04:09', '2023-04-13 08:04:09', NULL);

-- ----------------------------
-- Table structure for siadu_units
-- ----------------------------
CREATE TABLE `siadu_units`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `signer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `nip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of siadu_units
-- ----------------------------
INSERT INTO `siadu_units` VALUES (1, 'Farmasi', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (2, 'Gizi', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (3, 'Kebidanan Medan', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (4, 'Kebidanan Padang Sidempuan', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (5, 'Kebidanan Pematangsiantar', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (6, 'Kebidanan Tapanuli Utara', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (7, 'Keperawatan Medan', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (8, 'Keperawatan Dairi', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (9, 'Keperawatan Gunungsitoli', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (10, 'Keperawatan Tapanuli Tengah', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (11, 'Kesehatan Gigi', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (12, 'Sanitasi', NULL, NULL, NULL, '2023-03-09 15:29:56', '2023-03-09 15:29:56', NULL);
INSERT INTO `siadu_units` VALUES (13, 'Teknologi Laboratorium Medis', 'Nita Andriani Lubis', '199808012022031001', 'Ketua Jurusan Teknologi Laboratorium Medis', '2023-03-09 15:29:56', '2023-05-15 15:49:40', NULL);
INSERT INTO `siadu_units` VALUES (14, 'Laboratorium Terpadu', 'Gabriella Septiani', '199808012022031001', 'Kepala Unit Laboratorium Terpadu', '2023-03-09 15:29:56', '2023-05-15 16:00:37', NULL);
INSERT INTO `siadu_units` VALUES (15, 'Test2', NULL, NULL, NULL, '2023-04-06 05:28:43', '2023-04-06 05:29:41', '2023-04-06 05:29:41');

