
CREATE TABLE `cabang` (
  `id_cabang` int(11) NOT NULL AUTO_INCREMENT,
  `nama_cabang` varchar(100) NOT NULL,
  `alamat` text DEFAULT NULL,
  PRIMARY KEY (`id_cabang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `akun` (
  `id_akun` int(11) NOT NULL AUTO_INCREMENT,
  `nama_akun` varchar(50) NOT NULL,
  `saldo_awal` decimal(15,2) DEFAULT 0.00,
  PRIMARY KEY (`id_akun`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `kategori` (
  `id_kategori` int(11) NOT NULL AUTO_INCREMENT,
  `nama_kategori` varchar(100) NOT NULL,
  `tipe` enum('Pengeluaran','Pendapatan','Kecualikan') NOT NULL,
  PRIMARY KEY (`id_kategori`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `transaksi` (
  `id_transaksi` int(11) NOT NULL AUTO_INCREMENT,
  `tanggal` date NOT NULL,
  `keterangan` varchar(255) NOT NULL,
  `jumlah` decimal(15,2) NOT NULL,
  `id_akun` int(11) NOT NULL,
  `tipe` enum('Pengeluaran','Pendapatan','Kecualikan') NOT NULL,
  `id_kategori` int(11) NOT NULL,
  `id_cabang` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id_transaksi`),
  FOREIGN KEY (`id_akun`) REFERENCES `akun`(`id_akun`),
  FOREIGN KEY (`id_kategori`) REFERENCES `kategori`(`id_kategori`),
  FOREIGN KEY (`id_cabang`) REFERENCES `cabang`(`id_cabang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Insert default data
INSERT INTO `akun` (`nama_akun`, `saldo_awal`) VALUES 
('Rekening Bank', 5000000), 
('Tabungan', 25000000), 
('Kartu Kredit', 0), 
('Uang Tunai', 300000);

INSERT INTO `kategori` (`nama_kategori`, `tipe`) VALUES 
('Kos / Cicilan Rumah', 'Pengeluaran'),
('Belanja Bulanan', 'Pengeluaran'),
('Makan di Luar', 'Pengeluaran'),
('Transportasi', 'Pengeluaran'),
('Gaji', 'Pendapatan');

INSERT INTO `cabang` (`nama_cabang`) VALUES ('Pusat');
