🗄️ Database Browser © Nasirudin

CONSTRAINT_CATALOG	CONSTRAINT_SCHEMA	CONSTRAINT_NAME	UNIQUE_CONSTRAINT_CATALOG	UNIQUE_CONSTRAINT_SCHEMA	UNIQUE_CONSTRAINT_NAME	MATCH_OPTION	UPDATE_RULE	DELETE_RULE	TABLE_NAME	REFERENCED_TABLE_NAME
def	ayam_mrothol_db	akses_diskon_user_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	akses_diskon	users
def	ayam_mrothol_db	cashier_shifts_id_device_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	cashier_shifts	outlet_devices
def	ayam_mrothol_db	cashier_shifts_id_outlet_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	cashier_shifts	outlets
def	ayam_mrothol_db	cashier_shifts_id_user_pic_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	cashier_shifts	users
def	ayam_mrothol_db	closing_days_brand_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	closing_days	brands
def	ayam_mrothol_db	products_category_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	products	categories
def	ayam_mrothol_db	products_ruang_penjualan_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	products	ruang_penjualan
def	ayam_mrothol_db	outlet_devices_id_outlet_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_devices	outlets
def	ayam_mrothol_db	bahan_mentah_komponen_unit_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	bahan_mentah_komponen	units
def	ayam_mrothol_db	purchase_ck_supplier_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	purchase_ck	suppliers
def	ayam_mrothol_db	produksi_ck_komp_bahan_baku_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	produksi_ck	bahan_baku_ck
def	ayam_mrothol_db	outlet_sales_device_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_sales	outlet_devices
def	ayam_mrothol_db	outlet_sales_id_outlet_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_sales	outlets
def	ayam_mrothol_db	outlet_sales_payment_method_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_sales	payment_methods
def	ayam_mrothol_db	outlet_sales_shift_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_sales	cashier_shifts
def	ayam_mrothol_db	return_transactions_cashier_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	RESTRICT	return_transactions	users
def	ayam_mrothol_db	return_transactions_outlet_sale_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	RESTRICT	return_transactions	outlet_sales
def	ayam_mrothol_db	return_transactions_reviewer_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	SET NULL	return_transactions	users
def	ayam_mrothol_db	return_transactions_shift_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	RESTRICT	return_transactions	cashier_shifts
def	ayam_mrothol_db	outlet_staffs_outlet_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_staffs	outlets
def	ayam_mrothol_db	outlet_staffs_staff_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_staffs	users
def	ayam_mrothol_db	bahan_baku_unit_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	bahan_baku	units
def	ayam_mrothol_db	outlet_qr_tokens_user_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_qr_tokens	users
def	ayam_mrothol_db	bahan_baku_ck_unit_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	SET NULL	bahan_baku_ck	units
def	ayam_mrothol_db	outlet_sale_items_outlet_sale_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_sale_items	outlet_sales
def	ayam_mrothol_db	outlet_sale_items_product_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_sale_items	products
def	ayam_mrothol_db	return_transaction_details_outlet_sale_item_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	RESTRICT	return_transaction_details	outlet_sale_items
def	ayam_mrothol_db	return_transaction_details_return_transaction_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	return_transaction_details	return_transactions
def	ayam_mrothol_db	attendance_logs_id_outlet_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	attendance_logs	outlets
def	ayam_mrothol_db	outlet_otp_id_outlet_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	outlet_otp	outlets
def	ayam_mrothol_db	product_bahan_baku_bahan_baku_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	product_bahan_baku	bahan_baku
def	ayam_mrothol_db	product_bahan_baku_product_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	product_bahan_baku	products
def	ayam_mrothol_db	promos_brand_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	CASCADE	promos	brands
def	ayam_mrothol_db	outlets_supervisor_id_foreign	def	ayam_mrothol_db	PRIMARY	NONE	RESTRICT	RESTRICT	outlets	users

Total Baris: 34