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



-- Dumping database structure for dkppp
CREATE DATABASE IF NOT EXISTS `dkppp` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `dkppp`;

-- 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

-- Dumping structure for table dkppp.betina
CREATE TABLE IF NOT EXISTS `betina` (
  `ear_tag` 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,
  `usia` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jumlah_ib` int DEFAULT NULL,
  `riwayat_penyakit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` 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 (`ear_tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.betina: ~0 rows (approximately)
DELETE FROM `betina`;
INSERT INTO `betina` (`ear_tag`, `id_peternak`, `nama`, `jenis_sapi`, `usia`, `foto`, `jumlah_ib`, `riwayat_penyakit`, `status`, `tanggal_lahir`, `created_at`, `updated_at`) VALUES
	('Autem velit nihil il', 'PETERNAK-2025-0001', 'Necessitatibus et il', 'Inventore hic evenie', '44', 'G:\\RAW\\tableau\\public\\/gambar_sapi/betina\\1758044689_460706376_499759942910044_7246121336483009296_n.jpg', 65, 'Unde exercitationem', 'TIDAK BOLEH IB', '1980-12-20', NULL, NULL),
	('Deserunt tenetur aut', 'PETERNAK-2025-0001', 'Ut reiciendis ut ven', 'Explicabo Velit ut', '16', '/storage/betina/1758044060_460706376_499759942910044_7246121336483009296_n.jpg', 64, 'Modi excepturi et qu', 'TIDAK BOLEH IB', '2009-05-24', NULL, NULL),
	('Est irure consequatu', 'PETERNAK-2025-0001', 'A sunt omnis quidem', 'Facere sit doloremq', '37', 'gambar_sapi/betina1758044902_460706376_499759942910044_7246121336483009296_n.jpg', 20, 'In aute saepe cum fa', 'BOLEH IB', '1988-03-13', NULL, NULL),
	('Nobis et deserunt si', 'PETERNAK-2025-0002', 'Iure non sed ratione', 'Aut et et saepe aut', '20', '/storage/G:\\RAW\\tableau\\public\\betina\\1758044528_460706376_499759942910044_7246121336483009296_n.jpg', 64, 'Officiis consequatur', 'TIDAK BOLEH IB', '2005-03-14', NULL, NULL),
	('Nobis possimus offi', 'PETERNAK-2025-0002', 'Quidem et incidunt', 'A ipsum dolore aut', '19', '/storage/G:\\RAW\\tableau\\public\\/gambar_sapi/betina\\1758044617_460706376_499759942910044_7246121336483009296_n.jpg', 10, 'Alias et quia quis q', 'TIDAK BOLEH IB', '2005-12-04', NULL, NULL),
	('Qui in est amet lau', 'PETERNAK-2025-0002', 'Facere voluptate per', 'Perspiciatis recusa', '32', '/storage/betina/1758042999_460706376_499759942910044_7246121336483009296_n.jpg', 55, 'Est sunt sit impedi', 'TIDAK BOLEH IB', '1993-08-22', NULL, NULL),
	('Qui sit saepe amet', 'PETERNAK-2025-0002', 'Pariatur Minus exce', 'Eiusmod voluptas et', '23', '/storage/betina/1758043481_460706376_499759942910044_7246121336483009296_n.jpg', 76, 'Qui dolor et ullam s', 'TIDAK BOLEH IB', '2001-12-11', NULL, NULL),
	('Velit voluptates ali', 'PETERNAK-2025-0001', 'Inventore laudantium', 'Velit illo Nam dolor', '10', 'gambar_sapi/betina/1758045015_460706376_499759942910044_7246121336483009296_n.jpg', 36, 'Dolor qui facilis ni', 'BOLEH IB', '2014-11-03', 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_peternak` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_dokumen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_staff` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `betina` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pejantan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hasil` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `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: ~0 rows (approximately)
DELETE FROM `ib`;

-- 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_peternak` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Belum Ada Tindakan',
  `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_peternak`, `status`, `created_at`, `updated_at`) VALUES
	('KEJADIAN-2025-0001', 'Nobis et deserunt si', 'PETERNAK-2025-0002', 'Belum Ada Tindakan', '2025-09-17 00:00:00', NULL);

-- Dumping structure for table dkppp.kelahiran
CREATE TABLE IF NOT EXISTS `kelahiran` (
  `id_kelahiran` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis_kelamin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_pkb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_staff` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keunggulan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_kelahiran`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

-- 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=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.migrations: ~0 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_kelahiran', 1),
	(13, '2025_06_05_163802_create_log', 1),
	(14, '2025_06_07_091143_create_action_logs_table', 1),
	(15, '2025_08_11_042355_create_ticket', 1);

-- Dumping structure for table dkppp.pejantan
CREATE TABLE IF NOT EXISTS `pejantan` (
  `id_pejantan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_pembuatan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis_straw` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `persentase` int DEFAULT NULL,
  `asal_straw` varchar(50) COLLATE utf8mb4_unicode_ci 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_pembuatan`, `jenis_straw`, `persentase`, `asal_straw`, `created_at`, `updated_at`) VALUES
	('Voluptate tenetur oc', 'Nobis eaque est quod', 'Omnis aut est cupid', 32, 'Perferendis at esse', '2025-09-17 00:19:12', NULL);

-- 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,
  `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: ~0 rows (approximately)
DELETE FROM `peternak`;
INSERT INTO `peternak` (`id_peternak`, `nama`, `alamat`, `no_hp`, `created_at`, `updated_at`) VALUES
	('PETERNAK-2025-0001', 'Gail Whitehead', 'Vel sed harum sequi', '084230789138', NULL, NULL),
	('PETERNAK-2025-0002', 'Hasad Faulkner', 'Sapiente irure nemo', '080498434260', 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_ib` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_dokumen` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_staff` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hasil` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `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: ~0 rows (approximately)
DELETE FROM `pkb`;

-- 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,
  `no_hp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surat_izin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `asal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_staff`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dkppp.staff: ~0 rows (approximately)
DELETE FROM `staff`;
INSERT INTO `staff` (`id_staff`, `nama`, `no_hp`, `surat_izin`, `asal`, `created_at`, `updated_at`) VALUES
	('STAFF-2025-0001', 'Elizabeth Mccullough', '080986964853', 'Facilis ea consectet', 'In tenetur duis fugi', NULL, NULL);

-- Dumping structure for table dkppp.ticket
CREATE TABLE IF NOT EXISTS `ticket` (
  `id_ticket` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_user` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis_laporan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_ticket`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

