| id |
int(11)
|
|
|
|
| code |
varchar(50)
|
utf8_general_ci
|
|
|
| name |
varchar(255)
|
utf8_general_ci
|
|
|
| unit |
int(11)
|
|
|
|
| cost |
decimal(25,4)
|
|
|
|
| price |
decimal(25,4)
|
|
|
|
| alert_quantity |
decimal(15,4)
|
|
|
|
| image |
varchar(255)
|
utf8_general_ci
|
|
|
| category_id |
int(11)
|
|
|
|
| subcategory_id |
int(11)
|
|
|
|
| cf1 |
varchar(255)
|
utf8_general_ci
|
|
|
| cf2 |
varchar(255)
|
utf8_general_ci
|
|
|
| cf3 |
varchar(255)
|
utf8_general_ci
|
|
|
| cf4 |
varchar(255)
|
utf8_general_ci
|
|
|
| cf5 |
varchar(255)
|
utf8_general_ci
|
|
|
| cf6 |
varchar(255)
|
utf8_general_ci
|
|
|
| quantity |
decimal(15,4)
|
|
|
|
| tax_rate |
int(11)
|
|
|
|
| track_quantity |
tinyint(1)
|
|
|
|
| details |
varchar(1000)
|
utf8_general_ci
|
|
|
| warehouse |
int(11)
|
|
|
|
| barcode_symbology |
varchar(55)
|
utf8_general_ci
|
|
|
| file |
varchar(100)
|
utf8_general_ci
|
|
|
| product_details |
text
|
utf8_general_ci
|
|
|
| tax_method |
tinyint(1)
|
|
|
|
| type |
varchar(55)
|
utf8_general_ci
|
|
|
| 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)
|
|
|
|
| promo_price |
decimal(25,4)
|
|
|
|
| start_date |
date
|
|
|
|
| end_date |
date
|
|
|
|
| supplier1_part_no |
varchar(50)
|
utf8_general_ci
|
|
|
| supplier2_part_no |
varchar(50)
|
utf8_general_ci
|
|
|
| supplier3_part_no |
varchar(50)
|
utf8_general_ci
|
|
|
| supplier4_part_no |
varchar(50)
|
utf8_general_ci
|
|
|
| supplier5_part_no |
varchar(50)
|
utf8_general_ci
|
|
|
| sale_unit |
int(11)
|
|
|
|
| purchase_unit |
int(11)
|
|
|
|
| brand |
int(11)
|
|
|
|
| slug |
varchar(55)
|
utf8_general_ci
|
|
|
| featured |
tinyint(1)
|
|
|
|
| weight |
decimal(10,4)
|
|
|
|
| hsn_code |
int(11)
|
|
|
|
| views |
int(11)
|
|
|
|
| hide |
tinyint(1)
|
|
|
|
| second_name |
varchar(255)
|
utf8_general_ci
|
|
|
| hide_pos |
tinyint(1)
|
|
|
|
