| id |
int(11)
|
|
|
|
| description |
longtext
|
utf8mb4_unicode_ci
|
|
|
| long_description |
mediumtext
|
utf8mb4_unicode_ci
|
|
|
| rate |
decimal(15,2)
|
|
|
|
| tax |
int(11)
|
|
|
|
| tax2 |
int(11)
|
|
|
|
| unit |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| group_id |
int(11)
|
|
|
|
| commodity_code |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| commodity_barcode |
text
|
utf8mb4_unicode_ci
|
|
|
| unit_id |
int(11)
|
|
|
|
| sku_code |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| sku_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| purchase_price |
decimal(15,2)
|
|
|
|
| can_be_sold |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| can_be_purchased |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| can_be_manufacturing |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| can_be_inventory |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| sub_group |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| active |
int(11)
|
|
|
|
| parent_id |
int(11)
|
|
|
|
| attributes |
longtext
|
utf8mb4_unicode_ci
|
|
|
| parent_attributes |
longtext
|
utf8mb4_unicode_ci
|
|
|
| from_vendor_item |
int(11)
|
|
|
|
| guarantee |
text
|
utf8mb4_unicode_ci
|
|
|
| profif_ratio |
text
|
utf8mb4_unicode_ci
|
|
|
| long_descriptions |
longtext
|
utf8mb4_unicode_ci
|
|
|
| without_checking_warehouse |
int(11)
|
|
|
|
| series_id |
text
|
utf8mb4_unicode_ci
|
|
|
| warehouse_id |
int(11)
|
|
|
|
| origin |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| color_id |
int(11)
|
|
|
|
| style_id |
int(11)
|
|
|
|
| model_id |
int(11)
|
|
|
|
| size_id |
int(11)
|
|
|
|
| commodity_type |
int(11)
|
|
|
|
| commodity_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| color |
text
|
utf8mb4_unicode_ci
|
|
|