Assalam,.. ini struktur tabelnya mas
CREATE TABLE `data_penjualan` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`no_rm` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`no_nota` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`tgl_penjualan`
date DEFAULT NULL, `nama` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`kode_obat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`kategori` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`satuan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`h_jual` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`jumlah` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`total` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`qty` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`aturan_pakai` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`no_batch` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`tgl_expired` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`jenis_jual` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`unit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `data_pembelian` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`no_faktur` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`nama` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`kode_obat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`kategori` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`satuan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`tgl_expired` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`no_batch` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`id_distributor` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`h_beli` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`qty` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`t_harga` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`tgl_pembelian`
date NOT
NULL,) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `data_obat` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`kode_obat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`barcode` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`nama` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`kategori` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`golongan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`satuan1` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`satuan2` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`isi1` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`isi2` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`harga_jual` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`harga_beli` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`tgl_expired` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`brand` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`qty` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`qty_min` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`kelompok` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`jenis` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;