✅ Koneksi Database Berhasil!

Database aktif: dznkaxpk_crm

Daftar Tables:

📦 absensi

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI		auto_increment
user_id	bigint(20) unsigned	NO	MUL
kantor_id	bigint(20) unsigned	NO	MUL
tanggal	date	NO
checkin_time	datetime	YES
checkin_lat	decimal(10,8)	YES
checkin_long	decimal(11,8)	YES
checkin_distance	int(11)	YES
checkout_time	datetime	YES
checkout_lat	decimal(10,8)	YES
checkout_long	decimal(11,8)	YES
checkout_distance	int(11)	YES
foto_checkin	varchar(255)	YES
foto_checkout	varchar(255)	YES
status	enum('hadir','izin','sakit','cuti','alpha')	YES		hadir
keterangan	text	YES
ip_address	varchar(45)	YES
user_agent	text	YES
created_at	datetime	YES		current_timestamp()
updated_at	datetime	YES			on update current_timestamp()

📦 email_template

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
kode_template	varchar(50)	YES	UNI
nama_template	varchar(150)	YES
subject	varchar(255)	YES
body	text	YES
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()

📦 feature_comments

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
feature_id	int(11)	NO
komentar	text	YES
dibuat_oleh	varchar(100)	YES
created_at	timestamp	NO		current_timestamp()

📦 feature_requests

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
judul	varchar(255)	NO
deskripsi	text	YES
kategori	enum('bug','fitur','improvement','catatan')	YES		fitur
prioritas	enum('rendah','normal','tinggi','urgent')	YES		normal
status	enum('open','progress','done','closed')	YES		open
dibuat_oleh	varchar(100)	YES
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	YES			on update current_timestamp()
screenshot	varchar(255)	YES

📦 gamas

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
kode_gamas	varchar(30)	YES	UNI
judul	varchar(255)	NO
deskripsi	text	YES
status	enum('OPEN','TEKNISI BERANGKAT','SAMPAI LOKASI','PERBAIKAN','SELESAI')	YES		OPEN
created_by	bigint(20) unsigned	YES
created_at	datetime	YES		current_timestamp()
closed_at	datetime	YES

📦 gamas_impact

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
gamas_id	int(11)	NO	MUL
node_type	enum('server','olt','odc','odp','pelanggan')	NO
node_id	int(11)	NO
created_at	datetime	YES		current_timestamp()

📦 harga_reseller

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
reseller_id	int(11)	NO	MUL
durasi	varchar(50)	NO
harga	int(11)	NO
created_at	timestamp	NO		current_timestamp()

📦 job_queue

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
type	varchar(50)	NO
payload	text	NO
gateway_id	int(11)	YES
error_message	text	YES
status	enum('pending','processing','done','failed','cancelled','skipped')	YES		pending
scheduled_at	datetime	YES
attempts	int(11)	YES		0
last_attempt_at	datetime	YES
created_at	timestamp	NO		current_timestamp()
processed_at	timestamp	YES

📦 kantor

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI		auto_increment
nama_kantor	varchar(100)	NO
alamat	text	YES
latitude	decimal(10,8)	NO
longitude	decimal(11,8)	NO
radius_meter	int(11)	NO		100
status	enum('aktif','nonaktif')	YES		aktif
created_at	datetime	YES		current_timestamp()
updated_at	datetime	YES			on update current_timestamp()

📦 komisi_sales

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
sales_id	int(11)	NO	MUL
pelanggan_id	int(11)	NO	MUL
tagihan_id	int(11)	NO	UNI
tipe	enum('PSB','RECURRING')	NO
jumlah_tagihan	int(11)	NO
jumlah_komisi	decimal(12,2)	NO
status	enum('pending','dibayar')	YES		pending
periode	varchar(20)	YES
created_at	timestamp	NO		current_timestamp()

📦 network_map

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
node_type	varchar(50)	YES
ref_id	int(11)	YES
pos_x	int(11)	YES
pos_y	int(11)	YES
created_at	timestamp	NO		current_timestamp()

📦 notifikasi

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	YES
role_target	varchar(50)	YES
judul	varchar(255)	NO
pesan	mediumtext	YES
link	varchar(255)	YES
status	enum('unread','read')	YES		unread
created_at	timestamp	NO		current_timestamp()

📦 odc

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
pon_id	int(11)	NO	MUL
nama_odc	varchar(100)	NO
lokasi	varchar(255)	YES
latitude	decimal(10,8)	YES
longitude	decimal(11,8)	YES
splitter	varchar(20)	YES
kapasitas	int(11)	YES		8
catatan	text	YES
created_at	timestamp	NO		current_timestamp()

📦 odp

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
odc_id	int(11)	NO	MUL
nama_odp	varchar(100)	NO
lokasi	varchar(255)	YES
latitude	decimal(10,8)	YES
longitude	decimal(11,8)	YES
kapasitas	int(11)	YES		8
catatan	text	YES
created_at	timestamp	NO		current_timestamp()

📦 odp_port

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
odp_id	int(11)	NO	MUL
port_number	int(11)	NO
status	enum('kosong','terpakai','rusak')	YES		kosong
catatan	text	YES
created_at	timestamp	NO		current_timestamp()

📦 olt

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
server_id	int(11)	NO	MUL
nama_olt	varchar(100)	NO
ip_address	varchar(50)	NO
port	int(11)	YES		23
username	varchar(100)	NO
password	varchar(100)	NO
vendor	enum('huawei','zte','fiberhome','hioso','other')	YES		other
lokasi	varchar(255)	YES
latitude	decimal(10,8)	YES
longitude	decimal(11,8)	YES
catatan	text	YES
created_at	timestamp	NO		current_timestamp()

📦 paket

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
nama_paket	varchar(100)	NO
jenis_paket	enum('Reguler','Voucher')	NO
kecepatan	varchar(50)	YES
harga	int(11)	NO
masa_aktif_hari	int(11)	YES		30
deskripsi	text	YES
status	enum('active','inactive')	YES		active
created_at	timestamp	NO		current_timestamp()

📦 pelanggan

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
kode_pelanggan	varchar(30)	YES	UNI
nama	varchar(150)	NO
email	varchar(150)	YES
no_hp	varchar(20)	YES
alamat	text	YES
sharelok	text	YES
latitude	decimal(10,7)	YES	MUL
longitude	decimal(10,7)	YES
foto_rumah	varchar(255)	YES
server_id	int(11)	YES	MUL
router_id	int(11)	YES	MUL
odp_port_id	int(11)	YES	MUL
paket_id	int(11)	YES	MUL
sales_id	int(11)	YES	MUL
ip_static	varchar(50)	YES	MUL
mac_address	varchar(20)	YES
status_berlangganan	enum('register','active','masa_tenggang','isolir','dismantle','terminate')	YES		active
status_billing	enum('yes','no')	YES		yes
tanggal_pasang	date	YES
masa_aktif_sampai	datetime	YES
reminder_h3_sent	tinyint(1)	NO		0
isolir_notified	tinyint(1)	NO		0
created_at	timestamp	NO		current_timestamp()

📦 pelanggan_kontak

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
pelanggan_id	int(11)	NO	MUL
nama_kontak	varchar(150)	NO
no_hp	varchar(20)	NO	UNI
is_primary	tinyint(1)	NO		0
dibuat_pada	timestamp	NO		current_timestamp()

📦 pembayaran

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
tagihan_id	int(11)	NO	MUL
metode	varchar(50)	YES
jumlah	int(11)	NO
tanggal_bayar	datetime	YES
status	varchar(50)	YES
created_at	timestamp	NO		current_timestamp()

📦 permissions

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
nama_permission	varchar(100)	NO	UNI
kategori	varchar(50)	YES
created_at	timestamp	NO		current_timestamp()

📦 pon

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
olt_id	int(11)	NO	MUL
pon_port	varchar(20)	NO
nama_sfp	varchar(100)	YES
serial_number_sfp	varchar(100)	YES
tx_power	decimal(5,2)	YES
rx_power	decimal(5,2)	YES
catatan	text	YES
created_at	timestamp	NO		current_timestamp()

📦 reseller

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
kode_reseller	varchar(30)	YES	UNI
nama_reseller	varchar(150)	NO
no_hp	varchar(20)	YES
alamat	text	YES
saldo	int(11)	YES		0
status	enum('active','suspend')	YES		active
created_at	timestamp	NO		current_timestamp()
password	varchar(255)	YES
remember_token	varchar(100)	YES
reset_token	varchar(100)	YES
reset_expired	datetime	YES
harga_default	int(11)	YES		0

📦 role_permissions

Field	Type	Null	Key	Extra
id	int(11)	NO	PRI	auto_increment
role_id	int(11)	NO	MUL
permission_id	int(11)	NO	MUL

📦 roles

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
nama_role	varchar(50)	NO	UNI
created_at	timestamp	NO		current_timestamp()

📦 router

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
kode_router	varchar(50)	YES	UNI
merk	varchar(100)	YES
tipe	varchar(100)	YES
mac_address	varchar(50)	YES
status	enum('stok_gudang','pindah_gudang','di_teknisi','terpasang','dicabut','rusak')	YES		stok_gudang
gudang	varchar(100)	YES
teknisi	varchar(100)	YES
created_at	timestamp	NO		current_timestamp()

📦 router_log

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
router_id	int(11)	NO	MUL
dari_status	varchar(50)	YES
ke_status	varchar(50)	YES
keterangan	text	YES
tanggal	datetime	YES		current_timestamp()

📦 saldo_reseller

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
reseller_id	int(11)	NO	MUL
tipe	enum('topup','beli_voucher','refund')	NO
jumlah	int(11)	NO
saldo_sebelum	int(11)	YES
saldo_sesudah	int(11)	YES
keterangan	text	YES
created_at	datetime	YES		current_timestamp()

📦 sales

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
kode_sales	varchar(30)	YES	UNI
nama	varchar(150)	NO
no_hp	varchar(20)	YES
email	varchar(150)	YES
alamat	text	YES
komisi_psb	decimal(12,2)	YES		0.00
komisi_recurring_percent	decimal(5,2)	YES		0.00
status	enum('aktif','nonaktif')	YES		aktif
created_at	timestamp	NO		current_timestamp()

📦 server

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
nama_server	varchar(100)	NO
ip_primary	varchar(50)	NO
port_primary	int(11)	YES		8728
ip_backup	varchar(50)	YES
port_backup	int(11)	YES		8728
username	varchar(100)	NO
password	varchar(100)	NO
ros_version	enum('ros6','ros7')	NO
lokasi	varchar(150)	YES
status	enum('active','inactive')	YES		active
created_at	timestamp	NO		current_timestamp()

📦 status_koneksi

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
kode_pelanggan	varchar(50)	NO	UNI
status	enum('online','offline')	NO	MUL	offline
ip_address	varchar(45)	YES
mac_address	varchar(20)	YES
last_seen	datetime	YES
server_id	int(11)	YES	MUL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

📦 tagihan

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
pelanggan_id	int(11)	NO	MUL
tanggal_tagih	date	YES
jumlah	int(11)	NO
status	enum('unpaid','paid','cancelled')	YES		unpaid
jatuh_tempo	date	YES
reference_duitku	varchar(100)	YES
created_at	timestamp	NO		current_timestamp()

📦 telegram_bot

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
nama_bot	varchar(100)	NO
bot_token	varchar(255)	NO
username_bot	varchar(100)	YES
keterangan	text	YES
status	enum('aktif','nonaktif')	YES		aktif
dibuat_pada	timestamp	NO		current_timestamp()

📦 telegram_group

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
nama_group	varchar(100)	NO
chat_id	varchar(50)	NO
fungsi	varchar(50)	NO
status	enum('aktif','nonaktif')	YES		aktif
dibuat_pada	timestamp	NO		current_timestamp()

📦 telegram_template

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
kode	varchar(50)	YES
nama_template	varchar(100)	YES
isi_template	mediumtext	YES
created_at	timestamp	NO		current_timestamp()

📦 ticket_log_photos

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
ticket_log_id	int(11)	NO	MUL
file_path	varchar(255)	NO
uploaded_at	datetime	YES		current_timestamp()

📦 ticket_logs

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
ticket_id	int(11)	NO	MUL
user_id	int(11)	NO
action	varchar(255)	NO
keterangan	text	YES
created_at	datetime	YES		current_timestamp()

📦 ticket_teknisi

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
ticket_id	int(11)	NO	MUL
teknisi_id	int(11)	NO	MUL
assigned_by	int(11)	NO
status	enum('DITUGASKAN','DITERIMA','DALAM PERJALANAN','SEDANG DIKERJAKAN','SELESAI')	YES		DITUGASKAN
assigned_at	datetime	YES		current_timestamp()

📦 tickets

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
kode_tiket	varchar(30)	NO	UNI
pelanggan_id	int(11)	YES	MUL
gamas_id	int(11)	YES
dibuat_oleh	int(11)	NO	MUL
jenis_tiket	enum('TEKNIS','NON-TEKNIS')	NO
kategori	enum('GANGGUAN_PELANGGAN','GANGGUAN_MASSAL','GANGGUAN_BACKBONE','KUALITAS_LAYANAN','MAINTENANCE_JARINGAN','PASANG_BARU','UPGRADE_PAKET','RELOKASI','DISMANTLE','BILLING','SURVEY','MIGRASI','PERUBAHAN_DATA')	NO	MUL
prioritas	enum('rendah','sedang','tinggi','urgent')	YES		sedang
judul	varchar(255)	NO
deskripsi	text	NO
status	enum('TIKET DIBUAT','DITUGASKAN','TEKNISI BERANGKAT','SAMPAI LOKASI','INVESTIGASI','PERBAIKAN','MONITORING','PENDING','MENUNGGU PELANGGAN','MENUNGGU MATERIAL','SELESAI (TEKNISI)','SELESAI & DIKONFIRMASI','DIBATALKAN')	YES	MUL	TIKET DIBUAT
last_update	datetime	YES
sla_deadline	datetime	YES
created_at	datetime	YES		current_timestamp()
updated_at	datetime	YES		current_timestamp()	on update current_timestamp()
closed_at	datetime	YES

📦 transaksi

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
merchant_order_id	varchar(100)	NO	MUL
kode_pelanggan	varchar(30)	NO	MUL
nama	varchar(150)	NO
no_hp	varchar(20)	NO
paket_id	int(11)	YES
paket	varchar(100)	NO
durasi	int(11)	NO
amount	int(11)	NO
payment_url	text	YES
status	varchar(20)	YES	MUL	PENDING
masa_aktif_lama	datetime	YES
masa_aktif_baru	datetime	YES
metode_bayar	varchar(50)	YES
referensi_pembayaran	varchar(100)	YES
tanggal_bayar	datetime	YES
created_at	timestamp	NO		current_timestamp()

📦 transaksi_reseller

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
reseller_id	int(11)	NO
merchant_order_id	varchar(100)	YES
amount	int(11)	NO
metode_bayar	varchar(50)	YES
payment_url	text	YES
status	enum('PENDING','PAID','FAILED')	YES		PENDING
created_at	timestamp	NO		current_timestamp()
paid_at	datetime	YES

📦 transaksi_voucher

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
merchant_order_id	varchar(100)	YES	MUL
voucher_id	int(11)	YES	MUL
kode_voucher	varchar(100)	YES
nomor_hp	varchar(20)	NO	MUL
durasi	varchar(50)	YES
harga	int(11)	NO
metode_pembayaran	varchar(50)	YES
status_pembayaran	varchar(50)	YES		paid
tanggal_bayar	datetime	YES
tanggal_transaksi	datetime	YES		current_timestamp()

📦 user_devices

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO
fcm_token	text	NO	UNI
created_at	timestamp	NO		current_timestamp()

📦 users

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI		auto_increment
nama	varchar(100)	NO
email	varchar(150)	NO	UNI
nomor_hp	varchar(20)	YES
telegram_chat_id	varchar(50)	YES
password	varchar(255)	NO
role	varchar(50)	NO		operator
status	enum('aktif','nonaktif')	NO		aktif
last_login	datetime	YES
created_at	datetime	NO		current_timestamp()
updated_at	datetime	YES			on update current_timestamp()

📦 vouchers

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
kode_voucher	varchar(100)	NO	UNI
paket	varchar(50)	NO	MUL
durasi	varchar(50)	NO
harga	int(11)	NO
status	enum('available','assigned','used')	YES	MUL	available
nomor_hp	varchar(20)	YES	MUL
reseller_id	int(11)	YES	MUL
tanggal_buat	datetime	YES		current_timestamp()
tanggal_assign	datetime	YES
tanggal_used	datetime	YES

📦 wa_gateway

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
provider	varchar(50)	NO
name	varchar(100)	NO
token	text	NO
secret_key	text	YES
endpoint	text	NO
priority	int(11)	NO		1
is_active	tinyint(1)	NO		1
status	varchar(20)	NO		offline
fail_count	int(11)	NO		0
last_check	datetime	YES
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

📦 wa_templates

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
nama_template	varchar(100)	YES
kode_template	varchar(100)	YES	UNI
isi_template	text	YES
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()