| id |
int(11)
|
|
|
|
| vendor_id |
int(11)
|
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| long_description |
text
|
utf8mb4_general_ci
|
|
|
| rate |
decimal(15,2)
|
|
|
|
| tax |
int(11)
|
|
|
|
| tax2 |
int(11)
|
|
|
|
| unit |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| group_id |
int(11)
|
|
|
|
| commodity_code |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| commodity_barcode |
text
|
utf8mb4_general_ci
|
|
|
| unit_id |
int(11)
|
|
|
|
| sku_code |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| sku_name |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| sub_group |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| active |
int(11)
|
|
|
|
| parent |
int(11)
|
|
|
|
| attributes |
longtext
|
utf8mb4_general_ci
|
|
|
| parent_attributes |
longtext
|
utf8mb4_general_ci
|
|
|
| commodity_type |
int(11)
|
|
|
|
| origin |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| commodity_name |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| series_id |
text
|
utf8mb4_general_ci
|
|
|
| long_descriptions |
longtext
|
utf8mb4_general_ci
|
|
|
| share_status |
int(1)
|
|
|
|