Debug Database Structure

Available Tables:

customer
customer_produk
daily_work
daily_work_plans
daily_work_results
draft_penjualan
draft_penjualan_detail
jabatan
kas_bank
kas_bank2
kas_kecil
meeting
meeting_action_items
meeting_agenda
meeting_attachments
meeting_notes
meeting_peserta
pembelian
pembelian_detail
penjualan
penjualan_detail
penjualan_pembelian_link
produk_interest
produk_supplier
rekening
shipment_info
supplier
user
v_draft_penjualan
v_meeting_summary
v_pembelian_summary
v_stock_available

Meeting Table Structure:

Field	Type	Null	Key	Default	Extra
id	id	int(11)	int(11)	NO	NO	PRI	PRI			auto_increment	auto_increment
kode_meeting	kode_meeting	varchar(50)	varchar(50)	NO	NO	UNI	UNI
tanggal	tanggal	date	date	NO	NO	MUL	MUL
waktu_mulai	waktu_mulai	time	time	YES	YES
waktu_selesai	waktu_selesai	time	time	YES	YES
tempat	tempat	varchar(255)	varchar(255)	NO	NO
jenis_meeting	jenis_meeting	enum('internal','external','customer','supplier','planning','review')	enum('internal','external','customer','supplier','planning','review')	YES	YES	MUL	MUL	internal	internal
status	status	enum('planned','ongoing','completed','cancelled')	enum('planned','ongoing','completed','cancelled')	YES	YES	MUL	MUL	planned	planned
pic_meeting	pic_meeting	int(11)	int(11)	YES	YES	MUL	MUL
customer_id	customer_id	int(11)	int(11)	YES	YES	MUL	MUL
supplier_id	supplier_id	int(11)	int(11)	YES	YES	MUL	MUL
created_by	created_by	int(11)	int(11)	NO	NO	MUL	MUL
created_at	created_at	datetime	datetime	NO	NO			current_timestamp()	current_timestamp()
updated_at	updated_at	datetime	datetime	YES	YES					on update current_timestamp()	on update current_timestamp()

Sample Meeting Data:

Array
(
    [id] => 5
    [kode_meeting] => MTG20250004
    [tanggal] => 2025-08-13
    [waktu_mulai] => 
    [waktu_selesai] => 
    [tempat] => Kantor
    [jenis_meeting] => internal
    [status] => planned
    [pic_meeting] => 1
    [customer_id] => 
    [supplier_id] => 
    [created_by] => 1
    [created_at] => 2025-08-13 16:20:59
    [updated_at] => 
)

Meeting Agenda Table Structure:

Field	Type	Null	Key	Default	Extra
id	id	int(11)	int(11)	NO	NO	PRI	PRI			auto_increment	auto_increment
meeting_id	meeting_id	int(11)	int(11)	NO	NO	MUL	MUL
urutan	urutan	int(11)	int(11)	NO	NO	MUL	MUL	1	1
subject	subject	varchar(255)	varchar(255)	NO	NO
detail_subject	detail_subject	text	text	YES	YES
status_agenda	status_agenda	enum('pending','discussed','completed','postponed')	enum('pending','discussed','completed','postponed')	YES	YES			pending	pending
pic_agenda	pic_agenda	int(11)	int(11)	YES	YES	MUL	MUL
deadline	deadline	date	date	YES	YES
prioritas	prioritas	enum('low','medium','high','urgent')	enum('low','medium','high','urgent')	YES	YES			medium	medium