-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------


-- Dumping structure for table dkppp.action_logs
CREATE TABLE IF NOT EXISTS `action_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `metadata` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.action_logs: ~14 rows (approximately)
DELETE FROM `action_logs`;


-- Dumping structure for table dkppp.betina
CREATE TABLE IF NOT EXISTS `betina` (
  `id_betina` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_peternak` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis_sapi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ear_tag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_betina`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.betina: ~2 rows (approximately)
DELETE FROM `betina`;
INSERT INTO `betina` (`id_betina`, `id_peternak`, `nama`, `jenis_sapi`, `ear_tag`, `tanggal_lahir`, `created_at`, `updated_at`) VALUES
	('BETINA-2025-0001', 'PETERNAK-2025-0001', 'Porro et eveniet ve', 'Sit molestiae molest', NULL, '2017-08-11', NULL, NULL),
	('BETINA-2025-0002', 'PETERNAK-2025-0002', 'Sint in ipsa recus', 'Qui ut voluptate dol', NULL, '2019-06-01', NULL, NULL);

-- Dumping structure for table dkppp.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.failed_jobs: ~0 rows (approximately)
DELETE FROM `failed_jobs`;

-- Dumping structure for table dkppp.ib
CREATE TABLE IF NOT EXISTS `ib` (
  `id_ib` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_kejadian` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_staff` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Belum Ada Tindakan',
  `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_ib`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.ib: ~3 rows (approximately)
DELETE FROM `ib`;
INSERT INTO `ib` (`id_ib`, `id_kejadian`, `id_staff`, `status`, `keterangan`, `created_at`, `updated_at`) VALUES
	('IB-2025-0001', 'KEJADIAN-2025-0001', 'STAFF-2025-0001', 'Belum Ada Tindakan', NULL, '2025-03-29 00:00:00', '2025-07-08 23:31:18'),
	('IB-2025-0002', 'KEJADIAN-2025-0003', 'STAFF-2025-0002', 'Belum Ada Tindakan', NULL, '2024-11-29 00:00:00', NULL);

-- Dumping structure for table dkppp.kebuntingan
CREATE TABLE IF NOT EXISTS `kebuntingan` (
  `id_kebuntingan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_kejadian` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_staff` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Belum Ada Tindakan',
  `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_kebuntingan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.kebuntingan: ~0 rows (approximately)
DELETE FROM `kebuntingan`;

-- Dumping structure for table dkppp.kejadian
CREATE TABLE IF NOT EXISTS `kejadian` (
  `id_kejadian` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_betina` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_pejantan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Belum Ada Tindakan',
  `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_kejadian`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.kejadian: ~0 rows (approximately)
DELETE FROM `kejadian`;
INSERT INTO `kejadian` (`id_kejadian`, `id_betina`, `id_pejantan`, `status`, `keterangan`, `created_at`, `updated_at`) VALUES
	('KEJADIAN-2025-0001', 'BETINA-2025-0001', 'JANTAN-2025-0001', 'Belum Ada Tindakan', NULL, '2021-02-06 00:00:00', '2025-07-08 23:31:18'),
	('KEJADIAN-2025-0002', 'BETINA-2025-0002', 'JANTAN-2025-0001', 'Belum Ada Tindakan', NULL, '2024-11-29 00:00:00', NULL),
	('KEJADIAN-2025-0003', 'BETINA-2025-0002', 'JANTAN-2025-0001', 'Belum Ada Tindakan', NULL, '2024-12-02 00:00:00', '2025-07-08 23:08:51');

-- Dumping structure for table dkppp.log
CREATE TABLE IF NOT EXISTS `log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_log` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.log: ~0 rows (approximately)
DELETE FROM `log`;

-- Dumping structure for table dkppp.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.migrations: ~14 rows (approximately)
DELETE FROM `migrations`;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_000000_create_users_table', 1),
	(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
	(3, '2019_08_19_000000_create_failed_jobs_table', 1),
	(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(5, '2025_05_22_033033_create_staff', 1),
	(6, '2025_05_22_033749_create_peternak', 1),
	(7, '2025_05_22_033833_create_pejantan', 1),
	(8, '2025_05_22_033841_create_betina', 1),
	(9, '2025_05_22_033851_create_kejadian', 1),
	(10, '2025_05_22_033858_create_ib', 1),
	(11, '2025_05_22_033905_create_pkb', 1),
	(12, '2025_05_22_033920_create_kebuntingan', 1),
	(13, '2025_06_05_163802_create_log', 1),
	(14, '2025_06_07_091143_create_action_logs_table', 1);

-- Dumping structure for table dkppp.password_reset_tokens
CREATE TABLE IF NOT EXISTS `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.password_reset_tokens: ~0 rows (approximately)
DELETE FROM `password_reset_tokens`;

-- Dumping structure for table dkppp.pejantan
CREATE TABLE IF NOT EXISTS `pejantan` (
  `id_pejantan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_peternak` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis_sapi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ear_tag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_pejantan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.pejantan: ~0 rows (approximately)
DELETE FROM `pejantan`;
INSERT INTO `pejantan` (`id_pejantan`, `id_peternak`, `nama`, `jenis_sapi`, `ear_tag`, `tanggal_lahir`, `created_at`, `updated_at`) VALUES
	('JANTAN-2025-0001', 'PETERNAK-2025-0001', 'Minus pariatur Sit', 'Fugiat fugiat id du', NULL, '1995-04-21', NULL, NULL);

-- Dumping structure for table dkppp.personal_access_tokens
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.personal_access_tokens: ~0 rows (approximately)
DELETE FROM `personal_access_tokens`;

-- Dumping structure for table dkppp.peternak
CREATE TABLE IF NOT EXISTS `peternak` (
  `id_peternak` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_hp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_peternak`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.peternak: ~13 rows (approximately)
DELETE FROM `peternak`;
INSERT INTO `peternak` (`id_peternak`, `nama`, `alamat`, `email`, `no_hp`, `created_at`, `updated_at`) VALUES
	('PETERNAK-2025-0001', 'Lael Brock', 'Laborum commodo sequ', 'xydu@mailinator.com', '085680919239', NULL, NULL),
	('PETERNAK-2025-0002', 'Jada Clemons', 'Reiciendis tempor es', 'sihunun@mailinator.com', '085127944918', NULL, NULL),
	('PETERNAK-2025-0003', 'Fikri', 'Banjar', 'fikri@gmail.com', '082316861194', NULL, NULL),
	('PETERNAK-2025-0004', 'Suyanto', 'Purwaharja', 'suyanto@gmail.com', '082316715975', NULL, NULL),
	('PETERNAK-2025-0005', 'Yana', 'Langensari', 'yana@gmail.com', '081914585816', NULL, NULL),
	('PETERNAK-2025-0006', 'Sutono', 'Langensari', 'sutono@gmail.com', '082216883127', NULL, NULL),
	('PETERNAK-2025-0007', 'Enceng', 'Balokang', 'enceng@gmail.com', '081221355001', NULL, NULL),
	('PETERNAK-2025-0008', 'Agustinus', 'Dobo', 'agustinus@gmail.com', '085314445725', NULL, NULL),
	('PETERNAK-2025-0009', 'Parno', 'Kujangsari', 'parno@gmail.com', '081312572230', NULL, NULL),
	('PETERNAK-2025-0010', 'Mumu', 'Banjar', 'mumu@gmail.com', '082320301889', NULL, NULL),
	('PETERNAK-2025-0011', 'Semin', 'Mekarharja', 'semin@gmail.com', '082127937279', NULL, NULL),
	('PETERNAK-2025-0012', 'Sohidin', 'Langensari', 'sohidin@gmail.com', '085294979030', NULL, NULL),
	('PETERNAK-2025-0013', 'Salman', 'Rejasari', 'salman@gmail.com', '085223895205', NULL, NULL);

-- Dumping structure for table dkppp.pkb
CREATE TABLE IF NOT EXISTS `pkb` (
  `id_pkb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_kejadian` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_staff` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Belum Ada Tindakan',
  `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_pkb`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.pkb: ~2 rows (approximately)
DELETE FROM `pkb`;
INSERT INTO `pkb` (`id_pkb`, `id_kejadian`, `id_staff`, `status`, `keterangan`, `created_at`, `updated_at`) VALUES
	('PKB-2025-0001', 'KEJADIAN-2025-0001', 'STAFF-2025-0001', 'Belum Ada Tindakan', NULL, '2024-11-30 00:00:00', NULL),
	('PKB-2025-0002', 'KEJADIAN-2025-0001', 'STAFF-2025-0001', 'Belum Ada Tindakan', NULL, '2024-11-30 00:00:00', NULL);

-- Dumping structure for table dkppp.staff
CREATE TABLE IF NOT EXISTS `staff` (
  `id_staff` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_hp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jabatan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_staff`),
  UNIQUE KEY `staff_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.staff: ~2 rows (approximately)
DELETE FROM `staff`;
INSERT INTO `staff` (`id_staff`, `nama`, `email`, `no_hp`, `jabatan`, `alamat`, `created_at`, `updated_at`) VALUES
	('STAFF-2025-0001', 'Charity Wilder 2', 'lajixuxym@mailinator.com', '089896361811', 'dokter', 'Quidem odit sint non', NULL, NULL),
	('STAFF-2025-0002', 'Carl Williamson 2', 'vusenawe@mailinator.com', '088205496491', 'petugas', 'Aut cillum optio bl', NULL, NULL),
	('STAFF-2025-0003', 'Toto', 'toto@gmail.com', '085223963608', 'petugas', 'Banjar', NULL, NULL);

