|
id
|
int(11)
|
|
|
|
|
code
|
varchar(50)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
unit
|
int(11)
|
|
|
|
|
cost
|
decimal(25,4)
|
|
|
|
|
price
|
decimal(25,4)
|
|
|
|
|
alert_quantity
|
decimal(15,4)
|
|
|
20.0000
|
|
image
|
varchar(255)
|
|
|
no_image.png
|
|
category_id
|
int(11)
|
|
|
|
|
subcategory_id
|
int(11)
|
|
|
|
|
cf1
|
varchar(255)
|
|
|
|
|
cf2
|
varchar(255)
|
|
|
|
|
cf3
|
varchar(255)
|
|
|
|
|
cf4
|
varchar(255)
|
|
|
|
|
cf5
|
varchar(255)
|
|
|
|
|
cf6
|
varchar(255)
|
|
|
|
|
quantity
|
decimal(15,4)
|
|
|
0.0000
|
|
tax_rate
|
int(11)
|
|
|
|
|
track_quantity
|
tinyint(1)
|
|
|
1
|
|
details
|
varchar(1000)
|
|
|
|
|
warehouse
|
int(11)
|
|
|
|
|
barcode_symbology
|
varchar(55)
|
|
|
code128
|
|
file
|
varchar(100)
|
|
|
|
|
product_details
|
text
|
|
|
|
|
tax_method
|
tinyint(1)
|
|
|
0
|
|
type
|
varchar(55)
|
|
|
standard
|
|
supplier1
|
int(11)
|
|
|
|
|
supplier1price
|
decimal(25,4)
|
|
|
|
|
supplier2
|
int(11)
|
|
|
|
|
supplier2price
|
decimal(25,4)
|
|
|
|
|
supplier3
|
int(11)
|
|
|
|
|
supplier3price
|
decimal(25,4)
|
|
|
|
|
supplier4
|
int(11)
|
|
|
|
|
supplier4price
|
decimal(25,4)
|
|
|
|
|
supplier5
|
int(11)
|
|
|
|
|
supplier5price
|
decimal(25,4)
|
|
|
|
|
promotion
|
tinyint(1)
|
|
|
0
|
|
promo_price
|
decimal(25,4)
|
|
|
|
|
start_date
|
date
|
|
|
|
|
end_date
|
date
|
|
|
|
|
supplier1_part_no
|
varchar(50)
|
|
|
|
|
supplier2_part_no
|
varchar(50)
|
|
|
|
|
supplier3_part_no
|
varchar(50)
|
|
|
|
|
supplier4_part_no
|
varchar(50)
|
|
|
|
|
supplier5_part_no
|
varchar(50)
|
|
|
|
|
sale_unit
|
int(11)
|
|
|
|
|
purchase_unit
|
int(11)
|
|
|
|
|
brand
|
int(11)
|
|
|
|
|
slug
|
varchar(55)
|
|
|
|
|
featured
|
tinyint(1)
|
|
|
|
|
weight
|
decimal(10,4)
|
|
|
|
|
hsn_code
|
int(11)
|
|
|
|
|
views
|
int(11)
|
|
|
0
|
|
hide
|
tinyint(1)
|
|
|
0
|
|
second_name
|
varchar(255)
|
|
|
|
|
hide_pos
|
tinyint(1)
|
|
|
0
|