≡ƒôè Complete Database Export

Database: inventory_pos
Host: localhost
Export Time: 2026-02-14 11:37:10

21

Total Tables

283

Total Records

10.4.32-MariaDB

MySQL Version

8.2.12

PHP Version

≡ƒôï account_transactions 17 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(11)`	NO	PRIMARY	NULL	auto_increment
account_id	`int(11)`	NO	FOREIGN	NULL
transaction_type	`enum('credit','debit')`	NO		NULL
amount	`decimal(15,2)`	NO		NULL
reference_type	`varchar(50)`	NO		NULL
reference_id	`int(11)`	NO		NULL
description	`text`	YES		NULL
transaction_date	`datetime`	YES		current_timestamp()
created_by	`int(11)`	YES		NULL

Indexes:

account_id: account_id

≡ƒöù Foreign Key Relationships:

account_id ΓåÆ references financial_accounts.id

Sample Data (First 10 rows):

id	account_id	transaction_type	amount	reference_type	reference_id	description	transaction_date	created_by
1	1	credit	15187.93	sale	16	Sale Payment Ref: INV-20260209-1EBDBF	2026-02-09 17:29:06	1
2	1	credit	500000.00	capital_injection	4	Capital injection - Investor: ehrth	2026-02-09 17:30:17	1
3	1	credit	26645.50	sale	17	Sale Payment Ref: INV-20260209-8EA6D2	2026-02-09 21:06:17	1
4	1	credit	15987.30	sale	18	Sale Payment Ref: INV-20260209-1C911A	2026-02-09 21:08:01	1
5	1	credit	47961.90	sale	19	Sale Payment Ref: INV-20260209-9234C7	2026-02-09 21:15:05	1
6	1	credit	2545.90	sale	20	Sale Payment Ref: INV-20260209-280EF2	2026-02-09 21:15:46	1
7	1	credit	2297.70	sale	21	Sale Payment Ref: INV-20260209-E91194	2026-02-09 21:36:46	1
8	1	credit	765.90	sale	22	Sale Payment Ref: INV-20260209-1344A3	2026-02-09 21:48:33	1
9	1	credit	765.90	sale	23	Sale Payment Ref: INV-20260209-22FD07	2026-02-09 22:08:02	1
10	1	credit	700000.00	capital_injection	5	Capital injection - Investor: extra	2026-02-09 23:05:50	1

≡ƒôï activity_logs 131 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
user_id	`int(10) unsigned`	YES	FOREIGN	NULL
action	`varchar(100)`	NO		NULL
table_name	`varchar(100)`	YES	FOREIGN	NULL
record_id	`int(10) unsigned`	YES		NULL
old_values	`longtext`	YES		NULL
new_values	`longtext`	YES		NULL
description	`text`	YES		NULL
ip_address	`varchar(45)`	YES		NULL
user_agent	`text`	YES		NULL
created_at	`timestamp`	NO	FOREIGN	current_timestamp()

Indexes:

idx_user: user_id
idx_table: table_name, record_id
idx_created: created_at

≡ƒöù Foreign Key Relationships:

user_id ΓåÆ references users.id

Sample Data (First 10 rows):

id	user_id	action	table_name	record_id	old_values	new_values	description	ip_address	user_agent	created_at
1	1	stock_adjustment	products	16	{"old_stock":47}	{"new_stock":59,"reason":"gsfg"}	NULL	::1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Sa...	2026-02-08 17:04:12
2	1	create_investor	capital	15	NULL	{"name":"iniokxnb","phone":"","email":""}	Added new investor: iniokxnb	::1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Sa...	2026-02-09 00:58:43
3	1	create_investor	capital	16	NULL	{"name":"iniokxnbios","phone":"","email":""}	Added new investor: iniokxnbios	::1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Sa...	2026-02-09 00:59:00
4	1	create_investor	capital	17	NULL	{"name":"dmlkgns","phone":"","email":""}	Added new investor: dmlkgns	::1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Sa...	2026-02-09 01:00:15
5	1	capital_injection	capital	2	NULL	{"trans_date":"2026-02-08","investor_id":"17","amount":"5000","method":"cash","description":""}	Capital injection of 5000	::1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Sa...	2026-02-09 01:00:34
6	1	delete_investor	capital	11	NULL	NULL	Deleted investor ID: 11	::1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Sa...	2026-02-09 01:04:55
7	1	delete_investor	capital	12	NULL	NULL	Deleted investor ID: 12	::1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Sa...	2026-02-09 01:04:59
8	1	delete_investor	capital	13	NULL	NULL	Deleted investor ID: 13	::1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Sa...	2026-02-09 01:05:02
9	1	delete_investor	capital	14	NULL	NULL	Deleted investor ID: 14	::1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Sa...	2026-02-09 01:05:06
10	1	delete_investor	capital	15	NULL	NULL	Deleted investor ID: 15	::1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Sa...	2026-02-09 01:05:09

≡ƒôï capital_transactions 1 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
trans_date	`date`	NO		NULL
investor_id	`int(10) unsigned`	NO	FOREIGN	NULL
type	`enum('injection','withdrawal')`	NO		NULL
amount	`decimal(12,2)`	NO		NULL
method	`enum('cash','bank','mobile')`	YES		cash
reference	`varchar(100)`	YES		NULL
description	`text`	YES		NULL
created_by	`int(10) unsigned`	YES	FOREIGN	NULL
created_at	`timestamp`	NO		current_timestamp()

Indexes:

investor_id: investor_id
created_by: created_by

≡ƒöù Foreign Key Relationships:

investor_id ΓåÆ references contacts.id
created_by ΓåÆ references users.id

Sample Data (First 10 rows):

id	trans_date	investor_id	type	amount	method	reference	description	created_by	created_at
1	2026-02-10	10	injection	500000.00	cash	NULL	Initial investment	1	2026-02-10 17:16:06

≡ƒôï categories 1 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
name	`varchar(255)`	NO		NULL
description	`text`	YES		NULL
is_active	`tinyint(1)`	YES		1
created_at	`timestamp`	NO		current_timestamp()

Sample Data (First 10 rows):

id	name	description	is_active	created_at
11	j9ojfhisdyesr	ubujb	1	2026-02-09 21:10:50

≡ƒôï contacts 5 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
type	`enum('customer','supplier','investor')`	NO	FOREIGN	NULL
name	`varchar(255)`	NO		NULL
email	`varchar(255)`	YES		NULL
image	`varchar(255)`	YES		NULL
phone	`varchar(20)`	YES		NULL
company_name	`varchar(255)`	YES		NULL
address	`text`	YES		NULL
credit_limit	`decimal(12,2)`	YES		0.00
created_at	`timestamp`	NO		current_timestamp()
opening_balance	`decimal(12,2)`	YES		0.00
balance	`decimal(10,2)`	YES		0.00
opening_balance_date	`date`	YES		NULL

Indexes:

idx_type: type

Sample Data (First 10 rows):

id	type	name	email	image	phone	company_name	address	created_at	balance	opening_balance_date
10	investor	Owner (Me)	NULL	NULL	NULL	NULL	NULL	2026-02-08 23:49:20	0.00	NULL
17	investor	dmlkgns		NULL		NULL	NULL	2026-02-09 01:00:15	0.00	NULL
20	investor	Mubin		NULL	01793593692	NULL	NULL	2026-02-09 23:04:41	0.00	NULL
21	supplier	Fahad	nfen@iesngis.sog	assets/uploads/contacts/698cfc158d32a_cd6194ef.jpg	01745258963	nenfewdn	oujlbnj	2026-02-10 16:50:41	1000.00	NULL
22	customer	Nur		assets/uploads/contacts/698cfb7c1ea91_425513f4.jpg	01700112233	ejf		2026-02-11 13:11:59	530.00	NULL

≡ƒôï expenses 0 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
category	`varchar(100)`	NO		NULL
amount	`decimal(12,2)`	NO		NULL
reference	`varchar(100)`	YES		NULL
description	`text`	YES		NULL
expense_date	`date`	NO	FOREIGN	NULL
created_at	`timestamp`	NO		current_timestamp()

Indexes:

idx_date: expense_date

ΓÜá∩╕Å No data in this table

≡ƒôï financial_accounts 3 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(11)`	NO	PRIMARY	NULL	auto_increment
account_name	`varchar(100)`	NO		NULL
account_number	`varchar(50)`	YES		NULL
account_type	`enum('cash','bank','mobile_banking')`	NO		cash
balance	`decimal(15,2)`	YES		0.00
is_active	`tinyint(1)`	YES		1
created_at	`timestamp`	NO		current_timestamp()
updated_at	`timestamp`	NO		current_timestamp()	on update current_timestamp()

Sample Data (First 10 rows):

id	account_name	account_number	account_type	balance	is_active	created_at	updated_at
1	Cash Drawer	NULL	cash	486747.00	1	2026-02-09 15:31:48	2026-02-12 04:32:03
3	DBBL	NULL	bank	14.00	1	2026-02-09 23:47:40	2026-02-11 13:22:02
4	BKash	NULL	mobile_banking	0.00	1	2026-02-09 23:50:03	2026-02-10 16:46:50

≡ƒôï financial_transactions 14 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(11)`	NO	PRIMARY	NULL	auto_increment
financial_account_id	`int(11)`	NO	FOREIGN	NULL
transaction_type	`enum('credit','debit')`	NO		NULL
amount	`decimal(15,2)`	NO		NULL
reference_type	`varchar(50)`	YES	FOREIGN	NULL
reference_id	`int(11)`	YES		NULL
description	`text`	YES		NULL
transaction_date	`date`	NO	FOREIGN	NULL
created_by	`int(11)`	YES		NULL
created_at	`timestamp`	NO		current_timestamp()

Indexes:

idx_account: financial_account_id
idx_date: transaction_date
idx_reference: reference_type, reference_id

Sample Data (First 10 rows):

id	financial_account_id	transaction_type	amount	reference_type	reference_id	description	transaction_date	created_by	created_at
2	1	debit	5000.00	purchase	4	Purchase Payment Ref: PO-20260210-1428	2026-02-10	1	2026-02-10 17:08:45
3	1	credit	14.00	sale	1	Sale Payment Ref: INV-20260210-0D1E96	2026-02-10	1	2026-02-10 17:10:08
4	1	credit	500000.00	capital_injection	1	Capital injection - Investor: Initial investment	2026-02-10	1	2026-02-10 17:16:06
5	1	debit	9900.00	purchase	6	Purchase Payment Ref: PO-20260210-5184	2026-02-10	1	2026-02-10 17:55:07
6	1	credit	153.00	sale	2	Sale Payment Ref: INV-20260211-E14A8C	2026-02-11	1	2026-02-11 13:18:06
7	3	credit	14.00	sale	3	Sale Payment Ref: INV-20260211-ADB489	2026-02-11	1	2026-02-11 13:22:02
8	1	debit	35000.00	expense	1	Expense: Other - test	2026-02-11	1	2026-02-11 18:18:10
9	1	credit	35000.00	expense_edit_reversal	1	Correction: Expense #1 edited (Reversal)	2026-02-11	1	2026-02-11 18:18:43
10	1	debit	20000.00	expense	1	Expense: Other - test (Updated)	2026-02-11	1	2026-02-11 18:18:43
11	1	credit	20000.00	expense_reversal	1	Reversal: Deleted expense - Other	2026-02-11	1	2026-02-11 18:19:01

≡ƒôï payments 9 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
payable_type	`varchar(50)`	NO	FOREIGN	NULL
payable_id	`int(10) unsigned`	NO		NULL
amount	`decimal(12,2)`	NO		NULL
method	`enum('cash','card','bank','mobile')`	YES		cash
paid_at	`date`	NO		NULL
created_at	`timestamp`	NO		current_timestamp()

Indexes:

idx_payable: payable_type, payable_id

Sample Data (First 10 rows):

id	payable_type	payable_id	amount	method	paid_at	created_at
2	purchase	4	5000.00	cash	2026-02-10	2026-02-10 17:08:45
3	sale	1	14.00	cash	2026-02-10	2026-02-10 17:10:08
4	purchase	6	9900.00	cash	2026-02-10	2026-02-10 17:55:07
5	sale	2	153.00	cash	2026-02-11	2026-02-11 13:18:06
6	sale	3	14.00	card	2026-02-11	2026-02-11 13:22:02
7	sale	4	850.00	cash	2026-02-11	2026-02-12 03:24:08
8	sale	5	120.00	cash	2026-02-11	2026-02-12 03:26:10
9	sale	6	390.00	cash	2026-02-11	2026-02-12 03:42:04
10	sale	8	120.00	cash	2026-02-11	2026-02-12 04:32:03

≡ƒôï products 22 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
name	`varchar(255)`	NO		NULL
slug	`varchar(255)`	NO	UNIQUE	NULL
sku	`varchar(100)`	NO	UNIQUE	NULL
barcode_symbology	`enum('C128','C39','EAN13','EAN8')`	YES		C128
description	`text`	YES		NULL
image	`varchar(255)`	YES		NULL
category_id	`int(10) unsigned`	YES	FOREIGN	NULL
supplier_id	`int(10) unsigned`	YES	FOREIGN	NULL
unit_id	`int(10) unsigned`	YES	FOREIGN	NULL
cost_price	`decimal(12,2)`	YES		0.00
selling_price	`decimal(12,2)`	YES		0.00
stock_quantity	`int(11)`	YES	FOREIGN	0
alert_quantity	`int(11)`	YES		10
gallery	`longtext`	YES		NULL
is_active	`tinyint(1)`	YES		1
created_at	`timestamp`	NO		current_timestamp()
updated_at	`timestamp`	NO		current_timestamp()	on update current_timestamp()
commission_rate	`decimal(10,2)`	YES		0.00
commission_type	`enum('percentage','fixed')`	YES		percentage

Indexes:

slug: slug
sku: sku
unit_id: unit_id
idx_sku: sku
idx_stock: stock_quantity
idx_category: category_id
idx_supplier: supplier_id

≡ƒöù Foreign Key Relationships:

category_id ΓåÆ references categories.id
unit_id ΓåÆ references units.id

Sample Data (First 10 rows):

id	name	slug	sku	barcode_symbology	description	image	category_id	supplier_id	unit_id	cost_price	selling_price	alert_quantity	gallery	created_at	updated_at	commission_type
1	Samsung Galaxy S23	samsung-galaxy-s23	SAM-A1B2C3	C128	Latest Samsung smartphone with 256GB storage	NULL	NULL	NULL	1	65000.00	75000.00	5	NULL	2026-02-07 20:02:16	2026-02-10 16:46:50	percentage
2	iPhone 14 Pro	iphone-14-pro	IPH-D4E5F6	C128	Apple iPhone 14 Pro with 256GB	NULL	NULL	NULL	1	95000.00	110000.00	5	NULL	2026-02-07 20:02:16	2026-02-10 16:46:50	percentage
3	Sony Headphones WH-1000XM5	sony-headphones-wh-1000xm5	SON-G7H8I9	C128	Premium noise-cancelling headphones	NULL	NULL	NULL	1	22000.00	28000.00	10	NULL	2026-02-07 20:02:16	2026-02-10 16:46:50	percentage
4	Nike Air Max	nike-air-max	NIK-J1K2L3	EAN13	Running shoes - Size 42	NULL	NULL	NULL	1	4500.00	6500.00	15	NULL	2026-02-07 20:02:16	2026-02-10 16:46:50	percentage
5	Adidas T-Shirt	adidas-t-shirt	ADI-M4N5O6	C39	Cotton sports t-shirt	NULL	NULL	NULL	1	800.00	1200.00	10	NULL	2026-02-07 20:02:16	2026-02-10 16:46:50	percentage
6	Coffee Beans Premium	coffee-beans-premium	COF-P7Q8R9	C128	Arabica coffee beans	NULL	NULL	NULL	2	1200.00	1800.00	10	NULL	2026-02-07 20:02:16	2026-02-10 16:46:50	percentage
7	Organic Green Tea	organic-green-tea	TEA-S1T2U3	C128	Premium green tea leaves	NULL	NULL	NULL	4	500.00	750.00	15	NULL	2026-02-07 20:02:16	2026-02-10 16:46:50	percentage
8	Garden Shovel	garden-shovel	GAR-V4W5X6	C39	Heavy-duty gardening shovel	NULL	NULL	NULL	1	350.00	550.00	5	NULL	2026-02-07 20:02:16	2026-02-10 16:46:50	percentage
9	LED Light Bulb	led-light-bulb	LED-Y7Z8A9	EAN8	12W energy-saving bulb	NULL	NULL	NULL	1	150.00	250.00	20	NULL	2026-02-07 20:02:16	2026-02-10 16:46:50	percentage
10	Yoga Mat	yoga-mat	YOG-B1C2D3	C128	Non-slip exercise mat	NULL	NULL	NULL	1	800.00	1200.00	10	NULL	2026-02-07 20:02:16	2026-02-10 16:46:50	percentage

≡ƒôï purchase_items 2 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
purchase_id	`int(10) unsigned`	NO	FOREIGN	NULL
product_id	`int(10) unsigned`	NO	FOREIGN	NULL
quantity	`int(11)`	NO		NULL
unit_cost	`decimal(12,2)`	NO		NULL
subtotal	`decimal(12,2)`	NO		NULL

Indexes:

product_id: product_id
idx_purchase: purchase_id

≡ƒöù Foreign Key Relationships:

purchase_id ΓåÆ references purchases.id
product_id ΓåÆ references products.id

Sample Data (First 10 rows):

id	purchase_id	product_id	quantity	unit_cost	subtotal
2	4	22	50	100.00	5000.00
3	5	22	10	100.00	1000.00

≡ƒôï purchases 2 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
reference_no	`varchar(50)`	NO	UNIQUE	NULL
supplier_id	`int(10) unsigned`	YES	FOREIGN	NULL
purchase_date	`date`	NO	FOREIGN	NULL
total_amount	`decimal(12,2)`	NO		NULL
paid_amount	`decimal(12,2)`	YES		0.00
agent_commission_percent	`decimal(5,2)`	YES		0.00
agent_commission_amount	`decimal(10,2)`	YES		0.00
status	`enum('received','pending','canceled')`	YES	FOREIGN	received
created_at	`timestamp`	NO		current_timestamp()

Indexes:

reference_no: reference_no
supplier_id: supplier_id
idx_date: purchase_date
idx_status: status

≡ƒöù Foreign Key Relationships:

supplier_id ΓåÆ references contacts.id

Sample Data (First 10 rows):

id	reference_no	supplier_id	purchase_date	total_amount	paid_amount	agent_commission_percent	agent_commission_amount	status	created_at
4	PO-20260210-1428	21	0000-00-00	5000.00	5000.00	0.00	0.00	received	2026-02-10 17:08:45
5	PO-20260210-8842	21	0000-00-00	1000.00	0.00	0.00	0.00	received	2026-02-10 17:19:18

≡ƒôï sale_items 9 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
sale_id	`int(10) unsigned`	NO	FOREIGN	NULL
product_id	`int(10) unsigned`	NO	FOREIGN	NULL
quantity	`int(11)`	NO		NULL
unit_price	`decimal(12,2)`	NO		NULL
subtotal	`decimal(12,2)`	NO		NULL
discount_type	`enum('percentage','fixed')`	YES		fixed
discount_value	`decimal(12,2)`	YES		0.00
discount_amount	`decimal(12,2)`	YES		0.00
commission_amount	`decimal(10,2)`	YES		0.00

Indexes:

product_id: product_id
idx_sale: sale_id

≡ƒöù Foreign Key Relationships:

sale_id ΓåÆ references sales.id
product_id ΓåÆ references products.id

Sample Data (First 10 rows):

id	sale_id	product_id	quantity	unit_price	subtotal	discount_type	discount_value	discount_amount	commission_amount
1	1	22	3	120.00	360.00	fixed	0.00	0.00	18.00
2	2	22	2	120.00	220.00	fixed	10.00	20.00	11.00
3	3	22	3	120.00	360.00	fixed	0.00	0.00	18.00
4	4	23	1	130.00	130.00	fixed	0.00	0.00	0.00
5	4	22	6	120.00	720.00	fixed	0.00	0.00	36.00
6	5	22	1	120.00	120.00	fixed	0.00	0.00	6.00
7	6	23	3	130.00	390.00	fixed	0.00	0.00	0.00
8	7	23	1	130.00	130.00	fixed	0.00	0.00	0.00
9	8	22	1	120.00	120.00	fixed	0.00	0.00	6.00

≡ƒôï sale_return_items 0 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
return_id	`int(10) unsigned`	NO	FOREIGN	NULL
product_id	`int(10) unsigned`	NO	FOREIGN	NULL
quantity	`int(11)`	NO		NULL
unit_price	`decimal(12,2)`	YES		NULL
subtotal	`decimal(12,2)`	YES		NULL

Indexes:

return_id: return_id
product_id: product_id

≡ƒöù Foreign Key Relationships:

return_id ΓåÆ references sale_returns.id
product_id ΓåÆ references products.id

ΓÜá∩╕Å No data in this table

≡ƒôï sale_returns 0 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
sale_id	`int(10) unsigned`	NO	FOREIGN	NULL
return_date	`date`	NO		NULL
total_amount	`decimal(12,2)`	YES		NULL
refund_amount	`decimal(12,2)`	YES		NULL
status	`enum('pending','completed','rejected')`	YES	FOREIGN	pending
reason	`text`	YES		NULL
created_by	`int(10) unsigned`	YES	FOREIGN	NULL
created_at	`timestamp`	NO		current_timestamp()

Indexes:

created_by: created_by
idx_sale: sale_id
idx_status: status

≡ƒöù Foreign Key Relationships:

sale_id ΓåÆ references sales.id
created_by ΓåÆ references users.id

ΓÜá∩╕Å No data in this table

≡ƒôï sales 8 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
reference_no	`varchar(50)`	NO	UNIQUE	NULL
customer_id	`int(10) unsigned`	YES	FOREIGN	NULL
sale_date	`date`	NO	FOREIGN	NULL
total_amount	`decimal(12,2)`	NO		NULL
tax_amount	`decimal(12,2)`	YES		0.00
discount_amount	`decimal(12,2)`	YES		0.00
paid_amount	`decimal(12,2)`	YES		0.00
staff_commission_percent	`decimal(5,2)`	YES		0.00
staff_commission_amount	`decimal(10,2)`	YES		0.00
status	`enum('completed','pending','canceled')`	YES	FOREIGN	completed
created_by	`int(10) unsigned`	YES	FOREIGN	NULL
created_at	`timestamp`	NO		current_timestamp()

Indexes:

reference_no: reference_no
customer_id: customer_id
created_by: created_by
idx_date: sale_date
idx_status: status
idx_reference: reference_no

≡ƒöù Foreign Key Relationships:

customer_id ΓåÆ references contacts.id
created_by ΓåÆ references users.id

Sample Data (First 10 rows):

id	reference_no	customer_id	sale_date	total_amount	tax_amount	paid_amount	status	created_by	created_at
1	INV-20260210-0D1E96	NULL	2026-02-10	414.00	54.00	14.00	completed	1	2026-02-10 17:10:08
2	INV-20260211-E14A8C	NULL	2026-02-11	253.00	33.00	153.00	completed	1	2026-02-11 13:18:06
3	INV-20260211-ADB489	22	2026-02-11	414.00	54.00	14.00	completed	1	2026-02-11 13:22:02
4	INV-20260211-8CA7C0	22	2026-02-11	850.00	0.00	850.00	completed	3	2026-02-12 03:24:08
5	INV-20260211-27FB47	NULL	2026-02-11	120.00	0.00	120.00	completed	3	2026-02-12 03:26:10
6	INV-20260211-C70A78	NULL	2026-02-11	390.00	0.00	390.00	completed	3	2026-02-12 03:42:04
7	INV-20260211-E0C308	22	2026-02-11	130.00	0.00	0.00	completed	3	2026-02-12 03:42:38
8	INV-20260211-34402F	NULL	2026-02-11	120.00	0.00	120.00	completed	3	2026-02-12 04:32:03

≡ƒôï settings 17 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
setting_key	`varchar(50)`	NO	UNIQUE	NULL
setting_value	`text`	YES		NULL
setting_type	`enum('text','number','boolean','json')`	YES		text
category	`varchar(50)`	YES		general
updated_by	`int(11)`	YES		NULL
created_at	`timestamp`	NO		current_timestamp()
updated_at	`timestamp`	NO		current_timestamp()	on update current_timestamp()

Indexes:

setting_key: setting_key

Sample Data (First 10 rows):

id	setting_key	setting_value	setting_type	category	updated_by	created_at	updated_at
1	company_name	FOrbit' Shop	text	general	1	2026-02-08 17:07:02	2026-02-10 13:07:15
2	company_email	admin@example.com	text	general	1	2026-02-08 17:07:02	2026-02-10 13:07:15
3	company_phone	01700000000	text	general	1	2026-02-08 17:07:02	2026-02-10 13:07:15
4	company_address	Dhaka, Bangladesh	text	general	1	2026-02-08 17:07:02	2026-02-10 13:07:15
5	currency_symbol	αº│	text	general	1	2026-02-08 17:07:02	2026-02-11 18:32:58
6	timezone	Asia/Dhaka	text	general	1	2026-02-08 17:07:02	2026-02-11 18:32:58
25	tax_id		text	general	1	2026-02-08 17:11:46	2026-02-11 18:32:58
26	default_tax_rate	0	text	general	1	2026-02-08 17:11:46	2026-02-11 18:32:58
35	company_tagline	Smart Business Management System	text	company	1	2026-02-10 11:56:55	2026-02-10 13:07:15
36	company_website	www.forbitpos.com	text	company	1	2026-02-10 11:56:55	2026-02-10 13:07:15

≡ƒôï stock_movements 33 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
product_id	`int(10) unsigned`	NO	FOREIGN	NULL
type	`enum('sale','purchase','return','adjustment')`	NO	FOREIGN	NULL
quantity	`int(11)`	NO		NULL
reference_type	`varchar(100)`	YES		NULL
reference_id	`int(10) unsigned`	YES		NULL
description	`varchar(255)`	YES		NULL
created_at	`timestamp`	NO		current_timestamp()

Indexes:

idx_product: product_id
idx_type: type

≡ƒöù Foreign Key Relationships:

product_id ΓåÆ references products.id

Sample Data (First 10 rows):

id	product_id	type	quantity	reference_type	reference_id	description	created_at
4	16	adjustment	12	NULL	NULL	gsfg	2026-02-08 17:04:12
5	16	adjustment	6	sale_delete	15	Stock restored from deleted sale	2026-02-09 15:17:02
6	6	adjustment	1	sale_delete	15	Stock restored from deleted sale	2026-02-09 15:17:02
7	5	adjustment	4	sale_delete	14	Stock restored from deleted sale	2026-02-09 15:17:11
8	5	adjustment	1	sale_delete	13	Stock restored from deleted sale	2026-02-09 15:17:12
9	13	adjustment	5	sale_delete	12	Stock restored from deleted sale	2026-02-09 15:17:14
10	13	adjustment	3	sale_delete	11	Stock restored from deleted sale	2026-02-09 15:17:16
11	13	adjustment	1	sale_delete	10	Stock restored from deleted sale	2026-02-09 15:17:18
12	13	adjustment	1	sale_delete	9	Stock restored from deleted sale	2026-02-09 15:17:19
13	13	adjustment	1	sale_delete	8	Stock restored from deleted sale	2026-02-09 15:17:20

≡ƒôï tax_settings 1 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
tax_name	`varchar(50)`	NO		NULL
tax_rate	`decimal(5,2)`	YES		0.00
is_active	`tinyint(1)`	YES		1
is_default	`tinyint(1)`	YES		0
created_at	`timestamp`	NO		current_timestamp()

Sample Data (First 10 rows):

id	tax_name	tax_rate	is_active	is_default	created_at
1	VAT	15.00	1	1	2026-02-08 17:07:02

≡ƒôï units 5 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
name	`varchar(100)`	NO		NULL
short_name	`varchar(20)`	YES		NULL

Sample Data (First 10 rows):

id	name	short_name
1	Piece	pc
2	Kilogram	kg
3	Liter	L
4	Box	box
5	Dozen	dz

≡ƒôï users 3 rows

Table Structure:

Field	Type	Null	Key	Default	Extra
id	`int(10) unsigned`	NO	PRIMARY	NULL	auto_increment
name	`varchar(255)`	NO		NULL
email	`varchar(255)`	NO	UNIQUE	NULL
password	`varchar(255)`	NO		NULL
role	`enum('admin','manager','cashier','staff')`	YES	FOREIGN	staff
image	`varchar(255)`	YES		NULL
is_active	`tinyint(1)`	YES		1
created_at	`timestamp`	NO		current_timestamp()
updated_at	`timestamp`	NO		current_timestamp()	on update current_timestamp()

Indexes:

email: email
idx_email: email
idx_role: role

Sample Data (First 10 rows):

id	name	email	password	role	image	is_active	created_at	updated_at
1	Admin User	admin@example.com	$2y$10$QP1bLuQDbvwhU1v.D.7yZusBdP2XaDeKeuzUamDeSsXMy/F9OhvPO	admin	assets/uploads/users/698d005d37e16_a3cd04fe.jpg	1	2026-02-07 20:02:16	2026-02-12 04:19:09
2	Manager User	manager@example.com	$2y$10$hLVdUFOBCDuw8b9fyIGDbuBujOsayf1TbySu1hQKG1KMv15qAjSmG	manager	NULL	1	2026-02-07 20:02:16	2026-02-07 20:08:01
3	Cashier User	cashier@example.com	$2y$10$WIq6yqDfwQHOHDqVAORhxuhp/mT0lXmzL.fD2otJ4l69COvR0Pn1G	staff	assets/uploads/users/698d02d6a2c17_bf347914.jpg	1	2026-02-07 20:02:16	2026-02-12 04:29:42

Generated by Database Export Script | Stan2CD Project

Note: αªÅαªç output αªƒαª╛ copy αªòαª░αºç αªåαª«αª╛αªòαºç αªªαª┐αª¿, αªñαª╛αª╣αª▓αºç αªåαª«αª┐ αªåαª¬αª¿αª╛αª░ complete database αª¼αºüαª¥αªñαºç αª¬αª╛αª░αª¼