🗄️ Database Browser © Nasirudin

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	NON_UNIQUE	INDEX_SCHEMA	INDEX_NAME	SEQ_IN_INDEX	COLUMN_NAME	COLLATION	CARDINALITY	SUB_PART	PACKED	NULLABLE	INDEX_TYPE	IGNORED
def	ayam_mrothol_db	ruang_penjualan	0	ayam_mrothol_db	PRIMARY	1	id	A	5	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	akses_diskon	0	ayam_mrothol_db	PRIMARY	1	id	A	4	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	akses_diskon	1	ayam_mrothol_db	akses_diskon_user_id_foreign	1	user_id	A	4	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	password_reset_tokens	0	ayam_mrothol_db	PRIMARY	1	email	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	cashier_shifts	0	ayam_mrothol_db	PRIMARY	1	id	A	80	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	cashier_shifts	1	ayam_mrothol_db	cashier_shifts_id_device_foreign	1	id_device	A	10	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	cashier_shifts	1	ayam_mrothol_db	cashier_shifts_id_outlet_foreign	1	id_outlet	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	cashier_shifts	1	ayam_mrothol_db	cashier_shifts_id_user_pic_foreign	1	id_user_pic	A	20	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	closing_days	0	ayam_mrothol_db	PRIMARY	1	id	A	2	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	closing_days	1	ayam_mrothol_db	closing_days_brand_id_foreign	1	brand_id	A	2	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	migrations	0	ayam_mrothol_db	PRIMARY	1	id	A	48	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	cache	0	ayam_mrothol_db	PRIMARY	1	key	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	cache	1	ayam_mrothol_db	cache_expiration_index	1	expiration	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	failed_jobs	0	ayam_mrothol_db	PRIMARY	1	id	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	failed_jobs	0	ayam_mrothol_db	failed_jobs_uuid_unique	1	uuid	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	failed_jobs	1	ayam_mrothol_db	failed_jobs_connection_queue_failed_at_index	1	connection	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	failed_jobs	1	ayam_mrothol_db	failed_jobs_connection_queue_failed_at_index	2	queue	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	failed_jobs	1	ayam_mrothol_db	failed_jobs_connection_queue_failed_at_index	3	failed_at	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	payment_methods	0	ayam_mrothol_db	PRIMARY	1	id	A	4	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	suppliers	0	ayam_mrothol_db	PRIMARY	1	id	A	1	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	users	0	ayam_mrothol_db	PRIMARY	1	id	A	52	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	users	0	ayam_mrothol_db	users_email_unique	1	email	A	52	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	products	0	ayam_mrothol_db	PRIMARY	1	id	A	88	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	products	1	ayam_mrothol_db	products_category_id_foreign	1	category_id	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	products	1	ayam_mrothol_db	products_ruang_penjualan_id_foreign	1	ruang_penjualan_id	A	11	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_devices	0	ayam_mrothol_db	PRIMARY	1	id	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_devices	0	ayam_mrothol_db	outlet_devices_device_token_unique	1	device_token	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_devices	1	ayam_mrothol_db	outlet_devices_id_outlet_foreign	1	id_outlet	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	bahan_mentah_komponen	0	ayam_mrothol_db	PRIMARY	1	id	A	4	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	bahan_mentah_komponen	1	ayam_mrothol_db	bahan_mentah_komponen_unit_id_foreign	1	unit_id	A	2	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	purchase_ck	0	ayam_mrothol_db	PRIMARY	1	id	A	2	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	purchase_ck	1	ayam_mrothol_db	purchase_ck_supplier_id_foreign	1	supplier_id	A	2	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	produksi_ck	0	ayam_mrothol_db	PRIMARY	1	id	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	produksi_ck	1	ayam_mrothol_db	produksi_ck_komp_bahan_baku_id_foreign	1	komp_bahan_baku_id	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	bahan_mentah	0	ayam_mrothol_db	PRIMARY	1	id	A	1	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	jobs	0	ayam_mrothol_db	PRIMARY	1	id	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	jobs	1	ayam_mrothol_db	jobs_queue_index	1	queue	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	cache_locks	0	ayam_mrothol_db	PRIMARY	1	key	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	cache_locks	1	ayam_mrothol_db	cache_locks_expiration_index	1	expiration	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_sales	0	ayam_mrothol_db	PRIMARY	1	id	A	117	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_sales	1	ayam_mrothol_db	outlet_sales_id_outlet_foreign	1	id_outlet	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_sales	1	ayam_mrothol_db	outlet_sales_device_id_foreign	1	device_id	A	10	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_sales	1	ayam_mrothol_db	outlet_sales_shift_id_foreign	1	shift_id	A	117	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_sales	1	ayam_mrothol_db	outlet_sales_payment_method_id_foreign	1	payment_method_id	A	8	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	return_transactions	0	ayam_mrothol_db	PRIMARY	1	id	A	13	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	return_transactions	0	ayam_mrothol_db	return_transactions_outlet_sale_id_unique	1	outlet_sale_id	A	13	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	return_transactions	1	ayam_mrothol_db	return_transactions_shift_id_foreign	1	shift_id	A	4	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	return_transactions	1	ayam_mrothol_db	return_transactions_cashier_id_foreign	1	cashier_id	A	2	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	return_transactions	1	ayam_mrothol_db	return_transactions_reviewer_id_foreign	1	reviewer_id	A	6	NULL	NULL	YES	BTREE	NO
def	ayam_mrothol_db	outlet_staffs	0	ayam_mrothol_db	PRIMARY	1	id	A	25	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_staffs	0	ayam_mrothol_db	outlet_staffs_outlet_id_staff_id_unique	1	outlet_id	A	8	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_staffs	0	ayam_mrothol_db	outlet_staffs_outlet_id_staff_id_unique	2	staff_id	A	25	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_staffs	1	ayam_mrothol_db	outlet_staffs_staff_id_foreign	1	staff_id	A	25	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	bahan_baku	0	ayam_mrothol_db	PRIMARY	1	id	A	26	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	bahan_baku	1	ayam_mrothol_db	bahan_baku_unit_id_foreign	1	unit_id	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_qr_tokens	0	ayam_mrothol_db	PRIMARY	1	id	A	3	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_qr_tokens	0	ayam_mrothol_db	outlet_qr_tokens_qr_token_unique	1	qr_token	A	3	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_qr_tokens	1	ayam_mrothol_db	outlet_qr_tokens_device_id_index	1	device_id	A	3	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_qr_tokens	1	ayam_mrothol_db	outlet_qr_tokens_user_id_foreign	1	user_id	A	3	NULL	NULL	YES	BTREE	NO
def	ayam_mrothol_db	bahan_baku_ck	0	ayam_mrothol_db	PRIMARY	1	id	A	2	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	bahan_baku_ck	1	ayam_mrothol_db	bahan_baku_ck_unit_id_foreign	1	unit_id	A	2	NULL	NULL	YES	BTREE	NO
def	ayam_mrothol_db	outlet_sale_items	0	ayam_mrothol_db	PRIMARY	1	id	A	227	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_sale_items	1	ayam_mrothol_db	outlet_sale_items_outlet_sale_id_foreign	1	outlet_sale_id	A	227	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_sale_items	1	ayam_mrothol_db	outlet_sale_items_product_id_foreign	1	product_id	A	113	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	personal_access_tokens	0	ayam_mrothol_db	PRIMARY	1	id	A	49	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	personal_access_tokens	0	ayam_mrothol_db	personal_access_tokens_token_unique	1	token	A	49	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	personal_access_tokens	1	ayam_mrothol_db	personal_access_tokens_tokenable_type_tokenable_id_index	1	tokenable_type	A	2	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	personal_access_tokens	1	ayam_mrothol_db	personal_access_tokens_tokenable_type_tokenable_id_index	2	tokenable_id	A	12	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	personal_access_tokens	1	ayam_mrothol_db	personal_access_tokens_expires_at_index	1	expires_at	A	2	NULL	NULL	YES	BTREE	NO
def	ayam_mrothol_db	categories	0	ayam_mrothol_db	PRIMARY	1	id	A	3	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	categories	0	ayam_mrothol_db	categories_nama_unique	1	nama	A	3	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	return_transaction_details	0	ayam_mrothol_db	PRIMARY	1	id	A	15	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	return_transaction_details	0	ayam_mrothol_db	return_transaction_details_outlet_sale_item_id_unique	1	outlet_sale_item_id	A	15	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	return_transaction_details	1	ayam_mrothol_db	return_transaction_details_return_transaction_id_foreign	1	return_transaction_id	A	15	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	units	0	ayam_mrothol_db	PRIMARY	1	id	A	5	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	job_batches	0	ayam_mrothol_db	PRIMARY	1	id	A	0	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	brands	0	ayam_mrothol_db	PRIMARY	1	id	A	3	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	attendance_logs	0	ayam_mrothol_db	PRIMARY	1	id	A	77	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	attendance_logs	1	ayam_mrothol_db	attendance_logs_id_outlet_foreign	1	id_outlet	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	attendance_logs	1	ayam_mrothol_db	attendance_logs_email_index	1	email	A	38	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	sessions	0	ayam_mrothol_db	PRIMARY	1	id	A	17	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	sessions	1	ayam_mrothol_db	sessions_user_id_index	1	user_id	A	2	NULL	NULL	YES	BTREE	NO
def	ayam_mrothol_db	sessions	1	ayam_mrothol_db	sessions_last_activity_index	1	last_activity	A	17	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_otp	0	ayam_mrothol_db	PRIMARY	1	id	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_otp	1	ayam_mrothol_db	outlet_otp_id_outlet_foreign	1	id_outlet	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlet_otp	1	ayam_mrothol_db	outlet_otp_otp_code_index	1	otp_code	A	6	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	product_bahan_baku	0	ayam_mrothol_db	PRIMARY	1	id	A	45	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	product_bahan_baku	1	ayam_mrothol_db	product_bahan_baku_product_id_foreign	1	product_id	A	45	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	product_bahan_baku	1	ayam_mrothol_db	product_bahan_baku_bahan_baku_id_foreign	1	bahan_baku_id	A	45	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	promos	0	ayam_mrothol_db	PRIMARY	1	id	A	3	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	promos	1	ayam_mrothol_db	promos_brand_id_foreign	1	brand_id	A	3	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlets	0	ayam_mrothol_db	PRIMARY	1	id	A	7	NULL	NULL		BTREE	NO
def	ayam_mrothol_db	outlets	1	ayam_mrothol_db	outlets_supervisor_id_foreign	1	supervisor_id	A	7	NULL	NULL		BTREE	NO

Total Baris: 93