🗄️ Database Browser © Nasirudin

CONSTRAINT_CATALOG	CONSTRAINT_SCHEMA	CONSTRAINT_NAME	TABLE_SCHEMA	TABLE_NAME	CONSTRAINT_TYPE
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	ruang_penjualan	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	akses_diskon	PRIMARY KEY
def	ayam_mrothol_db	akses_diskon_user_id_foreign	ayam_mrothol_db	akses_diskon	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	password_reset_tokens	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	cashier_shifts	PRIMARY KEY
def	ayam_mrothol_db	cashier_shifts_id_device_foreign	ayam_mrothol_db	cashier_shifts	FOREIGN KEY
def	ayam_mrothol_db	cashier_shifts_id_outlet_foreign	ayam_mrothol_db	cashier_shifts	FOREIGN KEY
def	ayam_mrothol_db	cashier_shifts_id_user_pic_foreign	ayam_mrothol_db	cashier_shifts	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	closing_days	PRIMARY KEY
def	ayam_mrothol_db	komponen	ayam_mrothol_db	closing_days	CHECK
def	ayam_mrothol_db	closing_days_brand_id_foreign	ayam_mrothol_db	closing_days	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	migrations	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	cache	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	failed_jobs	PRIMARY KEY
def	ayam_mrothol_db	failed_jobs_uuid_unique	ayam_mrothol_db	failed_jobs	UNIQUE
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	payment_methods	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	suppliers	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	users	PRIMARY KEY
def	ayam_mrothol_db	users_email_unique	ayam_mrothol_db	users	UNIQUE
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	products	PRIMARY KEY
def	ayam_mrothol_db	products_category_id_foreign	ayam_mrothol_db	products	FOREIGN KEY
def	ayam_mrothol_db	products_ruang_penjualan_id_foreign	ayam_mrothol_db	products	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	outlet_devices	PRIMARY KEY
def	ayam_mrothol_db	outlet_devices_device_token_unique	ayam_mrothol_db	outlet_devices	UNIQUE
def	ayam_mrothol_db	outlet_devices_id_outlet_foreign	ayam_mrothol_db	outlet_devices	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	bahan_mentah_komponen	PRIMARY KEY
def	ayam_mrothol_db	bahan_mentah_komponen_unit_id_foreign	ayam_mrothol_db	bahan_mentah_komponen	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	purchase_ck	PRIMARY KEY
def	ayam_mrothol_db	paket	ayam_mrothol_db	purchase_ck	CHECK
def	ayam_mrothol_db	purchase_ck_supplier_id_foreign	ayam_mrothol_db	purchase_ck	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	produksi_ck	PRIMARY KEY
def	ayam_mrothol_db	produksi_ck_komp_bahan_baku_id_foreign	ayam_mrothol_db	produksi_ck	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	bahan_mentah	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	jobs	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	cache_locks	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	outlet_sales	PRIMARY KEY
def	ayam_mrothol_db	outlet_sales_device_id_foreign	ayam_mrothol_db	outlet_sales	FOREIGN KEY
def	ayam_mrothol_db	outlet_sales_id_outlet_foreign	ayam_mrothol_db	outlet_sales	FOREIGN KEY
def	ayam_mrothol_db	outlet_sales_payment_method_id_foreign	ayam_mrothol_db	outlet_sales	FOREIGN KEY
def	ayam_mrothol_db	outlet_sales_shift_id_foreign	ayam_mrothol_db	outlet_sales	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	return_transactions	PRIMARY KEY
def	ayam_mrothol_db	return_transactions_outlet_sale_id_unique	ayam_mrothol_db	return_transactions	UNIQUE
def	ayam_mrothol_db	return_transactions_cashier_id_foreign	ayam_mrothol_db	return_transactions	FOREIGN KEY
def	ayam_mrothol_db	return_transactions_outlet_sale_id_foreign	ayam_mrothol_db	return_transactions	FOREIGN KEY
def	ayam_mrothol_db	return_transactions_reviewer_id_foreign	ayam_mrothol_db	return_transactions	FOREIGN KEY
def	ayam_mrothol_db	return_transactions_shift_id_foreign	ayam_mrothol_db	return_transactions	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	outlet_staffs	PRIMARY KEY
def	ayam_mrothol_db	outlet_staffs_outlet_id_staff_id_unique	ayam_mrothol_db	outlet_staffs	UNIQUE
def	ayam_mrothol_db	outlet_staffs_outlet_id_foreign	ayam_mrothol_db	outlet_staffs	FOREIGN KEY
def	ayam_mrothol_db	outlet_staffs_staff_id_foreign	ayam_mrothol_db	outlet_staffs	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	bahan_baku	PRIMARY KEY
def	ayam_mrothol_db	bahan_baku_unit_id_foreign	ayam_mrothol_db	bahan_baku	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	outlet_qr_tokens	PRIMARY KEY
def	ayam_mrothol_db	outlet_qr_tokens_qr_token_unique	ayam_mrothol_db	outlet_qr_tokens	UNIQUE
def	ayam_mrothol_db	outlet_qr_tokens_user_id_foreign	ayam_mrothol_db	outlet_qr_tokens	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	bahan_baku_ck	PRIMARY KEY
def	ayam_mrothol_db	komponen	ayam_mrothol_db	bahan_baku_ck	CHECK
def	ayam_mrothol_db	bahan_baku_ck_unit_id_foreign	ayam_mrothol_db	bahan_baku_ck	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	outlet_sale_items	PRIMARY KEY
def	ayam_mrothol_db	outlet_sale_items_outlet_sale_id_foreign	ayam_mrothol_db	outlet_sale_items	FOREIGN KEY
def	ayam_mrothol_db	outlet_sale_items_product_id_foreign	ayam_mrothol_db	outlet_sale_items	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	personal_access_tokens	PRIMARY KEY
def	ayam_mrothol_db	personal_access_tokens_token_unique	ayam_mrothol_db	personal_access_tokens	UNIQUE
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	categories	PRIMARY KEY
def	ayam_mrothol_db	categories_nama_unique	ayam_mrothol_db	categories	UNIQUE
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	return_transaction_details	PRIMARY KEY
def	ayam_mrothol_db	return_transaction_details_outlet_sale_item_id_unique	ayam_mrothol_db	return_transaction_details	UNIQUE
def	ayam_mrothol_db	return_transaction_details_outlet_sale_item_id_foreign	ayam_mrothol_db	return_transaction_details	FOREIGN KEY
def	ayam_mrothol_db	return_transaction_details_return_transaction_id_foreign	ayam_mrothol_db	return_transaction_details	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	units	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	job_batches	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	brands	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	attendance_logs	PRIMARY KEY
def	ayam_mrothol_db	attendance_logs_id_outlet_foreign	ayam_mrothol_db	attendance_logs	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	sessions	PRIMARY KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	outlet_otp	PRIMARY KEY
def	ayam_mrothol_db	outlet_otp_id_outlet_foreign	ayam_mrothol_db	outlet_otp	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	product_bahan_baku	PRIMARY KEY
def	ayam_mrothol_db	product_bahan_baku_bahan_baku_id_foreign	ayam_mrothol_db	product_bahan_baku	FOREIGN KEY
def	ayam_mrothol_db	product_bahan_baku_product_id_foreign	ayam_mrothol_db	product_bahan_baku	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	promos	PRIMARY KEY
def	ayam_mrothol_db	detail_promo	ayam_mrothol_db	promos	CHECK
def	ayam_mrothol_db	promos_brand_id_foreign	ayam_mrothol_db	promos	FOREIGN KEY
def	ayam_mrothol_db	PRIMARY	ayam_mrothol_db	outlets	PRIMARY KEY
def	ayam_mrothol_db	outlets_supervisor_id_foreign	ayam_mrothol_db	outlets	FOREIGN KEY

Total Baris: 85