| id |
int(11)
|
|
|
|
| sku |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| model |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| category_id |
int(11)
|
|
|
|
| brand |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| supplier |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| manufacturer_part_no |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| name_tw |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| name_en |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| name_cn |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| description_tw |
text
|
utf8mb4_general_ci
|
|
|
| description_en |
text
|
utf8mb4_general_ci
|
|
|
| description_cn |
text
|
utf8mb4_general_ci
|
|
|
| spec_tw |
text
|
utf8mb4_general_ci
|
|
|
| spec_en |
text
|
utf8mb4_general_ci
|
|
|
| spec_cn |
text
|
utf8mb4_general_ci
|
|
|
| unit |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| currency |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| sale_price |
decimal(15,2)
|
|
|
|
| cost_price |
decimal(15,2)
|
|
|
|
| stock_qty |
int(11)
|
|
|
|
| safety_stock |
int(11)
|
|
|
|
| lead_time_days |
int(11)
|
|
|
|
| status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| item_type |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| image_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| catalog_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| remark |
text
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
