* id user_id tanggal jam_masuk jam_pulang status keterangan created_at updated_at foto_selfie

* id kode_akun nama_akun jenis kategori posisi_normal is_active is_header parent_id created_at updated_at

* id invoice_number agent_id purchase_date due_date grand_total returned_total paid_total status notes created_at updated_at

* id agent_purchase_id product_id qty unit_price subtotal created_at updated_at

* id agent_purchase_id cash_account_id payment_date amount method notes created_at updated_at

* id agent_purchase_id invoice_number return_date total_return notes created_at updated_at

* id agent_purchase_return_id agent_purchase_item_id qty unit_price subtotal created_at updated_at

* key value expiration

* key owner expiration

* id name type opening_balance is_active created_at updated_at

* id trx_date cash_account_id type category description amount source_type source_id created_at updated_at

* id nama_kategori deskripsi created_at updated_at

* id uuid connection queue payload exception failed_at

* id queue payload attempts reserved_at available_at created_at

* id name total_jobs pending_jobs failed_jobs failed_job_ids options cancelled_at created_at finished_at

* id journal_entry_id account_id debet kredit keterangan created_at updated_at

* id nomor_jurnal tanggal tipe referensi keterangan total_debet total_kredit is_posted posted_at created_by created_at updated_at

* id migration batch

* id expense_date cash_account_id category description amount notes created_at updated_at

* email token created_at

* id barcode category_id nama_produk satuan stok harga_modal harga_jual created_at updated_at

* id purchase_number supplier_id total_harga paid_amount status_pembayaran due_date kasir created_at updated_at

* id purchase_id product_id qty harga_beli subtotal created_at

* id purchase_id payment_date amount metode_bayar keterangan created_by created_at updated_at

* id role_name menu_name can_access created_at updated_at

* id invoice_number customer_id total_bayar total_untung created_at updated_at total_untungan kasir metode_bayar uang_diterima journal_entry_id

* id sale_id product_id qty subtotal total_untung untung_satuan created_at updated_at

* id sale_id invoice_number customer_id total_retur alasan catatan return_date created_at updated_at

* id sale_return_id product_id qty harga subtotal created_at updated_at

* id user_id ip_address user_agent payload last_activity

* id nama_toko alamat_toko logo_toko backup_path telepon footer_struk created_at updated_at

* id nama_supplier kontak_person telepon alamat deskripsi created_at updated_at

* id invoice_number total_amount paid_amount change_amount created_at updated_at

* id transaction_id product_id quantity unit_price subtotal created_at updated_at

* id name email phone address bank_account_number email_verified_at password role status level_id remember_token created_at updated_at

* id nama_level deskripsi created_at updated_at

select table absensi account_coa agent_purchases agent_purchase_items agent_purchase_payments agent_purchase_returns agent_purchase_return_items cache cache_locks cash_accounts cash_transactions categories failed_jobs jobs job_batches journal_details journal_entries migrations operational_expenses password_reset_tokens products purchases purchase_details purchase_payments role_permissions sales sale_details sale_returns sale_return_details sessions settings suppliers transactions transaction_items users user_levels . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table absensi account_coa agent_purchases agent_purchase_items agent_purchase_payments agent_purchase_returns agent_purchase_return_items cache cache_locks cash_accounts cash_transactions categories failed_jobs jobs job_batches journal_details journal_entries migrations operational_expenses password_reset_tokens products purchases purchase_details purchase_payments role_permissions sales sale_details sale_returns sale_return_details sessions settings suppliers transactions transaction_items users user_levels .	select column