id	product_id	store_id	quantity	cost_price	purchase_date	added_by	remarks	created_at	updated_by	updated_at	

stock entries

id	store_name	store_address	store_contact	location	created_at	updated_at	email	t_pin	

stores

id	store_id	expense_type	description	amount	expense_date	created_at	updated_at	added_by	

expenses


Full texts
id
first_name
last_name
username
email
password
phone_number
role_id
store_id
created_at
updated_at
password_reset
last_activity
last_seen
last_logged_in
profile_picture
password_changed    users


Full texts
id
role_name
created_at             roles

id	sender_id	receiver_id	subject	body	is_read	created_at	reply_to	attachment	thread_id	

messages