Letakkan berkas disini

SQL upload ( 0 ) x -

Pengaturan Terkait dengan Halaman Klik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Jumlah Time taken
Bookmark
Segarkan
Tambah
Tidak ada penanda
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data : Waktu eksekusi kueri :
Belum ada nama *
v Show/Hide tables list View in fullscreen Tambahkan tabel dari database lainya New page Buka halaman Simpan halaman Simpan halaman sebagai Delete pages Buat tabel Create relationship Pilih kolom untuk ditampilkan Muat ulang Bantuan Tautan angular / Tautan langsung Lekatkan kepada kisi v Small/Big All Toggle small/big Toggle relationship lines Export schema > Pindahkan Menu > Sematkan teks
v v
Number of tables: 0
v ngopicee_test asset_purchases
* id : int(11)
* number : varchar(50)
* date : date
* name : varchar(100)
* category : varchar(60)
* quantity : int(11)
* total : decimal(16,2)
* method : enum('cash','transfer','qris','ewallet')
* supplier_id : int(11)
* notes : text
* user_id : int(11)
* request_key : varchar(32)
* status : enum('posted','void')
* voided_at : datetime
* voided_by : int(11)
* void_reason : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test business_settings
* id : int(11)
* name : varchar(100)
* address : text
* phone : varchar(30)
* footer : varchar(255)
* currency : varchar(5)
* transaction_prefix : varchar(12)
* low_cash : decimal(16,2)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test capital_transactions
* id : int(11)
* date : date
* source : varchar(100)
* amount : decimal(16,2)
* method : varchar(20)
* notes : text
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test cash_transactions
* id : bigint(20)
* date : date
* category : varchar(40)
* description : varchar(255)
* method : varchar(20)
* incoming : decimal(16,2)
* outgoing : decimal(16,2)
* reference_type : varchar(30)
* reference_id : int(11)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test debts
* id : int(11)
* purchase_id : int(11)
* name : varchar(100)
* total : decimal(16,2)
* paid : decimal(16,2)
* due_date : date
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test ingredients
* id : int(11)
* code : varchar(30)
* name : varchar(100)
* category_id : int(11)
* unit : enum('gram','ml','pcs')
* stock : decimal(16,3)
* min_stock : decimal(16,3)
* avg_cost : decimal(18,6)
* supplier_id : int(11)
* active : tinyint(4)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test ingredient_categories
* id : int(11)
* name : varchar(100)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test login_attempts
* id : bigint(20)
* ip_address : varchar(45)
* created_at : timestamp
v ngopicee_test operational_expenses
* id : int(11)
* date : date
* category : varchar(60)
* description : varchar(255)
* amount : decimal(16,2)
* method : varchar(20)
* notes : text
* proof : varchar(190)
* is_fixed : tinyint(4)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test private_withdrawals
* id : int(11)
* date : date
* description : varchar(255)
* amount : decimal(16,2)
* method : varchar(20)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test products
* id : int(11)
* code : varchar(30)
* name : varchar(100)
* category_id : int(11)
* cup_size : varchar(30)
* price : decimal(16,2)
* active : tinyint(4)
* photo : varchar(190)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test product_categories
* id : int(11)
* name : varchar(100)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test purchases
* id : int(11)
* number : varchar(50)
* date : date
* supplier_id : int(11)
* total : decimal(16,2)
* method : enum('cash','transfer','qris','ewallet','credit')
* notes : text
* status : enum('posted','void')
* user_id : int(11)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test purchase_details
* id : int(11)
* purchase_id : int(11)
* ingredient_id : int(11)
* quantity : decimal(16,3)
* unit_cost : decimal(18,6)
* subtotal : decimal(16,2)
* previous_cost : decimal(18,6)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test receivables
* id : int(11)
* sale_id : int(11)
* name : varchar(100)
* total : decimal(16,2)
* paid : decimal(16,2)
* due_date : date
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test recipes
* id : int(11)
* product_id : int(11)
* utility_cost : decimal(16,2)
* overhead_cost : decimal(16,2)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test recipe_details
* id : int(11)
* recipe_id : int(11)
* ingredient_id : int(11)
* quantity : decimal(16,3)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test roles
* id : int(11)
* name : varchar(30)
v ngopicee_test sales
* id : int(11)
* number : varchar(50)
* date : date
* total : decimal(16,2)
* discount : decimal(16,2)
* cogs : decimal(16,2)
* estimated_overhead : decimal(16,2)
* paid : decimal(16,2)
* change_amount : decimal(16,2)
* method : enum('cash','transfer','qris','ewallet','credit')
* customer : varchar(100)
* user_id : int(11)
* request_key : varchar(64)
* created_at : timestamp
* updated_at : timestamp
* status : enum('posted','void')
* voided_at : datetime
* voided_by : int(11)
* void_reason : varchar(255)
v ngopicee_test sales_targets
* id : int(11)
* daily_cups : int(11)
* daily_revenue : decimal(16,2)
* monthly_revenue : decimal(16,2)
* monthly_profit : decimal(16,2)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test sale_details
* id : int(11)
* sale_id : int(11)
* product_id : int(11)
* product_name : varchar(100)
* quantity : int(11)
* price : decimal(16,2)
* unit_cogs : decimal(18,6)
* unit_overhead : decimal(16,2)
* subtotal : decimal(16,2)
* discount : decimal(16,2)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test stock_movements
* id : bigint(20)
* ingredient_id : int(11)
* date : date
* type : varchar(30)
* incoming : decimal(16,3)
* outgoing : decimal(16,3)
* balance : decimal(16,3)
* unit_cost : decimal(18,6)
* reference_type : varchar(30)
* reference_id : int(11)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test stock_opnames
* id : int(11)
* date : date
* notes : varchar(255)
* user_id : int(11)
* request_key : varchar(32)
* created_at : timestamp
v ngopicee_test stock_opname_details
* id : int(11)
* opname_id : int(11)
* ingredient_id : int(11)
* ingredient_name : varchar(100)
* unit : varchar(20)
* system_stock : decimal(16,3)
* actual_stock : decimal(16,3)
* difference : decimal(16,3)
* unit_cost : decimal(18,6)
v ngopicee_test suppliers
* id : int(11)
* name : varchar(100)
* phone : varchar(30)
* address : text
* notes : text
* active : tinyint(4)
* created_at : timestamp
* updated_at : timestamp
v ngopicee_test users
* id : int(11)
* role_id : int(11)
* name : varchar(100)
* username : varchar(60)
* email : varchar(190)
* password_hash : varchar(255)
* active : tinyint(4)
* created_at : timestamp
* updated_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship