🗄️ Database Browser © Nasirudin

CONSTRAINT_CATALOG	CONSTRAINT_SCHEMA	CONSTRAINT_NAME	TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	ORDINAL_POSITION	POSITION_IN_UNIQUE_CONSTRAINT	REFERENCED_TABLE_SCHEMA	REFERENCED_TABLE_NAME	REFERENCED_COLUMN_NAME
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	ruang_penjualan	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	akses_diskon	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	akses_diskon_user_id_foreign	def	ayam_mrothol_db	akses_diskon	user_id	1	1	ayam_mrothol_db	users	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	password_reset_tokens	email	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	cashier_shifts	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	cashier_shifts_id_device_foreign	def	ayam_mrothol_db	cashier_shifts	id_device	1	1	ayam_mrothol_db	outlet_devices	id
def	ayam_mrothol_db	cashier_shifts_id_outlet_foreign	def	ayam_mrothol_db	cashier_shifts	id_outlet	1	1	ayam_mrothol_db	outlets	id
def	ayam_mrothol_db	cashier_shifts_id_user_pic_foreign	def	ayam_mrothol_db	cashier_shifts	id_user_pic	1	1	ayam_mrothol_db	users	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	closing_days	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	closing_days_brand_id_foreign	def	ayam_mrothol_db	closing_days	brand_id	1	1	ayam_mrothol_db	brands	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	migrations	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	cache	key	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	failed_jobs	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	failed_jobs_uuid_unique	def	ayam_mrothol_db	failed_jobs	uuid	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	payment_methods	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	suppliers	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	users	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	users_email_unique	def	ayam_mrothol_db	users	email	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	products	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	products_category_id_foreign	def	ayam_mrothol_db	products	category_id	1	1	ayam_mrothol_db	categories	id
def	ayam_mrothol_db	products_ruang_penjualan_id_foreign	def	ayam_mrothol_db	products	ruang_penjualan_id	1	1	ayam_mrothol_db	ruang_penjualan	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	outlet_devices	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlet_devices_device_token_unique	def	ayam_mrothol_db	outlet_devices	device_token	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlet_devices_id_outlet_foreign	def	ayam_mrothol_db	outlet_devices	id_outlet	1	1	ayam_mrothol_db	outlets	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	bahan_mentah_komponen	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	bahan_mentah_komponen_unit_id_foreign	def	ayam_mrothol_db	bahan_mentah_komponen	unit_id	1	1	ayam_mrothol_db	units	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	purchase_ck	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	purchase_ck_supplier_id_foreign	def	ayam_mrothol_db	purchase_ck	supplier_id	1	1	ayam_mrothol_db	suppliers	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	produksi_ck	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	produksi_ck_komp_bahan_baku_id_foreign	def	ayam_mrothol_db	produksi_ck	komp_bahan_baku_id	1	1	ayam_mrothol_db	bahan_baku_ck	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	bahan_mentah	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	jobs	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	cache_locks	key	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	outlet_sales	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlet_sales_device_id_foreign	def	ayam_mrothol_db	outlet_sales	device_id	1	1	ayam_mrothol_db	outlet_devices	id
def	ayam_mrothol_db	outlet_sales_id_outlet_foreign	def	ayam_mrothol_db	outlet_sales	id_outlet	1	1	ayam_mrothol_db	outlets	id
def	ayam_mrothol_db	outlet_sales_payment_method_id_foreign	def	ayam_mrothol_db	outlet_sales	payment_method_id	1	1	ayam_mrothol_db	payment_methods	id
def	ayam_mrothol_db	outlet_sales_shift_id_foreign	def	ayam_mrothol_db	outlet_sales	shift_id	1	1	ayam_mrothol_db	cashier_shifts	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	return_transactions	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	return_transactions_outlet_sale_id_unique	def	ayam_mrothol_db	return_transactions	outlet_sale_id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	return_transactions_cashier_id_foreign	def	ayam_mrothol_db	return_transactions	cashier_id	1	1	ayam_mrothol_db	users	id
def	ayam_mrothol_db	return_transactions_outlet_sale_id_foreign	def	ayam_mrothol_db	return_transactions	outlet_sale_id	1	1	ayam_mrothol_db	outlet_sales	id
def	ayam_mrothol_db	return_transactions_reviewer_id_foreign	def	ayam_mrothol_db	return_transactions	reviewer_id	1	1	ayam_mrothol_db	users	id
def	ayam_mrothol_db	return_transactions_shift_id_foreign	def	ayam_mrothol_db	return_transactions	shift_id	1	1	ayam_mrothol_db	cashier_shifts	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	outlet_staffs	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlet_staffs_outlet_id_staff_id_unique	def	ayam_mrothol_db	outlet_staffs	outlet_id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlet_staffs_outlet_id_staff_id_unique	def	ayam_mrothol_db	outlet_staffs	staff_id	2	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlet_staffs_outlet_id_foreign	def	ayam_mrothol_db	outlet_staffs	outlet_id	1	1	ayam_mrothol_db	outlets	id
def	ayam_mrothol_db	outlet_staffs_staff_id_foreign	def	ayam_mrothol_db	outlet_staffs	staff_id	1	1	ayam_mrothol_db	users	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	bahan_baku	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	bahan_baku_unit_id_foreign	def	ayam_mrothol_db	bahan_baku	unit_id	1	1	ayam_mrothol_db	units	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	outlet_qr_tokens	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlet_qr_tokens_qr_token_unique	def	ayam_mrothol_db	outlet_qr_tokens	qr_token	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlet_qr_tokens_user_id_foreign	def	ayam_mrothol_db	outlet_qr_tokens	user_id	1	1	ayam_mrothol_db	users	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	bahan_baku_ck	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	bahan_baku_ck_unit_id_foreign	def	ayam_mrothol_db	bahan_baku_ck	unit_id	1	1	ayam_mrothol_db	units	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	outlet_sale_items	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlet_sale_items_outlet_sale_id_foreign	def	ayam_mrothol_db	outlet_sale_items	outlet_sale_id	1	1	ayam_mrothol_db	outlet_sales	id
def	ayam_mrothol_db	outlet_sale_items_product_id_foreign	def	ayam_mrothol_db	outlet_sale_items	product_id	1	1	ayam_mrothol_db	products	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	personal_access_tokens	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	personal_access_tokens_token_unique	def	ayam_mrothol_db	personal_access_tokens	token	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	categories	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	categories_nama_unique	def	ayam_mrothol_db	categories	nama	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	return_transaction_details	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	return_transaction_details_outlet_sale_item_id_unique	def	ayam_mrothol_db	return_transaction_details	outlet_sale_item_id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	return_transaction_details_outlet_sale_item_id_foreign	def	ayam_mrothol_db	return_transaction_details	outlet_sale_item_id	1	1	ayam_mrothol_db	outlet_sale_items	id
def	ayam_mrothol_db	return_transaction_details_return_transaction_id_foreign	def	ayam_mrothol_db	return_transaction_details	return_transaction_id	1	1	ayam_mrothol_db	return_transactions	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	units	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	job_batches	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	brands	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	attendance_logs	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	attendance_logs_id_outlet_foreign	def	ayam_mrothol_db	attendance_logs	id_outlet	1	1	ayam_mrothol_db	outlets	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	sessions	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	outlet_otp	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlet_otp_id_outlet_foreign	def	ayam_mrothol_db	outlet_otp	id_outlet	1	1	ayam_mrothol_db	outlets	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	product_bahan_baku	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	product_bahan_baku_bahan_baku_id_foreign	def	ayam_mrothol_db	product_bahan_baku	bahan_baku_id	1	1	ayam_mrothol_db	bahan_baku	id
def	ayam_mrothol_db	product_bahan_baku_product_id_foreign	def	ayam_mrothol_db	product_bahan_baku	product_id	1	1	ayam_mrothol_db	products	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	promos	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	promos_brand_id_foreign	def	ayam_mrothol_db	promos	brand_id	1	1	ayam_mrothol_db	brands	id
def	ayam_mrothol_db	PRIMARY	def	ayam_mrothol_db	outlets	id	1	NULL	NULL	NULL	NULL
def	ayam_mrothol_db	outlets_supervisor_id_foreign	def	ayam_mrothol_db	outlets	supervisor_id	1	1	ayam_mrothol_db	users	id

Total Baris: 82