-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 25, 2026 at 12:16 PM
-- Server version: 10.6.22-MariaDB
-- PHP Version: 8.3.23

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: `persadal_db_smartlab2_live`
--

-- --------------------------------------------------------

--
-- Table structure for table `m_customer`
--

CREATE TABLE `m_customer` (
  `id` int(11) NOT NULL,
  `m_parent_perusahaan` int(11) DEFAULT 0,
  `m_jenis_perusahaan` int(11) DEFAULT 0,
  `m_jenis_industri_level_1` int(11) DEFAULT 0,
  `m_jenis_industri_level_2` int(11) DEFAULT 0,
  `m_skala_bisnis_unit` int(11) DEFAULT 0,
  `m_proper` int(11) DEFAULT NULL,
  `m_grading` int(11) DEFAULT 0,
  `m_grading_level` int(1) DEFAULT 0,
  `m_grading_handle_by` int(1) DEFAULT 0,
  `is_cust_prio` int(1) DEFAULT 0,
  `kode_prospect` varchar(50) DEFAULT NULL,
  `nomor_suspect` varchar(50) DEFAULT NULL,
  `nomor` int(11) DEFAULT 0,
  `kode_nomor` varchar(50) DEFAULT NULL,
  `m_cabang` int(11) DEFAULT 0,
  `m_klasifikasi_customer` int(11) DEFAULT 0,
  `m_klasifikasi_customer_industri` int(11) DEFAULT 0,
  `m_kategori_industri` int(11) DEFAULT 0,
  `nama` varchar(150) NOT NULL,
  `alamat` varchar(250) DEFAULT NULL,
  `m_provinsi` int(11) DEFAULT 0,
  `m_kabupaten` int(11) DEFAULT 0,
  `no_telp` varchar(25) DEFAULT NULL,
  `m_gmp_qsm` int(1) DEFAULT 0,
  `cp_nama` varchar(100) DEFAULT NULL,
  `cp_telp` varchar(25) DEFAULT NULL,
  `cp_email` varchar(50) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `user_email` varchar(255) DEFAULT NULL,
  `password` varchar(500) DEFAULT NULL,
  `alamat_kirim_dokumen` mediumtext DEFAULT NULL,
  `id_marketing` int(11) DEFAULT 0,
  `m_kategori_sales` int(1) DEFAULT 1,
  `sl_idpelanggan` bigint(20) DEFAULT NULL,
  `nama_sesuai_npwp` varchar(150) DEFAULT NULL,
  `npwp` varchar(50) DEFAULT NULL,
  `alamat_sesuai_npwp` varchar(250) DEFAULT NULL,
  `tax_npwp` varchar(50) DEFAULT NULL,
  `tax_nama` varchar(100) DEFAULT NULL,
  `tax_jalan` varchar(150) DEFAULT NULL,
  `tax_blok` varchar(50) DEFAULT NULL,
  `tax_nomor` varchar(10) DEFAULT NULL,
  `tax_rt` varchar(10) DEFAULT NULL,
  `tax_rw` varchar(10) DEFAULT NULL,
  `tax_kecamatan` varchar(100) DEFAULT NULL,
  `tax_kelurahan` varchar(100) DEFAULT NULL,
  `tax_kabupaten` varchar(100) DEFAULT NULL,
  `tax_propinsi` varchar(30) DEFAULT NULL,
  `tax_kode_pos` varchar(10) DEFAULT NULL,
  `tax_nomor_telepon` varchar(30) DEFAULT NULL,
  `parent_customer` int(11) DEFAULT 0,
  `cp_nama_keuangan` varchar(50) DEFAULT NULL,
  `cp_telp_keuangan` varchar(50) DEFAULT NULL,
  `cp_email_keuangan` varchar(50) DEFAULT NULL,
  `coupon_disc` int(11) DEFAULT 0,
  `kontak_broadcast` varchar(255) DEFAULT NULL,
  `m_periode_penawaran` int(11) DEFAULT 0,
  `is_v2` int(1) DEFAULT 0,
  `is_bypass_elhu` tinyint(1) DEFAULT 0,
  `created_user` int(11) DEFAULT 0,
  `created_date` timestamp NULL DEFAULT NULL,
  `updated_user` int(11) DEFAULT 0,
  `updated_date` timestamp NULL DEFAULT NULL,
  `is_delete` int(11) DEFAULT 0,
  `deleted_user` int(11) DEFAULT 0,
  `deleted_date` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `m_customer`
--
ALTER TABLE `m_customer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `created_user` (`created_user`),
  ADD KEY `updated_user` (`updated_user`),
  ADD KEY `deleted_user` (`deleted_user`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `m_customer`
--
ALTER TABLE `m_customer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
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 */;
