warehouse

page_permissions

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
user_id int(11) No
page varchar(255) No
can_access tinyint(1) No 0

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid22ANo

set_date

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
bill_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tbl_admin

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(12) No
type tinyint(4) No
user_name varchar(64) No
pword varchar(100) No
name varchar(100) No
email varchar(64) No
phone varchar(20) No
address varchar(256) No
time_stamp timestamp No current_timestamp()
status tinyint(4) No
post_date datetime No current_timestamp()
post_time time No current_timestamp()
last_updated varchar(36) No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid4ANo

tbl_daily_cash

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
description varchar(500) No
dr decimal(10,2) No
cr decimal(10,2) No
balance decimal(10,2) No
month varchar(2) No
year varchar(4) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tmp_supplier_demand

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
item_id int(11) No
unit_id int(11) No
cat_id int(11) No
qty decimal(10,2) No
note varchar(500) No
supplier_id int(11) No
cell bigint(20) No
cr int(11) No
status tinyint(4) No
post_date date Yes curdate()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tmp_warehousepay

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(20) No
invoice int(11) No
items_amount int(11) No
gst int(11) No
delivery_charges decimal(10,2) No
total_cost decimal(10,2) No
return_cost decimal(10,2) No
payable int(11) No
paid int(11) No
balance int(11) No
pay int(11) No
demand_supplier_id int(11) No
purchased_supplier_id int(11) No
payment_method_id int(11) No
post_date date No current_timestamp()
post_time time No current_timestamp()
bill_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tmp_warehousepurchased

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
invoice int(11) No
items_amount int(11) No
gst int(11) No
delivery_charges decimal(10,2) No
total_cost decimal(10,2) No
return_cost decimal(10,2) No
payable int(11) No
paid int(11) No
balance int(11) No
demand_supplier_id int(11) No
purchased_supplier_id int(11) No
payment_method_id int(11) No
Logo blob No
post_date date No current_timestamp()
post_time time No current_timestamp()
bill_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tmp_warehousepurchaserclosing

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(20) No
invoice int(11) No
items_amount int(11) No
gst int(11) No
delivery_charges decimal(10,2) No
total_cost decimal(10,2) No
return_cost int(11) No
total_cash int(11) No
paid_exp int(11) No
payable int(11) No
paid int(11) No
balance int(11) No
pay int(11) No
pending_bills int(50) No
demand_supplier_id int(11) No
purchased_supplier_id int(11) No
payment_method_id int(11) No
remarks varchar(300) No
post_date date No current_timestamp()
post_time time No current_timestamp()
bill_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tmp_warehousereceive

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(20) No
invoice int(11) No
items_amount int(11) No
gst int(11) No
delivery_charges decimal(10,2) No
total_cost decimal(10,2) No
return_cost decimal(10,2) No
payable int(11) No
paid int(11) No
balance int(11) No
pay int(11) No
branch_id int(11) No
payment_method_id int(11) No
post_date date No current_timestamp()
post_time time No current_timestamp()
bill_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tmp_warehousesell

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(20) No
invoice int(11) No
items_amount int(11) No
gst int(11) No
delivery_charges decimal(10,2) No
total_cost decimal(10,2) No
return_cost decimal(10,2) No
payable int(11) No
paid int(11) No
balance int(11) No
branch_id int(11) No
payment_method_id int(11) No
post_date date No current_timestamp()
post_time time No current_timestamp()
bill_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tmp_warehousestockin

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(200) No
invoice int(11) No
item_id int(11) No
pack_qty decimal(11,2) No
total_pack decimal(11,2) No
qty decimal(11,3) No
unit_cost decimal(10,2) No
total_cost decimal(10,2) No
return_qty decimal(11,2) No
return_cost decimal(10,2) No
wastage decimal(11,2) No
unit_id int(11) No
cat_id int(11) No
post_date date No current_timestamp()
stockin_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tmp_warehousestockout

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(200) No
invoice int(11) No
item_id int(11) No
pack_qty decimal(11,3) No
total_pack decimal(11,2) No
qty decimal(11,3) No
unit_cost decimal(10,2) No
total_cost decimal(10,2) No
return_qty decimal(11,2) No
branch_id int(11) No
merge_recipe_id int(11) No
unit_id int(11) No
cat_id int(11) No
post_date date No current_timestamp()
stockin_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

warehousebank

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title text No
post_date datetime No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid23ANo

warehousebranches

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title text No
address text No
post_date datetime No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid3ANo

warehouseitems

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(20) No
title varchar(500) No
unit_id int(11) No
mini int(11) No
new_order int(11) No
opening_stock decimal(11,3) No
balance_stock decimal(11,3) No
unit_cost decimal(10,3) No
supplier_id int(11) No
suppliers_cat_id int(11) No
post_date timestamp No current_timestamp()
Remark varchar(500) No
image_path blob No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid251ANo
titleBTREENoNotitle251ANo

warehouseitemsunites

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title text No
post_date datetime No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid4ANo

warehousepaymentmethod

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title text No
post_date datetime No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid4ANo

warehouseproducts

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title text No
p_categories int(10) No
total_order int(10) No
sell_price int(11) No
post_date datetime No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

warehouseproductscategories

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title text No
post_date datetime No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

warehouseproductsrecipe

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
recipe_id int(11) No
item_id int(11) No
item_qty decimal(11,3) No
merge_recipe_id int(11) No
procedure_notes text No
post_date date No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

warehousepurchased

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(20) No
invoice int(11) No
items_amount int(11) No
gst int(11) No
delivery_charges decimal(10,2) No
total_cost decimal(10,2) No
return_cost decimal(10,2) No
payable int(11) No
paid int(11) No
balance int(11) No
demand_supplier_id int(11) No
purchased_supplier_id int(11) No
payment_method_id int(11) No
Logo blob No
post_date date No current_timestamp()
post_time time No current_timestamp()
bill_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

warehousepurchaserclosing

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(20) No
invoice int(11) No
items_amount int(11) No
gst int(11) No
delivery_charges decimal(10,2) No
total_cost decimal(10,2) No
return_cost decimal(10,2) No
total_cash int(11) No
paid_exp int(11) No
payable int(11) No
paid int(11) No
balance int(11) No
pay int(11) No
pending_bills int(50) No
demand_supplier_id int(11) No
purchased_supplier_id int(11) No
payment_method_id int(11) No
remarks varchar(300) No
post_date date No current_timestamp()
post_time time No current_timestamp()
bill_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

warehousesell

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(20) No
invoice int(11) No
items_amount int(11) No
gst int(11) No
delivery_charges decimal(10,2) No
total_cost decimal(10,2) No
return_cost decimal(10,2) No
payable int(11) No
paid int(11) No
balance int(11) No
branch_id int(11) No
payment_method_id int(11) No
post_date date No current_timestamp()
post_time time No current_timestamp()
bill_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid12ANo

warehousestockin

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(20) No
invoice int(11) No
item_id int(11) No
qty decimal(11,2) No
unit_cost decimal(10,2) No
total_cost decimal(10,2) No
return_qty decimal(11,2) No
return_cost decimal(10,2) No
wastage decimal(11,2) No
unit_id int(11) No
cat_id int(11) No
post_date date No current_timestamp()
stockin_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid17ANo

warehousestockout

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(20) No
invoice int(11) No
item_id int(11) No
qty decimal(11,2) No
total_pack decimal(11,2) No
unit_cost decimal(10,2) No
total_cost decimal(10,2) No
return_qty decimal(11,2) No
return_cost decimal(10,2) No
branch_id int(11) No
unit_id int(11) No
cat_id int(11) No
merge_recipe_id int(11) No
post_date date No current_timestamp()
stockin_date date No
paid_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid41ANo

warehousesuppliers

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title varchar(255) No
supplier_cat_id int(11) No
c_limit int(200) No
fbr_name varchar(255) No
ntn int(11) No
bank_id int(11) No
bank_title_name varchar(255) No
account_number varchar(20) No
phone_number bigint(20) No
address varchar(235) No
post_date datetime No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid24ANo
titleBTREENoNotitle24ANo
title_2BTREENoNotitle24ANo

warehousesupplierscategories

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title text No
status varchar(11) No
post_date datetime No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid16ANo