* 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 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 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 migration batch

* id expense_date cash_account_id category description amount notes created_at updated_at

* email token created_at

* id barcode nama_produk stok harga_modal harga_jual created_at updated_at

* id total_bayar total_untung created_at updated_at

* id product_id qty subtotal untung_satuan created_at updated_at

* id user_id ip_address user_agent payload last_activity

* id nama_toko alamat_toko logo_toko telepon footer_struk 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 remember_token created_at updated_at

select table agent_purchases agent_purchase_items agent_purchase_payments agent_purchase_returns agent_purchase_return_items cache cache_locks cash_accounts cash_transactions failed_jobs jobs job_batches migrations operational_expenses password_reset_tokens products sales sale_details sessions settings transactions transaction_items users . 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 agent_purchases agent_purchase_items agent_purchase_payments agent_purchase_returns agent_purchase_return_items cache cache_locks cash_accounts cash_transactions failed_jobs jobs job_batches migrations operational_expenses password_reset_tokens products sales sale_details sessions settings transactions transaction_items users .	select column