SQLize | PHPize | SQLtest

-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: db:3306 -- Generation Time: Jun 19, 2025 at 12:02 PM -- Server version: 8.0.40 -- PHP Version: 8.2.24 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `db_lahan_makam` -- -- -------------------------------------------------------- -- -- Table structure for table `Table_Agent` -- CREATE TABLE `Table_Agent` ( `No_Agent` varchar(200) NOT NULL, `Nama_Agent` varchar(200) DEFAULT NULL, `Jabatan` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `Table_Agent` -- INSERT INTO `Table_Agent` (`No_Agent`, `Nama_Agent`, `Jabatan`) VALUES ('LMP001', 'Bryan', 'Service Advisor'), ('LMP002', 'Renny', 'Service Advisor'), ('LMP003', 'Bambang', 'District Service Director'); -- -------------------------------------------------------- -- -- Table structure for table `Table_Customer` -- CREATE TABLE `Table_Customer` ( `ID_Customer` varchar(200) NOT NULL, `Nama_Customer` varchar(200) DEFAULT NULL, `Alamat` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `Table_Customer` -- INSERT INTO `Table_Customer` (`ID_Customer`, `Nama_Customer`, `Alamat`) VALUES ('CU001', 'Sugiana', 'Jl. Merpati 12 No 3. Jakarta Barat'), ('CU002', 'Robin', 'Jl. Angke Jaya No. 22. Jakarta Barat'), ('CU003', 'Keshia', 'Jl. Mawar No. 8. Jakarta Selatan'); -- -------------------------------------------------------- -- -- Table structure for table `Table_DetailPenjualan` -- CREATE TABLE `Table_DetailPenjualan` ( `ID_Transaksi` varchar(200) NOT NULL, `ID_Customer` varchar(200) DEFAULT NULL, `Tanggal_Transaksi` date DEFAULT NULL, `Kode_LahanMakam` varchar(200) DEFAULT NULL, `No_Invoice` varchar(200) DEFAULT NULL, `No_Agent` varchar(200) DEFAULT NULL, `Harga_Beli` decimal(15,2) DEFAULT NULL, `Jumlah` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `Table_DetailPenjualan` -- INSERT INTO `Table_DetailPenjualan` (`ID_Transaksi`, `ID_Customer`, `Tanggal_Transaksi`, `Kode_LahanMakam`, `No_Invoice`, `No_Agent`, `Harga_Beli`, `Jumlah`) VALUES ('IDT001', 'CU001', '2024-06-12', 'A001', 'NIV001', 'LMP001', 127392000.00, 1), ('IDT002', 'CU002', '2025-03-20', 'AB001', 'NIV002', 'LMP001', 254784000.00, 1), ('IDT003', 'CU003', '2025-05-15', 'ABC001', 'NIV003', 'LMP003', 977400000.00, 1); -- -------------------------------------------------------- -- -- Table structure for table `Table_Komisi_Campaign` -- CREATE TABLE `Table_Komisi_Campaign` ( `ID_Pendapatan` varchar(200) NOT NULL, `No_Agent` varchar(200) DEFAULT NULL, `Lot` int DEFAULT NULL, `Jumlah_Komisi` decimal(15,2) DEFAULT NULL, `Bonus_Trip` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `Table_Komisi_Campaign` -- INSERT INTO `Table_Komisi_Campaign` (`ID_Pendapatan`, `No_Agent`, `Lot`, `Jumlah_Komisi`, `Bonus_Trip`) VALUES ('IDP001', 'LMP001', 1, 2000000.00, 'Hainan, China'), ('IDP002', 'LMP002', 1, 3000000.00, 'Chengdu, China'), ('IDP003', 'LMP003', 1, 4000000.00, 'Chongqing, China'); -- -------------------------------------------------------- -- -- Table structure for table `Table_LahanMakam` -- CREATE TABLE `Table_LahanMakam` ( `Kode_LahanMakam` varchar(200) NOT NULL, `Tipe_Tanah` varchar(200) DEFAULT NULL, `Zona` varchar(200) DEFAULT NULL, `Ukuran` varchar(200) DEFAULT NULL, `Peruntukkan` int DEFAULT NULL, `Harga` decimal(15,2) DEFAULT NULL, `Status_Ketersediaan` varchar(200) DEFAULT NULL, `Jenis_Pemesanan` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `Table_LahanMakam` -- INSERT INTO `Table_LahanMakam` (`Kode_LahanMakam`, `Tipe_Tanah`, `Zona`, `Ukuran`, `Peruntukkan`, `Harga`, `Status_Ketersediaan`, `Jenis_Pemesanan`) VALUES ('A001', 'Single', 'A', '2 m x 6 m', 1, 127392000.00, 'Tidak', 'Pre Need'), ('A002', 'Single', 'A', '2 m x 6 m', 1, 127392000.00, 'Ada', 'Belum Ada'), ('AB001', 'Double', 'A', '4 m x 6 m', 2, 254784000.00, 'Tidak', 'As Need'), ('AB002', 'Double', 'A', '4 m x 6 m', 2, 254784000.00, 'Ada', 'Belum Ada'), ('ABC001', 'Family', 'A', '8 m x 12 m', 8, 977400000.00, 'Tidak', 'Pre Need'), ('ABC002', 'Family', 'A', '8 m x 12 m', 8, 977400000.00, 'Ada', 'Belum Ada'); -- -------------------------------------------------------- -- -- Table structure for table `Table_Penjualan` -- CREATE TABLE `Table_Penjualan` ( `No_Invoice` varchar(200) NOT NULL, `ID_Pendapatan` varchar(200) DEFAULT NULL, `Kode_LahanMakam` varchar(200) DEFAULT NULL, `Tipe_Tanah` varchar(200) DEFAULT NULL, `Harga_Beli` decimal(15,2) DEFAULT NULL, `Jumlah` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `Table_Penjualan` -- INSERT INTO `Table_Penjualan` (`No_Invoice`, `ID_Pendapatan`, `Kode_LahanMakam`, `Tipe_Tanah`, `Harga_Beli`, `Jumlah`) VALUES ('NIV001', 'IDP001', 'A001', 'Single', 127392000.00, 1), ('NIV002', 'IDP002', 'ABC001', 'Double', 254784000.00, 1), ('NIV003', 'IDP003', 'ABC001', 'Family', 977400000.00, 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `Table_Agent` -- ALTER TABLE `Table_Agent` ADD PRIMARY KEY (`No_Agent`); -- -- Indexes for table `Table_Customer` -- ALTER TABLE `Table_Customer` ADD PRIMARY KEY (`ID_Customer`); -- -- Indexes for table `Table_DetailPenjualan` -- ALTER TABLE `Table_DetailPenjualan` ADD PRIMARY KEY (`ID_Transaksi`), ADD KEY `ID_Customer` (`ID_Customer`), ADD KEY `Kode_LahanMakam` (`Kode_LahanMakam`), ADD KEY `No_Invoice` (`No_Invoice`), ADD KEY `No_Agent` (`No_Agent`); -- -- Indexes for table `Table_Komisi_Campaign` -- ALTER TABLE `Table_Komisi_Campaign` ADD PRIMARY KEY (`ID_Pendapatan`), ADD KEY `No_Agent` (`No_Agent`); -- -- Indexes for table `Table_LahanMakam` -- ALTER TABLE `Table_LahanMakam` ADD PRIMARY KEY (`Kode_LahanMakam`); -- -- Indexes for table `Table_Penjualan` -- ALTER TABLE `Table_Penjualan` ADD PRIMARY KEY (`No_Invoice`), ADD KEY `ID_Pendapatan` (`ID_Pendapatan`), ADD KEY `Kode_LahanMakam` (`Kode_LahanMakam`); -- -- Constraints for dumped tables -- -- -- Constraints for table `Table_DetailPenjualan` -- ALTER TABLE `Table_DetailPenjualan` ADD CONSTRAINT `Table_DetailPenjualan_ibfk_1` FOREIGN KEY (`ID_Customer`) REFERENCES `Table_Customer` (`ID_Customer`), ADD CONSTRAINT `Table_DetailPenjualan_ibfk_2` FOREIGN KEY (`Kode_LahanMakam`) REFERENCES `Table_LahanMakam` (`Kode_LahanMakam`), ADD CONSTRAINT `Table_DetailPenjualan_ibfk_3` FOREIGN KEY (`No_Invoice`) REFERENCES `Table_Penjualan` (`No_Invoice`), ADD CONSTRAINT `Table_DetailPenjualan_ibfk_4` FOREIGN KEY (`No_Agent`) REFERENCES `Table_Agent` (`No_Agent`); -- -- Constraints for table `Table_Komisi_Campaign` -- ALTER TABLE `Table_Komisi_Campaign` ADD CONSTRAINT `Table_Komisi_Campaign_ibfk_1` FOREIGN KEY (`No_Agent`) REFERENCES `Table_Agent` (`No_Agent`); -- -- Constraints for table `Table_Penjualan` -- ALTER TABLE `Table_Penjualan` ADD CONSTRAINT `Table_Penjualan_ibfk_1` FOREIGN KEY (`ID_Pendapatan`) REFERENCES `Table_Komisi_Campaign` (`ID_Pendapatan`), ADD CONSTRAINT `Table_Penjualan_ibfk_2` FOREIGN KEY (`Kode_LahanMakam`) REFERENCES `Table_LahanMakam` (`Kode_LahanMakam`); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;